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.
Thanks & Regards,
S.Grace Paul Regan
+965-97100377
