Error while Using API OKL_TAX_TRX_DETAILS_PUB.update_tax_trx_details (Doc ID 2544980.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

On : 12.2.4 version, Setups

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
06502. 00000 - "PL/SQL: numeric or value error%s"
*Cause: An arithmetic, numeric, string, conversion, or constraint error
  occurred. For example, this error occurs if an attempt is made to
  assign the value NULL to a variable declared NOT NULL, or if an
  attempt is made to assign an integer larger than 99 to a variable
  declared NUMBER(2).
*Action: Change the data, how it is manipulated, or how it is declared so
  that values do not violate constraints.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. When any termination quote is created, 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

Cause

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