Search Results fa_massadd_distributions_s




Overview
Explore in AI Chat

Overview

FA_MASSADD_DIST_PKG is an Oracle EBS Assets (FA) package body owned by the APPS schema. Its purpose is to support the mass addition process by maintaining the distribution information associated with mass addition lines that are destined to become fixed assets. Within Oracle Assets, every capitalized asset requires a distribution set that determines the depreciation expense, cost, and clearing accounts for each distribution line. The mass additions interface (FA_MASSADD_DISTRIBUTIONS) carries pending distributions that arrive from external sources such as Oracle Payables invoice lines, and FA_MASSADD_DIST_PKG provides the programmatic layer that manipulates, defaults, validates, and persists those distributions during the mass addition lifecycle.

The package depends on FA_API_TYPES, FA_DISTRIBUTION_DEFAULTS, FA_DISTRIBUTION_SETS, FA_MASSADD_DISTRIBUTIONS, and FA_MASSADD_DISTRIBUTIONS_S, and it raises errors through APP_EXCEPTION. It is not referenced by any other database object, indicating it is a terminal package invoked directly by Oracle Assets forms, concurrent programs, and seeded workflows rather than by other PL/SQL units.

Key Procedures and Functions

The package exposes three documented procedures:

  • DIST_SET — Establishes or assigns the distribution set associated with a mass addition line. It derives and applies the appropriate distribution set from the distribution defaults and distribution sets repositories so that the mass addition line carries valid, balanced accounting distributions.
  • SAVEPT — Persists (saves) the distribution data for a mass addition line. This procedure writes the assembled distribution rows to the mass addition distribution table and the corresponding _S (sequence-enabled) table, committing the changes for downstream processing.
  • ROLLBK — Rolls back uncommitted distribution work performed on mass additions, restoring the prior state of the distribution records. This is used to guarantee transactional integrity when a save or validation step fails.

Tables Accessed

  • FA_MASSADD_DISTRIBUTIONS — The primary mass addition distribution table; the package reads existing lines and inserts or updates distribution rows.
  • FA_MASSADD_DISTRIBUTIONS_S — The sequence-bearing companion table for mass addition distributions, providing surrogate keys used when rows are created or saved.
  • FA_DISTRIBUTION_DEFAULTS — Supplies default accounting segments used to construct distributions when explicit values are not provided.
  • FA_DISTRIBUTION_SETS — Defines the named distribution sets from which accounting combinations are retrieved for a mass addition line.
  • DUAL — Used for single-row PL/SQL constructs and scalar evaluations.

Usage Notes

FA_MASSADD_DIST_PKG is invoked internally by the Oracle Assets mass additions infrastructure. Typical call sites include the Mass Additions form and related distribution windows, the Prepare Mass Additions and post-mass-addition concurrent programs, and seeded workflow or API actions that create or modify assets from mass addition lines. Because mass addition distributions frequently originate from Oracle Payables invoice distributions, this package is exercised whenever invoice lines feed the asset interface and distributions must be defaulted, validated, saved, or backed out.

Supporting the FA_MASSADD_DISTRIBUTIONS_S table confirms the package participates in the sequence-driven creation of distribution records, so any custom code that inserts mass addition distributions directly should honor the same sequence and validation conventions to avoid orphaning the base distribution rows. The absence of upstream package dependencies means customization should treat FA_MASSADD_DIST_PKG as an implementation detail subject to change across EBS 12.1.1 and 12.2.2, and should prefer documented public APIs such as FA_MASS_ADDITIONS_API or FA_DISTRIBUTION_API where they cover the same business requirement.