My Oracle Support Banner

PO_POCALC Abended At Step PO_POCALC.VS9200.UPDSTGU (Doc ID 2449823.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms



PO_POCALC Abended at Step PO_POCALC.VS9200.UPDSTGU

When an item with two UOM Price Attributes having the same Effective Date, but different Minimum Quantity in the PS_ITM_VNDR_UOM_PR table, and if that item is used in a requisition and run PO_POCALC, the process will end up in error indicating the error below.






Error:
- 13:33:27.298 Process 10288945 ABENDED at Step PO_POCALC.VS9200.UPDSTGU (Action SQL) -- RC = 1427
ROLLBACK
/
-- 13:33:27.316 SQL Error: ORA-01427: single-row subquery returns more than one row



The issue can be reproduced at will with the following steps:
1. Create an item with two UOM Price Attributes having the same Effective Date, but different Minimum Quantity in the PS_ITM_VNDR_UOM_PR table
2. Create a requisition
3. Run Auto Sourcing


Due to this issue, users cannot use item with item with two UOM Price Attributes having the same Effective Date, but different Minimum Quantity in the PS_ITM_VNDR_UOM_PR table in Purchasing Business Process.

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.