Search Results okl_txd_assets_b

Overview

The OKL_TXD_ASSETS_B table is a core transaction table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves a critical role in the integration between the leasing lifecycle and the Fixed Assets module. Specifically, this table acts as a staging or preparatory area for tax book-related asset attributes required by Fixed Assets. Its primary purpose is to hold detailed asset transaction data, including attributes for split asset transactions, before a lease or finance contract is formally activated. This ensures all necessary fixed asset information is correctly assembled and validated prior to the contract becoming active and generating asset records in the FA module.

Key Information Stored

While the full column list is not detailed in the provided metadata, the table's structure is centered on transaction-level asset details. The primary key column is ID, which uniquely identifies each transaction record. A critical foreign key column is TAL_ID, which links the transaction detail back to its parent asset header record in the OKL_TXL_ASSETS_B table. Based on its described function, other columns likely store attributes such as transaction amounts (e.g., cost), dates, tax book codes, split proportions, and flags indicating the transaction's status or type relevant to fixed asset creation and accounting. These attributes are essential for the accurate subsequent creation and capitalization of assets in Oracle Fixed Assets.

Common Use Cases and Queries

This table is primarily accessed during the contract activation workflow and for troubleshooting asset integration issues. Common operational and reporting scenarios include validating pre-activation asset data, reconciling transaction details before posting to FA, and auditing split asset transactions. A typical query might join to the parent asset table to review all pending transactions for a specific contract.

• Sample Query: Retrieving transaction details for a specific parent asset header.
  SELECT txd.* FROM OKL.OKL_TXD_ASSETS_B txd WHERE txd.tal_id = <parent_asset_id>;
• Use Case: An asset accountant runs a report to verify the total transaction cost and tax book attributes of all split assets associated with a new lease contract before activation, ensuring data completeness.
• Use Case: A technical consultant queries this table to diagnose why a contract activation failed, checking for missing mandatory asset attributes that are required by the Fixed Assets interface.

Related Objects

The OKL_TXD_ASSETS_B table exists within a key relationship hierarchy in the OKL schema. Its primary relationships, as documented, are:

• OKL_TXL_ASSETS_B: This is the parent table, linked via the foreign key TAL_ID. It holds the header-level information for the asset.
• OKL_TXL_ITM_INSTS: This table holds item instance information and references OKL_TXD_ASSETS_B via its ASD_ID column, indicating a relationship between asset transaction details and specific leased item instances.
• Fixed Assets Module Tables (e.g., FA_ADDITIONS_B): While not explicitly listed in the metadata, this table's ultimate purpose is to feed data into Oracle Fixed Assets. Its data is processed by OKL's asset interface programs to create records in the FA module's core tables upon successful contract activation.