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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms