Search Results child_worksheet_id

Overview

The PSB_WS_DISTRIBUTION_DETAILS 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 functions as a mapping and tracking mechanism for the distribution and redistribution of budget worksheets and budget revisions across different organizational budget groups. Its primary role is to maintain the lineage and relationships between a source (or parent) worksheet and the child worksheets created for each target budget group during a distribution process. This enables the system to correctly propagate new line items to all relevant parent worksheets and to intelligently manage redistributions by identifying existing child worksheets.

Key Information Stored

The table's columns are designed to capture the critical identifiers that link distribution processes, worksheets, and budget groups. The mandatory DISTRIBUTION_ID is the foreign key to the master distribution header. The WORKSHEET_ID and GLOBAL_WORKSHEET_ID identify the specific source worksheet and its originating global worksheet, respectively. The two most operationally significant columns for tracking distributed data are CHILD_WORKSHEET_ID, which stores the unique identifier of the worksheet created for a specific budget group, and CHILD_BUDGET_GROUP_ID, which stores the unique identifier of that target budget group. This pair of columns is so critical for lookups that they are jointly indexed (PSB_WS_DISTRIBUTION_DETAIL_N3). The BUDGET_GROUP_RESP_ID column stores the responsibility associated with the budget group.

Common Use Cases and Queries

A primary use case is tracing all child worksheets generated from a specific source worksheet during a distribution run. This is essential for audit trails and impact analysis. Another common scenario is the reverse: identifying the parent source worksheet for a given child worksheet, which is used when adding lines to a child worksheet to determine all parent worksheets that must be updated. The table is also queried during redistribution to prevent duplicate child worksheet creation for a budget group. A sample query to find all child worksheets and their associated budget groups for a specific source worksheet would be:

• SELECT dd.child_worksheet_id, dd.child_budget_group_id, bg.budget_group_name FROM psb.psb_ws_distribution_details dd, psb.psb_budget_groups bg WHERE dd.worksheet_id = :p_source_worksheet_id AND dd.child_budget_group_id = bg.budget_group_id;

Reporting use cases include generating distribution summaries and validating the completeness of a distribution process across the organization's budget structure.

Related Objects

PSB_WS_DISTRIBUTION_DETAILS is centrally connected to several key PSB tables via foreign key constraints, forming the integrity backbone of the worksheet distribution functionality. Its relationships are:

• PSB_WS_DISTRIBUTIONS: The table references this header table via DISTRIBUTION_ID to link details to a specific distribution process instance.
• PSB_BUDGET_GROUPS: It references this master table via CHILD_BUDGET_GROUP_ID to validate and describe the target budget group for the distribution.
• PSB_WORKSHEETS: The table has two separate foreign key relationships to this core worksheet table. One references the WORKSHEET_ID of the source worksheet, and the other references the GLOBAL_WORKSHEET_ID.

The table's primary key is a composite of DISTRIBUTION_ID, WORKSHEET_ID, and CHILD_WORKSHEET_ID, ensuring a unique record for each child worksheet created per distribution and source worksheet combination.