'Cannot Delete a Member Which is Used in a Hierarchy' in OFSAA 5.5 and Lower Versions

(Doc ID 1519254.1)

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

Symptoms

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.

Cause

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