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:

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

Changes

Cause

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