Benefit Program Import Function Is Not Working (Doc ID 2065285.1)

Last updated on NOVEMBER 24, 2015

Applies to:

Oracle Fusion Benefits Cloud Service - 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms