My Oracle Support Banner

INVOICE VALIDATION ERROR ORA-01400:CANNOT INSERT NULL - AP_INVOICE_DISTRIBUTIONS (Doc ID 2600019.1)

Last updated on OCTOBER 16, 2019

Applies to:

Oracle Landed Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Invoice Issues

When attempting to run the Invoice Validation, the child process has an error:

ERROR
-----------------------
ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ID") occurred in
AP_APPROVAL_MATCHED_PKG.Exec_Matched_Variance_Checks<-AP_APPROVAL_PKG.Generate_Distributions<-
with parameters (Invoice_id = 3400258, Sys Xrate Gain Ccid = , Sys Xrate Loss Ccid = )


STEPS
-----------------------
Run the Invoice Validation program.
View>Requests noticed the child process fails.


Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.