Symptoms

• An AP payment batch cannot complete GL Transfer because one or more AP_AE_LINES_ALL records have code_combination_id = -1 (an invalid placeholder value).
• The same invalid CCID appears in the corresponding GL_INTERFACE rows for the same gl_sl_link_id, preventing the GL import from accepting the journal.
• Affected lines are ERV (Exchange Rate Variance) type lines on a specific invoice or payment batch.

Root Cause

During AP payment processing or batch accounting, the ERV accounting line was created with code_combination_id = -1 — a sentinel value indicating that the correct account could not be determined at the time of creation. This leaves the GL Interface record in an invalid state that blocks GL Transfer. The correct CCID must be applied directly to both the AE line and the corresponding GL Interface row.

Resolution

The script first queries to display all invoice numbers affected by the invalid CCID condition — ERV lines in AP_AE_LINES_ALL with code_combination_id = -1 linked to GL_INTERFACE via gl_sl_link_id.

Run data_fix.sql. For each affected AE line, the script:

1. Inserts a backup row into RSI_AP_AE_LINES_85420B from AP_AE_LINES_ALL.
2. Inserts a backup row into RSI_GL_INTERFACE_85420B from GL_INTERFACE.
3. Updates AP_AE_LINES_ALL.code_combination_id to the correct CCID for the affected AE line and header.
4. Updates GL_INTERFACE.code_combination_id to the correct CCID for the corresponding gl_sl_link_id.

The script commits after each record and prints success/failure counts. Errors are logged to an error table. After completion, re-run the GL Transfer for the affected batch.

Script Inventory

Key Tables Affected