Search Results distribution_rule_id




Overview
Explore in AI Chat

Overview

The PSB_WS_DISTRIBUTION_RULES table is a core data repository within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master definition table for rules governing the automated distribution of worksheets and budget revisions. These rules are essential for top-down budgeting processes, enabling a parent budget group to systematically allocate budget amounts or revisions to its designated child budget groups. The table's primary role is to store the rule's metadata, which is then executed through related distribution objects to facilitate consistent and controlled budget propagation across an organization's hierarchy.

Key Information Stored

The table's structure is designed to capture rule definitions and standard auditing information. The most critical columns include the unique identifier, DISTRIBUTION_RULE_ID, which is the primary key for all related operations. The NAME column stores the user-defined identifier for the rule, while BUDGET_GROUP_ID is a mandatory foreign key linking the rule to a specific parent budget group in the PSB_BUDGET_GROUPS table. A series of ATTRIBUTE1 through ATTRIBUTE10 columns, along with a CONTEXT field, provide extensibility via Descriptive Flexfields (DFFs) to capture organization-specific rule attributes. Standard EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) complete the table, tracking all changes for audit purposes.

Common Use Cases and Queries

Primary use cases involve the creation, maintenance, and execution of distribution rules during budget formulation. Administrators define rules per budget group, which are then selected by users when distributing worksheet data. Common reporting and validation queries include listing all rules for a specific budget group or identifying rules that have not been recently updated. A fundamental query to retrieve core rule information is:

  • SELECT distribution_rule_id, name, budget_group_id, last_update_date FROM psb.psb_ws_distribution_rules WHERE budget_group_id = :p_bg_id ORDER BY name;

For troubleshooting distribution errors, a join to the child distribution lines table (PSB_WS_DISTRIBUTION_RULE_LINES) is essential to examine the full rule definition, including target groups and distribution percentages.

Related Objects

The PSB_WS_DISTRIBUTION_RULES table is central to the distribution workflow and has defined relationships with several key objects. It references the PSB_BUDGET_GROUPS table via its BUDGET_GROUP_ID column to validate the parent group. Crucially, two other tables hold foreign key references to its DISTRIBUTION_RULE_ID:

  • PSB_WS_DISTRIBUTIONS: This table references the rule, linking the rule definition to specific instances of distribution executions for worksheets or revisions.
  • PSB_WS_DISTRIBUTION_RULE_LINES: This child table references the rule, storing the detailed components that define *how* the distribution occurs, such as the target child budget groups and their respective allocation percentages or amounts.

These relationships underscore the table's role as the definitional source, with dependent objects managing the execution details and historical instances.