Skip to Main Content
Return to Navigation

Considerations for Creating a PS Query Implementation

Oracle recommends that you perform these tasks when multiple related terms may be accessed during a single business event:

  1. Create a single PS Query implementation to return a rowset containing the data for several terms.

  2. Specify which data element or field position in the rowset or record is to be used for the term.

  3. Ensure that appropriate privileges have been set for accessing the objects present in the query.

Note: Use caution when using this type of implementation because the query may execute very slowly.