'Cannot Delete a Member Which is Used in a Hierarchy' in OFSAA 5.5 and Lower Versions
Last updated on DECEMBER 18, 2015
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.
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