Search Results okl_fee_pk

Overview

OKL_FEES_B is a transactional header table within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, owning schema OKL. It stores header-level information about fees quoted on a Lease Quote, making it the entry point for fee definition and pricing on lease contracts. In release 12.1.1 and 12.2.2 the table is documented with 42 columns and a primary key constraint named OKL_FEE_PK, built on the ID column.

Under the heuristic Data Vault classification mined from the foreign key structure, OKL_FEES_B is treated as a standalone object rather than a conventional hub, link, or satellite. As a modeling suggestion, this classification indicates that OKL_FEES_B carries no inbound child relationships in the shipped schema and can be modeled in isolation, with its own primary key acting as the natural integration point. Its foreign key to PAY_PAYMENT_TYPES is an outbound reference only.

Key Information Stored

The surrogate primary key is ID (constraint OKL_FEE_PK). A second unique index, OKL_FEE_UC1, is also defined on ID, which the metadata flags as a business-key candidate; in practice the distinct business identity of a fee record is composed from the parent context and fee type rather than from ID alone. The most significant documented columns are:

• PARENT_OBJECT_CODE and PARENT_OBJECT_ID — the polymorphic link identifying the owning entity, typically the lease quote or contract to which the fee belongs.
• FEE_TYPE and FEE_PURPOSE_CODE — the classification and business purpose of the fee.
• FEE_AMOUNT, TARGET_AMOUNT, and TARGET_FREQUENCY — the quoted amount and its target basis and repetition frequency.
• PAYMENT_TYPE_ID — foreign key to PAY_PAYMENT_TYPES, defining how the fee is settled.
• STRUCTURED_PRICING, RATE_TEMPLATE_ID, RATE_CARD_ID, and LEASE_RATE_FACTOR — pricing constructs that determine how the fee is derived.
• STREAM_TYPE_ID and SUPPLIER_ID — the payment stream classification and the supplier associated with the fee.
• EFFECTIVE_FROM, EFFECTIVE_TO, and ROLLOVER_QUOTE_ID — date-bounded validity and rollover linkage.
• INITIAL_DIRECT_COST and TARGET_ARREARS — cost and arrears treatment indicators.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard concurrency control and audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard DFF/extension block.

Common Use Cases and Queries

Typical reporting retrieves all fees for a given quote or contract by joining on the polymorphic parent columns. A representative pattern is:

• SELECT f.id, f.fee_type, f.fee_amount, f.fee_purpose_code FROM okl.okl_fees_b f WHERE f.parent_object_code = :code AND f.parent_object_id = :parent_id;
• Pricing analysis by joining to the payment types reference on f.payment_type_id = p.payment_type_id.
• Effective-dated fee validation using EFFECTIVE_FROM and EFFECTIVE_TO to isolate currently active fee lines.
• Audit and reconciliation extracts on LAST_UPDATE_DATE ranges for incremental ETL loads.
• Rollover reporting using ROLLOVER_QUOTE_ID to trace fees carried into a successor quote.

Related Objects

• PAY_PAYMENT_TYPES — referenced by OKL_FEES_B.PAYMENT_TYPE_ID, providing the payment type definition for each fee.
• OKL_FEES_TL / OKL_FEES_VL — the translated and view-layer counterparts that expose fee header details for UI and reporting.
• OKL_QUOTES_B and related quote headers — the parent entities identified through PARENT_OBJECT_CODE and PARENT_OBJECT_ID.
• OKL_RATE_TEMPLATES_B and OKL_RATE_CARDS_B — pricing sources referenced by RATE_TEMPLATE_ID and RATE_CARD_ID.
• OKL_STREAM_TYPES — referenced by STREAM_TYPE_ID for fee stream classification.
• OKL_SUPPLIERS / AP_SUPPLIERS — supplier context for fees carrying SUPPLIER_ID.
• OKL_FEE_APIS / OKL_FEES_PUB — programmatic entry points used by lease quote and pricing flows to create and maintain fee headers.