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 220.127.116.11 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 18.104.22.168, 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:
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 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.
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