Search Results csi_t_txn_line_details

Overview

The CSI_T_TXN_LINE_DETAILS table is a core transactional entity within the Oracle E-Business Suite Install Base (CSI) module. It functions as a detailed staging and working table for granular changes to tracked assets (item instances) during business transactions. Its primary role is to capture and hold the specific attribute-level modifications proposed for an asset instance—such as changes to its status, location, or ownership—before these changes are finalized and posted to the master Install Base tables. This table is integral to the transaction processing engine, enabling complex updates, splits, merges, and transfers of serialized assets while maintaining data integrity and auditability throughout the transaction lifecycle.

Key Information Stored

The table's structure is defined by its relationships, as indicated by its foreign keys. The primary key is the TXN_LINE_DETAIL_ID, a unique identifier for each proposed change record. Critical foreign key columns define the context of the change: TRANSACTION_LINE_ID links to the parent transaction line in CSI_T_TRANSACTION_LINES, while INSTANCE_ID and CHANGED_INSTANCE_ID reference the source and resulting (changed) item instances in CSI_ITEM_INSTANCES. The CSI_SYSTEM_ID and TRANSACTION_SYSTEM_ID columns associate the detail with the master and transactional system structures, respectively. In essence, each row stores a discrete unit of change targeting a specific attribute of a specific asset instance within a larger business transaction.

Common Use Cases and Queries

This table is central to processes like asset updates, returns, and configuration changes initiated from Order Management, Depot Repair, or Service modules. A common reporting use case involves analyzing pending changes for a specific asset or transaction. For example, to review all proposed details for a transaction line, one might query:

• SELECT * FROM csi_t_txn_line_details WHERE transaction_line_id = <line_id> ORDER BY txn_line_detail_id;

For troubleshooting, queries often join to CSI_ITEM_INSTANCES to see the current and proposed asset states:

• SELECT det.txn_line_detail_id, inst.instance_number, det.instance_id FROM csi_t_txn_line_details det, csi_item_instances inst WHERE det.instance_id = inst.instance_id AND det.transaction_line_id = <line_id>;

Data in this table is typically created and processed by the Install Base transaction engine and is not meant for direct DML in standard operations.

Related Objects

CSI_T_TXN_LINE_DETAILS is a nexus within the Install Base transaction schema. It has a direct parent relationship with CSI_T_TRANSACTION_LINES. Its most critical relationships are with the master asset table, CSI_ITEM_INSTANCES, via the INSTANCE_ID and CHANGED_INSTANCE_ID columns. It also links to system structures through CSI_SYSTEMS_B and CSI_T_TXN_SYSTEMS. Furthermore, it serves as a key source for several other transactional detail tables, including CSI_T_EXTEND_ATTRIBS (for extended attributes), CSI_T_II_RELATIONSHIPS (for proposed asset relationships), CSI_T_ORG_ASSIGNMENTS (for organization assignments), and CSI_T_PARTY_DETAILS (for party/customer assignments). An integration point with the XDP (Service Fulfillment Manager) module is also documented via the XDP_ORDER_LINE_ITEMS table.