mtl_cross_references
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.