Search Results csi_txn_types

Overview

The CSI_TXN_TYPES table is a core reference table within the Oracle E-Business Suite Install Base (CSI) module. It functions as the master list of all valid source transaction types that can create or update asset records in the Installed Base repository. Every transaction processed through the CSI Transaction Interface must reference a defined type from this table. Its primary role is to enforce data integrity and provide a controlled classification system for the diverse business events—such as sales orders, service requests, or internal transfers—that drive changes to the installed product base. This table is essential for the transactional foundation of asset lifecycle management.

Key Information Stored

The table's structure is designed to uniquely identify and describe each transaction type. The primary key, TRANSACTION_TYPE_ID, is a unique numeric identifier. Critical descriptive columns include TRANSACTION_TYPE_NAME and DESCRIPTION. A pivotal column is SOURCE_APPLICATION_ID, a foreign key to FND_APPLICATION, which identifies the originating EBS module (e.g., Order Management, Service, Inventory) for the transaction type. Other columns typically manage status (e.g., ACTIVE_FLAG), control flags for processing behavior, and standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY) for auditing.

Common Use Cases and Queries

This table is central to setup, validation, and reporting. Implementers use it to review and configure available transaction types during implementation. A common diagnostic query involves joining with FND_APPLICATION to list all active transaction types and their source modules:

• SELECT txn.transaction_type_name, txn.description, app.application_name FROM csi_txn_types txn, fnd_application app WHERE txn.source_application_id = app.application_id AND txn.active_flag = 'Y' ORDER BY app.application_name;

When troubleshooting interface errors, support personnel query this table to verify a referenced TRANSACTION_TYPE_ID is valid and active. Reporting on transaction volumes by type also requires this table as a dimension. Furthermore, custom integrations must use transaction types defined here to ensure proper processing by the Install Base engine.

Related Objects

CSI_TXN_TYPES has defined relationships with several key objects. It is referenced by a foreign key constraint from the CSI_TRANSACTIONS table (CSI_TRANSACTIONS.TRANSACTION_TYPE_ID), which is the primary transactional interface table. It also holds a foreign key constraint to FND_APPLICATION via its SOURCE_APPLICATION_ID column, linking the transaction type to its originating application. The table is integral to the CSI Transaction Interface public APIs and is often accessed via the CSI_TXN_TYPES_PKG package for programmatic operations. Its definitions drive the behavior of the Install Base transaction processor.