Case 00036135 – AR Receipt AX Event Translation Status and Posting Not Updated

AR Receipt AX Event Translation Status and Posting Not Updated

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

Symptoms

An AR cash receipt AX event (RECEIPT_INSERT or MISC_INSERT) shows an incorrect translation_status that prevents posting to the GL.
The corresponding AR receivable application record has posting_control_id = -3 (unposted), preventing period close.
The receipt appears as unaccounted or unposted in the AR reconciliation reports.

Root Cause

The AX Global Accounting Engine event for the cash receipt was not fully processed — the translation_status on AX_EVENTS was not updated to 'T' (Translated), and the receivable application's posting_control_id was left at -3 (unposted). This prevented the receipt from being recognised as posted in GL reports.

Resolution

Step 1 – Create backup tables

Run data_fix.sql. Backups are created for:

AX_EVENTS (RECEIPT_INSERT / MISC_INSERT events for the affected receipt)
AR_RECEIVABLE_APPLICATIONS_ALL

Step 2 – Update AX event translation status

Set translation_status = 'T' on AX_EVENTS for the affected receipt's RECEIPT_INSERT and MISC_INSERT events.

Step 3 – Update receivable application posting control

Update AR_RECEIVABLE_APPLICATIONS_ALL to set posting_control_id to the correct posting control ID (replacing the unposted value of -3) for the affected cash receipt and payment schedule combination.

Step 4 – Commit and validate

Issue COMMIT. Verify the receipt no longer appears as unposted in AR reconciliation reports.

Note: This is an Oracle 11i Global Accounting Engine (AX) fix. The AX_EVENTS and related tables do not exist in R12 environments.

Script Inventory

File	Description
data_fix.sql	Creates backups; sets AX_EVENTS translation_status to 'T'; updates AR_RECEIVABLE_APPLICATIONS_ALL posting_control_id from unposted (-3) to the correct value.

Key Tables Affected

Table	Action
AX_EVENTS	Update translation_status to 'T'
AR_RECEIVABLE_APPLICATIONS_ALL	Update posting_control_id