Search Results okl_pools




Overview
Explore in AI Chat

Overview

The OKL_POOLS table serves as the fundamental data structure for securitization pool management within Oracle E-Business Suite's Leasing and Finance Management (OKL) module. It functions as the header or master record for a securitization pool, which is a collection of leased assets or financial contracts grouped together for the purpose of raising capital, typically through the issuance of securities. This table is central to the securitization process, enabling organizations to manage, track, and report on pools of assets as distinct financial entities. Its role is to define the pool's core attributes and link it to the underlying contracts and its classification type.

Key Information Stored

Based on the provided ETRM metadata, the table's structure is defined by its primary keys and foreign key relationships. The primary identifier is the ID column, enforced by the POL_PK primary key constraint. A unique business identifier is stored in the POOL_NUMBER column, enforced by the POL_POL_UK unique key. Two critical foreign keys establish the table's core relationships: the KHR_ID column links the pool to a specific contract header in the OKL_K_HEADERS table, and the POT_ID column links the pool to a classification defined in the OKL_POOL_TYPES table. While specific descriptive columns are not listed in the excerpt, a typical implementation would include fields for pool name, description, status, creation date, and effective dates.

Common Use Cases and Queries

This table is primarily accessed for securitization administration and related reporting. Common operational use cases include creating a new pool for a securitization deal, querying the details of existing pools, and updating pool statuses throughout their lifecycle. For reporting, it is joined to related tables to analyze pool composition, performance, and exposure. A fundamental query pattern retrieves pool header information along with its type description and associated contract details.

SELECT pol.pool_number,
       pol.id,
       pot.name pool_type,
       khr.contract_number
FROM   okl_pools pol,
       okl_pool_types pot,
       okl_k_headers khr
WHERE  pol.pot_id = pot.id
AND    pol.khr_id = khr.id;

Another common scenario is identifying all pools of a specific type for audit or regulatory reporting purposes.

Related Objects

The OKL_POOLS table is a central node within the OKL data model for securitization. Its most direct dependencies, as per the metadata, are:

  • OKL_K_HEADERS: This foreign key relationship (OKL_POOLS.KHR_ID) ties the securitization pool to the master lease or finance contract from which the pooled assets are sourced.
  • OKL_POOL_TYPES: This foreign key relationship (OKL_POOLS.POT_ID) classifies the pool, allowing for categorization and differentiated processing rules based on pool type.
  • Child Tables: While not specified in the excerpt, it is architecturally typical for detail or line-level tables (e.g., for pool assets or cash flows) to reference OKL_POOLS.ID as a foreign key to associate specific items with a pool header.

It is critical to note the provided metadata states "Not implemented in this database," which may indicate the object is a standard Oracle reference structure that requires specific implementation and population for a given EBS instance.