Modified payroll_1 load plan to remove LEARNING related steps. This Load plan is under below.

Past that error and now below error.

Seems to be a bug, applied below fix and rerunning it.



 alter system set “_fix_control”=’17376322:OFF’;




ODI-1217: Session SILOS_SIL_HRASSIGNMENTCONTRACTS_FLEX_DIMENSION (6256500) 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: ODI-1228: Task SIL_HRAssignmentContracts_Flex_Dimension (Integration) fails on the target ORACLE connection BIAPPS_DW.

Caused By: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number


    at oracle.jdbc.driver.T4CTTIoer.processError(

    at oracle.jdbc.driver.T4CTTIoer.processError(

    at oracle.jdbc.driver.T4C8Oall.processError(

    at oracle.jdbc.driver.T4CTTIfun.receive(

    at oracle.jdbc.driver.T4CTTIfun.doRPC(

    at oracle.jdbc.driver.T4C8Oall.doOALL(

    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(

    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(

     => ORA-20942:

ORA-06512: at line 60


Not exact error but Somewhat related note. The solution is to apply a patch but this needs to be an SR with regard to our error.


Publish Planning Result Completes With Error VCP-JDE Integration ODI-1226, ODI-1232: Procedure UpdatePurchasePlanDetail execution fails. then ODI-1228 (Doc ID 2178053.1)


I just disabled the DIM where it was failing.


disabled HRASGNMT_DIM 

After above change it completed successfully.