From: Pat Keeley PKeeley@amctheatres.com
Date: Mon, 14 Jun 1999 13:38:20 -0500
I received this notice from the American Payroll Association. I understand that Oracle has a patch for this.
For the notice please
401k money - how often to capture
Subject: [orahrms-l] 401k money - how often to capture
From: "Menke, Irene M." menke@Mail.Donaldson.com
Date: Fri, 4 Jun 1999 11:50:17 -0500
Hello,
We are currently using an HRMS system which makes it very easy for us to
identify which money
i.e., contributions, loans and matches need to go to our Vendor - never
missing any or capturing any more than once.
Now the issue. We are implementing HRMS - HR and Payroll
We know the results of a payrun are in the pay_run_results.
We have come up with two ways to capture money to send to our Vendor.
1. Use system date minus 7 following a payrun and capture all entries with
a pay_period_end_date which falls into the range
2. Use pay_period_end_date for the majority of the entries which have come
from the payrun
and then design a separate process to run daily which captures quick pays
and writes this info to a temp table which will be included in the next send
to our Vendor.
We have a couple of issues
1. Never miss an element
2. Never capture an element more than once
3. Never miss a quick ck or a void.
I would love to discuss this with anyone who has figured this out.
Friday - June 4- I can be reached at 847.478.8762 or Monday Jun 7- @
612.887.3605.
Thank you to everyone for your thoughts!!
Irene Menke
menke@mail.donaldson.com
612.887.3605
401k Feedback from vendor
Subject: [orahrms-l] 401k Feedback from Vendor to HRMS- 401k Ques # 2
From: "Menke, Irene M." menke@Mail.Donaldson.com
Date: Fri, 4 Jun 1999 12:49:49 -0500
Hello,
I have a second question to pose to this forum.
Once a week our 401k vendor sends us a file for us to update employee
deferral percentage elements and loan elements.
If an employee has a 401k element and is currently deducting say 10% of
their pay - then calls the vendor and requests their deferral % to be set to
0% for a while and the vendor informs us via an electronic file that the
deferral % is now 0% or
if an employee has a 401k loan and the vendor informs us via an electronic
file that the loan has now been paid and we need to zero amount the element
two issues have come up.
1. we cannot have an 401k element with a deferral % of zero without it
being end-dated and paymix will not end date an element
2. we cannot have a 401k loan element with an amount of zero - without it
being end-dated and paymix will not end date an element.
We realize we can go into element_entries_ table and end date these elements
if the above happens - but our company policy is to not directly go into
tables and update --- instead they would like us to use an application
process .
We do not have the option of manually keying in these scenarios - as that
would be going backward and is not an option.
Could anyone tell me - how they are handling this. Your thoughts are very
much appreciated.
I can be reached - Fri - June 4th @ 847.478.8762 or Monday- June 7th @
612.887.3605 or via email. Thank you again.
Irene Menke
menke@mail.donaldson.com
612.887.3605
Subject: Re: [orahrms-l] 401k Feedback from Vendor to HRMS- 401k Ques # 2
From: AKGeorge99@aol.com
Date: Sat, 5 Jun 1999 17:37:54 EDT
Hi Irene,
I realized after I responded to your question that the project I was thinking
of actually implemented a modification to standard functionality in order to
accomplish this. Unfortunately, my earlier misleading response had already
been posted to the list. Sorry for any confusion caused.
Sincerely,
Alice
Setup steps for 401k deductions
Subject: [orahrms-l] 401K deductions
From: "Michael Scott" mscott@goodegg.com
Date: Sat, 5 Jun 1999 13:24:35 -0400
Need some help with the 401k deductions. Trying to withhold from earnings
other then regular wages and salaries, but have not been able to do so yet
by altering classification and types. Does anyone have any insight into
the setup of 401k eligible elements.
Thanks
MS
Using ADE for hourly wages COLA increase
Subject: [orahrms-l] Using ADE for hourly wage COLA increase
From: "Gerald, Karen" kGerald@wssc.dst.md.us
Date: Fri, 4 Jun 1999 15:32:28 -0400
Hi All-
1. We are attempting to use ADE to apply a $0.31 cost of living increase to
our hourly wage employees. We can successfully export the data from Oracle
to Excel with ADE, fill in the increase amount & effective date on the
spreadsheet and upload it back to Oracle via ADE. The problem is when we
look at an employee's salary screen, the New (salary) Amount does not
reflect any increase. The Change Amount and Change Percent show zero.
The Components section at the bottom of the salary page does show the reason
as Cost of Living and accurately shows the Change Amount as $0.31, so we
know that part of the ADE process is working.
The ADE process works fine for our salaried employees, who received a $638
increase. Any suggestions on how to apply the $0.31 hourly wage increase
via ADE will be greatly appreciated.
2. Does anyone know of a way to approve salary changes in mass, as opposed
to approving each employee's new salary one by one by navigating to their
salary screen and clicking on the Approved Box?
Sincerely,
Karen Gerald
WSSC Human Resource Division
(301) 206-8691
Kgerald@WSSC.dst.md.us
Subject: Re: [orahrms-l] Using ADE for hourly wage COLA increase
From: Kit Stephenson kstephen@earthlink.net
Date: Fri, 04 Jun 1999 16:50:05 -0500
Hi Karen,
#1 - Have you approved the change on the employee that you are viewing? You
may need to approve, save and requery the record to see the change take
effect.
#2 - If you have the 'Approve' button on the Salary Management Folder (your
System Administrator can do this) you can query the proposals that you want
to approve and approve them there. You have to hightlight the ones to
approve by Clicking left mouse button; as in most Windows apps, you can
Highlight the first and go to the last and Shift-Leftclick for all lines.
I think you can also indivually Ctrl-click to individually select. (I am
writing from memory here so you may have to play with Shift-clicking).
Hope this helps.
Kit
Changes in Group-Term Life (GTL) Insurance Premium rates
Subject: [orahrms-l] Changes in GTL rates
From: Pat Keeley PKeeley@amctheatres.com
Date: Mon, 14 Jun 1999 13:38:20 -0500
I received this notice from the American Payroll Association. I understand
that Oracle has a patch for this.
For the notice please
Subject: RE: [orahrms-l] Changes in GTL rates
From: "Smith, Amy" Amy.Smith@fmr.com
Date: Mon, 14 Jun 1999 14:53:29 -0400
The patch number is 794420, but I don't think it's
been released yet - I don't see it out on their ftp server yet...
Amy Smith
Application Support - Oracle HRMS
Phone: (603) 791-7201
Email: amy.smith@fmr.com
Pager: (800) sky-8888 PIN# 1572913
Subject: [orahrms-l] FW: [orahrms-l] Changes in GTL rates
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Fri, 18 Jun 1999 11:22:04 -0400
This patch is now available from Oracle, but I had to request it under a
TAR.
Statement of Earnings (SOE) viewing error
Subject: [orahrms-l] SOE viewing error
From: "Crawford, Erin" ECrawfor@JPI.com
Date: Tue, 13 Jul 1999 15:01:56 -0500
We've been having problems viewing certain employees' SOEs and have been
unable to see a commonality between these employees. I was wondering if
anyone else was getting a similar error, and if so, what they did to
correct it. The error says 'Too many Emp Info rows returned. Possible
data corruption.' Then another error comes up that says 'FRM-40350.
Query caused no records to be retrieved.' Please let me know if you've
run into this before.
Thanks,
Erin Crawford
JPI Partners, Inc.
972-556-6978
Subject: RE: [orahrms-l] SOE viewing error
From: "Brobeck, Jason" brobeck@ppg.com
Date: Tue, 13 Jul 1999 16:32:01 -0400
Funny you should mention this, as we just went through this problem with
someone a couple hours ago. There are a number of things that can cause it
- basically any datetracked table queried by the SOE that somehow has its
date-tracking 'corrupted', meaning 2 records active on the same date. We've
seen this problem happen sporatically and never have been able to track it
down.
Another cause is due to an error with the SOE form (which is what our
problem was today). When querying the state tax records to determine which
state to show on the SOE, an error can result if an employee has a
non-resident certificate on one of their state tax records and has had an
address change at any point on their record from one state to another. The
error in the form is that it is not accessing address records by date. So
it returns the current address record as well as all past address records,
thereby causing the 'too many emp info rows' to be returned. Again, this
only happens if they have a non-resident certficate checked on one of their
state tax records and have address records from multiple states. The
employee is still paid correctly in this case, its just that you can't view
the SOE online. It might also be a problem with Oracle's version of
Checkwriter and Deposit Advice, as it has the same logic in there...not sure
though since we've customized ours heavily and it isn't a problem in ours.
If neither of these help you out, I'd get one of your technical people to
look at the SOE form. There is only one query in there that will return the
40350 error. By executing that alone they can find out which table is
returning more than 1 row.
Jason Brobeck
PPG Industries, Inc.
Subject: RE: [orahrms-l] SOE viewing error
From: "Terry Hodge" tahodge@hotmail.com
Date: Wed, 14 Jul 1999 11:47:43 GMT
All,
The major cause of this error, is an invalid tax information.
Check the address, ensure that the effective dates match across the
people,address, and assignment record.
Remember in addition, if you moved the location from within this will cause
a problem.
Support has a script for determining tax records. This one is per.sql
and another script to delete tax infor. Use with caution.
Terry Hodge
Child Support Payment for Michigan
Subject: [orahrms-l] Child Support Payments for Michigan
From: Diane Patch DPATCH@FAMILYDOLLAR.com
Date: Tue, 13 Jul 1999 16:46:21 -0400
Cc: Sherry Walden SWalden@FAMILYDOLLAR.com
Thanks everyone for the help about the API. We found the information. Now
another issue has been brought to my attention from our payroll area.
For an employee in Michigan who has a Child Support element, Oracle withheld
60% and the order states to withhold 55% (standard preprinted amount, not
just for this employee). Our payroll manager wants to know how we can
refund the difference to the employee and how we can adjust the third party
check amount.
Any help would be greatly appreciated.
Diane Patch
HRIS Manager
Family Dollar Stores, Inc
(704)814-3315
DPatch@familydollar.com
Decrease YTD Support of employee
Subject: [orahrms-l] YTD Support Problem
From: "Phillips, Laura" LPhillips@jwrinc.com
Date: Wed, 14 Jul 1999 12:56:09 -0500
Title: YTD Support Problem
Hey All! To make a long story extremely short, I need to decrease an employee's YTD support. He is no longer being deducted for child support but his YTD support is incorrect. Any suggestions would be very much appreciated!
Thanks!
Laura
Subject: RE: [orahrms-l] YTD Support Problem
From: pkandra@civicdevelopment.com
Date: Wed, 14 Jul 1999 14:19:11 -0400
Use the Adjust Balance screen. People, Enter and Maintain, Assignment,
Other, Adjust Balance. Just be sure to be datetracked to when you want the
adjustment to be reflected.
Clear Arrears
Subject: [orahrms-l] Clear Arrears? ? ?
From: Adam Gates AGATES@FAMILYDOLLAR.com
Date: Tue, 20 Jul 1999 14:52:12 -0400
On the element entries screen there is a field called:
CLEAR ARREARS for some element entries!
My organization is trying to find out if when this is selected to YES, will
the employee still have money deducted from his payroll for other elements.;
or will this balance out and adjust?
Also, I have tried researching on this topic (CLEAR ARREARS), and have come
up with nothing on Oracle's webiste.
Adam Gates
agates@familydollar.com
Subject: Re: [orahrms-l] Clear Arrears? ? ?
From: Hankins Parichabutr Hankins@spinsoftware.com
Date: Wed, 21 Jul 1999 09:01:23 +1200
Hi Adam,
'Clear Arrears' should appear on deductions where arrearage was checked when
created.
If i remember correctly, when set to Yes it zeroes out the arrears balance WITHOUT
deducting it from the employee; then gets reset to No by an UPDATE_RECURRING
formula result rule.
On the special inputs element for that deduction, you might see an 'Adjust
Arrears'(?) input value...this would be the one to use for adjusting the arrears
balance which *will* get withheld from the employee next time the deduction is
processed.
Cheers,
HPARICHA
Hankins Parichabutr
Spin Software
Practice Director
228 Queen Street, Level 3
Auckland, New Zealand
(+64) 25.771.275 (mobile) or 9.366.0348 ext. 804
http://www.spinips.com/
Vacation Accrual and Payroll
Date: Thu, 9 Sep 1999 13:11:28 -0400
From: "Richards, Annele" Annele_Richards@compuware.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: HR-Vacation Accrual and Payroll
Hello-
Does anyone have the vacation accrual turned on in their HR system? If so,
do you interface it with Oracle Payroll or an outside payroll service? We
have Ceridian payroll and I want to know if there are any problems with this
feed.
Any help is appreciated.
ANR