My Oracle Support Banner

Retail Sales Audit (ReSA) Totals Do Not Get Re-exported to General Ledger (GL) After Being Modified and Recalculated for a Closed Store (Doc ID 1516158.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

Oracle Retail Sales Audit - Version 13.1.4 to 13.1.7 [Release 13.1]
Oracle Retail Sales Audit - Version 13.2.4 to 13.2.7 [Release 13.2]
Information in this document applies to any platform.


When the Oracle Retail Sales Audit(ReSA) Total is modified and recalculated for stores that were already closed, the new amount does not get re-sent to General Ledger (GL).   We expect to be able to get old amounts reversed and new amounts re-sent, but this does not happen for 'C'losed stores.   Totals for a store/day that have been modified by an auditor are not being exported to the STG_FIF_GL_DATA when the store status = 'C'losed.

Steps to Reproduce:

1. Select one closed store and validate the totals on screen.
2. Modify the formula for one total mapped to GL and finish it with option “Reset the store status and recalculate”.  The new version of totals will be recalculated.
3. Validate the new amount for the total.
4. Run saexpgl, and check staging table STG_FIF_GL_DATA.  Totals are not there.  It should contain the reverse amount of the previous version and new totals posted to GL.




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.