Results for “decision_status_code”

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

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:

• ID — Surrogate primary key (defined by OKL_SUBSIDY_POOLS_B_PK). Also appears in the unique index OKL_SUBSIDY_POOLS_B_U1.
• SUBSIDY_POOL_NAME — Business-key candidate, enforced by unique index OKL_SUBSIDY_POOLS_B_U2. Provides the user-visible pool identifier.
• SUBSIDY_POOL_ID — Pool reference column participating in the documented foreign key relationships. It is self-referencing and is the column targeted by child tables such as OKL_SUBSIDY_POOL_BUDGETS_B and OKL_TRX_SUBSIDY_POOLS.
• POOL_TYPE_CODE — Classifies the pool by funding or program type.
• EFFECTIVE_FROM_DATE and EFFECTIVE_TO_DATE — Define the active validity window during which the pool may be applied.
• CURRENCY_CODE and CURRENCY_CONVERSION_TYPE — Govern monetary amounts and the conversion rules applied to pool values.
• DECISION_STATUS_CODE and DECISION_DATE — Track the approval/decision workflow state and its date.
• REPORTING_POOL_LIMIT — The capped amount reported for the pool.
• TOTAL_BUDGETS and TOTAL_SUBSIDY_AMOUNT — Aggregate financial totals maintained for the pool.
• OBJECT_VERSION_NUMBER — Optimistic locking and concurrency control.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — Descriptive flexfield (DFF) storage.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit who-columns.

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.