Case 00103924 – AP Invoice Liability Account Incorrect with XLA and GL Correction

AP Invoice Liability Account Incorrect — XLA and GL Journal Correction

Case Number	00103924
Oracle Module	Accounts Payable (AP) / Subledger Accounting (XLA) / General Ledger (GL)
EBS Version	R12
Functional Area	Invoice Processing / Liability Account / Subledger and GL Correction
Related Patches	None

Symptoms

An AP invoice has an incorrect ACCTS_PAY_CODE_COMBINATION_ID (liability account CCID) — the invoice was booked to the wrong payables account.
The corresponding XLA accounting entries in XLA_AE_LINES and trial balance entries in XLA_TRIAL_BALANCES reference the incorrect CCID.
The corresponding GL journal lines (GL_JE_LINES) have already been posted with the incorrect account, so GL Interface correcting entries are required to reclassify the amounts to the correct account.

Root Cause

The AP invoice was created with or defaulted to an incorrect liability account CCID. Because the invoice was already accounted and the GL journal posted, simply updating the AP and XLA tables is not sufficient — correcting GL Interface entries must also be inserted to reclassify both the invoice liability entry and the corresponding payment entry from the old account to the new account in the General Ledger.

Resolution

Step 1 – Create backup tables

Run data_fix.sql. Backup tables are created for:

AP_INVOICES_ALL
XLA_AE_LINES (for the affected AE headers and incorrect CCID)
XLA_TRIAL_BALANCES
GL_JE_LINES (the posted journal lines with the incorrect CCID)

Step 2 – Update AP invoice liability account

Update AP_INVOICES_ALL.ACCTS_PAY_CODE_COMBINATION_ID to the correct CCID for the affected invoice.

Step 3 – Update XLA accounting lines

Update XLA_AE_LINES.code_combination_id to the correct CCID for all affected AE header/old CCID combinations. Then update XLA_TRIAL_BALANCES.code_combination_id with the same correction.

Step 4 – Commit AP/XLA changes

Issue COMMIT for the AP and XLA table updates.

Step 5 – Insert GL Interface correcting journal entries

Insert four GL Interface rows to reclassify the amounts in the General Ledger:

Invoice reversal: Credit the new (correct) liability CCID for the invoice amount; Debit the old (incorrect) liability CCID.
Payment reversal: Debit the new (correct) liability CCID for the payment amount; Credit the old (incorrect) liability CCID.

The GL Interface entries use STATUS = 'NEW' and an appropriate period, category, and source so they can be imported and posted through the normal GL Journal Import process.

Step 6 – Commit and validate

Issue COMMIT for the GL Interface entries. Run GL Journal Import for the correcting entries and post the resulting journal to complete the reclassification.

Note: The GL Interface entries must be imported and posted through the normal GL Journal Import process after this script runs. Verify the correcting entries net to zero across both the old and new accounts and that the AP Trial Balance shows the invoice under the correct liability account.

Script Inventory

File	Description
data_fix.sql	Creates backups; updates ACCTS_PAY_CODE_COMBINATION_ID in AP_INVOICES_ALL; updates code_combination_id in XLA_AE_LINES and XLA_TRIAL_BALANCES; inserts GL_INTERFACE correcting journal entries (invoice and payment reclassification) for GL Journal Import.

Key Tables Affected

Table	Action
AP_INVOICES_ALL	Update ACCTS_PAY_CODE_COMBINATION_ID to correct CCID
XLA_AE_LINES	Update code_combination_id to correct CCID
XLA_TRIAL_BALANCES	Update code_combination_id to correct CCID
GL_INTERFACE	Insert correcting reclassification journal entries for invoice and payment