AR_00010 Receipt Application or Credit Memo Application: Unable to Apply Cash to Invoice/Credit Memo/Bills Receivables
(Doc ID 1564440.1)
Last updated on MAY 01, 2018
Applies to:Oracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
Applying Receipts, Credit Memos or Adjustments against Invoice and receive the following error:
This Action Has Been Blocked To Avoid Inaccurate Accounting Entries
The distributions are not proper for data in AR_RECEIVABLE_APPLICATIONS_ALL
The record does not save if the Invoice data in RECEIVABLE_APPLICATIONS_ALL is not in sync with data in AR_DISTRIBUTIONS.
Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Transactions > Transactions
Case 1 - Create an Invoice with line, tax (overapply flag=Y):
Adjust the Invoice line or tax amount to zero (eg. Invoice adjustment)
Apply a Receipt against the invoice.
The corrupt record, which has distribution data, is not in sync with receivable application data, but is found to be posted to GL using the following query:
Set Org Context:
Run the Query:
from ar_receivable_applications ra,
where ra.application_type = 'CASH'
and ra.cash_receipt_id = ra.cash_receipt_id
and ra.gl_date between '&enter_start_gl_date' and '&enter_end_gl_date'
and ra.event_id = xe.event_id
and ra.gl_date = xe.event_date
and xe.application_id = 222
and xe.event_id = xah.event_id
and xe.application_id = xah.application_id
and ra.set_of_books_id = xah.ledger_id
and ra.status = 'APP'
and xe.event_status_code = 'P'
and xe.process_status_code = 'P'
and abs(ra.amount_applied) <> (
select abs( sum(nvl(amount_dr, 0)) - sum(nvl(amount_cr, 0)) )
where source_table = 'RA'
and source_id = ra.receivable_application_id
order by ra.cash_receipt_id, xe.event_id;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|1. Bug Summary|
|2. Fixed Files|
|3. Recommended Patches|
|4. Solution Steps|