APP-SQLAP-97198 ：您不能匹配此销售订单发运，因为已关闭。【解决方案】

sunyukun8888

MATELINK 方案：

CauseThis is the system as designed to work.  

Finally Close Purchase Order shipment, prevents modifications to the purchase order.  

When you finally close at one level then all sublevels are also finally closed.

No further actions can be performed against a purchase order level that is finally closed.

If Profile Option 'Show Finally Closed POs' is set to No, then during invoice entry Payables does not display purchase orders that are finally closed.
If the profile option is set to Yes then Payables displays these purchase orders but you can’t match to them.

This is described in:
Payables User's Guide-  Invoices 4 – 85
Oracle Purchasing User's Guide - Approval, Security, and Control 2 – 63
SolutionIf an invoice is matched to a purchase order shipment that then becomes finally closed before validation of the invoice, Invoice Validation applies a Finally Closed PO hold on the invoice.
You cannot manually release this hold.
You must reverse the match in the Distributions/Discard the Matched Invoice Line window and resubmit Invoice Validation to release this hold. You can then match the invoice to a different purchase order or enter distributions manually.
Note: If you encounter issues discarding the matched lines please see Doc ID 1447955.1

WorkaroundPlease consider to apply the following workaround in your test instance and only if encumbrance is not setup up.

• Create manual adjustment journals in GL to settle the accrual accounting entries for the concerned POs. (Please review the Oracle Purchasing User's Guide, Overview of Receipt Accounting.)
• Create a new Purchase Order.
• Match the invoice to the new PO.
  

我的处理方案：

/***********************************************************************
sunyukun at 2013-6-20
注意： 1、 修改前做好相关备份
  
       2、 尽量拿一个类似数据进行比对着修改  
      
       3、 本测试是在 R12.0.4 版本测试通过的，应该也使用 11I
***********************************************************************/
-- 修改前备份修改数据
create table bak.po_headers_all130620 as
select * from po.po_headers_all h where h.segment1 =&po_number;
--- 根据注释修改相关列
select h.org_id,
       h.po_header_id,
       h.last_update_date,
       h.last_updated_by,
       h.last_update_login,
       h.closed_code, --修改为大写 OPEN
       h.closed_date --修改成null
  from po.po_headers_all h
where h.segment1 =&po_number
   for update;
   
-- 修改前备份修改数据
create table bak.po_lines_all130620 as
select * from po.po_lines_all h where h.po_header_id =&po_header_id
--- 根据注释修改相关列
select l.po_line_id,
       l.closed_code, --  修改为大写 OPEN
       l.CLOSED_DATE, --  修改为 空
       l.CLOSED_BY, --  修改为 空
       closed_reason --  修改为 空
  from po.po_lines_all l
where l.po_header_id = &po_header_id
for update
-- PO发运行 修改前备份修改数据
create table bak.po_line_locations_all130620 as
select *
  from po.po_line_locations_all plla
where plla.po_line_id = &po_line_id
--- PO发运行 根据注释修改相关列
select plla.line_location_id,
       closed_code, --修改为大写 OPEN
       closed_reason, --null
       closed_date, --null
       closed_by, --null
       shipment_closed_date, --null
       closed_for_invoice_date --null
  from po.po_line_locations_all plla
where plla.po_line_id =&po_line_id
   for update
--PO分配行  暂时没有做任何修改
select *
  from po.po_distributions_all pda
where pda.line_location_id = &line_location_id
   for update