Query services retrieve information from Oracle Applications systems by querying the Oracle Applications production tables. Query services execute SQL trees against the corresponding Oracle Applications production tables to find and retrieve business documents that match the search criteria. For more information about SQL trees, see webMethods Oracle Applications Adapter Installation and User’s Guide .

Query services return all business documents that match the query criteria you specify in the query. If you do not specify a selection criteria for a particular parameter, the query ignores that parameter when performing the query. For example, if you specify a query to retrieve POs based on a particular PO creator, within a specific date range, the query service returns all purchase orders that meet that criteria. Any parameters that are not specified in the search criteria are ignored as part of the query.

There is no maximum number of business documents that the query service returns. To limit the business documents that the service might return, we recommend that you provide more stringent query criteria.