Parent Serial Number Link is Found in MTL_OBJECT_GENEALOGY

(Doc ID 1293314.1)

Last updated on NOVEMBER 12, 2016

Applies to:

Oracle Enterprise Asset Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance 07-Jun-2015***

Goal

Assigned a parent asset number to a newly created asset number.
When queering the MTL_SERIAL_NUMBER for the newly created asset, the fields PARENT_SERIAL_NUMBER and PARENT_ITEM_ID are empty in the table.

Is this intended behavior, and the link is maintained in another table?


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms