After Apply PUM Image 20 PO_POCREATE Abends at PO_POCREATE.PB4800.STEP06

(Doc ID 2237676.1)

Last updated on APRIL 24, 2017

Applies to:

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

Symptoms

After Apply PUM Image 20 PO_POCREATE Abends at PO_POCREATE.PB4800.STEP06.
PO Create abends with Unique Constraint when Multiples Requisitions have Multiples Distributions lines.

 

According customer:
"Code was changed in PUM 20, To User REQ line fields, but is excluding REQ_ID in the Join, thus causing an incorrect join and duplicate data. Thus unique constraint on table insert.
In Non Prod Env, I added code: AND DST.REQ_ID = D.REQ_ID , is this a viable solution "

ERROR
ABENDED at Step PO_POCREATE.PB4800.STEP06 (Action SQL) -- RC = 805


STEPS
The issue can be reproduced at will with the following steps:
1 - Create requisition 1 amount only - one distribution line
2 - Create requisition 2 amount only - 2 distribution line
3 - Requisition selection. Select 2 requisitions above.
4 - Run PO_POCALC
5 - Run PO_POCREATE


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