Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

mtl_cross_references

edited Sep 22, 2015 10:02AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 4 commentsAnswered

Hi,

  I have a requirement to insert into mtl_cross_references when an item is created. I am using an AFTER INSERT trigger to call a procedure that in turn calls the API MTL_CROSS_REFERENCES_PUB.Process_XRef to create the cross reference. But I get an error "Cannot find an item master record for this item". Does the item does not exist in the database when the AFTER INSERT trigger is executed ? Below is my trigger code. In the XXX_ASSIGN_UPC_PRC I am calling the API. What is the best way to create a cross reference when an item is created ? Any help is appreciated.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center