My Oracle Support Banner

Audit History Consolidator Report Issue (Doc ID 2643594.1)

Last updated on MARCH 07, 2022

Applies to:

Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Transaction Control

Facing some issues in the Audit History Consolidator after upgrade to system from 11i to 12.2.6.

Have made changes to sales order A,  like Schedule Ship Date, Promise Date & Shipping Method.
After running the program "Audit History Consolidator" we need to verify the changes made in the Sales Orders through the “Audit History” form.
In the form we could see the new values that are updated with Null values.

1. Old and New Values are not populating in same pattern for all sales orders in upgraded R12 instance.
For example, Sales Order B data is matching with 11i production but getting NULL values New Value field for Sales order A.
2. Also in R12, it appears all fields are being audited in R12 compared to 11i.
3. For Scheduled Ship Date and Promise Date fields, it is not showing Time Stamp like 11i

Expect the date records to contain the timestamp

The issue can be reproduced at will with the following steps:
1.Make changes to the record
2. Run the Audit Report or Consolidator and the changes are shown but no timestamp

The issue has the following business impact:
Due to this issue, users cannot determine the time the records were updated.


 Upgrade to system from 11i to 12.2.6.


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

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