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