Search Results copy_item_instance

Overview

CSI_FA_INSTANCE_GRP is a group-type (GRP) PL/SQL API package in the Oracle E-Business Suite Applications (APPS) schema that bridges Oracle Install Base (CSI) instance records with Oracle Fixed Assets (FA) and Enterprise Asset Management (EAM) data. Its primary business purpose is to create, copy, associate, and synchronize item instance records — the physical or logical instantiations of inventory items tracked in Install Base — while simultaneously maintaining the corresponding fixed asset associations and asset location history. The package is declared with AUTHID CURRENT_USER and exposes a public specification header (csigfais.pls, version 120.5) that defines several strongly typed record and table structures used to pass asset, EAM, and serial/lot attributes between caller and API.

Key Procedures and Functions

• CREATE_ITEM_INSTANCE — The central procedure, and the object most commonly searched for as "create_item_instance." It creates a new item instance in Install Base together with its associated fixed asset linkage, EAM attributes, serial/lot data, and party/party-account relationships. It accepts fixed asset and EAM record structures, an instance record, a serial table, and party/account tables, and returns the created instance and instance-asset tables along with a return status and error message.
• COPY_ITEM_INSTANCE — Duplicates an existing item instance, preserving asset associations and optionally propagating parties, accounts, and contacts based on the copy control flags passed by the caller.
• ASSOCIATE_ITEM_INSTANCE — Establishes the relationship between an existing instance and a fixed asset or EAM context, without creating a new instance.
• UPDATE_ASSET_ASSOCIATION — Modifies the asset-to-instance association, supporting subsequent changes to asset linkage and asset synchronization state.
• CREATE_INSTANCE_ASSETS — Creates the underlying asset records and distribution history entries associated with an instance, serving as the lower-level asset creation primitive used by the other procedures.

Tables Accessed

The package reads and writes across Install Base, Fixed Assets, Receivables/HZ, and inventory tables through APPS synonyms. CSI_ITEM_INSTANCES and CSI_ITEM_INSTANCES_H hold the current and historical instance records, while CSI_I_ASSETS and CSI_I_PARTIES store instance-to-asset and instance-to-party associations. CSI_A_LOCATIONS and HZ_PARTY_SITES provide location and party-site context, and CSI_TRANSACTIONS logs Install Base transaction activity. On the Fixed Assets side, FA_BOOKS and FA_BOOK_CONTROLS validate asset book and depreciation parameters, while FA_DISTRIBUTION_HISTORY captures asset assignment and transfer history. MTL_SYSTEM_ITEMS supplies item definition attributes, and PLITBLM is used for item-related lookup validation.

Usage Notes

CSI_FA_INSTANCE_GRP is an integration-tier API rather than an end-user interface. It is typically invoked from Install Base and Fixed Assets forms and concurrent programs that need to register or synchronize asset-bearing instances, and from custom PL/SQL code performing bulk instance creation or asset reconciliation. Because it is a GRP package, callers conventionally wrap the individual procedure calls inside a single transaction and commit only after checking the returned x_return_status and x_error_message values. Instance creation should be preceded by validation that the target item is asset-trackable and that party, account, and location identifiers are valid. The package is referenced by one other documented package, indicating it functions as a dependency within broader Install Base and asset synchronization flows.