Search Results okl_cdj_pk

Overview

OKL_COST_ADJUSTMENTS_B is a core transactional table within the Oracle E-Business Suite (EBS) Leasing and Finance Management module (OKL). It stores financing cost adjustments that apply to quoted assets throughout the lease origination and quoting lifecycle. In the context of OKL, a "quoted asset" represents an asset position attached to a lease or loan quote, and its financing cost can be altered by adjustments such as subsidies, promotional rates, or supplier-funded incentives. This table is the primary base table that captures those adjustment records, held centrally in the OKL schema and validated as VALID in both EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the metadata classifies this object as standalone based on its foreign key structure — meaning it is not directly anchored to a parent hub through a mandated foreign key relationship, though it does carry logical parent references. This suggests a design where each adjustment row is largely self-contained, with parent linkage expressed through generic object code/ID pairs rather than enforced foreign keys.

Key Information Stored

The table exposes 34 documented physical columns. The most significant include:

• ID — the surrogate primary key, backed by the OKL_CDJ_PK constraint. This uniquely identifies each cost adjustment record.
• PARENT_OBJECT_CODE and PARENT_OBJECT_ID — a polymorphic reference identifying the owning business entity (for example, the quote, quote line, or asset) to which the adjustment belongs. These form a strong business-key candidate in combination.
• ADJUSTMENT_SOURCE_TYPE and ADJUSTMENT_SOURCE_ID — identify where the adjustment originates (such as a supplier program or internal source) and its specific source record.
• BASIS and VALUE — define the calculation basis and the numeric value applied by the adjustment.
• PERCENT_BASIS_VALUE — supports percentage-based adjustments, complementing the BASIS/VALUE pair.
• PROCESSING_TYPE — indicates how the adjustment is processed within the financing cost calculations.
• SUPPLIER_ID — the supplier associated with a supplier-funded subsidy.
• DEFAULT_SUBSIDY_AMOUNT — the default subsidy amount derived for the adjustment.
• STREAM_TYPE_ID — identifies the payment or cashflow stream type affected.
• OBJECT_VERSION_NUMBER — supports optimistic locking and concurrent update control.
• The WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the fifteen ATTRIBUTE / ATTRIBUTE_CATEGORY flex columns provide audit and extensibility support.

Common Use Cases and Queries

Typical usage centers on retrieving, validating, and reporting adjustments tied to a quote. A common query pattern joins the parent reference to a quote or asset entity:

• Retrieving all adjustments for a parent object: SELECT * FROM OKL_COST_ADJUSTMENTS_B WHERE PARENT_OBJECT_CODE = :code AND PARENT_OBJECT_ID = :id;
• Isolating supplier-funded subsidies: SELECT ID, SUPPLIER_ID, DEFAULT_SUBSIDY_AMOUNT FROM OKL_COST_ADJUSTMENTS_B WHERE SUPPLIER_ID IS NOT NULL;
• Audit/traceability reporting using the WHO columns to identify recently modified adjustments.
• Reconciliation of adjustment totals against quoted asset financing costs by grouping on BASIS, PROCESSING_TYPE, or STREAM_TYPE_ID.

Because it is a base table, most reporting surfaces through associated translated tables and descriptive views rather than direct queries.

Related Objects

The most significant related objects, inferred from the parent-reference and surrogate pattern, include:

• OKL_COST_ADJUSTMENTS_TL — the translated table sharing the ID primary key, providing language-specific descriptive columns.
• OKL_COST_ADJUSTMENTS_V — the descriptive view typically joining base and TL tables for reporting.
• The quote and quote-line base tables referenced via PARENT_OBJECT_CODE and PARENT_OBJECT_ID.
• The supplier table (PO_VENDORS / AP_SUPPLIERS) via SUPPLIER_ID.
• OKL_STREAM_TYPES classes referenced through STREAM_TYPE_ID.

Collectively these objects make OKL_COST_ADJUSTMENTS_B the central persistence point for financed cost adjustments in the leasing quote flow.