My Oracle Support Banner

Missing Item Revisions in MTL_ITEM_REVISION_B And MTL_ITEM_REVISIONS_TL Implemented Via Change Order (ECO) (Doc ID 2856630.1)

Last updated on MARCH 17, 2022

Applies to:

Oracle Engineering - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

--ISSUE DESCRIPTION--
The item has a revision missing in the revisions tables in a given organization.
The revision was implemented via ECO which is in implemented status.

--STEPS TO REPRODUCE--
1. Go to Engineering > Change Management > Change Orders (ECO)
2. Create and implement an ECO with a new Item Revision
3. Navigate to Inventory > Items > Master Items
4. Query the item 
5. Click on Tools > Revisions
6. See all the revisions for the item in the organization except the revision which was implemented in the ECO.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.