My Oracle Support Banner

Data Load ETL fails with 'ORA-25156: Old style outer join (+) Cannot be used with ANSI joins' Error (Doc ID 2442071.1)

Last updated on OCTOBER 11, 2018

Applies to:

Oracle Healthcare Translational Research - Version 3.1.0.4 and later
Information in this document applies to any platform.

Symptoms

On TRC 3104 version, Performance

ACTUAL BEHAVIOR
---------------
When running LOAD_SUBADMN_PATIENT_BRIDGE , the following errors occurs:

Session LOAD_SUBADMN_PATIENT_BRIDGE (26213507)
Session Name: LOAD_SUBADMN_PATIENT_BRIDGE Status: Error
Scenario Name: LOAD_SUBADMN_PATIENT_BRIDGE Context: Global
Scenario Version: 001
Start: Aug 14, 2018 5:23:42 PM End: Aug 14, 2018 5:23:43 PM
------------
Record Statistics
No of Inserts: 0 No of Updates: 0 No of Deletes: 0
No of Errors: 0 No of Rows: 0

Error Messages;
ODI-1217: Session LOAD_SUBADMN_PATIENT_BRIDGE (26213507)fails with return code 25156.
ODI-1226: step INT_TMPAPPS_Subadmin_patient_H fails after 1 attempt (S).
ODI-1240: Flow INT_TMPAPPS_Subadmin_patient_H fails while performing a Integration operation. This flow loads target table W_EHA_SUBADMIN_PATIENT_H.
ODI-1228: Task INT_TMPAPPS_Subadmin_patient_H (Integration) fails on the target ORACLE connection ORACLE_TMP_DATAMART.
Caused By: java.sql.SQLException: ORA-25156: old style outer join (+) cannot be used with ANSI joins

 

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.