Results for “okl_pools_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_POOLS_ALL is the securitization pool header table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It serves as the master record for each securitization pool created in the system, holding the defining attributes, financial totals, and status information that govern a pool throughout its lifecycle. In the context of leasing operations, a securitization pool groups a set of lease contracts or receivables that are bundled and managed together for financing, credit rating, and reconciliation purposes. The table is owned by the OKL schema and is flagged VALID in the ETRM 12.1.1 and 12.2.2 data models.

From a Data Vault modeling perspective (a heuristic inferred from the foreign-key structure), OKL_POOLS_ALL is classified as satellite-leaning. This suggests it primarily stores descriptive and measured attributes attached to a business key rather than acting as a pure hub or link. The business key around which pool records are organized is the POOL_NUMBER, while the surrogate identifier ID anchors the physical row.

Key Information Stored

The table exposes 44 documented columns. The most significant are summarized below.

• ID — Surrogate primary key, enforced by index OKL_POOLS_ALL_PK and unique index OKL_POOLS_ALL_U1. This column is the row identifier referenced by child tables.
• POOL_NUMBER — The user-visible business key, enforced by unique index OKL_POOLS_ALL_U2 (also documented as OKL_POOLS_ALL_UK1). It uniquely identifies a pool for external reporting and lookup.
• POT_ID — Foreign key to OKL_POOL_TYPES, classifying the pool by its type.
• KHR_ID — Foreign key to OKL_K_HEADERS, linking the pool to the relevant lease or contract header context.
• LEGAL_ENTITY_ID — Foreign key to FV_LEGAL_ENTITIES, identifying the legal entity that owns the pool.
• CURRENCY_CODE — Currency in which the pool's monetary balances are denominated.
• TOTAL_PRINCIPAL_AMOUNT and TOTAL_RECEIVABLE_AMOUNT — Aggregate principal and receivable balances associated with the pool.
• SECURITIES_CREDIT_RATING — Credit rating assigned to the issued securities backed by the pool.
• STATUS_CODE — Lifecycle state of the pool (for example, active, closed, or reconciled).
• DESCRIPTION and SHORT_DESCRIPTION — Descriptive text for reporting and identification.
• DATE_CREATED, DATE_LAST_UPDATED, DATE_LAST_RECONCILED, and DATE_TOTAL_PRINCIPAL_CALC — Milestone dates tracking pool establishment, maintenance, reconciliation, and principal calculation.
• DISPLAY_IN_LEASE_CENTER — Flag controlling whether the pool is exposed in the Lease Center user interface.
• ORG_ID — Multi-org operating unit identifier supporting EBS Multi-Org Access Control.

Standard EBS audit and concurrent-program columns (OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) and the 15 ATTRIBUTE columns provide extensibility and traceability.

Common Use Cases and Queries

The most frequent access pattern is retrieving pool header details by business key or by legal entity. For example:

SELECT p.pool_number, p.description, p.status_code, p.total_principal_amount, pt.pool_type_name FROM okl_pools_all p, okl_pool_types pt WHERE p.pot_id = pt.id AND p.pool_number = :pool_number;

Reporting on pool balances and credit ratings by legal entity supports securitization disclosure and treasury analysis. Reconciling DATE_LAST_RECONCILED against DATE_TOTAL_PRINCIPAL_CALC helps controllers validate that principal figures are current. Queries filtered on DISPLAY_IN_LEASE_CENTER drive Lease Center dashboards, while ORG_ID predicates are applied whenever Multi-Org security is in force. Aging and audit queries typically join to OKL_POOL_TRANSACTIONS to trace individual pool activity back to the header.

Related Objects

OKL_POOLS_ALL sits at the center of the securitization model and is referenced by several dependent tables and itself references configuration tables.

• OKL_POOL_CONTENTS — References OKL_POOLS_ALL via POL_ID; holds the individual contracts or items belonging to a pool.
• OKL_POOL_TRANSACTIONS — References OKL_POOLS_ALL via POL_ID; records financial transactions posted against the pool.
• OKL_POOL_TYPES — Referenced by OKL_POOLS_ALL.POT_ID; defines pool type classifications.
• OKL_K_HEADERS — Referenced by OKL_POOLS_ALL.KHR_ID; supplies contract/lease header context.
• FV_LEGAL_ENTITIES — Referenced by OKL_POOLS_ALL.LEGAL_ENTITY_ID; identifies the owning legal entity.

Together these relationships make OKL_POOLS_ALL the header anchor for pool membership, pool-level transaction detail, and legal-entity reporting within Oracle Leasing and Finance Management.