'Cannot Delete a Member Which is Used in a Hierarchy' in OFSAA 5.5 and Lower Versions
(Doc ID 1519254.1)
Last updated on APRIL 19, 2021
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 to 7.2.7 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 5.2 to 5.5
In Oracle Financial Services Analytical Applications (OFSAA) 5.5 and lower versions, when you run the dimension loader, fn_drmDataLoader, to load new members into a Dimension, the following error message is output to FSI_MESSAGE_LOG:
Error. Cannot delete a member which is used in a hierarchy
This error prevents you from loading the dimension members into Dimension Management successfully.
Note: When defining the Batch, your task uses parameters of (<dimension_id>,'N'). So, the load process should not be trying to delete any members. It should only delete existing members when parameters of (<dimension_id>,'Y') are used.
Steps to Reproduce:
1. Populate the Dimension Loader interface tables (ex. STG_ORG_UNIT_B_INTF, STG_ORG_UNIT_TL_INTF, STG_ORG_UNIT_ATTR_INTF, and STG_ORG_UNIT_HIER_INTF)
2. Go to Operations > Batch Maintenance
3. Create a new Batch
4. Create a Task under the new batch with the following options:
Component = TRANSFORM DATA
Rule Name = fn_drmDataLoader
Parameter List = 1, 'N'
5. Go to Operations > Batch Execution
6. Run the Batch
The batch fails and the error appears in FSI_MESSAGE_LOG.
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