Search Results csi_i_assets_h




Overview
Explore in AI Chat

Overview

The table CSI_I_ASSETS_H is a core historical data repository within the Oracle E-Business Suite Install Base (CSI) module. It is designed to track the complete history of associations between Install Base instances (physical or logical assets tracked by the system) and financial assets (from the FA module). This table plays a critical role in maintaining a precise audit trail, enabling users to understand when and why an instance was linked to or de-linked from a specific capital asset over its lifecycle. Its existence is fundamental for accurate reporting, audit compliance, and troubleshooting the financial tracking of installed items.

Key Information Stored

The table's structure is centered on capturing the lifecycle of each instance-asset relationship. The primary key, INSTANCE_ASSET_HISTORY_ID, uniquely identifies each historical record. Two critical foreign keys define the relationship's scope: INSTANCE_ASSET_ID references the current or originating association in CSI_I_ASSETS, and TRANSACTION_ID references the specific Install Base transaction in CSI_TRANSACTIONS that caused the change. While the provided metadata does not list all columns, typical data stored includes timestamps for the change, the type of historical event (e.g., association creation, update, or end-dating), and identifiers for the associated instance and financial asset at the time of the transaction.

Common Use Cases and Queries

This table is primarily used for historical analysis and audit reporting. A common scenario involves tracing the full lineage of financial asset associations for a given Install Base instance, which is essential for support and depreciation reconciliation. Another key use case is generating reports to satisfy audit requirements, showing all changes to asset assignments within a specific period. A typical query pattern would join CSI_I_ASSETS_H to CSI_ITEM_INSTANCES and FA_ADDITIONS to produce a readable history report.

  • Sample Query Pattern: SELECT ciah.instance_asset_history_id, cii.instance_number, fa.asset_number, ciah.creation_date FROM csi_i_assets_h ciah, csi_item_instances cii, fa_additions fa WHERE ciah.instance_id = cii.instance_id AND ciah.asset_id = fa.asset_id AND cii.instance_number = :p_instance_num ORDER BY ciah.creation_date DESC;

Related Objects

As defined by its foreign keys, CSI_I_ASSETS_H has direct, integral dependencies on two primary Install Base tables. The table CSI_I_ASSETS holds the current active association between an instance and an asset, for which this table stores all historical versions. The table CSI_TRANSACTIONS provides the transactional context (e.g., "Move," "Link Asset," "Update") that generated each historical record. This table is also inherently related to CSI_ITEM_INSTANCES (the instances themselves) and tables in the Fixed Assets module, such as FA_ADDITIONS, though these relationships are typically established via the instance and asset IDs stored within the history records.