401K Withholdings and Matches report
Subject: [orahrms-l] Report for 401K Withholdings and Matches
From: "Heather Budnik" HBUDNIK@indianapolis.olivellp.com
Date: Thu, 25 Mar 1999 16:24:20 -0500
We need a report that shows the following information for all
employees that are making contributions to a 401K:
Name
Social Security Number
Gross Compensation
401K Withheld
Company Match
We need to give this information to a third-party administrator
monthly.
We have two 401K elements (one for flat-rate withholding and one for
percentage withholding). We're using a custom balance (defined in the
Balance form) for Gross Compensation, in order to include both regular
and supplemental earnings in the withholding. We also have two
company match elements defined; each 401K withholding element
calculates the company match and passes the result to the company
match element. We're on 10.7 NCA.
Does anyone have a report that's similar to what we need? Any
suggestions as to the best way to approach this? Would we need to use
the Oracle Report Writer, or is there an easier way to do it?
Any help would be appreciated. Thanks!
Heather Budnik
Senior Consultant, Olive, LLP
hbudnik@indianapolis.olivellp.com
Subject: RE: [orahrms-l] Report for 401K Withholdings and Matches
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Thu, 25 Mar 1999 17:17:51 -0500
Heather: You need to create a PL/SQL program to get this information out to
the third-party administrator. Use the delivered Oracle Packages to get
balances on Gross Compensation, etc. The other data (name, ssn, etc.)can be
pulled from base tables. Let me know if you need more information.
Regards,
Tony x8452
http://www.mcsgroups.com
SQWL Rollback stuck
Subject: [orahrms-l] SQWL Rollback "Stuck"
From: "Ken Stovesand" Ken_Stovesand@norstanconsult.com
Date: Fri, 9 Apr 1999 13:50:02 -0400
My client has "stuck" SQWLs for two states. From a rollback perspective,
they appear to have already been rolled back (i.e. they do not appear on
the LOV for processes that are available to be rolled back). From the
viewpoint of re-running the SQWLs, they appear to be already run (i.e. the
LOV for the Format parameter has no entries). The original SQWL processes
for these states ended in error due to a "max extents" database problem
which has since been corrected. SQWLs for other states can be run, rolled
back, and re-run without problems. Oracle support is struggling; any help
would be greatly appreciated.
Regards,
Ken Stovesand
Norstan Consulting
Subject: Re: [orahrms-l] SQWL Rollback "Stuck"
From: "William C.Stratton" bstratton@sprynet.com
Date: Fri, 9 Apr 1999 17:17:19 -0400
Anytime a payroll process terminates with an error, you must run a special
process from the Unix prompt called a "FORCE UNDO". Oracle Support should
know this and maybe you have already tried this. If not, let me know, and
I'll try to dig up the syntax.
Bill Stratton
BOSS Corporation
Better Organization Service Solutions
6455 East Johns Crossing, Suite 404
Duluth, GA 30097
770-622-5500 (V) 770-622-5400 (F)
http://www.bosscorporation.com
Subject: [orahrms-l] Re: SQWL Rollback "Stuck" - RESOLUTION
From: "Ken Stovesand" Ken_Stovesand@norstanconsult.com
Date: Mon, 12 Apr 1999 15:40:32 -0400
Thanks for the inputs. The problem was finally resolved this morning by
deleting rows in the following tables that are associated with the payroll
action ids for the "stuck" SQWLs. The tables are:
1. ff_archive_items (payroll_action_id = [payroll action id])
2. pay_assignment_actions (payroll_action_id = [payroll action id])
3. pay_message_lines (source_type = 'P' and source_id = [payroll
action id])
4. pay_payroll_actions (payroll_action_id = [payroll action id])
Note that if the deletion for table number 3 is not performed first, an
error may result when attempting to perform deletion of rows from table
number 4.
Thanks again for your responses.
Regards,
Ken Stovesand
Norstan Consulting
Subject: RE: [orahrms-l] SQWL Rollback "Stuck"
Subject: RE: [orahrms-l] SQWL Rollback "Stuck" How to widen the address field of Payroll Deposit advice
Date: Wed, 21 Jul 1999 14:06:11 -0500 Local version of SQWL
Subject: [orahrms-l] Local Version of SQWL Available?
Subject: RE: [orahrms-l] SQWL Rollback "Stuck" 401K ACH file
Subject: [orahrms-l] 401K ACH file Signal 11 on running a report
Subject: [orahrms-l] Signal 11 Error
Subject: Re: [orahrms-l] Signal 11 Error
Subject: RE: [orahrms-l] Signal 11 Error
Subject: RE: [orahrms-l] Signal 11 Error Error APP-0687 on execution of Quickpaint Report
Subject: [orahrms-l] Quickpaint Payroll Register Report - Patch 887057
Subject: [orahrms-l] Patch 887057 Gross to Net Report - Patch 873000 and Bug 823718
Subject: [orahrms-l] Patch 873000 and Bug 823718
Subject: RE: [orahrms-l] Patch 873000 and Bug 823718 Current Tax Balances not appearing in SOE Report
Subject: [orahrms-l] current tax balances on soe report Report by Assignment No., containing GRE, TIme details etc.
Subject: [orahrms-l] Oracle SQL + Report
Subject: RE: [orahrms-l] Oracle SQL + Report SQL script for report on 401K ER Contribution
Subject: [orahrms-l] 401K ER Contribution
Subject: Re: [orahrms-l] 401K ER Contribution Costing Reports do not show Balances
Subject: [orahrms-l] Costing
Subject: [orahrms-l] Fw: [orahrms-l] Costing
Subject: RE: [orahrms-l] Fw: [orahrms-l] Costing Reports for Auditing
Subject: [orahrms-l] Auditing
Subject: RE: [orahrms-l] Auditing
Subject: RE: [orahrms-l] Auditing Resident and Non-Resident Aliens Tax Reporting Requirments
Subject: [orahrms-l] Resident and Non-Resident Aliens Tax Reporting Requirments
From: "Driver, Paul" p.driver@ic.ac.uk
Date: Thu, 15 Apr 1999 14:14:05 +0100
The Command is :-
PYUGEN hr/hr 0 Y FORCE_UNDO
The
The '' is 2 single quotes not a double quote
Cheers
P.Driver
From: "Jarnutowski, George J." JarnGJ@jea.com
Date: Thu, 15 Apr 1999 10:02:18 -0400
This is great feedback because I was not able to find this anywhere. I have
this condition (SQWL in error) and was unable to locate how to do this.
This list server for HRMS is a good thing.
Thanks Paul in UK.
From: "Shockey, David" DShockey@jwrinc.com
Subject: PAY: Deposit advice address
We are only getting twenty characters in the address field of payroll
deposit advices. Can this be extended without customizing the report?
From: "Ken Stovesand" Ken_Stovesand@norstanconsult.com
Date: Fri, 16 Apr 1999 13:01:55 -0400
We have the need to report quarterly wage list data to specific local
jurisdictions. The information is similar to that provided by the SQWL
reports but must of course be limited in scope of employees reported. Is
there a "local" version of the SQWL that allows reporting to the local
level? How are others solving this problem? Thanks for your response.
Regards,
Ken Stovesand
From: "Driver, Paul" p.driver@ic.ac.uk
Date: Tue, 20 Apr 1999 10:21:36 +0100
George
I believe that the PYUGEN call below calls the following packaged
procedure:-
py_rollback_pkb.rollback_payroll_action(payroll_action_id)
There are several other parmeters in the call, the payroll_action_id is the
only none defaulted one.
Cheers
Paul Driver
From: "Dhawan, Radhika (Oracle Financial)" RDhawan@sigeco.com
Date: Fri, 30 Apr 1999 13:38:28 -0500
Hi All,
Has anyone sent a file to their bank for their 401K interface with the total
debit and credit amounts. It looks like a direct deposit NACHA file except
that it has to be produced from scratch unlike the Direct deposit file that
Oracle automatically produces in the out directory. Basically this file
would have the debit and credit amounts that go to the bank in the NACHA
format.
Any help would be appreciated!!!!!!!
From: Pallavi Grandhi pallavi.grandhi@deltec.com
Date: Wed, 5 May 1999 10:08:29 -0500
Hello,
I am submitting a concurrent request (which runs a report) which completes
with a error. When I look at the request log it says that it completed
with a signal 11 error. I looked at the managers log, it just had the
information about starting the concurrent managers.
The report that this concurrent manager is trying to run is a monster
report. It prints the paychecks of 650 employees. It should take 4 hours
to complete. I was able to run this report 2 times before without any
error. Even now, I can run the report by restricting the data (group of
employees rather than 650). If I try to run this report for 650
employees, it is processing till 646 employees and then it is erroring
out.
I was looking at one of the previous mail which says that, this error
might be because of some system parameters sized too small. Is any one
aware of what system parameters to check for.
Please Help.
Thank You
Pallavi Grandhi
651 628 7348
From: "Bob Cody" Bob_Cody@norstanconsult.com
Date: Wed, 5 May 1999 11:54:25 -0400
Pallavi,
Check to be sure the report was FTP'ed to the server in binary mode.
I think I've seen this error when FTP'ing reports in ASCII.
Bob Cody
From: Pallavi Grandhi pallavi.grandhi@deltec.com
Date: Wed, 5 May 1999 10:58:57 -0500
I developed the report in Unix, so I did not have to ftp the report.
Thanks for your time.
Pallavi Grandhi
651 628 7348
From: "Driver, Paul" p.driver@ic.ac.uk
Date: Thu, 6 May 1999 07:59:04 +0100
First check with Oracle support for any known problems with your hardware.
I think signal 11 is a memory problem. It might be your report requires a
lot of memory and disk swapping. If it uses a lot of resource you may want
to try and tune it.
Cheers
Paul Driver
From: "Goodyear, Michael" Michael.Goodyear@ncp.co.uk
Date: Wed, 12 May 1999 13:38:46 +0100
Hi All,
I am having a problem trying to run a quickpaint report against an
assignment set.
I get an APP-0687: Error occurred during formula execution.
Cause: An error of data type ASG_JOB not found at line 6 of mg_test_set.
This error occurs with any '&ASG' item picked as the criteria in the
assignment set, and the line number always points to the line 'ELSE
INCLUDE_FLAG = 'N'' in the formula ( I assume that it is falling over when
it comes across an employee that doesn't match the criteria )
I have applied 'C patch 830192' as advised by WWS, but still have the
problem, a BUG has now been raised by them.
Any insight into a way around this would be greatly appreciated.
TIA
Mick.
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Wed, 9 Jun 1999 11:59:53 -0400
Has anyone applied this patch for the updated Payroll Register Report? WWS
indicated that there exists a bug with the report that if it is run multiple
times w/the same parameters, the report returns different results. We have
not been able to replicate this, but want to apply the patch as it is
contained in another patch (874692) that would address some problems we are
having. Anyone having problems with the Payroll Register Report? We are on
10.7 NCA.
Ellen L. Young
Oracle Applications Project Mgr.
Family Dollar Stores, Inc.
704-814-3365
eyoung@familydollar.com
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Fri, 11 Jun 1999 12:16:20 -0400
Cc: "'dsnyder@us.oracle.com'" dsnyder@us.oracle.com
Does anyone have any experience with patch 873000 (Gross to Net Report)
patch. There are a couple pre-reqs for this patch, which we have applied,
but the report is still taking over 13 hours to run for one payroll. Oracle
has logged a bug (823718) that is in development, but I cannot get any
information on this bug off MetaLink.
Ellen L. Young
Oracle Applications Project Mgr.
Family Dollar Stores, Inc.
704-814-3365
eyoung@familydollar.com
From: pkandra@civicdevelopment.com
Date: Fri, 11 Jun 1999 12:32:17 -0400
Cc: dsnyder@us.oracle.com
We have severe issues with the performance of all our payroll reports and
actually ended up writing most of our own.
From: lakshmi mannem prasuna_ml@hotmail.com
Date: Tue, 15 Jun 1999 15:59:08 PDT
Hi Folks:
I have couple of questions here:
1. I have loaded the initial balances in to oracle. After running quickpay,
I have seen all the ytd and current balances on soe report
but yesterday, you have got new instance, in this instance I did the same
steps, infact same set up(hope fully) but this time i have seen only ytd
balances in soe report not current runs. could any body through some light
on this issue.
2. I checked after loading initial balances using tax balance view form,
there for tax category SS, the excess amount is showing in negative values
and excess and exempt values are different. Exempt values are in positive
side
I would appreciate, if some body have any ideas.
Thanks
Lokanadha raju
From: "Michael Scott" mscott@goodegg.com
Date: Mon, 21 Jun 1999 15:11:12 -0400
Does any one out there have any idea on the following reports
1. I want a report by assignment #, then GRE other information such as
GRE, Timecard Required and shift worked. This other GRE information
appears only to be a view and the TRM does not have any useful suggestions
on where to find this information.
2. Assignment # with Job and Exempt Non Exempt Status (classified in other
job information). Same issue as above, and the TRM is of no use in this
case.
Thanks to anyone with any sql ideas on this.
MS
From: pkandra@civicdevelopment.com
Date: Mon, 21 Jun 1999 16:39:49 -0400
#2. SELECT PA.ASSIGNMENT_NUMBER, PJ.NAME, PJ.JOB_INFORMATION3 FROM
PER_ASSIGNMENTS_F PA, PER_JOBS PJ
WHERE PA.JOB_ID = PJ.JOB_ID
JOB_INFORMATION3 will either be EX or NEX depending upon whether it's Exempt
or Non-Exempt.
You'll most likely also want to join PER_PEOPLE_F and include
EFFECTIVE_START_DATE and/or EFFECTIVE_END_DATE
Hope this helps,
Peter Kandra
Civic Development Group
(888) 800-7637 x2518
From: "Michael Scott" mscott@goodegg.com
Date: Thu, 1 Jul 1999 11:39:34 -0400
Does anyone have a quick sql script to run showing by employee ee 401k
contributions and er 401k employee contributions, by payrollrun or date
earned. I sure could use a quickie on this one, or some quick pointers.
Thanks
MS
From: Hankins Parichabutr Hankins@spinsoftware.com
Date: Fri, 02 Jul 1999 10:41:19 +1200
Each of these contributions ee and er 401k presumably feed an appropriate balance.
A script/report to loop thru all assignment actions calling
pay_balance_pkg.get_value in assignment action mode would do the job.
The defined_balance_id's you'd want to pass are probably the one's for
(BALANCENAME)_ASG_GRE_RUN.
This would give you the figures you want, could be written fairly quickly,
and is a handy script to have.
If you really want the figures by "date earned" then that's another story - unless
you're date earned's are the same as your effective/pay/check date, which is
rarely
the case.
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/
From: g o xyxzas@yahoo.com
Date: Wed, 5 May 1999 14:02:57 -0700 (PDT)
I am running 11.02 on NT and having an issue with the costing process.
I run the costing process and then run the Costing Breakdown Report
When I view the report I only see the costing side, not the balance
side. Is there a known problem with the costing process for 11.02 on
NT?
Thanks!!!!!!
From: "Ken Conway" ken.conway@bosscorporation.com
Date: Wed, 5 May 1999 20:56:50 -0500
G O:
Your observation about Costing is accurate. This is not a bug. This is a
"feature". I agree with you that the report should provide appropriate
balancing information but it doesn't. In the meantime, prepare to write
something custom if you desire to review this information prior to
transferring to the GL.
Hope this helps,
--Ken
From: "Driver, Paul" p.driver@ic.ac.uk
Date: Thu, 6 May 1999 08:01:30 +0100
Ken is right it is a feature of the report. When I wrote a bespoke costing
breakdown by employee for one of my clients, it was a difficult and
thankless task. Good luck!
Paul Driver
From: "Winn, George H." gwinn@Mail.Donaldson.com
Date: Thu, 15 Jul 1999 07:48:54 -0500
We are using ver 10.7 SC; prod 16.1
We have a requirement to perform the following auditing steps:
1) Salary increases greater than x% (probably will be 10%)
2) Identify specific supplemental earnings (not all types) such as bonus;
achievement awards; sign-on bonus; etc.
We want to be able to generate separate reports of each of these.
Any ideas short of creating custom reports?
thanks
George Winn
Donaldson Company, Inc
email: gwinn@mail.donaldson.com
voice: 612.887.3833
fax: 612.887.3148
From: "Schwartz, Ken" kschwar@rwjf.org
Date: Thu, 15 Jul 1999 09:02:54 -0400
George:
This sounds like several Oracle Alerts.
I would create one alert for the salary increase and an alert for each of
the elements used for the identification of the supplemnental earnings.
In addition to being able to generate a report out of each alert, you cna
also send an email to the appropriate person(s) informing them of what has
happened.
Please contact me if you need additonal information.
Regards,
Ken Schwartz
Independent Human Resource Consultant
Specialinzing in Oracle HRMS
Site: 609-720-7529
Cell: 404-226-6334
Mail: Kenschwartz@mindspring.com
Site Mail: Kschwar@rwjf.org
From: "Terry Hodge" tahodge@hotmail.com
Date: Thu, 15 Jul 1999 14:03:27 GMT
All,
You may want to use something more generic than oracle alerts, this does not
give you the flexibility to generate report.
I would recommend placing a trigger on the table, or event which copies in a
custom table which would allow you to capture and run reports based on user
defined protocol.
DBMS_ALERT is a pre-packaged Oracle package which will allow you to send
messages also.
Terry
From: "Kuoppala, Beverly A" bkuoppala@kpmg.com
Date: Wed, 21 Jul 1999 23:25:06 -0400
Can anyone help Janice with this one? If so, we would appreciate it.
Beverly Kuoppala
All,
I am currently working at a client site where they have a large population
of non-resident alien individuals. During the setup of the Oracle HRMS
Payroll module (Release 11.0.2), the system configuration needs to address
the business requirement of tracking the amounts paid to non-resident aliens
separate from the amounts paid to resident aliens to meet year-end tax
reporting requirements.
Generally, non-resident aliens receive a Form 1042-S and resident aliens
receive a Form W-2.
What I believe I must do is setup an element for each non-resident
reportable income code and tie each to a salary basis. If I allow these
individuals to be paid with the pre-defined element of regular wages or
regular salary, I believe the amounts will feed a balance which will appear
on a Form W-2 instead of the required Form 1042-S. This is not what I want.
Has anyone tackled this issue??? And are there other solutions that you
have tested and documented the success?
Any thoughts and suggestions would be greatly appreciated!!
Janice Lyng
Consultant
KPMG LLP
Phone - 518-434-7246