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

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

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#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.util.model.applicationModule.GLIntegrationBaseAMImpl] [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(SnpSessTaskSqlS.java:53)

Changes

Cause

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