INVOICE VALIDATION ERROR ORA-01400:CANNOT INSERT NULL - AP_INVOICE_DISTRIBUTIONS
(Doc ID 2600019.1)
Last updated on SEPTEMBER 25, 2023
Applies to:
Oracle Landed Cost Management - Version 12.1.3 and laterInformation 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 |