Search Results okl_pools_all




Overview
Explore in AI Chat

Overview

The OKL_POOLS_ALL table is a core data object within Oracle E-Business Suite's Leasing and Finance Management (OKL) module, specifically in versions 12.1.1 and 12.2.2. It functions as the securitization pool header table. A securitization pool is a collection of financial assets, such as leases or loans, that are grouped together to back the issuance of securities. This table serves as the master record for each distinct pool, storing its defining attributes and administrative information. Its role is central to the securitization and asset-backed financing processes, enabling the management, tracking, and reporting on aggregated portfolios of contracts.

Key Information Stored

The table stores essential header-level data for each securitization pool. While the full column list is not detailed in the provided metadata, the structure indicates critical fields. The primary identifier is the ID column (the primary key). A unique business identifier is stored in POOL_NUMBER. The table maintains relationships to other key entities via foreign keys: KHR_ID links to the contract header (OKL_K_HEADERS), likely identifying a master or umbrella agreement, and POT_ID links to the OKL_POOL_TYPES table, classifying the pool. Other typical columns would include creation dates, status, effective dates, description, and attributes controlling the pool's behavior and accounting treatment.

Common Use Cases and Queries

This table is primarily accessed for pool administration, inquiry, and regulatory reporting. Common operational scenarios include creating a new securitization portfolio, querying the status and composition of existing pools, and generating reports for investors or internal analysis. Sample SQL patterns often involve joining to related tables to get a complete view. For instance, to list all active pools with their type description:

  • SELECT p.pool_number, p.description, pt.name as pool_type, p.status FROM okl_pools_all p, okl_pool_types pt WHERE p.pot_id = pt.id AND p.status = 'ACTIVE';

Another critical use case is tracing the contents of a specific pool by joining to the OKL_POOL_CONTENTS child table to list all contracts (assets) assigned to it.

Related Objects

OKL_POOLS_ALL has integral relationships with several other objects in the OKL schema, forming the core of the securitization data model. As per the metadata, key dependencies include:

  • OKL_POOL_TYPES: Referenced via POT_ID foreign key, provides classification for the pool.
  • OKL_K_HEADERS: Referenced via KHR_ID, links the pool to a lease or finance contract header.
  • OKL_POOL_CONTENTS: This table holds a foreign key (POL_ID) referencing OKL_POOLS_ALL.ID, storing the detailed list of individual assets (contracts) assigned to each pool.
  • OKL_POOL_TRANSACTIONS: Also references POL_ID, logging financial or administrative transactions against the pool.

These relationships ensure data integrity and enable comprehensive tracking from the pool header down to its constituent assets and all associated activities.