EPY: Tax Distribution for Hourly Employees (Doc ID 638049.1)

Last updated on APRIL 11, 2024

Applies to:

Symptoms

 
Entered new record in JOB record to change the employee's empl_type to hourly.  Then went to that employee's tax distribution to change it from IL at 87.5% and MO at 12.5% to just IL at 100% effective the same date.  The tax distribution page gave an error, "Hourly employee require only one distribution record at 100%. (2000, 403)  Distribution percent equal to 100 must be entered for hourly employee."

Researched the PeopleCode module that handled this message and found it on record TAX_DIST_EFFDT, field EMPLID, module SaveEdit.  This code is executed for each row that exists for this employee.  It retrieves the employee's employee type from JOB using a SQLExec command.  It is retrieving the max effdt for the employee's JOB records.  That means if there is a future-dated record, that is the value retrieved.  It doesn't try to find the employee type that is effective on the date of the tax distribution being considered.

Is this legitimate? Can an hourly employee only have a tax distribution to one state?  Does PeopleSoft really want to look at just one employee type over the course of all distribution changes?  I'm looking for a second opinion on this questionable issue.  This may or may not be a bug.

Shouldn't the code be validating against the current JOB records rather the all records?

Changes

Cause

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