Search Results dist_default_id

Overview

The FA_DISTRIBUTION_DEFAULTS table is a core data structure within the Oracle E-Business Suite Fixed Assets module (OFA). It serves as a repository for the detailed accounting rules that constitute a distribution set. A distribution set is a configuration tool used to automate the assignment of specific accounting flexfields—namely the depreciation expense and location—to individual asset assignments. This functionality is critical for ensuring consistent and accurate accounting entries during depreciation runs, particularly for assets distributed across multiple cost centers or departments. The table operates as the child entity to the FA_DISTRIBUTION_SETS table, storing the individual line items of a set.

Key Information Stored

Each record in FA_DISTRIBUTION_DEFAULTS defines a single accounting rule within a distribution set. The primary columns, as indicated by the metadata, include the unique identifier DIST_DEFAULT_ID and the foreign key DIST_SET_ID, which links the record to its parent distribution set in the FA_DISTRIBUTION_SETS table. The two most significant accounting columns are DEPRN_EXPENSE_CCID, which holds the Code Combination ID (CCID) for the depreciation expense account, and LOCATION_ID, which identifies the physical or logical location for the asset. The DEPRN_EXPENSE_CCID column is enforced by a foreign key relationship to the GL_CODE_COMBINATIONS table, ensuring referential integrity with the General Ledger. Similarly, the LOCATION_ID references the FA_LOCATIONS table.

Common Use Cases and Queries

The primary use case is the creation and maintenance of distribution sets via the Oracle Assets user interface, which manages inserts, updates, and deletes to this table. For reporting and troubleshooting, common queries involve joining this table to related entities to analyze the accounting rules. A typical pattern is to retrieve all distribution defaults for a specific set to validate its configuration:

• SELECT fdd.dist_default_id, fdd.deprn_expense_ccid, fdd.location_id, fl.segment1 FROM fa_distribution_defaults fdd, fa_locations fl WHERE fdd.location_id = fl.location_id AND fdd.dist_set_id = <SET_ID> ORDER BY fdd.dist_default_id;

Another critical use is during the mass addition or assignment process, where the system references the rules in this table to automatically populate the depreciation expense account and location for an asset line based on the assigned distribution set.

Related Objects

FA_DISTRIBUTION_DEFAULTS is centrally connected to several key Fixed Assets tables, as defined by its foreign key constraints. Its parent table is FA_DISTRIBUTION_SETS (via DIST_SET_ID). For accounting validation, it references GL_CODE_COMBINATIONS (via DEPRN_EXPENSE_CCID). For location data, it references FA_LOCATIONS (via LOCATION_ID). In application logic, it is heavily utilized by the FA_DISTRIBUTION_PUB application programming interface (API) package, which provides the programmatic procedures for managing distribution sets and their defaults. Data from this table is also reflected in key reporting views such as FA_DISTRIBUTION_DEFAULTS_V.