External GL Data Loader Completed with Warning - No Data Loaded (Doc ID 433720.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10.2
This problem can occur on any platform.

Symptoms

-- Problem Statement:
A custom program ran fine and loaded the data to the fem_bal_interface_t table. When running External General Ledger Data Loader, it completed with warning and no data is loaded to the fem_balances table.

-- ERROR
FEM_XGL_POST_ENGINE module: External General Ledger Data Loader

Either the loading process could not find any rows in the interface table
(FEM_BAL_INTERFACE_T) that match the parameters entered for this execution,
or the data slice columns are NULL for all matching rows.

The parameters entered resulted in the following values used for matching:
LOAD_METHOD_CODE: I;
CAL_PER_DIM_GRP_DISPLAY_CODE: OGL_1;
CAL_PERIOD_END_DATE: 31-JAN-07 00:00:00;
CAL_PERIOD_NUMBER: 1;
LEDGER_DISPLAY_CODE: NETZERO, INC;
DS_BALANCE_TYPE_CODE: ACTUAL;
BUDGET_DISPLAY_CODE: ;
ENCUMBRANCE_TYPE_CODE: .
Note that for LOAD_METHOD_CODE = 'I', the only new rows processed are those
with LOAD_METHOD_CODE = 'I'. However, all error rows remaining from previous executions are reprocessed, including both 'I' and 'S' values. Note also that
DS_BALANCE_TYPE_CODE must match the Dataset Balance Type Code attribute
of the Dataset parameter.

-- Steps To Reproduce:
1. Run UOL EPB Load Assets Projection Depreciation
2. It will run FA Projections (Depreciation Projection) and load data to the fem_bal_interface_t table
3. Run External General Ledger Data Loader with Incremental mode.

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