OBIA 12c: SDE_ORAR122_ADAPTOR_SDE_ORA_GLJOURNALSFACT Failing In Incremental Load With ORA-01705 Error
(Doc ID 3025663.1)
Last updated on JUNE 06, 2024
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.10.3 - PS3 - Patch Set 3 and laterInformation in this document applies to any platform.
Symptoms
SDE_ORAR122_ADAPTOR_SDE_ORA_GLJOURNALSFACT session failing in incremental load with the below error:
Error message:
==========
ODI-1217: Session SDE_ORAR122_ADAPTOR_SDE_ORA_GLJOURNALSFACT (11578) 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-1227: Task Load data-LKM BIAPPS SQL to Oracle (Multi Transport)- fails on the source connection EBSPROD.
Caused by: java.sql.SQLSyntaxErrorException: ORA-01705: an outer join cannot be specified on a correlation column
atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
atoracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
atoracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
atoracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
atoracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:230)
atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:42)
atoracle.jdbc.dri => ORA-20942:
ORA-06512: at line 60
==========
ODI-1217: Session SDE_ORAR122_ADAPTOR_SDE_ORA_GLJOURNALSFACT (11578) 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-1227: Task Load data-LKM BIAPPS SQL to Oracle (Multi Transport)- fails on the source connection EBSPROD.
Caused by: java.sql.SQLSyntaxErrorException: ORA-01705: an outer join cannot be specified on a correlation column
atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
atoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
atoracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
atoracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
atoracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
atoracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:230)
atoracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:42)
atoracle.jdbc.dri => ORA-20942:
ORA-06512: at line 60
.
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 |