Search Results psb_ws_distribution_rule_lines

Overview

The PSB_WS_DISTRIBUTION_RULE_LINES table is a core data object within the Oracle E-Business Suite Public Sector Budgeting (PSB) module, specifically for versions 12.1.1 and 12.2.2. It functions as a child table that defines the specific budget groups targeted for distribution within a budget worksheet distribution rule. Its primary role is to store the detailed line-level assignments that link a high-level distribution rule to the granular budget groups where budget amounts will be allocated. This table is essential for enabling the automated and rule-based distribution of budget figures across different organizational segments or funds during the budgeting process, a critical requirement in public sector financial planning.

Key Information Stored

The table's structure is designed to maintain the relationship between a distribution rule and its assigned budget groups. The most critical columns are its primary and foreign keys. The DISTRIBUTION_RULE_LINE_ID serves as the unique identifier for each record. The DISTRIBUTION_RULE_ID is a foreign key that links the line back to its parent rule defined in the PSB_WS_DISTRIBUTION_RULES table. The BUDGET_GROUP_ID is a foreign key that identifies the specific budget group from the PSB_BUDGET_GROUPS table that is included in this distribution rule line. Together, these columns create a many-to-one relationship, allowing a single distribution rule to be applied across multiple budget groups.

Common Use Cases and Queries

A primary use case is auditing and reporting on the configuration of budget distribution rules. Analysts may need to verify which budget groups are associated with a specific rule or identify all rules that impact a particular budget group. Common SQL queries involve joining to the parent rule and budget group tables to retrieve descriptive information. For example, to list all budget groups for a specific distribution rule named 'Q4_ALLOCATION', a typical query would be:

• SELECT bg.budget_group_name, bg.description FROM psb_ws_distribution_rule_lines lines, psb_budget_groups bg, psb_ws_distribution_rules rules WHERE lines.budget_group_id = bg.budget_group_id AND lines.distribution_rule_id = rules.distribution_rule_id AND rules.rule_name = 'Q4_ALLOCATION';

Another critical use case is during the budget worksheet distribution process itself, where the EBS application reads the lines associated with a rule to determine the target entities for financial allocation.

Related Objects

PSB_WS_DISTRIBUTION_RULE_LINES maintains documented foreign key relationships with two key tables in the PSB schema, forming a central link in the distribution rule data model.

• PSB_WS_DISTRIBUTION_RULES: This is the parent table. The relationship is defined by the column PSB_WS_DISTRIBUTION_RULE_LINES.DISTRIBUTION_RULE_ID, which references the PSB_WS_DISTRIBUTION_RULES table. This links each distribution rule line to its master rule definition.
• PSB_BUDGET_GROUPS: This table stores the definition of budget groups. The relationship is defined by the column PSB_WS_DISTRIBUTION_RULE_LINES.BUDGET_GROUP_ID, which references the PSB_BUDGET_GROUPS table. This links each line to the specific budgetary entity that will receive distributed amounts.

The table's primary key constraint, PSB_WS_DISTRI_RULE_LINES_PK, ensures the uniqueness of each DISTRIBUTION_RULE_LINE_ID.