My Oracle Support Banner

Error While Running Retail Analytics Batch SLSILTSDE.KSH At Step/Interface "SDE_RetailSalesTransactionFactTempLoad_A2" (Doc ID 1497524.1)

Last updated on APRIL 08, 2021

Applies to:

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

Symptoms

While running "slsiltsde.ksh" it errors out. It errors out in step / interface "SDE_RetailSalesTransactionFactTempLoad_A2".

IN SDE_RETAILSALESTRANSACTIONFACTTEMPLOAD_A2 PROD_IT_NUM JOIN WITH ITEM RESULTS 0

Steps To Recreate:

1. Execute the package - SIL_Retail_SalesTransactionFact (slsiltsde.ksh).
2. while loading the table W_RTL_SLS_TRX_IT_LC_DY_FS, We can observe the column  PROD_IT_NUM value is fetching a trimed value.

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!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.