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

Last updated on SEPTEMBER 23, 2016

Applies to:

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

Symptoms

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;

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