Search Results hr_assignment_set_amendments

Overview

The HR_ASSIGNMENT_SET_AMENDMENTS table is a core data structure within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically for versions 12.1.1 and 12.2.2. It functions as a rule definition table for assignment sets. An assignment set is a named grouping of employee assignments used to control data security and reporting visibility. This table stores the explicit inclusion and exclusion rules that define the specific assignments belonging to a given set. Its role is critical for configuring and maintaining the scope of HR data access for managers, payroll administrators, and other users, enabling precise control over which employee records are visible within processes like payroll runs, absence management, and reporting.

Key Information Stored

The table's primary purpose is to link individual assignments to an assignment set and define the rule type for that link. The key columns, as indicated by the primary and foreign key metadata, are ASSIGNMENT_SET_ID and ASSIGNMENT_ID. The ASSIGNMENT_SET_ID is a foreign key to the HR_ASSIGNMENT_SETS table, which stores the definition of the assignment set itself (e.g., name, description). The ASSIGNMENT_ID column holds the identifier for a specific employee assignment record. While the provided metadata does not list all columns, a typical implementation includes a column to indicate the rule type, such as 'INCLUDE' or 'EXCLUDE', which determines whether the specified assignment is explicitly added to or removed from the set's population. The primary key constraint ensures that the combination of an assignment set and a specific assignment is unique within this table.

Common Use Cases and Queries

A primary use case is auditing the composition of an assignment set to verify security rules. For instance, an administrator may need to list all explicitly included assignments for a set named 'US_PAYROLL'. A common query would join this table to HR_ASSIGNMENT_SETS and PER_ALL_ASSIGNMENTS_F.

SELECT hasa.assignment_set_id, has.assignment_set_name, hasa.assignment_id
FROM hr_assignment_set_amendments hasa
JOIN hr_assignment_sets has ON hasa.assignment_set_id = has.assignment_set_id
WHERE has.assignment_set_name = 'US_PAYROLL'
AND hasa.rule_type = 'INCLUDE';

Another critical scenario is during payroll or HR report execution, where the system queries this table to dynamically build the list of assignments in scope. Troubleshooting data visibility issues often involves checking this table for conflicting include/exclude rules that may be preventing an expected assignment from appearing in a set's results.

Related Objects

• HR_ASSIGNMENT_SETS: This is the parent table, as documented by the foreign key relationship. The column HR_ASSIGNMENT_SET_AMENDMENTS.ASSIGNMENT_SET_ID references HR_ASSIGNMENT_SETS.ASSIGNMENT_SET_ID. This relationship connects the amendment rules to the master definition of the assignment set.
• PER_ALL_ASSIGNMENTS_F: While not listed in the provided foreign key metadata, this is a fundamental related table. The ASSIGNMENT_ID column in HR_ASSIGNMENT_SET_AMENDMENTS typically references PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID to resolve the specific employee assignment details (person, job, position, etc.).
• HRMS Assignment Sets APIs: Programmatic creation and maintenance of assignment set rules, such as through the HR_ASSIGNMENT_SET_API, will internally read from and write to the HR_ASSIGNMENT_SET_AMENDMENTS table.