Results for “user_dim2_id”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FII_GL_CCID_DIMENSIONS is a Financial Intelligence (FII) table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. Its documented purpose is to store the detail information for each code combination, decomposing an Oracle General Ledger code combination identifier (CCID) into its constituent accounting flexfield segments and associated analytical dimensions. In practice, this object serves as a denormalized, query-optimized representation of the accounting flexfield, allowing FII reporting and analytics components to resolve a CCID into meaningful business attributes without repeatedly traversing the key flexfield structures.

The ETRM metadata classifies FII_GL_CCID_DIMENSIONS heuristically as a standalone object under the Data Vault model. This classification suggests it be modeled as an independent hub-like structure keyed on the code combination, rather than as a link or satellite bridging multiple business entities. Notably, the documentation flags FII as obsolete and states that the table is "Not implemented in this database" in the reference environment. Its owner is FII, and the documented physical schema contains 16 columns. Because the product is obsolete in 12.1.1 and 12.2.2, the table should generally be treated as a legacy or inactive artifact, and its presence in a given instance should be verified before any dependency is built upon it.

Key Information Stored

The table's surrogate and primary access key is CODE_COMBINATION_ID, which is also the sole documented unique index (FII_GL_CCID_DIMENSIONS_U1) and therefore the business-key candidate. This column carries the General Ledger code combination identifier that the remaining columns elaborate.

Together, these columns translate a single CCID into the segment-level and analytical attributes required for dimensional reporting.

Common Use Cases and Queries

Typical usage resolves a CCID into descriptive segment values for financial reporting, or pivots balances by company, cost center, account, and product dimensions. A representative pattern joins the table to itself or to GL structures on the key columns:

  • Resolving CCID attributes: select COMPANY_ID, COST_CENTER_ID, NATURAL_ACCOUNT_ID, PRODUCT_ID from FII_GL_CCID_DIMENSIONS where CODE_COMBINATION_ID = :ccid.
  • Dimension roll-up reporting: group balances by CHART_OF_ACCOUNTS_ID, COST_CENTER_ID, and NATURAL_ACCOUNT_ID.
  • Product profitability: filter on PROD_CATEGORY_ID and PRODUCT_ID to aggregate revenue and cost.
  • Validation and reconciliation: compare COMPANY_ID and COST_CENTER_ID against GL code combination segment values to detect mapping drift.

Because the object is documented as obsolete and not implemented in the reference database, queries should be guarded against empty or absent tables in 12.1.1 and 12.2.2 environments.

Related Objects

The documented foreign keys tie this table to master and reference tables that supply its dimensional values. The most significant relationships are:

  • GL_MGT_SEG_UPGRADE_H — referenced through FII_GL_CCID_DIMENSIONS.CHART_OF_ACCOUNTS_ID, supporting management segment upgrade processing.
  • PN_COMPANIES_ALL — referenced through COMPANY_ID, supplying company definitions.
  • FND_DM_PRODUCTS — referenced through PRODUCT_ID, providing product master data.

Beyond these, the table logically depends on General Ledger code combination structures (GL_CODE_COMBINATIONS and related GL key flexfield tables) that define CODE_COMBINATION_ID, and it feeds FII reporting entities that consume resolved code combination dimensions. Any migration or reporting design touching FII should trace these dependencies before relying on the object.