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 laterInformation 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
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 |