Search Results fa_create_group_asset_pkg




Overview
Explore in AI Chat

Overview

FA_CREATE_GROUP_ASSET_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the creation of group assets in Oracle Assets. A group asset is a parent asset used to consolidate depreciation and reporting for a set of member assets that share common attributes, such as those belonging to the same asset category, book, or location. The package provides the programmatic entry point for building the group asset record and its associated book and distribution relationships during mass additions or other asset-loading processes.

In the ETRM 12.2.2 metadata, the package is classified as an "OTHER" API type, indicating that it is an internal supporting utility rather than a public, documented open interface. It is validated and active in the APPS schema, and it is depended upon by other Oracle Assets packages including FA_AFE_TRANSACTIONS_PKG and FA_MASSADD_PREP_ENERGY_PKG, which rely on it to generate group asset structures as part of their processing flows.

Key Procedures and Functions

The documented package exposes a single public procedure:

  • CREATE_GROUP_ASSET — The procedure responsible for constructing a group asset record. Based on the referenced tables, it derives the necessary asset identifiers, book associations, category and category-book mappings, distribution history, and keyword information, then inserts the group asset into the appropriate Oracle Assets tables. It is the central routine that other packages call when a group asset must be materialized in the asset repository.

Because the ETRM metadata lists only this procedure, no parameter lists are documented or should be assumed. Any invocation must be validated against the deployed package specification in the target environment.

Tables Accessed

The package reads and writes a set of core Oracle Assets tables and supporting lookup tables:

Usage Notes

FA_CREATE_GROUP_ASSET_PKG is not intended for direct invocation by end users. It is typically called from within other Oracle Assets packages, notably FA_AFE_TRANSACTIONS_PKG, FA_MASSADD_PREP_ENERGY_PKG, and recursively from within itself. In practice, it is exercised during mass addition preparation and AFE transaction processing, where group assets must be generated programmatically rather than entered manually through the Assets form.

Custom code should treat this package as an internal dependency. Any direct call must respect the current depreciation period, the open book state, and the asset category setup. Because it is classified as an "OTHER" API, Oracle does not guarantee upward compatibility in the same manner as registered open interfaces, so customizations should be validated carefully across 12.1.1 and 12.2.2 environments before deployment.