While Using API OKL_TAX_TRX_DETAILS_PUB.update_tax_trx_details it Errors with ORA-06502: PL/SQL: numeric or value error: character to number conversion error (Doc ID 2544980.1)

Last updated on AUGUST 15, 2024

Applies to:

Symptoms

When attempting to use the API OKL_TAX_TRX_DETAILS_PUB.update_tax_trx_details, the following error is returned:

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 80

The issue can be reproduced at will with the following steps:
1. Using lease super user responsibility, create a termination quote. Based on the quote reason code, the transaction amount is being updated to 0 instead of the default amount which is calculated using formula. To update the transaction amount the aforementioned API is called which ends in error.

Changes

Cause

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