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> exitRegards,
Bahaa Barghouti
Post a Comment