Search Results igc_cchp




Overview
Explore in AI Chat

This article is part of the ETRM reference series for Oracle E-Business Suite 12.1.1 and 12.2.2. It summarises the database view APPS.IGCFV_MC_RELEASES and its relationship to the underlying multicurrency contract tables, including IGC_CC_HEADERS_ALL, which is referenced by the view definition.

Overview

APPPS.IGCFV_MC_RELEASES is a read-only view owned by the APPS schema that presents release-level commitment contracts together with their associated multicurrency conversion attributes. It joins the contract header and parent header records in IGC_CC_HEADERS_ALL to the multicurrency extension table IGC_CC_MC_HEADERS, enriching the result with the set of books, the daily conversion rate type, and the owning organization.

The view is defined with the predicate WITH READ ONLY and applies an organization security clause (_SEC:IGC_CCH.ORG_ID). It is therefore intended as a reporting and integration surface rather than as a maintenance object; DML against the view is not permitted. Its primary role is to expose release contracts (CC_TYPE = 'R') alongside the currency conversion details needed for financial reconciliation and multi-currency reporting, while enforcing operating unit security automatically.

Underlying Base Objects

The view is defined over five documented base objects, all referenced through APPS synonyms:

  • IGC_CC_HEADERS_ALL — referenced twice in the FROM clause, once as IGC_CCH (the release contract) and once as IGC_CCHP (the parent contract). This is the key relationship the user searching for "igc_cc_headers_all" should note.
  • IGC_CC_MC_HEADERS — provides the multicurrency conversion type, conversion date, and conversion rate for the release contract; joined on CC_HEADER_ID.
  • GL_SETS_OF_BOOKS_11I — supplies the set of books name and short name through SET_OF_BOOKS_ID.
  • HR_ALL_ORGANIZATION_UNITS — supplies the organization name via ORG_ID.
  • GL_DAILY_CONVERSION_TYPES — supplies the user conversion type and description, joined with an outer (+) operator on CONVERSION_TYPE.

Because the join between the contract and its multicurrency counterpart is mandatory (no outer join), only release contracts that have a corresponding IGC_CC_MC_HEADERS row are returned.

Key Columns

Common Use Cases and Queries

Typical scenarios include multi-currency commitment reporting, rate verification for audit, and reconciliation between release contracts and their parents. The following query returns releases for a given parent contract number:

  • SELECT release_contract_number, parent_contract_number, currency_conversion_rate FROM apps.igcfv_mc_releases WHERE parent_contract_number = :parent_contract_number;

To list releases by ledger and organization:

  • SELECT release_contract_number, sets_of_books_name, organization_name FROM apps.igcfv_mc_releases WHERE organization_id = :org_id;

Because the view is read-only and enforces organization security, no additional ORG_ID filtering is required when the session context is correctly initialised. The view is therefore best used directly in reports, extracts, and interfaces rather than being recreated from its base tables.