Search Results apps_ts_nologging




Overview
Explore in AI Chat

Overview

The OKL_STREAM_TRX_DATA table is a core transactional data store within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a staging and logging repository for XML data exchanged with an external pricing engine during the processing of financial streams. Its primary role is to temporarily hold outbound XML requests sent to the pricing engine and the corresponding inbound XML responses received. The table is designed for transient data; once a transaction is complete, the associated data is purged. It is stored in the APPS_TS_NOLOGGING tablespace, indicating its operational nature where data recovery via redo logs is typically not required, prioritizing performance for high-volume, temporary data operations.

Key Information Stored

The table's structure is centered on managing the lifecycle of a pricing transaction. The ID column serves as the primary key. Critical transactional identifiers include TRANSACTION_NUMBER (a unique identifier for the transaction) and foreign key columns SIF_ID and SIR_ID, which link to the stream interface headers and returns, respectively. The core data payload is stored in Large Object (LOB) columns: OUT_XML (CLOB) for the data sent to the pricing engine, and IN_XML (CLOB) for the response received. Status tracking is facilitated through the STATUS and TRANSACTION_STATE columns. Additional context is provided by columns like KHR_ID (contract header ID), ORIG_KHR_ID, and user-entered COMMENTS.

Common Use Cases and Queries

This table is primarily accessed for debugging, auditing, and monitoring the integration with the external pricing engine. Common operational queries include investigating pending or failed transactions, reviewing the raw XML exchanged for specific contracts, or purging completed transactions. A typical query to examine active transactions for a specific contract would join to the interface headers table.

  • Sample Query: Find transactions for a specific contract (KHR_ID):
    SELECT std.TRANSACTION_NUMBER, std.STATUS, std.OUT_XML, std.IN_XML
    FROM OKL.OKL_STREAM_TRX_DATA std
    WHERE std.KHR_ID = <contract_id>
    ORDER BY std.ID DESC;
  • Sample Query: Monitor pending transactions:
    SELECT COUNT(*), STATUS
    FROM OKL.OKL_STREAM_TRX_DATA
    GROUP BY STATUS;

Related Objects

OKL_STREAM_TRX_DATA is integral to the OKL module's pricing integration framework. Its documented foreign key relationships establish clear data lineage.

  • OKL_STREAM_INTERFACES: The SIF_ID column in OKL_STREAM_TRX_DATA is a foreign key referencing this table, linking the transactional XML data to its originating stream interface header.
  • OKL_SIF_RETS: The SIR_ID column is a foreign key referencing this table, connecting the transaction data to the corresponding stream interface return records.

