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.
- CODE_COMBINATION_ID — the unique code combination identifier and business-key candidate.
- CHART_OF_ACCOUNTS_ID — identifies the chart of accounts to which the combination belongs.
- COMPANY_ID — the company dimension value, resolving to a legal or reporting entity.
- COMPANY_COST_CENTER_ORG_ID — the organization context associated with the company and cost center.
- COST_CENTER_ID — the cost center segment value.
- NATURAL_ACCOUNT_ID — the natural account segment value.
- PRODUCT_ID and PROD_CATEGORY_ID — product and product category dimensions.
- CATEGORY_ID — an additional categorization dimension for the combination.
- USER_DIM1_ID and USER_DIM2_ID — user-defined dimensions mapped from the accounting flexfield.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns.
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.
-
This table stores the detail information for each code combinations.
-
This is the base fact table that stores the budget and forecase data.
-
Acquisition and disposal transaction trial balances
-
This table stores budget and forecast data users will upload into the DBI system.
-
Table: FII_GL_AGRT_SUM_MV 12.1.1
-
This table stores the prior version date that we need to use during the upload process.
-
This table is used for internal processing only
-
This is a temp table for storing the encumbrance carry forward data.
-
Temporary table for GL budget extraction.
-
Base Summary table for General Ledger entries. It is used to support revenue and expenses related portlets.
-
GCS historical rates information
-
Table: FII_GL_BASE_MAP_MV 12.1.1
-
This is a table for storing the encumbrance carry forward data.
-
GCS dimension templates for retained earnings and suspense handling
-
GCS consolidation entry lines
-
Intercompany transactions table.
-
This table is used for internal processesing only
-
This is the fact table for the Asset Expense Base Summary extraction program
-
This table is used for internal processing only
-
This table is used for internal processing only.
-
This is the staging table for the Asset Expense Base Summary extraction program
-
This table stores data in FII_GL_JE_SUMMARY_B by columns.
-
This table is the staging table for AP Summary Information.
-
Cost Object Members
-
This table holds AP Summary Information. It is used to support AP and POA portlets.
-
Activity Members
-
Table: FII_GL_SNAP_SUM_F 12.1.1
This table stores aggregated snapshot data of sysdate from FII_GL_SNAP_F.
-
Table: FII_GL_SNAP_F 12.1.1
This table stores snapshot data of sysdate at master value sets level.