Benefit Program Import Function Is Not Working - ODI-1217: Session HCM_BEN_PGM_IMPORT_WRAPPER (63503) fails with return code 20010.
(Doc ID 2065285.1)
Last updated on NOVEMBER 01, 2024
Applies to:
Oracle Fusion Benefits Cloud Service - Version 11.1.10.0.0 and laterOracle Fusion Benefits - Version 11.1.10.0.0 and later
Information in this document applies to any platform.
Symptoms
On : 11.1.10.0.0 version, Manage Benefits
When attempting to import the benefit program target environment, the process errors out with the following error
ERROR
-----------------------
ODI-1217: Session HCM_BEN_PGM_IMPORT_WRAPPER (63503) fails with return code 20010.
ODI-1226: Step Foreign key Check fails after 1 attempt(s).
ODI-1232: Procedure Foreign key Check execution fails.
ODI-1228: Task Foreign key Check (Procedure) fails on the target ORACLE connection ORACLE_FUSION.
Caused By: java.sql.SQLException: ORA-20010: All tab script . Foreign key not present.
BEN_LER_POPL_ACTN_TYP_F LER_ID BEN_LER_F count: 1
BEN_LER_POPL_ACTN_TYP_F LER_ID BEN_LER_F_TL count: 1
BEN_LER_CHG_DPNT_CVG_F LER_ID BEN_LER_F count: 1
BEN_LER_CHG_DPNT_CVG_F LER_ID BEN_LER_F_TL count: 1
ORA-06512: at line 65
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.;
ODI-1226: Step PGM_IMPORT_WRAPPER fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(SnpSessTaskSqlS.java:53)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatStepTaskError(SnpSessStep.java:1127)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:594)
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:1895)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenReq
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Plan Configuration > Manage Benefits configuration > Import Benefits plan configuration
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import the program to target environment
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 |