Search Results csi_i_org_assignments_h




Overview
Explore in AI Chat

Overview

The table CSI_I_ORG_ASSIGNMENTS_H is a critical history table within the Oracle E-Business Suite (EBS) Install Base (CSI) module. It serves as the official audit trail for changes to the organizational assignments of tracked assets, known as instances. Every time an instance's association with an operating unit (organization) is created, updated, or ended, a historical record is inserted into this table. This provides a complete, immutable timeline of an asset's organizational ownership and usage context, which is essential for compliance, audit reporting, and analyzing asset lifecycle movements across business units in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to capture the state of an organization assignment at a specific point in time. Its key columns include the surrogate primary key INSTANCE_OU_HISTORY_ID. The INSTANCE_OU_ID is a foreign key linking back to the current assignment record in the CSI_I_ORG_ASSIGNMENTS table, grouping all historical entries for that specific assignment. The TRANSACTION_ID foreign key links to the CSI_TRANSACTIONS table, providing the exact business event (e.g., move, update, termination) that triggered the historical snapshot. Other crucial columns typically found in such history tables include START_DATE_ACTIVE and END_DATE_ACTIVE, which define the period the recorded assignment was valid, along with CREATION_DATE and CREATED_BY for audit purposes.

Common Use Cases and Queries

This table is primarily used for historical reporting and audit inquiries. A common use case is generating a report of all organizational changes for a specific asset instance over a fiscal period for compliance audits. Another scenario involves diagnosing data issues by reconstructing the sequence of assignment changes. A typical analytical query would join this history table to the instance and transaction details.

SELECT csi.instance_number,
       h.start_date_active,
       h.end_date_active,
       hou.name operating_unit,
       ct.transaction_date,
       ct.transaction_type_code
  FROM csi_i_org_assignments_h h,
       csi_i_org_assignments oa,
       csi_item_instances csi,
       csi_transactions ct,
       hr_operating_units hou
 WHERE h.instance_ou_id = oa.instance_ou_id
   AND oa.instance_id = csi.instance_id
   AND h.transaction_id = ct.transaction_id
   AND oa.organization_id = hou.organization_id
   AND csi.instance_number = 'ASSET-12345'
 ORDER BY h.start_date_active;

Related Objects

CSI_I_ORG_ASSIGNMENTS_H is centrally connected to other core Install Base tables through documented foreign key relationships. It has a direct, mandatory relationship with the CSI_I_ORG_ASSIGNMENTS table via the INSTANCE_OU_ID column. This links each historical row to its master assignment record. Furthermore, it references the CSI_TRANSACTIONS table via the TRANSACTION_ID column, tying each historical snapshot to the specific business transaction that caused it. These relationships are fundamental for constructing accurate historical reports that include both the assignment details and the context of the change.

  • CSI_I_ORG_ASSIGNMENTS: Linked via foreign key CSI_I_ORG_ASSIGNMENTS_H.INSTANCE_OU_ID.
  • CSI_TRANSACTIONS: Linked via foreign key CSI_I_ORG_ASSIGNMENTS_H.TRANSACTION_ID.