Results for “add_to_asset_id”

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

Overview

FA_MASS_ADDITIONS is a core table in the Oracle Assets (OFA) module of Oracle E-Business Suite, holding the staging and control records for assets that an external feeder system — such as Payables, Projects, Purchasing, or a third-party source — intends to add automatically into Oracle Assets. Each row represents a mass addition line that originates from an external source and is processed through the Mass Additions queue before being posted to the FA_ADDITIONS_B asset register (or rejected, merged, or split). The table supports the entire lifecycle of a mass addition: creation from an external source, review, adjustment, merge, split, and final posting to a book controlled by FA_BOOK_CONTROLS.

The ETRM metadata classifies this object heuristically as satellite-leaning. In a Data Vault 2.0 interpretation, FA_MASS_ADDITIONS would be modeled as a satellite on a business key such as ASSET_NUMBER or MASS_ADDITION_ID, with links to AP invoices, projects, purchase orders, and the asset register. This classification reflects the table's role as an attribute-rich, transaction-scoped record rather than a pure hub or link.

Key Information Stored

The table carries 205 documented columns and is uniquely identified by the surrogate primary key MASS_ADDITION_ID via FA_MASS_ADDITIONS_PK and the unique index FA_MASS_ADDITIONS_U1. Business-identifying attributes include:

• MASS_ADDITION_ID — surrogate primary key. ASSET_NUMBER and TAG_NUMBER — business identifiers for the asset, both referencing FA_ADDITIONS_B where applicable.
• DESCRIPTION, ASSET_CATEGORY_ID (FK to FA_CATEGORIES_B), BOOK_TYPE_CODE (FK to FA_BOOK_CONTROLS), and DATE_PLACED_IN_SERVICE — primary asset attributes that determine depreciation.
• FIXED_ASSETS_COST, PAYABLES_COST, SALVAGE_VALUE, and DEPRECIATE_FLAG — cost and depreciation control fields.
• PAYABLES_CODE_COMBINATION_ID and EXPENSE_CODE_COMBINATION_ID (both FK to GL_CODE_COMBINATIONS) — the accounting distribution accounts.
• LOCATION_ID (FK to FA_LOCATIONS), ASSIGNED_TO, MANUFACTURER_NAME, SERIAL_NUMBER, MODEL_NUMBER — physical and assignment attributes.
• POSTING_STATUS, QUEUE_NAME, POST_BATCH_ID, CREATE_BATCH_ID, REQUEST_ID — queue and concurrent request control fields.
• PARENT_MASS_ADDITION_ID, PARENT_ASSET_ID, SPLIT_MERGED_CODE, ADD_TO_ASSET_ID — self-referencing and merge/split lineage fields.
• INVOICE_ID, AP_DISTRIBUTION_LINE_NUMBER, PO_DISTRIBUTION_ID, PROJECT_ID, TASK_ID — source transaction linkages to Payables, Purchasing, and Projects.

Common Use Cases and Queries

The most frequent operational query is to inspect mass additions awaiting review or posting, often filtered by queue and book:

SELECT mass_addition_id, asset_number, description, book_type_code, posting_status, queue_name, fixed_assets_cost FROM fa.fa_mass_additions WHERE posting_status = 'ON QUEUE' AND book_type_code = :book;

Reporting patterns typically join to FA_ADDITIONS_B to reconcile posted mass additions against the asset register, to AP_INVOICES_ALL via INVOICE_ID for invoice-to-asset reconciliation, and to PA_PROJECT_ASSET_LINES_ALL via PROJECT_ASSET_LINE_ID for capitalized project costs. Common scenarios include: identifying duplicate invoices before posting, tracing merge/split lineage through PARENT_MASS_ADDITION_ID, and querying by FEEDER_SYSTEM_NAME to audit third-party integration feeds. The FA_MASSADD_DISTRIBUTIONS child table is frequently joined to obtain the multi-distribution breakdown per mass addition.

Related Objects

• FA_ADDITIONS_B — joined through ASSET_NUMBER, PARENT_ASSET_ID, and ADD_TO_ASSET_ID; receives the posted asset when a mass addition is added.
• FA_ASSET_INVOICES — references FA_MASS_ADDITIONS via PARENT_MASS_ADDITION_ID, MERGE_PARENT_MASS_ADDITIONS_ID, and SPLIT_PARENT_MASS_ADDITIONS_ID, capturing invoice association history.
• FA_MASSADD_DISTRIBUTIONS — child table via MASS_ADDITION_ID, holding distribution lines for a mass addition.
• FA_DELETED_MASS_ADDITIONS — retains deleted mass addition records via MASS_ADDITION_ID.
• FA_MC_MASS_RATES — multi-currency mass addition rates keyed to MASS_ADDITION_ID and PARENT_MASS_ADDITION_ID.
• AP_INVOICES_ALL / AP_INVOICE_DISTRIBUTIONS_ALL — source invoice linkages through INVOICE_ID and AP_DISTRIBUTION_LINE_NUMBER.
• PO_DISTRIBUTIONS_ALL / PO_VENDORS — purchasing source references via PO_DISTRIBUTION_ID and PO_VENDOR_ID.
• PA_PROJECTS_ALL, PA_TASKS, PA_PROJECT_ASSET_LINES_ALL — Projects integration through PROJECT_ID, TASK_ID, and PROJECT_ASSET_LINE_ID.
• FND_CONCURRENT_REQUESTS — batch control through REQUEST_ID, CREATE_BATCH_ID, and POST_BATCH_ID.
• JAI_FA_MASS_ADDITIONS — regional (India) localization extension keyed to MASS_ADDITION_ID.