Search Results fun_dist_lines_n2

Overview

FUN.FUN_DIST_LINES is the intercompany distribution table within the Oracle E-Business Suite Financials (FUN) schema. It stores the accounting distributions generated for intercompany transactions, capturing both the initiator side (the entity that originates the transaction) and the recipient side (the entity that receives it). Each row represents a single distribution line, carrying the debits, credits, and code combination assignments required for intercompany balancing and settlement.

The table is central to the Oracle EBS intercompany accounting flow, where transactions between legal entities or balancing segments must be recorded symmetrically on both sides. Rows are qualified through a combination of PARTY_TYPE_FLAG and DIST_TYPE_FLAG: a value of I with L identifies an initiator distribution line; I with R identifies an initiator receivables account distribution line; R with L identifies a recipient distribution line; and R with P identifies a recipient payables account distribution line. This dual-flag design allows a single table to model the full accounting picture of an intercompany event.

Under the ETRM heuristic Data Vault classification, FUN_DIST_LINES is designated as standalone. From a dimensional modeling perspective, this suggests the table may be treated as an independent entity rather than being decomposed into a traditional hub, link, or satellite structure.

Key Information Stored

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

• DIST_ID — System-generated primary key for the distribution line, and the target of the unique index FUN_DIST_LINES_U1. This is the surrogate primary key and the single documented business-key candidate.
• LINE_ID — Identifier linking the distribution to its originating transaction line.
• DIST_NUMBER — Sequential distribution number for ordering and display.
• TRX_ID — The intercompany transaction identifier, indexed by FUN_DIST_LINES_N2.
• PARTY_ID — Stores the recipient party identifier when PARTY_TYPE_FLAG = R, otherwise the initiator party identifier.
• PARTY_TYPE_FLAG — Indicates the party side; valid values I and R.
• DIST_TYPE_FLAG — Indicates the distribution type; valid values L, R, and P.
• AMOUNT_CR / AMOUNT_DR — Credit and debit amounts for the distribution line.
• CCID — Code combination identifier referencing the accounting flexfield.
• BATCH_DIST_ID — Populated when the distribution was created through automatic proration.
• AUTO_GENERATE_FLAG — Distinguishes manually entered lines from automatically generated ones.
• DESCRIPTION — Free-text description of the distribution line.
• ATTRIBUTE1–ATTRIBUTE15 / ATTRIBUTE_CATEGORY — Descriptive flexfield segments.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns.

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include retrieving all distributions for a given intercompany transaction, isolating initiator versus recipient lines, and comparing debit and credit totals for balancing checks.

To retrieve all lines for a transaction:

SELECT DIST_ID, LINE_ID, DIST_NUMBER,
       PARTY_TYPE_FLAG, DIST_TYPE_FLAG,
       AMOUNT_DR, AMOUNT_CR, CCID
  FROM FUN.FUN_DIST_LINES
 WHERE TRX_ID = :p_trx_id;

To separate initiator from recipient distributions:

SELECT PARTY_TYPE_FLAG, DIST_TYPE_FLAG,
       SUM(NVL(AMOUNT_DR,0)) dr_total,
       SUM(NVL(AMOUNT_CR,0)) cr_total
  FROM FUN.FUN_DIST_LINES
 WHERE TRX_ID = :p_trx_id
 GROUP BY PARTY_TYPE_FLAG, DIST_TYPE_FLAG;

To find automatically prorated lines, filter on BATCH_DIST_ID IS NOT NULL or on the AUTO_GENERATE_FLAG value. Auditing queries commonly join to GL code combinations via CCID.

Related Objects

• OKL_UPG_TRNS_ACC_DSTRS_T — Referenced via the foreign key from FUN_DIST_LINES.DIST_ID according to the documented relationship data, linking distribution lines to the upgrade transaction account distributions.
• FUN_DIST_LINES_N1 — Nonunique index on TRX_ID supporting transaction-based lookups.
• FUN_DIST_LINES_N2 — Nonunique index on LINE_ID supporting line-level joins.
• GL_CODE_COMBINATIONS — Joined through CCID to resolve accounting flexfield accounts.
• Intercompany transaction header/line tables in the FUN schema — Joined through TRX_ID and LINE_ID to reconstruct the full transaction context.
• Oracle Intercompany APIs — Populate FUN_DIST_LINES during distribution generation and automatic proration.