Abend Running PV_AUTO_SRC - Single-row Subquery Returns More Than One Row At Step PO_POCREATE.PB8300.UPLNAPPR (Doc ID 2049230.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

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

Symptoms

PV_AUTO_SRC abends with - single-row subquery returns more than one row at Step PO_POCREATE.PB8300.UPLNAPPR

ERROR

File: e:\pt85408c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 62 Return: 1427 - ORA-01427: single-row subquery returns more than one row Failed SQL stmt: UPDATE PS_PO_LINE SET APPR_REQD = 'Y' WHERE BUSINESS_UNIT = ( SELECT DISTINCT H.BUS INESS_UNIT FROM PS_PO_POB_HDR_T4 H , PS_PO_POB_LINE_T4 T WHERE H.PROCESS_INSTANCE = 292647 AND H.PRO CESS_INSTANCE = T.PROCESS_INSTANCE AND H.BUSINESS_UNIT = T.BUSINESS_UNIT AND H.PO_ID = PS_PO_LINE.PO _ID AND H.PO_ID = T.PO_ID) AND EXISTS ( SELECT 'Y' FROM PS_PO_POB_HDR_T4 H , PS_PO_POB_LINE_T4 T WHE RE H.PROCESS_INSTANCE = 292647 AND H.PROCESS_INSTANCE = T.PROCESS_INSTANCE AND H.BUSINESS_UNIT = T.B USINESS_UNIT AND H.PO_ID = T.PO_ID AND H.PO_WF_APPR_NEEDED = 'Y' AND T.PROCESS_INSTANCE = 292647 AND T.BUSINESS_UNIT = PS_PO_LINE.BUSINESS_UNIT AND T.PO_ID = PS_PO_LINE.PO_ID AND T.PO_LINE_NBR = PS_PO

Process 292647 ABENDED at Step PO_POCREATE.PB8300.UPLNAPPR (SQL) -- RC = 1427

STEPS
The issue can be reproduced at will with the following steps:
1. Create req's in different Business Units
2. Be sure the Next PO ID in each Business Unit is the same
3. Run Quick Source for both Business Units

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