Results for “psb_dss_fin_data_items_v”
6 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view PSB_DSS_FIN_DATA_ITEMS_V belongs to the Oracle Public Sector Budgeting (PSB) product family, which is documented as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. The view exposes financial data item definitions used by the Decision Support System (DSS) components of PSB, presenting the descriptive and structural attributes that govern how budget financial data items are named, labelled, and classified within a set of books. Its principal role is to provide a denormalized, reporting-friendly projection of the PSB_DSS_FIN_DATA_ITEMS table augmented with descriptive lookups from General Ledger, business group, and application lookup tables.
In the context of a user searching for psb_balance_type, this view is significant because it outer-joins FND_LOOKUPS on the PSB_BALANCE_TYPE lookup type, translating the stored BALANCE_TYPE code into a human-readable BALANCE_TYPE_MEANING. This makes the view the canonical reporting source for resolving balance type values associated with financial data items.
Underlying Base Objects
The view is defined over four base objects:
- PSB_DSS_FIN_DATA_ITEMS FDI — the primary driving table holding financial data item definitions, including identifiers, labels, level, and balance type.
- GL_SETS_OF_BOOKS GL — joined on
SET_OF_BOOKS_IDwith an outer join ((+)) to supply the set of books name. - PER_BUSINESS_GROUPS PER — joined on
BUSINESS_GROUP_IDwith an outer join to supply the business group name. - FND_LOOKUPS LK — joined with the constant lookup type
'PSB_BALANCE_TYPE'and matched onFDI.BALANCE_TYPE = LK.LOOKUP_CODE, again via an outer join.
Because all joining conditions other than the driving table use the Oracle outer-join operator, rows in PSB_DSS_FIN_DATA_ITEMS are retained even when a matching set of books, business group, or balance type lookup is absent. The metadata notes that the object is "not implemented in this database" and lists no referenced base objects in the documented ETRM 12.2.2 metadata, indicating the view is legacy and may not be deployed in every environment.
Key Columns
- FIN_DATA_ITEM_ID — primary identifier for the financial data item.
- NAME, FDI_LEVEL, OBJECT_NAME, COLUMN_LABEL, ROW_LABEL — descriptive and structural attributes defining the item.
- SET_OF_BOOKS_ID / SET_OF_BOOKS_NAME — ledger context; the name is sourced from
GL_SETS_OF_BOOKS. - BUSINESS_GROUP_ID / BUSINESS_GROUP_NAME — business group context from
PER_BUSINESS_GROUPS. - BALANCE_TYPE / BALANCE_TYPE_MEANING — the stored lookup code and its translated meaning from
PSB_BALANCE_TYPE. - CURRENCY_CODE, FREEZE_FLAG, DESCRIPTION — currency, freeze indicator, and free-text description.
- Audit and descriptive flexfield columns —
CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN, andCONTEXTthroughATTRIBUTE10.
Common Use Cases and Queries
Typical usage centres on resolving balance type meanings and reconciling data item definitions against ledgers. A representative query is:
SELECT fin_data_item_id, name, balance_type, balance_type_meaning FROM psb_dss_fin_data_items_v ORDER BY name;SELECT name, set_of_books_name, balance_type_meaning FROM psb_dss_fin_data_items_v WHERE balance_type = 'E';
Because the product is obsolete and the view is reportedly not implemented in some databases, administrators should verify its existence before relying on it in custom reports or integrations, and prefer supported alternatives where available.
-
Not implemented in this database·Explore PSB module →
-
Not implemented in this database·Explore PSB module →
-
Not implemented in this database·Explore PSB module →
-
Not implemented in this database·Explore PSB module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2