Search Results fa_mass_additions

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.