Search Results csi_iea_values_h




Overview
Explore in AI Chat

Overview

The CSI_IEA_VALUES_H table is a core data object within the Oracle E-Business Suite (EBS) Install Base (CSI) module. It functions as a historical audit trail for changes made to extended attribute values assigned to asset instances. In Oracle Install Base, an instance represents a tangible or intangible asset, such as a piece of equipment or a software license. Extended attributes provide a flexible method to capture instance-specific details beyond standard fields. This table records the previous state of an attribute value each time it is updated via a transaction, ensuring a complete audit history for compliance, troubleshooting, and tracking the evolution of an asset's characteristics over its lifecycle.

Key Information Stored

The table's structure is designed to link a historical value snapshot to the specific transaction that caused the change. The primary key, ATTRIBUTE_VALUE_HISTORY_ID, uniquely identifies each historical record. Two critical foreign keys define its relationships: ATTRIBUTE_VALUE_ID references the CSI_IEA_VALUES table to identify the specific extended attribute whose value changed, and TRANSACTION_ID references the CSI_TRANSACTIONS table to pinpoint the exact business event (e.g., update, move, split) that triggered the historical snapshot. While the full column list is not detailed in the provided metadata, a typical history table in this context would store the attribute's previous value, the date of the change, and potentially the prior context or classification at the time of the transaction.

Common Use Cases and Queries

This table is primarily used for audit reporting and historical analysis. Common scenarios include generating reports to show all changes made to a specific instance's attributes, tracing the value history of a particular serialized asset, or complying with regulatory audits that require a full change history. A typical query pattern involves joining CSI_IEA_VALUES_H with CSI_IEA_VALUES for attribute details and CSI_TRANSACTIONS for transaction context.

  • Sample Query Pattern: To retrieve the change history for a specific instance's attributes, a query would join from CSI_INSTANCES through CSI_IEA_VALUES to CSI_IEA_VALUES_H and CSI_TRANSACTIONS.
  • Reporting Use Case: Creating an audit report that lists every modification to extended attributes for assets under warranty, showing the old value, new value, date, and the user responsible (via transaction data).

Related Objects

The metadata explicitly defines this table's dependencies within the Install Base schema. Its primary relationships are as follows:

  • CSI_IEA_VALUES: This is the current values table. CSI_IEA_VALUES_H.ATTRIBUTE_VALUE_ID is a foreign key to CSI_IEA_VALUES, linking each historical record to its source attribute definition and current value row.
  • CSI_TRANSACTIONS: This is the master transactions table. CSI_IEA_VALUES_H.TRANSACTION_ID is a foreign key to CSI_TRANSACTIONS, connecting the value change to the overarching business event that caused it.
  • CSI_INSTANCES: While not a direct foreign key in the provided metadata, CSI_IEA_VALUES is linked to CSI_INSTANCES. Therefore, historical attribute data is indirectly related to the asset instance itself through this chain of relationships.