TRANSACTION AUDIT TRAIL NOT SHOWING UPDATED/CORRECTED AMOUNTS

(Doc ID 2244928.1)

Last updated on MARCH 22, 2017

Applies to:

Oracle Retail Sales Audit - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

When the Sales Auditor makes changes to the ReSA transaction, clicks 'Save', this creates a Revision, they will click on 'Save and Close' to exit the transaction,notice that these changes are also available in the
Transaction Audit Trail for the transaction in the UI.

However, if the Sales Auditor makes changes to the ReSA transaction and simply clicks on 'Save and Close' to exit the transaction,and they go and check the Transaction Audit Trail for this transaction, the changes are not
shown in the UI. Although SA_TRAN_HEAD for that transaction marks that a revision exists for that transaction.

 

Instructions To Recreate:

Scenario 1:

a. Transaction is present in SA_TRAN_ITEM table with quantity One, Audit trail not available.
   Edit the transaction. Update quantity to Two, Click Save. (Revision written to SA_TRAN_ITEM_REV with quantity 1). Click Save and Close.
    (Revision written to SA_TRAN_ITEM_REV with quantity 2).
b.  Audit Trail window available, shows 2 revisions with quantity 1 and quantity 2.

Scenario 2:


a. Transaction is present in SA_TRAN_ITEM table with quantity 1. Audit trail not available.
    Edit the transaction. Update quantity to 2. Click Save and Close.
   (Revision written to SA_TRAN_ITEM_REV with quantity 1).

b.  Audit Trail window available, shows 1 revision with quantity 1.

In Scenario 2, notice that Audit Trail is incomplete because it doesn't show the current / latest values.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms