Results for “fa_distribution_defaults”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_DISTRIBUTION_DEFAULTS is an Oracle E-Business Suite table owned by the FA schema within the OFA (Assets) product module. It stores distribution set information, specifically the default accounting and assignment attributes applied when depreciation expense is allocated across distribution sets, locations, and employees. In release 12.1.1 and 12.2.2, this table is documented as VALID and contains 11 columns.

Functionally, the table acts as a bridge between a distribution set definition and the destination attributes (expense account, location, employee) that drive the allocation percentages for a given default line. Each row represents one default distribution line within a set, carrying the percentage of the set to be applied to a particular combination of depreciation expense account and either a location or an employee.

Using the heuristic Data Vault classification mined from the foreign key structure, this object models as a link. It resolves many-to-many-style associations between FA_DISTRIBUTION_SETS, GL_CODE_COMBINATIONS, FA_LOCATIONS, and PSB_EMPLOYEES, rather than behaving as a pure reference hub or a descriptive satellite. This classification is a modeling suggestion only; the transactional semantics remain those of a setup/defaults table.

Key Information Stored

The table is keyed by the surrogate primary key DIST_DEFAULT_ID, enforced by the constraint FA_DISTRIBUTION_DEFAULTS_PK. A unique index documented as FA_DISTRIBUTIONS_DEFAULT_U1 also lists DIST_DEFAULT_ID, making it the business-key candidate for the object. The remaining documented columns carry the substantive distribution information:

• DIST_SET_ID — identifies the parent distribution set in FA_DISTRIBUTION_SETS to which this default line belongs.
• UNIT_PERCENTAGE — the share of the distribution set assigned to this line; the driver behind multi-line allocation.
• DEPRN_EXPENSE_CCID — the depreciation expense account, joined to GL_CODE_COMBINATIONS.
• LOCATION_ID — the location receiving the allocation, joined to FA_LOCATIONS.
• EMPLOYEE_ID — the employee receiving the allocation, joined to PSB_EMPLOYEES.
• CREATED_BY, CREATION_DATE — standard WHO-column audit attributes recording row creation.
• LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — standard audit attributes recording the most recent modification and session.

The presence of both LOCATION_ID and EMPLOYEE_ID reflects the two supported defaulting modes: allocation by location or allocation by employee. In practical use a given default line typically resolves to one of these targets, with UNIT_PERCENTAGE supplying the weighting and DEPRN_EXPENSE_CCID supplying the accounting destination.

Common Use Cases and Queries

The most common requirement is to enumerate the default distribution lines for a set and join each line to its accounting and destination context. A representative pattern follows:

• Retrieve all default lines for a distribution set: SELECT DIST_DEFAULT_ID, DIST_SET_ID, UNIT_PERCENTAGE, DEPRN_EXPENSE_CCID, LOCATION_ID, EMPLOYEE_ID FROM FA.FA_DISTRIBUTION_DEFAULTS WHERE DIST_SET_ID = :p_set_id;
• Validate that percentages sum correctly per set, grouped by DIST_SET_ID, to confirm allocation completeness.
• Resolve the expense account by joining DEPRN_EXPENSE_CCID to GL_CODE_COMBINATIONS and the location by joining LOCATION_ID to FA_LOCATIONS.
• Audit changes over time using LAST_UPDATED_BY and LAST_UPDATED_DATE to identify recently modified defaults.

Typical reporting scenarios include reconciliation of depreciation expense allocation, verification of distribution set setup before running depreciation, and migration or comparison exercises between environments where distribution set integrity must be confirmed.

Related Objects

The documented foreign keys establish the core relationships to external objects:

• FA_DISTRIBUTION_SETS — parent set definition, joined on DIST_SET_ID.
• GL_CODE_COMBINATIONS — depreciation expense account, joined on DEPRN_EXPENSE_CCID.
• FA_LOCATIONS — allocation location, joined on LOCATION_ID.
• PSB_EMPLOYEES — allocation employee, joined on EMPLOYEE_ID.

Together these references make FA_DISTRIBUTION_DEFAULTS the connective setup object between distribution sets and the general ledger, location, and employee master data that Oracle Assets uses when allocating depreciation expense.