GST: TDS invoices NOT generated on validation of AP invoice with TDS Taxes Error " ORA-01400: cannot insert NULL into ("JA"."JAI_TAX_RATE_DETAILS"."EFFECTIVE_FROM") (Doc ID 2325516.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Symptoms

 Reported issue :-
----------------
On validation of Invoice with TDS taxes , observed that TDS invoices are NOT getting generated and in addition observed that the default section , tax
category are equally not defaulting .

Expected Behavior
----------------
On validation of invoice with valid TDS taxes , system should generate TDS
invoices. Also observed that as per the third party and Threshold setup ,section code and threshold tax category should be defaulted in.

Steps for Replication
------------------
1. Raise a invoice for an OU where which is assigned to exception threshold setup defined in.
2. Validate the invoice. Invoices get validated , but no TDS invoices are generated in.
3. Before validation , TDS Section code ( defaulted at third party ) and tax category are NOT getting defaulted
4. On validation , no tds invoices generated
5. Error message via fnd debug log
JAI.PLSQL.JAI_TAX_RATE_PKG.TAX_RATE_DETS_INSERT 2 Exception occurred in
Others. ORA-01400: cannot insert NULL into
("JA"."JAI_TAX_RATE_DETAILS"."EFFECTIVE_FROM")
JAI.PLSQL.JAI_AP_DTC_DEFAULTATION_PKG.DEFAULT_TDS_FROM_SETUP.exception 2
Error from default_tds_from_setup :ORA-01400: cannot insert NULL into
("JA"."JAI_TAX_RATE_DETAILS"."EFFECTIVE_FROM")

Error Message  from fnd debug log:
-----------------------------------------
JAI.PLSQL.JAI_TAX_RATE_PKG.TAX_RATE_DETS_INSERT 2 Exception occurred in Others. ORA-01400: cannot insert NULL into ("JA"."JAI_TAX_RATE_DETAILS"."EFFECTIVE_FROM")
JAI.PLSQL.JAI_AP_DTC_DEFAULTATION_PKG.DEFAULT_TDS_FROM_SETUP.exception 2 Error from default_tds_from_setup :ORA-01400: cannot insert NULL into
("JA"."JAI_TAX_RATE_DETAILS"."EFFECTIVE_FROM")

Business criticality
--------------------
Due to this customers are enable to generate TDS invoices.

Cause

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