Results for “igc_cbc_summary_templates_v”

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

Overview

IGC_CBC_SUMMARY_TEMPLATES_V is an Oracle E-Business Suite view owned by the APPS schema in the IGC (Contract Commitment) product family. It exposes summary template definitions that drive the funds check behavior for Contract Commitment (CBC) processing. Functionally, the view joins the general ledger summary template repository (GL_SUMMARY_TEMPLATES) with the Contract Commitment-specific summary template table (IGC_CBC_SUMMARY_TEMPLATES) so that a single row presents both the standard GL template attributes and any CBC-specific override flag.

The view is read-only and is primarily consumed by funds check and budgetary control logic that needs to resolve which code combination or template governs a commitment transaction. Because it carries funds check level, account category, and boundary/amount type attributes, it is central to determining how Contract Commitment transactions are validated against available funds. The metadata lists DUAL as the documented referenced base object, but the view text explicitly selects from GL_SUMMARY_TEMPLATES and IGC_CBC_SUMMARY_TEMPLATES.

Underlying Base Objects

The view is defined over two base tables joined through an outer join controlled by the CBC-specific template table:

• GL_SUMMARY_TEMPLATES (alias GST) — the primary source of summary template definitions, supplying template identity, set of books, account category, funds check level, and the segment-type descriptors for SEGMENT1_TYPE through SEGMENT30_TYPE.
• IGC_CBC_SUMMARY_TEMPLATES (alias IST) — the Contract Commitment extension table supplying the CBC_OVERRIDE flag. The join uses the (+) outer-join operator on IST.SET_OF_BOOKS_ID and IST.TEMPLATE_ID, so every GL summary template is returned regardless of whether a CBC-specific row exists.

Because of the outer join, rows from GL_SUMMARY_TEMPLATES that have no matching IGC_CBC_SUMMARY_TEMPLATES record still appear, with CBC_OVERRIDE null. The DISTINCT keyword deduplicates the result set where multiple CBC rows map to the same GL template.

Key Columns

The view exposes identified template and control attributes, including:

• TEMPLATE_ID and SET_OF_BOOKS_ID — the composite key identifying the summary template within a ledger.
• MAX_CODE_COMBINATION_ID — the user-searched column; it holds the highest code combination identifier referenced by the template, supporting account range resolution.
• FUNDS_CHECK_LEVEL_CODE — defines the funds check granularity at which the CBC template operates.
• ACCOUNT_CATEGORY_CODE, AMOUNT_TYPE, BOUNDARY_CODE, DR_CR_CODE — categorize the template and control amount/boundary treatment and debit/credit direction.
• START_ACTUALS_PERIOD_NAME and FUNDING_BUDGET_VERSION_ID — period and budget version context for actuals and funding.
• SEGMENT n_TYPE — descriptor columns (SEGMENT1_TYPE onward) indicating how each accounting flexfield segment participates in the summary.
• CBC_OVERRIDE — the CBC-specific flag indicating whether the Contract Commitment configuration overrides the base GL template behavior.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage resolves the funds check level and override behavior for a given ledger and template, or locates templates by their maximum code combination. The following query returns CBC override information for a specific ledger:

• SELECT template_id, set_of_books_id, funds_check_level_code, max_code_combination_id, cbc_override FROM igc_cbc_summary_templates_v WHERE set_of_books_id = :p_sob_id;
• SELECT template_name, account_category_code, cbc_override FROM igc_cbc_summary_templates_v WHERE max_code_combination_id = :p_ccid;
• SELECT template_id, template_name FROM igc_cbc_summary_templates_v WHERE funds_check_level_code = :p_level AND cbc_override = 'Y';

These queries support funds check diagnostics, CBC configuration review, and troubleshooting of code combination resolution in Oracle EBS 12.1.1 and 12.2.2 environments.