Error trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : jai_ap_dtc_generation_pkg.process_dtc_at_inv_validate :ORA-01722: invalid number While Trying to Validate A Invoice (Doc ID 2002151.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

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

Symptoms

On : 12.2.2 version, India AP Localizations

When attempting to validate standard Invoice,
the following error occurs.

ERROR
-----------------------
Error - trigger ja_in_ap_aida_before_trg on ap_invoice_distributions_all : jai_ap_dtc_generation_pkg.process_dtc_at_inv_validate :ORA-01722: invalid number

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create Standard Invoice
2. Attach TDS Tax details
3. Validate Invoice

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot validate and generate TDS Invoices . Impacting in statutory payments

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