My Oracle Support Banner

Retail Data Extractor (Universal Adapter) is not Generating .dat.ctx File (Doc ID 2132425.1)

Last updated on DECEMBER 05, 2019

Applies to:

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


Retail Data Extractor (Universal Adapter) is not generating .dat.ctx file.

Steps to Recreate:

  1. Open ODI client.
  2. Navigate to Oracle BI Applications 11g (Project) -> Utilities_and_Execution (Folder) -> SDE_RetailUniversalAdapterLoad -> Procedures.
  3. Modify the procedure RABE_GENERATE_CTXFILE -> Options and set GENERATE_CTXFILE =1.
  4. Navigate to procedure RA_GENERATE_CTXFILE -> Options and set GENERATE_CTXFILE =1.
  5. Open $MMHOME/src in Terminal and run the batch with ./rtluasde.ksh
  6. .dat file is generated in $MMHOME/data/staging, but .dat.ctx file is not generated.




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.