Search Results allocation_rule_percent_id

Overview

The PSB_ALLOCRULE_PERCENTS table is a core data object within the Oracle E-Business Suite (EBS) module Public Sector Budgeting (PSB), which is documented as obsolete. This table is designed to store detailed allocation percentages for individual time periods, such as months or quarters, within a defined budget allocation rule. Its primary role is to support the distribution of budget amounts across a fiscal year according to a specified pattern, enabling more granular and period-specific budget planning and forecasting. The table's existence is critical for applications requiring temporal allocation of funds, though its implementation status, as noted in the provided metadata, may vary by database instance.

Key Information Stored

The table's structure is centered on linking allocation rules to their period-specific percentage breakdowns. The primary key is the column ALLOCATION_RULE_PERCENT_ID, which uniquely identifies each percentage record. A critical foreign key column is ALLOCATION_RULE_ID, which links each percentage entry back to its parent allocation rule definition, likely stored in a related table such as PSB_ALLOC_RULE or PSB_ENTITY as indicated by the foreign key relationship. While the full column list is not provided, typical data stored would include the period identifier (e.g., period number or name) and the corresponding allocation percentage for that period, allowing the system to prorate an annual budget amount into periodic installments.

Common Use Cases and Queries

The primary use case for this table is to retrieve or validate the period-by-period distribution for a given budget allocation rule. For instance, a financial report may need to calculate the budget amount allocated to a specific month. A common query would join PSB_ALLOCRULE_PERCENTS to its parent rule table to fetch all percentages for a rule, ordered by period. An example SQL pattern is:

• SELECT period_id, allocation_percent FROM psb_allocrule_percents WHERE allocation_rule_id = :rule_id ORDER BY period_num;

This data is essential for generating budget forecasts, performing period-end budget versus actual comparisons, and ensuring that allocation rules are applied correctly during budget journal generation or fund distribution processes.

Related Objects

Based on the provided foreign key metadata, PSB_ALLOCRULE_PERCENTS has a direct relationship with the PSB_ENTITY table via the ALLOCATION_RULE_ID column. This suggests that the parent allocation rule definition is stored within or referenced by the PSB_ENTITY table, which likely serves as a master table for various budgeting entities or rules. The documented primary key constraint, PSB_ALLCORULE_PERCENTS_PK, enforces uniqueness on the ALLOCATION_RULE_PERCENT_ID column. Given the module's context, this table may also be referenced by views or APIs responsible for budget calculation and allocation engine processes within the obsolete Public Sector Budgeting module.