My Oracle Support Banner

W_RTL_PRICE_IT_LC_DY_F_JOB Fails with ORA-30926: unable to get a stable set of rows in the source tables (Doc ID 2956045.1)

Last updated on NOVEMBER 20, 2023

Applies to:

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

Goal

W_RTL_PRICE_IT_LC_DY_F_JOB fails and log shows:

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at
...
{"step":"RA_Update_TO_DT_WID","status":"ERROR","sourceCmd":null,"targetCmd":null,"errorMessage":"
ODI-1228: Task Procedure-RA_Update_TO_DT_WID-Update TO_DT_WID fails on the target connection ORACLE_BI_APPLICATIONS_MED.
Caused by: java.sql.SQLException: ORA-12801: error signaled in parallel query server P01V, instance 6
ORA-30926: unable to get a stable set of rows in the source tables
 

Solution

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.