Results for “fdi_level”

2 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_ID with an outer join ((+)) to supply the set of books name.
  • PER_BUSINESS_GROUPS PER — joined on BUSINESS_GROUP_ID with an outer join to supply the business group name.
  • FND_LOOKUPS LK — joined with the constant lookup type 'PSB_BALANCE_TYPE' and matched on FDI.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

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.