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’;

 

Now

 

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(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)

     => 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.