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