R12: Unable To Validate Credit Memo Due To Error ORA-01400: cannot insert NULL into ("AP", "AP_INVOICE_DISTRIBUTIONS_ALL", "DIST_CODE_COMBINATION_ ID") occurred in Insert_Tax_Distributions (Doc ID 1129343.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

On R12.0 application version, when attempting to validate a credit memo invoice, the following error occurs.

Error Message
APP-SQLAP-10000: ORA-01400: cannot insert NULL into
("AP", "AP_INVOICE_DISTRIBUTIONS_ALL", "DIST_CODE_COMBINATION_
ID") occurred in
Insert_Tax_Distributions <-
AP_ETAX_UTILITY_PKG.Return_Tax_Distributions<-AP_ETAX_SERVICES_PKG.Update_AP
<-AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax
<-AP_APPROVAL_PKG.Approval<-APXINWKB
with parameters ( P_Invoice_Id = &invoice_Id P_Calling_Sequence
=
AP_ETAX_UTILITY_PKG.Return_Tax_Distributions<-AP_ETAX_SERVICES_PKG.Update_AP
<-AP_ETAX_SERVICES_PKG.Distribute<-AP_ETAX_PKG.Calling_eTax
<-AP_APPROVAL_PKG.Approval<-APXINWKB)
while performing the following operation:
Step 11: Insert new distributions including variances

Steps to Reproduce
(R) : Payables
(N) : Invoices > Entry > Invoices > Query invoice > Actions > Validate

Result: Error returned

Cause

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