ORA-01427 Aggregating from a Transaction Table to an Account Table Using a Mapping Rule (Doc ID 365785.1)

Last updated on DECEMBER 02, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
Oracle Profitability Manager - Version: 11.5.10
This problem can occur on any platform.
FEM

Symptoms

In the Profitability Manager responsibility, when running a "Simple Source On Allocation" Mapping Rule that takes records from a transaction table and aggregates them to an account table, the following error occurs in the "View Output" log:

APP-FEM-416921: Failed to register chain for object 11615 and request 251103.
APP-FND-01564: ORACLE error 1427 in drv_upi

Cause: drv_upi failed due to ORA-01427: single-row subquery returns more than one row

The SQL statement being executed at the time of the error is an UPDATE against the account table.

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