My Oracle Support Banner

Xcalc Trying To Use String Dimension Rate Table Ora-06502 (Doc ID 331420.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.

Symptoms

After running calculation, transactions are in XCALC status when using string rate dimensions.

Process log shows:
EXCEPTION IN GET_input, ORA-06502: PL/SQL: numeric or value error: character to number conversion error
old_status is POP
new _status is XCALC
EXCEPTION IN GET_input, ORA-06502: PL/SQL: numeric or value error: character to number conversion error
old_status is POP
new _status is XCALC

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


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