Search Results okl_sif_fees




Overview
Explore in AI Chat

Overview

The OKL_SIF_FEES table is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. Its primary function is to store detailed fee and payment information that is specifically required for the external pricing of lease and finance contracts. This table acts as a critical interface table, facilitating the exchange of structured financial data between the internal contract management system and external pricing engines or services. It ensures that all requisite fee components are accurately captured and formatted for downstream processing, supporting complex financial calculations and deal structuring.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented foreign key relationships and primary keys define its core structure. The table uniquely identifies each record with a primary key (SFE_PK) on the ID column. It stores the essential link to a lease or finance line item via the KLE_ID column, which references the OKL_K_LINES table. Furthermore, it is associated with a parent stream interface record through the SIF_ID column, which references the OKL_STREAM_INTERFACES table. The data held typically includes fee amounts, fee types, payment terms, due dates, and calculation bases, forming a complete dataset necessary for external pricing evaluations.

Common Use Cases and Queries

The primary use case for this table is during the contract pricing and approval workflow. When a lease or finance contract is submitted for external pricing validation or funding, the system aggregates the relevant fee data from this table. Common reporting and validation queries involve joining to related contract and stream interface tables. For instance, a query to list all fees for a specific contract line for audit purposes would join OKL_SIF_FEES to OKL_K_LINES. Another typical pattern is extracting a complete fee schedule for a given stream interface (SIF_ID) to be transmitted to an external system. Data integrity checks often verify that all fees referenced in OKL_SIF_STREAM_TYPES have corresponding master records in OKL_SIF_FEES.

Related Objects

OKL_SIF_FEES is centrally connected to several key tables in the OKL schema, as documented by its foreign key constraints:

  • OKL_K_LINES: The table is linked to lease/finance line items via the foreign key on column OKL_SIF_FEES.KLE_ID referencing OKL_K_LINES.
  • OKL_STREAM_INTERFACES: Fees are grouped under a specific stream interface record via the foreign key on column OKL_SIF_FEES.SIF_ID referencing OKL_STREAM_INTERFACES.
  • OKL_SIF_STREAM_TYPES: This table holds a dependent relationship, where OKL_SIF_STREAM_TYPES references OKL_SIF_FEES via its SFE_ID column, indicating that stream type details are defined for specific fee records.