| Case Number | 00026526 |
| Oracle Module | Accounts Payable (AP) / Subledger Accounting (XLA) |
| EBS Version | R12 |
| Functional Area | Payment Processing / XLA Accounting / Gain/Loss Rounding |
| Related Patches | None |
XLA_AE_LINES have incorrect entered_dr or entered_cr amounts on gain/loss lines (rounding_class_code = 'GAIN' or 'LOSS') for multiple payments.XLA_DISTRIBUTION_LINKS rows also have incorrect unrounded_entered_dr or unrounded_entered_cr values for the GAIN/LOSS rounding class.XLA_ACCOUNTING_ERRORS records exist for the affected events, indicating Create Accounting detected the discrepancy.XLA payment accounting events were created with incorrect entered debit or credit amounts on the gain/loss rounding lines. The unrounded_entered_dr / unrounded_entered_cr values in both XLA_AE_LINES and XLA_DISTRIBUTION_LINKS do not match what the accounting engine computed, causing XLA accounting errors. The fix applies the correct entered amounts directly to the affected AE lines and distribution links, marks the events as processed and the AE headers as Final, and clears the accounting errors so the payments can be re-accounted and transferred.
Run data_fix.txt. Backup tables are created for:
XLA_EVENTS (for affected event IDs)XLA_AE_HEADERS (for affected AE header IDs)XLA_AE_LINES (filtered by the incorrect CCID and affected AE headers)XLA_ACCOUNTING_ERRORS (for affected accounting error IDs)XLA_DISTRIBUTION_LINKS (GAIN/LOSS rounding class rows for affected AE headers)Update XLA_EVENTS to set PROCESS_STATUS_CODE = 'P' and EVENT_STATUS_CODE = 'P' for the affected event IDs. Update XLA_AE_HEADERS to set ACCOUNTING_ENTRY_STATUS_CODE = 'F' (Final) for the affected AE header IDs.
For each affected AE header, update XLA_AE_LINES to set the correct entered_dr and unrounded_entered_dr (or entered_cr and unrounded_entered_cr for GAIN lines) on the line with the specific gain/loss CCID. The correct amounts differ per AE header pair.
For each affected AE header, update XLA_DISTRIBUTION_LINKS to set the correct unrounded_entered_dr or unrounded_entered_cr for LOSS or GAIN rounding class rows respectively.
Delete from XLA_ACCOUNTING_ERRORS for all affected accounting error IDs. Commit.
Re-submit Create Accounting for payments. Verify no payments appear on the Create Accounting error report. Transfer the corrected accounting to GL and post.
.txt file. The correct entered amounts for each AE header pair must be determined by analyzing the original payment and exchange rate data before running the fix. After applying the fix, validate that the entered amounts equal the accounted amounts (no currency conversion discrepancy) for the affected payment AE lines.
| File | Description |
|---|---|
| data_fix.txt | Step-by-step fix instructions. Creates backups; marks XLA_EVENTS as processed and XLA_AE_HEADERS as Final; updates entered_dr/cr and unrounded amounts on XLA_AE_LINES for GAIN/LOSS gain-loss lines across multiple AE header pairs; updates XLA_DISTRIBUTION_LINKS unrounded amounts; deletes XLA_ACCOUNTING_ERRORS. Includes post-fix validation query and Create Accounting re-submission instructions. |
| Table | Action |
|---|---|
| XLA_EVENTS | Update PROCESS_STATUS_CODE and EVENT_STATUS_CODE to 'P' |
| XLA_AE_HEADERS | Update ACCOUNTING_ENTRY_STATUS_CODE to 'F' (Final) |
| XLA_AE_LINES | Update entered_dr/cr and unrounded_entered_dr/cr for gain/loss CCID rows |
| XLA_DISTRIBUTION_LINKS | Update unrounded_entered_dr/cr for GAIN/LOSS rounding class rows |
| XLA_ACCOUNTING_ERRORS | Delete error records |