Search Results okl_fee_nc1

Overview

OKL.OKL_FEES_B is the header table within the Oracle E-Business Suite Lease and Finance Management (formerly Oracle Lease Management, OKL) schema that stores header-level information about fees quoted on a Lease Quote. It is registered under FND Design Data as OKL.OKL_FEES_B and resides in the APPS_TS_TX_DATA tablespace with a status of VALID. The table is transactional in nature, holding the fee structures, pricing references, and financial terms associated with a given lease quote or contract line. It forms the parent in a header/attribute relationship with OKL_FEES_TL, which carries the translatable descriptive text for each fee.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure is standalone. Because the table is largely independent, with only one documented outbound FK (PAYMENT_TYPE_ID → PAY_PAYMENT_TYPES), it is best modeled as a satellite or an independent hub rather than a link. Modelers should treat OKL_FEES_B as a descriptor-bearing entity keyed by its own surrogate identifier, with any relationships to payment types captured as reference lookups rather than transaction links.

Key Information Stored

The table contains 42 documented columns. The most operationally significant are:

• ID (NUMBER) — Surrogate primary key, enforced by the OKL_FEE_PK constraint and by the unique index OKL_FEE_UC1 (NORMAL, UNIQUE, APPS_TS_TX_IDX). This is the sole documented business-key candidate.
• OBJECT_VERSION_NUMBER — Locking column used for optimistic concurrency during updates.
• PARENT_OBJECT_CODE and PARENT_OBJECT_ID — Identify the parent lease quote or contract for which the fee is created; PARENT_OBJECT_ID is indexed non-uniquely via OKL_FEE_NC1.
• FEE_TYPE (VARCHAR2 30) — Classifies the fee (e.g., origination, documentation, late charge).
• FEE_AMOUNT and INITIAL_DIRECT_COST — Monetary values for the fee and its associated direct cost.
• TARGET_AMOUNT and TARGET_FREQUENCY — Target revenue and billing cadence.
• FEE_PURPOSE_CODE — Purpose classification for the fee.
• PAYMENT_TYPE_ID — Foreign key to OKL.OKL_PAYMENT_TYPES (PAY_PAYMENT_TYPES), linking the fee to a specific payment method.
• STREAM_TYPE_ID — Identifies the stream type associated with the fee.
• RATE_TEMPLATE_ID, RATE_CARD_ID, and LEASE_RATE_FACTOR — Pricing references used when the fee is structured against a rate card or template.
• EFFECTIVE_FROM and EFFECTIVE_TO — Date-bounded validity window for the fee record.
• STRUCTURED_PRICING — Flag indicating whether the fee is derived through structured pricing logic.
• ROLLOVER_QUOTE_ID and SUPPLIER_ID — Links to rollover quotes and the supplier associated with the fee.
• Standard WHO admin columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, plus the descriptive flexfield columns ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15.

Common Use Cases and Queries

Typical reporting and integration scenarios include retrieving all fees for a lease quote, aggregating fee revenue by fee type, and validating that effective dates align with contract terms. A representative join to the payment-type lookup is:

SELECT f.ID, f.FEE_TYPE, f.FEE_AMOUNT, f.EFFECTIVE_FROM, f.EFFECTIVE_TO, p.NAME
FROM   OKL.OKL_FEES_B f,
       PAY.PAY_PAYMENT_TYPES p
WHERE  f.PAYMENT_TYPE_ID = p.PAYMENT_TYPE_ID
AND    f.PARENT_OBJECT_ID = :quote_id
AND    SYSDATE BETWEEN f.EFFECTIVE_FROM AND NVL(f.EFFECTIVE_TO, SYSDATE);

Because the descriptive flexfield columns are stored locally, queries that surface user-defined attributes should reference ATTRIBUTE_CATEGORY together with ATTRIBUTE1–ATTRIBUTE15. Aggregations on FEE_AMOUNT grouped by FEE_TYPE and TARGET_FREQUENCY support revenue forecasting.

Related Objects

The following objects are most significant to OKL_FEES_B:

• PAY.PAY_PAYMENT_TYPES — Joined via OKL_FEES_B.PAYMENT_TYPE_ID = PAY_PAYMENT_TYPES.PAYMENT_TYPE_ID.
• OKL.OKL_FEES_TL — The translatable child table carrying fee names and descriptions keyed by FEE_ID → OKL_FEES_B.ID.
• OKL.OKL_QUOTES_B and OKL.OKL_QUOTES_TL — Parent lease quote entities referenced indirectly through PARENT_OBJECT_ID / PARENT_OBJECT_CODE.
• OKL.OKL_RATE_TEMPLATES and OKL.OKL_RATE_CARDS — Referenced by RATE_TEMPLATE_ID and RATE_CARD_ID for structured pricing.
• OKL.OKL_STREAM_TYPES — Referenced by STREAM_TYPE_ID.
• OKL.OKL_FEE_TYPES_B — Lookup source for the FEE_TYPE classification.
• OKL.OKL_LEASE_LINES — Line-level detail for the lease contract to which fees attach.