Item Revision does not get updated in ENG ECO form after creating ECO to update the item revision using ECO API
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.
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
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