My Oracle Support Banner

RSP/RI: W_RTL_SLSPR_PC_HH_WK_A_JOB Failure (Doc ID 2887575.1)

Last updated on JANUARY 31, 2024

Applies to:

Oracle Retail Science Platform Cloud Service - Version 21.0 and later
Information in this document applies to any platform.

Symptoms

When running the HIST_SALES_LOAD_ADHOC process, the W_RTL_SLSPR_PC_HH_WK_A_JOB is completing with errors. The log provides following details:

Package Name-> PLP_RETAILPROMOTRNDRPTAGGFACT
Step Name-> RA_TRIAL_REPEAT_DT_WID 
Error Details->
ODI-1226: Step RA_TRIAL_REPEAT_DT_WID fails after 1 attempt(s).
ODI-1236: Error while refreshing variable RA_BI.RA_TRIAL_REPEAT_DT_WID.
Caused By: java.lang.Exception: ODI-17511: No value to be set to variable 'RA_BI.RA_TRIAL_REPEAT_DT_WID'.

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.