My Oracle Support Banner

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

Last updated on MAY 01, 2023

Applies to:

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


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.


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


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




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

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