My Oracle Support Banner

Update_items_and_sourcing Returned Unexpected Error (Doc ID 1669935.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Configure to Order - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.


Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.