Item Revision does not get updated in ENG ECO form after creating ECO to update the item revision using ECO API (Doc ID 1249568.1)

Last updated on JANUARY 27, 2017

Applies to:

Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite - Version 2.5 to 3.1 [Release 2.5 to 3.1]
Information in this document applies to any platform.

Symptoms

The released ECOs from Agile, ECO are created successfully in Oracle E-Business Suite. The items and BOMs listed in the ECO are also created successfully. The issue is that the revision for the items is not getting updated on the Oracle E-Business side. For example it is always showing as A for Items as well as BOMs even after updating the revision to B or C in Agile PLM. Item revision table does not get updated with new revisions.

Confirm this by viewing the Item Revision tab in the Master Item Form or by running the SQL:

SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, REVISION FROM MTL_ITEM_REVISIONS_B
WHERE INVENTORY_ITEM_ID = &item_id
AND ORGANIZATION_ID = &org_id

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