PO: Finally close error

最新推荐文章于 2024-11-05 16:39:53 发布

原创最新推荐文章于 2024-11-05 16:39:53 发布 · 745 阅读

0 ·

CC 4.0 BY-SA版权

Oracle EBS PO 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了解决在尝试最终关闭采购订单（PO）时遇到的系统错误的方法。当存在未验证的发票时，系统会阻止PO的最终关闭。文章提供了一个SQL查询来查找这些未验证的发票，并建议在尝试关闭PO之前先验证这些发票。

今天发现用户在在PO做finally close时候报错:

Error: You cannot finally close this purchase order because there are outstanding invoices and/or credit memos

metalink上有对此的解释：

cause: Issue was caused by invalid data. Some invoice lines were not validated.

This is a valid system error if invoices that are not validated are matched to the PO user is trying to finally close.

Action should be taken to validate these invoices before attempting to finally close the PO.

如何后台查找没有验证的invoice：

SELECT ai.invoice_id, ai.invoice_num
FROM po_headers_all               ph,
       po_distributions_all         pd,
       po_releases_all              pr,
       ap_invoice_distributions_all aid,
       ap_invoices_all              ai
WHERE ph.po_header_id = &po_header_id
   AND ph.po_header_id = pd.po_header_id
   AND pd.po_release_id = pr.po_release_id(+)
   AND pd.po_distribution_id = aid.po_distribution_id
   AND aid.invoice_id = ai.invoice_id
   AND (exists (select 'hold'
                  from ap_holds_all ah
                 where ai.invoice_id = ah.invoice_id
                   AND ah.release_lookup_code is null) OR exists
        (select 'unvalidated dist'
           from ap_invoice_distributions_all aid2
          where ai.invoice_id = aid2.invoice_id
            and nvl(aid2.match_status_flag, 'N') <> 'A'));