Results for “end_dpis”

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

Overview

FA_DISTRIBUTION_SETS is the header table for distribution sets within the Oracle E-Business Suite Fixed Assets (OFA) module. A distribution set defines a reusable allocation template that determines how depreciation expense and other asset-related charges are distributed across accounts when assets are added, adjusted, transferred, or retired. The table resides in the FA schema and is classified as VALID in Oracle EBS 12.1.1 and 12.2.2.

The table stores the identifying attributes and effective period ranges that govern each distribution set. It is the parent object to which individual account distribution lines and default assignments are attached, functioning as the governing header record for downstream allocation logic. Based on the foreign key topology documented in the ETRM metadata, the object exhibits a satellite-leaning Data Vault classification: it carries descriptive attributes (name, description, effective period range) tied to a parent context — the asset book — rather than acting as an independent business hub or a pure associative link. Modelers designing a Data Vault layer should consider treating FA_DISTRIBUTION_SETS as a satellite hanging off FA_BOOK_CONTROLS, with DIST_SET_ID serving as the surrogate key.

Key Information Stored

The table contains eleven documented columns. The most significant are:

• DIST_SET_ID — The surrogate primary key, enforced by FA_DISTRIBUTION_SETS_PK and reinforced by the unique index FA_DISTRIBUTIONS_SETS_U1. It uniquely identifies each distribution set instance and is the join key referenced by dependent tables.
• NAME — The user-defined name of the distribution set, used to identify the template in the Fixed Assets application and in reporting.
• BOOK_TYPE_CODE — The asset book to which the distribution set belongs. This is a foreign key to FA_BOOK_CONTROLS and establishes the corporate or tax book context for the allocation rules.
• BEGIN_DPIS and END_DPIS — The date placed-in-service range (begin and end) for which the distribution set is effective. These columns allow multiple distribution sets to coexist for the same book, scoped to different DPIS windows, enabling period-sensitive allocation behavior.
• DESCRIPTION — Free-text narrative describing the purpose or scope of the distribution set.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — The standard Oracle EBS WHO columns providing audit lineage for row creation and modification.

Only DIST_SET_ID is a documented business-key candidate via the unique index; there is no documented natural-key unique constraint on NAME or BOOK_TYPE_CODE alone, so NAME should not be assumed globally unique.

Common Use Cases and Queries

Typical usage centers on locating the distribution set applicable to a given book and date-placed-in-service, then drilling into its allocation lines. A representative query joins the header to its defaults:

• Retrieve active distribution sets for a book within a DPIS window: SELECT dist_set_id, name, begin_dpis, end_dpis FROM fa_distribution_sets WHERE book_type_code = :book AND :dpis BETWEEN begin_dpis AND end_dpis;
• List allocation defaults per set: SELECT d.name, dd.* FROM fa_distribution_sets d, fa_distribution_defaults dd WHERE d.dist_set_id = dd.dist_set_id;
• Audit recently modified sets: SELECT dist_set_id, name, last_updated_by, last_update_date FROM fa_distribution_sets ORDER BY last_update_date DESC;

Reporting use cases include validating that every asset book has adequate distribution coverage, reconciling distribution sets against book controls, and feeding allocation data into depreciation and expense reporting extracts.

Related Objects

The following objects are the most significant dependencies based on documented foreign key relationships:

• FA_BOOK_CONTROLS — Referenced by FA_DISTRIBUTION_SETS.BOOK_TYPE_CODE; the parent book definition.
• FA_DISTRIBUTION_DEFAULTS — References FA_DISTRIBUTION_SETS.DIST_SET_ID; holds the per-account allocation lines.
• FA_HIERARCHY_DISTRIBUTIONS — References DIST_SET_ID; links hierarchy distributions to the set.
• FA_ASSET_HIERARCHY_VALUES — References DIST_SET_ID; associates hierarchy values with the set.

Together these objects define the complete distribution framework, with FA_DISTRIBUTION_SETS acting as the header that governs downstream allocation behavior.