These relationships allow for comprehensive analysis by joining transactional XML data with its source interface metadata and processed return information.

  • TABLE: OKL.OKL_STREAM_TRX_DATA 12.2.2

    owner:OKL,  object_type:TABLE,  fnd_design_data:OKL.OKL_STREAM_TRX_DATA,  object_name:OKL_STREAM_TRX_DATA,  status:VALID, 

  • TABLE: GMS.GMS_BC_PACKETS_SUMMARY 12.1.1

    owner:GMS,  object_type:TABLE,  fnd_design_data:GMS.GMS_BC_PACKETS_SUMMARY,  object_name:GMS_BC_PACKETS_SUMMARY,  status:VALID, 

  • TABLE: OKL.OKL_STREAM_TRX_DATA 12.1.1

    owner:OKL,  object_type:TABLE,  fnd_design_data:OKL.OKL_STREAM_TRX_DATA,  object_name:OKL_STREAM_TRX_DATA,  status:VALID, 

  • TABLE: GMS.GMS_BC_PACKETS_SUMMARY 12.2.2

    owner:GMS,  object_type:TABLE,  fnd_design_data:GMS.GMS_BC_PACKETS_SUMMARY,  object_name:GMS_BC_PACKETS_SUMMARY,  status:VALID, 

  • TABLE: OKL.OKL_SIF_STREAM_TYPES 12.1.1

    owner:OKL,  object_type:TABLE,  fnd_design_data:OKL.OKL_SIF_STREAM_TYPES,  object_name:OKL_SIF_STREAM_TYPES,  status:VALID, 

  • TABLE: HR.PAY_MONITOR_BALANCE_RETRIEVALS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_MONITOR_BALANCE_RETRIEVALS,  object_name:PAY_MONITOR_BALANCE_RETRIEVALS,  status:VALID, 

  • TABLE: OKL.OKL_SIF_TRX_PARMS 12.2.2

    owner:OKL,  object_type:TABLE,  fnd_design_data:OKL.OKL_SIF_TRX_PARMS,  object_name:OKL_SIF_TRX_PARMS,  status:VALID, 

  • TABLE: HR.PAY_MONITOR_BALANCE_RETRIEVALS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_MONITOR_BALANCE_RETRIEVALS,  object_name:PAY_MONITOR_BALANCE_RETRIEVALS,  status:VALID, 

  • TABLE: OKL.OKL_SIF_STREAM_TYPES 12.2.2

    owner:OKL,  object_type:TABLE,  fnd_design_data:OKL.OKL_SIF_STREAM_TYPES,  object_name:OKL_SIF_STREAM_TYPES,  status:VALID, 

  • TABLE: INV.MTL_CATALOG_SEARCH_ITEMS 12.1.1

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_CATALOG_SEARCH_ITEMS,  object_name:MTL_CATALOG_SEARCH_ITEMS,  status:VALID, 

  • TABLE: OKL.OKL_SIF_TRX_PARMS 12.1.1

    owner:OKL,  object_type:TABLE,  fnd_design_data:OKL.OKL_SIF_TRX_PARMS,  object_name:OKL_SIF_TRX_PARMS,  status:VALID, 

  • TABLE: IGS.IGS_EN_MERGE_ID_LOG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_MERGE_ID_LOG,  object_name:IGS_EN_MERGE_ID_LOG,  status:VALID, 

  • TABLE: CSI.CSI_XNP_MSGS_TEMP 12.2.2

    owner:CSI,  object_type:TABLE,  fnd_design_data:CSI.CSI_XNP_MSGS_TEMP,  object_name:CSI_XNP_MSGS_TEMP,  status:VALID, 

  • TABLE: INV.MTL_CATALOG_SEARCH_ITEMS 12.2.2

    owner:INV,  object_type:TABLE,  fnd_design_data:INV.MTL_CATALOG_SEARCH_ITEMS,  object_name:MTL_CATALOG_SEARCH_ITEMS,  status:VALID, 

  • TABLE: APPLSYS.FND_CONCURRENT_DEBUG_INFO 12.1.1

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.FND_CONCURRENT_DEBUG_INFO,  object_name:FND_CONCURRENT_DEBUG_INFO,  status:VALID, 

  • TABLE: HR.PQH_SS_PRINT_LABEL_TEMP 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PQH.PQH_SS_PRINT_LABEL_TEMP,  object_name:PQH_SS_PRINT_LABEL_TEMP,  status:VALID, 

  • TABLE: IMC.IMC_REPORTS_TEMPINFO 12.2.2

    owner:IMC,  object_type:TABLE,  object_name:IMC_REPORTS_TEMPINFO,  status:VALID, 

  • TABLE: APPLSYS.FND_CONCURRENT_DEBUG_INFO 12.2.2

    owner:APPLSYS,  object_type:TABLE,  fnd_design_data:FND.FND_CONCURRENT_DEBUG_INFO,  object_name:FND_CONCURRENT_DEBUG_INFO,  status:VALID, 

  • TABLE: IMC.IMC_REPORTS_TEMPINFO 12.1.1

    owner:IMC,  object_type:TABLE,  object_name:IMC_REPORTS_TEMPINFO,  status:VALID, 

  • TABLE: DPP.DPP_LOG_MESSAGES 12.1.1

    owner:DPP,  object_type:TABLE,  fnd_design_data:DPP.DPP_LOG_MESSAGES,  object_name:DPP_LOG_MESSAGES,  status:VALID, 

  • TABLE: DPP.DPP_LOG_MESSAGES 12.2.2

    owner:DPP,  object_type:TABLE,  fnd_design_data:DPP.DPP_LOG_MESSAGES,  object_name:DPP_LOG_MESSAGES,  status:VALID, 

  • TABLE: ONT.ONT_PRICE_ADJ_TEMP_ONT 12.2.2

    owner:ONT,  object_type:TABLE,  object_name:ONT_PRICE_ADJ_TEMP_ONT,  status:VALID, 

  • TABLE: GR.GR_WORK_BUILD_DOCS 12.1.1

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_BUILD_DOCS,  object_name:GR_WORK_BUILD_DOCS,  status:VALID, 

  • TABLE: HR.PAY_TEMP_BALANCE_ADJUSTMENTS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_TEMP_BALANCE_ADJUSTMENTS,  object_name:PAY_TEMP_BALANCE_ADJUSTMENTS,  status:VALID, 

  • TABLE: GR.GR_WORK_BUILD_DOCS 12.2.2

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_BUILD_DOCS,  object_name:GR_WORK_BUILD_DOCS,  status:VALID, 

  • TABLE: HR.PQH_SS_PRINT_LABEL_TEMP 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PQH.PQH_SS_PRINT_LABEL_TEMP,  object_name:PQH_SS_PRINT_LABEL_TEMP,  status:VALID, 

  • TABLE: GR.GR_WORK_INGRED_CONCS 12.1.1

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_INGRED_CONCS,  object_name:GR_WORK_INGRED_CONCS,  status:VALID, 

  • TABLE: GR.GR_WORK_ADDITIVE_RISKS 12.2.2

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_ADDITIVE_RISKS,  object_name:GR_WORK_ADDITIVE_RISKS,  status:VALID, 

  • TABLE: GMS.GMS_BC_PACKETS_BVID 12.2.2

    owner:GMS,  object_type:TABLE,  fnd_design_data:GMS.GMS_BC_PACKETS_BVID,  object_name:GMS_BC_PACKETS_BVID,  status:VALID, 

  • TABLE: ONT.ONT_PRICE_ADJ_TEMP_ONT 12.1.1

    owner:ONT,  object_type:TABLE,  object_name:ONT_PRICE_ADJ_TEMP_ONT,  status:VALID, 

  • TABLE: BOM.CST_LISTS 12.2.2

    owner:BOM,  object_type:TABLE,  fnd_design_data:BOM.CST_LISTS,  object_name:CST_LISTS,  status:VALID, 

  • TABLE: BOM.CST_VALUE_REPORT_TEMP 12.2.2

    owner:BOM,  object_type:TABLE,  fnd_design_data:BOM.CST_VALUE_REPORT_TEMP,  object_name:CST_VALUE_REPORT_TEMP,  status:VALID, 

  • TABLE: IEC.IEC_O_TRANSITION_PHONES 12.2.2

    owner:IEC,  object_type:TABLE,  object_name:IEC_O_TRANSITION_PHONES,  status:VALID, 

  • TABLE: EAM.EAM_ASSET_EXPLOSION_TEMP 12.2.2

    owner:EAM,  object_type:TABLE,  fnd_design_data:EAM.EAM_ASSET_EXPLOSION_TEMP,  object_name:EAM_ASSET_EXPLOSION_TEMP,  status:VALID, 

  • TABLE: GR.GR_WORK_ADDITIVE_RISKS 12.1.1

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_ADDITIVE_RISKS,  object_name:GR_WORK_ADDITIVE_RISKS,  status:VALID, 

  • TABLE: PSP.PSP_MATRIX_DRIVER3 12.2.2

    owner:PSP,  object_type:TABLE,  fnd_design_data:PSP.PSP_MATRIX_DRIVER3,  object_name:PSP_MATRIX_DRIVER3,  status:VALID, 

  • TABLE: GR.GR_WORK_AUDIT 12.2.2

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_AUDIT,  object_name:GR_WORK_AUDIT,  status:VALID, 

  • TABLE: GR.GR_WORK_COUNTRY 12.1.1

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_COUNTRY,  object_name:GR_WORK_COUNTRY,  status:VALID, 

  • TABLE: GR.GR_WORK_AUDIT 12.1.1

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_AUDIT,  object_name:GR_WORK_AUDIT,  status:VALID, 

  • TABLE: IGF.IGF_AP_ISIRCOR_TMP 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_AP_ISIRCOR_TMP,  object_name:IGF_AP_ISIRCOR_TMP,  status:VALID, 

  • TABLE: GR.GR_WORK_CLASSN_RISKS 12.2.2

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_CLASSN_RISKS,  object_name:GR_WORK_CLASSN_RISKS,  status:VALID, 

  • TABLE: MSD.MSD_BACKUP_LEVEL_VALUES 12.2.2

    owner:MSD,  object_type:TABLE,  fnd_design_data:MSD.MSD_BACKUP_LEVEL_VALUES,  object_name:MSD_BACKUP_LEVEL_VALUES,  status:VALID, 

  • TABLE: GR.GR_WORK_CLASSN_RISKS 12.1.1

    owner:GR,  object_type:TABLE,  fnd_design_data:GR.GR_WORK_CLASSN_RISKS,  object_name:GR_WORK_CLASSN_RISKS,  status:VALID, 

  • TABLE: BOM.CST_VALUE_REPORT_TEMP 12.1.1

    owner:BOM,  object_type:TABLE,  fnd_design_data:BOM.CST_VALUE_REPORT_TEMP,  object_name:CST_VALUE_REPORT_TEMP,  status:VALID, 

  • TABLE: GMD.GMD_REPLACE 12.1.1

    owner:GMD,  object_type:TABLE,  fnd_design_data:GMD.GMD_REPLACE,  object_name:GMD_REPLACE,  status:VALID, 

  • TABLE: MSD.MSD_BACKUP_LEVEL_VALUES 12.1.1

    owner:MSD,  object_type:TABLE,  fnd_design_data:MSD.MSD_BACKUP_LEVEL_VALUES,  object_name:MSD_BACKUP_LEVEL_VALUES,  status:VALID, 

  • TABLE: EAM.EAM_ASSET_EXPLOSION_TEMP 12.1.1

    owner:EAM,  object_type:TABLE,  fnd_design_data:EAM.EAM_ASSET_EXPLOSION_TEMP,  object_name:EAM_ASSET_EXPLOSION_TEMP,  status:VALID, 

  • TABLE: GMD.GMD_REPLACE 12.2.2

    owner:GMD,  object_type:TABLE,  fnd_design_data:GMD.GMD_REPLACE,  object_name:GMD_REPLACE,  status:VALID, 

  • TABLE: BOM.CST_LISTS 12.1.1

    owner:BOM,  object_type:TABLE,  fnd_design_data:BOM.CST_LISTS,  object_name:CST_LISTS,  status:VALID, 

  • TABLE: IGF.IGF_DB_PAYS_PRG_T 12.1.1

    owner:IGF,  object_type:TABLE,  fnd_design_data:IGF.IGF_DB_PAYS_PRG_T,  object_name:IGF_DB_PAYS_PRG_T,  status:VALID,