Error : ORA-06502: PL/SQL: numeric or value error: character to number conversion error while validating invoices with TDS (Doc ID 2776277.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

Problem Description
------------------

Upon validating payables invoices with TDS taxes observed that the TDS invoices are not generated.
An error is found in tools - TDS tax details menu under error message section.

Error message 
-----------------
(from FND)
JAI.PLSQL.JAI_AP_DTC_DEFAULTATION_PKG.DEFAULT_TDS_FROM_SETUP.exception Error from default_tds_from_setup :ORA-06502: PL/SQL: numeric or value error: character to number conversion error


Error message
-----------------
(from tools - TDS tax details menu )
ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Steps for replication
-----------------------
1. Raise a payables invoice with TDS taxes.
2. Validate.
3. Find no TDS child invoices generated.
4. Found error during validation , per fnd logs along with error in tools - TDS tax details menu.

Expected Behavior
---------------------
Expectation is such that the TDS processing should be allowed for completion without any errors.

Changes

Cause

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