Search Results rel_acct_encumbrance_amount




Overview
Explore in AI Chat

Overview

IGCBV_MC_RELEASE_ACCOUNT_LINES is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the IGC (Contract Commitment) product family. It presents the accounting-line detail associated with contract commitment releases processed through Multi-Currency (MC) accounting. The view consolidates the link between original contract commitment accounting lines and their released counterparts, exposing functional amounts, encumbrance amounts, currency conversion attributes, and sets-of-books descriptors in a single reporting surface.

The view is defined with the WITH READ ONLY clause, so it supports query access only and cannot be used as a DML target. It exists primarily to satisfy inquiry, reconciliation, and integration reporting requirements for release accounting activity in Contract Commitment.

Underlying Base Objects

The view is defined over three documented base objects, all referenced via synonyms:

The view joins IGC_CC_MC_ACCT_LINES to IGC_CC_ACCT_LINES on CC_ACCT_LINE_ID, and joins IGC_CC_MC_ACCT_LINES to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID. This structure means each row represents a release accounting line paired with its originating parent accounting line and its associated ledger.

Key Columns

Common Use Cases and Queries

Typical usage includes reconciling releases against their parent commitments, reviewing encumbrance and functional balances by ledger, and driving downstream integration extracts. A common query filters on the parent commitment identifier:

  • Retrieve all release accounting lines for a specific parent commitment:

SELECT release_account_line_number,
       release_contract_commitment_id,
       parent_contract_commitment_id,
       parent_account_line_id,
       release_acct_functional_amount,
       rel_acct_encumbrance_amount,
       sets_of_books_name,
       currency_conversion_rate
FROM   apps.igcbv_mc_release_account_lines
WHERE  parent_contract_commitment_id = :p_commitment_id;

  • Aggregate release encumbrance by ledger to support period-end analysis:

SELECT sets_of_books_name,
       SUM(rel_acct_encumbrance_amount) total_encumbrance,
       SUM(release_acct_functional_amount) total_functional
FROM   apps.igcbv_mc_release_account_lines
GROUP  BY sets_of_books_name;

Because the view is read-only and joins the parent and release accounting lines directly, it is well suited to enquiry screens, concurrent-program extracts, and reconciliation reports without requiring custom join logic.