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 MARCH 16, 2018

Applies to:

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

Symptoms

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.

Changes

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms