Symptoms

• AP payment XLA accounting entries have incorrect CODE_COMBINATION_ID, PARTY_ID, and/or PARTY_SITE_ID values on the CASH_CLEARING and LIABILITY accounting lines.
• The accounting entries were generated with the wrong supplier or bank account CCID, or the wrong party/site information was stamped, resulting in incorrect general ledger postings.
• XLA_EVENTS for the affected payments have event_status_code and process_status_code in a state that indicates incomplete processing.
• XLA_AE_HEADERS for the affected AE headers have an ACCOUNTING_ENTRY_STATUS_CODE that is not Final, preventing proper GL transfer.
• XLA_ACCOUNTING_ERRORS records exist for the affected events.

Root Cause

AP payment Create Accounting generated XLA accounting lines with incorrect CODE_COMBINATION_ID, PARTY_ID, and PARTY_SITE_ID values on the CASH_CLEARING and LIABILITY line types for multiple payments across multiple AE header pairs. The correct CCID and party/site values must be applied directly to the XLA_AE_LINES rows for each AE header pair. After correcting the lines, the XLA events are marked as processed and the AE headers are marked as Final so the corrected entries can be used for GL reporting and transfer.

Resolution

Run data_fix.sql. Backup tables are created for:

• XLA_AE_LINES (for all affected ae_header_ids)
• XLA_EVENTS (for all affected event_ids)
• XLA_AE_HEADERS (for all affected ae_header_ids)

For each AE header pair (invoice event header + payment event header), update XLA_AE_LINES to set the correct CODE_COMBINATION_ID, PARTY_ID, and PARTY_SITE_ID filtered by ACCOUNTING_CLASS_CODE:

• Update CASH_CLEARING lines with the correct cash clearing CCID and the correct supplier party ID and party site ID.
• Update LIABILITY lines with the correct liability CCID and the correct supplier party ID and party site ID.

This pattern is repeated for each AE header pair in the affected set, with the specific CCID and party values varying per payment depending on the payment bank account and supplier.

Update XLA_EVENTS to set EVENT_STATUS_CODE = 'P' and PROCESS_STATUS_CODE = 'P' (processed) for all affected event IDs.

Update XLA_AE_HEADERS to set ACCOUNTING_ENTRY_STATUS_CODE = 'F' (Final) for all affected AE header IDs. This marks the corrected accounting entries as finalized and ready for GL transfer.

Delete from XLA_ACCOUNTING_ERRORS for all affected event IDs to clear any error records that were generated during the failed or incorrect accounting run.

Commit. Re-test the accounting by verifying the corrected CCID, PARTY_ID, and PARTY_SITE_ID values appear correctly in the AP Trial Balance and accounting reports for the affected payments.

Script Inventory

Key Tables Affected