OGL EPF: Hierarchy Rule Error: Process Registration Has Failed & ORA-01422 on Sub Account (Doc ID 739600.1)

Last updated on OCTOBER 28, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10 to 12.0.5
This problem can occur on any platform.
GL EPF Integration

Symptoms

In Enterprise Performance Foundation Administrator (FEM), when running a General Ledger (GL) Hierarchy transfer rule on Sub Account, the rule ends in an error and the following message is in the View Log:

Process Registration has failed.

If you run the Hierarchy Rule with FND: Debug on, the following error is in the fnd_log_messages table:

Unexpected error has occurred: ORA-01422: exact fetch returns more than requested number of rows.
Please contact your system administrator.

The Sub Account dimension is mapped to the Sub Account General Ledger segment.  This segment has a Value Set with a Dependent validation type.  It is dependent on the Account segment.

Steps to replicate:

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