Search Results csi_ib_txn_types

Overview

The table CSI_IB_TXN_TYPES is a core reference table within the Oracle E-Business Suite (EBS) Install Base (CSI) module. It serves as a master repository for defining and classifying the various transaction types that can be performed on installed product instances. Every activity that alters the state, location, or attributes of an installed asset—such as installations, moves, upgrades, or disposals—is governed by a transaction type defined in this table. Its primary role is to enforce business rules, control workflow, and ensure data integrity by providing a standardized set of valid operations for the Installed Base transactional engine. The table is central to the processing logic of the CSI_ITEM_INSTANCES table, which stores the actual asset records.

Key Information Stored

The table's structure is designed to categorize and control transaction processing. While the full column list is not detailed in the provided excerpt, based on its function and primary key, the critical data elements typically include:

• SUB_TYPE_ID: The primary key column, uniquely identifying each transaction type definition.
• TRANSACTION_TYPE_ID: A likely foreign key to a parent transaction category table (e.g., CSI_TXN_TYPES).
• NAME and DESCRIPTION: Human-readable identifiers for the transaction sub-type, such as "Install," "Move," or "Terminate."
• FLAG_COLUMNS: A series of indicator columns (often named as flags) that define the transaction's behavior. These control whether the transaction affects instance status, location, ownership, or counters, and whether it is an internal or customer-facing action.
• SECURITY and VALIDATION attributes: Columns that may govern which responsibilities can use the type or what pre-validation is required.

Common Use Cases and Queries

This table is primarily referenced for validation, reporting, and setup purposes. A common use case is during the creation of a transaction via the Install Base public APIs or forms, where the provided transaction type code is validated against active records in CSI_IB_TXN_TYPES. For reporting, it is joined to transactional history to categorize events. Key query patterns include fetching all valid transaction types for a given parent category or checking the properties of a specific type to understand its business impact.

-- Sample: Retrieve active transaction sub-types for installations
SELECT sub_type_id, name, description
FROM csi_ib_txn_types
WHERE transaction_type_id = (SELECT transaction_type_id
                             FROM csi_txn_types
                             WHERE name = 'INSTALLATION')
  AND sysdate BETWEEN start_date_active AND NVL(end_date_active, sysdate)
ORDER BY name;

Related Objects

CSI_IB_TXN_TYPES is a central node in the Install Base schema. Its primary key, SUB_TYPE_ID, is a fundamental foreign key in transactional and interface tables. Key related objects include:

• CSI_ITEM_INSTANCES: The main instances table; transaction types govern the updates applied to records in this table.
• CSI_TXN_TYPES: The parent table holding broader transaction categories, to which CSI_IB_TXN_TYPES likely relates via a TRANSACTION_TYPE_ID foreign key.
• CSI_I_TXN_INTERFACE and CSI_T_TRANSACTIONS: Transaction interface and base tables that would store the SUB_TYPE_ID for each processed or pending transaction.
• Public APIs (CSI_TRANSACTION_PUB): These APIs accept transaction type parameters that are validated against this table.