Results for “fii_slg_assignments”

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

Overview

The FII_SLG_ASSIGNMENTS table resides in the FII schema and belongs to the Financial Intelligence (FII) product family within Oracle E-Business Suite. Its documented purpose is to store ledger assignment details for source ledger groups, functioning as a bridge between a source ledger group definition and the specific ledgers and balancing segment values that participate in that grouping. In ETRM 12.1.1 the table is physically documented with thirteen columns and is flagged as VALID; the same structural characteristics carry forward to 12.2.2 deployments where FII is licensed. Because it maps source ledger groups to individual ledgers and balance segment values, it is fundamentally a configuration and assignment table rather than a transactional fact table.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. This suggests the table be modeled as its own hub-like structure rather than as a dependent satellite or link, since the documented FK activity does not reveal a strong parent-child dependency chain to other FII tables. Analysts building a dimensional or Data Vault layer on top of EBS should treat FII_SLG_ASSIGNMENTS as a reference/assignment entity that supplies the ledger-to-group relationships consumed by downstream Financial Intelligence reporting.

Key Information Stored

The surrogate primary key is FII_SLG_ASSIGNMENTS_PK, defined over the composite of SOURCE_LEDGER_GROUP_ID, LEDGER_ID, and BAL_SEG_VALUE_ID. A parallel unique index, FII_SLG_ASSIGNMENTS_U1, is documented over the same three columns, confirming this triplet as the business-key candidate that guarantees one assignment row per source ledger group, ledger, and balancing segment value combination.

• SOURCE_LEDGER_GROUP_ID — identifies the source ledger group to which the assignment belongs; part of both the PK and the unique business key.
• LEDGER_ID — the ledger assigned to the group; also part of the composite PK and unique key.
• BAL_SEG_VALUE_ID — the balancing segment value (typically the company/entity segment) included in the assignment; completes the PK.
• CHART_OF_ACCOUNTS_ID — links the assignment to a chart of accounts; this is the column carrying the documented foreign key relationship.
• BAL_SEG_VALUE_SET_ID — the value set that governs the balancing segment value.
• BAL_SEG_VALUE — the stored (denormalized) balancing segment value text for reporting convenience.
• INCLUDE_ALL_JE_FLAG — a flag controlling whether all journal entries are included in the grouping.
• JE_RULE_SET_ID — references the journal entry rule set applied to the assignment.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit columns recording who created and last modified each assignment row.

Common Use Cases and Queries

Typical usage centers on answering which ledgers and balancing segment values are assigned to a given source ledger group, and on validating configuration before Financial Intelligence consolidation or reporting runs.

• Enumerate assignments for a specific group: SELECT ledger_id, bal_seg_value, include_all_je_flag FROM fii.fii_slg_assignments WHERE source_ledger_group_id = :group_id;
• Resolve assignments enriched with ledger and value-set context by joining LEDGER_ID to GL_LEDGERS and BAL_SEG_VALUE_SET_ID to FND_FLEX_VALUE_SETS.
• Audit configuration drift by comparing BAL_SEG_VALUE against the current GL balances for the same ledger, catching stale assignments that survive ledger or COA changes.
• Reporting: provide the assignment map that downstream Financial Intelligence extracts use to scope which ledgers feed a consolidated view.

Related Objects

The FK metadata documents a relationship from CHART_OF_ACCOUNTS_ID to GL_MGT_SEG_UPGRADE_H, and the following objects are the most significant references or dependents for this table:

• GL_MGT_SEG_UPGRADE_H — joined on CHART_OF_ACCOUNTS_ID; the documented FK target for segment upgrade history.
• GL_LEDGERS — joined on LEDGER_ID to resolve ledger names and currencies.
• FND_FLEX_VALUE_SETS — joined on BAL_SEG_VALUE_SET_ID to identify the balancing segment value set.
• FND_FLEX_VALUES — joined on BAL_SEG_VALUE_ID/BAL_SEG_VALUE for segment value descriptions.
• FII_SLG (Source Ledger Groups) — the parent grouping concept referenced by SOURCE_LEDGER_GROUP_ID.
• GL_JE_RULE_SETS — joined on JE_RULE_SET_ID to describe the applied journal entry rule set.

Oracle Proprietary, Confidential Information — Legal Notices apply to all documented ETRM objects referenced above.