My Oracle Support Banner

PO_POCALC ABENDED at Step PO_CMPRICE.PR1000.ISRTPRW3 When Multiple Requisition is Staged (Doc ID 2417210.1)

Last updated on JUNE 29, 2018

Applies to:

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

Symptoms

Steps to Reproduce the Issue:

1) Create two Purchasing Requisition
2) Stage one of the Req using Requisition Page one at a time using Define PO checked
3) Assign an Existing PO ID
4) Stage the Other Requisition similarly
5) Run the PO_POCALC process error is observed:


File:
e:\pt85606b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:
1725 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native
Client 11.0][SQL Server]Cannot insert duplicate key r ow in object
'dbo.PS_PO_PRC_WRK3_T4' with unique index 'PS_PO_PRC_WRK3_T4'. The
duplicate key value is (150214GBR01000000002611OSHARE
1.00000000GBP2018-05-11 00:00:00.000M Failed SQL stmt: INSERT INTO
PS_PO_PRC_WRK3_T4(PROCESS_INSTANCE , BUSINESS_UNIT , PO_ID , LINE_NBR ,
SCHED_NBR , PO_STG_TYPE , ITM_SETID , CATEGORY_ID , INV_ITEM_ID ,
CONVERSION_RATE , CURRENCY_CD , P O_DT , PRICE_LOC , PRICE_PO ,
PRICE_SETID , PRICE_VENDOR , RT_TYPE , UNIT_OF_MEASURE , QTY_REQ , QTY
_REQ_STD , MERCHANDISE_AMT) SELECT PROCESS_INSTANCE , BUSINESS_UNIT ,
PO_ID , LINE_NBR , SCHED_NBR , PO_STG_TYPE , ITM_SETID , CATEGORY_ID ,
INV_ITEM_ID , CONVERSION_RATE , CURRENCY_CD , PO_DT , PRICE

Process 150214 ABENDED at Step PO_CMPRICE.PR1000.ISRTPRW3 (SQL) -- RC = 805 150214 PO_CMPRICE PR1000 ISRTPRW3 SQL 805

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.