My Oracle Support Banner

Error "Unexpected Error pi_trx_id-->XXXXXXORA-06502: PL/SQL: numeric or value error: character string buffer too small" in Autoinvoice Import Program (Doc ID 2895117.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

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

Symptoms

PROBLEM STATEMENT
-----------------------
When attempting to run Autoinvoice import program, the program completes with error for Accounts Receivables (AR) Credit Memo.

Error message (from Auto-Invoice Import Log)
-------------

ERROR: from eBusiness Tax - return code = 1 Current system time is 01-SEP-2022 10:46:08
Please review the plsql debug log for additional details. Current system time is 01-SEP-2022 10:46:08

Error message (from FND Debug log)
-------------

JAI_POPULATE_IRN_DETAILS 2 Start Of Section TRANSACTIONS DETAILS  
JAI_POPULATE_IRN_DETAILS 2 END Of Section TRANSACTIONS DETAILS  
JAI_POPULATE_IRN_DETAILS 2 Start Of Section DOCUMENT DETAILS  
JAI.PLSQL.JAI_AR_TAX_DET_PKG.create_ar_tax_inv_number 1 JAI_AR_TAX_DET_PKGpv_return_code: ERROR ,Unexpected Error pi_trx_id-->XXXXXXORA-06502: PL/SQL: numeric or value error: character string buffer too small
JAI.PLSQL.JAI_AR_TAX_DET_PKG.create_ar_tax_inv_number.END 2 JAI_AR_TAX_DET_PKG: create_ar_tax_inv_number()+
JAI.PLSQL.JAI_AR_AUTO_INV_PKG.create_ar_tax_inv_number.END 2 JAI_AR_AUTO_INV_PKG: create_ar_tax_inv_number()+
ar.plsql.arp_etax_util.synchronize_for_doc_seq 1 create_ar_tax_inv_number returns with below error
ar.plsql.arp_etax_util.synchronize_for_doc_seq 1 ,Unexpected Error pi_trx_id-->XXXXXXORA-06502: PL/SQL: numeric or value error: character string buffer too small
ar.plsql.arp_etax_util.synchronize_for_doc_seq.end 2 arp_etax_util.synchronize_for_doc_seq()-
fnd.src.process.fdpwrt.fdpwrt.log_write 3 ERROR: from eBusiness Tax - return code = 1

Steps to replicate
--------------------
The issue can be reproduced at will with the following steps:
1. Navigate to India Local Receivables responsibility.
2. Run the Auto-Invoice import program.
    Oracle Receivables-> Interfaces-> AutoInvoice

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
References


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