Dimension Loader Fn_drmDataLoader Fails But Oracle Error Not Output to FSI_MESSAGE_LOG
Last updated on NOVEMBER 17, 2016
Applies to:Oracle Financial Services Asset Liability Management - Version 5.2 to 22.214.171.124 [Release 5 to 6]
Oracle Financial Services Profitability Management - Version 5.2 to 126.96.36.199 [Release 5 to 6]
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Oracle Financial Services Funds Transfer Pricing - Version 5.2 to 188.8.131.52 [Release 5 to 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
For Oracle Financial Services Analytical Applications (OFSAA), when you run the Dimension Loader program fn_drmDataLoader (STG_DIMENSION_LOADER), you get a message in the Batch Monitor screen stating the stored procedure failed. However, there are no error messages output to FSI_MESSAGE_LOG explaining why the dimension load failed.
The following messages are output to the Event Log in the Batch Monitor screen for the Batch's Task:
 Error occurred during execution of Stored Procedure
 Step Failure : FN_FSI_DIM_LOADER_1
However, when you check the rows FSI_MESSAGE_LOG for the Batch, there are no error messages. The messages indicate rows are inserted successfully but the dimension data does not exist in the dimension tables (ex. DIM_GENERAL_LEDGER_B, DIM_GENERAL_LEDGER_TL, etc).
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