Search Results csi_fa_instance_grp




Overview
Explore in AI Chat

Overview

CSI_FA_INSTANCE_GRP is a public PL/SQL group package in the APPS schema that brokers the relationship between Oracle Enterprise Asset Management (eAM) item instances and Oracle Assets (FA) asset records. Its primary business function is to create and maintain the linkage between a physical or logical item instance tracked in the Install Base (CSI) and the corresponding fixed asset row used for depreciation, book, and distribution accounting. The "GRP" classification indicates that the package is a grouping layer: it does not itself implement the underlying transactional logic but composes calls to the CSI item instance private and public APIs, the FA asset interface, and the standard concurrent-request messaging stack (FND_MSG_PUB).

The package is documented as VALID and is part of the 12.1.1 / 12.2.2 code line. It is referenced by one other package but references none of its callers as a dependency, confirming it sits near the top of the CSI–FA integration call stack.

Key Procedures and Functions

  • CREATE_ITEM_INSTANCE — Creates a new item instance record, establishing the instance that will subsequently be associated with asset data. It consolidates the instance creation path and seeding of related attributes.
  • COPY_ITEM_INSTANCE — Duplicates an existing item instance, typically used when a configuration or asset needs to be replicated across multiple instances.
  • ASSOCIATE_ITEM_INSTANCE — Establishes the association between an item instance and the asset-side entities. This is the core linkage routine that ties the CSI instance to its FA counterpart.
  • UPDATE_ASSET_ASSOCIATION — Modifies an existing instance-to-asset association, supporting corrections and re-assignments after initial creation.
  • CREATE_INSTANCE_ASSETS — Creates the asset records derived from an instance, driving the FA-facing side of the integration.

All five procedures are exposed at the package specification level, indicating they are intended for direct invocation by other EBS modules or customer extensions rather than being private helpers.

Tables Accessed

The package operates across three functional areas, and the documented dependency list reflects that breadth:

Calls into CSI_ASSET_PVT, CSI_ITEM_INSTANCE_PUB/PVT/VLD_PVT, CSI_DATASTRUCTURES_PUB, CSI_GEN_UTILITY_PVT, CSI_TRANSACTIONS_PVT, and EAM_MAINT_ATTRIBUTES_PUB provide the API layer through which these tables are actually touched; the package itself relies on those private APIs rather than performing raw DML in most paths.

Usage Notes

CSI_FA_INSTANCE_GRP is invoked in the context of the eAM/Install Base–oracle Assets integration flow. Typical call sites include:

  • Install Base and eAM asset creation workflows, where a new item instance must be materialized and then associated with an asset number.
  • Customer and partner extensions that programmatically create or copy instances and their asset associations, using the documented procedures as the supported entry points.
  • Concurrent programs and forms that call the API layer to keep CSI and FA data synchronized.

Because the package uses FND_API, FND_MESSAGE, and FND_MSG_PUB, callers should follow the standard EBS API conventions: initialize the message stack, check the returned status, and retrieve messages via FND_MSG_PUB rather than interpreting exceptions directly. It is not referenced by any database object, so it is only entered through explicit procedural calls.