Update_items_and_sourcing Returned Unexpected Error
(Doc ID 1669935.1)
Last updated on FEBRUARY 03, 2019
Oracle Configure to Order - Version 12.1.3 and later Information in this document applies to any platform.
On : 12.1.3 version, Configuration Process
When attempting to run 'Update Existing Configurations' program, When running update existing configurations process fails with an error 'Update_items_and_sourcing returned unexpected error'.
the following error occurs.
ERROR ----------------------- ... Inserted rows into mtl_secondary_locators:: 0 ERROR:Others error in update_item_data170ORA-00001: unique constraint (INV.MTL_CROSS_REFERENCES_U1) violated LEAVING OE_MSG_PUB.COUNT_AND_GET 0 Update_Item_Data returned with unexpected error ERROR: Unxpected error in Update_Items_and_Sourcing::lStmtNum::::User-Defined Exception LEAVING OE_MSG_PUB.COUNT_AND_GET 0
STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Submit 'Update Existing Configurations' program enter parameters : Items: All Models Has sourcing changed: No Process non-matchable models: Yes Upgrade Mode: Update Items
We have applied Patch 10240482 and its pre-req patches 10167279,10235354 and 10014847. The process ran without error before the application of these two patches.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!