My Oracle Support Banner

Error In Importing Benefit Program (Doc ID 2406707.1)

Last updated on JANUARY 27, 2020

Applies to:

Oracle Fusion Benefits Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Error In importing Benefit Program

I am trying to import the benefit program downloaded from production into test and getting below exception

Looks like data corrupted in production. Could you please help us cleaning the data in production


ERROR
-----------------------
Plan Copy Name :prod05152018_v3
Effective Date :15-MAY-2018
--------------------------------------------------
Mapping information imported successfully.
--------------------------------------------------Error Message :
--------------------------------------------------
ODI-1217: Session HCM_BEN_PGM_IMPORT_WRAPPER (78503) 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_CHG_PLIP_ENRT_F LER_ID BEN_LER_F_TL count: 1
BEN_LER_CHG_PLIP_ENRT_F LER_ID BEN_LER_F count: 1
ORA-06512: at line 65

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;
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:2123)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1928)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcesso




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Export benefits program from Production
2. Upload the benefits program into test instance
3. Error exception is thrown

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users not able to upload the benefit program into test instance.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.