While Generating Cross Reference File Getting "Extracting Cross Reference Data For Enterprise 1" Error (Doc ID 1511195.1)

Last updated on MAY 05, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.4.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to submit Generate mapping information, the following error occurs.

ERROR
-----------------------
ODI-1217: Session HCM_BL_MAINT_EXPORT_REFERENCES (2501) fails with return code 7000.
ODI-1226: Step Export SETID_SETS References fails after 1 attempt(s).
ODI-1240: Flow Export SETID_SETS References fails while performing a Integration operation. This flow loads target table XR_SETID_SET.
ODI-1228: Task Export SETID_SETS References (Integration) fails on the target FILE connection FILE_OUTPUT_HCM.
Caused By: java.sql.SQLException: ODI-40449: File not found: /tmp/ODI_IN/export/XR_SETID_SET.dat
at com.sunopsis.jdbc.driver.file.FileTruncator.truncateFile(FileTruncator.java:40)
at com.sunopsis.jdbc.driver.file.impl.commands.CommandTruncate.execute(CommandTruncate.java:39)
at com.sunopsis.jdbc.driver.file.CommandExecutor.executeCommand(CommandExecutor.java:33)
at com.sunopsis.jdbc.driver.file.FilePreparedStatement.execute(FilePreparedStatement.java:178)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:561)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1890)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:83)
at java.lang.Thread.run(Thread.java:662)


The issue can be reproduced at will with the following steps:
1. Go to Manage HCM Coexistence Configuration.
2. Generate cross reference file / submit Generate mapping information,

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