Results for “igi_com_gl_batches_copy_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IGI_COM_GL_BATCHES_COPY_V view is a public-sector financials international (IGI) construct owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a filtered set of journal entry batches sourced from the General Ledger, restricted to those eligible for copying or migration between sets of books. The view serves as the selection pool for the IGI commitment (encumbrance) copy process, which transfers encumbrance balances tied to a source set of books into a corresponding target set of books.

The object is a view rather than a stored table, so it always reflects the current state of GL_JE_BATCHES at query time. It is primarily consumed by concurrent programs, forms, and integration routines within IGI that must identify which journal batches remain candidates for duplication. Because it exposes je_batch_id explicitly, it is the natural entry point for queries that search for a specific batch by identifier.

Underlying Base Objects

Per the documented view text, the definition draws on two tables and their related constructs:

• GL_JE_BATCHES (alias GJB) — the primary source of batch attributes, including je_batch_id, name, status, actual_flag, set_of_books_id, control_total, and running totals.
• GL_LOOKUPS (alias L1) — joined on lookup_type = 'BATCH_TYPE' and lookup_code = actual_flag to derive the descriptive BALANCE_TYPE value.
• IGI_COM_SOB_LINK — a subquery source that governs whether the source set of books participates in the encumbrance copy, based on the ENCUMBRANCE_FLAG.
• IGI_COM_COPY_AUDIT — consulted twice to exclude batches already used as either a source or a target of a prior copy operation.
• GL_JE_HEADERS — an inner subquery that further restricts batches by journal source.

The ETRM metadata documents the runtime reference as DUAL, reflecting the resolved synonym layer rather than the full join graph. The view's actual dependency footprint is the set of IGI and GL objects listed above.

Key Columns

• JE_BATCH_ID — unique identifier of the journal batch; the primary search discriminator and the column most often referenced in troubleshooting and integration logic.
• ROW_ID — the GL_JE_BATCHES row identifier, included for record-level navigation.
• NAME — the batch name as defined in General Ledger.
• ACTUAL_FLAG — indicates the balance type of the batch (for example A for actuals, E for encumbrances).
• BALANCE_TYPE — the decoded description of ACTUAL_FLAG obtained from GL_LOOKUPS.
• SET_OF_BOOKS_ID — the source ledger for the batch, matched against SOURCE_SET_OF_BOOKS_ID in IGI_COM_SOB_LINK.
• STATUS — only batches with status 'P' (posted) qualify.
• CONTROL_TOTAL, RUNNING_TOTAL_DR, RUNNING_TOTAL_CR — monetary control figures useful for reconciliation.
• DEFAULT_PERIOD_NAME and the audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN complete the projection.

Common Use Cases and Queries

The view supports identifying batches eligible for the IGI encumbrance copy routine. Filtering logic already excludes batches that are unposted, that originate from PAYABLES, PURCHASING, or RECEIVABLES sources, and that have previously been copied. A direct lookup by batch identifier is the most frequent operation:

• SELECT je_batch_id, name, status, balance_type FROM igi_com_gl_batches_copy_v WHERE je_batch_id = :batch_id;
• SELECT je_batch_id, set_of_books_id, control_total FROM igi_com_gl_batches_copy_v WHERE actual_flag = 'E' AND default_period_name = :period;
• SELECT set_of_books_id, COUNT(*) FROM igi_com_gl_batches_copy_v GROUP BY set_of_books_id;

Analysts use these queries to reconcile candidate batches before executing the copy program and to confirm which batches have already flowed through the audit table.