Oracle® Retail Sales Audit (ReSA) User Guide Release 16.0.024 E90750-01 |
|
![]() Previous |
![]() Next |
Once the auditing process is complete, the transactional data is exported to different Oracle Retail systems. Exporting data involves retrieving data from the ReSA database, and writing it to a file formatted to the standards of the external systems such as, Retail Merchandising System (RMS), Store Inventory Management (SIM), Retail Invoice Matching (ReIM), Retail Analytics (RA)/Retail Insights (RI), and third party applications.
ReSA uses the following process to export audited data:
Transactions/Totals that are corrected in the interactive audit process are extracted from the database tables by the Sales Audit program.
This information is written to interface files/tables that are used by external systems.
A batch program extracts transactions with the status of Passed, Non-fatal, and Delete. The data is exported to temporary staging tables where additional batch programs manipulate the data and pass it to external systems, such as RMS or RA.
If a previous revision of a transaction was exported, a reversal of the revision is also included in the transmission.
After all reversal entries are created, the reversed transactions are deleted from the transaction tables.