Search Results psb_ws_distribution_details




Overview
Explore in AI Chat

Overview

The PSB_WS_DISTRIBUTION_DETAILS table is a core data object within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module. It is designated as obsolete in the context of releases 12.1.1 and 12.2.2, indicating its functionality is deprecated and may be phased out in future versions. The table's primary role is to store granular transactional details for each instance of a worksheet distribution. In PSB, worksheet distributions are a mechanism for allocating or distributing budget amounts, often from a parent or source worksheet to one or more child worksheets or budget groups. This table acts as the child record, capturing the specific targets and relationships for a given distribution header.

Key Information Stored

The table's structure is defined by a composite primary key and several foreign key relationships. The primary key uniquely identifies a distribution detail record through a combination of three columns: DISTRIBUTION_ID, WORKSHEET_ID, and CHILD_WORKSHEET_ID. This structure implies that a single distribution transaction (DISTRIBUTION_ID) can involve multiple line items, each linking a specific source worksheet (WORKSHEET_ID) to a specific target or child worksheet (CHILD_WORKSHEET_ID). While the provided metadata does not list all columns, the foreign keys reveal other critical data points stored, including the CHILD_BUDGET_GROUP_ID for distributions targeting budget groups and the GLOBAL_WORKSHEET_ID, which may link to a master or template worksheet used in the distribution logic.

Common Use Cases and Queries

This table is central to auditing and reporting on budget distribution activities. Common use cases include tracing the lineage of budget figures from a consolidated worksheet down to its constituent parts, validating distribution rules, and generating reconciliation reports. A typical analytical query would join this table to its parent and related worksheet tables to summarize distributed amounts by source and target. For example, to list all distribution details for a specific source worksheet, one might use a SQL pattern such as: SELECT d.* FROM PSB_WS_DISTRIBUTION_DETAILS d WHERE d.WORKSHEET_ID = :source_ws_id. Given the module's obsolete status, direct operational use in new integrations is discouraged, but the table remains critical for historical reporting and data migration efforts from legacy PSB implementations.

Related Objects

The PSB_WS_DISTRIBUTION_DETAILS table maintains defined foreign key relationships with several other PSB tables, forming an integral part of the distribution data model. The documented relationships are:

  • PSB_WS_DISTRIBUTIONS: Joined via DISTRIBUTION_ID. This is the parent header table for the distribution transaction.
  • PSB_BUDGET_GROUPS: Joined via CHILD_BUDGET_GROUP_ID. Links the detail line to a specific target budget group.
  • PSB_WORKSHEETS (two relationships): Joined via WORKSHEET_ID (the source worksheet) and via GLOBAL_WORKSHEET_ID (a related global worksheet). A separate relationship exists via CHILD_WORKSHEET_ID, linking to the target worksheet.
These relationships enforce referential integrity and are essential for constructing accurate joins in any reporting or data extraction involving worksheet distribution details.