Results for “stream_element_date”

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

Overview

OKL_CS_SCHPRINC_BALANCE_UV is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the OKL product family — Oracle Leasing and Finance Management. The object is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2, and the metadata is identical across the two releases, reflecting the stability of the underlying leasing stream model. The view is a user-facing (UV) interface, meaning it exposes a simplified, reporting-oriented projection of the stream data model that is intended for consumption by reports, concurrent programs, and external integrations rather than by transactional forms.

The view answers a single, well-scoped business question: what are the current principal balance amounts recorded against active leasing streams? It isolates one stream purpose — PRINCIPAL_BALANCE — and one stream accounting status — CURR (current) — to produce a clean snapshot of principal balances over time, keyed by contract line entity (KLE_ID).

Underlying Base Objects

The view is defined over three base objects, all in the APPS schema and referenced through public synonyms: OKL_STREAMS, OKL_STRM_ELEMENTS, and OKL_STRM_TYPE_B. The joins are strictly inner joins across the stream hierarchy:

• OKL_STRM_TYPE_B provides the stream type definition. The view restricts this table with STREAM_TYPE_PURPOSE = 'PRINCIPAL_BALANCE', selecting only stream type definitions dedicated to principal balance tracking.
• OKL_STREAMS provides the stream instance. The view joins on STR_TYPE.ID = STRM.STY_ID and further filters on STRM.SAY_CODE = 'CURR', STRM.ACTIVE_YN = 'Y', and STRM.PURPOSE_CODE IS NULL.
• OKL_STRM_ELEMENTS provides the dated amounts. The join STR_ELM.STM_ID = STRM.ID links each stream element to its parent stream, so the result set is the historical series of principal balance amounts for each active current stream.

No aggregation or grouping is applied: the view returns one row per stream element.

Key Columns

• KLE_ID — The contract line entity identifier, sourced from OKL_STREAMS.KLE_ID. This is the principal join key to contract and line-level reporting in the leasing module.
• AMOUNT — The stream element amount from OKL_STRM_ELEMENTS.AMOUNT, representing the principal balance value for the associated element date.
• STREAM_ELEMENT_DATE — The effective date of the stream element, from OKL_STRM_ELEMENTS.STREAM_ELEMENT_DATE. Because the view does not aggregate, consumers must select the appropriate date when reporting a point-in-time balance.

Common Use Cases and Queries

The view is typically used to derive the latest principal balance per contract line, to reconcile balances against the lease accounting schedules, and to feed downstream reporting extracts. A representative query obtains the most recent balance per KLE:

• Latest balance per contract line: SELECT kle_id, amount, stream_element_date FROM okl_cs_schprinc_balance_uv a WHERE stream_element_date = (SELECT MAX(stream_element_date) FROM okl_cs_schprinc_balance_uv b WHERE b.kle_id = a.kle_id);
• Balance as of a date: filter STREAM_ELEMENT_DATE <= :p_as_of_date and select the maximum date per KLE to obtain the point-in-time balance.
• Contract-level reporting: join KLE_ID to the leasing contract and line tables to present principal balances alongside contract terms and counterparty information.
• Reconciliation extracts: compare summed AMOUNT values by KLE against calculated amortization schedules to detect variances.

Because the view is a simple, non-aggregated projection over current, active principal balance streams, it is inexpensive to query and safe for read-only integration. It carries Oracle proprietary and confidential status, so its use should remain confined to licensed environments.