PO_AUTO_SRC failed with: ABENDED at Step PO_CMPRICE.MAIN.RATEMULT (SQL) -- RC = 1427 (Doc ID 2241871.1)

Last updated on MARCH 14, 2017

Applies to:

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

Symptoms

PO_AUTO_SRC is failing with the following error when running the sourcing process for requisition with an Open Item Reference Contract.

ERROR:

Process 42891 ABENDED at Step PO_CMPRICE.MAIN.RATEMULT (SQL) -- RC = 1427
42891 PO_CMPRICE MAIN RATEMULT SQL 1427

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 48 Return: 14 27 - ORA-01427: single-row subquery returns more than one row Failed SQL stmt: UPDATE PS_PO_PRC_WRK1_T4 SET CNTRCT_RATE_MULT=( SELECT C.CNTRCT_RATE_MULT FROM PS_P O_CNTRCT_L2T4 C WHERE C.PROCESS_INSTANCE = PS_PO_PRC_WRK1_T4.PROCESS_INSTANCE AND C.BUSINESS_UNIT = PS_PO_PRC_WRK1_T4.BUSINESS_UNIT AND C.PO_ID = PS_PO_PRC_WRK1_T4.PO_ID AND C.LINE_NBR = PS_PO_PRC_WRK 1_T4.LINE_NBR AND C.SCHED_NBR = PS_PO_PRC_WRK1_T4.SCHED_NBR AND C.PO_STG_TYPE = PS_PO_PRC_WRK1_T4.PO _STG_TYPE AND C.CNTRCT_SETID = PS_PO_PRC_WRK1_T4.CNTRCT_SETID AND C.CNTRCT_ID = PS_PO_PRC_WRK1_T4.CN TRCT_ID AND C.VERSION_NBR = PS_PO_PRC_WRK1_T4.VERSION_NBR AND C.CNTRCT_LINE_NBR = PS_PO_PRC_WRK1_T4. CNTRCT_LINE_NBR AND C.CNTRCT_ID<>' ' ) WHERE PROCESS_INSTANCE = 42891 AND PRICE_COMPL_FLG = 'N' AND
Explain

 

 

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