Pages

Monday, December 9, 2013

Purchase Order (PO) and Purchase Requisition (PR) reset script.

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:

Anonymous said...

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

fusionscm said...

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