Wednesday, 23 October 2013

Re-open the finally closed po in Oracle R12 /11i

Query for re-open the finally closed PO in Oracle R12/11i

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');


No comments:

Post a Comment