Search Results balancing_segment_value

Overview

The APPS.IGCFV_CBC_JOURNAL_LINES view is a reporting and integration object within the Oracle E-Business Suite IGC – Contract Commitment product family. It exposes the journal line records entered against contract commitment batches, presenting them in a denormalized, business-friendly form suitable for reporting, extract, and downstream integration. The view carries a VALID status in the APPS schema and is defined over the IGC Contract Commitment journal entry line table (IGC_CBC_JE_LINES) joined to its batch header (IGC_CBC_JE_BATCHES) and a set of General Ledger reference tables.

Because the view flattens accounting flexfield, currency, period, and encumbrance context alongside the raw journal amounts, it is commonly consumed by custom reports, Oracle Discoverer worksheets, and interfaces that must reconcile commitment journal activity back to the General Ledger. The inclusion of the BALANCING_SEGMENT_VALUE column makes the view particularly relevant to users searching on that term, since balancing segment analysis is a frequent requirement in commitment accounting and budgetary control reporting.

Underlying Base Objects

The view is documented as being defined over the following base objects:

• IGC_CBC_JE_LINES (SYNONYM) – the primary journal line table, aliased IGC_CBCJEL.
• IGC_CBC_JE_BATCHES (SYNONYM) – the journal batch header, aliased IGC_CBCJEB, supplying the batch name.
• GL_CODE_COMBINATIONS (SYNONYM) – the accounting flexfield combination, referenced through the _KF:GL_ACCOUNT key flexfield descriptor.
• GL_SETS_OF_BOOKS (VIEW) – set of books name and short name.
• GL_PERIODS (SYNONYM) and GL_PERIOD_SETS (SYNONYM) – accounting period and period set context.
• GL_BUDGET_VERSIONS (SYNONYM) – budget version name.
• GL_ENCUMBRANCE_TYPES (SYNONYM) – encumbrance type name.
• FND_CURRENCIES (SYNONYM) – currency reference data.

The join pattern links each journal line to its batch, its code combination, and the relevant GL reference rows, producing a single denormalized row per commitment journal line.

Key Columns

• JOURNAL_LINE_NUMBER, JOURNAL_SOURCE, JOURNAL_CATEGORY – identify and classify the line.
• _LA:BALANCE_TYPE – a lookup-translated descriptor derived from ACTUAL_FLAG against GL_LOOKUPS:BATCH_TYPE.
• EFFECTIVE_DATE, POSTED_DATE, PERIOD_NAME, PERIOD_SET_NAME – accounting and posting timing.
• ENTERED_DR, ENTERED_CR – entered debit and credit amounts.
• BALANCING_SEGMENT_VALUE – the balancing segment value carried on the journal line, central to balancing segment reporting.
• _KF:GL_ACCOUNT – the concatenated accounting flexfield from GL_CODE_COMBINATIONS.
• BATCH_NAME, SETS_OF_BOOKS_NAME, SETS_OF_BOOKS_SHORT_NAME, CURRENCY_CODE – descriptive context.
• BUDGET_VERSION_NAME, BUDGET_TYPE, ENCUMBRANCE_TYPE_NAME – budgetary control attributes.
• REFERENCE_1 through REFERENCE_10 – free-form reference attributes.
• Audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY.

Common Use Cases and Queries

Typical scenarios include reconciliation of commitment journal lines to GL, balancing segment analysis, and encumbrance reporting by set of books and period.

SELECT balancing_segment_value,
       period_name,
       SUM(entered_dr) dr,
       SUM(entered_credit) cr
FROM   apps.igcfv_cbc_journal_lines
WHERE  set_of_books_id = :p_sob
AND    period_name = :p_period
GROUP BY balancing_segment_value, period_name;

SELECT batch_name, journal_line_number, gl_account,
       entered_dr, entered_cr, encumbrance_type_name
FROM   apps.igcfv_cbc_journal_lines
WHERE  journal_source = :p_source
ORDER BY batch_name, journal_line_number;

The view should be queried with the APPS schema or a synonym, and filtered on SET_OF_BOOKS_ID and PERIOD_NAME to bound result sets.