Results for “okl_txd_assets_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_TXD_ASSETS_B is a transaction table within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 Leasing and Finance Management (OKL) module. It serves as the staging and transactional record for tax book asset attributes that must be communicated to the Oracle Fixed Assets module before a lease contract is activated. In addition, the table stores split asset transaction attributes required by Fixed Assets when a leased asset is divided into multiple depreciation components prior to activation. The table therefore sits at the boundary between the leasing transaction lifecycle and the corporate fixed asset register, capturing the descriptive and financial characteristics of each asset line in a form that eliminates redundant computation by the Fixed Assets application.

From a Data Vault modeling perspective, the mined foreign-key structure suggests a satellite-leaning classification. The table carries its own surrogate primary key (OKL_TXD_ASSETS_B_PK on ID) while referencing a parent asset record through TAL_ID, which is consistent with a descriptive satellite attached to a parent asset hub or link rather than a standalone hub. This classification is heuristic and should be treated as a modeling suggestion rather than a documented architectural designation.

Key Information Stored

The table contains 40 documented columns in the OKL schema. The most significant for integration and reporting purposes include:

• ID — the surrogate primary key, enforced by OKL_TXD_ASSETS_B_PK and duplicated by unique index OKL_TXD_ASSETS_B_U1. It uniquely identifies each asset transaction row.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Forms/ADF layer during concurrent updates.
• TAL_ID — foreign key to OKL_TXL_ASSETS_B, linking this tax book asset detail to its parent asset line.
• TARGET_KLE_ID — reference to the target lease or KLE (lease element) for which the asset is being prepared.
• LINE_DETAIL_NUMBER and ASSET_NUMBER — the human-readable identifying line and asset reference passed to Fixed Assets.
• QUANTITY and COST — the physical count and capitalized cost basis of the asset line.
• TAX_BOOK — the depreciation book to which the asset will be posted.
• LIFE_IN_MONTHS_TAX, DEPRN_METHOD_TAX, and DEPRN_RATE_TAX — the tax book life, depreciation method, and rate that Fixed Assets will use.
• SALVAGE_VALUE — the residual value applied to the tax book asset.
• SPLIT_PERCENT — the percentage allocated to a split asset component.
• INVENTORY_ITEM_ID — the inventory item reference for the underlying asset.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, and CURRENCY_CONVERSION_DATE — the currency and conversion parameters needed to translate foreign-currency costs into the functional currency before transfer to Fixed Assets.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle flexfield descriptor columns reserved for client-specific extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical usage centers on pre-activation validation and reconciliation reporting between OKL and Fixed Assets. A common query confirms that every tax book asset row has a valid parent asset line:

• Pre-activation completeness check: join OKL_TXD_ASSETS_B to OKL_TXL_ASSETS_B on TAL_ID to ensure all tax book attributes are populated before the contract activation concurrent program runs.
• Split asset reporting: query rows where SPLIT_PERCENT is not null to review how a single leased asset has been apportioned across depreciation components.
• Currency translation audit: select CURRENCY_CODE, CURRENCY_CONVERSION_RATE, and COST to verify converted amounts against the corporate ledger.
• Depreciation setup validation: list TAX_BOOK, LIFE_IN_MONTHS_TAX, DEPRN_METHOD_TAX, DEPRN_RATE_TAX, and SALVAGE_VALUE to confirm consistency with Fixed Assets book controls.
• Exception monitoring: identify rows where INVENTORY_ITEM_ID is null or where SPLIT_PERCENT exceeds 100, which typically indicates incomplete upstream data entry.

A representative pattern is: SELECT a.ASSET_NUMBER, a.TAX_BOOK, a.COST, a.SPLIT_PERCENT FROM OKL_TXD_ASSETS_B a, OKL_TXL_ASSETS_B b WHERE a.TAL_ID = b.ID AND a.SPLIT_PERCENT IS NOT NULL;

Related Objects

• OKL_TXL_ASSETS_B — the parent asset line table; joined via OKL_TXD_ASSETS_B.TAL_ID = OKL_TXL_ASSETS_B.ID. This is the primary parent referenced by the table.
• OKL_TXL_ITM_INSTS — the item instance table, which references OKL_TXD_ASSETS_B through the ASD_ID column. This child relationship makes OKL_TXD_ASSETS_B the parent for item instance records tied to tax book assets.
• FA_ADDITIONS_B / FA_ADDITIONS_T — Fixed Assets asset addition tables populated when the contract is activated and tax book attributes are transferred.
• FA_BOOK_CONTROLS — provides the valid TAX_BOOK values and depreciation rules referenced by this table's columns.
• OKL_TXL_ASSET_TRXNS — associated transaction records that may accompany asset processing.
• OKL_TXD_ASSETS_B_PK and OKL_TXD_ASSETS_B_U1 — the primary key constraint and unique index defining the ID as the definitive row identifier.

Together these relationships confirm the table's role as the tax book asset staging satellite bridging OKL lease transactions and the Oracle Fixed Assets asset register.