Search Results undo_split_mass_additions




Overview
Explore in AI Chat

Overview

APPS.SPLIT_MASS_ADDITIONS_PKG is a PL/SQL package in the Oracle E-Business Suite Fixed Assets module. It supports the mass additions interface by allowing a single mass addition line to be divided into multiple child mass additions, and by reversing such a division if required. Mass additions represent capitalizable transactions imported from external sources (such as Payables, Purchasing, or Projects) and staged in the FA_MASS_ADDITIONS tables before being posted as asset lines. Splitting is required when a single imported transaction must be distributed across multiple assets — for example, when a bulk invoice line covers several capitalized items with distinct cost, salvage, production capacity, or depreciation attributes.

The package header dates to a 2005 revision (faxisps.pls 120.1) and is still present in both release 12.1.1 and 12.2.2. Its documented API classification is OTHER, meaning it is not a formally published public API; it is internal plumbing used by the Fixed Assets mass additions framework. Consequently, no other package in the environment is documented as referencing it, which reinforces that its callers are forms and processing logic within the FA product family rather than external integrations.

Key Procedures and Functions

  • SPLIT_MASS_ADDITIONS — Performs the split operation for a mass addition identified by its mass addition ID, book type, and currency. Callers supply the parent's financial and physical attributes (unit cost from FA and AP sources, salvage value, production capacity, revaluation amortization basis, revaluation reserve, unrevalued cost, year-to-date revalued depreciation expense, depreciation reserve, YTD depreciation, and beginning net book value) together with unit counts and merge/split codes. The procedure apportions these parent values across the newly created child mass additions. An optional logging record (FA_API_TYPES.log_level_rec_type) controls diagnostic output.
  • UNDO_SPLIT_MASS_ADDITIONS — Reverses a prior split for the specified mass addition and merge code, removing the generated child records and restoring the original mass addition structure. It accepts the mass addition ID, the merge code, and the same optional log level record.
  • INSERT_SPLIT_CHILD — The worker routine that physically creates a single child mass addition row. This is the procedure surfaced by the search term insert_split_child. It receives the source and new mass addition IDs, the split and merge parent identifiers, and the full set of financial and physical attribute values (FA cost, PA cost, salvage value, production capacity, revaluation amortization basis, revaluation reserve, unrevalued cost, YTD revalued depreciation expense, depreciation reserve, YTD depreciation, beginning NBV, total FA units, merge child FA units, and sum units). It is normally invoked iteratively by SPLIT_MASS_ADDITIONS rather than called directly.

Tables Accessed

The package reads and writes the core mass additions tables and their audit counterparts:

  • FA_MASS_ADDITIONS and FA_MASS_ADDITIONS_S — hold the parent and child mass addition rows, including costs, depreciation attributes, and unit counts; the _S table stores the audit shadow rows.
  • FA_MASSADD_DISTRIBUTIONS and FA_MASSADD_DISTRIBUTIONS_S — store the distribution (accounting) lines associated with each mass addition, ensuring child rows inherit or receive apportioned distributions.
  • FND_CURRENCIES — validates currency codes when determining the currency context of the split.
  • DUAL — used for single-row calculations and default value derivation.

Usage Notes

SPLIT_MASS_ADDITIONS_PKG is invoked from the Fixed Assets mass additions maintenance flow, typically triggered by the Mass Additions form or by the concurrent programs that prepare mass additions for posting. Because the package is classified as OTHER rather than a public API, direct calls from custom code should be avoided; any customization should route splits through the supported mass additions interface. When embedding calls in custom PL/SQL, developers must observe the identical parameter semantics of the parent procedures: supply all parent attribute values and unit counts, and pass a log level record to capture diagnostics. Splitting must be performed before the mass addition is posted to an asset, and UNDO_SPLIT_MASS_ADDITIONS must be used to unwind a split rather than deleting rows manually, so that the audit tables and distributions remain consistent.