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 FEBRUARY 20, 2019
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
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