Label Loading Errors Can Never Be Fixed (Error: Relation Already Active) FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-20000 (Doc ID 747261.1)

Last updated on JANUARY 29, 2013

Applies to:

Adverse Event Reporting System - Version 4.6.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-20000 in Global Maintenance Label Maintenance when attempting update to added detail.

To Reproduce:

 

Proceed to Activation of pending Label changes in Pre-Dict group <Name of your Pre-Dict Group> in TMS?

  

 
'TMS Activation completed'

 

 
Error:
Relation already active

 

 
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-20000

 

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