Search Results okl_ass_pk

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.

• ID — surrogate primary key and unique business-key candidate (OKL_ASS_UC1).
• ASSET_NUMBER — user-facing asset identifier, protected by unique index OKL_ASS_UC2.
• ORIG_ASSET_ID — links a quoted asset to its originating asset record.
• PARENT_OBJECT_CODE / PARENT_OBJECT_ID — generic polymorphic reference associating the asset with its owning quote or parent entity.
• INSTALL_SITE_ID — the installation site associated with the quoted asset.
• OEC / OEC_PERCENTAGE — original equipment cost and its percentage basis, central to pricing.
• STRUCTURED_PRICING — flag governing whether structured pricing rules apply.
• RATE_TEMPLATE_ID / RATE_CARD_ID — rate configuration references used to derive pricing.
• LEASE_RATE_FACTOR — the applied lease rate factor.
• TARGET_ARREARS, TARGET_AMOUNT, TARGET_FREQUENCY — target payment characteristics for the quote.
• END_OF_TERM_VALUE / END_OF_TERM_VALUE_DEFAULT — residual value inputs for end-of-term treatment.

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:

• OKL_ASSETS_TL — translation table for asset descriptive text.
• OKL_QUOTES / OKL_QUOTE_HEADERS — the lease quote headers referenced via PARENT_OBJECT_CODE and PARENT_OBJECT_ID.
• OKL_ASSET_DETAILS — detail-level attribute rows for a quoted asset.
• OKL_RATE_CARDS_B / OKL_RATE_TEMPLATES_B — pricing configuration referenced by RATE_CARD_ID and RATE_TEMPLATE_ID.
• OKL_INSTALL_SITES / HR_LOCATIONS — installation site resolution for INSTALL_SITE_ID.
• OKL_CONTRACTS_B — contract header created from accepted quotes.

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.