Search Results okl_subsidy_pool_budgets_b_u1

Overview

The OKL.OKL_SUBSIDY_POOL_BUDGETS_B table is a core transactional entity within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module, also referred to as the Enterprise Tax, Revenue, and Lease Management (ETRM) family of applications. It stores the individual budget lines associated with subsidy pools, allowing organizations to record requests to add to or reduce from the total budget allocated to a given subsidy pool. Each row captures the requested budget amount, its effective date, and the approval or rejection decision made against that request. The table resides in the APPS_TS_TX_DATA tablespace with a default PCT Free of 10, consistent with standard EBS transaction data storage conventions. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is part of the standard OKL schema and is designated VALID with FND Design Data registered under OKL.OKL_SUBSIDY_POOL_BUDGETS_B.

From a Data Vault modeling perspective, the mined relationship structure suggests that this object is satellite-leaning. Its primary key is a single surrogate identifier, and it holds descriptive attributes (budget type, amounts, decision status, dates) that describe a parent entity — the subsidy pool — rather than acting as an independent hub or as a pure link between two hubs. This classification is heuristic and offered as a modeling suggestion only; the table functions as a standard transactional detail table in the EBS schema.

Key Information Stored

The table contains 30 documented columns. The most significant columns and their purposes are as follows:

• ID (NUMBER) — The surrogate primary key and unique identifier for each subsidy pool budget line. It is enforced by the unique index OKL_SUBSIDY_POOL_BUDGETS_B_U1 on the ID column, and is the business-key candidate for this table. Also referenced as the column behind the OKL_SUBSIDY_POOL_BUDGETS_B_PK primary key.
• SUBSIDY_POOL_ID (NUMBER) — Foreign key to the OKL_SUBSIDY_POOLS_B table, identifying the parent subsidy pool to which the budget line belongs. A non-unique index, OKL_SUBSIDY_POOL_BUDGETS_B_N1, supports queries by this column.
• BUDGET_TYPE_CODE (VARCHAR2, 30) — Indicates the nature of the budget line. Documented valid values are ADDITION and REDUCTION.
• BUDGET_AMOUNT (NUMBER) — The monetary amount requested to be added to or reduced from the total pool budget.
• EFFECTIVE_FROM_DATE (DATE) — The date from which the budget line becomes effective.
• DECISION_STATUS_CODE (VARCHAR2, 30) — Indicates whether the budget line has been approved or rejected.
• DECISION_DATE (DATE) — The date on which the approval or rejection decision was recorded.
• NOTE (VARCHAR2, 150) — Free-text notes associated with the budget line.
• OBJECT_VERSION_NUMBER (NUMBER) — Standard EBS optimistic locking and concurrency control column.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 (VARCHAR2) — Descriptive flexfield columns enabling client-specific extensions without schema changes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking row creation and modification.

Common Use Cases and Queries

Typical usage involves tracking budget adjustments against subsidy pools, reviewing pending approvals, and reporting on the cumulative effect of additions and reductions. For example, to list all budget lines for a specific subsidy pool:

• SELECT id, budget_type_code, budget_amount, effective_from_date, decision_status_code FROM okl.okl_subsidy_pool_budgets_b WHERE subsidy_pool_id = :pool_id ORDER BY effective_from_date;

To sum the approved budget changes per pool:

• SELECT subsidy_pool_id, SUM(DECODE(budget_type_code,'ADDITION',budget_amount,'REDUCTION',-budget_amount,0)) net_change FROM okl.okl_subsidy_pool_budgets_b WHERE decision_status_code = 'APPROVED' GROUP BY subsidy_pool_id;

To identify lines awaiting a decision, filter on decision_status_code and decision_date. Reporting views typically join this table to subsidy pool and translated name tables to present descriptive labels.

Related Objects

The following objects are the most significant in relation to this table:

• OKL_OKL_SUBSIDY_POOLS_B — Parent entity referenced through the SUBSIDY_POOL_ID foreign key.
• OKL_SUBSIDY_POOL_BUDGETS_TL — Translation table referencing OKL_SUBSIDY_POOL_BUDGETS_B.ID; holds language-specific descriptive text for budget lines.
• OKL_SUBSIDY_POOLS_B — The subsidy pool master table joined via SUBSIDY_POOL_ID.
• Standard OKL concurrent programs and PL/SQL APIs that create, approve, or reject subsidy pool budget lines.

These relationships make OKL_SUBSIDY_POOL_BUDGETS_B a key detail table for subsidy pool budget management within EBS Lease and Finance Management.