My Oracle Support Banner

Cancelled Invoice With Voided Check With Two PAYMENT CREATED Transactions/Events Appears In The Payables Trial Balance Report (Doc ID 2346121.1)

Last updated on JULY 13, 2021

Applies to:

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


On : 12.1.3 version, Accounting Issues in AP

Cancelled invoice appears in the Payables Trial Balance report.

Invoice was validated in 11i.
Invoice was paid twice in 11i.
Invoice first payment was voided in 11i.
Invoice was accounted in 11i.

There was a corruption on the first 11i payment and this resulted in the check having two(2) PAYMENT CREATED accounting events in table AP_ACCOUNTING_EVENTS_ALL instead of one PAYMENT CREATE and one PAYMENT CANCELLED events.

The invoice second payment was accounted correctly.

After upgrade to R12.1.3, the invoice first payment resulted in two PAYMENT CREATED events in R12 table XLA_EVENTS instead of one PAYMENT CREATE and one PAYMENT CANCELLED events.

Table XLA_EVENTS shows the accounting event_ID of the corrupted payment (PAYMENT CREATED instead of PAYMENT CANCELLED) accounted OK (P/P) and transferred to GL OK.  But, this accounting event is missing the header(s) (XLA_AE_Headers), Lines (XLA_AE_Lines), and Distribution Links (XLA_Distribution_Links) rows.

This data corruption is preventing proper accounting.


Upgrade from 11i to R12

The invoice corrupted first payment was upgraded and resulted in two(2) PAYMENT CREATED events in R12 table XLA_EVENTS

GDF of KM Note: 1072017.1 was applied.   This did not solve problem.


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

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