Search Results edw_local_system_parameters




Overview
Explore in AI Chat

Overview

FIIBV_PROJ_CATEG5_LCV is a Financial Intelligence (FII) base view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the Category 5 base view for the Project dimension within the Enterprise Data Warehouse (EDW). In the FII architecture, base views such as this one are the lowest layer of the reporting stack: they normalize and conform source transaction-level data into standardized dimension attributes that feed higher-level materialized views and star-schema fact tables. The Project dimension is one of the core analytical axes in Financial Intelligence, enabling expenditure, commitment, and budget reporting across the enterprise.

The view's specific purpose is to expose Project Class Category 5 as a queryable dimension segment. It joins the PA_CLASS_CATEGORIES base table to EDW control tables so that the currently active Category 5 value defined for the EDW instance is correctly qualified and surfaced for downstream reporting.

Underlying Base Objects

The view text documented in the ETRM metadata identifies three referenced objects:

  • PA_CLASS_CATEGORIES (alias CL) — the Projects module table holding valid class category codes, including CLASS_CATEGORY and LAST_UPDATE_DATE.
  • EDW_LOCAL_SYSTEM_PARAMETERS (alias CT) — the local control/parameter table that stores the configured Category 5 selector in the CLASS_CATEG5 column. This is the object most relevant to the user's search term "edw_local_system_parameters."
  • EDW_LOCAL_INSTANCE (alias ELI) — provides INSTANCE_CODE, identifying the local EDW instance against which the parameter is resolved.

The defining join is CL.CLASS_CATEGORY = CT.CLASS_CATEG5, which restricts the returned class category to the single Category 5 value configured in the EDW local system parameters for that instance. This parameter-driven design allows the same view definition to serve multiple EDW instances with different Category 5 configurations without code changes.

Key Columns

  • PROJ_CATEG5_PK — surrogate primary key for the Category 5 dimension row.
  • NAME — the concatenated composite identifier, produced as CLASS_CATEGORY || '-' || ELI.INSTANCE_CODE, giving a globally unique dimension name per instance.
  • PROJECT_CATEGORY5 — the actual Category 5 class category value exposed for reporting and joining to facts.
  • ALL_FK — a constant 'ALL' foreign key supporting the "all values" aggregate row in the star schema.
  • INSTANCE — the EDW instance code from EDW_LOCAL_INSTANCE.
  • LAST_UPDATE_DATE — inherited from PA_CLASS_CATEGORIES, used for incremental extract and change tracking.
  • "_DF:PCT:_EDW" and the descriptor expression '_DF:PA:PA_CLASS_CATEGORIES_DESC_FLEX:CL' — Flexfield descriptor metadata supporting descriptive flexfield (DFF) handling in the FII extraction framework.

Common Use Cases and Queries

This view is typically consumed by FII dimension extraction programs, BI Publisher reports, and custom analyses requiring Project Category 5 as a pivot or filter. A representative query returning the configured category for the current instance follows:

  • SELECT NAME, PROJECT_CATEGORY5, INSTANCE, LAST_UPDATE_DATE FROM APPS.FIIBV_PROJ_CATEG5_LCV;
  • SELECT PROJECT_CATEGORY5 FROM APPS.FIIBV_PROJ_CATEG5_LCV WHERE INSTANCE = :p_instance;

Because the view is entirely parameter-driven by EDW_LOCAL_SYSTEM_PARAMETERS, diagnostics on an unexpected or empty result set should begin by verifying CLASS_CATEG5 in that table for the instance in question. Administrators should treat FIIBV_PROJ_CATEG5_LCV as read-only and never modify its definition, as the Financial Intelligence extraction layer depends on its structure.