Search Results psbbv_position_sets

Overview

The view PSBBV_POSITION_SETS belongs to the Oracle E-Business Suite product PSB – Public Sector Budgeting, a module documented in ETRM as obsolete. The view presents a consolidated, read-only list of account position set definitions used by the budgeting engine, joined to the data extract definitions those sets are associated with. Its primary role is to expose descriptive information about position sets — name, shareable (global versus local) status, and the attribute selection type — in a form suitable for inquiry screens, reports, and integration extracts.

Per the ETRM documentation for this object, the view is Not implemented in this database, meaning the object is recorded as metadata only and may not exist as a physical database object in all environments. This is consistent with the obsolescence of the Public Sector Budgeting module in releases 12.1.1 and 12.2.2. Where the view is present, it is defined WITH READ ONLY, and therefore cannot be used as the target of DML.

Underlying Base Objects

The documented view text defines the object over exactly two base tables:

• PSB_ACCOUNT_POSITION_SETS (aliased SETS) — the driving table, holding position set header definitions.
• PSB_DATA_EXTRACTS (aliased DTE) — joined on DATA_EXTRACT_ID using an outer join (DTE.DATA_EXTRACT_ID(+) = SETS.DATA_EXTRACT_ID), so position sets with no associated extract are still returned.

The join is filtered by the predicate ACCOUNT_OR_POSITION_TYPE = 'P', restricting the result set strictly to position-type sets rather than account-type sets. ETRM records no additional referenced base objects beyond these two tables, and the view is equipped with WITH READ ONLY rather than a stored query or materialized construct.

Key Columns

The view exposes the following columns, several of which are aliases derived from the underlying tables:

• POSITION_SET_NAME — sourced from SETS.NAME; the user-facing identifier of the position set.
• POSITION_SET_SHAREABLE_FLAG — derived via DECODE(SETS.GLOBAL_OR_LOCAL_TYPE, 'G', 'Y', 'N'); returns Y when the set is global (shareable) and N when local.
• ATTRIBUTE_SELECTION_TYPE — sourced from DTE.DATA_EXTRACT_NAME; the name of the linked data extract.
• POSITION_SET_ID — sourced from SETS.ACCOUNT_POSITION_SET_ID; the primary key of the position set.
• DATA_EXTRACT_ID — the foreign key linking the set to its data extract definition.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / CREATED_BY / CREATION_DATE — standard EBS audit columns carried through from PSB_ACCOUNT_POSITION_SETS.

Common Use Cases and Queries

The view is typically used to enumerate position sets for configuration review, to confirm whether a set is shared across organizations, and to trace the data extract associated with each set. A representative query listing all position sets and their shareable status is:

• SELECT position_set_name, position_set_shareable_flag, attribute_selection_type FROM psbbv_position_sets ORDER BY position_set_name;
• SELECT position_set_name, position_set_id FROM psbbv_position_sets WHERE position_set_shareable_flag = 'Y';
• SELECT position_set_name, attribute_selection_type FROM psbbv_position_sets WHERE data_extract_id IS NULL;

Because the view is read-only and tied to an obsolete module, it should be treated as a legacy inquiry object. Any query referencing it should be validated against the target environment, since ETRM explicitly records that the view is not implemented in the documented database.