ODI-17511 No Value To Be Set To Variable ARM.PeriodName When Loading Data Into ARCS (Doc ID 2395055.1)

Last updated on FEBRUARY 27, 2024

Applies to:

Symptoms

When attempting to do a load data into ARCS, the load fails with the following error in the UI:

"N/A N/A Unable to perform data load. A service error has occurred. Select "Provide Feedback" and contact Oracle Support."

In the AccountReconciliation.log, the following error is thrown:

[2018-04-30T15:14:04.051+00:00] [EPMServer0] [ERROR] [] [oracle.apps.epm.arm.model] [tid: 16] [userId:USER] [ecid: 0000MCN7IeN8_q4pvSL6iX1QthkD00000j,0] [APP: ACCOUNTRECONCILIATION#11.1.2.0] [SRC_CLASS: oracle.apps.epm.arm.model.applicationModule.manager.dataload.DataloadPhase] [SRC_METHOD: _runDataload] ODI scenario failed with following error: Session Failed :72501 : ODI-1217: Session EXPORTTOARM (72501) fails with return code 7000.[[
ODI-1226: Step Log Error fails after 1 attempt(s).
ODI-1232: Procedure Log Error execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 20, in <module>
RuntimeError: ODI-1226: Step PeriodName fails after 1 attempt(s).
ODI-1236: Error while refreshing variable ARM.PeriodName.
Caused By: java.lang.Exception: ODI-17511: No value to be set to variable 'ARM.PeriodName'.
at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(RefreshVariableExecutor.java:70)
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.SnpSessTaskSqlV.processTask(SnpSessTaskSqlV.java:410)
...........................................
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:378)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:307)
Caused by: Traceback (most recent call last):
File "<string>", line 20, in <module>
RuntimeError: ODI-1226: Step PeriodName fails after 1 attempt(s).
ODI-1236: Error while refreshing variable ARM.PeriodName.
Caused By: java.lang.Exception: ODI-17511: No value to be set to variable 'ARM.PeriodName'.
at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(RefreshVariableExecutor.java:70)
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.SnpSessTaskSqlV.processTask(SnpSessTaskSqlV.java:410)

Cause

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