CloudOPS Load Plan Executions Are Resulting In Errors (Doc ID 2177248.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Transactional Business Intelligence Enterprise for Human Capital Management Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

Apps-ETL Data Warehouse Loading

Load plan executions are resulting in errors

ODI-1519: Serial step "Start Load Plan (InternalID:6504)" failed because child step "Global Variable Refresh (InternalID:7504)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:7504)" failed because child step "Source Extract Phase (InternalID:89504)" is in error.
ODI-1519: Serial step "Source Extract Phase (InternalID:89504)" failed because child step "1 SDE Extract (InternalID:460504)" is in error.
ODI-1519: Serial step "1 SDE Extract (InternalID:460504)" failed because child step "2 SDE Dimension Group (InternalID:540504)" is in error.
ODI-1519: Serial step "2 SDE Dimension Group (InternalID:540504)" failed because child step "Parallel (InternalID:565504)" is in error.
ODI-1518: Parallel step "Parallel (InternalID:565504)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: 3 SDE Dims EMPLOYEE_DIM (InternalID:919504)
ODI-1519: Serial step "3 SDE Dims EMPLOYEE_DIM (InternalID:919504)" failed because child step "Load Target Table (InternalID:924504)" is in error.
ODI-1519: Serial step "Load Target Table (InternalID:924504)" failed because child step "TALEO_14_B - DSN 800 (InternalID:925504)" is in error.
ODI-1519: Serial step "TALEO_14_B - DSN 800 (InternalID:925504)" failed because child step "EMPLOYEE_DIM (InternalID:926504)" is in error.
ODI-1519: Serial step "EMPLOYEE_DIM (InternalID:926504)" failed because child step "Parallel (InternalID:927504)" is in error.
ODI-1518: Parallel step "Parallel (InternalID:927504)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: Case Variable: BIAPPS.IS_SDS_READY (InternalID:928504)
ODI-1521: Case step "Case Variable: BIAPPS.IS_SDS_READY (InternalID:928504)" failed; the selected child "When Value = Y (InternalID:929504)" is in error.
ODI-1520: Case-When/Else step "When Value = Y (InternalID:929504)" failed because child step "rootStep_caseWhen (InternalID:930504)" is in error.
ODI-1519: Serial step "rootStep_caseWhen (InternalID:930504)" failed because child step "Serial (InternalID:931504)" is in error.
ODI-1519: Serial step "Serial (InternalID:931504)" failed because child step "SDE_TLO_EMPLOYEE_EXTENSIONATTRIBUTESDIMENSION (InternalID:936504)" is in error.
ODI-1217: Session SDE_TALEO_14B_ADAPTOR_SDE_TLO_EMPLOYEE_EXTENSIONATTRIBUTESDIMENSION (3051504) fails with return code 1438.
ODI-1226: Step SDE_TLO_Employee_ExtensionAttributesDimension.W_EMPLOYEE_ADDL_DS fails after 1 attempt(s).
ODI-1240: Flow SDE_TLO_Employee_ExtensionAttributesDimension.W_EMPLOYEE_ADDL_DS fails while performing a Integration operation. This flow loads target table W_EMPLOYEE_ADDL_DS.
ODI-1228: Task SDE_TLO_Employee_ExtensionAttributesDimension.W_EMPLOYEE_ADDL_DS (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column

Changes

Applied Patch Bundle 9, Taleo load plan regeneration fails. This failure occurs because of a new logical schema,
DS_TALEO14B_SRCFILES.

Cause

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 hundreds of Community platforms