My Oracle Support Banner

What Is The Proper API Call To Import Asset Genealogy In MTL_OBJECT_GENEALOGY_INTERFACE? (Doc ID 1626483.1)

Last updated on JULY 24, 2020

Applies to:

Oracle Enterprise Asset Management - Version 12.1.1 and later
Information in this document applies to any platform.


I need to be able to perform asset genealogy changes from an external system into Oracle EAM. I am able to insert records into MTL_OBJECT_GENEALOGY_INTERFACE and then manually kick off the import process via the Interfaces: Import Asset Genealogy choice in the EAM responsibility.

In the case of other open interface integrations, we've scheduled the import requests via Oracle forms and this generally works fine because it can be run without parameters. The Import Asset Genealogy requires the Batch Id as a parameter and since that changes with every set of interface records, we cannot schedule this in the same way.

Is there a public API either via PL/SQL or a web service to programatically kick off the same Import Asset Genealogy process?

I have found the EAM_GENEALOGY_IMPORT_PUB.import_genealogy(errbuf, retcode, p_interface_group_id), but that appears to have requirements that are in conflict with doing the import via Import Asset Genealogy. Namely, it only operates on interface records with PROCESS_STATUS = 'R' and it requires a group_id whereas the Import Asset Genealogy operates on PROCESS_STATUS = 'P' and will not run if group_id is set.

I also examined INV_GENEALOGY_PUB.insert_genalogy, but had no luck with that API either. When an exception was thrown, I got an error that a SAVEPOINT had not been established. That SAVEPOINT appears to be created in another call (insert_flow_genealogy) that isn't accessed by calling insert_genealogy.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.