Audit History Consolidator Report Issue (Doc ID 2643594.1)

Last updated on MARCH 07, 2022

Applies to:

Symptoms

On : 12.2.6 version, Transaction Control

ACTUAL BEHAVIOR
---------------
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


EXPECTED BEHAVIOR
-----------------------
Expect the date records to contain the timestamp

STEPS
-----------------------
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

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

Changes

 Upgrade to system from 11i to 12.2.6.

Cause

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