Case 00076480 – AP AE Lines Entered Amount Incorrect (11i)

AP AE Lines Entered Amount Incorrect (11i)

Case Number	00076480
Oracle Module	Accounts Payable (AP)
EBS Version	11i (Oracle Applications 11.5.x)
Functional Area	Payment Processing / Accounting Entries (AP_AE_LINES)
Related Patches	None

Symptoms

An AP accounting entry in AP_AE_LINES_ALL shows incorrect entered_dr or entered_cr amounts for a payment or invoice.
The AP Trial Balance or payment accounting report shows an incorrect entered amount, while the accounted amount may be correct.
The error is confined to a small number of specific AE line records identified by their ae_line_id.

Root Cause

The entered amount columns (entered_dr and entered_cr) on specific AP_AE_LINES_ALL records were set incorrectly during payment or accounting processing. This is an 11i-style accounting entry (AP AE Lines, not XLA), applicable to Oracle Applications 11.5.x environments. A direct update to the specific line IDs corrects the entered amounts.

Resolution

Step 1 – Create backup table

Run data_fix.sql. A backup of the affected AP_AE_LINES_ALL rows is created by ae_line_id.

Step 2 – Correct entered_dr amount

Update AP_AE_LINES_ALL to set the correct entered_dr value for the affected debit line.

Step 3 – Correct entered_cr amount

Update AP_AE_LINES_ALL to set the correct entered_cr value for the affected credit line.

Step 4 – Commit and validate

Issue COMMIT. Verify the accounting entry balances correctly and the AP Trial Balance reflects the corrected amounts.

Note: This fix applies to the 11i AP_AE_LINES_ALL accounting model (not the R12 XLA model). It is applicable only to Oracle Applications 11.5.x environments. For R12 accounting entry corrections, use the XLA tables (XLA_AE_LINES).

Script Inventory

File	Description
data_fix.sql	Creates backup of affected AP_AE_LINES_ALL rows; updates entered_dr on the debit line and entered_cr on the credit line to correct values.

Key Tables Affected

Table	Action
AP_AE_LINES_ALL	Update entered_dr and entered_cr to correct values