AR Period Cannot Be Closed Even The Unposted Items Report Is Empty

最新推荐文章于 2023-05-10 17:13:47 发布

feixiangVB

最新推荐文章于 2023-05-10 17:13:47 发布

阅读量8.3k

点赞数

分类专栏： ORACLE ERP 文章标签： report application date file output transactions

本文链接：https://blog.csdn.net/feixiangvb/article/details/4393683

版权

在使用现金基础会计方法时，出现不能关闭会计期间的问题，即使未记账项目报告为空。错误提示包括APP-AR-11332。此问题可能由Bug 2189383引起，导致AR_MISC_CASH_DISTRIBUTIONS表中存在孤儿记录。解决方案包括运行特定SQL脚本来检查和修复此问题，并提供两个独立补丁2202643和2200713。此外，提供了创建ar_distributions_all表缺失记录的脚本create_dists_for_ra.sql，成功应用后可以正常关闭会计期间。

摘要由CSDN通过智能技术生成

Oracle Receivables 11.5.10.2

ARXSUMPS - Open/Close Accounting Periods
fact: System Option: Accounting Method "Cash Basis"
symptom: APP-AR-11332 You must post all transactions in this period before you close it
symptom: Period cannot be closed in AR
symptom: There are no unposted items on the Unposted Items report.
cause: This could be Bug 2189383:

If you are using "Cash Basis" accounting deletion of zero amount
receipts causes orphan records in table AR_MISC_CASH_DISTRIBUTIONS.
These records remain unposted and you are not able to close the period.

Please run following script to verify this issue:

select org_id,cash_receipt_id,amount,gl_date,posting_control_id pid
from ar_misc_cash_distributions_all dist
where not exists
(select 'x' from ar_cash_receipts_all cash
where cash.cash_receipt_id=dist.cash_receipt_id)
/
fix:

This is fixed in ARREMT2B.pls-115.8 included in Minipack AR.J (2182030).

There are two standalone patches available:
2202643 can be applied on AR.D.
2200713 can be applied on AR.H.

To obtain a datafix please log an iTar with Oracle Support including the output
of the above script.

For this issue, I submit a SR:7529606.992 Cann't close the period Feb-09 in Receivables module

(1) Oracle support provide sql script to analyse this issue

i) select org_id,adjustment_id,gl_date,posting_control_id,postable,
status from ar_adjustments_all
where gl_date between '&start' and '&end'
and status = 'A'
and posting_control_id = -3;

ii)
select cash_receipt_id,gl_date,status,amount_applied,
application_typ