8 Exporting Data

Once the auditing process is complete, the transactional data is exported to different Oracle Retail systems. Exporting data involves retrieving data from the Sales Audit 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.

Exporting Audited Data

Sales Audit uses the following process to export audited data:

1. Transactions/Totals that are corrected in the interactive audit process are extracted from the database tables by the Sales Audit program.

2. This information is written to interface files/tables that are used by external systems.

3. 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 Merchandising or Analytics.

4. If a previous revision of a transaction was exported, a reversal of the revision is also included in the transmission.

5. After all reversal entries are created, the reversed transactions are deleted from the transaction tables.