Search Results csi_i_assets




Overview
Explore in AI Chat

Overview

The table CSI_I_ASSETS is a core data object within the Oracle E-Business Suite Install Base (CSI) module. It serves as the central repository for managing the association between an installed product instance and a fixed asset. This table enables the critical financial and operational linkage between the physical or logical items tracked in Install Base (CSI_ITEM_INSTANCES) and the capitalized assets managed in Oracle Fixed Assets (FA). By maintaining this relationship, organizations can reconcile their operational equipment registers with their formal accounting records, ensuring asset valuation, depreciation, and tracking are synchronized across the enterprise.

Key Information Stored

The table's primary purpose is to establish and describe the instance-to-asset relationship. Its structure is defined by key foreign key columns that link to master data in other modules. The primary identifier for each association record is the INSTANCE_ASSET_ID. The fundamental links are stored in INSTANCE_ID (references CSI_ITEM_INSTANCES) and FA_ASSET_ID (references FA_ADDITIONS_B). To provide granular asset accounting context, the table also includes FA_BOOK_TYPE_CODE (references FA_BOOK_CONTROLS) to specify the asset book and FA_LOCATION_ID (references FA_LOCATIONS) to denote the financial asset location. This design allows a single installed item instance to be associated with specific asset details within a particular accounting book.

Common Use Cases and Queries

The primary use case is reporting and auditing the alignment between operational installations and the fixed asset ledger. Financial analysts use this data to verify that all capitalized assets have corresponding installed items for maintenance tracking, and operations managers can identify the financial book and asset ID for their critical equipment. A common query retrieves all asset associations for a given instance, including asset details:

  • SELECT cia.instance_asset_id, cii.instance_number, fa.asset_number, fa.description, cia.fa_book_type_code FROM csi_i_assets cia, csi_item_instances cii, fa_additions_b fa WHERE cia.instance_id = cii.instance_id AND cia.fa_asset_id = fa.asset_id AND cii.instance_id = :p_instance_id;

Conversely, queries often start from the asset side to find linked instance data for audit trails or to populate custom integrated reports that combine financial and operational attributes.

Related Objects

CSI_I_ASSETS is a central hub with defined relationships to several key tables. It is the parent table for the history table CSI_I_ASSETS_H, which tracks changes to these associations over time. Its foreign key dependencies are critical: CSI_ITEM_INSTANCES is the source of the installed item, FA_ADDITIONS_B is the source of the fixed asset, FA_BOOK_CONTROLS provides the asset book context, and FA_LOCATIONS provides the financial location. These relationships ensure referential integrity and enable the seamless flow of data between the Install Base and Fixed Assets modules.