Search Results fa_distribution_sets




Overview
Explore in AI Chat

Overview

The FA_DISTRIBUTION_SETS table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets (OFA) module, specifically in versions 12.1.1 and 12.2.2. It functions as the header table for defining and storing distribution sets. A distribution set is a predefined template that assigns asset depreciation expense to specific general ledger accounts across different percentages or amounts. This object is critical for automating and standardizing the accounting distribution of asset costs, ensuring consistent and accurate posting to the correct cost centers, departments, or natural accounts during depreciation runs and other asset transactions.

Key Information Stored

The table primarily stores metadata that defines each unique distribution set. The most critical column, as indicated by the user's search for "dist_set_id," is DIST_SET_ID. This is the system-generated primary key (FA_DISTRIBUTION_SETS_PK) that uniquely identifies each distribution set definition within the database. Another essential column is BOOK_TYPE_CODE, which is a foreign key linking the distribution set to a specific asset book in the FA_BOOK_CONTROLS table. This linkage ensures distribution sets are associated with the correct accounting rule set. While the provided metadata does not list all columns, typical attributes would include a user-defined NAME or DESCRIPTION for the set, creation dates, and status indicators.

Common Use Cases and Queries

The primary use case is querying distribution set definitions for reporting, audit, or integration purposes. A common pattern is to join with the detail table, FA_DISTRIBUTION_DEFAULTS, to get a complete view of a set's account assignments. For instance, to find all distribution sets for a specific asset book and their details, one might use:

  • SELECT fds.dist_set_id, fds.name, fdd.distribution_id, fdd.percent
  • FROM fa_distribution_sets fds, fa_distribution_defaults fdd
  • WHERE fds.dist_set_id = fdd.dist_set_id
  • AND fds.book_type_code = 'CORPORATE';

Another critical query involves identifying assets using a particular distribution set, which would require joining through the FA_DISTRIBUTION_HISTORY or FA_ADDITIONS tables. Administrators may also query this table to validate configuration or troubleshoot issues where depreciation expenses post to unexpected accounts.

Related Objects

As per the provided metadata, FA_DISTRIBUTION_SETS has defined relationships with several key objects. It is the parent table to FA_DISTRIBUTION_DEFAULTS via the DIST_SET_ID foreign key; this child table stores the individual account assignments (e.g., GL account, percentage) for each set. FA_DISTRIBUTION_SETS itself references FA_BOOK_CONTROLS through its BOOK_TYPE_CODE column, tethering the set to a specific asset book. In practice, it is also fundamentally related to FA_ADDITIONS (where a distribution set can be assigned to an asset) and FA_DEPRN_DETAIL (where the calculated depreciation is distributed using the set's rules). The distribution set ID is a crucial parameter for APIs and open interfaces that create or update asset information.