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

Last updated on JULY 01, 2013

Applies to:

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

Symptoms

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.

Error
APP-SQLAP-10000 ORA-01400 cannot insert NULL into
("AP."AP_INVOICE_DISTRIBUTIONS_ALL"."PERIOD_NAME")
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

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