Hierarchy Loader FN_DRMDATALOADER Failed with ORA-01422 After Language Pack Installation
(Doc ID 2083859.1)
Last updated on FEBRUARY 03, 2019
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
After installing the language pack on ofsaa 8.0, hierarchy loader FN_DRMDATALOADER failed with the following error.
ORA-01422 exact fetch returns more than one requested number of rows
Error. Duplicate Hierarchy found. MY HIERARCHY
1. Run FN_DRMDATALOADER successfully
2. Apply the language pack
3. FN_DRMDATALOADER failed with duplicate hierarchy message 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