Results for “per_ri_workbench_items”

50+ results




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

Overview

PER_RI_WORKBENCH_ITEMS is a Human Resources (PER) module table within the Oracle E-Business Suite, owned by the HR schema. It stores the definition records for "Workbench items" — the configurable entries that populate the Oracle HRMS workbench user interface, most notably the Self-Service Human Resources (SSHR) workbench and related administrative workbenches. Each row defines a discrete item that can be presented to a user within a workbench, its ordering relative to sibling items, its hierarchical placement, and the menu through which it is reached. The table therefore acts as the structural backbone that maps functional HR transactions and menus into the navigable workbench experience.

Under a heuristic Data Vault classification mined from the foreign-key structure, PER_RI_WORKBENCH_ITEMS is modeled as a standalone entity. This reflects the limited outbound relationships documented for the table — it references FND_MENUS but is not itself the target of dependent foreign keys in the analyzed schema. From a modeling perspective, the table functions as a reference or configuration hub of workbench item definitions rather than a transactional fact.

Key Information Stored

The table comprises thirteen documented columns in the 12.2.2 physical schema. The core identity of each row is the business key WORKBENCH_ITEM_CODE, which is the sole column of the PER_RI_WORKBENCH_ITEMS_PK primary key. In the 12.2.2 schema, the unique index also includes ZD_EDITION_NAME, indicating an edition-aware uniqueness model consistent with Oracle's editioning strategy.

  • WORKBENCH_ITEM_CODE — the primary key and business identifier for each workbench item.
  • MENU_ID — foreign key to FND_MENUS, identifying the menu associated with the workbench item; this is the primary linkage to the navigation framework.
  • WORKBENCH_ITEM_SEQUENCE — controls the display order of the item within its workbench context.
  • WORKBENCH_PARENT_ITEM_CODE — self-referencing value establishing parent-child hierarchy among items.
  • WORKBENCH_ITEM_TYPE — classifies the nature of the item (for example, a route, function, or grouping).
  • WORKBENCH_ITEM_CREATION_DATE — the date the item definition was created.
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Applications framework.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns capturing the most recent change.
  • CREATED_BY, CREATION_DATE — standard WHO columns recording initial creation.
  • ZD_EDITION_NAME — editioning qualifier supporting the 12.2 online patching / edition-based redefinition model.

Common Use Cases and Queries

Administrators and technical consultants query this table to diagnose workbench rendering issues, verify menu-to-item mappings, and audit item sequencing. A typical diagnostic joins workbench items to their menus:

  • Identify items belonging to a specific menu: SELECT WORKBENCH_ITEM_CODE, WORKBENCH_ITEM_SEQUENCE, WORKBENCH_ITEM_TYPE FROM HR.PER_RI_WORKBENCH_ITEMS WHERE MENU_ID = :menu_id ORDER BY WORKBENCH_ITEM_SEQUENCE;
  • Resolve parent-child hierarchy by self-joining on WORKBENCH_PARENT_ITEM_CODE to display the workbench tree structure.
  • Audit recent configuration changes using LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.
  • Validate edition context by filtering on ZD_EDITION_NAME in a 12.2 online-patching environment.

These queries support functional configuration reviews, regression testing after patches, and troubleshooting when workbench items fail to appear for end users.

Related Objects

  • FND_MENUS — referenced through MENU_ID; the principal documented foreign-key relationship.
  • PER_RI_WORKBENCH_ITEMS (self-reference) — via WORKBENCH_PARENT_ITEM_CODE for hierarchical items.
  • FND_MENU_ENTRIES — menu entries corresponding to the referenced menus.
  • FND_FUNCTIONS — functions invoked by workbench items through the menu structure.
  • PER_RI_WORKBENCH_ITEMS_PK — the primary key constraint enforcing item uniqueness.

Together these objects form the navigation and workbench configuration layer that HRMS self-service relies upon.