PO Close Short (PO_CLSSHORT) Populates CHNG_DTTM Incorrectly in Change Order Tables (Doc ID 1447578.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

PO Close Short (PO_CLSSHORT) populates CHNG_RQST.CHNG_DTTM and CHNG_RQST_DTL.CHNG_DTTM with different values. This causes a couple of issues when the PO Change Process (PO_POCHNG) runs.

1) PO Change Process (PO_POCHNG) does not update CHNG_RQST.PO_UPDATED to P when the Close Short process is done.  Because of this, every time PO change process runs, those lines get picked up again and again but go nowhere.  Over time, as the volume increases, it will impact the performance of the program.

2) If you run PO Close Short and PO Change processes while a PO is on Hold, PS_CHNG_RQST_DTL.CHG_PROCESS_STATUS will be P (In Process).  If you then take off the Hold and re-run the PO Close Short process, it will not process the change order.


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