Dimension Loader Fn_drmDataLoader Fails But Oracle Error Not Output to FSI_MESSAGE_LOG (Doc ID 1682492.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 5.2 to 6.1.0.3 [Release 5 to 6]
Oracle Financial Services Profitability Management - Version 5.2 to 6.1.0.3 [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 6.1.0.3 [Release 5 to 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

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:

[10207] Error occurred during execution of Stored Procedure
[10200] 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).

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