Auto Invoice Program Ending in Error Due to ORA-06502 importing TDS Credit Memo

(Doc ID 2349640.1)

Last updated on FEBRUARY 22, 2018

Applies to:

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

Symptoms

When running Autoinvoice to import TDS Credit Memo, this is ending in error and the log is showing the following:


JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX Encountered an error in JAI_AR_TAX_DET_PKG.determine_importing_ar_tax. Encountered an error in JAI_AR_TAX_DET_PKG.insert_ar_trx. ORA-06502: PL/SQL: numeric or value error: character to number conversion error.


Steps to Reproduce:

Responsibility: Receivables India Localization
Navigation
: Interfaces> Autoinvoice

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