Collecting Invoices Errors With ORA-01427: iSngle-row Subquery Returns More Than One Row (Doc ID 754881.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Incentive Compensation - Version 11.5.8 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance 2-May-2012


Symptoms

When running Collections the following error is encountered:

CN_COLLECT_INVOICES module: Collect Invoices 
+---------------------------------------------------------------------------+ 

Current system time is 20-NOV-2008 14:04:57 

+---------------------------------------------------------------------------+ 

**Starts**20-NOV-2008 14:04:57 
ORACLE error 1427 in FDPSTP 

Cause: FDPSTP failed due to ORA-01427: single-row subquery returns more than 
one row 
ORA-06512: at "APPS.CN_COLLECT_INVOICES_322", line 513 
ORA-06512: at line 1 
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1118 

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