Search Results attribute_selection_type




Overview
Explore in AI Chat

Overview

PSBFV_POSITION_SETS is an Oracle E-Business Suite business intelligence system view owned by the APPS schema and registered under the FND design data application PSB (Oracle Advanced Benefits). Its status is VALID, and it is classified as a Business Intelligence System view, meaning it is intended primarily for read-only reporting, data extraction, and integration rather than for transactional data entry. The view presents the definition of position sets, which are reusable groupings of positions used within the Oracle Advanced Benefits data extract and eligibility framework.

In Oracle EBS 12.1.1 and 12.2.2 the object is exposed as APPS.PSBFV_POSITION_SETS. It serves as a reporting-friendly projection of the underlying position set definition tables, denormalizing the position set header attributes together with its parent data extract. The view plays a supporting role in benefits administration integration, where downstream systems need to consume position set definitions to resolve participant eligibility and extract membership.

Underlying Base Objects

The documented ETRM metadata states that PSBFV_POSITION_SETS references the following base objects:

The view is therefore defined over the position set table, which supplies the position set name, shareability flag, attribute selection type, and position set identifier, joined to the data extract table, which supplies the data extract name and data extract identifier. The view is not referenced by any database object, confirming that it functions as a terminal, read-only reporting layer rather than a dependency of other database logic.

Key Columns

Common Use Cases and Queries

Typical use cases include extracting position set definitions for benefits integration, auditing which position sets are globally shared, and determining the selection logic applied to each set. The following query lists all position sets with their parent extract and selection type:

SELECT DATA_EXTRACT_NAME
     , POSITION_SET_NAME
     , POSITION_SET_SHAREABLE_FLAG
     , ATTRIBUTE_SELECTION_TYPE
     , POSITION_SET_ID
     , DATA_EXTRACT_ID
  FROM APPS.PSBFV_POSITION_SETS;

To isolate global (shareable) sets for a specific extract:

SELECT POSITION_SET_NAME, ATTRIBUTE_SELECTION_TYPE
  FROM APPS.PSBFV_POSITION_SETS
 WHERE POSITION_SET_SHAREABLE_FLAG = 'Y'
   AND DATA_EXTRACT_ID = :p_extract_id;

Because ATTRIBUTE_SELECTION_TYPE governs whether all criteria or at least one criterion must match, reporting on this column is essential when validating eligibility outcomes. All queries should be executed in a reporting capacity, respecting the read-only intent of the view.