Case 00035953 – AR Cash Receipt Amount and Posting Incorrect (11i AX)

AR Cash Receipt Amount and Posting Incorrect (11i Global Accounting Engine)

Case Number	00035953
Oracle Module	Accounts Receivable (AR)
EBS Version	11i (Global Accounting Engine / AX)
Functional Area	Cash Receipts / Posting / Global Accounting Engine
Related Patches	None

Symptoms

An AR cash receipt shows an incorrect amount in AR_CASH_RECEIPT_HISTORY_ALL and AR_RECEIVABLE_APPLICATIONS_ALL.
The accounted amounts do not match the expected receipt value.
Posting-related columns (posting_control_id) on receivable application records are set to an unposted value (e.g., -3).
AX subledger journal entries (AX_SLE_LINES) reference the incorrect amount.
The AR payment schedule shows incorrect amount_due_original and amount_due_remaining values.

Root Cause

The cash receipt was created or applied with an incorrect amount, and the associated Global Accounting Engine (AX) subledger entries and AR tables retained the incorrect values. The posting control was either not completed or set to an unposted value, leaving the receivable application in an inconsistent state. This is an 11i-specific issue involving the AX (Global Accounting Engine) subledger architecture.

Resolution

Step 1 – Create backup tables

Run data_fix.sql. Backup tables are created for:

AX_SLE_LINES (subledger journal entry lines)
AR_CASH_RECEIPT_HISTORY_ALL
AX_EVENTS (RECEIPT_INSERT and MISC_INSERT events)
AR_CASH_RECEIPTS_ALL
AR_RECEIVABLE_APPLICATIONS_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_DISTRIBUTIONS_ALL

Step 2 – Correct cash receipt history amounts

Update AR_CASH_RECEIPT_HISTORY_ALL to set the correct amount and ACCTD_AMOUNT.

Step 3 – Correct receivable application amounts

Update AR_RECEIVABLE_APPLICATIONS_ALL:

Set correct amount_applied and acctd_amount_applied_from
Update posting_control_id to clear the unposted flag (-3) for the relevant application

Step 4 – Correct payment schedule amounts

Update AR_PAYMENT_SCHEDULES_ALL to set correct amount_due_original and amount_due_remaining values.

Step 5 – Commit and re-post

Issue COMMIT. Re-run the AR posting process to regenerate correct AX subledger journal entries.

Note: This fix targets an Oracle 11i instance using the Global Accounting Engine (AX). The AX tables (AX_SLE_LINES, AX_EVENTS) are not present in R12 environments.

Script Inventory

File	Description
data_fix.sql	Creates backups for AX and AR tables; corrects cash receipt history amounts; fixes receivable application amounts and posting control; corrects payment schedule balances. Final working version (V2 supersedes earlier iteration).

Key Tables Affected

Table	Action
AR_CASH_RECEIPT_HISTORY_ALL	Update amount, ACCTD_AMOUNT
AR_RECEIVABLE_APPLICATIONS_ALL	Update amount_applied, acctd_amount_applied_from, posting_control_id
AR_PAYMENT_SCHEDULES_ALL	Update amount_due_original, amount_due_remaining
AX_SLE_LINES	Backup only (re-generated by posting)
AX_EVENTS	Backup only