Search Results fii_ccc_values_v




Overview
Explore in AI Chat

Overview

FII_CCC_VALUES_V is a database view owned by the APPS schema within the Financial Intelligence (FII) product family of Oracle E-Business Suite. Its documented purpose is to return company cost center values for WebADI upload. In practical terms, the view acts as a value source for WebADI-based integrations and desktop uploads where users must select or validate a combination of a company and a cost center. Rather than exposing raw key flexfield structures, the view presents a denormalized, user-friendly list of dimension members consisting of company values and cost center values, together with their identifiers, display values, descriptions, and hierarchy (leaf) indicators.

The view is marked VALID in ETRM, confirming that it compiles successfully against the referenced objects in both the 12.1.1 and 12.2.2 releases. It is typically consumed as a validation or list-of-values source rather than as a transactional reporting view, and its output is oriented toward populating pick lists and validating user input during upload processing.

Underlying Base Objects

The view text is defined as a UNION of four SELECT statements, two of which read from other FII reporting views and two of which generate synthetic "ALL" rows from DUAL. The referenced objects are:

The two FND_MESSAGE.GET_STRING calls resolve the message names 'ALL' and 'BIS_GRANTS_ALL_VALUES' from the BIS application, producing a translated "All" label and a descriptive string indicating that all values are granted. This design ensures the "ALL" option is presented in the user's language.

Key Columns

  • DIMENSION — Literal discriminator identifying which dimension a row belongs to. Values are 'FII_COMPANIES' for company rows and 'HRI_CL_ORGCC' for cost center rows.
  • ID — Numeric identifier for the dimension member, sourced from the underlying value views. The synthetic "ALL" rows use the reserved value -999.
  • VALUE — The display value of the member. For the "ALL" rows this is the translated string returned by FND_MESSAGE.GET_STRING('BIS','ALL').
  • DESCRIPTION — Descriptive text for the member. For the "ALL" rows this is the message string 'BIS_GRANTS_ALL_VALUES'.
  • IS_LEAF_FLAG — Indicates whether the member is a leaf (detail) node in the hierarchy. It is NULL for the synthetic "ALL" rows.

Common Use Cases and Queries

Typical usage involves constraining the DIMENSION column to retrieve only one dimension's values, for example when populating a WebADI parameter or validating a company selection:

  • Retrieve all company values: SELECT ID, VALUE, DESCRIPTION FROM APPS.FII_CCC_VALUES_V WHERE DIMENSION = 'FII_COMPANIES' ORDER BY VALUE;
  • Retrieve cost center values: SELECT ID, VALUE, DESCRIPTION FROM APPS.FII_CCC_VALUES_V WHERE DIMENSION = 'HRI_CL_ORGCC';
  • List only leaf members, excluding the synthetic "ALL" row: SELECT * FROM APPS.FII_CCC_VALUES_V WHERE IS_LEAF_FLAG = 'Y';
  • Look up a specific member by value: SELECT ID FROM APPS.FII_CCC_VALUES_V WHERE DIMENSION = 'FII_COMPANIES' AND VALUE = :p_value;

Because the view always includes an "ALL" option per dimension, WebADI templates can offer a convenient wildcard selection. Implementers should be aware that the -999 sentinel ID and NULL leaf flag distinguish these aggregate rows, so downstream logic must handle them explicitly to avoid unintended matches.