Search Results psb_defaults




Overview
Explore in AI Chat

Overview

The PSB_DEFAULTS table is a core data structure within the Oracle E-Business Suite Public Sector Budgeting (PSB) module. It serves as the master repository for position default rules. These rules are critical configuration elements that automate the assignment of budgetary attributes, such as account distributions, to positions within an organization's hierarchy. By defining these defaults, the system streamlines the budget preparation and maintenance process, ensuring consistency and reducing manual data entry for positions that share common funding or accounting characteristics. Its role is foundational to the PSB module's position management and budgeting workflows.

Key Information Stored

The primary data stored in this table defines the default rule itself. The key column is DEFAULT_RULE_ID, which is the unique identifier (Primary Key) for each rule. While the provided ETRM excerpt does not list other specific columns, typical columns in such a rule-defining table would include fields to name the rule (e.g., RULE_NAME), describe its purpose (DESCRIPTION), indicate its status (ENABLED_FLAG), and specify effective dates (START_DATE, END_DATE). The table acts as the parent record for more detailed rule components stored in related child tables.

Common Use Cases and Queries

The primary use case is the setup and maintenance of position defaulting logic within Public Sector Budgeting. Administrators create and manage rules in this table to define how new or existing positions inherit default account distributions and other budgetary attributes. Common reporting and validation queries involve joining PSB_DEFAULTS with its related tables. For instance, to list all active default rules and their assigned account distributions, a query would join PSB_DEFAULTS to PSB_DEFAULT_ACCOUNT_DISTRS. A basic query to audit all defined rules would be:

  • SELECT DEFAULT_RULE_ID, RULE_NAME, DESCRIPTION, ENABLED_FLAG FROM PSB.PSB_DEFAULTS WHERE SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE);

Technical consultants often query this table to troubleshoot issues where positions are not receiving expected default values or to document system configurations.

Related Objects

The PSB_DEFAULTS table has a direct parent-child relationship with several other key PSB tables, as defined by its foreign key constraints. The DEFAULT_RULE_ID column is referenced by the following child tables, which store the specific components of each rule:

  • PSB_DEFAULT_ACCOUNT_DISTRS: Links default rules to specific accounting distributions (via DEFAULT_RULE_ID).
  • PSB_DEFAULT_ASSIGNMENTS: Links default rules to the positions or organizational units they apply to (via DEFAULT_RULE_ID).
  • PSB_SET_RELATIONS: Likely links default rules to other PSB set definitions or hierarchies (via DEFAULT_RULE_ID).

These relationships are critical for understanding the complete structure of a default rule, as the PSB_DEFAULTS table holds the header information, while the details are segmented into these related entities.