Results for “okl_sif_yields”

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

Overview

OKL_SIF_YIELDS is a transaction-level satellite table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It stores the definitions of yields calculated for a lease or loan transaction by the external pricing engine, capturing the result set returned through the stream interface integration. The table sits downstream of OKL_STREAM_INTERFACES, which carries the inbound pricing payload, and records each yield dimension — method, rate of return basis, compounding rule, target value, and nominal or pre-tax indicators — associated with a given stream interface record.

Under the heuristic Data Vault classification derived from its foreign key structure, this object is satellite-leaning. It attaches descriptive, descriptive-context attributes (yields, methods, target values) to a parent business key represented by the stream interface, and it carries no independent hub or link semantics of its own. Implementations modeling OKL pricing data for analytics may therefore treat OKL_SIF_YIELDS as a satellite hanging off the OKL_STREAM_INTERFACES hub, keyed by SIF_ID.

The metadata classifies the object as VALID under schema OKL and documents a physical column count of 34, consistent between the 12.1.1 and 12.2.2 releases of the ETRM schema.

Key Information Stored

The table's most significant columns are as follows. The surrogate primary key is ID, exposed through the SIY_PK constraint. Business-key candidates are defined by unique indexes: SIY_SIY_UK and SIY_SIY_UK_1, both spanning SIF_ID and YIELD_NAME, and OKL_SIY_UK1 on ID. The combination of SIF_ID and YIELD_NAME is therefore the natural business key — it uniquely identifies a yield within a given stream interface and prevents duplicate yield definitions per transaction.

• ID — surrogate primary key; system-generated identifier for each yield row.
• SIF_ID — foreign key to OKL_STREAM_INTERFACES, linking the yield to its parent stream interface record.
• YIELD_NAME — the name of the yield returned by the pricing engine; part of the composite unique key.
• METHOD — the calculation method applied to derive the yield.
• ARRAY_TYPE — indicates the array or structure type of the yield result.
• ROE_TYPE and ROE_BASE — the rate-of-return type and the base against which the return is measured.
• COMPOUNDED_METHOD — the compounding convention applied.
• TARGET_VALUE — the target figure against which the calculated yield is compared or solved.
• INDEX_NUMBER — sequencing index for ordering yields within a stream.
• NOMINAL_YN and PRE_TAX_YN — flags indicating whether the yield is nominal and whether it is expressed on a pre-tax basis.
• SIY_TYPE — classification of the yield record.
• STREAM_INTERFACE_ATTRIBUTE01–15 — the descriptive flexfield (DFF) segment columns, carrying client-specific yield attributes.
• OBJECT_VERSION_NUMBER — optimistic locking column maintained by the framework.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical usage centers on reconstructing the pricing output for a transaction and auditing how yields were derived. A frequent pattern joins OKL_SIF_YIELDS to OKL_STREAM_INTERFACES on SIF_ID to resolve the contract or transaction context:

• Yield detail for a transaction: SELECT siy.yield_name, siy.method, siy.roe_type, siy.target_value FROM okl_sif_yields siy WHERE siy.sif_id = :sif_id ORDER BY siy.index_number;
• Yield listing with interface context: joining OKL_STREAM_INTERFACES on SIF_ID to report yields alongside the originating stream record.
• Audit and reconciliation reporting: filtering on LAST_UPDATE_DATE and LAST_UPDATED_BY to trace changes to yield definitions over time.
• Flexfield analysis: querying STREAM_INTERFACE_ATTRIBUTE01 through STREAM_INTERFACE_ATTRIBUTE15 for client-specific yield extensions.
• Pricing extraction feeds: selecting yields where PRE_TAX_YN or NOMINAL_YN matches a reporting basis.

Because the table is populated by the external pricing engine, it is generally treated as read-only reference data for reporting; direct DML is not recommended.

Related Objects

• OKL_STREAM_INTERFACES — parent table; OKL_SIF_YIELDS.SIF_ID references it. This is the primary join path and the hub to which the yields satellite attaches.
• OKL_STREAM_INTERFACE_ATTRIBUTES — sibling table holding attribute-level detail for the same stream interface.
• OKL_TRX_* contract tables — transaction and contract headers reached indirectly through the stream interface for reporting context.
• OKL_SIF_* interface tables — companion pricing-engine staging tables populated in the same integration cycle.
• OKL pricing APIs — the stream interface integration routines that insert yield rows into OKL_SIF_YIELDS.

These objects form the core of the OKL external pricing integration footprint and are typically queried together when analyzing yield calculation results.