This content has been marked as final.
Show 4 replies
-
1. Re: How to Change a PO from Finally Closed back to Approved
628428 Jun 2, 2008 2:45 AM (in response to 618075)No. You cannot reopen a finally closed PO using control actions (Note:225217.1). You may request for a script from support.
Thanks
Nagamohan -
2. Re: How to Change a PO from Finally Closed back to Approved
Matt Rasmussen Jun 3, 2008 2:30 PM (in response to 618075)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'); -
3. Re: How to Change a PO from Finally Closed back to Approved
618075 Jun 3, 2008 9:33 PM (in response to Matt Rasmussen)Hi Mat,
Greatly appreciate the following steps.
And yes will perform in test. Ive already been burned trying to place a setup in prd. -
4. Re: How to Change a PO from Finally Closed back to Approved
618075 Jun 3, 2008 9:35 PM (in response to 628428)Hi Nagamohan,
Thanks for the info!