My Oracle Support Banner

Unable To Import Data Using Hyperion FDMEE (Doc ID 2502371.1)

Last updated on JANUARY 15, 2020

Applies to:

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


Error while trying to import data from Oracle EBS GL
The import process was happening fine till last month Financial close cycle. But all of a sudden the Import step in FDMEE is failing.

ERROR In Process Log

FATAL [AIF]: Error in Launch GL Load Balances Data

Error in Aif-WebApp log
[ErpIntegrator0] [NOTIFICATION] [] [oracle.apps.erpi.model] [tid: 106] [userId: ] [ecid: 00irsvekgvAFg4c5Tjd9ic00018g002NEy,0:1:4] [APP: AIF#] [SRC_CLASS:] [SRC_METHOD: invoke_odi_process] pid:8739, Extract id:12235501, status:Session Failed :12235501 : ODI-1217: Session COMM_LOAD_BALANCES (12235501) fails with return code 7000.[[
ODI-1226: Step FAILED - Import Data fails after 1 attempt(s).
ODI-1232: Procedure COMM Finalize Process execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
 File "", line 10, in
 File "", line 162, in finalizeProcess
RuntimeError: ODI-1226: Step Launch GL Load Balances Data fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlS.getExceptionOnStepTaskFailure(




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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