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
2 comments:
i want to develop concurrent program for poxrespo.sql i have did all step.store file in custom PO top.i am confused about parameter by which name should i pass this parameter to sql and conc program and where should put commit i tried lot.help me
The adaptability of Fusion SCM is impressive! Regardless of the industry or scale of operation, the platform can be tailored to meet specific business needs, making it an ideal solution for organizations of all types. Fusion cloud SCM Training in hyderabad
Post a Comment