Search Results psb_default_account_distr_pk

Overview

The PSB_DEFAULT_ACCOUNT_DISTRS table is a core data object within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It functions as a detail table that stores the specific account distribution lines associated with a default budgeting rule. In the context of budget formulation and control, default rules automate the allocation of budget amounts across various accounting segments (e.g., cost centers, natural accounts, projects). This table physically stores the predefined cost distribution patterns, enabling the system to automatically generate budget journal lines based on the characteristics of a source transaction or budget entry, thereby ensuring consistency and efficiency in the budgeting process for public sector entities.

Key Information Stored

The table's primary purpose is to map a default rule to one or more general ledger (GL) account code combinations and their respective distribution percentages or amounts. While the full column list is not detailed in the provided metadata, the documented structure reveals critical identifiers. The ACCOUNT_DISTRIBUTION_ID column serves as the unique primary key for each distribution line. The DEFAULT_RULE_ID is the foreign key that links each distribution line back to its parent rule defined in the PSB_DEFAULTS table. Other typical columns in such a structure would include the GL account code combination (likely CODE_COMBINATION_ID), a distribution percentage (PERCENT), and potentially a distribution amount, along with sequencing and enabled flags to control the order and activity status of each distribution line.

Common Use Cases and Queries

This table is central to operations where automated budget distributions are required. A primary use case is during budget entry or mass budget uploads, where the system references the associated default rule to split a single budget amount across multiple GL accounts according to the predefined splits stored in this table. For troubleshooting and audit reporting, common queries involve joining to the PSB_DEFAULTS table to review all account distributions for a specific rule. A typical analytical SQL pattern would be:

• SELECT d.default_rule_name, dad.* FROM psb_default_account_distrs dad, psb_defaults d WHERE dad.default_rule_id = d.default_rule_id AND d.default_rule_name = '&RULE_NAME';

Data fixes or updates to distribution percentages for active budgeting rules would also directly target records in this table, based on the ACCOUNT_DISTRIBUTION_ID or DEFAULT_RULE_ID.

Related Objects

The PSB_DEFAULT_ACCOUNT_DISTRS table maintains a strict hierarchical relationship within the PSB schema. Its sole documented foreign key relationship is as a child to the PSB_DEFAULTS table. The join is performed on the column PSB_DEFAULT_ACCOUNT_DISTRS.DEFAULT_RULE_ID referencing the primary key in PSB_DEFAULTS. This relationship ensures that every account distribution is explicitly tied to a valid, higher-level default rule. The table is itself protected by a primary key constraint named PSB_DEFAULT_ACCOUNT_DISTR_PK on the ACCOUNT_DISTRIBUTION_ID column. It is a foundational object for the PSB module's default rule engine and is likely referenced by various budgeting APIs and public sector budgeting reports.