PO_RECVLOAD Getting ORA-01427: Single-row Subquery Returns More Than One Row (Doc ID 1925724.1)

Last updated on JUNE 01, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

In Purchasing while running the PO_RECVLOAD process,

Error occurs when a multiple line PO is entered with at least one line being for an item that is serial controlled. When the PO is received receiving both lines and having multiple serial ids on the one line, the error is thrown.


ERROR
-----------------------

PO_RECVLOAD getting ORA-01427: single-row subquery returns more than one row. Problem in PO_RECVLOAD.INSRECV.STEP030B) (SQL)

Process 25883 ABENDED at Step PO_RECVLOAD.INSRECV.STEP030B (SQL) -- RC = 1427


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a PO for 2 lines with one line having Non controlled item and other line having Asset item with serial control
2. Dispatch the PO
3. Use the 0104 Transaction to receive PO for line 1
4. Use the 0104 Transaction to receive PO for Line 2
5. Use the 0105 Transaction to end PO receiving
6. Run PO_RECVLOAD process



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