Search Results csi_t_transaction_lines

Overview

The CSI_T_TRANSACTION_LINES table is a core transaction staging table within the Oracle E-Business Suite Install Base (CSI) module. It serves as the primary repository for detailed line-level information for transactions that are in the process of being applied to the Install Base. This table is integral to the transactional engine of CSI, holding data for activities such as item installations, updates, transfers, and terminations before these operations are fully posted and reflected in the master Install Base tables. Its role is to ensure data integrity and manage the workflow of asset transactions within the EBS ecosystem.

Key Information Stored

The table's primary key, TRANSACTION_LINE_ID, uniquely identifies each transaction line record. While the full column list is not detailed in the provided metadata, based on its function, the table typically stores critical attributes for each transaction line. These include references to the parent transaction header (TRANSACTION_ID), the inventory item involved (INVENTORY_ITEM_ID, SERIAL_NUMBER), the transaction quantity, the source and destination parties and locations, and the transaction type and status. The data in this table represents the granular, actionable details of any change being made to an installed asset's record.

Common Use Cases and Queries

A primary use case is troubleshooting pending or failed Install Base transactions. Administrators query this table to examine transaction details that have not yet been processed or have encountered errors. Common reporting involves joining with CSI_T_TRANSACTION_HEADERS to get a complete view of a transaction. A sample query pattern to find pending transaction lines for a specific item would be:

• SELECT tl.transaction_line_id, tl.inventory_item_id, tl.serial_number, th.transaction_date
• FROM csi_t_transaction_lines tl, csi_t_transaction_headers th
• WHERE tl.transaction_id = th.transaction_id
• AND th.transaction_status_code = 'PENDING'
• AND tl.inventory_item_id = <item_id>;

This table is also central to custom integrations that feed asset transaction data into the Install Base module, as it is the target for the initial insertion of transactional data via the CSI Transaction Interface.

Related Objects

As indicated by the foreign key relationships in the metadata, CSI_T_TRANSACTION_LINES is a central hub for transactional detail. The CSI_T_II_RELATIONSHIPS table references it, linking transaction lines to the creation or update of relationships between installed items. The CSI_T_TXN_LINE_DETAILS table holds additional, extended attributes for each transaction line, forming a child relationship. Crucially, this staging table feeds the permanent Install Base transaction tables (e.g., CSI_TRANSACTION_LINES) upon successful processing. It is also heavily referenced by the core Install Base transaction processing APIs and the CSI Transaction Interface public APIs.