PO_DISPATCH Abends at Step PO_DISPATCH.MAIN.Step09 (PeopleCode) -- RC = 8 (108,5) Due to Duplicate COMMENT_ID (Doc ID 1965870.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

PO_DISPATCH abends when dispatching Purchase Orders that have duplicate PO_COMMENTS.COMMENT_ID values.  This will happen when the Purchase Order is created from a predecessor document such as a Requisition, RFQ or Contract that has multiple header comments.

Error
PO_DISPATCH Abends at Step PO_DISPATCH.MAIN.Step09 (PeopleCode) -- RC = 8 (108,5)

SQL error in Exec. (2,280) PO_DISPATCH.PO_Dispatch_Data.OnExecute
Name:getHDRComments PCPC:9087 Statement:163
Called from:PO_DISPATCH.PO_Dispatch_Data.OnExecute Name:fillHeader
Statement:307
Called from:PO_DISPATCH.MAIN.GBL.default.1900-01-01.Step09.OnExecute
Statement:2
2014-12-22-09.12.14.447436 DoStepActions [1853] Exception logged: RC=100.

Process 402739 ABENDED at Step PO_DISPATCH.MAIN.Step09 (PeopleCode) -- RC = 8
(108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
2014-12-22-09.12.14.447608 DoMessageLogError [1043] Exception logged: RC=4.
2014-12-22-09.12.14.447608 ExecuteStep [984] Exception logged: RC=100.
2014-12-22-09.12.14.447608 ExecuteSection [694] Exception logged: RC=100.
2014-12-22-09.12.14.447608 AeExecExecute [319] Exception logged: RC=100.
2014-12-22-09.12.15.446612 ProcessRequest [1738] Exception logged: RC=100.


Replication Steps:
1. Create a Requisition (req) with 2 header comments
2. Source the req to a PO
3. Go to PO header comments, the two from the req will be associated to the PO
4. Edit both of the comments from the req
5. Save the PO and two new rows will be added to the PO_COMMENTS table with the same COMMENT_ID
6. Dispatch the PO via the PO_DISPATCH process



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