R12 INVOICE SHOWS AS UNACCOUNTED, BUT ACCOUNTING EXISTS AND INVOICE CANNOT BE ACCOUNTED FURTHER

(Doc ID 787340.1)

Last updated on MARCH 08, 2017

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.

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.

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