My Oracle Support Banner

Temporary Tables are not Deleted After Running SDE_RetailWholesalefranchiseFact (Doc ID 2414236.1)

Last updated on JUNE 28, 2018

Applies to:

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

Symptoms

In the Interfaces "SDE_RetailWholesalefranchiseLoad" and "SDE_RetailItemSeasonDimensionLoad",  the "DELETE TEMPORARY OBJECT" option is set to False hence, temporary tables are not deleted from the system.

Steps To Recreate:

  1. Open SDE_RETAIL_ADAPTOR
  2. Navigate to "SDE_RetailWholesalefranchiseFact" / “SDE_RetailItemSeasonDimension” sub folder
  3. Open Interface SDE_RetailWholesalefranchiseLoad / SDE_RetailItemSeasonDimensionLoad
  4. Go to Flow Option --> LKM (LKM RA Oracle to Oracle(DBLink) with Control)
  5. Check for the Option "DELETE TEMPORARY OBJECT"
  6. This Option should be set to "True"

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.