Error. getDimensionDetails ORA-01403: no data found Errors Running the drmdataloader
Last updated on JULY 06, 2015
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 184.108.40.206 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
On OFSAAI 220.127.116.11, 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:
Starting DRM Dimension Loader
Error. getDimensionDetails ORA-01403: no data found
Error. Check details for dimension 8 in FSI_DIM_LOADER_SETUP_DETAILS table.
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.
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