Search Results fa_mass_additions




Overview
Explore in AI Chat

Overview

The FA_MASS_ADDITIONS table is a core staging table within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). Its primary role is to serve as a data repository for asset information imported from external systems, such as Oracle Payables or legacy applications, prior to formal creation and capitalization of assets in the Oracle Assets application. This table is the central object for the Mass Additions process, a critical workflow that enables the bulk review, validation, and posting of asset transactions. It acts as an intermediary holding area, allowing for data cleansing, categorization, and assignment of accounting rules before assets are permanently added to the FA_ADDITIONS_B table.

Key Information Stored

The table stores a comprehensive set of attributes for each prospective asset. Key columns include the unique identifier MASS_ADDITION_ID, which is the table's primary key. Critical descriptive and financial columns include ASSET_NUMBER, DESCRIPTION, TAG_NUMBER, and COST. Columns such as ASSET_CATEGORY_ID, BOOK_TYPE_CODE, and DATE_PLACED_IN_SERVICE define the asset's classification and accounting treatment. The table also holds relational keys to trace the source transaction, including INVOICE_ID and PO_DISTRIBUTION_ID for Payables and Purchasing integrations, and POST_BATCH_ID to track the concurrent request that created the mass additions. Status is managed via columns like POSTING_STATUS and PROCESS_FLAG, which control the workflow from 'New' to 'Posted'.

Common Use Cases and Queries

The primary use case is the management of the Mass Additions workflow. Users typically query this table to review unposted assets, identify errors, or prepare for posting. Common SQL patterns include filtering by status to find assets ready for processing or troubleshooting failed items. Reporting often focuses on the cost and count of assets in various stages of the pipeline.

  • Querying new mass additions for a specific book: SELECT mass_addition_id, asset_number, description, cost FROM fa_mass_additions WHERE book_type_code = 'CORP' AND posting_status = 'NEW';
  • Identifying mass additions linked to a specific invoice for audit purposes: SELECT * FROM fa_mass_additions WHERE invoice_id = <invoice_id>;
  • Finding mass additions that failed to post due to validation errors: SELECT mass_addition_id, error_message FROM fa_mass_additions WHERE posting_status = 'ERROR';

Related Objects

As indicated by its extensive foreign key relationships, FA_MASS_ADDITIONS is deeply integrated with multiple EBS modules. Its most direct relationship is with FA_ADDITIONS_B, the master assets table, linked via MASS_ADDITION_ID, ASSET_NUMBER, and PARENT_ASSET_ID. For source tracking, it references AP_INVOICES_ALL and PO_DISTRIBUTIONS_ALL. It links to foundational setup tables such as FA_CATEGORIES_B for asset categories, FA_BOOK_CONTROLS for book definitions, and GL_CODE_COMBINATIONS for accounting flexfields. For project accounting integration, it references PA_PROJECTS_ALL and PA_TASKS. The table is also referenced by the concurrent request system (FND_CONCURRENT_REQUESTS) to manage the posting process.

  • 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 , 

  • Table: FA_ASSET_INVOICES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_INVOICES,  object_name:FA_ASSET_INVOICES,  status:VALID,  product: OFA - Assets ,  description: Accounts payable and purchasing information for each asset ,  implementation_dba_data: FA.FA_ASSET_INVOICES , 

  • Table: FA_ASSET_INVOICES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_INVOICES,  object_name:FA_ASSET_INVOICES,  status:VALID,  product: OFA - Assets ,  description: Accounts payable and purchasing information for each asset ,  implementation_dba_data: FA.FA_ASSET_INVOICES , 

  • Table: FA_MC_MASS_RATES 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_MASS_RATES,  object_name:FA_MC_MASS_RATES,  status:VALID,  product: OFA - Assets ,  description: Exchange rate information for mass additions process ,  implementation_dba_data: FA.FA_MC_MASS_RATES , 

  • Table: FA_MC_MASS_RATES 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_MC_MASS_RATES,  object_name:FA_MC_MASS_RATES,  status:VALID,  product: OFA - Assets ,  description: Exchange rate information for mass additions process ,  implementation_dba_data: FA.FA_MC_MASS_RATES , 

  • Table: FA_DELETED_MASS_ADDITIONS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_DELETED_MASS_ADDITIONS,  object_name:FA_DELETED_MASS_ADDITIONS,  status:VALID,  product: OFA - Assets ,  description: Invoice information of mass additions you deleted from the FA_MASS_ADDITIONS table using the Delete Mass Additions form ,  implementation_dba_data: FA.FA_DELETED_MASS_ADDITIONS , 

  • Table: FA_DELETED_MASS_ADDITIONS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_DELETED_MASS_ADDITIONS,  object_name:FA_DELETED_MASS_ADDITIONS,  status:VALID,  product: OFA - Assets ,  description: Invoice information of mass additions you deleted from the FA_MASS_ADDITIONS table using the Delete Mass Additions form ,  implementation_dba_data: FA.FA_DELETED_MASS_ADDITIONS , 

  • Table: FA_ADDITIONS_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ADDITIONS_B,  object_name:FA_ADDITIONS_B,  status:VALID,  product: OFA - Assets ,  description: Descriptive information about assets (base MLS table) ,  implementation_dba_data: FA.FA_ADDITIONS_B , 

  • Table: FA_ADDITIONS_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ADDITIONS_B,  object_name:FA_ADDITIONS_B,  status:VALID,  product: OFA - Assets ,  description: Descriptive information about assets (base MLS table) ,  implementation_dba_data: FA.FA_ADDITIONS_B , 

  • Table: FA_ASSET_KEYWORDS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_KEYWORDS,  object_name:FA_ASSET_KEYWORDS,  status:VALID,  product: OFA - Assets ,  description: Asset key flexfield segment combinations ,  implementation_dba_data: FA.FA_ASSET_KEYWORDS , 

  • Table: FA_ASSET_KEYWORDS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_ASSET_KEYWORDS,  object_name:FA_ASSET_KEYWORDS,  status:VALID,  product: OFA - Assets ,  description: Asset key flexfield segment combinations ,  implementation_dba_data: FA.FA_ASSET_KEYWORDS , 

  • 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_CATEGORIES_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORIES_B,  object_name:FA_CATEGORIES_B,  status:VALID,  product: OFA - Assets ,  description: Default financial information for asset categories (base MLS table) ,  implementation_dba_data: FA.FA_CATEGORIES_B , 

  • Table: FA_CATEGORIES_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORIES_B,  object_name:FA_CATEGORIES_B,  status:VALID,  product: OFA - Assets ,  description: Default financial information for asset categories (base MLS table) ,  implementation_dba_data: FA.FA_CATEGORIES_B , 

  • Table: FA_BOOK_CONTROLS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS , 

  • Table: FA_BOOK_CONTROLS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS , 

  • View: FA_MASS_ADDITIONS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_MASS_ADDITIONS_V,  object_name:FA_MASS_ADDITIONS_V,  status:VALID,  product: OFA - Assets ,  implementation_dba_data: APPS.FA_MASS_ADDITIONS_V , 

  • View: FA_MASS_ADDITIONS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OFA.FA_MASS_ADDITIONS_V,  object_name:FA_MASS_ADDITIONS_V,  status:VALID,  product: OFA - Assets ,  implementation_dba_data: APPS.FA_MASS_ADDITIONS_V ,