Search Results okl_stream_trx_data




Overview
Explore in AI Chat

Overview

The OKL_STREAM_TRX_DATA table is a core data repository within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. Its primary function is to store the XML data payload exchanged between the EBS application and an external pricing engine during financial transaction processing. This table acts as a transactional log and data bridge, ensuring that the detailed, structured input and output from complex pricing calculations—such as those for lease streams, interest rates, or fee assessments—are persistently stored and can be audited or reprocessed if necessary. Its existence is critical for integrations where pricing logic is externalized from the core EBS system.

Key Information Stored

The table's structure is designed to manage the lifecycle of a pricing transaction. The key columns, as indicated by the provided metadata, include the system-generated unique identifier ID (the primary key) and the TRANSACTION_NUMBER, which uniquely identifies the specific pricing request. The core data is held in an XML-type column (implied by the description, though not explicitly named in the excerpt), which contains the complete request sent to or response received from the external engine. Critical foreign key columns are SIF_ID, linking to the OKL_STREAM_INTERFACES table to define the interface configuration used, and SIR_ID, linking to OKL_SIF_RETS, which likely stores high-level status or return information for the transaction.

Common Use Cases and Queries

This table is primarily accessed for integration support, debugging, and audit reporting. A common operational query involves retrieving all transaction data for a specific interface to monitor throughput or diagnose failures. For auditing purposes, one might join to related tables to fetch the full context of a pricing request. A typical diagnostic SQL pattern would be:

  • SELECT std.id, std.transaction_number, sif.interface_name, sir.status_code FROM okl_stream_trx_data std JOIN okl_stream_interfaces sif ON std.sif_id = sif.id JOIN okl_sif_rets sir ON std.sir_id = sir.id WHERE std.transaction_number = '<TXN_NUM>';

Reporting use cases include analyzing the volume of pricing calls over time or investigating discrepancies between EBS data and the XML payload sent for calculation.

Related Objects

The OKL_STREAM_TRX_DATA table is centrally connected to other key integration objects via documented foreign key relationships, forming a critical data model for external pricing.

  • OKL_STREAM_INTERFACES: Linked via the SIF_ID column. This table defines the configuration and parameters for the specific external pricing interface used by the transaction.
  • OKL_SIF_RETS: Linked via the SIR_ID column. This table stores return statuses and summary results for the interface call, providing high-level outcome data that complements the detailed XML in OKL_STREAM_TRX_DATA.

These relationships allow for reconstructing the complete flow of a pricing transaction: from the interface definition, through the detailed XML payload, to the final result status.