My Oracle Support Banner

When a Post-Void Transaction Is Sent to ReSA, Reversal of the Sales/Return for That Transaction Is Not Generated During Export to RMS (Doc ID 728061.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

Oracle Retail Sales Audit - Version 12.0.7 to 12.0.9 [Release 12.0]
Information in this document applies to any platform.
Checked for relevance on 5 Oct 2010
Checked for relevance July-2013


When a Post-Void transaction is sent to Oracle Retail Sales Audit (ReSA), the reversal of the sales/return for that transaction is not generated while exporting data to Retail Merchandising System (RMS).

Steps to Reproduce:

  1. Check that the SA_SYSTEM_OPTIONS parameter UNIT_OF_WORK = 'T'.
  2. Upload sales transactions to ReSA.
  3. Export the data to RMS.
  4. Verify that the POSU generated contains the correct data.
  5. Upload some other transactions along with a Post-Void of one of the transactions that was previously uploaded.
  6. Notice that the record for the Post-Voided transaction is deleted from the SA_EXPORTED table and the details of this has been inserted into SA_EXPORTED_REV table.
  7. Export the data to RMS.
  8. Notice that the POSU generated does not have any detail regarding the Post-Voided transaction, but contains all other details.


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.