Querying OEBS Programs

Given the large number of Oracle E-Business Suite programs, you may find it useful to get a listing of programs based on a variety of criteria. You can generate a list by defining a query on the Query sub-tab for the RA Oracle E-Business Suite Agent solution Agent object and clicking the Query button. Query results are informational only. The Query results dialog shows the number of rows at the bottom right.

Field Descriptions

The following table describes the fields on the Query Programs section.

  • Application Short Name

    • Searches for programs in the selected application.

  • Program

    • Searches for OEBS program name(s). Wildcards % and _ are allowed. The field is case sensitive.

  • Program Description

    • Searches for OEBS program description(s). Wildcards % and _ are allowed.

  • Query only for Programs

    • Allows you to limit the query based on the following options.

    • with existing Jobs
    • without existing Jobs
    • that are SRS programs
    • that are not SRS programs
    • that have been marked Included
    • that have been marked Excluded

You can type the first few letters of a program name in the Search field, and the RA Oracle E-Business Suite Agent will filter the results. The Search field also supports UNIX regular expressions and the Oracle % wildcard for multiple characters.