Unable to Fully Account an invoice due to unaccounted AWT line
Last updated on SEPTEMBER 23, 2016
Applies to:Oracle Payables - Version 11.5.1 to 126.96.36.199 [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;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms