ECO Open Interface Program Errors With 'The Parent Item XXXX You Are Referencing In Component XXXX Does Not Exist On ECO XXX'

(Doc ID 2136703.1)

Last updated on OCTOBER 17, 2017

Applies to:

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

Symptoms

The Engineering Change Order (ECO) Open Interface program errors out when passing the item revision field for Bill of Materials (BOM) update/creation.

The "ECO Open Interface" program is being used to create/update ECOs.
Data has been populated into the interface tables:

The effective date in the bom_inventory_comps_interface and the scheduled date passed in the eng_revised_items_interface for the ECO are exactly the same.
Columns new_item_revision and new_revised_item_rev_desc fields have been populated in the eng_revised_items_interface.
When trying to update the item revision for a new BOM or updating an existing BOM and passing the item revision field, the program errors out with the following error message:

The parent item XXXX you are referencing in component XXXX does not exist on ECO XXX

 
The effective date in the BOM_INVENTORY_COMPS_INTERFACE and the scheduled date passed in the ENG_REVISED_ITEMS_INTERFACE for the ECO are exactly the same.
Columns new_item_revision and new_revised_item_rev_desc fields have been populated in table ENG_REVISED_ITEMS_INTERFACE.

If just updating the item revision alone with the same fields, then the program is successful.
The issue only occurs when trying to update the item revision for the bill.

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