ORA-01422 When Batch Validation is Running TMS Derivation Process (Doc ID 793525.1)

Last updated on AUGUST 29, 2014

Applies to:

Oracle Thesaurus Management System - Version 4.5.1 and later
Information in this document applies to any platform.
.
***Checked for relevance on 07-DEC-2010***
***Checked for relevance on 29-Aug-2014***

Symptoms

On TMS 4.5.1 in Production:
When attempting to run Batch Validation the following warning is appearing at the end of the log file:

ERROR

Batch Validation Completed with warnings due to TMS or Procedure execution or generation SQL error during TMS Thesaurus Validation: SQLERROR ORA-01422: exact fetch returns more than requested number of rows
ORA-

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms