My Oracle Support Banner

All Production Terms in TMS Disappear when Test Data is Hard-Deleted using Default '%' (Doc ID 1275143.1)

Last updated on FEBRUARY 13, 2020

Applies to:

Oracle Clinical - Version 4.5.2 to 5.0.0 [Release 4.5.2 to 5.0.0]
Oracle Thesaurus Management System - Version 4.5.2 to 5.0.0 [Release 4.5.2 to 5.0.0]
Information in this document applies to any platform.


TMS 4.5.2

For our Electronic Data Capture studies data is batch loaded into Oracle Clinical from external site.

Data is batch loaded initially in test mode, and later production data is batch loaded in prod mode.

Prior to study freeze the trial team clean up test data by hard-deleting using default % (in test mode).

This causes all terms to be deleted in TMS production for the study !

We can get the terms back by forcing TMS re-derivation, but our medical coders and the trial teams are concerned when this happens.




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.