TriniDBA

Problem: Some purchase orders are stuck in the “In Process” status. How do I reset these purchase orders?

Solution: Refer to How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases (Doc ID 390023.1)

Referring to the above My Oracle Support document, apply patch 9707155:R12.PO.B to the instance. The patch places a number of reset scripts (poxrespo.sql, poresrel.sql and poresreq.sql) in the $PO_TOP/sql. To reset the stuck purchase orders, source the application tier environment and run the poxrespo.sql script in SQL*Plus as follows:

bash-3.00$ sqlplus apps/xxxxxxx @ poxrespo.sql

SQL*Plus: Release 10.1.0.5.0 - Production on Tue Dec 2 16:32:07 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options



Please enter the PO number to reset : 408161
Please enter the organization id to which the PO belongs (Default NULL) : 82
Do you want to delete the action history since the last approval ? (Y/N) N

Processing STANDARD PO Number: 408161
......................................
Aborting Workflow...
Updating PO Status..
Done Approval Processing.

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL>