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

Last updated on JUNE 21, 2023

Applies to:

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

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