My Oracle Support Banner

KO Path Missing In SIL_RetailPriceFact Package (Doc ID 2414762.1)

Last updated on JUNE 29, 2018

Applies to:

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

Symptoms

When regenerating the scenario SIL_RETAILPRICEFACT, the process returns the following error:

ODI-1217: Session RA_BI.RA_BUSINESS_PREV_DT_WID (1773139) fails with return code 7000.
ODI-1226: Step RA_BUSINESS_PREV_DT_WID fails after 1 attempt(s).
ODI-1236: Error while refreshing variable RA_BI.RA_BUSINESS_PREV_DT_WID.
java.lang.Exception: ODI-17511: No value to be set to variable DefDate:null
DefN:null
DefV:null
IndStore:H
ITxtDefT:null
ITxtVar:null
SessNo:903001
VarDatatype:A
VarLongValue:null
VarName:RA_BI.RA_BUSINESS_PREV_DT_WID.
at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(RefreshVariableExecutor.java:70)


Steps To Recreate:

  1. Generate the scenario for SIL_RETAILPRICEFACT.
  2. Notice, RA_BUSINESS_PREV_DT_WID refreshing code does not include the prefix "RA_BI." for all variables.

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.