Error Cannot Delete A Member Used In Hierarchy Running Stg_dimension_loader (Doc ID 1448133.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)


Symptoms

On : 7.3 version, Install and Upgrade Issues

When attempting to run stg_dimension_loader to update organization hierarchy the following error occurs.

ERROR
-----------------------
FSI_DIM_LOADER_SETUP_DETAILS shows the following:
Dimension Loading Error
Check FSI_MESSAGE_LOG Failed

FSI_MESSAGE_LOG shows:
Error. Cannot delete a member which is used in a hierarchy

STEPS
-----------------------
1. Run stg_dimension_loader.
2. Check DIM_ORG_UNIT_B table the org unit is not updated.
3. Found error 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