Search Results okl_stream_interfaces_v




Overview
Explore in AI Chat

Overview

OKL_STREAM_INTERFACES_V is an Oracle E-Business Suite (EBS) view owned by the APPS schema within the OKL – Lease and Finance Management product. It is classified as a valid database view and serves as a contract header–level interface object that exposes details required for external pricing processing. The view is a thin, read-oriented projection over its underlying base table, allowing external pricing engines, concurrent programs, and integration interfaces to consume lease contract header information without querying the transactional table directly.

The visible name maps directly to the OKL Stream Interfaces entity, which supports the interface between Oracle Lease Management and external pricing/rating systems. A user searching for the column date_sec_deposit_collected will find it exposed by this view as DATE_SEC_DEPOSIT_COLLECTED, carried through from the base table. Because the view presents all columns of the underlying table (including the ROWID-based ROW_ID and the STREAM_INTERFACE_ATTRIBUTE01 through 10 flex-style columns), it functions as the canonical reporting and integration surface for stream interface header data in EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The documented referenced base object is OKL_STREAM_INTERFACES, referenced through a synonym. The view definition is a direct SELECT from that table (aliased as SIFB), projecting each column with an explicit alias to produce the exposed attribute set. The leading columns include:

No joins, unions, or filter predicates are present in the documented view text; therefore the view maps one row to one base table row without aggregation or deduplication.

Key Columns

The most frequently referenced columns for external pricing are ID, TRANSACTION_NUMBER, and DEAL_TYPE, which identify and classify the contract header. SECURITY_DEPOSIT_AMOUNT and DATE_SEC_DEPOSIT_COLLECTED together describe the security deposit and the date on which it was collected — the latter being the column in the user's search. The SECURITY_DEPOSIT_AMOUNT value paired with DATE_SEC_DEPOSIT_COLLECTED is central to lease pricing and cash-flow projection.

Financial and term attributes include TOTAL_FUNDING, TERM, IMPLICIT_INTEREST_RATE, ADJUSTMENT_METHOD, ADJUST, and STRUCTURE. Codes such as COUNTRY, SIS_CODE, ORP_CODE, SIF_MODE, and KHR_ID support classification and routing. The ten STREAM_INTERFACE_ATTRIBUTE01–10 columns provide extensibility for external pricing fields not covered by the standard columns. Audit columns (REQUEST_ID, PROGRAM_ID, etc.) trace which concurrent process inserted or updated the record.

Common Use Cases and Queries

Typical uses include extracting unprocessed stream interface records for an external pricing run, reconciling security deposit collection dates, and auditing the source of records. Example queries:

  • Retrieve header records for a batch: SELECT id, transaction_number, deal_type FROM okl_stream_interfaces_v WHERE request_id = :p_request_id;
  • Check security deposit collection: SELECT id, security_deposit_amount, date_sec_deposit_collected FROM okl_stream_interfaces_v WHERE date_sec_deposit_collected IS NOT NULL;
  • Reconcile pricing template usage: SELECT pricing_template_name, COUNT(*) FROM okl_stream_interfaces_v GROUP BY pricing_template_name;

Because the view omits the application filter predicates found in secured views, users should always restrict queries (for example, by transaction number or request ID) and avoid full-table scans on large interface tables.