Results for “sil_id”

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

Overview

OKL_SIF_STREAM_TYPES is a transactional interface table in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, owned by the OKL schema. It holds the stream types that are generated for a transaction from the external pricing engine. When a lease or loan contract is priced externally, integrated pricing results are staged in the Sales Interface Framework (SIF) tables before being processed into the contract's stream schedule. This table records, for each priced transaction line, which stream type the external engine returned and how it relates to the originating fees, lines, and stream interface header.

The table is populated during the interface import cycle that consumes external pricing output and is subsequently read by the stream generation programs that build the contract's cash flow streams. Based on the foreign key topology documented in the ETRM metadata — four outbound foreign keys to OKL_SIF_FEES, OKL_STREAM_INTERFACES, OKL_SIF_LINES, and OKL_STRM_TYPE_B — the heuristic Data Vault classification for this object is a link. It should be modelled as a link table resolving relationships among the SIF interface header, the SIF line, the associated fee, and the stream type reference.

Key Information Stored

Twelve columns are documented for the 12.2.2 physical schema. The most significant are:

• ID — surrogate primary key (SIT_PK); also the sole unique index candidate documented (OKL_SIT_UK1).
• SIF_ID — foreign key to OKL_STREAM_INTERFACES, identifying the parent stream interface record for the transaction.
• SIL_ID — foreign key to OKL_SIF_LINES, tying the stream type to a specific interface line.
• SFE_ID — foreign key to OKL_SIF_FEES, associating the generated stream type with a fee row.
• STY_ID — foreign key to OKL_STRM_TYPE_B, the stream type definition (for example, rental, interest, or residual stream categories).
• PRICING_NAME — the pricing element or component name returned by the external pricing engine, used to trace the stream back to its pricing source.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

The composite uniqueness rule SIT_SIT_UK (SIF_ID, STY_ID, SIL_ID, SFE_ID) enforces that a stream type is recorded only once per combination of interface header, line, fee, and stream type, preventing duplicates during re-import of pricing results.

Common Use Cases and Queries

Typical usage centres on reconciliation of interface processing and diagnosis of missing streams on contracts. A common pattern joins the stream type table to its stream type definition to report what the pricing engine returned per interface and line:

• Reconcile incoming pricing results: select sif_id, sil_id, sty_id, pricing_name from okl_sif_stream_types where sif_id = :p_sif_id.
• Detect interface rows lacking a valid stream type by outer-joining OKL_STRM_TYPE_B and filtering on null.
• Trace a missing rental or fee stream back to the originating SIF line or fee using SIL_ID or SFE_ID.
• Report stream types generated per transaction by joining through OKL_STREAM_INTERFACES to the contract identifier.

Because this is an interface table, records are transient — they exist only until the interface is processed and purged, so point-in-time reporting should be based on the resulting contract-level stream tables once processing completes.

Related Objects

• OKL_STREAM_INTERFACES — parent interface header, joined on SIF_ID.
• OKL_SIF_LINES — interface line detail, joined on SIL_ID.
• OKL_SIF_FEES — staged fee records, joined on SFE_ID.
• OKL_STRM_TYPE_B — stream type definition, joined on STY_ID.
• OKL_SIF_HEADERS and the other SIF staging tables — sibling interface objects sharing the same import cycle.
• OKL_STREAMS and the stream generation concurrent programs — consumers of validated interface data.