My Oracle Support Banner

Had to Cancel a PO_PORECON process; Need Instructions / Guidance on how to Clean up Records (Doc ID 2244706.1)

Last updated on JULY 21, 2020

Applies to:

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

Goal

Had to Cancel a PO_PORECON job; need instructions / guidance on how to clean up records

Due to a performance issue on our production system, a decision was made to CANCEL a running PO_PORECON job. This was done via the Process Monitor within the PIA and by pressing the Cancel radio button.

 The job cancelled. However, we now have records in our PS_PO_HDR, LINE, SHIP , DISTRIB tables with the process_instance = , in_process_flg = 'Y' ( and 'N' ) , and the PO_STATUS <> 'C' (cancelled / closed ).

And these records are matched to the PS_PO_RC_HDR , LINE , DIST, SHIP tables.

We need guidance on how to rectify the differences . Some of the PO's should be candidates for closure and should be closed . Some get locked by the process and then released at the very end.

We need to be able to sort out what / how to get back to a state where PO_PORECON can be turned on again and are confident that the production PO_HDR , etc. tables have the correct statuses.

Any guidance or reference to an Oracle document is greatly appreciated.
 

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.