Cancelled Invoice With Voided Check With Two PAYMENT CREATED Transactions/Events Appears In The Payables Trial Balance Report
Last updated on MARCH 16, 2018
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.
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