Results for “okl_sif_fees”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_SIF_FEES is a transaction and interface table within the Oracle Lease and Finance Management (OKL) module. It holds the fee and payment details required for external pricing calculations, acting as the staging repository where fee structures, payment streams, and pricing attributes are assembled before being consumed by the external pricing engine. In Oracle EBS 12.1.1 and 12.2.2, this table sits at the junction between contract line definition (OKL_K_LINES) and stream interface processing (OKL_STREAM_INTERFACES), making it central to lease pricing workflows.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. The table carries descriptive and numeric attributes (rates, amounts, dates, flags) that qualify parent business keys rather than serving as an independent hub or as a pure many-to-many link. Modelers should treat the composite unique key as the business key candidate around which satellite attributes are grouped.

Key Information Stored

The surrogate primary key is SFE_PK, physically implemented as the ID column and enforced through unique index OKL_SFE_U1. The business-key candidate is captured by unique index OKL_SFE_U2, a composite of SIF_ID, SIL_ID, SFE_TYPE, FEE_INDEX_NUMBER, and LEVEL_INDEX_NUMBER. These five columns together define the natural identity of a fee/payment record within a stream interface.

  • ID — Surrogate primary key (SFE_PK).
  • SIF_ID — Foreign key to OKL_STREAM_INTERFACES; associates the fee with its parent stream interface.
  • KLE_ID — Foreign key to OKL_K_LINES; ties the fee to a contract line.
  • SIL_ID — Stream interface line identifier; part of the business key.
  • SFE_TYPE — Classifies the fee or payment type; part of the business key.
  • FEE_INDEX_NUMBER and LEVEL_INDEX_NUMBER — Ordering and leveling attributes completing the business key.
  • RATE and AMOUNT#1 — Pricing basis and monetary value of the fee or payment.
  • DATE_START and DATE_PAID — Effective date range and payment date for the fee entry.
  • ADVANCE_OR_ARREARS, PERIOD, NUMBER_OF_PERIODS, DAYS_IN_PERIOD — Timing and frequency characteristics of the payment stream.
  • INCOME_OR_EXPENSE, STRUCTURE, LEVEL_TYPE — Classification flags controlling accounting and leveling behavior.
  • CASH_EFFECT_YN and TAX_EFFECT_YN — Indicators for cash and tax treatment.
  • STREAM_INTERFACE_ATTRIBUTE01..20 — Flexible descriptor columns used for external pricing attributes.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER — Standard audit and concurrency columns.

Common Use Cases and Queries

Typical usage centers on pricing integration, fee reconciliation, and reporting on payment streams. A common pattern joins OKL_SIF_FEES to OKL_STREAM_INTERFACES and OKL_K_LINES to reconstruct the pricing context:

  • SELECT f.ID, f.SFE_TYPE, f.RATE, f.AMOUNT#1, si.SIF_ID, kl.KLE_ID FROM OKL_SIF_FEES f JOIN OKL_STREAM_INTERFACES si ON f.SIF_ID = si.SIF_ID JOIN OKL_K_LINES kl ON f.KLE_ID = kl.KLE_ID
  • Filtering by SIF_ID to isolate all fees for a single external pricing request.
  • Aggregating AMOUNT#1 by SFE_TYPE and CASH_EFFECT_YN for cash-flow reporting.
  • Auditing records where TAX_EFFECT_YN = 'Y' for tax reconciliation.
  • Detecting duplicates or gaps using the OKL_SFE_U2 business key columns.

Related Objects

  • OKL_STREAM_INTERFACES — Parent stream interface; joined on OKL_SIF_FEES.SIF_ID = OKL_STREAM_INTERFACES.SIF_ID.
  • OKL_K_LINES — Contract line parent; joined on OKL_SIF_FEES.KLE_ID = OKL_K_LINES.KLE_ID.
  • OKL_SIF_STREAM_TYPES — Child table referencing OKL_SIF_FEES via SFE_ID.
  • OKL_SIF_FEES ID column — Referenced by OKL_SIF_STREAM_TYPES.SFE_ID as its primary key link.