Results for “igcfv_mc_detail_pay_forecasts”

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

Overview

The IGCFV_MC_DETAIL_PAY_FORECASTS view is a read-only reporting object owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGC – Contract Commitment product family. The "MC" prefix denotes the multi-currency variant of the commitment pay forecast data, distinguishing it from the single-currency detail pay forecast structures. The view assembles detail-level pay forecast lines and joins them to the accounting line and ledger context required to report commitment amounts in a functional or reporting currency.

Its principal role is to expose commitment encumbrance balances at the detail pay forecast line level, alongside the currency conversion attributes that were applied when the multi-currency amounts were derived. The view is defined with the WITH READ ONLY clause, confirming that it is intended strictly for query and reporting purposes and cannot be used as a DML target. This makes it suitable for concurrent programs, BI Publisher reports, and custom inquiry screens that need to reconcile pay forecast encumbrance to the general ledger.

Underlying Base Objects

The view is defined over four base objects, resolved in the APPS schema through synonyms:

• IGC_CC_MC_DET_PF – the multi-currency detail pay forecast table, which supplies the functional amount, encumbrance amount, conversion type, conversion date, conversion rate, detail pay forecast line ID, and set of books ID.
• IGC_CC_DET_PF – the detail pay forecast table, supplying the detail pay forecast line number and the accounting line ID used to link to the accounting line.
• IGC_CC_ACCT_LINES – the contract commitment accounting lines table, providing the account line number that ties the pay forecast to a specific distribution.
• GL_SETS_OF_BOOKS (GL_SETS_OF_BOOKS_11I) – the General Ledger sets of books definition, providing the ledger name and short name associated with the set of books ID.

Joins are established on SET_OF_BOOKS_ID between IGC_CC_MC_DET_PF and GL_SETS_OF_BOOKS, on CC_DET_PF_LINE_ID between IGC_CC_MC_DET_PF and IGC_CC_DET_PF, and on CC_ACCT_LINE_ID between IGC_CC_DET_PF and IGC_CC_ACCT_LINES.

Key Columns

• DETAIL_PF_LINE_NUMBER – the user-visible line number of the detail pay forecast line.
• DETAIL_PF_FUNCTIONAL_AMOUNT – the detail pay forecast amount expressed in the functional currency of the ledger.
• DETAIL_PF_ENCUMBRANCE_AMOUNT – the encumbrance amount recorded against the detail pay forecast line; this is the column most directly associated with the search term "detail_pf_encumbrance_amount" and is the primary measure for commitment reporting.
• CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE – the conversion attributes captured when the multi-currency amount was calculated, allowing the original transaction currency amount to be re-derived or audited.
• SETS_OF_BOOKS_NAME / SETS_OF_BOOKS_SHORT_NAME – the ledger name and short name from GL_SETS_OF_BOOKS.
• ACCOUNT_LINE_NUMBER, ACCOUNT_LINE_ID – the accounting line identifier and its display number, used to link the encumbrance to a distribution.
• DETAIL_PF_LINE_ID, SET_OF_BOOKS_ID – surrogate keys supporting joins back to the base commitment tables.

Common Use Cases and Queries

Typical use cases include reconciling commitment encumbrance balances by ledger and account line, extracting multi-currency pay forecast detail for audit, and feeding downstream reporting that requires the applied conversion rate and date. A representative query follows:

SELECT detail_pf_line_number,
       detail_pf_encumbrance_amount,
       detail_pf_functional_amount,
       currency_conversion_rate,
       sets_of_books_short_name,
       account_line_number
FROM   apps.igcfv_mc_detail_pay_forecasts
WHERE  set_of_books_id = :p_set_of_books_id
AND    detail_pf_encumbrance_amount <> 0
ORDER BY account_line_number, detail_pf_line_number;

Because the view is read-only, it can be safely exposed to inquiry responsibilities and used in concurrent extracts without risk of altering commitment data.