My Oracle Support Banner

Unable to Fully Account an invoice due to unaccounted AWT line (Doc ID 353303.1)

Last updated on FEBRUARY 10, 2019

Applies to:

Oracle Payables - Version 11.5.1 to [Release 11.5]
Information in this document applies to any platform.
Concurrent Program:APACCENG - Payables Accounting Process


Unable to close period. Invoice canot be fully accounted.

Awt setup at Payment time and a payment on the invoice has been re-issued.

You may be running into this issue if the following sql returns rows.

Select aida.invoice_id, aida.invoice_distribution_id, aida.org_id, aida.awt_invoice_payment_id
from ap_invoice_distributions_all aida, ap_system_parameters_all aspa
where  nvl(aida.org_id,-99) = nvl(aspa.org_id, -99)
and aspa.create_awt_dists_type = 'PAYMENT'
and aida.line_type_lookup_code = 'AWT'
and aida.accounting_event_id is null;


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.