Search Results rvi_yn




Overview
Explore in AI Chat

Overview

APPS.OKL_ST_MAP_HEADER_V is a reporting and integration view within the Oracle Enterprise Contracts (formerly Oracle Lease and Finance Management) module of Oracle E-Business Suite. It exposes stream interface header information used by the ETRM (Enterprise Transaction and Revenue Management) subsystem, part of the broader Oracle Financials family. The view presents a denormalized projection of stream interface records, exposing financial, tax, pricing, and payment attributes associated with a stream transaction. Because it is owned by APPS and defined as a simple SELECT with no joins, predicates, or aggregations, it functions primarily as a stable, read-friendly interface layer over the underlying interface table.

The view's relevance to users searching for total_funding is direct: TOTAL_FUNDING is one of the columns explicitly projected by this view, making OKL_ST_MAP_HEADER_V a likely access point for reporting on the funded amount associated with a lease or finance stream interface record.

Underlying Base Objects

The view is defined over a single referenced base object: OKL_STREAM_INTERFACES, accessed through a SYNONYM in the APPS schema. The view definition performs no filtering, joins, or transformation of the underlying data — it is a one-to-one projection that selects a defined subset of columns from OKL_STREAM_INTERFACES. This design means that all rows present in the base interface table are visible through the view (subject to standard APPS schema privileges and any row-level security applied by the application). Consequently, changes made to the base table are immediately reflected through the view, and no materialization or caching is involved.

Because the base object is an interface table, records typically represent inbound or outbound transaction data staged for processing by the ETRM stream engine. The view should therefore be understood as a window into in-flight or historically staged interface data rather than a master reference or setup object.

Key Columns

The view exposes the following categories of columns, as documented in the ETRM 12.2.2 metadata:

Common Use Cases and Queries

Typical usage includes reconciliation of interface staging data, funding reporting, and troubleshooting of ETRM stream processing. A common query retrieves funding amounts for a given transaction:

SELECT TRANSACTION_NUMBER, TOTAL_FUNDING, LENDING_RATE, TERM, DATE_PROCESSED
  FROM APPS.OKL_ST_MAP_HEADER_V
 WHERE TRANSACTION_NUMBER = :transaction_number;

Another frequent pattern aggregates funding by country or processing date:

SELECT COUNTRY, SUM(TOTAL_FUNDING) total_funded
  FROM APPS.OKL_ST_MAP_HEADER_V
 GROUP BY COUNTRY;

Because the view is a thin projection, it is well suited for ad-hoc reporting, integration extracts, and BI Publisher data sources where stable column naming and simple structure are preferred over direct access to the interface table.