Search Results fun_dist_lines




Overview
Explore in AI Chat

Overview

FUN_DIST_LINES is a table in the FUN (Financials Common Modules) product schema within Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. It stores the distribution lines associated with intercompany transactions, capturing both the initiator side and the recipient side of each intercompany entry. As documented in the ETRM metadata, the table is central to the Intercompany accounting flow: a row flagged with PARTY_TYPE_FLAG = 'I' together with DIST_TYPE_FLAG = 'L' represents an Initiator distribution line, while the complementary flag combinations represent recipient-side distributions. The object carries 34 columns in the documented 12.2.2 physical schema and is owned by the FUN schema.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. This suggests the table functions principally as a self-contained detail or transaction entity rather than as a pure hub, link, or satellite, and any downstream warehouse design should treat it as such unless further relationships are established.

Key Information Stored

The table's surrogate primary key is DIST_ID, which is also the single documented unique index (FUN_DIST_LINES_U1) and therefore the strongest business-key candidate. Note that DIST_ID is additionally documented as a foreign key referencing OKL_UPG_TRNS_ACC_DSTRS_T, an upgrade-related leasing table used during data migration.

The most significant columns include:

  • DIST_ID — surrogate primary key uniquely identifying each distribution line.
  • LINE_ID — links the distribution back to its originating intercompany transaction line.
  • TRX_ID — identifies the parent intercompany transaction header.
  • DIST_NUMBER — the user-visible distribution line number.
  • PARTY_ID and PARTY_TYPE_FLAG — identify the party and whether the line is an initiator ('I') or recipient distribution.
  • DIST_TYPE_FLAG — classifies the distribution type; combined with PARTY_TYPE_FLAG it distinguishes initiator lines ('L') from other roles.
  • BATCH_DIST_ID — groups distributions belonging to a batch run.
  • AMOUNT_CR and AMOUNT_DR — the credit and debit monetary amounts of the distribution.
  • CCID — the code combination identifier used to derive the accounting flexfield.
  • DESCRIPTION — free-text description of the distribution.
  • AUTO_GENERATE_FLAG — indicates whether the line was system-generated.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard EBS descriptive flexfield columns.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns.

Common Use Cases and Queries

Typical reporting scenarios reconcile initiator distributions against recipient distributions for a given intercompany transaction, validate that debits and credits balance, and audit the accounting flexfield assignments behind each line. A representative query extracts initiator lines for a specific transaction:

  • SELECT dist_id, line_id, dist_number, ccid, amount_dr, amount_cr FROM fun.fun_dist_lines WHERE trx_id = :p_trx_id AND party_type_flag = 'I' AND dist_type_flag = 'L';
  • SELECT party_type_flag, SUM(amount_dr), SUM(amount_cr) FROM fun.fun_dist_lines WHERE trx_id = :p_trx_id GROUP BY party_type_flag; — used to confirm initiator/recipient balance.
  • SELECT batch_dist_id, COUNT(*), SUM(amount_dr - amount_cr) FROM fun.fun_dist_lines GROUP BY batch_dist_id HAVING SUM(amount_dr - amount_cr) <> 0; — batch-level balancing check.

Reconciliation reports frequently join CCID to GL_CODE_COMBINATIONS to translate accounting flexfields, and join TRX_ID and LINE_ID back to their parent intercompany transaction tables.

Related Objects

The documented foreign key links FUN_DIST_LINES.DIST_ID to OKL_UPG_TRNS_ACC_DSTRS_T, an upgrade staging table in the leasing module, reflecting the data-migration path. Beyond this documented relationship, FUN_DIST_LINES is referenced by the intercompany transaction structures that own TRX_ID and LINE_ID, and its CCID values are resolved against GL_CODE_COMBINATIONS in the general ledger schema. Standard EBS reporting joins also involve FND_FLEX_VALUES and FND_FLEX_VALUE_SETS for descriptive flexfield interpretation of ATTRIBUTE_CATEGORY and ATTRIBUTE1–15, and the WHO audit columns reference FND_USER for CREATED_BY and LAST_UPDATED_BY. Batch-level processing relies on BATCH_DIST_ID linking to the intercompany batch definition objects. Because the table is classified as standalone, no dedicated child links are documented, but the TRX_ID and LINE_ID columns are the primary join paths to the intercompany transaction and line entities.