Search Results acct_line_encumbrance_amount




Overview
Explore in AI Chat

Overview

The IGCBV_MC_ACCOUNT_LINES view is a read-only reporting object owned by the APPS schema within the IGC – Contract Commitment product family. It presents multi-currency account line detail for contract commitments, joining accounting line information to the applicable set of books and exposing both functional and encumbrance amounts. The view is well suited to reporting and integration scenarios in Oracle EBS 12.1.1 and 12.2.2, where downstream processes or custom reports require contract commitment accounting data enriched with set of books context. Because the view is defined with the READ ONLY qualifier, it cannot be used as a DML target; its purpose is strictly query and extraction. The user search term "acct_line_encumbrance_amount" maps directly to the exposed column ACCT_LINE_ENCUMBRANCE_AMOUNT, confirming that encumbrance reporting is a primary reason analysts consult this object.

Underlying Base Objects

The view is defined over three referenced objects: IGC_CC_ACCT_LINES, IGC_CC_MC_ACCT_LINES, and GL_SETS_OF_BOOKS (documented as the GL_SETS_OF_BOOKS_11I synonym in the ETRM 12.2.2 metadata). The principal join links IGC_CC_MC_ACCT_LINES to IGC_CC_ACCT_LINES on CC_ACCT_LINE_ID, and a second join links IGC_CC_MC_ACCT_LINES to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID. The MC (multi-currency) table carries the monetary and currency conversion attributes, while IGC_CC_ACCT_LINES supplies the account line number and the parent contract commitment identifier. GL_SETS_OF_BOOKS contributes the descriptive set of books name and short name. This three-way structure allows a single query to return accounting amounts alongside the ledger identity under which they were recorded.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling encumbrance balances by ledger, extracting functional versus encumbrance amounts for a given commitment, and feeding downstream reporting or interface programs where multi-currency detail is required. A representative query follows.

  • Encumbrance by commitment: 
    SELECT contract_commitment_id,
       account_line_number,
       acct_line_encumbrance_amount,
       sets_of_books_name
FROM   apps.igcbv_mc_account_lines
WHERE  contract_commitment_id = :p_commitment_id;
  • Ledger-level aggregation: 
    SELECT sets_of_books_short_name,
       SUM(acct_line_encumbrance_amount) encumbrance_total,
       SUM(acct_line_functional_amount)  functional_total
FROM   apps.igcbv_mc_account_lines
GROUP  BY sets_of_books_short_name;
  • Currency conversion audit: 
    SELECT account_line_id,
       currency_conversion_type,
       currency_conversion_date,
       currency_conversion_rate
FROM   apps.igcbv_mc_account_lines
WHERE  set_of_books_id = :p_sob_id;