Issues With Plan Design Import (Doc ID 1951440.1)

Last updated on MAY 20, 2015

Applies to:

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

Symptoms

On : 11.1.8.0.0 version, Manage Benefits

Customer type: SaaS
Release level (8)


When attempting to Import Benefits Plan Configuration from stage to production, the following error occurs.


ERROR
-----------------------
ODI-1217: Session HCM_BEN_PGM_IMPORT_WRAPPER (12502) 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: Foreign key not present.
BEN_VRBL_RT_PRFL_F ELIGY_PRFL_ID
BEN_OIPLIP_F OIPL_ID
ORA-06512: at line 414

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;
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(StartScenRequestProcesso


Customer is trying to export and import as 1/1/1951. All our comp objects are created as of 1/1/1951 in stage.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Plan Configuration > Manage Benefits configuration > Import Benefits plan configuration
Plan Copy Name :US_XXX_Benefits_1124
Plan Copy Object:US XXX Benefits Program
Effective Date :01-JAN-1951
Reuse existing named objects



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