Search Results igc_cc_mc_det_pf_pk

Overview

IGC_CC_MC_DET_PF is a table in the IGC (Contract Commitment) product of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. Its documented purpose is to store multiple reporting currency amounts for detail payment forecast lines. In the Oracle EBS architecture, IGC supports the Contract Commitment functionality, which records commitments, obligations, and payment forecasts against contracts. Because operational ledgers often require reporting in currencies other than the functional currency, the base detail payment forecast table is complemented by this companion table, which holds the converted reporting-currency amounts and the conversion attributes used to derive them.

The object resides in the IGC schema and is classified as VALID. The ETRM metadata records it with a heuristic Data Vault classification of "standalone," meaning the FK analysis did not identify dependent relationships that would place it in a hub, link, or satellite pattern. From a modeling perspective, the table functions as a satellite-style extension keyed by the natural business key of the payment forecast line plus the ledger context, rather than as an independent hub.

Key Information Stored

The table contains seven documented columns, organized around a composite key and the monetary and conversion values for each reporting ledger.

• CC_DET_PF_LINE_ID — The identifier of the detail payment forecast line. Together with SET_OF_BOOKS_ID it forms the primary key IGC_CC_MC_DET_PF_PK and the unique business-key index IGC_CC_MC_DET_PF_U1.
• SET_OF_BOOKS_ID — Identifies the reporting set of books (ledger) for which the converted amounts are held. Because a single forecast line can be reported in multiple ledgers, this column differentiates rows sharing the same line identifier.
• CC_DET_PF_FUNC_AMT — The payment forecast amount expressed in the functional currency of the associated ledger.
• CC_DET_PF_ENCMBRNC_AMT — The encumbrance amount associated with the detail payment forecast line, carried in the same reporting context.
• CONVERSION_TYPE — The Oracle currency conversion type (for example, a corporate or spot rate) used to translate the functional amount into the reporting currency.
• CONVERSION_DATE — The effective date on which the conversion rate was applied, which determines the rate selected from the rate table.
• CONVERSION_RATE — The actual exchange rate factor applied to produce the reporting-currency values.

The surrogate primary key is the composite of CC_DET_PF_LINE_ID and SET_OF_BOOKS_ID; the unique index IGC_CC_MC_DET_PF_U1 mirrors this pair and serves as the business-key candidate.

Common Use Cases and Queries

Typical uses include multi-ledger payment forecasting reports, commitment reporting across sets of books, and reconciliation of functional versus reporting-currency balances. A common query pattern joins the base forecast lines to this table by line identifier and set of books:

• Reporting: SELECT m.CC_DET_PF_LINE_ID, m.SET_OF_BOOKS_ID, m.CC_DET_PF_FUNC_AMT, m.CONVERSION_RATE FROM IGC.IGC_CC_MC_DET_PF m WHERE m.SET_OF_BOOKS_ID = :ledger_id;
• Rate validation: filter on CONVERSION_TYPE and CONVERSION_DATE to confirm which rate was applied to a given forecast.
• Audit: compare CC_DET_PF_FUNC_AMT to CC_DET_PF_ENCMBRNC_AMT to identify encumbered versus forecast amounts per ledger.

Related Objects

The metadata classifies this table as standalone, so FK relationships are not documented. The most significant related objects are those that share the CC_DET_PF_LINE_ID key, principally the base detail payment forecast table from which the line identifier originates, plus the sets of books and currency conversion infrastructure referenced by SET_OF_BOOKS_ID, CONVERSION_TYPE, and CONVERSION_DATE. Reports and concurrent programs in the IGC Contract Commitment module that produce multi-currency payment forecast output depend on this table as their source of converted amounts.