My Oracle Support Banner

ReSA Transactions in Error But No Records in SA_ERROR Table (Doc ID 2618900.1)

Last updated on DECEMBER 16, 2019

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.


In an unidentified scenario at the customer end, some transactions that are our of balance exist in Retail Sales Audit (ReSA) but no TRAN_OUT_BAL records could be seen in SA_ERROR table.

Steps to test by forcing the scenario:
1. Create a transaction in ReSA and ensure that transaction is out of balance (has a TRAN_OUT_BAL error).  
2. Delete the TRAN_OUT_BAL error from the SA_ERROR table.
3. Run the batches saprepost sapreexp post batch.
4. Verify that a TRAN_OUT_BAL error is written for the transaction in Step 1.




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.