BSP 'Load Ledger Data into ESSBASE' Program Fails to Load Any Data (Doc ID 2304828.1)

Last updated on SEPTEMBER 13, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.2.0.9 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Balance Sheet Planning (BSP) 8.0.2.0.9, when you run the "Load Ledger Data into ESSBASE" program from the Financial Plan form, Ledger data is not getting loaded into Essbase.  No entries are created in FSI_MESSAGE_LOG or FSI_BSP_PROCESS_LOG for the BSP_LEDGER_STAT_TRANS program.

The following message is output to the Essbase application log from $MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/essbase/essbase/app/<app>:

[Thu Jul 20 18:09:33 2017]Local/<app>/BSP/admin@Native Directory/48/Info(1021006)
SELECT Statement [SELECT YEAR_VALUE,
PERIOD_NAME,
BUCKET_VAL,
PRODUCT_ID || '_CCOA',
STRATEGY_ID || '_ST',
CUSTOM1 || '_CS1',
CUSTOM2 || '_CS2',
CCY_CD,
ORG_UNIT_ID || '_ORGN',
FINANCIAL_ELEM_ID,
VERSION_DISPLAY_CD,
SCENARIO_DISPLAY_CD,
ATTRIBUTE_DISPLAY_CD FROM VW_ACTUAL_LEDGER_DATA] is generated


[Thu Jul 20 18:09:33 2017]Local/<app>/BSP/admin@Native Directory/48/Info(1021043)
Connection has been established
.
.
.
[Thu Jul 20 18:09:37 2017]Local/<app>/BSP/admin@Native Directory/48/Warning(1003035)
No data values modified by load of this data file


When you check the view VW_ACTUAL_LEDGER_DATA, no data is found.

You can run the load successfully if you manually execute the load functions listed in the log file DBProcsFuncs_PAttrs_Call.log, one by one.  The view is loaded
successfully and log entries are made in FSI_MESSAGE_LOG.

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