Invoice validation error: Unexpected issue during Tax Calculation Exception - User Defined Exception (ORA-01400) (Doc ID 2103014.1)

Last updated on OCTOBER 31, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Tax Deducted at Source-Payables

Customer facing the below issues while validating the invoice:

 Unexpected issue during Tax Calculation Exception - User Defined Exception

JAI.PLSQL.jai_ap_match_tax_proc_pkg.insert_ap_inv_dist() ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."DIST_CODE_COMBINATION_ID")


ERROR
-----------------------
Invoice should be validated successfully


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an invoice
2. Attach TDS taxes to it
3. Validate
4. Issue happens

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
TDS issue

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms