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 OCTOBER 27, 2020

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. 


Changes

 Could be issue with length of ship_to and bill_to fields. 

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.