Results for “okl_stream_interfaces”

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

Overview

OKL_STREAM_INTERFACES is a core staging and integration table within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It holds contract header-level details that are exchanged with external pricing engines. In the leasing lifecycle, contracts frequently require pricing calculations—payment streams, yields, implicit interest rates, and fee allocations—that are performed by third-party systems or by the Oracle Pricing/Stream generation processes. This table serves as the interface staging area where the header-level attributes of a leasing transaction are persisted before and after external pricing, enabling the OKL contract to be priced outside of the native engine and then re-integrated.

Under a heuristic Data Vault classification, OKL_STREAM_INTERFACES models as a hub: it carries its own surrogate primary key (SIF_PK on the ID column) and is referenced as a parent by multiple dependent child tables. This suggests it functions as a central business entity anchor, with associated detail recorded in satellite-style child tables such as fee, line, yield, and transaction-parameter records. The documentation confirms the table is VALID and owned by the OKL schema in both EBS 12.1.1 and 12.2.2, with 58 documented columns in 12.2.2.

Key Information Stored

The table is keyed by two documented structures: a surrogate primary key, SIF_PK, defined on the ID column, and a unique business key candidate, OKL_SIF_U2, defined on TRANSACTION_NUMBER. A second unique constraint, SIF_SIF_UK, combines KHR_ID and TRANSACTION_NUMBER. Among the 58 columns, the most operationally significant include:

• ID — surrogate primary key and parent reference used by all child tables.
• KHR_ID — foreign key to OKL_K_HEADERS, linking the interface record to its owning contract header.
• TRANSACTION_NUMBER — the external business identifier for the pricing transaction.
• DATE_DELIVERY, DATE_PAYMENTS_COMMENCEMENT, DATE_PROCESSED, DATE_SEC_DEPOSIT_COLLECTED — key lifecycle dates driving stream timing.
• TOTAL_FUNDING, SECURITY_DEPOSIT_AMOUNT — monetary figures for the funding and deposit components.
• IMPLICIT_INTEREST_RATE, LENDING_RATE, RVI_RATE — rate inputs and outputs used in yield and pricing computations.
• PRICING_TEMPLATE_NAME — identifies the pricing template applied by the external engine.
• TERM, FIRST_PAYMENT, LAST_PAYMENT, STRUCTURE, DEAL_TYPE — contract structural attributes defining the stream shape.
• PURPOSE_CODE, SIS_CODE, ORP_CODE, RVI_YN — classification and optionality flags.
• STREAM_INTERFACE_ATTRIBUTE01 through 15 — a reserved extension block for externally supplied attributes.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program tracking columns.
• Standard audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on reconciling external pricing output back to the contract header, diagnosing failed pricing interfaces, and auditing the rates and dates submitted to the pricing engine. A common query joins the interface record to its contract header and its child stream lines:

SELECT s.TRANSACTION_NUMBER, s.KHR_ID, s.IMPLICIT_INTEREST_RATE, s.TOTAL_FUNDING, s.DATE_PAYMENTS_COMMENCEMENT FROM OKL_STREAM_INTERFACES s WHERE s.DATE_PROCESSED IS NULL;

Unprocessed records (DATE_PROCESSED null) indicate pricing requests awaiting external response. A second pattern joins child streams to verify that every interface header has generated fees, lines, and yields:

SELECT s.ID, s.TRANSACTION_NUMBER, COUNT(l.SIF_ID) FROM OKL_STREAM_INTERFACES s LEFT JOIN OKL_SIF_LINES l ON l.SIF_ID = s.ID GROUP BY s.ID, s.TRANSACTION_NUMBER;

Reporting use cases include tracking pricing throughput by REQUEST_ID and monitoring rate variances between IMPLICIT_INTEREST_RATE and LENDING_RATE across deal structures.

Related Objects

The table is the parent hub for six dependent child tables, all joined on SIF_ID referencing the parent's ID:

• OKL_K_HEADERS — parent contract header (KHR_ID).
• OKL_SIF_FEES — fee components linked via SIF_ID.
• OKL_SIF_LINES — payment stream lines linked via SIF_ID.
• OKL_SIF_STREAM_TYPES — stream type definitions linked via SIF_ID.
• OKL_SIF_YIELDS — yield calculation detail linked via SIF_ID.
• OKL_STREAM_TRX_DATA — transaction-level stream data linked via SIF_ID.
• OKL_SIF_TRX_PARMS — transaction parameter records linked via SIF_ID.

Together these child objects complete the interface picture, and joins through SIF_ID provide the primary means of traversing from contract header to detailed priced stream output.