Search Results do_mass_addition

Overview

FA_MASSADD_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Fixed Assets mass addition process. Mass additions allow organizations to create asset records in bulk from external feeder systems — for example, payables invoice distributions, purchasing receipts, projects capitalizations, or external flat-file uploads — without manually entering each asset through the Fixed Assets form. FA_MASSADD_PKG orchestrates the core processing logic that transforms staged, source-system records into live asset rows in the Fixed Assets tables.

The package is classified in the ETRM documentation as an "OTHER" API rather than a published open interface or public API, which indicates that it is primarily an internal engine invoked by the standard Oracle mass additions flow rather than a supported integration point. Its status is VALID, confirming it is active and compiled in the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The documented package exposes three procedures:

• DO_MASS_ADDITION — Drives the creation of asset additions from staged mass addition records. It converts qualifying rows in the mass additions interface tables into assets in FA_ADDITIONS and the associated distribution and book records.
• DO_MASS_PROPERTY — Handles the property-related attributes and book processing associated with the mass addition, establishing the per-book asset records (FA_BOOKS) and distribution history needed for capitalized and expensed asset books.
• ALLOCATE_WORKERS — Manages the assignment of workers/processing units to the mass addition run, supporting the parallel or partitioned processing model used when large volumes of mass additions are being posted.

Parameter lists are not exposed in the ETRM metadata, and per Oracle convention these are internal signatures that may change across releases; consumers should not code against them directly.

Tables Accessed

FA_MASSADD_PKG touches the central tables of the Fixed Assets model, referenced through APPS synonyms:

• FA_MASS_ADDITIONS and FA_MASSADD_DISTRIBUTIONS — the staging interface tables holding records awaiting conversion and their distribution detail.
• FA_ADDITIONS, FA_ADDITIONS_S, FA_ADDITIONS_TL — the base, secondary (KFF), and translated asset tables where new assets are created.
• FA_BOOKS and FA_BOOK_CONTROLS — per-book asset cost, depreciation, and book-control settings governing posting.
• FA_CATEGORIES and FA_CATEGORY_BOOK_DEFAULTS — category and category-to-book default rules that determine asset defaults during creation.
• FA_DISTRIBUTION_HISTORY — distribution records generated for the new assets.
• FA_CALENDAR_PERIODS and FA_FISCAL_YEAR — depreciation calendar and fiscal-year context used for date/period validation.
• FA_MC_MASS_RATES — multi-currency mass rate information used in global/multi-currency environments.
• DUAL and PLITBLM — utility references (PLITBLM being the generic PL/SQL table/index-by table type).

The package also references APPS.FA_API_TYPES for the shared Fixed Assets API type definitions.

Usage Notes

FA_MASSADD_PKG is not intended for direct customer invocation. It is typically exercised through the standard Fixed Assets mass additions workflow — for instance, the "Post Mass Additions" concurrent program and the Prepare Mass Additions / Mass Additions form flow that moves records from the interface tables into FA_ADDITIONS and FA_BOOKS. Because it is classified as OTHER and is referenced by no other documented packages in the ETRM metadata, custom code should avoid calling it directly; Oracle does not expose a stability guarantee for its interfaces. Integrations requiring asset creation should instead use the supported external interfaces and public APIs (for example FA_MASS_ADDITIONS_PUB or the standard Payables/Projects mass addition feeders). Where custom extensions require the same business logic, they should invoke the supported public entry points rather than DO_MASS_ADDITION, DO_MASS_PROPERTY, or ALLOCATE_WORKERS directly.