Results for “igc_cc_encmbrnc_ctrls_v”

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

Overview

IGC_CC_ENCMBRNC_CTRLS_V is an Oracle E-Business Suite view owned by the APPS schema and registered as VALID. It belongs to the IGC (Contract Commitment) product family, which supports the commitment control and encumbrance accounting features used by public sector and other encumbrance-enabled installations. The view exposes the encumbrance control configuration defined at the operating unit level, combining the IGC contract commitment encumbrance settings with the corresponding encumbrance type identifiers and names held in Oracle Payables and Oracle General Ledger.

Rather than presenting a single normalized entity, the view performs a denormalization that resolves numeric encumbrance type identifiers into their descriptive names. This makes the view suitable for reporting, inquiry screens, and integration extracts that must display human-readable encumbrance type values rather than internal IDs. It is read-only and inherits the security and multi-organization behavior of its underlying tables, so queries return data for the operating units visible to the connected responsibility.

Underlying Base Objects

The view is defined over seven referenced base objects identified in the ETRM metadata as synonyms: IGC_CC_ENCMBRNC_CTRLS, FINANCIALS_SYSTEM_PARAMS_ALL, and five aliased instances of GL_ENCUMBRANCE_TYPES. IGC_CC_ENCMBRNC_CTRLS is the driving table, holding the contract commitment encumbrance control records keyed by ORG_ID. FINANCIALS_SYSTEM_PARAMS_ALL is joined on ORG_ID and supplies the Payables-side encumbrance type parameters for requisitions, purchases, and invoices. The five GL_ENCUMBRANCE_TYPES aliases (GLE1 through GLE5) each resolve an encumbrance type name through an outer join on the corresponding type ID, covering the provisional and confirmed contract commitment types plus the three Payables types.

The join from IGC_CC_ENCMBRNC_CTRLS to FINANCIALS_SYSTEM_PARAMS_ALL is an inner join on ORG_ID, meaning an operating unit appears only when a matching Payables parameter row exists. All GL_ENCUMBRANCE_TYPES joins are outer joins, so rows are still returned when an encumbrance type ID is null or does not resolve to a defined type.

Key Columns

• ROW_ID — the ROWID of the underlying IGC_CC_ENCMBRNC_CTRLS row.
• ORG_ID — the operating unit that owns the control configuration.
• CC_BUDGET_TYPE — the budget type associated with the contract commitment controls.
• CC_PROV_ENCMBRNC_TYPE_ID / CC_PROV_ENCMBRNC_TYPE — the provisional contract commitment encumbrance type ID and its GL name.
• CC_CONF_ENCMBRNC_TYPE_ID / CC_CONF_ENCMBRNC_TYPE — the confirmed contract commitment encumbrance type ID and its GL name.
• CC_PROV_ENCMBRNC_ENABLE_FLAG / CC_CONF_ENCMBRNC_ENABLE_FLAG — flags indicating whether provisional and confirmed encumbrance processing is enabled.
• AP_REQ_ENCMBRNC_TYPE_ID / AP_REQ_ENCMBRNC_TYPE — the Payables requisition encumbrance type.
• AP_PURCH_ENCMBRNC_TYPE_ID / AP_PURCH_ENCMBRNC_TYPE — the Payables purchase order encumbrance type.
• AP_INV_ENCMBRNC_TYPE_ID / AP_INV_ENCMBRNC_TYPE — the Payables invoice encumbrance type.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard audit columns inherited from the base table.

Common Use Cases and Queries

Typical uses include verifying which encumbrance types are configured per operating unit, auditing the enablement flags that govern provisional and confirmed contract commitment processing, and driving reports that reconcile IGC commitment settings against Payables encumbrance parameters.

SELECT org_id,
       cc_budget_type,
       cc_prov_encmbrnc_type,
       cc_conf_encmbrnc_type,
       cc_prov_encmbrnc_enable_flag,
       cc_conf_encmbrnc_enable_flag
FROM   apps.igc_cc_encmbrnc_ctrls_v
WHERE  org_id = :p_org_id;

SELECT org_id,
       ap_req_encmbrnc_type,
       ap_purch_encmbrnc_type,
       ap_inv_encmbrnc_type
FROM   apps.igc_cc_encmbrnc_ctrls_v
ORDER  BY org_id;

Because the view joins to GL_ENCUMBRANCE_TYPES and FINANCIALS_SYSTEM_PARAMS_ALL, queries should always filter by ORG_ID in multi-organization environments to limit results to the intended operating unit and to support efficient execution.