My Oracle Support Banner

RI_DIM_INITIAL_ADHOC -> W_RTL_ITEM_XFORM_D_JOB Fails with "Table W_RTL_ITEM_XFORM_D does not exist in RA_TRUNCATE_TBL table or is invalid." (Doc ID 3039676.1)

Last updated on AUGUST 07, 2024

Applies to:

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

Symptoms

 RI_DIM_INITIAL_ADHOC -> W_RTL_ITEM_XFORM_D_JOB fails and log shows:

"step" : "SIL_RetailItemXFORMDimensionLoad",
"status" : "ERROR",
"sourceCmd" : null,
"targetCmd" : null,
"errorMessage" : "ODI-1298: Serial task \"SERIAL-MAP_MAIN- (10)\" failed because child task \"SERIAL-EU-BIAPPS_11g_RA_UNIT (20)\" is in error.
ODI-1298: Serial task \"SERIAL-EU-BIAPPS_11g_RA_UNIT (20)\" failed because child task \"Truncate target table-IKM RA Oracle Generic Insert with Control- (100)\" is in error.
ODI-1590: The execution of the script failed.
Caused By: javax.script.ScriptException: java.sql.SQLException: java.sql.SQLException: ORA-20001: Error occurred in TRUNCATE_RA_TBL.TRUNCATE_RA_TBL - Error in TRUNCATE_RA_TBL procedure. Table W_RTL_ITEM_XFORM_D does not exist in RA_TRUNCATE_TBL table or is invalid.
ORA-06512: at \"RADM01.RI_LOG_UTIL\", line 274
ORA-06512: at \"RADM01.TRUNCATE_RA_TBL\", line 69
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at \"RADM01.TRUNCATE_RA_TBL\", line 59
ORA-06512: at line 5

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.