Search Results ghr_dual_proc_methods_pk




Overview
Explore in AI Chat

Overview

The HR.GHR_DUAL_PROC_METHODS table is a configuration table within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically for the U.S. Federal Human Resources (GHR) functionality. Its primary role is to govern the processing logic for overlapping personnel actions, known as dual actions. When two distinct Nature of Action (NOA) codes are processed concurrently for an employee, certain data fields may overlap. This table stores rules that determine which of the two action's values should take precedence for specific form fields, ensuring data integrity and correct processing outcomes in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to define precedence rules for overlapping fields. The DUAL_OVERLAP_ID column serves as the unique primary key, populated from the sequence GHR_DUAL_PROC_METHODS_S. The NOA_FAMILY_CODE links to the GHR_FAMILIES table, grouping related NOA codes. The core rule logic is defined by FIRST_NOA_PROC_METHOD and SECOND_NOA_PROC_METHOD, which specify the processing method (e.g., which NOA's data to use) for the first and second actions, respectively. The FORM_FIELD_NAME identifies the specific field on the form to which the rule applies. Standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track auditing information.

Common Use Cases and Queries

This table is critical during the automated processing of personnel transactions where dual actions are submitted. A common use case is when a personnel action affecting pay (like a step increase) and an action affecting position (like a reassignment) are processed simultaneously; rules in this table resolve which source provides data for fields like salary or duty station. Administrators may query this table to audit or maintain these rules. A foundational query to review all configured rules is:

SELECT NOA_FAMILY_CODE,
       FORM_FIELD_NAME,
       FIRST_NOA_PROC_METHOD,
       SECOND_NOA_PROC_METHOD
FROM   HR.GHR_DUAL_PROC_METHODS
ORDER BY NOA_FAMILY_CODE, FORM_FIELD_NAME;

For troubleshooting, one might join with GHR_FAMILIES to see the descriptive family name associated with each rule.

Related Objects

  • Primary Key: The table is uniquely identified by the GHR_DUAL_PROC_METHODS_PK index on the DUAL_OVERLAP_ID column.
  • Foreign Key: The GHR_DUAL_PROC_METHODS_FK index enforces a relationship to the HR.GHR_FAMILIES table via the NOA_FAMILY_CODE column, ensuring referential integrity for Nature of Action families.
  • Sequence: The primary key values are generated by the sequence GHR_DUAL_PROC_METHODS_S.
  • Dependencies: The table is referenced by database objects such as the synonym APPS.GHR_DUAL_PROC_METHODS and the view GHR_DUAL_PROC_METHODS_WHO, which likely provides a formatted view of the data including WHO column descriptions.