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:

Symptoms

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
Validated.

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.

Changes

Cause

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