My Oracle Support Banner

GST ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ID") error during invoice validation (Doc ID 2648815.1)

Last updated on MARCH 14, 2020

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Error observed when trying to validate payable invoices. 

Error message 
---------------
(in invoice workbench form via screen shots)

Unexpected error occurred during Tax Calculation 
Exception Encountered the error in jai_tax_processing_pkg.Calculate_taxORA-20001:--1400: ORA-01400: cannot insert null into ("AP","AP_inovice_distributions_all"."Dist_code_combination_id")

Please contact the problem or contact your system administrator 

(Error from fnd debug log )
----------------------------
Encountered the error in JAI_TAX_PROCESSING_PKG.CALCULATE_TAXORA-20001: --1400: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ID")
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "Unexpected error occurred during Tax Calculation.
Exception: Encountered the error in JAI_TAX_PROCESSING_PKG.CALCULATE_TAXORA-20001: --1400: ORA-01400: cannot insert NULL into (""AP"".""AP_INVOICE_DISTRIBUTIONS_ALL"".""DIST_CODE_COMBINATION_ID"")

Expected Behavior 
----------------------
Expects that the invoice validation should be completed successfully. 

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.