Search Results psa_fa_mass_additions




Overview
Explore in AI Chat

Overview

The APPS.PSA_FA_MASS_ADDITIONS package is a PL/SQL database object residing in the APPS schema of Oracle E-Business Suite. It is categorized under the ETRM classification OTHER and holds a VALID status in both Release 12.1.1 and 12.2.2. Functionally, the package belongs to the Public Sector Applications (PSA) product family and supports the Fixed Assets mass additions process. Mass additions in Oracle Assets represent the mechanism by which capitalizable transactions originating in external source systems — typically Payables, Purchasing, Projects, or feeder systems — are loaded into Oracle Assets and converted into fixed asset records. This package provides supporting logic for that process, including asset type validation and the printing of mass addition report content. Its dependency graph is deliberately narrow: at the database level it depends only on the SYS STANDARD package, and the ETRM metadata records no downstream packages referencing it, confirming that it is a leaf-level utility rather than a shared framework component.

Key Procedures and Functions

The ETRM documentation identifies four documented procedures or functions within this package:

  • UPDATE_ASSET_TYPE — Derives or applies the asset type classification associated with a mass addition line, ensuring that the record carries a valid asset type before it becomes a fixed asset.
  • PRINT_HEADER_INFO — Produces the header-level information section of the mass additions report output.
  • PRINT_MASS_ADDITION_DETAILS — Produces the detailed line-level section of the mass additions report, presenting individual mass addition records.
  • PRINT_REPORT_HEADER — Generates the report title and top-of-page formatting for the mass additions report output.

The presence of three report-printing routines alongside a single data-manipulation routine indicates that the package is oriented primarily toward rendering the mass additions report rather than performing bulk processing. No parameter signatures are published in the documented metadata, so invocation details should be confirmed against the deployed package specification in the target instance.

Tables Accessed

The only documented table referenced by this package is FA_MASS_ADDITIONS, accessed through an APPS synonym. This is the core Oracle Assets interface table that holds pre-asset capitalizable transactions awaiting conversion into fixed assets. The package reads from this table to populate the report output produced by the PRINT_* routines, and it interacts with the same table when executing UPDATE_ASSET_TYPE. No other application tables are documented in the dependency metadata.

Usage Notes

This package is typically invoked indirectly: Oracle Assets provides the standard Mass Additions Create and Mass Additions Post concurrent programs, and reporting on mass additions is driven through the standard Assets reports that call packages of this type. Custom code should not depend on this package as a public API, since it is classified as OTHER rather than as a supported open interface. Customers extending or troubleshooting the mass additions report may reference it, but any direct call must be validated in the specific environment, as the package specification defines which of the four routines are publicly exposed. Because no packages reference it, changes to its internals carry limited blast radius, but care is still warranted given the sensitivity of the FA_MASS_ADDITIONS interface data.