Search Results release_contract_commitment_id




Overview
Explore in AI Chat

Overview

IGCBV_MC_RELEASES is an APPS-owned, read-only view within the Oracle E-Business Suite product IGC (Contract Commitment). It presents the relationship between a contract commitment header and the multi-currency (MC) release records that are associated with it, exposing both the release contract commitment and its parent contract commitment in a single, denormalized result set. The view is defined with the WITH READ ONLY clause, meaning it is intended strictly for query and reporting purposes and cannot be used as the target of DML operations. Its primary role is to support reporting and integration scenarios where release-level contract commitment information must be joined with currency conversion details and the associated set of books.

Because the view presents release contract numbers alongside parent contract commitment identifiers, it is frequently used when users need to trace a release back to its originating contractual commitment, or when they need to report on conversion rates and dates applied to those releases across multiple ledgers. The column name RELEASE_CONTRACT_NUMBER is the alias applied to the underlying IGC_CCH.CC_NUM value, which is why searches using that term resolve to this view.

Underlying Base Objects

The view is defined over three documented base objects:

  • GL_SETS_OF_BOOKS_11I (exposed as the synonym GL_SETS_OF_BOOKS) — provides the set of books name and short name, and is joined on SET_OF_BOOKS_ID.
  • IGC_CC_HEADERS_ALL (aliased IGC_CCH) — the parent contract commitment header, supplying the release contract number (CC_NUM), version number, organization ID, and parent header ID.
  • IGC_CC_MC_HEADERS — the multi-currency header records, supplying the conversion type, conversion date, conversion rate, release contract commitment ID, and set of books ID.

The join is driven by the equalities IGC_CC_MC_HEADERS.CC_HEADER_ID = IGC_CCH.CC_HEADER_ID and IGC_CC_MC_HEADERS.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID. A security predicate, '_SEC:IGC_CCH.ORG_ID' IS NOT NULL, enforces multi-org access control (MOAC) so that only data for organizations the user is authorized to view is returned.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling release contracts to their parents, auditing conversion rates applied to releases in a given ledger, and feeding downstream reporting or integration extracts. Because the view is read-only and security-filtered, it is safe to use in custom reports and interfaces.

Example query listing releases for a given ledger:

  • SELECT release_contract_number, release_version_number, currency_conversion_type, currency_conversion_rate, sets_of_books_name, parent_contract_commitment_id FROM igcbv_mc_releases WHERE set_of_books_id = :p_sobid;
  • SELECT release_contract_number, release_contract_commitment_id, parent_contract_commitment_id FROM igcbv_mc_releases ORDER BY release_contract_number;

Note that the view reflects the ETRM 12.2.2 metadata; the same structure is expected to be compatible with 12.1.1 environments where the IGC Contract Commitment schema is present.