Common BOM Utility (BOMPCMBM) Fails From Master To Other Inventory Organizations With Utility (Component Replicate) ORA-01403: no data found Error (Doc ID 779546.1)

Last updated on AUGUST 11, 2017

Applies to:

Oracle Bills of Material - Version 12.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
***Checked for relevance on 10-Oct-2014***

Symptoms

Not able to common a Bill of Material (BOM) between two organizations.
The 'Create Common Bills' completes with Warning.
The log file indicates the following error.

-- Error
Calling BOM_BO_PUB.PROCESS_BOM
Commoning errored for organization : 103
entity_id : BH
BOMPCMBM : Utility (Component Replicate) ORA-01403: no data found
This record was not processed since an unexpected error occured in assembly item 9999 while
performing database writes.
entity_id : BO
An error occurred while processing business object 2990554206 in organization UTS.
Please check the data in this business object and re-run the import process.

-- Steps to Reproduce
Query a BOM in MST Org.
Go to tools and select Common the BOM.
This kicks off the concurrent Program 'Create Common Bills'
It completes with a warning.


Cause

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 hundreds of Community platforms