Search Results okl_ass_uc2

Overview

OKL.OKL_ASSETS_B is a transactional table in the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. It stores header-level information about assets that have been quoted on a lease quote. Each row represents a single asset header record associated with a parent lease quote, capturing the identifying asset number, pricing and rate configuration, end-of-term valuation defaults, and a full set of descriptive flexfield attributes.

The table is owned by the OKL schema and resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10. It is documented as VALID in the ETRM 12.2.2 physical schema and carries 39 columns in total. In the 12.1.1 and 12.2.2 code lines the object is referenced through the standard EBS application design data registration as OKL.OKL_ASSETS_B. From a Data Vault modeling perspective, the metadata suggests this object behaves as a satellite, since it stores descriptive and mutable attribute detail anchored to a parent instance; depending on how parent references are interpreted, elements of link behavior may also apply where the asset participates in relationships to lease quotes and other parties.

Key Information Stored

The table is anchored by a surrogate primary key and constrained by two unique indexes, which together define both the physical access path and the business key candidates.

• ID (NUMBER) — surrogate primary key, backed by unique index OKL_ASS_UC1; the OKL_ASS_PK constraint is defined on this column.
• ASSET_NUMBER (VARCHAR2, length 15) — business-key candidate, backed by unique index OKL_ASS_UC2; the human-readable asset identifier quoted on the lease.
• PARENT_OBJECT_CODE (VARCHAR2, 30) — identifies the parent object type, for example 'LEASE_QUOTE' when the asset belongs to a lease quote.
• PARENT_OBJECT_ID (NUMBER) — the identifier of the parent object instance; indexed non-uniquely through OKL_ASS_NC1 for parent-based lookups.
• ORIG_ASSET_ID (NUMBER) — reference to the originating asset record, useful for tracking re-quoted or duplicated assets.
• INSTALL_SITE_ID (NUMBER) — the installation site associated with the asset.
• STRUCTURED_PRICING — flag or value governing the pricing structure applied to the quote asset.
• RATE_TEMPLATE_ID and RATE_CARD_ID (NUMBER) — rate configuration references used to derive lease pricing.
• LEASE_RATE_FACTOR — the rate factor applied in the lease calculation.
• OEC and OEC_PERCENTAGE — original equipment cost and its percentage, used for financing basis.
• END_OF_TERM_VALUE and END_OF_TERM_VALUE_DEFAULT — residual or end-of-term valuation amounts.
• TARGET_ARREARS, TARGET_AMOUNT, and TARGET_FREQUENCY — target payment terms and frequency for the asset.
• OBJECT_VERSION_NUMBER — concurrency control column used for locking records during updates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 (VARCHAR2, 450) — descriptive flexfield storage for client-specific extensions.

Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) provide audit tracking.

Common Use Cases and Queries

Typical usage centers on retrieving quoted assets for a lease quote, validating that an asset number is unique, and extracting pricing or residual values for reporting. The unique index on ASSET_NUMBER makes it the natural lookup key for business transactions, while PARENT_OBJECT_ID supports parent-driven navigation.

Querying assets by parent lease quote:

SELECT a.id, a.asset_number, a.oec, a.oec_percentage, a.end_of_term_value
FROM okl.okl_assets_b a
WHERE a.parent_object_code = 'LEASE_QUOTE'
AND a.parent_object_id = :p_quote_id;

Looking up a single asset by its business key:

SELECT id, parent_object_id, rate_card_id, lease_rate_factor
FROM okl.okl_assets_b
WHERE asset_number = :p_asset_number;

Reporting queries commonly join to the lease quote header and to rate configuration tables to render pricing summaries, and use descriptive flexfield columns for client-defined attributes. Because the table carries the OBJECT_VERSION_NUMBER column, integrations that update these rows must respect optimistic locking to avoid overwriting concurrent changes.

Related Objects

The documented index metadata shows no dependent foreign keys outbound from this table, and the relationship data classifies the object as standalone. The following objects are the most significant points of reference:

• OKL.OKL_ASSETS_B itself via index OKL_ASS_NC1 on PARENT_OBJECT_ID, enabling self-referencing or parent-scoped access patterns.
• The lease quote header table (the parent identified by PARENT_OBJECT_CODE = 'LEASE_QUOTE' and PARENT_OBJECT_ID), which owns the quote to which each asset is attached.
• Rate configuration tables referenced by RATE_TEMPLATE_ID and RATE_CARD_ID.
• The originating asset record referenced by ORIG_ASSET_ID.
• Installation site reference tables keyed by INSTALL_SITE_ID.
• OKL lease quote and pricing APIs that insert, update, or validate OKL_ASSETS_B rows during quote creation and revision.
• OKL descriptive flexfield definition tables that drive the ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 columns.

Any extension or integration touching this table should honor the primary key OKL_ASS_PK on ID, preserve the ASSET_NUMBER uniqueness constraint, and treat PARENT_OBJECT_ID as the principal link to the lease quote context.