Results for “fa_massadd_distributions”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FA_MASSADD_DISTRIBUTIONS is a transactional table in the Oracle E-Business Suite Fixed Assets (OFA) module, owned by the FA schema. It stores the distribution information associated with each mass addition line processed through the Mass Additions interface. When invoices, purchase orders, or other source systems feed capitalizable costs into Oracle Assets via Oracle Payables or external interfaces, each mass addition line may be split across multiple distribution entries. This table captures those splits, recording how a single mass addition line is allocated to units, depreciation expense accounts, physical locations, and employees.
The table serves as a critical staging and reference point between the pre-mass-additions queue (FA_MASS_ADDITIONS) and the eventual fixed asset book records. Distributions entered here drive the assignment of depreciation expense account combinations and cost center responsibility at the point an asset is created or added to a book. Based on the foreign key structure and ETRM Data Vault classification heuristics, this table is best modeled as a link entity, connecting mass addition lines to locations, depreciation expense code combinations, and employees. It resolves many-to-many style relationships rather than functioning as a standalone hub or a descriptive satellite.
Key Information Stored
The primary key is the surrogate identifier MASSADD_DIST_ID, which is also the single column of the unique index FA_MASSADD_DISTRIBUTIONS_U1. This column uniquely identifies each distribution record and does not carry business meaning on its own.
- MASSADD_DIST_ID — Surrogate primary key, generated per distribution row; the only documented unique business-key candidate.
- MASS_ADDITION_ID — Foreign key to FA_MASS_ADDITIONS; ties the distribution back to its parent mass addition line.
- UNITS — Quantity of units attributed to this distribution, enabling proportional splits of a mass addition line.
- DEPRN_EXPENSE_CCID — Foreign key to GL_CODE_COMBINATIONS; the depreciation expense account combination charged for this distribution.
- LOCATION_ID — Foreign key to FA_LOCATIONS; the physical location or location flexfield assigned to the distribution.
- EMPLOYEE_ID — Foreign key to PSB_EMPLOYEES; the employee custodian or assignee associated with the distributed units.
- CREATED_BY, CREATION_DATE — Standard audit columns capturing record creation.
- LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE — Standard audit columns capturing the last modification and login context.
The 11 documented columns include six descriptive/relationship attributes and four standard WHO audit columns, plus the surrogate key. Business users typically interact through MASS_ADDITION_ID, LOCATION_ID, DEPRN_EXPENSE_CCID, and UNITS rather than the primary key.
Common Use Cases and Queries
Typical usage centers on validating and reporting mass addition distributions before assets are created. Common scenarios include auditing account assignments, reconciling unit splits, and tracing distributions back to source invoices.
- Listing all distributions for a given mass addition line:
SELECT massadd_dist_id, mass_addition_id, units, deprn_expense_ccid, location_id, employee_id FROM fa.fa_massadd_distributions WHERE mass_addition_id = :p_mass_addition_id;
- Joining to GL_CODE_COMBINATIONS to display the depreciation expense account for each distribution.
- Joining to FA_LOCATIONS to report the physical location assigned during mass addition processing.
- Aggregating UNITS by MASS_ADDITION_ID to verify that distribution units reconcile to the mass addition quantity.
- Reporting distributions by employee for custodial or responsibility analysis.
Because distributions feed asset creation, reconciliation queries comparing FA_MASS_ADDITIONS to FA_MASSADD_DISTRIBUTIONS are common during period-end close and interface error resolution.
Related Objects
- FA_MASS_ADDITIONS — Parent table; joined on FA_MASSADD_DISTRIBUTIONS.MASS_ADDITION_ID = FA_MASS_ADDITIONS.MASS_ADDITION_ID.
- FA_LOCATIONS — Joined on LOCATION_ID; supplies location details for each distribution.
- GL_CODE_COMBINATIONS — Joined on DEPRN_EXPENSE_CCID; resolves the depreciation expense account combination.
- PSB_EMPLOYEES — Joined on EMPLOYEE_ID; provides employee/custodian information.
- FA_ADDITIONS and related FA asset tables — Downstream consumers once distributions drive asset creation.
- FA_MASSADD_DISTRIBUTIONS_PK / _U1 — Primary key and unique index supporting efficient lookups by MASSADD_DIST_ID.
-
Distribution information for each mass addition line
-
Distribution information for each mass addition line
-
PACKAGE BODY: APPS.FA_PERSON 12.1.1
-
PACKAGE: APPS.FA_PERSON 12.2.2
-
PACKAGE: APPS.FA_PERSON 12.1.1
-
PACKAGE BODY: APPS.FA_PERSON 12.2.2