Search Results psb_ws_distributions




Overview
Explore in AI Chat

Overview

The PSB_WS_DISTRIBUTIONS table is a core data object within the now-obsolete Public Sector Budgeting (PSB) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functioned as the master transactional table for storing each unique instance of a budget worksheet distribution. In the context of public sector budgeting workflows, a distribution represents the application of a predefined allocation rule to a specific budget worksheet, facilitating the automated or manual spreading of budget amounts across multiple accounting periods, funds, or other dimensions. This table served as the critical link between the high-level worksheet and the detailed distribution lines, centralizing the control and tracking of these allocation events.

Key Information Stored

While the full column list is not provided in the metadata, the documented primary and foreign keys reveal the essential structural data points. The primary key, DISTRIBUTION_ID, uniquely identifies each distribution instance. The table stores the foreign key WORKSHEET_ID, linking the distribution to its parent budget entry in the PSB_WORKSHEETS table. It also stores DISTRIBUTION_RULE_ID, which references the PSB_WS_DISTRIBUTION_RULES table to identify the specific allocation logic (e.g., even spread, custom percentages) applied. Additional columns, not detailed in the excerpt, would typically store control information such as creation date, status, total distributed amount, and user identifiers for audit purposes.

Common Use Cases and Queries

This table was central to auditing distribution history and troubleshooting budget allocation results. Common operational and reporting queries would involve joining to related tables to provide a comprehensive view. A typical pattern would be to retrieve all distributions for a specific worksheet or to analyze the usage of a particular distribution rule. For instance, to audit all distributions on a worksheet, a query would join PSB_WS_DISTRIBUTIONS to PSB_WORKSHEETS and PSB_WS_DISTRIBUTION_RULES. Furthermore, to obtain the detailed accounting lines resulting from a distribution, queries would join from this table to the child PSB_WS_DISTRIBUTION_DETAILS table using the DISTRIBUTION_ID. Reporting use cases included tracking distribution frequency, validating that worksheets had undergone required allocation steps, and reconciling high-level worksheet amounts to the sum of their distributed details.

Related Objects

The PSB_WS_DISTRIBUTIONS table exists within a defined hierarchy of PSB objects, as evidenced by its foreign key relationships. It is a child table, referencing two parent tables:

  • PSB_WORKSHEETS via the column PSB_WS_DISTRIBUTIONS.WORKSHEET_ID.
  • PSB_WS_DISTRIBUTION_RULES via the column PSB_WS_DISTRIBUTIONS.DISTRIBUTION_RULE_ID.
Conversely, it acts as a parent table to one key child table:
  • PSB_WS_DISTRIBUTION_DETAILS is referenced via its column PSB_WS_DISTRIBUTION_DETAILS.DISTRIBUTION_ID, which points to PSB_WS_DISTRIBUTIONS.DISTRIBUTION_ID. This relationship stores the granular accounting flexfield and period-specific amounts generated by the distribution instance.
This structure confirms PSB_WS_DISTRIBUTIONS as the central entity connecting budget worksheets, allocation rules, and the resulting detailed distribution lines.