BSP 'Load Ledger Data into ESSBASE' Program Fails to Load Any Data
Last updated on SEPTEMBER 13, 2017
Applies to:Oracle Financial Services Balance Sheet Planning - Version 188.8.131.52.9 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Balance Sheet Planning (BSP) 184.108.40.206.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,
PRODUCT_ID || '_CCOA',
STRATEGY_ID || '_ST',
CUSTOM1 || '_CS1',
CUSTOM2 || '_CS2',
ORG_UNIT_ID || '_ORGN',
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.
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