HOW TO INCOMPLETE A PO THAT IS IN PROCESS
applying the patch 19254890:R12.PO.D. no need to apply the patch. just run poxrespo.sql as below can incomplete the PO
sqlplus apps/apps @poxrespo.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Mar 30 14:38:34 2017
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Please enter the PO number to reset : 1408
Please enter the organization id to which the PO belongs (Default NULL) : 102
Do you want to delete the action history since the last approval ? (Y/N) N
Processing STANDARD PO Number: 1408
......................................
Aborting Workflow...
Updating PO Status..
Done Approval Processing.
document reset successfully
please COMMIT data
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Mar 30 14:38:34 2017
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Please enter the PO number to reset : 1408
Please enter the organization id to which the PO belongs (Default NULL) : 102
Do you want to delete the action history since the last approval ? (Y/N) N
Processing STANDARD PO Number: 1408
......................................
Aborting Workflow...
Updating PO Status..
Done Approval Processing.
document reset successfully
please COMMIT data
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
No comments:
Post a Comment