Searching

Oracle iSupplier Portal provides extensive search criteria on all pages to help you retrieve information. Once you have your search results displayed, you can sort them by clicking any of the linked column headings.

When entering search values, you can use the percent sign (%) as a wildcard to search for generic items. For example, to search for all orders beginning with 27 and end in a 5 (such as 275, 2715, 27125) enter 27%5. The % wildcard does not control the number of wild characters. Note the search logic attempts to find matches containing values in any position.

There are three types of search functions available to you.

Quick Search

The Quick Search feature is available to you from the Home page. Using Quick Search, you can look for

To use the Quick Search:

  1. Select the search type from the Search menu.

  2. Enter a search value.

  3. Click Go.

Simple Search

The Simple Search feature occurs on many pages and allows you so specify multiple search fields and enter criteria for each. You can use any or all of the fields available to you. The system displays only those results that match all the criteria you entered.

Advanced Search

Advanced Search allows you to build complex search queries containing multiple search criteria. You can select which fields you wish to search on and enter search values for each. Such fields include (among others):

You can use the default search fields that appear for that page's Advanced Search function, or apply additional search fields from the "Add Another" menu for the page.

Search operators enable you to specify the matching conditions for a search. Available search operators are:

Note that you can use the same search field twice to specify a search range, for example a Ship Date range. Also note that you can choose to require the results to match all search criteria (resulting in a more focused, narrower set of results) by selecting the option "Show table data when all conditions are met," or allow a match of any of the search criteria (resulting in a larger set of results) by selecting the option "Show table date when any condition is met."