Search Results fa_massadd_distributions




Overview
Explore in AI Chat

Overview

The FA_MASSADD_DISTRIBUTIONS table is a core data object within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It serves as the detailed distribution repository for mass addition lines. When assets are created or updated in bulk via the Mass Additions interface—typically from external systems like Payables or Projects—this table stores the specific accounting and location distribution details for each asset line. Its primary role is to hold the segmented financial and logistical assignments (e.g., expense accounts, locations) that are applied during the final posting of mass additions to the FA_BOOKS and FA_DISTRIBUTION_HISTORY tables, ensuring accurate asset capitalization and depreciation accounting.

Key Information Stored

The table's structure is designed to capture distribution-level attributes for a mass addition line. The primary key, MASSADD_DIST_ID, uniquely identifies each distribution record. A critical foreign key column is MASS_ADDITION_ID, which links each distribution back to its parent header record in the FA_MASS_ADDITIONS table. Other significant columns include LOCATION_ID, which references the FA_LOCATIONS table to assign a physical or logical asset site, and DEPRN_EXPENSE_CCID, a foreign key to GL_CODE_COMBINATIONS that stores the code combination ID for the depreciation expense account. The table typically also contains columns for the distribution percentage or amount assigned to this specific accounting flexfield and location.

Common Use Cases and Queries

A primary use case is troubleshooting asset creation failures or reviewing distribution details before posting mass additions. Financial analysts may query this table to validate expense account assignments across a batch of new assets. A common reporting query joins to FA_MASS_ADDITIONS to list distributions for unposted lines:

  • SELECT mad.mass_addition_id, mad.deprn_expense_ccid, mad.location_id, ma.asset_number, ma.description FROM fa_massadd_distributions mad, fa_mass_additions ma WHERE mad.mass_addition_id = ma.mass_addition_id AND ma.post_status = 'POST';

Another critical scenario involves data correction, where updates to DEPRN_EXPENSE_CCID or LOCATION_ID in this table are required to fix erroneous distributions before the assets are capitalized.

Related Objects

FA_MASSADD_DISTRIBUTIONS maintains defined foreign key relationships with several key EBS tables, as documented in the ETRM metadata:

  • FA_MASS_ADDITIONS: The primary parent table. The join column is FA_MASSADD_DISTRIBUTIONS.MASS_ADDITION_ID referencing FA_MASS_ADDITIONS. This links distributions to the mass addition header information.
  • FA_LOCATIONS: Provides the physical location details. The join column is FA_MASSADD_DISTRIBUTIONS.LOCATION_ID.
  • GL_CODE_COMBINATIONS: Provides the accounting flexfield (chart of accounts) details for the depreciation expense. The join column is FA_MASSADD_DISTRIBUTIONS.DEPRN_EXPENSE_CCID.

This table is a direct precursor to the core asset distribution tables (FA_DISTRIBUTION_HISTORY) once mass addition lines are posted and become fully capitalized assets.

  • Table: FA_MASSADD_DISTRIBUTIONS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASSADD_DISTRIBUTIONS,  object_name:FA_MASSADD_DISTRIBUTIONS,  status:VALID,  product: OFA - Assets ,  description: Distribution information for each mass addition line ,  implementation_dba_data: FA.FA_MASSADD_DISTRIBUTIONS , 

  • Table: FA_MASSADD_DISTRIBUTIONS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASSADD_DISTRIBUTIONS,  object_name:FA_MASSADD_DISTRIBUTIONS,  status:VALID,  product: OFA - Assets ,  description: Distribution information for each mass addition line ,  implementation_dba_data: FA.FA_MASSADD_DISTRIBUTIONS , 

  • Table: FA_LOCATIONS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LOCATIONS,  object_name:FA_LOCATIONS,  status:VALID,  product: OFA - Assets ,  description: Location flexfield segment value combinations ,  implementation_dba_data: FA.FA_LOCATIONS , 

  • Table: FA_LOCATIONS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_LOCATIONS,  object_name:FA_LOCATIONS,  status:VALID,  product: OFA - Assets ,  description: Location flexfield segment value combinations ,  implementation_dba_data: FA.FA_LOCATIONS , 

  • Table: FA_MASS_ADDITIONS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_ADDITIONS,  object_name:FA_MASS_ADDITIONS,  status:VALID,  product: OFA - Assets ,  description: Information about assets that you want to automatically add to Oracle Assets from another system ,  implementation_dba_data: FA.FA_MASS_ADDITIONS , 

  • Table: FA_MASS_ADDITIONS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MASS_ADDITIONS,  object_name:FA_MASS_ADDITIONS,  status:VALID,  product: OFA - Assets ,  description: Information about assets that you want to automatically add to Oracle Assets from another system ,  implementation_dba_data: FA.FA_MASS_ADDITIONS ,