My Oracle Support Banner

Get App-Sqlap-10000 Ora-01400 When Trying To Validate Invoice (Doc ID 313192.1)

Last updated on MAY 13, 2020

Applies to:

Oracle Payables - Version 11.5.4 and later
Information in this document applies to any platform.


An invoice was matched and reversed in a prior accounting period which is currently closed.
Invoice was matched again in current period.
All distribution lines in closed period are validated.
All distribution lines in open period are not validated.
Parent and reversed distribution item lines have different tax codes attached.

APP-SQLAP-10000 ORA-01400 cannot insert NULL into
occurred in with parameters(p_invoice_id =203227p_amount=0p_dist_ccid=2930p_tax_code_id=10181)
while performing the following operation:
insert into ap_invoice_distributions


To view full details, 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 a vibrant support community of peers and Oracle experts.