Results for “array_type”

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

Overview

OKL_ST_MAP_YIELDS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL (Leasing and Finance Management) product family. Its validity status is VALID in both the 12.1.1 and 12.2.2 releases. The view is documented in the E-Business Suite Technical Reference Manual (ETRM) as a join between the yield configuration data held in OKL_SIF_YIELDS and the stream interface records held in OKL_STREAM_INTERFACES. Functionally, it presents the mapping between a named yield and the stream interface to which that yield applies, together with the parameters that govern how the yield value is calculated and applied.

In the leasing and finance data model, yields represent the interest or return rates used to calculate financing income over the life of a contract. The mapping view surfaces the association between those yields and the stream interfaces that generate contractual cash flows, making it a useful reference point for reporting, reconciliation, and diagnosis of yield-generation behavior.

Underlying Base Objects

The view is defined over two base objects, both referenced through synonyms to the APPS schema:

• OKL_SIF_YIELDS — the source of yield definitions, including the yield name, the index number used for ordering, and the SIF_ID that links to the stream interface.
• OKL_STREAM_INTERFACES — the source of the stream interface record, joined on OKL_STREAM_INTERFACES.ID = OKL_SIF_YIELDS.SIF_ID.

The join is an equijoin on the interface identifier, and the result set is ordered by OKL_SIF_YIELDS.INDEX_NUMBER. Because INDEX_NUMBER is used as the ORDER BY key, it is the natural sequencing column for any report or extract that requires yields to be presented in configured order.

Key Columns

• YIELD_NAME — the descriptive name assigned to the yield definition.
• INDEX_NUMBER — the sequencing index for the yield; also the ORDER BY column of the view definition.
• TRANSACTION_NUMBER — the parent transaction or contract number associated with the yield.
• SIF_ID — the identifier linking the yield to its stream interface record; sourced from OKL_SIF_YIELDS.SIF_ID.
• TARGET_VALUE — the target or result value that the yield calculation is intended to produce.
• METHOD — the method by which the yield value is derived.
• ROE_TYPE / ROE_BASE — the return-on-equity type and the base to which the return calculation is applied.
• ARRAY_TYPE — the array (rate table) type used in the calculation.
• COMPOUNDED_METHOD — the compounding convention applied.
• NOMINAL_YN / PRE_TAX_YN — flags indicating whether the yield is nominal and whether it is expressed on a pre-tax basis.
• SIY_TYPE — the stream interface yield type classification.

Common Use Cases and Queries

The view is typically queried for reporting on yield configuration and for reconciling yields against the stream interfaces they drive. Because the ORDER BY clause is embedded in the view, a simple SELECT returns rows in index order without additional sorting. A minimal query is:

• SELECT YIELD_NAME, INDEX_NUMBER, TRANSACTION_NUMBER, SIF_ID FROM OKL_ST_MAP_YIELDS_V;

To examine calculation attributes for a particular transaction:

• SELECT YIELD_NAME, INDEX_NUMBER, METHOD, ROE_TYPE, ROE_BASE, NOMINAL_YN, PRE_TAX_YN FROM OKL_ST_MAP_YIELDS_V WHERE TRANSACTION_NUMBER = :transaction_number ORDER BY INDEX_NUMBER;

To isolate only pre-tax yields on a stated basis:

• SELECT YIELD_NAME, INDEX_NUMBER, SIY_TYPE, TARGET_VALUE FROM OKL_ST_MAP_YIELDS_V WHERE PRE_TAX_YN = 'Y';

These queries support reconciliation of stream interface yields, verification that configured yields map to the expected SIF_ID, and extraction of yield parameters for downstream financial reporting. All access is read-only, as the object is a view over the two documented base objects.