Skip Headers

Oracle Advanced Collections User Guide
Release 12.1
Part Number E13451-04
Go to Table of Contents
Go to previous page
Go to next page


This chapter describes the methods you can use to search for information in the application.

This chapter covers the following topics:

Overview of Searching

The fastest way to search the Oracle Advanced Collections database is to use the Lists of Values (LOVs) provided with many fields.

Use the Universal Search window to search for information using multiple search criteria. You can use the universal search window to give you one-click access to information. Select one of the predefined quick searches and enter your criteria. The expanded searches provide a wide range of parameters you can use for your search. You can save the results of your search as a list or you can save your query for reuse. You can set the user profile option OTS: Default Universal Search Tab to set which tab appears when you open Universal Search.

You can search information displayed in dynamic tables by right clicking in the table and making a selection from a pop-up menu.

Note: Oracle Advanced Collections does not support the Query Enter / Query Run method of searching common to many Oracle applications.

Using Partial Search Terms

Many Lists of Values fields let you search for partial words and numbers by using the % sign to indicate missing or unknown characters.

For example, a search for j%n in the First name field retrieves all first names starting with the letter j and ending with the letter n, including John, Jon, and Johann. A search for jo% retrieves all names starting with the letters "Jo". A search for %jo% retrieves all names with the letters "jo" in the middle. To ensure quick performance, it is best not to use this last form of search.

Optimizing Your Searches

For the fastest performance, you must narrow down the range of information you are searching as much as possible.

For example, if you receive a call from John Smith at ABC Corp, you should first use the Organization List of Values (LOV) to search for ABC Corp, and then use the First Name or Last Name LOVs to search for the name. Searching for the organization first narrows the range of individuals your application must search to just those who work for ABC Corp.

If you are not sure about the best way to search, then use the Universal Search window for the greatest flexibility.

Related Topics

Performing Quick Searches

Performing Expanded Searches

Creating a List

Viewing a List You Have Created

Saving Query for Reuse

Searching Using a Query You Have Saved