Case 00051890 – AR Receivable Application Amount and Accounting Incorrect

AR Receivable Application Amount and Accounting Incorrect

Case Number	00051890
Oracle Module	Accounts Receivable (AR)
EBS Version	R12
Functional Area	Cash Receipts / Receipt Application / Subledger Accounting
Related Patches	None

Symptoms

An AR cash receipt application shows an incorrect applied amount — the amount_applied and associated accounting amounts in AR_RECEIVABLE_APPLICATIONS_ALL do not match expected values.
The corresponding AR_DISTRIBUTIONS_ALL and XLA subledger accounting entries (XLA_AE_LINES, XLA_DISTRIBUTION_LINKS) contain incorrect entered and accounted amounts, including incorrect cross-currency exchange rate amounts.
Orphaned distribution and accounting lines exist that should be removed.

Root Cause

The receipt application process recorded incorrect amounts for amount_applied, line_applied, acctd_amount_applied_to, and the cross-currency exchange rate (trans_to_receipt_rate). The corresponding AR distribution and XLA accounting lines also contain incorrect entered/accounted debit and credit amounts. Additionally, extra distribution and accounting lines were created during the erroneous processing that must be removed.

Resolution

Step 1 – Create backup tables

Run data_fix.sql. Backups are created for:

AR_RECEIVABLE_APPLICATIONS_ALL — for the affected cash receipt ID
AR_DISTRIBUTIONS_ALL — covering all distribution source types (CRH, RA, MCD) for the receipt
XLA_AE_LINES — XLA accounting lines for the AR receipt entity
XLA_DISTRIBUTION_LINKS — XLA distribution links for the receipt event

Step 2 – Correct the receivable application amounts

Update AR_RECEIVABLE_APPLICATIONS_ALL to set the correct amount_applied, line_applied, acctd_amount_applied_to, and trans_to_receipt_rate for the affected receivable application.

Step 3 – Correct the AR distribution amounts

Update AR_DISTRIBUTIONS_ALL to set the correct amount_cr and acctd_amount_cr (and currency_code if applicable) for the affected distribution line.

Step 4 – Correct XLA accounting line amounts

Update XLA_AE_LINES to set corrected entered and accounted debit/credit amounts (entered_cr, accounted_cr, unrounded_entered_cr, unrounded_accounted_cr, entered_dr, accounted_dr, etc.) for the affected accounting lines.

Step 5 – Correct XLA distribution link amounts

Update XLA_DISTRIBUTION_LINKS to set corrected unrounded entered and accounted credit amounts for the affected distribution link.

Step 6 – Delete orphaned distribution and accounting lines

Delete the extra/orphaned records from:

AR_DISTRIBUTIONS_ALL — orphaned distribution line
XLA_AE_LINES — extra accounting lines created during erroneous processing
XLA_DISTRIBUTION_LINKS — orphaned distribution link

Step 7 – Commit and validate

Issue COMMIT. Verify the receipt application balances correctly and the AR aging and accounting reports reflect the corrected amounts.

Script Inventory

File	Description
data_fix.sql	Creates backups; corrects amount_applied, line_applied, acctd_amount_applied_to, and trans_to_receipt_rate in AR_RECEIVABLE_APPLICATIONS_ALL; corrects AR_DISTRIBUTIONS_ALL amounts; corrects XLA_AE_LINES entered/accounted amounts; corrects XLA_DISTRIBUTION_LINKS; deletes orphaned distribution and accounting lines.

Key Tables Affected

Table	Action
AR_RECEIVABLE_APPLICATIONS_ALL	Update amount_applied, line_applied, acctd_amount_applied_to, trans_to_receipt_rate
AR_DISTRIBUTIONS_ALL	Update amount_cr, acctd_amount_cr; delete orphaned rows
XLA_AE_LINES	Update entered/accounted DR/CR amounts; delete orphaned lines
XLA_DISTRIBUTION_LINKS	Update unrounded amounts; delete orphaned link