My Oracle Support Banner

'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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.