My Oracle Support Banner

Results When We Query For A Pattern In Interactive Coding Screen (Doc ID 1400772.1)

Last updated on MARCH 08, 2017

Applies to:

Adverse Event Reporting System - Version: 4.6.2 and later   [Release: 4.6.2 and later ]
Information in this document applies to any platform.


Searching for term eg: %alcohol% with Term Filter Level= LLT and Highest Level =PT, there seem to be lots of irrelevant results returned. It seems when Term Filter Level and Highest Level are different, irrelevant results will be returned.

1. on Events screen, enter a term in Event (Verbatim) field, for example, additive, and tab out
2. Interactive Coding screen will open,
3. Enter %alcohol% in search term, set Term Filter Level and Highest Level at different values,
4. Execute Search, the results vary, some seem to be OK, some seem irrelevant, please see attachment for more details

Is this expected behavior? What is the logic ?


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.