Results for “release_detail_pf_line_id”

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

Overview

The IGCFV_MC_REL_DET_PF_FORECASTS view is a reporting object owned by the APPS schema within the IGC – Contract Commitment product family of Oracle E-Business Suite. In 12.1.1 and 12.2.2 it is registered as a VALID database view that consolidates release-level detail payment forecast records with their corresponding parent detail payment forecast and parent account line information. The prefix "MC" denotes the multi-currency variant of the underlying detail payment forecast data, and the view is designed to surface both the functional and encumbrance amounts associated with each release line of a payment forecast.

The view plays a supporting role in reporting and integration scenarios where users need to reconcile a child (release) payment forecast line against its parent line, or to extract the currency conversion context (conversion type, date and rate) applied to a particular forecast. Because it is defined WITH READ ONLY, it is intended exclusively for query and extraction, not for transactional DML. It does not hold data itself; it is a projection over the base commitment control tables.

The search term rel_det_pf_functional_amount corresponds directly to the exposed column REL_DET_PF_FUNCTIONAL_AMOUNT, which is the functional-currency amount of a release-level detail payment forecast line. This is the primary figure consumers of the view are typically seeking.

Underlying Base Objects

The documented metadata for 12.2.2 lists four referenced base objects, all exposed through synonyms in the APPS schema:

• GL_SETS_OF_BOOKS_11I (synonym of GL_SETS_OF_BOOKS) — supplies the set of books name and short name, and is joined on SET_OF_BOOKS_ID.
• IGC_CC_MC_DET_PF — the multi-currency detail payment forecast table providing functional amount, encumbrance amount, conversion attributes and the detail PF line ID.
• IGC_CC_DET_PF — the base detail payment forecast table, joined to link each release line to its parent detail PF line via PARENT_DET_PF_LINE_ID.
• IGC_CC_ACCT_LINES — the commitment account lines table, used twice (aliased IGCCAL and IGCCALP) to resolve the release account line and its parent account line.

The join path is a chain: the multi-currency detail PF record links to the base detail PF record, which links to an account line, which links to a parent account line, and in turn to a parent detail PF line. The view further restricts results with PARENT_ACCT_LINE_ID IS NOT NULL and PARENT_DET_PF_LINE_ID IS NOT NULL, ensuring only genuinely hierarchical release records are returned.

Key Columns

• RELEASE_DETAIL_PF_LINE_NUMBER — the line number of the release detail payment forecast line.
• REL_DET_PF_FUNCTIONAL_AMOUNT — the functional-currency amount of the release detail PF line (from CC_DET_PF_FUNC_AMT); the figure most commonly queried.
• REL_DET_PF_ENCUMBRANCE_AMOUNT — the encumbrance amount carried on the same line.
• CURRENCY_CONVERSION_TYPE / CURRENCY_CONVERSION_DATE / CURRENCY_CONVERSION_RATE — the currency conversion context applied to the multi-currency forecast amount.
• RELEASE_ACCOUNT_LINE_NUMBER / PARENT_ACCOUNT_LINE_NUMBER — account line identifiers for the release and its parent.
• PARENT_DETAIL_PF_LINE_NUMBER — the parent detail payment forecast line number.
• SETS_OF_BOOKS_NAME / SETS_OF_BOOKS_SHORT_NAME — human-readable identification of the ledger.
• Identifier columns — PARENT_ACCOUNT_LINE_ID, PARENT_DET_PF_LINE_ID, RELEASE_ACCOUNT_LINE_ID, RELEASE_DETAIL_PF_LINE_ID, SET_OF_BOOKS_ID — used for joins and drill-down.

Common Use Cases and Queries

Typical scenarios include reconciliation of release-level forecasts to parent lines, multi-currency reporting of functional versus encumbrance amounts, and drill-down from a parent account line to its releases. A basic extraction of functional amounts by ledger follows:

• SELECT release_detail_pf_line_number, rel_det_pf_functional_amount, rel_det_pf_encumbrance_amount, sets_of_books_short_name FROM apps.igcfv_mc_rel_det_pf_forecasts WHERE set_of_books_id = :p_sob_id ORDER BY release_detail_pf_line_number;
• Filtering by parent lineage: ... WHERE parent_det_pf_line_id = :p_parent_id;
• Currency conversion audit: select the conversion type, date and rate alongside rel_det_pf_functional_amount to verify translated amounts.

Because the view is read-only and restricted to records having both parent account line and parent detail PF line, queries against it will not return orphaned or top-level forecast lines; callers requiring those must query the base IGC_CC_DET_PF and IGC_CC_MC_DET_PF tables directly.