Search Results data_extract_name




Overview
Explore in AI Chat

Overview

The APPS.PSBFV_POSITION_SET_LISTS view is a Business Intelligence System (BIS) view owned by the APPS schema and registered under FND Design Data as PSB.PSBFV_POSITION_SET_LISTS. It presents consolidated information about position lists, exposing the relationship between position sets, their associated positions, and the data extracts that govern how budget positions are collected and processed. In Oracle EBS 12.1.1 and 12.2.2, this view is part of the Public Sector Budgeting (PSB) module family, which supports budget formulation, position control, and workforce planning for public sector and government installations.

The view's principal role is to make denormalized position set data readily available for reporting and integration. Instead of requiring report developers to join multiple PSB tables manually, PSBFV_POSITION_SET_LISTS presents a flattened result set in which each row represents a position within a position set, along with the corresponding data extract context. The view is documented with a VALID status, and its BIS designation indicates it is intended for downstream analytical and extract-oriented consumption rather than for transactional update.

Underlying Base Objects

PSBFV_POSITION_SET_LISTS is defined over four PSB base tables: PSB_ACCOUNT_POSITION_SETS, PSB_BUDGET_POSITIONS, PSB_DATA_EXTRACTS, and PSB_POSITIONS. These tables supply the identity attributes, naming, and extract metadata surfaced by the view. PSB_ACCOUNT_POSITION_SETS provides the position set definition and corresponding set identifier, while PSB_POSITIONS and PSB_BUDGET_POSITIONS contribute the individual position records and their budget context. PSB_DATA_EXTRACTS supplies the data extract name and identifier that associate a set of positions with a specific extract definition.

The view is not referenced by any other database object, which confirms it functions as a terminal reporting object rather than a foundation for further dependency chains. All four base tables reside in the APPS schema, and the view inherits standard Who columns for audit tracking.

Key Columns

  • POSITION_SET_NAME (VARCHAR2, 100): The descriptive name of the position set, useful for grouping and labeling in reports.
  • DATA_EXTRACT_NAME (VARCHAR2, 30): The name of the data extract associated with the position set; this is the column most relevant to the user's search for "data_extract_name" and identifies the extract used to bring position data into budgeting processes.
  • POSITION_NAME (VARCHAR2, 240): The descriptive name of the individual position within the set.
  • POSITION_SET_ID (NUMBER, 15): The unique identifier for the position set, suitable for joins back to PSB_ACCOUNT_POSITION_SETS.
  • DATA_EXTRACT_ID (NUMBER, 15): The unique identifier for the data extract, joinable to PSB_DATA_EXTRACTS.
  • POSITION_ID (NUMBER, 15): The unique identifier for the position record.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE: Standard Who audit columns capturing creation and last-modification metadata.

Common Use Cases and Queries

Typical scenarios include validating which positions belong to a given set and extract, auditing extract-to-position mappings, and feeding position data into downstream budget reports. A basic listing retrieves all rows:

SELECT POSITION_SET_NAME, DATA_EXTRACT_NAME, POSITION_NAME
FROM APPS.PSBFV_POSITION_SET_LISTS;

To isolate a specific extract, filter on DATA_EXTRACT_NAME:

SELECT POSITION_SET_NAME, POSITION_NAME, POSITION_ID
FROM APPS.PSBFV_POSITION_SET_LISTS
WHERE DATA_EXTRACT_NAME = :extract_name;

To count positions per set, aggregate:

SELECT POSITION_SET_NAME, DATA_EXTRACT_NAME, COUNT(*) AS position_count
FROM APPS.PSBFV_POSITION_SET_LISTS
GROUP BY POSITION_SET_NAME, DATA_EXTRACT_NAME;

Because the view is read-only and denormalized, it is well suited for BI Publisher reports, FSG-style extracts, and custom concurrent programs that need position list data without reconstructing complex PSB joins.