Results for “okl_sif_ret_levels_v”

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

Overview

OKL_SIF_RET_LEVELS_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, belonging to the OKL (Leasing and Finance Management) product family. It exposes the payment level records returned by an external pricing engine during the stream interface (SIF) process. When Oracle Leasing transmits a stream to an external pricing engine for rate or payment calculation, the engine returns structured payment levels that describe how a stream is divided across periods, including amounts, periodicity, advance/arrears treatment, and dates. This view provides a queryable, reporting-friendly representation of those returned levels without requiring direct access to the underlying base table.

The view's principal value lies in the stream interface attribute columns. The view projects fifteen generic columns, STREAM_INTERFACE_ATTRIBUTE1 through STREAM_INTERFACE_ATTRIBUTE15, alongside a RATE column. These attributes act as a flexible extension mechanism, allowing the pricing engine to return contract- or deal-specific values that do not map to the standard documented level fields. Because the columns are generically named, integrators frequently search for STREAM_INTERFACE_ATTRIBUTE1 to determine whether a given value returned by the engine is stored and available for downstream reporting, contract generation, or reconciliation.

Underlying Base Objects

The view is defined over a single base object, OKL_SIF_RET_LEVELS, exposed in the view text through the alias SRLB. In the documented metadata, OKL_SIF_RET_LEVELS is referenced as a synonym, with the view selecting directly from that underlying table. The view is a straightforward projection: it selects ROWID from the base table along with every documented column, without joins, unions, filters, aggregations, or expressions. Consequently, each row in OKL_SIF_RET_LEVELS_V corresponds one-to-one with a row in OKL_SIF_RET_LEVELS, and no data transformation occurs within the view itself.

Because the view is defined exclusively over OKL_SIF_RET_LEVELS, any row present in the base table appears in the view subject to standard Oracle EBS security applied at the base table level. The view does not itself enforce operating unit or role-based filtering.

Key Columns

• ID — Primary identifier of the returned level record.
• SIR_ID — Identifier linking the level to its parent stream interface return record.
• LEVEL_INDEX_NUMBER and INDEX_NUMBER — Positional identifiers that order the levels within the returned stream.
• LEVEL_TYPE — Classification of the payment level.
• NUMBER_OF_PERIODS, PERIOD, and DAYS_IN_PERIOD — Define the payment frequency and duration associated with the level.
• AMOUNT and RATE — The payment amount and rate returned for the level by the pricing engine.
• ADVANCE_OR_ARREARS — Indicates whether payments fall due at the beginning or end of each period.
• FIRST_PAYMENT_DATE — The date on which the first payment for the level is due.
• LOCK_LEVEL_STEP — Indicator relating to level locking behavior.
• STREAM_INTERFACE_ATTRIBUTE1 through STREAM_INTERFACE_ATTRIBUTE15 — Generic, context-dependent columns populated by the external pricing engine for values outside the standard level structure.
• OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN — Standard Oracle EBS audit and concurrency columns.

Common Use Cases and Queries

Typical uses include verifying what an external pricing engine returned for a given stream interface request, reconciling returned levels against contract terms, troubleshooting attribute-driven integrations, and extracting level data for reporting.

To inspect all levels for a specific stream interface return:

SELECT id, sir_id, level_index_number, level_type,
       number_of_periods, amount, rate, advance_or_arrears,
       first_payment_date, stream_interface_attribute1
FROM   apps.okl_sif_ret_levels_v
WHERE  sir_id = :p_sir_id
ORDER BY level_index_number;

To locate rows where the engine populated the first stream interface attribute:

SELECT id, sir_id, level_index_number, amount, rate,
       stream_interface_attribute1
FROM   apps.okl_sif_ret_levels_v
WHERE  stream_interface_attribute1 IS NOT NULL;

These queries illustrate the view's role as a transparent window onto OKL_SIF_RET_LEVELS: all columns, including the fifteen stream interface attributes and RATE, are available for selection, but no additional business logic is applied by the view.