FDMEE Load to Hyperion Financial Management (HFM) Fails When using "REPLACEBYSECURITY" Mode with Error: ERROR [AIF]: java.lang.Exception: Invalid Mode: should be Scan, Merge, Accumulate or ReplaceBySecurity ERROR [AIF]: The script has failed to execute (Doc ID 2003368.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.3.000 and later
Information in this document applies to any platform.

Symptoms

 FDMEE fails with the below message when loading to HFM REPLACEBYSECURITY option:

 ERROR [AIF]: java.lang.Exception: Invalid Mode:
 should be Scan, Merge, Accumulate or ReplaceBySecurity
 ERROR [AIF]: The script has failed to execute:
 FATAL [AIF]: Error in Comm.executeJythonScript
 Traceback (most recent call last):
 File "<string>", line 564, in executeJythonScript  File
"C:\oracle\Middleware\EPMSystem11R1/products/FinancialDataQuality/bin/HFM_LOAD.py", line 986, in <module>
   raise Exception("loadData raised an exception.") Exception: loadData raised an exception.  

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