Search Results icst_pk

Overview

IGC_CBC_SUMMARY_TEMPLATES is a reference table in the IGC (Contract Commitment) product family within Oracle E-Business Suite, holding funds check level information specific to contract commitments. Its purpose is to associate each Oracle General Ledger summary template with a specific set of books and to control whether commitment budgetary control (CBC — Commitment Budgetary Control) is overridden at that level. In practice the table acts as a bridge between the General Ledger summary template definitions and the set of books under which contract commitment funds checking is performed, allowing organizations to apply different CBC behavior by ledger and by summary template.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as a link. This is a modeling suggestion rather than a physical implementation detail: the table sits between two reference entities (GL_SETS_OF_BOOKS and GL_SUMMARY_TEMPLATES) and carries the relationship plus a small number of descriptive attributes, which is the characteristic shape of a link construct.

Key Information Stored

The physical schema documents eight columns. The most significant are described below.

• TEMPLATE_ID — Surrogate primary key (ICST_PK) and the business-key candidate. It also carries the unique index IGC_CBC_SUMMARY_TEMPLATES_U1 and is a foreign key to GL_SUMMARY_TEMPLATES.TEMPLATE_ID. It identifies the GL summary template that this row governs.
• SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS, identifying the ledger or set of books to which the summary template / CBC configuration applies.
• CBC_OVERRIDE — The functional flag that determines whether the commitment budgetary control setting is overridden for this template / set of books combination. This is the core business attribute of the table.
• LAST_UPDATE_DATE — Standard EBS audit column recording the last modification timestamp.
• LAST_UPDATED_BY — Standard EBS audit column recording the application user who last modified the row.
• LAST_UPDATE_LOGIN — Standard EBS audit column recording the login/user session associated with the last update.
• MIG_RESULT_CODE — Migration result code, typically populated during data migration or upgrade processing.
• MIG_REQUEST_ID — Migration request identifier linking the row to a migration or concurrent request run.

The surrogate key (TEMPLATE_ID) and the business-key candidate (the unique index on TEMPLATE_ID) coincide in the documented metadata, indicating a one-to-one correspondence between a summary template and its CBC configuration row per set of books.

Common Use Cases and Queries

Typical usage centers on determining the effective CBC behavior for a given ledger and summary template, and on auditing configuration across sets of books. A representative query joins the template table to GL_SUMMARY_TEMPLATES and GL_SETS_OF_BOOKS:

• Identify all templates overriding CBC for a specific ledger: SELECT template_id, cbc_override FROM igc_cbc_summary_templates WHERE set_of_books_id = :ledger_id;
• Resolve template names alongside override flags: join IGC_CBC_SUMMARY_TEMPLATES.TEMPLATE_ID to GL_SUMMARY_TEMPLATES to display the template name and description.
• Validate configuration completeness: compare the set of summary templates defined in GL against those having a CBC override row, to detect templates that inherit default behavior.
• Audit changes: use LAST_UPDATE_DATE, LAST_UPDATED_BY and LAST_UPDATE_LOGIN to trace configuration modifications over time.
• Migration verification: filter on MIG_RESULT_CODE and MIG_REQUEST_ID to reconcile rows loaded or converted during an upgrade or data migration.

Related Objects

The following objects are directly referenced or closely related through the documented foreign key relationships and shared IGC functionality.

• GL_SUMMARY_TEMPLATES — Referenced via IGC_CBC_SUMMARY_TEMPLATES.TEMPLATE_ID to GL_SUMMARY_TEMPLATES.TEMPLATE_ID. Supplies the template definition and name.
• GL_SETS_OF_BOOKS — Referenced via IGC_CBC_SUMMARY_TEMPLATES.SET_OF_BOOKS_ID to GL_SETS_OF_BOOKS. Identifies the ledger under which the override applies.
• IGC_CBC_* companion tables — Other IGC contract commitment / CBC configuration tables that share the same set of books and template keys.
• IGC Contract Commitment APIs and concurrent programs — The funds check and commitment validation logic that reads the CBC_OVERRIDE flag during funds checking.

Because IGC_CBC_SUMMARY_TEMPLATES carries only the override flag and audit columns, any reporting solution should join it to GL_SUMMARY_TEMPLATES and GL_SETS_OF_BOOKS to produce meaningful descriptions rather than resolving IDs in isolation.