Resetting Purchase Orders stuck in Pre-Approved status


Problem:Some purchase orders are stuck in the " Pre-Approved " status. How do I reset these purchase orders?

How To Reset a Purchase Order or Requisition From In Process or Pre-Approved (Doc ID 390023.1).
Download patch 21127441 R12.PO.B:
Note:
do not apply rather just extract script poxrespo.sql  and run it individually as a workaround to get past that error. 


sqlplus apps/pass @poxrespo.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Tue May 2 16:32:07 2016
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition
Please enter the PO number to reset : 1122
Please enter the organization id to which the PO belongs (Default NULL) : 81
Do you want to delete the action history since the last approval ? (Y/N) NProcessing STANDARD PO Number: 1122
......................................
Aborting Workflow...
Updating PO Status..
Done Approval Processing.
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> exit
Regards,

Bahaa Barghouti

No comments

2015@Bahaa Barghouti. Powered by Blogger.