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.

Symptoms

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

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.