Error. getDimensionDetails ORA-01403: no data found Errors Running the drmdataloader
(Doc ID 1569987.1)
Last updated on MAY 24, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2.2 and laterInformation 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.
The issue can be reproduced at will with the following steps:
1. Populate STG_<DIIM>_B_INTF, STG_<DIIM>_TL_INTF, STG_<DIIM>_ATTR_INTF,STG_<DIIM>_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.
Changes
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 |
Changes |
Cause |
Solution |
References |