Search Results dr_cr_meaning

Overview

IGC_CBC_SUMMARY_TEMPLATE_FCL_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 view owned by the APPS schema. It belongs to the IGC (Contract Commitment) product family and serves as the presentation-layer data source for the CBC Funds Check Level form. The view consolidates configuration records that define how budgetary funds checks are performed against commitments, joining GL summary template definitions with IGC-specific CBC summary template overrides. It is registered as a VALID object in EBS and is intended for read-only consumption by forms and reports rather than direct DML.

The view's primary purpose is to expose summary template attributes in a human-readable form by resolving otherwise opaque coded values through GL_LOOKUPS. Status codes, account category codes, funds check level codes, and debit/credit indicators are all translated into their lookup meanings, allowing the Funds Check Level setup form to display descriptive text instead of raw codes. This makes the view a critical bridge between the technical definition stored in GL_SUMMARY_TEMPLATES and the user-facing configuration experience within the IGC module.

Underlying Base Objects

The view is defined over the following documented base objects:

• GL_SUMMARY_TEMPLATES (GST) — the primary driver table, supplying template identity, set of books, status, template name, account category code, funds check level code, amount type, boundary code, debit/credit code, funding budget version, and the full SEGMENT1_TYPE through SEGMENT30_TYPE column set.
• IGC_CBC_SUMMARY_TEMPLATES (IST) — the IGC-specific extension table, outer-joined on SET_OF_BOOKS_ID and TEMPLATE_ID, contributing the CBC_OVERRIDE flag.
• GL_LOOKUPS (GL1, GL2, GL3, GL4) — four lookup aliases resolving SUMMARY_STATUS, ACCOUNT_CATEGORY_CODE, the SBC funds check level meaning, and the DR_CR meaning respectively, each outer-joined on LOOKUP_TYPE and LOOKUP_CODE.
• GL_BUDGET_VERSIONS (GBV) — supplies the FUNDING_BUDGET_NAME associated with FUNDING_BUDGET_VERSION_ID.

Notably, the ETRM-documented base object listing shows DUAL (SYNONYM) as a referenced object, reflecting the lookup joins in the underlying SQL. In Oracle EBS 12.2.2 the view continues to reference the edition-based GL_LOOKUPS and GL_SUMMARY_TEMPLATES objects, so it resolves consistently under the online patching (adop) architecture.

Key Columns

• TEMPLATE_ID, TEMPLATE_NAME — unique identifier and descriptive name of the summary template.
• SET_OF_BOOKS_ID, FUNDING_BUDGET_VERSION_ID, FUNDING_BUDGET_NAME — accounting context and the budget version used for funding checks.
• STATUS, SUMMARY_STATUS — the raw status code and its GL_LOOKUPS meaning.
• ACCOUNT_CATEGORY_CODE, ACCOUNT_CATEGORY — the category code and its resolved lookup meaning.
• FUNDS_CHECK_LEVEL_CODE, SBC_FUNDS_CHECK_MEANING — the funds check level and its descriptive SBC meaning.
• DR_CR_CODE, DR_CR_MEANING — debit/credit indicator and its description.
• AMOUNT_TYPE, BOUNDARY_CODE, MAX_CODE_COMBINATION_ID, START_ACTUALS_PERIOD_NAME — amount and boundary configuration.
• SEGMENT1_TYPE … SEGMENT30_TYPE — segment-level type assignments for the summary template.
• CBC_OVERRIDE — from IGC_CBC_SUMMARY_TEMPLATES, indicating an IGC-specific override.
• ROW_ID, audit columns — ROWID and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE).

Common Use Cases and Queries

The view supports Funds Check Level form rendering, template audits, and reconciliation between GL and IGC summary definitions. Typical queries include:

• Listing active templates with resolved statuses:
  SELECT template_id, template_name, summary_status, funds_check_level_code, sbc_funds_check_meaning FROM igc_cbc_summary_template_fcl_v WHERE status = 'A';
• Identifying IGC overrides:
  SELECT template_name, cbc_override FROM igc_cbc_summary_template_fcl_v WHERE cbc_override = 'Y';
• Auditing funds check level usage per budget:
  SELECT funding_budget_name, sbc_funds_check_meaning, COUNT(*) FROM igc_cbc_summary_template_fcl_v GROUP BY funding_budget_name, sbc_funds_check_meaning;

Because the view is read-only and aggregates lookup translations, it is unsuitable for insert or update operations; modifications must target the underlying GL_SUMMARY_TEMPLATES or IGC_CBC_SUMMARY_TEMPLATES tables directly.