My Oracle Support Banner

Error "You cannot update or delete component &C1 since it does not exist for item &A1" When Trying To Update Supply Subinventory For A Commoned Bill Using API Bom_Bo_Pub.Process_Bom (Doc ID 3050926.1)

Last updated on NOVEMBER 21, 2024

Applies to:

Oracle Bills of Material - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

User has over 3000+ existing bills in child organizations that are referenced from a Common organization.  There is a need to update the bills to maintain supply subinventory, supply locator at the organization level. 

From Bills of Material User Guide > Common Bills of Material > See below -
If two or more organizations manufacture the same item using the same bill of material, you can define the bill in one organization and reference it from the other organizations.
Necessary changes must then be made to the referenced bill. Optionally, you can reference all but the following five fields in a bill, maintaining these fields by individual bill of material.

• Supply Type
• Subinventory
• Locator
• Operation Seq
• Include In Cost Rollup

When trying to update Enable attributes = Yes to maintain supply_subinventory in a common bom (child org), the API Bom_Bo_Pub.process_bom throws below errors.

ERROR
=======================================================
Calling Bom_Bo_Pub.process_bom API
=======================================================
Return Status: E
x_msg_count:2
Error Message Count :2
1:1:BOM_INVENTORY_COMPS_INTERFACE
1:You cannot update or delete component C1 since it does not exist for item A1.
2:1:
2:An error occured while processing business object 1883AN65B in organization D1. Please check the data in this business object and re-run the import process.
=======================================================

STEPS 
1. Run API Bom_Bo_Pub.process_bom to update Enable Attrs = Yes and Supply subinventory on child bill
2. See error above.

WORKAROUND
1. Go to child org > Bills of Material > Bills > Query for the Bill > Place cursor on Components > See warning > Enable Attributes Yes/ No > Click Yes > Save.
2. Then run API, it works. This involves manual effort and is not feasible.

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!


In this Document
Symptoms
Cause
Solution
 Workarounds
 Idea
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.