My Oracle Support Banner

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 MAY 14, 2021

Applies to:

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

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

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
Changes
Cause
Solution


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