My Oracle Support Banner

Which SAEXPDW Generated File Should Be Used for Retail Analytics (RA)? (Doc ID 1378165.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Retail Merchandising Insights - Version 13.2 and later
Information in this document applies to any platform.


This document discusses which SAEXPDW generated file should be used for Retail Analytics (RA), as the script produces multiple files with varying structures.

After completing the following steps:

1. Execute Retail Sales Audit (ReSA)
2. Run SAEXPDW and RESA2DW for each file
3. Observe XTERN_RDWT table on RMSRA schema

We note that SAEXPDW script generates these four files:
 RDWT - Transaction file
 RDWF - Form of Payment (Tender) file
 RDWS - Store Totals Output file
 RDWC - Cashier Output file

RESA2DW processes each file and prepares them for export to RA, however the prepared file structure is totally different for all files.

Which SAEXPDW generated file should be used for RA?


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.