Case 00088203 – AP Paid Invoice Remaining on Trial Balance — Liability Balance Account Correction (11i)

AP Paid Invoice Remaining on Trial Balance — Liability Balance Account Correction (11i)

Case Number	00088203
Oracle Module	Accounts Payable (AP)
EBS Version	11i (11.5.10.2)
Functional Area	Payment Processing / AP Trial Balance / Liability Balance
Related Patches	None

Symptoms

Fully paid AP invoices continue to appear on the AP Trial Balance with a non-zero balance.
The invoice and payment accounting entries in AP_AE_LINES_ALL and AP_LIABILITY_BALANCE reference different code_combination_id values for the liability account, causing the net balance to appear open instead of clearing to zero.
The invoice was booked to one liability account CCID, and the payment was applied against a different CCID, resulting in a permanent mismatch visible on the Trial Balance.

Root Cause

The AP liability balance table (AP_LIABILITY_BALANCE) and accounting entry lines (AP_AE_LINES_ALL) for the payment side of affected invoices contain a different code_combination_id than the invoice liability lines. This mismatch prevents the Trial Balance from netting the invoice and payment to zero. The fix identifies the credited (invoice) account as the correct CCID and updates all payment-side liability balance and AE line records to use the same account.

Resolution

Step 1 – Populate the driver table

Populate RSI_AP_BAL_TMP_88203 with the affected invoice IDs, their current account balances, and CCID values before running the fix script.

Step 2 – Run the fix script

Run data_fix.sql. The script identifies invoices in the driver table that have more than one distinct account (CCID) across their liability balance records, then for each affected invoice:

Determines the correct target CCID as the credited account (invoice liability account).
Backs up the affected AP_AE_LINES_ALL and AP_LIABILITY_BALANCE records.
Updates AP_LIABILITY_BALANCE.code_combination_id to the target CCID for all payment-side balance rows with the incorrect account.
Updates AP_AE_LINES_ALL.code_combination_id to the target CCID for the corresponding AE lines.
Optionally inserts GL Interface adjustment entries to document the account change (if GL transfer is required).

Step 3 – Commit and validate

The script commits after each invoice and prints a summary of successful and failed records. Verify the affected invoices no longer appear on the AP Trial Balance after re-running the report.

Note: This fix applies to the 11i AP_AE_LINES_ALL and AP_LIABILITY_BALANCE accounting model. The driver table RSI_AP_BAL_TMP_88203 must be created and populated with the affected invoice data before running this script. An optional GL Transfer mode (l_gl_transfer = TRUE) can insert correcting GL Interface entries.

Script Inventory

File	Description
data_fix.sql	PL/SQL script (11i). Corrects mismatched code_combination_id on AP_LIABILITY_BALANCE and AP_AE_LINES_ALL for paid invoices remaining on the Trial Balance. Consolidates all payment-side liability rows to use the invoice liability account CCID. Creates backup tables and error log. Produces spooled output.

Key Tables Affected

Table	Action
AP_LIABILITY_BALANCE	Update code_combination_id to invoice liability CCID
AP_AE_LINES_ALL	Update code_combination_id to invoice liability CCID
GL_INTERFACE	Optional — insert correcting adjustment entries if GL transfer required