My Oracle Support Banner

GST: Error "PL/SQL: numeric or value error: character to number conversion error" while trying to complete manual AR transaction (Doc ID 2717892.1)

Last updated on OCTOBER 09, 2020

Applies to:

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

Symptoms

While create manual invoice and trying to complete invoice system show below error

ERROR
-----------------------
APP-AR-11526: Encountered an error in JAI_AR_TAX_DET_PKG.determine_manual_ar_tax.
Unexpected Error tp_location_address->ORA-6502: PL/SQL: numeric or value error: character to number conversion error


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a manual invoice with GST taxes.
2. Try to complete the same and notice the error message.

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


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