Reset a Purchase Order From In Process To Incomplete

 How to Set to po incomplete - EBS.

SQL> @poxrespo.sql

Please enter the PO number to reset : 563407

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) Y

Processing STANDARD PO Number: 563407

......................................

Updating PO Status..

Done Approval Processing.

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[ebs@SOUL sql]$