EBS PO 最终关闭的打开方法

标准功能限定最终关闭后不允许再有后续的业务处理。以下提供非ORACLE标准的更新处理，请知悉：

1、更新可能会带来未知的影响；

2、需要在测试环境先进行测试后，符合业务要求后再在正式环境实施。

--标准采购的恢复方式

1) Find po_header_id:
--gml_po_line_locations_all_t1
select po_header_id 
from po_headers_all 
where segment1 =‘300118‘
and org_id=‘7927‘--‘<the PO number in question>‘; 

2) Update closed_code from FINALLY CLOSED to CLOSED:

a)
update po_headers_all 
set closed_code = ‘CLOSED‘ 
where po_header_id =‘350194‘-- <the po header id from step 1>
and closed_code = ‘FINALLY CLOSED‘ ;

commit;

b) 
update po_lines_all 
set closed_code = ‘CLOSED‘ 
where po_header_id =‘350194‘-- <the po header id from step 1>
and closed_code = ‘FINALLY CLOSED‘;

commit;

c) 
update po_line_locations_all 
set closed_code = ‘CLOSED‘ 
where po_header_id =‘350194‘-- <the po header id from step 1>
and closed_code = ‘FINALLY CLOSED‘;

commit;

d)
delete from po_action_history 
where object_id = ‘350194‘-- <the po header id from step 1> 
and action_code = ‘FINALLY CLOSE‘

commit;

3) Go to Purchasing Order Entry form. Query the PO. Navigate to 
Special -> Control. Open the PO.

--一揽子订单的恢复方式

1. 获取发放id

--BPA NUMBER:2300001341-83  2300001341-84
--RELEASE_ID: 2166316        2179507
SELECT Pra.*
  FROM Po_Headers_All  Pha
      ,Po_Releases_All Pra
 WHERE Pha.Segment1 = '2300001341'
   AND Pha.Po_Header_Id = Pra.Po_Header_Id
   AND Pra.Release_Num = '84';

2. 修改发放头和发放行信息

UPDATE Po_Releases_All Pra
   SET Pra.Closed_Code = 'CLOSED'
 WHERE Pra.Po_Release_Id in (2166316,2179507);
 

UPDATE Po_Line_Locations_All plla
   SET Closed_Code = 'CLOSED'
 WHERE plla.po_release_id  in (2166316,2179507);

3. 更新审批记录

select * from Po_Action_History t where t.object_id = 2365067 and t.object_sub_type_code = 'BLANKET';

--是否修改审批记录都不会影响业务操作

以上请参考。谢谢！