Script to Open the Finally Closed Purchase Order in Oracle Apps. How to Open the Finally Closed PO in Oracle

Script to Open the Finally Closed Purchase Order in Oracle Apps. How to Open the Finally Closed PO in Oracle

In this post, We will de discuss about, how we can open the Finally closed Purchase order in oracle apps. In Oracle apps, we can open the closed order any time but to open the finally closed order is not possible from front end application. Finally Closed means, In future there will be no change in this PO so System does not allow to open that PO in oracle apps but on the other hand Closed PO , we can open any time because for closed PO , system allows us to do edit. So to open any Finally closed Purchase order, We need to use some SQL scripts, which will help to open the PO again and then we can do add some line or some changes in the existing PO.

3 Important Tables who Stores PO Status

 PO_LINE_LOCATIONS_ALL

 PO_LINES_ALL

 PO_HEADERS_ALL

All there above three tables stores the PO status and Line Status in the Closed_Code column in oracle apps. But there are some other columns too , which we need to update form back end to open the Finally closed PO.

Script to Open the Finally closed Purchase Order (PO).

Script 1:-

update po_line_locations_all

set closed_code='',

    closed_date='',

    CLOSED_FLAG='N'

where po_header_id=33444

and   po_line_id=322222

and   org_id= 83;

Script 2:-

update po_lines_all

set closed_code='',

    closed_date='',

    CLOSED_FLAG='N'

where po_header_id=33444

and   po_line_id=322222

and   org_id= 83;

Script 3:-

update po_headers_all

set closed_code='',

    closed_date=''   

where po_header_id=33444

and   org_id= 83;

Detail PL SQL script to run all the scripts in One Go

Begin

update po_line_locations_all

set closed_code='',

    closed_date='',

    CLOSED_FLAG='N'

where po_header_id=33444

and   po_line_id=322222

and   org_id= 83;

update po_lines_all

set closed_code='',

    closed_date='',

    CLOSED_FLAG='N'

where po_header_id=33444

and   po_line_id=322222

and   org_id= 83;

update po_headers_all

set closed_code='',

    closed_date=''   

where po_header_id=33444

and   org_id= 83;

commit;

end;