My Oracle Support Banner

R12: AP/AR: When Validating Invoice Error Rises: APP-SQLAP-1000: ORA-01400: Cannot Insert NULL Into (AP_INVOICE_DISTRIBUTIONS_ALL . Dist_code_combination_id) Occurred in AP_APPROLAV_MATCHED_PKG.Exec_matched_Variance_PKG (Doc ID 3004186.1)

Last updated on FEBRUARY 15, 2024

Applies to:

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

Symptoms

When attempting to Validate the Invoice, error message shown in the Invoice workbench.

ERROR
-----------------------
APP-SQLAP-1000: ORA-01400: cannot insert NULL into ("AP_INVOICE_DISTRIBUTIONS_ALL"." dist_code_combination_id") occurred in
AP_APPROLAV_MATCHED_PKG.Exec_matched_Variance_PKG_checks<-AP_APPROVAL_PKG.Generate_Distributions<-AP_APPROVAL_PKG.Approval<-APXINVWBB
with parameters (invoice_id = 1640715, Sys Xrate Gain Ccid =, Sys Xrate Loss Ccid=)




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Payables Responsibility
2. Invoice > Entry > Invoices
3. Press (B) Actions...1 > Validate
4. Error occurs

 

Changes

 

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
Changes
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.