Searching for Information
Oracle Applications provides you with easy-to-use search capabilities to access application information. You can quickly retrieve and review all available information in your database without having to remember the information displayed in windows, or print lengthy reports to see the data. Instead, you can simply run a search to obtain the information you want and review the data online in the same window used to enter the data.
This section describes the two methods you can use to search and retrieve records in a window:
In addition, this section also describes a type of window that lets you immediately query records for review or editing:
Note: We use the words search and query interchangeably to describe the retrieval of records.
Note: Some windows cannot be searched because they display only run-time output or they can only be used to submit or run specific processes. An example is the Run Requests window. Your application displays a helpful message in the message line if you attempt to search in such a window.
Overview of Flexfields
Searching for Data Using Flexfield Criteria
Basic Business Needs
Oracle Applications lets you satisfy the following basic information search needs:
- Have instant, online access to all of your application information. You can find information quickly and easily, without having to use a complex query language.
- Search for a specific record or for a group of records based on criteria you enter before executing the search. You can retrieve this information directly, without having to review all the information in your application database.
- Search for information using criteria of different types or lengths, including a single letter, a single word, a group of characters, or anything else you wish to enter.
- Find out how much information is available that matches your search criteria before running the search. Otherwise, you might waste both computer time and your time should your search for a single piece of information yield 10,000 responses. This feature is available only when using query-by-example.