Search Results psb_allocrule_percents_u2

Overview

The table PSB.PSB_ALLOCRULE_PERCENTS is a core data structure within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, specifically for releases 12.1.1 and 12.2.2. Its primary role is to store the detailed percentage breakdowns for budget allocation rules that are defined using a percentage distribution method. This table enables the systematic spreading of a total budget amount across defined time periods—such as months, quarters, or semi-annual periods—within a fiscal year. It is integral to the budget formulation and allocation processes, ensuring financial plans are accurately distributed according to predefined temporal patterns. The table's design supports flexible periodicity, accommodating annual, quarterly, or semi-annual allocation schedules.

Key Information Stored

The table's columns store the essential data for defining and executing allocation spreads. The ALLOCATION_RULE_ID serves as the foreign key linking to the parent allocation rule definition. The NUMBER_OF_PERIODS column is critical, indicating the temporal granularity of the spread with values of 12 (Monthly), 4 (Quarterly), or 2 (Semi-Annual). For each period within that spread, the PERIOD_NUM identifies the sequence (e.g., 1 for January or Q1), and the PERCENT column holds the specific allocation percentage for that period. The unique identifier ALLOCATION_RULE_PERCENT_ID is the primary key. Standard Oracle EBS "Who" columns (CREATED_BY, LAST_UPDATE_DATE, etc.) track audit information, while descriptive flexfield columns (ATTRIBUTE1-4) allow for custom extensions.

Common Use Cases and Queries

A primary use case is configuring a budget allocation rule to distribute a yearly budget estimate across 12 months using a non-uniform pattern, such as allocating higher percentages to quarters with expected greater expenditure. This table is queried by the allocation engine during budget generation to apply the correct percentages. For reporting and validation, common SQL patterns include retrieving the full allocation schedule for a specific rule or verifying that the percentages for a rule sum to 100. For example, to audit a monthly allocation rule (ID = 1000), one might use:

• SELECT PERIOD_NUM, PERCENT FROM PSB.PSB_ALLOCRULE_PERCENTS WHERE ALLOCATION_RULE_ID = 1000 AND NUMBER_OF_PERIODS = 12 ORDER BY PERIOD_NUM;
• SELECT ALLOCATION_RULE_ID, SUM(PERCENT) AS TOTAL_PCT FROM PSB.PSB_ALLOCRULE_PERCENTS GROUP BY ALLOCATION_RULE_ID, NUMBER_OF_PERIODS HAVING SUM(PERCENT) != 100;

Regarding the user's search for "대물 사고 금액에 따라 할증 비율" (surcharge rate according to property accident amount), this specific table is not directly related to insurance surcharge calculations. Its function is strictly for budgetary allocation across time periods within the PSB module.

Related Objects

PSB_ALLOCRULE_PERCENTS is a child table with a direct foreign key relationship to a parent allocation rule definition table, as indicated by the ALLOCATION_RULE_ID column and the unique index PSB_ALLOCRULE_PERCENTS_U2. The primary related object is the table storing the master allocation rule headers, likely named PSB_ALLOCATION_RULES or similar, where ALLOCATION_RULE_ID is the primary key. The unique index PSB_ALLOCRULE_PERCENTS_U1 on ALLOCATION_RULE_PERCENT_ID enforces the table's primary key constraint. This table is referenced by the PSB module's allocation engine programs and may be accessed through dedicated public APIs for budget rule maintenance.