Quick Source Requisition Abended at Step PO_POCALC.VS9200.UPDSTGU (Doc ID 2088011.1)

Last updated on AUGUST 17, 2017

Applies to:

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

Symptoms

Quick Source Requisition ABENDED at Step PO_POCALC.VS9200.UPDSTGU when issue an eProcurement requisition created for an item with two UOM Price Attributes having the same Effective Date, but different Minimum Quantity and Qty Recv Tolerance % in the Item Vendor UOM.


ERROR
-----------------------
File: e:\pt85416b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 64 Return: 1427 - ORA-01427: single-row subquery returns more than one row Failed SQL stmt: UPDATE PS_PO_STG_UD_T4 SET PS_PO_STG_UD_T4.QTY_RECV_TOL_PCT = ( SELECT A.QTY_RECV_T OL_PCT FROM PS_ITM_VNDR_UOM_PR A WHERE A.INV_ITEM_ID = PS_PO_STG_UD_T4.INV_ITEM_ID AND A.SETID = PS_ PO_STG_UD_T4.ITM_SETID AND A.UNIT_OF_MEASURE = PS_PO_STG_UD_T4.UNIT_OF_MEASURE AND A.VENDOR_SETID = PS_PO_STG_UD_T4.VENDOR_SETID AND A.VENDOR_ID = PS_PO_STG_UD_T4.VENDOR_ID AND A.VNDR_LOC= PS_PO_STG_U D_T4.VNDR_LOC AND A.CURRENCY_CD = PS_PO_STG_UD_T4.CURRENCY_CD AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(V2.EFFDT) FROM PS_ITM_VNDR_UOM_PR V2 WHERE V2.SETID = A.SETID AND V2.INV_ITEM_ID = A.INV _ITEM_ID AND V2.VENDOR_SETID = A.VENDOR_SETID AND V2.VENDOR_ID = A.VENDOR_ID AND V2.VNDR_LOC = A.VND
Process 13184 ABENDED at Step PO_POCALC.VS9200.UPDSTGU (SQL) -- RC = 1427


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Setup Steps:
------------------------
1. Item setup
Need to have an Item Code with one UOM but two different prices with the same Effective Date defined in the Item Vendor - UOM Price of Attributes, but different Minimum Quantity and Qty Recv Tolerance %.

Replication Steps
------------------------
1) Create ePro Requisition with the setup item id and then run Quick Source requisition process.
2) Click on Modify Line shipping Account and load values from Default and then click on select <All Distribution Lines> then click on line details.
3) Calculate Price = N
4) Click on Save and Submit
5) Run the Quick Source Requisition Process that is finishing with No Success and error mentioned above

6) Run results will show the below stage status an notice the Stage Status is <Ready to Create>

>>>



Changes

 

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