How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases
These scripts allow the user to resubmit the document for approval by resetting the authorization status when documents are stuck in 'In-Process' or 'Pre-Approved' statuses.
The scripts are:
poxrespo.sql - to reset Standard, Blanket, Planned and Contract purchase orders
poresrel.sql - to reset Blanket and scheduled releases
poresreq.sql - to reset Internal and purchase requisitions
In order to obtain the scripts apply the proper patch. The scripts will be available in the $PO_TOP/sql directory.
It is strongly encouraged to use these reset scripts where there are single (or few) occurrences of documents getting stuck. It is not necessary to submit a Service Request for authorized use of these scripts and if any issues arise after proper use of one of the reset scripts the issues will be fully supported by Oracle Support. Often where there are single occurrences that cannot be replicated, root
cause investigations cannot be performed. But if there are continued repetitive occurrence of such issues, then these should be reported to Oracle Support.
Doc ID 390023.1
