This chapter describes the methods you can use to search for information in the application.
This chapter covers the following topics:
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.
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.
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