After Apply PUM Image 20 PO_POCREATE Abends at PO_POCREATE.PB4800.STEP06
(Doc ID 2237676.1)
Last updated on FEBRUARY 04, 2019
Applies to:PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.
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.
"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 "
ABENDED at Step PO_POCREATE.PB4800.STEP06 (Action SQL) -- RC = 805
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
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