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 APRIL 04, 2025
Applies to:
Oracle Financials for India - Version 12.1.1 and laterInformation 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
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
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 |