Results for “gl_batch_id”

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

Overview

ORG_GL_BATCHES is an Inventory (INV) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores General Ledger transfer information for each accounting batch. Every transaction processed in Oracle Inventory, Work in Process, and related costing activities must eventually be transferred to the General Ledger as journal entries. The GL batch is the unit of that transfer, and ORG_GL_BATCHES records the metadata that identifies each batch, links it to an inventory organization, and associates it with the open accounting period during which the transfer occurred. The table therefore acts as a control point between the subledger accounting activities in Inventory and the General Ledger interface.

The table resides in the INV schema and is defined with a composite primary key, ORG_GL_BATCHES_PK, on the columns ORGANIZATION_ID and GL_BATCH_ID. A corresponding unique index, ORG_GL_BATCHES_U1, covers the same two columns, confirming that the organization plus batch combination is the business key. Based on the foreign key topology — where this table is referenced by the high-volume transaction accounting tables rather than acting as a pure transactional fact itself — the metadata’s heuristic Data Vault classification is satellite-leaning. In a Data Vault model this suggests ORG_GL_BATCHES is best treated as a satellite or a lightweight hub that groups transaction accounting records for a period, rather than as a standalone transactional hub.

Key Information Stored

The table contains ten documented columns. The most significant include:

• ORGANIZATION_ID — Identifies the inventory organization that owns the batch. Together with GL_BATCH_ID it forms the primary key and the unique business key, and it is a foreign key to MTL_PARAMETERS.
• GL_BATCH_ID — The unique identifier for the General Ledger transfer batch within the organization. This value is propagated to transaction accounting rows to group them for transfer.
• ACCT_PERIOD_ID — References ORG_ACCT_PERIODS and identifies the accounting period in which the batch was created and transferred.
• GL_BATCH_DATE — The date associated with the GL batch, typically used to determine the GL accounting date and to sequence batches within a period.
• DESCRIPTION — A free-text description of the batch, often populated by the transfer process to aid reconciliation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns recording who created and last modified the batch record, when, and from which login session.

The surrogate primary key is the composite (ORGANIZATION_ID, GL_BATCH_ID); there is no single-column surrogate, so both attributes must be supplied in any direct lookup or join.

Common Use Cases and Queries

Typical use cases include reconciliation of subledger activity to GL, reporting on batches not yet transferred, and auditing batch creation by period or user. A representative query lists batches with their organization and period:

• SELECT b.organization_id, b.gl_batch_id, b.gl_batch_date, b.acct_period_id, b.description FROM inv.org_gl_batches b WHERE b.organization_id = :org_id AND b.gl_batch_date BETWEEN :start_date AND :end_date;
• Join to ORG_ACCT_PERIODS to resolve the period name and status for each batch.
• Aggregate transaction accounts by GL_BATCH_ID to verify debits and credits balance before transfer.
• Identify batches created by a specific user for audit purposes using CREATED_BY and CREATION_DATE.

Because GL_BATCH_ID is carried onto MTL_TRANSACTION_ACCOUNTS and WIP_TRANSACTION_ACCOUNTS, the table is frequently used as the driving table in joins that reconstruct the full set of accounting lines belonging to a batch.

Related Objects

The most significant related objects, based on documented foreign key relationships, include:

• MTL_PARAMETERS — joined on ORG_GL_BATCHES.ORGANIZATION_ID to resolve organization context.
• ORG_ACCT_PERIODS — joined on ORG_GL_BATCHES.ACCT_PERIOD_ID to obtain period details.
• MTL_TRANSACTION_ACCOUNTS — references this table via ORGANIZATION_ID and GL_BATCH_ID; holds inventory accounting lines per batch.
• WIP_TRANSACTION_ACCOUNTS — references this table via ORGANIZATION_ID and GL_BATCH_ID; holds work in process accounting lines per batch.

These relationships make ORG_GL_BATCHES the central grouping object for the Inventory-to-GL transfer process in Oracle EBS.