My Oracle Support Banner

R12: AP/XLA: Invoices Showing Incorrectly on the Payables Trial Balance Due to Orphan Rows in XLA_TRIAL_BALANCES (Doc ID 2793199.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Subledger Accounting - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Paid or cancelled invoice(s) showing on the Trial Balance.

The following query returns rows

Both, the invoice and its payment have been accounted successfully and its accounted transferred to the General Ledger successfully.

Except, notice the record highlighted in XLA_TRIAL_BALANCES.  It references AE_HEADER_ID 28226375 which is NOT referenced in XLA_AE_HEASDERS nor in XLA_AE_LINES.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.