Search Results okl_assets_b




Overview
Explore in AI Chat

Overview

OKL_ASSETS_B is a core transactional table in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, present and valid in both release 12.1.1 and 12.2.2. It resides in the OKL schema and stores header-level information about assets that are quoted on a Lease Quote. In the leasing lifecycle, this table acts as the anchor record for each asset being priced and presented to a prospective lessee before a contract is authored. Each row captures the financial, pricing, and identification attributes of a single quoted asset, including its cost basis, residual characteristics, and rate configuration.

From a dimensional modeling perspective, the mined foreign-key structure yields a heuristic Data Vault classification of standalone, meaning the table does not participate in a dense hub-and-link graph and largely functions as an independent entity with limited enforced referential dependencies. This classification is a modeling suggestion only; in practice the table behaves as a header entity whose detail rows and quote associations are managed through application logic rather than rigid database constraints.

Key Information Stored

The table exposes 39 documented columns. Its surrogate primary key is ID, enforced through the OKL_ASS_PK constraint. Two unique indexes serve as business-key candidates: OKL_ASS_UC1 on ID and OKL_ASS_UC2 on ASSET_NUMBER, indicating that the asset number is the primary human-readable identifier.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and OBJECT_VERSION_NUMBER support auditability and optimistic locking, while ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 provide the customary DFF extension storage.

Common Use Cases and Queries

The most frequent access pattern retrieves all quoted assets for a given quote by joining on the polymorphic parent reference. A representative pattern is:

  • Reporting: SELECT asset_number, oec, oec_percentage, lease_rate_factor FROM okl_assets_b WHERE parent_object_code = :code AND parent_object_id = :id;
  • Exception review: querying rows where STRUCTURED_PRICING is null or RATE_CARD_ID is unpopulated to find incomplete pricing setups.
  • Residual analysis: comparing END_OF_TERM_VALUE against END_OF_TERM_VALUE_DEFAULT to detect manual overrides.
  • Reconciliation: joining ORIG_ASSET_ID back to the source asset to validate cost basis between quote and contract stages.

Related Objects

The documented relationship data classifies this table as standalone, so no enforced foreign keys are mined. In practice, the following objects interact with it:

Any custom extension should respect the optimistic locking convention of OBJECT_VERSION_NUMBER and reuse the ATTRIBUTE columns through the DFF framework rather than altering the base table structure.