My Oracle Support Banner

Calculation Pay Table Data Segment Is Updated Erroneously On Non-Pay Setting Actions (Doc ID 2318970.1)

Last updated on JULY 07, 2020

Applies to:

Oracle US Federal Human Resources - Version 12.2 HRMS RUP4 and later
Information in this document applies to any platform.


On : 12.2 HRMS RUP4 version, Federal Payroll

Calculation Pay Table Data Segment is Updated Erroneously on Non-Pay Setting Actions

Modifications made in system to flow the value from Calculation Pay Table data segment to payroll for Pay Table ID when personnel actions are processed so payroll will reflect the pay table ID from which pay is calculated. Several times a year, HR and payroll conduct a payroll reconciliation in which Pay Table ID is one of the values that are compared for mismatches. HR users are seeing multiple mismatches for Pay Table ID. When records were reviewed, they were finding that the majority of the errors were around employee records on pay retention sitting on a special rate pay table (e.g. 0414).

Further research found when  HR users processed a NOA 894 for identified employees, Calculation Pay Table is updated to ‘0000; however when a non-pay affecting personnel transaction (e.g. NOAs 840, 849, 800, etc.) is processed for same employee, the data field Calculation Pay Table (in the People >E&M > Assignment > US Federal Assignment RPA) is being updated to the position pay table ID. This causes payroll recon issues that requires both HR and payroll interventions to update appropriate values.

Expect Calculation Pay Table data segment to be only updated on pay-affecting personnel transactions, not non-pay ones.

Background: Federal Workforce Flexibility Act of 2004 contains reforms relating to Federal human capital management, resulting in significant changes to the applicability of special rate schedules, locality pay, pay retention and pay setting. Oracle Federal Requirements document for FWFA Implementation, Pay Calculation and WGI calls for the establishment of a new data element called ‘Calculation Pay Table’ and will reflect the pay table number used in the pay calculation process. This data element will be located in the Assignment  Extra Information  US Federal Assignment RPA DDF and will be updated through the various RPAs that affect pay setting. Date-tracking DDF controls review of the value in this data element.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.