Import Process

Importing data from the POS to Sales Audit is a multi-step process that involves several Sales Audit batch processes.

Preparing for Import

• Create Store Day for Expected Transactions (sastdycr) prepares the Sales Audit tables for data upload.

• Get Reference Data for Sales Audit Import Processing (sagetref) creates a number of reference files to be used for validation in the POS File Validation/Upload Process.

Importing Data

See the Merchandising Operations Guide Volume 2 for details on the following import programs:

• Import of Unaudited Transaction data from POS to Sales Audit (saimptlog/saimptlogi) validates files and uploads their transactions into the Sales Audit tables. This includes (as necessary) creating errors for the auditors to address.

• Sales Audit Voucher Upload (savouch) processes voucher sales and redemptions.

• Import Total Value Adjustments From External Systems to Sales Audit (saimpadj) imports adjustments to previously imported data.

• Customer Engagement Promotion Service (CePromoBatch.ksh) calls the ORCE webservice to retrieve promotion information, if using that solution to create promotions.

Import Processing Programs

• Processing to Allow Re-Upload of Deleted Transactions (saimptlogtdup_upd) fetches deleted transactions for a store day and modifies the tdup files remove deleted transactions in order to facilitate the saimptlog/saimptlogi uploads of deleted transactions again.

• Complete Transaction Import Processing (saimptlogfin) executes a number of import cleanup processes.

Figure 19-2 Oracle Retail Sales Import Process