Intermediate Temp Tables (C$) Created in Retail Analytics Batches Require Cleanup (Doc ID 1993248.1)

Last updated on AUGUST 17, 2016

Applies to:

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

Symptoms

In the Oracle Retail Analytics (RA) 13.2.3 interfaces "SDE_RetailWholesalefranchiseLoad" and "SDE_RetailItemSeasonDimensionLoad" the "DELETE TEMPORARY OBJECT" option is set to False.  This option should be set to "True," as if it is not, the Oracle Data Integrator (ODI) job will create intermediate temp tables (known as 'C$' tables) by using this Loading Knowledge Module (LKM).  Manual cleanup of these artifacts could be extensive, so it is essential that the cleanup is handled by ODI's LKM itself.


Steps to Reproduce:

  1. Open SDE_RETAIL_ADAPTOR.
  2. Navigate to "SDE_RetailWholesalefranchiseFact" sub folder.
  3. Open Interface "SDE_RetailWholesalefranchiseLoad".
  4. Go to Flow Option --> LKM (LKM RA Oracle to Oracle (DBLink) with Control).
  5. Check for the option "DELETE TEMPORARY OBJECT". 
  6. Note that the object is set to "False" and should instead be set to "True"

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms