Search Results okl_subsidy_pool_budgets_b




Overview
Explore in AI Chat

Overview

The OKL_SUBSIDY_POOL_BUDGETS_B table is a core transactional table within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It stores the budget lines associated with subsidy pools, capturing the funded amounts, decision outcomes, and effective dating that govern how subsidy funding is allocated across the lifecycle of a lease or finance contract. In EBS 12.1.1 and 12.2.2, this table operates within the OKL schema and is tightly coupled to the subsidy pool header data, which together form the subsidy management foundation used by leasing operations to track vendor or manufacturer incentive programs.

From a dimensional and Data Vault modeling perspective, the heuristic classification of this object is satellite-leaning. This suggests the table behaves primarily as a descriptive satellite attached to a parent business key, in this case the subsidy pool, rather than functioning as an independent hub or a pure link table. Each row carries descriptive attributes, effective dating, and decision state that qualify the parent subsidy pool record. Practitioners designing integration or warehouse extracts should treat OKL_SUBSIDY_POOL_BUDGETS_B as dependent descriptive data keyed by SUBSIDY_POOL_ID.

Key Information Stored

The table contains 30 documented columns. The most significant for functional and reporting purposes include the following:

  • ID — The surrogate primary key (OKL_SUBSIDY_POOL_BUDGETS_B_PK) uniquely identifying each budget line. A unique index, OKL_SUBSIDY_POOL_BUDGETS_B_U1, also exists on this column, confirming it as the sole documented business-key candidate.
  • SUBSIDY_POOL_ID — The foreign key linking each budget line to its parent record in OKL_SUBSIDY_POOLS_B. This is the principal join column and the business key inherited from the parent.
  • BUDGET_TYPE_CODE — Classifies the budget line (for example, by funding category or allocation type).
  • BUDGET_AMOUNT — The monetary value allocated to the budget line, central to subsidy fund tracking and consumption reporting.
  • DECISION_STATUS_CODE — Indicates the approval or disposition state of the budget line, such as pending, approved, or rejected.
  • DECISION_DATE — The date on which the budget decision was rendered, supporting audit and aging analysis.
  • EFFECTIVE_FROM_DATE — The date from which the budget line becomes effective, enabling date-effective queries.
  • NOTE — Free-text commentary attached to the budget line.
  • OBJECT_VERSION_NUMBER — Used by the EBS framework for optimistic locking during concurrent updates.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS extensibility (flexfield) columns allowing customer-specific descriptive data.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record provenance and change history.

Common Use Cases and Queries

Typical use cases include subsidy pool budget reporting, fund consumption reconciliation, approval workflow status monitoring, and integration feeds into financial or analytical systems. A common query retrieves all budget lines for a given pool:

SELECT b.ID, b.BUDGET_TYPE_CODE, b.BUDGET_AMOUNT, b.DECISION_STATUS_CODE, b.EFFECTIVE_FROM_DATE FROM OKL_SUBSIDY_POOL_BUDGETS_B b WHERE b.SUBSIDY_POOL_ID = :pool_id ORDER BY b.EFFECTIVE_FROM_DATE;

Reporting extracts often join to the translatable table to obtain the display name and to the pool header for organizational context. Aggregation queries summing BUDGET_AMOUNT by DECISION_STATUS_CODE or BUDGET_TYPE_CODE are routine for budget vs. approved-funding analysis. Date-effective filters on EFFECTIVE_FROM_DATE support point-in-time reporting required by auditors.

Related Objects

The most significant related objects are:

  • OKL_SUBSIDY_POOLS_B — The parent table; joined via OKL_SUBSIDY_POOL_BUDGETS_B.SUBSIDY_POOL_ID = OKL_SUBSIDY_POOLS_B.ID. This relationship defines the ownership of each budget line.
  • OKL_SUBSIDY_POOL_BUDGETS_TL — The translatable (language) table holding multilingual descriptive text; it references OKL_SUBSIDY_POOL_BUDGETS_B.ID via the column ID. Joined on ID to retrieve locale-specific descriptions.
  • OKL_SUBSIDY_POOL_BUDGETS_B_PK — The primary key constraint enforcing uniqueness of ID.
  • OKL_SUBSIDY_POOL_BUDGETS_B_U1 — The unique index on ID, the documented business-key candidate.
  • OKL_SUBSIDY_POOL_BUDGETS_B_N1 and related FK constraints — Index and constraint definitions supporting the SUBSIDY_POOL_ID relationship.
  • OKL_SUBSIDY_POOLS_TL — The translatable counterpart to the parent pool table, frequently joined alongside the budget tables in reporting queries requiring pool names.

Together these objects form the subsidy pool management sub-model within OKL, with OKL_SUBSIDY_POOL_BUDGETS_B serving as the operative satellite for budget decisions and amounts.