Search Results igcbv_mc_detail_pay_forecasts




Overview
Explore in AI Chat

Overview

The IGCBV_MC_DETAIL_PAY_FORECASTS view is a read-only database object owned by the APPS schema within the Oracle E-Business Suite environment. It belongs to the IGC - Contract Commitment product family, which supports commitment control and budgetary accounting for contracts and payables. The view presents detailed payment forecast information at the account-line level, combining commitment detail pay forecast records with their associated set of books (ledger) context. In Oracle EBS 12.1.1 and 12.2.2, this view serves as a reporting and integration surface that exposes multi-currency and multi-ledger payment forecast data in a denormalized form suitable for SQL-based reporting, Oracle Reports, BI Publisher, and custom concurrent programs.

The view is defined with a WITH READ ONLY clause, meaning it cannot be used for DML operations and is intended strictly as a query interface. Its inclusion of ACCOUNT_LINE_ID makes it a key linkage point for users tracing forecast amounts back to the underlying commitment accounting line — the exact term the user searched for.

Underlying Base Objects

The view is defined over three documented base objects, which are exposed in the APPS schema as synonyms:

  • IGC_CC_MC_DET_PF — the multi-currency detail payment forecast table, supplying functional amount, encumbrance amount, and currency conversion attributes.
  • IGC_CC_DET_PF — the detail payment forecast table, supplying the line number and the account-line linkage (CC_ACCT_LINE_ID).
  • GL_SETS_OF_BOOKS (documented as the GL_SETS_OF_BOOKS_11I synonym) — the General Ledger set of books / ledger definition, supplying the ledger name and short name.

The joins are driven by SET_OF_BOOKS_ID between IGC_CC_MC_DET_PF and GL_SETS_OF_BOOKS, and by CC_DET_PF_LINE_ID between IGC_CC_MC_DET_PF and IGC_CC_DET_PF. This structure allows each forecast line to be reported once per applicable ledger with its conversion data intact.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling payment forecasts to commitment account lines, reporting encumbrance versus functional forecast amounts, and auditing currency conversion application. A common query filters directly on the searched column:

SELECT account_line_id,
       detail_pf_line_number,
       detail_pf_functional_amount,
       detail_pf_encumbrance_amount,
       sets_of_books_name
  FROM apps.igcbv_mc_detail_pay_forecasts
 WHERE account_line_id = :p_account_line_id;

Another common report aggregates forecast totals per ledger using SETS_OF_BOOKS_ID and the functional amount columns. Because the view is read-only, all access should be limited to SELECT statements.