My Oracle Support Banner

How To Correct Item Revisions Which Have Revision And Effectivity Date In Incorrect Alphabetical / Chronological Order? (Doc ID 388349.1)

Last updated on FEBRUARY 08, 2019

Applies to:

Oracle Item Master - Version 11.5.10.0 and later
Oracle Product Hub - Version 11.5.10.0 and later
Information in this document applies to any platform.

Goal

 

How do you correct revisions where the revisions are out of order with the effectivity dates?

Identification Script

The following SQL looks for items with this issue where the revision is smaller but the effectivity date is greater.


Example -- Data Issue Seen
For example, you have the following revisions: A, B, C, D. The revisions however show effectivity dates out of order:

This is what you see and it is incorrect order on revisions:
Revision / Effectivity Date
A           / 10-OCT-2018
D           / 12-OCT-2018
B           / 15-OCT-2018
C           / 18-OCT-2018

Expected Results
Revision / Effectivity Date
A           / 10-OCT-2018
B           / 15-OCT-2018
C           / 18-OCT-2018
D           / 12-OCT-2018

Rules
Item revisions should always follow the below two rules:
- Revisions have to be in alphabetical order (ASCII order)
- Revision effectivity_date have to be chronological order.

How to fix this?

Solution

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
Goal
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.