Error. getDimensionDetails ORA-01403: no data found Errors Running the drmdataloader (Doc ID 1569987.1)

Last updated on JULY 06, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On OFSAAI 7.3.2.2, when we try load dimension members from STG__INTF staging tables using the FN_DRMDATALOADER for a user defined dimension DIM_ACCT_MNGR, the following errors are received in FSI_MESSAGE_LOG:

ERROR
Starting DRM Dimension Loader
Error. getDimensionDetails ORA-01403: no data found
Error. Check details for dimension 8 in FSI_DIM_LOADER_SETUP_DETAILS table.

STEPS
The issue can be reproduced at will with the following steps:

1. Populate STG__B_INTF, STG__TL_INTF, STG__ATTR_INTF,STG__HIER_INTF.
2. Go to OPERATIONS>Batch Maintenace
3. Create a batch with a new task that uses the following

Component: TRANSFORM DATA
Rule Name: FN_DRMDATALOADER
Parameter list: 8, 'Y'

4. Execute the batch
5. Check FSI_MESSAGE_LOG for errors.

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