Search Results fun_interface_dist_lines

Overview

FUN_INTERFACE_DIST_LINES is a public interface table in the FUN (Financials Common Modules) product of Oracle E-Business Suite, documented as the Intercompany Distributions Open Interface. It is registered under the BUSINESS_ENTITY category FUN_INTERCOMPANY_BATCH. The table serves as a staging area into which external sources or upstream EBS processes load intercompany distribution lines before they are validated, processed, and ultimately transferred into the functional intercompany distributions structure. It is therefore a transient landing object rather than a transactional ledger: rows typically exist between the import write and the subsequent interface processing run.

From a modeling standpoint, the mined FK structure classifies this table as standalone in a Data Vault heuristic sense, meaning the metadata does not evidence it as a hub, link, or satellite in its own right. In practice, the table behaves more like a staging satellite keyed by a batch distribution reference; downstream consumers should treat it as a feed, not as a system of record.

Key Information Stored

The table carries 33 documented columns. The most consequential for integration and reconciliation work are:

• TRX_ID — transaction identifier linking the distribution line to its source intercompany transaction.
• DIST_ID — the distribution identifier for the line; the documented foreign key maps DIST_ID to OKL_UPG_TRNS_ACC_DSTRS_T, indicating the lineage of the distribution record.
• BATCH_DIST_ID — the batch-level distribution reference, the primary grouping key for the interface batch.
• DIST_NUMBER — the user-visible distribution line number within the batch.
• PARTY_ID and PARTY_TYPE_FLAG — the intercompany trading partner and its classification.
• DIST_TYPE_FLAG — the type of distribution, governing subsequent accounting treatment.
• AMOUNT_DR and AMOUNT_CR — the debit and credit amounts for the line in the entered currency.
• CCID — the code combination identifier resolving to the Accounting Flexfield for the distribution account.
• IMPORT_STATUS_CODE — the processing state of the row; this governs which records are picked up by the interface program and which are rejected.
• DESCRIPTION — free-text line description.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield and DFF context columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS who-columns used for audit and incremental extraction.

No separate surrogate primary key or unique index is documented in the ETRM metadata; DIST_ID and BATCH_DIST_ID function as the practical business-key candidates in that absence and should be validated before assuming uniqueness.

Common Use Cases and Queries

Typical scenarios include monitoring interface import status, diagnosing stuck or rejected distributions, reconciling interface amounts against source transactions, and extracting incremental changes for downstream reporting.

A status-monitoring query groups pending rows by batch and status:

• SELECT BATCH_DIST_ID, IMPORT_STATUS_CODE, COUNT(*), SUM(AMOUNT_DR), SUM(AMOUNT_CR) FROM FUN.FUN_INTERFACE_DIST_LINES GROUP BY BATCH_DIST_ID, IMPORT_STATUS_CODE;

A cross-validation query joins lines to their trade partner and transaction context:

• SELECT TRX_ID, DIST_ID, PARTY_ID, PARTY_TYPE_FLAG, AMOUNT_DR, AMOUNT_CR, CCID FROM FUN.FUN_INTERFACE_DIST_LINES WHERE IMPORT_STATUS_CODE IS NULL;

An incremental extraction uses the standard audit columns to identify rows touched since the last run:

• SELECT * FROM FUN.FUN_INTERFACE_DIST_LINES WHERE LAST_UPDATE_DATE >= :last_run;

Reporting typically couples IMPORT_STATUS_CODE with the DFF ATTRIBUTE columns to explain rejection causes, and aggregates by DIST_TYPE_FLAG to confirm the intended DR/CR balance before release to the functional intercompany tables.

Related Objects

The documented FK indicates that DIST_ID references OKL_UPG_TRNS_ACC_DSTRS_T, establishing the lineage of the source distribution record.

• OKL_UPG_TRNS_ACC_DSTRS_T — joined on FUN_INTERFACE_DIST_LINES.DIST_ID = OKL_UPG_TRNS_ACC_DSTRS_T.DIST_ID.
• FUN_INTERFACE_HEADERS (and counterpart batch header tables) — keyed by the batch identifier that also carries BATCH_DIST_ID, used to retrieve batch-level context such as transaction date and currency.
• FUN_INTERCOMPANY_DISTRIBUTIONS (and related functional distribution tables) — the post-process destination into which validated interface lines are transferred.
• GL_CODE_COMBINATIONS — joined on CCID to resolve the distribution account and validate the Accounting Flexfield combination.
• HZ_PARTIES — joined on PARTY_ID to resolve the intercompany trading partner name and relationship details.
• BATCH_DIST_ID-keyed batch control records — used to reconcile the count and total DR/CR of interface lines against the originating batch.

Because the table is an open interface, the authoritative dependency is the interface processing program that reads IMPORT_STATUS_CODE and transfers qualifying rows; any custom extract should read-only, and never update FUN_INTERFACE_DIST_LINES without coordinating with that concurrent program.