Hierarchy Loader FN_DRMDATALOADER Failed with ORA-01422 After Language Pack Installation (Doc ID 2083859.1)

Last updated on NOVEMBER 30, 2015

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications

Symptoms

After installing the language pack on ofsaa 8.0, hierarchy loader FN_DRMDATALOADER failed with the following error.

Error:
ORA-01422 exact fetch returns more than one requested number of rows
Error. Duplicate Hierarchy found. MY HIERARCHY


Steps:
1. Run FN_DRMDATALOADER successfully
2. Apply the language pack
3. FN_DRMDATALOADER failed with duplicate hierarchy message 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