Search Results is_leaf_flag




Overview
Explore in AI Chat

Overview

APPS.FII_CCC_VALUES_V is a dimensional value-set view in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, shipped as part of the Financial Intelligence (FII) / Enterprise Performance Foundation (EPF) data model that underlies Oracle's BI and transfer-pricing engines. The view unifies two distinct hierarchies — company and cost center — into a single result set that can be consumed by downstream dimensional modelers, BI Publisher reports, and ETL routines. It is a UNION-based consolidation view rather than a base table, exposing the members of two segment hierarchies (FII_COMPANIES and HRI_CL_ORGCC) side-by-side with a dimension discriminator.

Underlying Base Objects

Although the ETRM metadata documents no referenced base objects, the view text reveals its true dependencies. It is composed of four UNION branches:

  • FII_COMPANY_VALUES_V — supplies the company member set, tagged with dimension 'FII_COMPANIES'.
  • A DUAL seed row producing the "ALL" aggregate member for FII_COMPANIES (ID = -999).
  • FII_COST_CENTER_VALUES_V — supplies the cost center member set, tagged with dimension 'HRI_CL_ORGCC'.
  • A DUAL seed row producing the "ALL" aggregate member for HRI_CL_ORGCC (ID = -999).

The two seed rows call FND_MESSAGE.GET_STRING('BIS','ALL') and FND_MESSAGE.GET_STRING('BIS','BIS_GRANTS_ALL_VALUES') to source localized labels from the FND message dictionary, ensuring language-specific "All" and "All Granted Values" text. Note the important relationship to the user's search term: HRI_CL_ORGCC is the dimension name used for cost center values, so FII_CCC_VALUES_V is effectively the access point for the cost center (CCC = Corporate/Cost Center Chart) member list.

Key Columns

  • DIMENSION — literal discriminator indicating the source hierarchy; either 'FII_COMPANIES' or 'HRI_CL_ORGCC'.
  • ID — internal numeric key for the member. A value of -999 denotes the special aggregate "ALL" member present in each dimension.
  • VALUE — display/segment value shown to users (from FND_MESSAGE for the ALL row).
  • DESCRIPTION — descriptive text for the member.
  • IS_LEAF_FLAG — indicates whether the member is a leaf node in the hierarchy; NULL for the synthetic ALL rows.

Common Use Cases and Queries

Typical use is enumerating available dimension members for a picker or validation, or joining CCC values to fact data. For example, retrieving all cost center members:

SELECT id, value, description, is_leaf_flag FROM apps.fii_ccc_values_v WHERE dimension = 'HRI_CL_ORGCC' AND id <> -999 ORDER BY value;

To obtain the aggregate member for a hierarchy:

SELECT value, description FROM apps.fii_ccc_values_v WHERE dimension = 'HRI_CL_ORGCC' AND id = -999;

Because the view merges two dimensions, always filter on DIMENSION to avoid mixing company and cost center members. Applications such as EPF dimensional loaders and FII-based transfer pricing setups query this view to populate value-set members, making it central when the user search term hri_cl_orgcc is referenced.