Results for “igc_cc_encmbrnc_ctrls”

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

Overview

The IGC_CC_ENCMBRNC_CTRLS table is a component of the Oracle E-Business Suite Contract Commitment (IGC) module, which supports the Federal and Public Sector commitment control and funds-checking functionality built on top of the core General Ledger encumbrance engine. The table's documented description — "Encumbrance type enable for contract states" — indicates that it functions as a configuration and control table within the IGC product family. Its role is to define which GL encumbrance types are enabled for the Provisional and Confirmed states of a contract commitment, effectively governing how encumbrance accounting is applied as a commitment progresses through its lifecycle states.

From a dimensional modelling perspective, the heuristic Data Vault classification derived from the foreign key structure places this object as a link. This is consistent with its design: it associates an operating unit and set of books context with two distinct references to GL_ENCUMBRANCE_TYPES, thereby resolving many-to-many style relationships between contract-state control logic and GL encumbrance type definitions. This classification should be treated as a modelling suggestion rather than an authoritative architectural assertion.

Key Information Stored

The table contains 12 documented columns that together describe the enablement of encumbrance types for contract states. The most significant columns are:

• ORG_ID — Operating unit identifier; a core business key candidate partitioning the control settings by organization.
• SET_OF_BOOKS_ID — Identifies the ledger/set of books to which the encumbrance control configuration applies.
• CC_BUDGET_TYPE — The budget type associated with the contract commitment; a key discriminator for the control record.
• CC_PROV_ENCMBRNC_TYPE_ID — Foreign key to GL_ENCUMBRANCE_TYPES; the encumbrance type used for the provisional commitment state.
• CC_CONF_ENCMBRNC_TYPE_ID — Foreign key to GL_ENCUMBRANCE_TYPES; the encumbrance type used for the confirmed commitment state.
• CC_PROV_ENCMBRNC_ENABLE_FLAG — Flag indicating whether encumbrance processing is enabled for the provisional state.
• CC_CONF_ENCMBRNC_ENABLE_FLAG — Flag indicating whether encumbrance processing is enabled for the confirmed state.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle WHO audit columns tracking the last modification.
• CREATION_DATE, CREATED_BY — Standard Oracle WHO audit columns recording initial creation.

The table does not expose an explicit single-column surrogate primary key in the documented metadata; instead, the combination of ORG_ID, SET_OF_BOOKS_ID, and CC_BUDGET_TYPE serves as the effective business key, with the two encumbrance type ID columns acting as link references to the GL encumbrance type dimension.

Common Use Cases and Queries

The primary use case is validating and reporting on how contract commitment encumbrance processing is configured per operating unit and ledger. Typical queries join the control table to GL_ENCUMBRANCE_TYPES to resolve the encumbrance type names for both provisional and confirmed states:

• Identifying which operating units have provisional or confirmed encumbrance processing disabled.
• Reporting the encumbrance types mapped to each contract state for audit and compliance review.
• Troubleshooting why a commitment did not generate expected encumbrance entries by inspecting the enable flags.

A representative SQL pattern would be:

SELECT c.ORG_ID, c.CC_BUDGET_TYPE, p.ENCUMBRANCE_TYPE_NAME prov_type, f.ENCUMBRANCE_TYPE_NAME conf_type, c.CC_PROV_ENCMBRNC_ENABLE_FLAG, c.CC_CONF_ENCMBRNC_ENABLE_FLAG FROM IGC_CC_ENCMBRNC_CTRLS c, GL_ENCUMBRANCE_TYPES p, GL_ENCUMBRANCE_TYPES f WHERE c.CC_PROV_ENCMBRNC_TYPE_ID = p.ENCUMBRANCE_TYPE_ID(+) AND c.CC_CONF_ENCMBRNC_TYPE_ID = f.ENCUMBRANCE_TYPE_ID(+) AND c.SET_OF_BOOKS_ID = :ledger_id;

Related Objects

The most significant related objects, grounded in the documented foreign key relationships, are:

• GL_ENCUMBRANCE_TYPES — Referenced twice, via CC_PROV_ENCMBRNC_TYPE_ID and CC_CONF_ENCMBRNC_TYPE_ID; the primary lookup dimension for encumbrance type definitions.
• GL_SETS_OF_BOOKS / GL_LEDGERS — Related through SET_OF_BOOKS_ID, providing ledger context.
• HR_OPERATING_UNITS — Related through ORG_ID, supplying operating unit descriptions.
• IGC_CC_COMMITMENTS and related IGC contract commitment tables — Depend on this control configuration to determine encumbrance behaviour across contract states.
• GL_BUDGET_TYPES — Related through the CC_BUDGET_TYPE business key.

These relationships confirm the table's position as a central control/link object bridging IGC commitment state processing and the GL encumbrance type master data.