My Oracle Support Banner

Mapping “SIL_IndustryDimension_Translate” Fails With "ORA-20942: ODI-1228: Task Insert Unspecified record-IKM BIAPPS Oracle Incremental Update" (Doc ID 2957963.1)

Last updated on JULY 12, 2023

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.3 - PS2 - Patch Set 2 and later
Information in this document applies to any platform.

Symptoms

Mapping SIL_IndustryDimension_Translate is failing on step "Insert Unspecified record" with following error:

ODI-1217: Session SILOS_SIL_INDUSTRYDIMENSION_TRANSLATE (629539) fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Procedure-Diagnostics Raise Exception-Raise Diagnostic Error fails on the target connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: ODI-1228: Task Insert Unspecified record-IKM BIAPPS Oracle Incremental Update- fails on the target connection BIAPPS_DW.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00917: missing comma

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.