Results for “psb_ws_distributions”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSB_WS_DISTRIBUTIONS is a transactional table within the Public Sector Budgeting (PSB) module of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. The table records information about each instance of worksheet distribution — that is, each occasion on which a budgeting worksheet was dispatched to participants in a budgeting cycle. It captures the distribution event itself, linking the worksheet being circulated to the distribution rule that governed how it was routed, together with timing, mode, and instruction attributes for that specific event.

The ETRM metadata classifies this object as obsolete and notes that it is not implemented in the reference database against which the documentation was generated. The table nonetheless remains part of the historical PSB schema, owned by the PSB schema, with 13 documented columns. A heuristic Data Vault classification derived from the foreign key structure describes the table as satellite-leaning. In modeling terms, this suggests the table behaves primarily as a satellite, holding descriptive, event-specific attributes that describe a parent distribution concept rather than acting as an independent hub or an associative link between two strong business entities. The worksheet reference and the distribution rule reference both function as context attributes around the distribution event.

Key Information Stored

The table is anchored by the surrogate primary key DISTRIBUTION_ID, which is enforced through the PSB_WS_DISTRIBUTIONS_PK constraint. The same column also appears in a unique index, PSB_WS_DISTRIBUTIONS_U1, making it the documented business-key candidate in addition to its role as the technical identifier. The columns most relevant to consumers of this table are:

• DISTRIBUTION_ID — primary key and unique business-key candidate; the identifier for a single distribution instance.
• DISTRIBUTION_RULE_ID — foreign key to PSB_WS_DISTRIBUTION_RULES, identifying the rule that determined routing and recipients.
• WORKSHEET_ID — foreign key to PSB_WORKSHEETS, identifying the worksheet that was distributed.
• DISTRIBUTION_DATE — the date on which the distribution occurred.
• DISTRIBUTED_FLAG — indicates whether the distribution has completed.
• DISTRIBUTION_OPTION_FLAG — records the distribution mode or option selected for this instance.
• DISTRIBUTION_INSTRUCTIONS — free-text instructions accompanying the distribution.
• REVISION_OPTION_FLAG — indicates whether a revised worksheet version was distributed.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns recording the most recent modification.
• CREATED_BY, CREATION_DATE — standard audit columns recording row creation.

The audit columns follow the conventional EBS _WHO pattern, though this table does not include the full WHO column set. DISTRIBUTION_ID is strictly a surrogate key; no natural business key beyond it is documented.

Common Use Cases and Queries

Reporting on this table typically answers questions such as which worksheets have been distributed in a given period, which distribution rule was used for each worksheet, and whether distribution has completed. A representative query joins the parent worksheet and rule tables:

• SELECT d.DISTRIBUTION_ID, d.WORKSHEET_ID, d.DISTRIBUTION_RULE_ID, d.DISTRIBUTION_DATE, d.DISTRIBUTED_FLAG FROM PSB_WS_DISTRIBUTIONS d WHERE d.DISTRIBUTION_DATE BETWEEN :p_start AND :p_end;
• Ensure the DISTRIBUTED_FLAG is filtered when reporting only completed distributions.
• Join to PSB_WS_DISTRIBUTION_DETAILS on DISTRIBUTION_ID to expand recipient-level detail for audit reporting.
• Group by DISTRIBUTION_RULE_ID to analyse which rules drive the greatest distribution volume.

Because the table is documented as obsolete and absent from the reference database, sites on 12.1.1 or 12.2.2 should confirm actual object existence in their instance before relying on these patterns; in many upgraded environments the PSB objects were superseded by later budgeting functionality.

Related Objects

The following objects have documented relationships to PSB_WS_DISTRIBUTIONS:

• PSB_WS_DISTRIBUTION_RULES — referenced through DISTRIBUTION_RULE_ID; the rule definition governing each distribution.
• PSB_WORKSHEETS — referenced through WORKSHEET_ID; the worksheet being distributed.
• PSB_WS_DISTRIBUTION_DETAILS — references this table via its DISTRIBUTION_ID column; holds detail rows for each distribution instance.
• PSB_WS_DISTRIBUTIONS_PK and PSB_WS_DISTRIBUTIONS_U1 — the primary key and unique index supporting DISTRIBUTION_ID.

These relationships position PSB_WS_DISTRIBUTIONS as the event-level header that ties a worksheet to its routing rule, with PSB_WS_DISTRIBUTION_DETAILS providing the subordinate detail.