Search Results igcfv_mc_releases




Overview
Explore in AI Chat

Overview

The APPS.IGCFV_MC_RELEASES view is a reporting construct within the Oracle E-Business Suite IGC – Contract Commitment module. It exposes release-level (multi-currency) contract commitment data, combining header information from the parent contract commitment with the release-specific currency conversion attributes stored in the multi-currency headers table. The view carries a status of VALID and is defined WITH READ ONLY, confirming that it is intended strictly for query and reporting rather than for DML operations. It is also secured by a virtual private database (VPD) predicate against IGC_CCH.ORG_ID (visible as '_SEC:IGC_CCH.ORG_ID' IS NOT NULL in the view text), which restricts rows to the operating units accessible to the querying responsibility.

The view is primarily relevant for users reporting on foreign-currency contract commitments and their associated conversion rates. The metadata records that the search term rate_name maps to the RATE_NAME column, which surfaces the Oracle General Ledger daily conversion type used to translate the commitment into the functional currency of the selected set of books.

Underlying Base Objects

The documented base objects for this view are APPS synonyms resolving to the following tables:

Join predicates link releases to their parent commitment through PARENT_HEADER_ID, to the multi-currency header through CC_HEADER_ID, to sets of books through SET_OF_BOOKS_ID, to the organization through ORG_ID, and to conversion types through a left outer join ((+)) on CONVERSION_TYPE.

Key Columns

Common Use Cases and Queries

Typical use cases include reconciling foreign-currency release commitments to their GL conversion types, auditing which rate was applied to a given release, and exposing release data to downstream reporting or integration layers through a read-only interface. A representative query filtered by rate name is:

SELECT release_contract_number,
       release_version_number,
       rate_name,
       rate_description,
       currency_conversion_date,
       currency_conversion_rate,
       sets_of_books_name,
       organization_name
FROM   apps.igcfv_mc_releases
WHERE  rate_name = :p_rate_name
AND    organization_id = :p_org_id;

Because the view is read-only and VPD-secured, queries automatically honor the operating unit security profile of the invoking responsibility, making it suitable for both ad hoc inquiry and embedded reporting without additional access control logic.