Hierarchy Loader FN_DRMDATALOADER Failed with ORA-01422 After Language Pack Installation
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
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.
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