Search Results account_line_number




Overview
Explore in AI Chat

Overview

IGCBV_MC_ACCT_LINES is a read-only Oracle EBS view owned by the APPS schema. It exposes multi-currency accounting line information associated with contract commitment (CC) transactions, joining the base accounting lines to their multi-currency counterparts and to the defining set of books. The view is part of the IGC (Oracle Contracts / Commitment Control) module family, which supports encumbrance and budgetary accounting for contract commitments. Because it presents account line numbers, functional and encumbrance amounts, currency conversion attributes, and set-of-books identifiers in a single denormalized structure, it is typically consumed by reporting, reconciliation, and integration routines that need account-line-level detail rather than raw base tables. The view is defined WITH READ ONLY, meaning it cannot be used as a DML target.

Underlying Base Objects

The view is defined over three documented base objects, all exposed through the APPS schema:

  • IGC_CC_ACCT_LINES — aliased as IGCCAL; the source of the account line number and header reference.
  • IGC_CC_MC_ACCT_LINES — the multi-currency accounting lines table, providing functional amounts, encumbrance amounts, and currency conversion attributes.
  • GL_SETS_OF_BOOKS_11I — a synonym over the set-of-books definition, supplying the set-of-books name and short name.

The join is established on CC_ACCT_LINE_ID between IGC_CC_MC_ACCT_LINES and IGC_CC_ACCT_LINES, and on SET_OF_BOOKS_ID between IGC_CC_MC_ACCT_LINES and GL_SETS_OF_BOOKS_11I. This structure corresponds to the documented view text, which performs an inner join across all three objects.

Key Columns

Common Use Cases and Queries

Typical scenarios include generating contract commitment account line reports, reconciling functional and encumbrance amounts, and extracting multi-currency detail for downstream integrations. Reports commonly join the view to commitment header tables using CONTRACT_COMMITMENT_ID and filter by SET_OF_BOOKS_ID to scope results to a ledger context.

  • Account line lookup by number: SELECT ACCOUNT_LINE_ID, ACCOUNT_LINE_NUMBER, ACCT_LINE_FUNCTIONAL_AMOUNT, ACCT_LINE_ENCUMBRANCE_AMOUNT FROM APPS.IGCBV_MC_ACCT_LINES WHERE ACCOUNT_LINE_NUMBER = :p_line_number;
  • Lines for a set of books: SELECT CONTRACT_COMMITMENT_ID, ACCOUNT_LINE_NUMBER, SETS_OF_BOOKS_SHORT_NAME, CURRENCY_CONVERSION_RATE FROM APPS.IGCBV_MC_ACCT_LINES WHERE SET_OF_BOOKS_ID = :p_sob_id;
  • Lines for a commitment header: SELECT ACCOUNT_LINE_NUMBER, ACCT_LINE_FUNCTIONAL_AMOUNT, CURRENCY_CONVERSION_TYPE FROM APPS.IGCBV_MC_ACCT_LINES WHERE CONTRACT_COMMITMENT_ID = :p_header_id ORDER BY ACCOUNT_LINE_NUMBER;

Because the view is read-only and performs inner joins across the three base objects, only accounting lines that have corresponding multi-currency records and valid set-of-books definitions are returned. The behavior is consistent between Oracle EBS 12.1.1 and 12.2.2, and the view remains a stable interface for account-line-level contract commitment reporting.