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:
Oracle Financials for India - Version 12.1 and laterInformation 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 |