My Oracle Support Banner

Single Row Subquery Error PO_POCALC.VS2700.UPDVSVC2 on Quick Source and Expedite Requisitions (Doc ID 2380713.1)

Last updated on APRIL 02, 2018

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When run Expedite Requisition or Quick Source, Single Row Subquery Error at PO_POCALC.VS2700.UPDVSVC2 error is triggered for Requisitions with multiple shipping lines. The Split PO by Ship To option is selected in our Purchase Order definition setup.

Steps to reproduce the issue:


1. Go to eProcurement > Requisition. Create a new Requisition with multiple shipping line.
2. Run Expedite Requisition or Quick Source.
3. Below Error is encountered:

Error:
<<<
File: e:\pt85604d-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:
1725  Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client
11.0][SQL Server]Subquery returned more than 1 value. This is not permitted
when the subquery follows =, !=, <, <= , >, >= or when the subquery i s used
as an expression. [Microsoft][SQL Server Native Client 11.0][SQL Failed SQL
stmt: UPDATE PS_PO_ITM_STG_T5 SET PS_PO_ITM_STG_T5.ITM_ID_VNDR = ( SELECT
PS_PO_SRC_IVND_ T5.ITM_ID_VNDR FROM PS_PO_SRC_IVND_T5 WHERE
PS_PO_ITM_STG_T5.PROCESS_INSTANCE = PS_PO_SRC_IVND_T5.PR OCESS_INSTANCE AND
PS_PO_ITM_STG_T5.BUSINESS_UNIT = PS_PO_SRC_IVND_T5.BUSINESS_UNIT AND
PS_PO_ITM_ST G_T5.INV_ITEM_ID = PS_PO_SRC_IVND_T5.INV_ITEM_ID AND
PS_PO_ITM_STG_T5.VENDOR_ID = PS_PO_SRC_IVND_T5.
 
Process 143206 ABENDED at Step PO_POCALC.VS2700.UPDVSVC2 (SQL) -- RC = 8601
>>>

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.