GST Error :fp_location_address-->ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2723784.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Symptoms

Reported issue
-----------------
When trying to complete an AR invoice , it is failing with an error.

Error (from fnd debug )
------
JAI.PLSQL.JAI_AR_TAX_DET_PKG.determine_manual_ar_tax Encountered an error in JAI_AR_TAX_DET_PKG.determine_manual_ar_tax.  ,Unexpected Error pi_trx_id-->XXXXXORA-06502: PL/SQL: numeric or value error: character string buffer too small
JAI.PLSQL.JAI_TAX_PROCESSING_PKG.CALCULATE_TAX Encountered an error in JAI_AR_TAX_DET_PKG.determine_manual_ar_tax.  ,Unexpected Error pi_trx_id-->XXXXXORA-06502: PL/SQL: numeric or value error: character string buffer too small
ZX.PLSQL.ZX_API_PUB.VALIDATE_DOCUMENT_FOR_TAX JAI_TAX_PROCESSING_PKG.CALCULATE_TAX  RETURN_STATUS = E


Steps to replicate
--------------------
1. Raise an AR invoice with GST taxes.
2. Try complete the transaction.
3. An error is observed. 

Cause

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