Search Results fun_trx_batches




Overview
Explore in AI Chat

Overview

FUN_TRX_BATCHES is a Financials Common Modules (FUN) table that stores information about Intercompany transaction batches in Oracle E-Business Suite 12.1.1 and 12.2.2. Each row represents a batch header that groups one or more intercompany transactions destined for one or more recipients. The table acts as the central control record for a batch, capturing its identifier, initiator, source ledger, transaction type, control totals, and lifecycle status.

The ETRM metadata describes FUN_TRX_BATCHES as having a standalone Data Vault classification, mined heuristically from its foreign key structure. In Data Vault modeling terms, the table can therefore be treated as a hub-like or self-contained entity rather than a link that resolves two or more business hubs. Its unique business key, formed by BATCH_NUMBER and INITIATOR_ID, supports that interpretation.

Key Information Stored

The table contains 44 documented columns. The most operationally significant are:

Common Use Cases and Queries

Typical reporting scenarios include batch status monitoring, control-total reconciliation, and audit of intercompany activity by initiator or ledger. A common query joins the batch header to its transaction lines and filters by status:

SELECT b.batch_number, b.initiator_id, b.status, b.control_total, b.running_total_dr, b.running_total_cr FROM fun_trx_batches b WHERE b.from_ledger_id = :ledger_id AND b.status = 'UNPOSTED';

Control-check queries compare CONTROL_TOTAL against the sum of the running totals to detect batches that failed to balance. Reversal analysis uses the ORIGINAL_BATCH_ID and REVERSED_BATCH_ID columns to trace a batch to its counterpart. Aging and period-close reports filter on GL_DATE and BATCH_DATE, while initiator-based reporting groups by INITIATOR_ID to measure batch volumes per user or process.

Related Objects

  • IGI_EXP_TRX_TYPE — referenced by FUN_TRX_BATCHES.TRX_TYPE_ID; provides the transaction type definition for each batch.
  • FUN_TRX_HEADERS — the transaction header table whose rows belong to a batch through BATCH_ID, forming the batch-to-transaction relationship.
  • FUN_TRX_LINES — transaction line detail associated with the headers and ultimately with the batch.
  • IGI_EXP_TRX_TYPES_B / IGI_EXP_TRX_TYPES_TL — the base and translated tables that back the transaction type reference.
  • GL_LEDGERS / GL_LEDGER_LE_BSV — source of FROM_LEDGER_ID and FROM_LE_ID values.
  • FND_USER — resolves INITIATOR_ID and the audit user columns to application users.
  • XLA_EVENTS / GL_JE_HEADERS — downstream accounting objects populated when an intercompany batch is accounted and posted.

These relationships make FUN_TRX_BATCHES the entry point for intercompany batch inquiry, reconciliation, and audit reporting in Oracle EBS Financials Common Modules.