Results for “cc_prov_encmbrnc_type”

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

Overview

The APPS.IGC_CC_ENCMBRNC_ORG_V view is a multi-organizational security-enabled reporting object within the IGC (Contract Commitment) product family of Oracle E-Business Suite. It consolidates encumbrance configuration data held at the operating-unit level, merging commitment-control settings from the Contract Commitment module with the encumbrance type defaults defined in Oracle Payables' financial system parameters. For each organization, the view resolves the numeric encumbrance type identifiers stored in the underlying configuration tables into their descriptive GL_ENCUMBRANCE_TYPES names, exposing a denormalized, human-readable projection of encumbrance behavior.

The object is registered under the APPS schema with a status of VALID. Its inclusion of the standard ORG_ID multi-org predicate makes it a secure view: rows are automatically filtered by the operating unit of the session, as derived from the USERENV('CLIENT_INFO') value. Users searching on the term ap_req_encmbrnc_type arrive at this view because it exposes the requisition encumbrance type — sourced from Payables parameters and surfaced as both an ID and a descriptive name — in the context of the broader Contract Commitment encumbrance model.

Underlying Base Objects

The view is defined over three referenced base objects, all accessed through APPS synonyms:

• IGC_CC_ENCMBRNC_CTRLS — the driving table (ENC), holding per-organization Contract Commitment encumbrance control configuration, including provisional and confirmed encumbrance type references and enablement flags.
• FINANCIALS_SYSTEM_PARAMS_ALL — (APF) the Payables/financials system parameter table, supplying the requisition, purchasing, and invoice encumbrance type identifiers.
• GL_ENCUMBRANCE_TYPES — joined five times (GLE1 through GLE5) to resolve each stored encumbrance type ID into its display name.

The controlling join between IGC_CC_ENCMBRNC_CTRLS and FINANCIALS_SYSTEM_PARAMS_ALL is on ORG_ID. All five lookups to GL_ENCUMBRANCE_TYPES are outer joins (denoted by the (+) operator), so configuration rows are preserved even when an encumbrance type ID is null or unresolved. The multi-org security clause compares the organization against the session client information, defaulting to -99 when no organization context is set.

Key Columns

• ROW_ID / ORG_ID — the row identifier and the operating unit that owns the configuration.
• CC_BUDGET_TYPE — the budget type associated with Contract Commitment encumbrance processing.
• CC_PROV_ENCMBRNC_TYPE_ID / CC_PROV_ENCMBRNC_TYPE — the provisional encumbrance type identifier and its resolved GL name.
• CC_CONF_ENCMBRNC_TYPE_ID / CC_CONF_ENCMBRNC_TYPE — the confirmed encumbrance type identifier and name.
• CC_PROV_ENCMBRNC_ENABLE_FLAG / CC_CONF_ENCMBRNC_ENABLE_FLAG — flags indicating whether provisional and confirmed encumbrance are enabled.
• AP_REQ_ENCMBRNC_TYPE_ID / AP_REQ_ENCMBRNC_TYPE — the requisition encumbrance type used by Payables, directly answering the user's search term.
• AP_PURCH_ENCMBRNC_TYPE_ID / AP_PURCH_ENCMBRNC_TYPE — the purchasing encumbrance type.
• AP_INV_ENCMBRNC_TYPE_ID / AP_INV_ENCMBRNC_TYPE — the invoice encumbrance type.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY.

Common Use Cases and Queries

Typical uses include verifying encumbrance setup per operating unit, diagnosing why encumbrances are or are not generated for requisitions, purchases, or invoices, and driving reconciliation or migration reports between Contract Commitment and Payables configuration.

SELECT org_id,
       ap_req_encmbrnc_type,
       ap_purch_encmbrnc_type,
       ap_inv_encmbrnc_type,
       cc_prov_encmbrnc_type,
       cc_conf_encmbrnc_type
FROM   apps.igc_cc_encmbrnc_org_v
ORDER  BY org_id;

To locate a specific requisition encumbrance type across organizations:

SELECT org_id, ap_req_encmbrnc_type_id, ap_req_encmbrnc_type
FROM   apps.igc_cc_encmbrnc_org_v
WHERE  ap_req_encmbrnc_type IS NOT NULL;

To audit recently changed configurations:

SELECT org_id, cc_budget_type, last_update_date, last_updated_by
FROM   apps.igc_cc_encmbrnc_org_v
WHERE  last_update_date >= SYSDATE - 30;