My Oracle Support Banner

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.

Symptoms

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:

exec mo_global.set_policy_context('S','&enter_org_id');

Run the Query:

select distinct ra.cash_receipt_id,
xe.event_id,
xe.event_date,
xah.event_type_code,
xah.gl_transfer_status_code
from ar_receivable_applications ra,
xla_events xe,
xla_ae_headers xah
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)) )
from ar_distributions
where source_table = 'RA'
and source_id = ra.receivable_application_id
)
order by ra.cash_receipt_id, xe.event_id;

 

Cause

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
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.