My Oracle Support Banner

TMS Derivation Failing - Numeric Or Value Error (Doc ID 2617840.1)

Last updated on DECEMBER 11, 2020

Applies to:

Oracle Thesaurus Management System - Version 5.2.3 and later
Information in this document applies to any platform.


After upgrading  to OC 5.2, batch validation session is failing, due to an error in the TMS derivation job.


Batch Validation aborted due to an error
SQL error during TMS Thesaurus Validation: SQLERROR ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "RXC.TMS_OCL_D


Error stack reported in a debug session is:

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "RXC.TMS_OCL_DERV", line 2235
ORA-06512: at "RXC.TMS_OCL_DERV", line 977
ORA-06512: at line 7




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

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