Account Reconciliation Manager (ARM) Data Load Fails With Errors: "Export terminated due to error in ODI Scenario step: 'Set ERPI Export flag to true'" (Doc ID 2196039.1)

Last updated on OCTOBER 28, 2016

Applies to:

Hyperion Financial Close Management - Version 11.1.2.3.700 and later
Information in this document applies to any platform.

Symptoms

When attempting to perform a data load in ARM. It fails with the error "Export terminated due to error in ODI Scenario step: "Set ERPI Export flag to true". Check the execution logs in the Oracle Data Integrator Studio Operator tab."

In the ODI Studio, when you click the EXPORTTOARM scenario (which can't be completed and consequently disrupts the ARM data load), additional errors are seen:

"ODI-1217: Session EXPORTTOARM (8033501) fails with return code 7000.
ODI-1226: Step Log Error and Delete records for all fails after 1 attempt(s).
ODI-1232: Procedure Log Error and Delete records for all 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 Set ERPI Export flag to true fails after 1 attempt(s).
ODI-1232: Procedure Set ERPI Export flag to true execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 21, in <module>
RuntimeError: No LOAD_ID is found in ARM_DATALOAD_RULES table"

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