Search Results psb_wf_review_groups




Overview
Explore in AI Chat

Overview

The PSB_WF_REVIEW_GROUPS table is a data object within the Oracle E-Business Suite (EBS) Public Sector Budgeting (PSB) module, which is documented as obsolete. Its primary role is to manage the workflow routing configuration for budget worksheets during the submission and approval process. Specifically, it stores the list of review groups to which a budget worksheet is sent for approval as part of a defined budget workflow rule. This table functions as a child entity, linking a specific workflow rule to one or more approval groups, thereby defining the sequential or parallel review path for a budgeting transaction. Its existence is critical for enforcing budgetary controls and approval hierarchies within the now-obsolete PSB module.

Key Information Stored

The table's structure is designed to map workflow rules to their assigned review groups. Based on the provided metadata, the key columns include the composite primary key and a critical foreign key. The BUDGET_WORKFLOW_RULE_ID is the pivotal foreign key column that links each record directly to a specific rule defined in the PSB_BUDGET_WORKFLOW_RULES table. The ITEM_KEY column, part of the primary key alongside BUDGET_WORKFLOW_RULE_ID, typically serves as a unique identifier for a specific instance or step within the review group assignment, potentially allowing for ordering or conditional logic. The table's primary purpose is to store the association between these two identifiers, defining which groups participate in the workflow for a given rule.

Common Use Cases and Queries

A primary use case involves auditing or troubleshooting the approval routing for budget submissions. Administrators or support personnel might query this table to understand all review groups assigned to a particular workflow rule, especially when diagnosing why a worksheet is routed to specific individuals. A sample query to retrieve this mapping would be:

  • SELECT budget_workflow_rule_id, item_key FROM psb_wf_review_groups WHERE budget_workflow_rule_id = :rule_id ORDER BY item_key;

Another common scenario is during the decommissioning or data migration of the obsolete PSB module, where identifying all configuration dependencies is necessary. Queries joining to PSB_BUDGET_WORKFLOW_RULES would be used to generate comprehensive reports on the entire workflow rule setup, including associated review groups. The metadata note "Not implemented in this database" indicates that in many instances, this table may exist in the data dictionary but contain no application data.

Related Objects

The most significant related object, as defined by the foreign key constraint, is the PSB_BUDGET_WORKFLOW_RULES table. This parent table stores the master definition of the workflow rules themselves, to which the review groups are attached. The relationship is enforced by the foreign key on PSB_WF_REVIEW_GROUPS.BUDGET_WORKFLOW_RULE_ID referencing PSB_BUDGET_WORKFLOW_RULES. Given the workflow nature of the data, it is also logically related to the underlying Oracle Workflow engine tables and to the security tables (such as FND_USER or FND_RESPONSIBILITY) that define the members of the review groups referenced by the ITEM_KEY, though these are not explicit foreign keys in the provided metadata.