Post Voiding a Transaction Does Not Modify UPDATE_ID, UPDATE_DATETIME in SA_TRAN_HEAD Table (Doc ID 1923931.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle Retail Sales Audit - Version 13.2.6 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Sales Audit (ReSA) 13.2.x, performing a post void of a transaction does not update the UPDATE_ID or UPDATE_DATETIME in the SA_TRAN_HEAD table.


Steps to Reproduce:

  1. Create a sales transaction.
  2. View data in the SA_TRAN_HEAD table and make sure there are no errors in the transaction.
  3. Look for data in the *_REV tables.  There should be no data in the revision tables. 
  4. Go to the Transaction Find screen in the UI and search for the sales transaction that was uploaded in Step 1.
  5. Post Void that transaction and click OK on the Transaction Detail screen. 
  6. Check the data in SA_TRAN_HEAD. Note that the value in the REV_NO field is 1. 
  7. Check the UPDATE_ID and UPDATE_DATETIME in SA_TRAN_HEAD.  This record shows the original values that were inserted by the RTLOG upload in Step 1.

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