Search Results fii_com_cc_mappings




Overview
Explore in AI Chat

Overview

The FII_COM_CC_MAPPINGS table is a Financial Intelligence (FII) module object in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores Company and Cost Center mappings to both managers and lines of business. It functions as a supporting configuration table for materialized view (MV) refresh programs, allowing FII reporting structures to resolve the correct managerial hierarchy and LOB attribution for cost center activity during data aggregation.

From a heuristic Data Vault modeling perspective, the mined foreign key structure classifies this object as standalone, meaning it does not act as a hub, link, or satellite within a conventional Data Vault construct. It is best treated as a reference or mapping table rather than a transactional fact source. The table is owned by the FII schema and holds 13 documented columns.

Key Information Stored

The table's principal purpose is to preserve the relationship between a cost center organization and its assigned manager and line of business. The most significant columns are:

The foreign key FII_COM_CC_MAPPINGS.COMPANY_ID references PN_COMPANIES_ALL, anchoring each mapping to a valid company definition.

Common Use Cases and Queries

Typical usage centers on resolving manager and LOB attribution for cost centers during FII reporting, and on auditing mapping completeness. A representative query retrieves the active mappings for a given company:

  • SELECT cc.COMPANY_ID, cc.COST_CENTER_ID, cc.MANAGER_ID, cc.LOB_ID FROM FII.FII_COM_CC_MAPPINGS cc WHERE cc.COMPANY_ID = :company_id AND cc.VALID_MGR_FLAG = 'Y';
  • Join to PN_COMPANIES_ALL to validate that each mapping points to a known company: SELECT ... FROM FII.FII_COM_CC_MAPPINGS cc, PN_COMPANIES_ALL pc WHERE cc.COMPANY_ID = pc.COMPANY_ID;
  • Detect orphan or stale mappings by comparing MANAGER_ID/PARENT_MANAGER_ID against current HR supervisor assignments prior to an MV refresh.

Reporting use cases include pre-refresh validation of cost center coverage, reconciliation of LOB roll-ups, and troubleshooting of missing or inconsistent manager assignments in FII dashboards.

Related Objects

The following objects are the most significant dependencies and references for FII_COM_CC_MAPPINGS:

  • PN_COMPANIES_ALL — Referenced via the COMPANY_ID foreign key.
  • FII_COM_CC_MAPPINGS_U1 — Unique index on COMPANY_COST_CENTER_ORG_ID.
  • FII_COM_CC_MAPPINGS_U2 — Unique index on COMPANY_ID and COST_CENTER_ID.
  • FII materialized views and MV refresh programs that consume these mappings for manager and LOB attribution.
  • Human Resources manager/supervisor entities used to validate MANAGER_ID and PARENT_MANAGER_ID values.

Because the object is classified as standalone, no additional foreign-key-documented dependents exist beyond the PN_COMPANIES_ALL reference.