Search Results fun_intercompany_batch




Overview
Explore in AI Chat

Overview

FUN.FUN_INTERFACE_DIST_LINES is the open interface (staging) table for Intercompany Distribution Lines within the Oracle E-Business Suite Financials (FUN) product. It is part of the Intercompany Batches Distributions Interface, referenced by the business entity FUN_INTERCOMPANY_BATCH, and it stores distribution-level records prior to validation and transfer into the permanent intercompany distribution tables. In Oracle EBS 12.1.1 and 12.2.2, this table resides in the APPS_TS_INTERFACE tablespace with a PCT Free of 10, confirming its role as a transient interface object rather than a transactional ledger table.

The documented metadata classifies this object heuristically as standalone within a Data Vault modeling context — that is, it functions as neither a pure hub, link, nor satellite in the mined FK structure. This classification is a modeling suggestion: the table behaves as an interface/staging construct that aggregates distribution attributes before they are pushed to production entities, so a Data Vault treatment would likely split its business keys (e.g., DIST_ID, BATCH_DIST_ID) into hubs and its descriptive fields into satellites during any downstream integration modeling.

One documented foreign key is captured: DIST_ID references OKL_UPG_TRNS_ACC_DSTRS_T. The schema exposes a single nonunique index, FUN_INTERFACE_DIST_LINES_N1, on DIST_ID.

Key Information Stored

The table carries 33 documented columns. The most significant of these are:

  • TRX_ID (NUMBER(15)) — Transaction Id linking back to fun_interface_headers; the primary linkage to the batch header.
  • DIST_ID (NUMBER(15)) — Distribution Id, system-generated through a sequence; indexed via FUN_INTERFACE_DIST_LINES_N1.
  • BATCH_DIST_ID (NUMBER(15)) — Batch Distribution Id, associating the line with its batch.
  • DIST_NUMBER (NUMBER(15)) — The human-readable distribution number.
  • PARTY_ID and PARTY_TYPE_FLAG — Identifies the initiator or recipient and its type.
  • DIST_TYPE_FLAG — Classifies the distribution type.
  • AMOUNT_CR and AMOUNT_DR — Credit and debit distribution amounts.
  • CCID — The accounting flexfield code combination.
  • IMPORT_STATUS_CODE — Tracks interface processing state.
  • DESCRIPTION — Free-text description of the distribution.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield segments.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

The surrogate primary key candidate is DIST_ID (sequence-generated). Business-key candidates include TRX_ID combined with DIST_NUMBER or BATCH_DIST_ID, which uniquely identify a line within its batch context. Because the only documented index is nonunique, exact uniqueness enforcement is not captured in the metadata.

Common Use Cases and Queries

Typical scenarios involve monitoring inbound intercompany distributions, diagnosing rejected interface rows, and reconciling staged amounts before transfer. A representative query joining the interface header and line follows:

  • Tracking import status: SELECT TRX_ID, DIST_ID, IMPORT_STATUS_CODE, AMOUNT_DR, AMOUNT_CR FROM FUN.FUN_INTERFACE_DIST_LINES WHERE IMPORT_STATUS_CODE = 'ERROR';
  • Batch-level rollup: aggregate DIST lines by TRX_ID to validate that total debits equal total credits before transfer.
  • Party reporting: group by PARTY_ID and PARTY_TYPE_FLAG to summarize distributions per initiator/recipient.
  • Audit and aging: use CREATION_DATE and LAST_UPDATE_DATE to identify stale interface rows awaiting processing.
  • Flexfield analysis: query ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for custom reporting dimensions.

Related Objects

  • FUN.FUN_INTERFACE_HEADERS — the header-level interface table; join on TRX_ID.
  • OKL_UPG_TRNS_ACC_DSTRS_T — referenced by the documented DIST_ID foreign key.
  • FUN_INTERFACE_DIST_LINES_N1 — the nonunique index on DIST_ID supporting lookups.
  • Downstream intercompany distribution tables (production targets of the interface load).
  • Intercompany batch APIs and concurrent programs that consume FUN_INTERFACE_HEADERS and FUN_INTERFACE_DIST_LINES.

Together, these objects form the intake-to-transfer path for intercompany batch distributions in Oracle EBS 12.1.1 and 12.2.2.