Search Results okl_trx_msgs




Overview
Explore in AI Chat

Overview

The OKL_TRX_MSGS table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as the central repository for storing system-generated messages associated with specific financial transactions. Its primary role is to provide a detailed audit trail and communication log for transaction processing, capturing informational, warning, and error messages that occur during the execution of leasing and finance operations. By referencing standard Application Object Library (AOL) messages, it ensures message consistency and supports multilingual capabilities across the EBS instance.

Key Information Stored

The table stores metadata that links transaction events to formal system messages. While the full column list is not detailed in the provided metadata, the foreign key relationships indicate its critical structure. The primary key is the ID column. Essential foreign key columns include BCH_ID, which links the message to a specific transaction batch or header, and a composite foreign key to the FND_NEW_MESSAGES table. This composite key consists of TMG_APPLICATION_ID, TMG_MESSAGE_NAME, and TMG_LANGUAGE_CODE, which precisely identifies the message text, its source application, and the language of the message. This design allows the table to store only reference keys, while the actual translatable message text is maintained in the standard AOL repository.

Common Use Cases and Queries

A primary use case is troubleshooting and auditing transaction processing within OKL. For instance, if a lease invoice batch fails to complete, consultants can query this table to retrieve all associated error messages. Common reporting needs include generating transaction error logs or validating successful processing. A typical diagnostic query would join to the transaction batch table and the messages table to present a readable audit trail.

SELECT otrm.bch_id,
       fnd.meaning,
       fnd.message_text
  FROM okl_trx_msgs otrm,
       fnd_new_messages fnd
 WHERE otrm.tmg_application_id = fnd.application_id
   AND otrm.tmg_message_name   = fnd.message_name
   AND otrm.tmg_language_code  = fnd.language_code
   AND otrm.bch_id = :p_batch_id;

This query retrieves the human-readable message text for all messages linked to a specific transaction batch.

Related Objects

  • Primary Key Constraint: OKL_TRX_MSGS_PK on the ID column.
  • Foreign Key to Transaction Batch/Header: The BCH_ID column references an unspecified table, logically pointing to a transaction batch or contract header within the OKL schema (e.g., OKL_TRX_BATCHES or a similar entity).
  • Foreign Key to FND_NEW_MESSAGES: A composite foreign key linking to the standard messages repository. The join is performed using the columns TMG_APPLICATION_ID, TMG_MESSAGE_NAME, and TMG_LANGUAGE_CODE to the corresponding columns in FND_NEW_MESSAGES.