Search Results okl_txl_assets_b




Overview
Explore in AI Chat

Overview

The OKL_TXL_ASSETS_B table is a core transaction table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It functions as a contract line-level staging area, specifically designed to capture and hold detailed asset attribute information required for the Fixed Asset module. Its primary operational role is to serve as a repository for asset data before a lease or finance contract is formally activated. This ensures all necessary asset details for capital accounting and asset tracking are validated and in place prior to contract commencement, supporting accurate fixed asset creation and lifecycle management.

Key Information Stored

The table stores transactional asset attributes linked to specific contract lines. While the full column list is not detailed in the provided metadata, its structure is defined by key foreign key relationships that indicate the critical data linkages. The primary key column is ID. Essential relational columns include KLE_ID, which links the record to a specific contract line in the OKL_K_LINES table, establishing the line-level context. The TAS_ID column references the OKL_TRX_ASSETS table, connecting to the master transaction asset record. Additionally, the DNZ_KHR_ID column denotes the tenant context or data group identifier for the record, a common feature in multi-tenant EBS architectures.

Common Use Cases and Queries

The primary use case involves processes that prepare or validate asset data for contract activation. This includes interfaces from external systems, data entry workflows, and validation routines that populate this table before submitting a contract for approval. A common reporting need is to identify contract lines with incomplete or pending asset data prior to activation. A sample query to achieve this would join the table to its related contract line and header tables.

  • Sample Query: SELECT txl.id, kl.line_number, kh.contract_number FROM okl_txl_assets_b txl, okl_k_lines kl, okl_k_headers_b kh WHERE txl.kle_id = kl.id AND kl.khr_id = kh.id AND kh.contract_status = 'ENTERED';
  • Data Validation: Data in this table is typically processed by the Fixed Asset interface or OKL-specific programs that create the final fixed asset records in the FA module upon contract activation.

Related Objects

OKL_TXL_ASSETS_B is centrally connected to several key objects within the Leasing schema, as defined by its foreign keys.

  • OKL_K_LINES: The fundamental parent table for contract line details, linked via the KLE_ID column.
  • OKL_TRX_ASSETS (TAS_ID): The master transaction asset definition table.
  • OKL_TXD_ASSETS_B: This table holds distribution-level asset transaction details and is a child of OKL_TXL_ASSETS_B, linked via the TAL_ID foreign key from the distribution table.
  • The table is also protected by its primary key constraint, OKL_TXL_ASSETS_B_PK.