ORA-1403 When Creating Profiles Under TMS--> Definition--> Maintain Settings (Doc ID 790663.1)

Last updated on AUGUST 17, 2017

Applies to:

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

Symptoms

On TMS 4.6:
When attempting to create profiles under TMS--> Definition--> Maintain Settings-->Profiles,
the following error occurs:

Error:

ORA-01403: No Data Found
FRM-40735: ON-INSERT trigger unhandled exception

Steps to Reproduce:
1. Log into TMS 4.6
2. Navigate to: TMS--> Definition--> Maintain Settings-->Profiles
3. Select the 'Profile' Tab and enter values
4. Save- the reported error is returned.

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