How to Change a PO from Finally Closed back to Approved

No. You cannot reopen a finally closed PO using control actions (Note:225217.1). You may request for a script from support.

Thanks
Nagamohan

As already noted, there is no functional way to do this. In your scenario, the user would have to recreate the PO. If you really, really, really don't want to recreate the PO (hey, there are times...) you can use the code below. You may need to change the object_sub_type_code based on your PO that needs to be fixed. Always perform these in test system first to verify the effects!

update     po_headers_all

set     closed_code = 'OPEN',

     authorization_status = 'REQUIRES REAPPROVAL'

     approved_flag = 'R',

     wf_item_type  = NULL,

     wf_item_key   = NULL

where     po_header_id  = 62170;



update     po_action_history

set     action_code = 'NO ACTION',

     action_date = trunc(sysdate),

     note        = 'updated by reset script on '||to_char(trunc(sysdate))

where     object_id   = 62170 --po_header_id 

and     object_type_code = 'PO'

and     object_sub_type_code in ('STANDARD','PLANNED');