Results for “rate_description”

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

Overview

IGCFV_MC_CONTRACT_COMMITMENTS is a read-only database view owned by the APPS schema within the Oracle E-Business Suite. It belongs to the IGC product family, which supports Contract Commitment processing in Oracle Grants and Contracts accounting flows. The view consolidates contract commitment header data with multi-currency (MC) conversion attributes, general ledger conversion type definitions, ledger (sets of books) information, and the operating unit organization name. Its primary role is to present a denormalized, reporting-friendly projection of contract commitments so that functional users and downstream reporting tools can retrieve commitment numbers, currency conversion details, ledger context, and organization context in a single query rather than joining multiple base tables manually.

The metadata records that the view text is defined with a WITH READ ONLY clause, and the WHERE predicate includes the internal security construct '_SEC:IGC_CCH.ORG_ID' IS NOT NULL, which enforces row-level organization security through the EBS security framework. This means the view respects Multi-Org Access Control (MOAC) and will only return commitments for organizations the querying responsibility is authorized to access.

Underlying Base Objects

Per the documented ETRM metadata (12.2.2), IGCFV_MC_CONTRACT_COMMITMENTS is defined over the following synonyms:

• GL_DAILY_CONVERSION_TYPES (synonym) — supplies the currency conversion rate name and description.
• GL_SETS_OF_BOOKS_11I (synonym) — supplies the ledger name and short name.
• HR_ALL_ORGANIZATION_UNITS (synonym) — supplies the organization (operating unit) name.
• IGC_CC_HEADERS_ALL (synonym) — the contract commitment header, providing the commitment number and version number.
• IGC_CC_MC_HEADERS (synonym) — the multi-currency header that stores conversion type, conversion date, conversion rate, contract header ID, and set of books ID.

These five objects are joined on their respective key columns: CC_HEADER_ID between IGC_CC_MC_HEADERS and IGC_CC_HEADERS_ALL; SET_OF_BOOKS_ID between IGC_CC_MC_HEADERS and GL_SETS_OF_BOOKS_11I; ORG_ID between IGC_CC_HEADERS_ALL and HR_ALL_ORGANIZATION_UNITS; and CONVERSION_TYPE between IGC_CC_MC_HEADERS and GL_DAILY_CONVERSION_TYPES. The join to GL_DAILY_CONVERSION_TYPES is expressed with an outer-join symbol (+) on the conversion type column, since a commitment may exist without an assigned daily conversion type.

Key Columns

• CONTRACT_COMMITMENT_NUMBER — the commitment document number.
• CONTRACT_VERSION_NUMBER — the version of the commitment header.
• CURRENCY_CONVERSION_TYPE — the conversion method/type used for currency translation.
• CURRENCY_CONVERSION_DATE — the date on which the conversion rate applies.
• CURRENCY_CONVERSION_RATE — the numeric rate applied.
• RATE_NAME — the user-defined conversion type name from GL_DAILY_CONVERSION_TYPES.
• RATE_DESCRIPTION — the descriptive text for the conversion type.
• SETS_OF_BOOKS_NAME / SETS_OF_BOOKS_SHORT_NAME — ledger identification.
• ORGANIZATION_NAME / ORGANIZATION_ID — the operating unit name and its identifier.
• CONTRACT_COMMITMENT_ID / SET_OF_BOOKS_ID — surrogate keys for linking back to source records.

Common Use Cases and Queries

This view is typically used in reporting, reconciliation, and extract scripts where commitment data must be reported alongside its ledger, organization, and currency conversion context. A basic query is:

SELECT CONTRACT_COMMITMENT_NUMBER,
       CONTRACT_VERSION_NUMBER,
       RATE_NAME,
       CURRENCY_CONVERSION_RATE,
       SETS_OF_BOOKS_NAME,
       ORGANIZATION_NAME
FROM   APPS.IGCFV_MC_CONTRACT_COMMITMENTS;

Because the view already enforces organization security, there is no need to add an explicit ORG_ID filter when it is queried from an appropriately configured responsibility. Analysts frequently join the view to GL_DAILY_CONVERSION_TYPES for rate validation, to GL_SETS_OF_BOOKS for ledger attribute checks, or to commitment detail tables using CONTRACT_COMMITMENT_ID. It is also a convenient source for currency conversion extracts, since the conversion type, date, and rate are co-located with the commitment and ledger identifiers.