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 [Release 11.5]
Information in this document applies to any platform.
Checked for relevance 2-May-2012


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 


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