Search Results psb_ws_distribution_rules




Overview
Explore in AI Chat

Overview

The PSB_WS_DISTRIBUTION_RULES table is a core data object within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for defining and storing worksheet distribution rules associated with specific budget groups. These rules govern the automated allocation or distribution of budget amounts across different periods, accounts, or other dimensions during the budget preparation process. The table's primary role is to act as a control entity, linking a budget group to its detailed distribution definitions and the subsequent distribution transactions generated from those rules.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented relationships and keys indicate the critical data elements. The primary identifier is the DISTRIBUTION_RULE_ID, a unique system-generated key. A fundamental foreign key is BUDGET_GROUP_ID, which links each distribution rule to its parent budget group in the PSB_BUDGET_GROUPS table. This establishes the rule's scope and ownership. Other columns would typically store rule metadata such as the rule name, description, effective dates, status (e.g., active, inactive), and the distribution method (e.g., even spread, custom pattern). The table's structure is designed to hold the rule's header-level information, with granular details managed in related child tables.

Common Use Cases and Queries

This table is central to budget formulation workflows where automated budget spreading is required. A common use case involves generating reports to audit all distribution rules defined for a particular budget group or across the system. Administrators may query this table to troubleshoot issues with budget distributions or to validate rule setups before a budget cycle. A typical analytical query would join to the budget groups table to provide context.

Sample SQL Pattern:
SELECT rule.distribution_rule_id,
rule.rule_name,
bg.budget_group_name,
rule.status_code
FROM psb.psb_ws_distribution_rules rule,
psb.psb_budget_groups bg
WHERE rule.budget_group_id = bg.budget_group_id
AND bg.budget_group_name = '&GROUP_NAME';

Related Objects

The PSB_WS_DISTRIBUTION_RULES table is a pivotal node in the PSB data model, with defined relationships to several key tables.

  • Referenced Foreign Key (Parent): The table references PSB_BUDGET_GROUPS via the BUDGET_GROUP_ID column, establishing the rule's owning budget group.
  • Referencing Foreign Keys (Children):
    • PSB_WS_DISTRIBUTIONS: References DISTRIBUTION_RULE_ID. This table stores the actual distribution transactions or instances created when a rule is executed.
    • PSB_WS_DISTRIBUTION_RULE_LINES: References DISTRIBUTION_RULE_ID. This child table holds the detailed line-level instructions for the distribution, such as percentage or amount splits across periods.

These relationships form a hierarchy: PSB_BUDGET_GROUPS → PSB_WS_DISTRIBUTION_RULES → (PSB_WS_DISTRIBUTION_RULE_LINES, PSB_WS_DISTRIBUTIONS).