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 MAY 16, 2016

Applies to:

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

Symptoms

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

Using the "ECO Open Interface" program to upload ECOs.
Data has been populated into the interface tables - eng_eng_changes_interface, eng_revised_items_interface and bom_inventory_comps_interface.

When trying to update the item revision for a new BOM or updating an existing BOM, the program errors out with the 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.
new_item_revision, new_revised_item_rev_desc fields in the eng_revised_items_interface have been populated. Then the program errors out.

If i just try to update an item revision alone with the same fields, then the program is successful. Only when trying to update item revision for BOM, we are facing this issue.

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