Search Results budget_workflow_rule_id




Overview
Explore in AI Chat

Overview

The PSB.PSB_WF_REVIEW_GROUPS table is a core data object within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically for the Public Sector Budgeting (PSB) module. It functions as a critical junction table within the budget workflow engine, orchestrating the sequential routing of budget worksheets for review and approval. Its primary role is to store the ordered list of review groups to which a specific budget worksheet instance must be sent during the submission workflow process. This table ensures that worksheets follow the predefined, rule-based approval hierarchy established in the system, thereby enforcing budgetary controls and compliance.

Key Information Stored

The table's structure is designed to link a workflow instance, a workflow rule, and an ordered sequence of reviewers. The key columns are:

  • ITEM_KEY (VARCHAR2(240)): A mandatory, unique identifier for a specific instance of an item (a budget worksheet) as it progresses through the workflow process. This key links the review group sequence to a single worksheet submission.
  • BUDGET_WORKFLOW_RULE_ID (NUMBER(15)): The unique identifier for the budget workflow rule that governs the approval process. This column directly associates the review group sequence with the rule defined by the user's search parameter.
  • SEQUENCE (NUMBER(15)): Defines the precise order in which the worksheet must be routed to the designated review groups for a given workflow process. This number enforces the serial approval path.

Common Use Cases and Queries

This table is primarily accessed for workflow monitoring, audit reporting, and troubleshooting approval routing issues. A common operational query involves identifying the review path for a specific worksheet or all worksheets under a particular workflow rule. For instance, to audit the review sequence for all active worksheets governed by a specific budget workflow rule, one would execute:

SELECT ITEM_KEY, SEQUENCE FROM PSB.PSB_WF_REVIEW_GROUPS WHERE BUDGET_WORKFLOW_RULE_ID = :rule_id ORDER BY ITEM_KEY, SEQUENCE;

Another critical use case is diagnosing workflow stalls by joining this table with workflow runtime tables (via the ITEM_KEY) to see if a worksheet is stuck at a particular sequence. Reporting on approval chain design often involves aggregating data from this table by BUDGET_WORKFLOW_RULE_ID to analyze the typical length and structure of review hierarchies.

Related Objects

As per the provided dependency information, PSB.PSB_WF_REVIEW_GROUPS does not reference other objects but is referenced by the APPS synonym PSB_WF_REVIEW_GROUPS. This synonym allows for privileged access within the APPS schema. In a full architectural context, this table is intrinsically linked to other PSB workflow tables, such as those storing the workflow rules (likely keyed by BUDGET_WORKFLOW_RULE_ID) and the master worksheet data. The ITEM_KEY column is a foreign key to the Oracle Workflow engine's item instance tables (e.g., WF_ITEMS), which manage the state and history of the workflow process itself.