Search Results okl_strm_elements

Overview

The OKL_STRM_ELEMENTS table is a core transactional data object within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module. It serves as the detailed repository for the actual payment schedules associated with a financial stream. In the context of lease and loan contracts, a stream (header) defined in the OKL_STREAMS table is decomposed into its individual, time-based payment components, which are stored as records in this table. Each row represents a specific installment, fee, or charge element that constitutes the payment schedule, holding the critical financial details such as amounts and due dates. Its primary role is to support the generation, tracking, and accounting of all scheduled cash flows for lease and finance agreements.

Key Information Stored

While the full column list is not provided in the metadata, the documented primary and foreign keys indicate the essential data relationships and a subset of critical columns. The table's primary key is the ID column, which uniquely identifies each stream element record. The STM_ID column is a foreign key that links each element back to its parent payment stream in the OKL_STREAMS table. This relationship is fundamental, as all elements for a given contract stream share the same STM_ID. Based on its described purpose, the table typically stores columns for the element sequence number, due date, payment amount (split into principal, interest, fee components), tax amounts, and status flags indicating whether the element has been billed or paid. The unique key constraint on STM_ID (SEL_SEL_UK) suggests business logic to prevent duplicate scheduling logic.

Common Use Cases and Queries

This table is central to payment schedule reporting, dunning processes, and revenue recognition. A common operational query involves retrieving the payment schedule for a specific contract or stream for customer statements or internal review. For example, to list all upcoming unpaid elements for a stream, a query would join OKL_STREAMS and OKL_STRM_ELEMENTS, filtering on the stream identifier and a status column (e.g., WHERE stm_id = :p_stm_id AND status = 'OPEN' AND due_date < SYSDATE + 30). During the billing cycle, batch processes select elements due for invoicing based on their due date. The table is also a key source for amortization schedule reports, cash flow forecasting, and tax reporting, as tax details (via OKL_TAX_SOURCES) are linked directly to the individual stream element (SEL_ID).

Related Objects

• OKL_STREAMS: The primary parent table. The foreign key OKL_STRM_ELEMENTS.STM_ID references OKL_STREAMS.
• OKL_TAX_SOURCES and OKL_TAX_SOURCES_T: These tables hold tax details sourced from individual payment elements, linked via the SEL_ID foreign key.
• OKL_TXD_AR_LN_DTLS_B: This transactional accounting detail table references the stream element (SEL_ID), linking the schedule to its accounted journal entries.
• OKL_STRM_ELEMENTS_PK: The primary key constraint on the ID column.
• SEL_SEL_UK: The unique key constraint on the STM_ID column.