Search Results okl_cash_flows




Overview
Explore in AI Chat

Overview

The OKL_CASH_FLOWS table is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the OKL (Leasing and Finance Management) product module. It functions as a header-level table designed to store the primary details and metadata for cash flow structures. Cash flows are fundamental to lease and finance contracts, modeling the scheduled financial transactions such as payments, receipts, and fees over the life of an agreement. This table serves as the central reference point for a cash flow schedule, with its records linked to detailed line-level data in other related tables. Its existence is critical for the accurate calculation, forecasting, and accounting of all monetary streams associated with a contract.

Key Information Stored

While the provided metadata does not list specific columns beyond key relationships, the table's primary purpose is to store header attributes for a cash flow schedule. Based on its role and foreign key relationships, the table's critical columns typically include a unique identifier (ID), which serves as the primary key, and foreign key references to other master data entities. The most significant stored information includes the link to a cash flow object (via CFO_ID) which likely defines the overall financial structure, and the link to a stream type (via STY_ID) which categorizes the nature of the cash flow (e.g., rental, interest, residual value). Other common attributes in such a header table would be status, effective dates, version numbers, and identifiers linking the cash flow to a specific contract or financial product.

Common Use Cases and Queries

This table is central to financial reporting, contract management, and reconciliation processes within Oracle Lease Management. Common use cases include generating payment schedules for lessees, forecasting future cash receipts for portfolio analysis, and supporting the accounting engine for revenue and receivable recognition. A typical analytical query would join OKL_CASH_FLOWS to its detail lines and related master tables to produce a comprehensive cash flow report for a contract. For example, a query might retrieve all active cash flow headers for a specific lease contract to summarize total expected payments. Data from this table is also essential for integration with Oracle General Ledger and other financial subsystems, ensuring all contractual cash movements are properly reflected in the corporate books.

Related Objects

The OKL_CASH_FLOWS table maintains defined foreign key relationships with several other key OKL tables, as documented in the ETRM metadata:

  • OKL_CASH_FLOW_OBJECTS: The table is a child of OKL_CASH_FLOW_OBJECTS via the foreign key column OKL_CASH_FLOWS.CFO_ID. This links a specific cash flow instance to its broader cash flow object definition.
  • OKL_STRM_TYPE_B: The table references the stream type base table via OKL_CASH_FLOWS.STY_ID, classifying the cash flow's type.
  • OKL_CASH_FLOW_LEVELS: The OKL_CASH_FLOWS table is a parent to the OKL_CASH_FLOW_LEVELS table. The child table references it via the foreign key column OKL_CASH_FLOW_LEVELS.CAF_ID. This relationship connects the cash flow header to its detailed line items or level-specific data.