Failed Data Load - SIL

Edwin-ACE

Guys,

I'm getting the error below when doing a Data Load from EBS_12_1_3 using BI Apps 11.1.1.10.1

ODI-1519: Serial step "Start Load Plan (InternalID:60470500)" failed because child step "Global Variable Refresh (InternalID:60471500)" is in error. ODI-1519: Serial step "Global Variable Refresh (InternalID:60471500)" failed because child step "Warehouse Load Phase (InternalID:62959500)" is in error. ODI-1519: Serial step "Warehouse Load Phase (InternalID:62959500)" failed because child step "1 SIL Load (InternalID:62960500)" is in error. ODI-1519: Serial step "1 SIL Load (InternalID:62960500)" failed because child step "2 SIL Fact Group (InternalID:64094500)" is in error. ODI-1519: Serial step "2 SIL Fact Group (InternalID:64094500)" failed because child step "Parallel (InternalID:64095500)" is in error. ODI-1518: Parallel step "Parallel (InternalID:64095500)" failed; 6 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 SIL Fact PRODEXP_FG (InternalID:64263500), 3 SIL Fact APTRANS_FG (InternalID:64099500), 3 SIL Fact GLCOGS_FG (InternalID:64234500), 3 SIL Fact ARTRANS_FG (InternalID:64127500), 3 SIL Fact GLREVN_FG (InternalID:64207500), 3 SIL Fact CUSTEXP_FG (InternalID:64266500) ODI-1519: Serial step "3 SIL Fact PRODEXP_FG (InternalID:64263500)" failed because child step "PRODEXP_FG (InternalID:64264500)" is in error. ODI-1519: Serial step "PRODEXP_FG (InternalID:64264500)" failed because child step "SIL_PRODUCTCOSTLINESFACT (InternalID:64265500)" is in error. ODI-1217: Session SILOS_SIL_PRODUCTCOSTLINESFACT (5237500) 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 Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW. Caused By: java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942: ORA-06512: at line 49 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539) at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)

at oracle.odi.core.persistence.dwgobj

Edwin-ACE

I found the issue and it's addressed in the following Note Select Statement Throws ORA-01792 Error ( Doc ID 1951689.1 )