My Oracle Support Banner

PAXINRVW: When Trying to Review Invoice Lines, Get Error "ORA-01427: Single-row Subquery Returns More Than One Row" (Doc ID 1569044.1)

Last updated on DECEMBER 12, 2024

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In the Invoice Review form, when attempting to review invoice lines, get the following error:

 

Steps
=====
1. Login to a Projects responsibility.

2. Navigate to: Billing > Invoice Review.

3. Query an existing draft invoice number.

4. Click the 'Lines' button to view the invoice lines, get error:

     "ORA-01427 Single-row sub query returns more than one row"

 

Changes

Upgraded to 12.1.3

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.