My Oracle Support Banner

ORASE: W_RTL_PRICE_IT_LC_DY_F_JOB Failure Shows One Thread as Success and Others In Progress (Doc ID 2822321.1)

Last updated on NOVEMBER 18, 2021

Applies to:

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


The nightly batch has a failure at W_RTL_PRICE_IT_LC_DY_F_JOB in POM. In c_load_dates table, one thread shows "Success" status, while other threads show "InProgress".

Error: MASTER_SIL_RETAILPRICEFACT failed with return code 1.
EXT_PROG_SYS_ERR:/u01/retail/ri/mmhome/src/ri_wrapper.ksh: Caused By: com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30059: The number of child sessions in error state is greater or equal to the MAX_CHILD_ERROR parameter.


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.