FEM_GL_POST_MISSING_BAL_COL Error Using External General Ledger Data Loader (Doc ID 375438.1)

Last updated on NOVEMBER 25, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10.R2
FEM
External General Ledger Data Loader
This problem can occur on any platform.

Symptoms

Attempting to load General Ledger data using fem_bal_interface_t table and are loading history data as YTD balance. The column "YTD_BALANCE_E" is populated in the interface table, and the process "External General Ledger Data Loader" is run with one of the parameter value as "Populate PTD and YTD only".

However, the process errored with the following message:

In the interface table, the "posting_error_code" column is showing message "FEM_GL_POST_MISSING_BAL_COL". Even trying to populate the column "xtd_balance_e" in interface table, the same error message appears.

ERROR
FEM_GL_POST_MISSING_BAL_COL:

Error: According to the QTD-YTD parameter and the currency type specification, some values for the
XTD/QTD/YTD columns are missing.

STEPS
The issue can be reproduced at will with the following steps:

Execution Mode: Snapshot
Run in Snapshot Mode
Ledger: GEMIS-US
GEMIS - US OPERATIONS - Set of Books
Calendar Period: JAN-05
JAN-05
Budget:
Encumbrance Type:
Dataset: Actuals_GL
Actuals from GL
Period Specific Amounts Provided: Populate PTD and YTD only
Populate only the PTD and YTD columns, butnot the QTD columns

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