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 06, 2017

Applies to:

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

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

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