My Oracle Support Banner

R12 Invoice Shows as Unaccounted, But Accounting Exists and Invoice Cannot be Accounted Further (Doc ID 787340.1)

Last updated on APRIL 25, 2023

Applies to:

Oracle Payables - Version 12.0.4 and later
Information in this document applies to any platform.
This problem can occur on any platform.


In R12, an invoice shows as unaccounted, but accounting exists for the invoice and
Create Online Accounting and the Create Accounting process do not create any additional
accounting for the invoice. Additionally, these invoices are reported on the Unaccounted
Transactions and Period Close Exceptions report with Exceptions = Not

Note: These invoices will also prevent the period from being closed.

These invoices are incorrectly reported as unaccounted/partially accounted
and are preventing period closed due to out of sync data in the
AP_SELF_ASSESSED_TAX_DIST_ALL table. These invoices have rows in this table
with accounting_event_id = NULL and posted_flag = N. The corresponding rows
in ap_invoice_distributions_all have an accounting_event_id assigned and
posted_flag = Y.




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.