My Oracle Support Banner

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 19, 2021

Applies to:

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

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

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
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.