Search Results position_set_shareable_flag

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:

• APPS.PSB_ACCOUNT_POSITION_SETS
• APPS.PSB_DATA_EXTRACTS

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

• DATA_EXTRACT_NAME (VARCHAR2, 30) — the name of the parent data extract to which the position set belongs.
• POSITION_SET_NAME (VARCHAR2, 100) — the descriptive name of the position set.
• POSITION_SET_SHAREABLE_FLAG (VARCHAR2) — indicates whether the set can be shared. A shareable set is a global set available across the enterprise.
• ATTRIBUTE_SELECTION_TYPE (VARCHAR2) — indicates whether the position set must match all or at least one of the selection criteria. This column is the subject of the user's search and is central to understanding how membership is resolved.
• POSITION_SET_ID (NUMBER, 15) — the unique position set identifier.
• DATA_EXTRACT_ID (NUMBER, 15) — the unique data extract identifier.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard Who columns recording audit information.

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.