Search Results okl_subsidy_pools_b




Overview
Explore in AI Chat

Overview

OKL_SUBSIDY_POOLS_B is the base (non-translated) table in the Oracle Lease and Finance Management (OKL) module that stores subsidy pool data. Within Oracle EBS 12.1.1 and 12.2.2, subsidy pools represent the funding structures under which subsidies are allocated against lease and finance contracts, typically used by vendors, partners, or internal programs to offset the cost of favorable lease rates. This table functions as the master definition record for each pool, holding the pool identity, validity period, currency attributes, decision status, and aggregate financial totals.

From a Data Vault modeling perspective, the metadata classifies this object as hub-leaning. This is a modeling suggestion derived from the foreign key structure: the table carries a primary key entity identifier (ID) and is referenced as a parent by several dependent and child entities, which is characteristic of a hub that anchors a business concept around which satellites and links are organized. In practice, OKL_SUBSIDY_POOLS_B acts as the central reference point for subsidy pool configuration, with translation, budget, and transaction-assignment details stored in companion tables.

Key Information Stored

The table contains 35 documented columns. The most significant include:

The distinction between the surrogate key (ID, unique index U1) and the business-key candidate (SUBSIDY_POOL_NAME, unique index U2) is important for query design and data integration.

Common Use Cases and Queries

Typical usage centers on reporting active pools, monitoring budget consumption, and tracing subsidy applications to transactions.

  • Retrieving active subsidy pools for a given date: 
    SELECT id, subsidy_pool_name, pool_type_code, currency_code,
       reporting_pool_limit, total_subsidy_amount
FROM   okl.okl_subsidy_pools_b
WHERE  sysdate BETWEEN effective_from_date AND effective_to_date
AND    decision_status_code = 'APPROVED';
  • Translating pool names and descriptions for multilingual reporting through OKL_SUBSIDY_POOLS_TL joined on ID.
  • Comparing budgets against utilization by aggregating OKL_SUBSIDY_POOL_BUDGETS_B on SUBSIDY_POOL_ID.
  • Reconciling subsidies consumed at the transaction level via OKL_TRX_SUBSIDY_POOLS.
  • Tracking pools pending decision using DECISION_STATUS_CODE and DECISION_DATE.

Related Objects

The documented relationships identify the following significant dependent and referenced objects:

  • OKL_SUBSIDY_POOLS_TL — Translation table joined on ID = OKL_SUBSIDY_POOLS_TL.ID, supplying language-specific names and descriptions.
  • OKL_SUBSIDY_POOL_BUDGETS_B — Budget records joined on SUBSIDY_POOL_ID, detailing allocations per pool.
  • OKL_TRX_SUBSIDY_POOLS — Transaction-to-pool assignments joined on SUBSIDY_POOL_ID, linking subsidies to lease transactions.
  • OKL_SUBSIDY_POOLS_B (self) — Self-referencing relationship via SUBSIDY_POOL_ID, supporting hierarchical or derived pool definitions.

Together these objects form the subsidy pool data model within OKL, with OKL_SUBSIDY_POOLS_B serving as the hub record.