Search Results fa_additions_s

Overview

FA_MASSADD_PKG is a core Oracle Assets (Fixed Assets) PL/SQL package body owned by the APPS schema. Its principal business function is to support the mass additions process, the high-volume mechanism by which Oracle EBS loads large batches of asset records sourced from external systems such as Oracle Payables, Oracle Purchasing, or third-party feeder systems. Mass additions are staged in the FA_MASS_ADDITIONS interface table, reviewed and corrected by users, and ultimately converted into production asset rows in FA_ADDITIONS. This package encapsulates the server-side logic that validates, defaults, and posts those staged interface records, including the allocation of parallel worker processes used to distribute the workload across a mass addition run. It is a standard, valid database object in both EBS 12.1.1 and 12.2.2, and it forms part of the internal API surface that the Mass Additions form and associated concurrent programs invoke when preparing, posting, or adjusting mass addition records.

Key Procedures and Functions

DO_MASS_ADDITION — Drives the processing of mass addition records, performing the validation, defaulting, and posting logic required to convert staged interface rows into asset additions. This is the primary entry point for executing a mass addition against a set of records.
DO_MASS_PROPERTY — Handles the mass property processing path, applying asset attribute logic to grouped or bulk records during the mass addition workflow. It complements DO_MASS_ADDITION for the property-oriented processing scenarios in the mass additions lifecycle.
ALLOCATE_WORKERS — Manages the allocation of worker processes for parallel mass addition execution. Large mass additions are partitioned across workers to improve throughput; this routine governs that distribution.

No parameter signatures are documented in the ETRM metadata, and none are asserted here. The procedures are consumed internally by Oracle Assets rather than as a published, standalone API.

Tables Accessed

The package reads and writes a broad set of Fixed Assets tables through APPS synonyms:

FA_MASS_ADDITIONS — the staging/interface table holding mass addition records awaiting processing.
FA_ADDITIONS, FA_ADDITIONS_S, FA_ADDITIONS_TL — the base, sequence/shadow, and translation tables for asset additions. FA_ADDITIONS_S is the sequence-backed table the user searched for, and it is central to insertion and identification of new asset rows.
FA_BOOKS, FA_BOOK_CONTROLS, FA_CATEGORY_BOOK_DEFAULTS, FA_CATEGORIES — supply book and category defaulting and depreciation configuration.
FA_CALENDAR_PERIODS, FA_FISCAL_YEAR — provide period and fiscal year context for posting dates.
FA_DISTRIBUTION_HISTORY, FA_MASSADD_DISTRIBUTIONS — store distribution and allocation detail for mass additions.
FA_MC_MASS_RATES — holds multi-currency mass addition rates.
DUAL and PLITBLM — used for standard SQL evaluation and PL/SQL table storage.

Usage Notes

FA_MASSADD_PKG is not referenced by any other database object, indicating it is invoked directly by Oracle Assets forms and concurrent programs rather than being called by peer packages. Typical invocation occurs from the Mass Additions form (Prepare Mass Additions, Post Mass Additions, and related actions) and from the concurrent programs that orchestrate mass addition posting and parallel processing. Custom code should not call these procedures directly; integrations should instead stage records in FA_MASS_ADDITIONS and use the supported Mass Additions workflow. The package's dependency on FA_ADDITION_PUB, FA_ADJUSTMENT_PUB, FA_CIP_PUB, FA_RECLASS_PUB, FA_UNIT_ADJ_PUB, and FA_UTIL_PVT confirms it delegates asset creation, adjustment, CIP, reclassification, and unit adjustment operations to the sanctioned public APIs.

SEQUENCE: FA.FA_ADDITIONS_S 12.2.2
owner:FA, object_type:SEQUENCE, object_name:FA_ADDITIONS_S, status:VALID,
SYNONYM: APPS.FA_ADDITIONS_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:FA_ADDITIONS_S, status:VALID,
SEQUENCE: FA.FA_ADDITIONS_S 12.1.1
owner:FA, object_type:SEQUENCE, object_name:FA_ADDITIONS_S, status:VALID,
SYNONYM: APPS.FA_ADDITIONS_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:FA_ADDITIONS_S, status:VALID,
TRIGGER: APPS.FA_MASS_ADDITIONS_BRU 12.2.2
owner:APPS, object_type:TRIGGER, object_name:FA_MASS_ADDITIONS_BRU, status:VALID,
12.2.2 DBA Data 12.2.2
TRIGGER: APPS.FA_MASS_ADDITIONS_BRI 12.1.1
owner:APPS, object_type:TRIGGER, object_name:FA_MASS_ADDITIONS_BRI, status:VALID,
TRIGGER: APPS.FA_MASS_ADDITIONS_BRI 12.2.2
owner:APPS, object_type:TRIGGER, object_name:FA_MASS_ADDITIONS_BRI, status:VALID,
TRIGGER: APPS.FA_MASS_ADDITIONS_BRU 12.1.1
owner:APPS, object_type:TRIGGER, object_name:FA_MASS_ADDITIONS_BRU, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.FA_MASSADD_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FA_MASSADD_PKG, status:VALID,
PACKAGE BODY: APPS.FA_ADDITIONS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FA_ADDITIONS_PKG, status:VALID,
PACKAGE BODY: APPS.FA_MASSADD_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FA_MASSADD_PKG, status:VALID,
PACKAGE BODY: APPS.FA_ADDITIONS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FA_ADDITIONS_PKG, status:VALID,
PACKAGE BODY: APPS.FA_ADDITION_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FA_ADDITION_PVT, status:VALID,
PACKAGE BODY: APPS.FA_ADDITION_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FA_ADDITION_PVT, status:VALID,
APPS.FA_MASSADD_PKG dependencies on FA_ADDITIONS_S 12.1.1
APPS.FA_ADDITION_PVT dependencies on FA_ADDITIONS_S 12.1.1
APPS.FA_ADDITIONS_PKG dependencies on FA_ADDITIONS_S 12.2.2
APPS.FA_ADDITIONS_PKG dependencies on FA_ADDITIONS_S 12.1.1
APPS.FA_ADDITION_PVT dependencies on FA_ADDITIONS_S 12.2.2
APPS.FA_MASSADD_PKG dependencies on FA_ADDITIONS_S 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1