Search Results routing_list_id




Overview
Explore in AI Chat

Overview

The HR.GHR_ROUTING_LISTS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the US Federal Human Resources (GHR) module. It functions as a master definition table for routing lists, which are ordered sets of individuals or positions designated to review and approve personnel actions. These routing lists are critical for enforcing workflow and approval hierarchies in federal personnel processes, ensuring actions follow the correct chain of command and compliance protocols. The table's storage in the APPS_TS_SEED tablespace indicates its role as a foundational setup entity within the application.

Key Information Stored

The table stores the essential metadata that defines a routing list. The primary identifier, ROUTING_LIST_ID, is a system-generated sequence number serving as the unique key for all related records. The NAME column holds the user-defined identifier for the list. A critical relationship is established via the ROUTING_GROUP_ID, a foreign key linking the list to a specific routing group defined in the GHR_ROUTING_GROUPS table, allowing for logical categorization. The PRIMARY_ROUTING_LIST_FLAG designates a default or primary list within its group. Standard Oracle EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track the creation and modification history of each record.

Common Use Cases and Queries

This table is central to configuring and managing approval workflows. Administrators use it to create and maintain distinct routing lists for different types of personnel actions or organizational units. Common operational and reporting queries include retrieving all lists within a specific routing group or identifying the primary list for a group. Troubleshooting often involves tracing a specific routing list's usage by joining to its member and history tables.

  • Retrieve all routing lists for a specific routing group ID:

    SELECT * FROM hr.ghr_routing_lists WHERE routing_group_id = <group_id>;

  • Find the primary routing list for a group:

    SELECT name, routing_list_id FROM hr.ghr_routing_lists WHERE routing_group_id = <group_id> AND primary_routing_list_flag = 'Y';

  • Basic audit query to see recently modified lists:

    SELECT name, last_updated_by, last_update_date FROM hr.ghr_routing_lists ORDER BY last_update_date DESC;

Related Objects

The HR.GHR_ROUTING_LISTS table sits at the center of a key relationship hierarchy, as defined by its foreign key constraints. It is a child of GHR_ROUTING_GROUPS, inheriting its group context via the ROUTING_GROUP_ID column. It is a parent to several important transactional and setup tables, which reference its ROUTING_LIST_ID to enforce data integrity. These child objects include:

These relationships demonstrate that GHR_ROUTING_LISTS provides the master definition that is populated with members and then referenced throughout the lifecycle of personnel and position description workflows.