Last updated on NOVEMBER 25, 2008
Applies to:Oracle Enterprise Performance Foundation - Version: 11.5.10.R2
External General Ledger Data Loader
This problem can occur on any platform.
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: According to the QTD-YTD parameter and the currency type specification, some values for the
XTD/QTD/YTD columns are missing.
The issue can be reproduced at will with the following steps:
Execution Mode: Snapshot
Run in Snapshot Mode
GEMIS - US OPERATIONS - Set of Books
Calendar Period: JAN-05
Actuals from GL
Period Specific Amounts Provided: Populate PTD and YTD only
Populate only the PTD and YTD columns, butnot the QTD columns
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms