Search Results igc_ccbce_pk

Overview

The table IGC.IGC_CC_BC_ENABLE is a configuration-level data object within the Oracle E-Business Suite IGC — Contract Commitment module. Its documented description, "Commitment budgetary control enable," indicates that the table governs whether budgetary control is activated for commitment transactions at the level of an individual ledger. Each row represents the budgetary control enablement status for a given set of books, allowing implementers and administrators to switch budgetary control behavior on or off per accounting ledger without modifying application code.

Under the heuristic Data Vault classification derived from its foreign key structure, this table is assessed as satellite-leaning. This classification is offered as a modeling suggestion rather than a normative Oracle definition. The reasoning is straightforward: the table is keyed by SET_OF_BOOKS_ID, which is itself a foreign key to GL_SETS_OF_BOOKS. The ledger therefore acts as the parent business key, while the enablement flags and audit columns in this table describe attributes of that ledger. In Data Vault terms, this positions GL_SETS_OF_BOOKS (or its surrogate) as the hub and IGC_CC_BC_ENABLE as a satellite capturing descriptive, potentially time-variant state about budgetary control enablement.

Key Information Stored

The documented physical schema for ETRM 12.2.2 lists eight columns. The most significant are summarized below.

• SET_OF_BOOKS_ID — The ledger identifier. This column is both the surrogate primary key component and the sole business-key candidate, enforced by the unique index IGC_CC_BC_ENABLE_U1. It also carries the foreign key relationship to GL_SETS_OF_BOOKS.
• CC_BC_ENABLE_FLAG — The primary control flag indicating whether commitment budgetary control is enabled for the associated ledger. This is the functional heart of the table.
• CBC_PO_ENABLE — An additional enablement indicator, documented as a distinct column, governing a related budgetary control behavior (typically associated with purchase order commitment processing).
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording when and by whom the enablement configuration was most recently changed.
• CREATION_DATE, CREATED_BY — Standard audit columns recording the initial insertion of the configuration row.

The surrogate primary key IGC_CCBCE_PK is defined on SET_OF_BOOKS_ID, and the unique index IGC_CC_BC_ENABLE_U1 reinforces the same column as the business key. In practice, the surrogate and business key coincide here, since the ledger identifier is a natural key supplied by GL_SETS_OF_BOOKS.

Common Use Cases and Queries

The predominant use case is determining, for a given ledger, whether commitment budgetary control is active. This is essential before commitment transactions are processed, since the enablement flag governs whether funds checking is applied against commitments. A typical query joins the configuration table to the ledger definition:

• Enablement lookup by ledger: SELECT c.SET_OF_BOOKS_ID, c.CC_BC_ENABLE_FLAG, c.CBC_PO_ENABLE FROM IGC.IGC_CC_BC_ENABLE c WHERE c.SET_OF_BOOKS_ID = :ledger_id;
• Listing all enabled ledgers: SELECT g.name, c.CC_BC_ENABLE_FLAG FROM IGC.IGC_CC_BC_ENABLE c, GL_SETS_OF_BOOKS g WHERE c.SET_OF_BOOKS_ID = g.SET_OF_BOOKS_ID AND c.CC_BC_ENABLE_FLAG = 'Y';
• Audit and change tracking: Reporting on LAST_UPDATE_DATE, LAST_UPDATED_BY, and CREATED_BY to identify who altered budgetary control configuration for a ledger and when, supporting SOX or internal control reviews.

Because the table stores configuration rather than transactional volume, it is typically referenced by setup validation logic and reconciliation reports rather than high-volume operational queries.

Related Objects

The documented foreign key relationship ties this table directly to the General Ledger ledger definition, and its role in Contract Commitment links it to the broader commitment processing model. The most significant related objects are:

• GL_SETS_OF_BOOKS — Referenced by IGC_CC_BC_ENABLE.SET_OF_BOOKS_ID; supplies the ledger name and accounting context used in all joins.
• IGC_CC_BC_ENABLE_U1 — Unique index on SET_OF_BOOKS_ID, enforcing one configuration row per ledger.
• IGC_CCBCE_PK — Primary key constraint on SET_OF_BOOKS_ID.
• IGC Contract Commitment transaction and setup tables that consume the enablement flags when performing funds checking.
• General Ledger budgetary control setup and funds availability objects that operate alongside commitment enablement.

Together these objects form the configuration foundation that determines how commitment budgetary control behaves for each ledger in Oracle EBS 12.1.1 and 12.2.2.