My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

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, 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 Maintenance
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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.