Void Payment Report
Subject: [orahrms-l] Void Payment report
From: "Michael Scott" mscott@goodegg.com
Date: Thu, 22 Jul 1999 16:55:45 -0400
Folks,
Trying to run the Void Payment Report in Oracle HRMS v.11, and the LOV for
Payroll, GRE and Consolidation set is empty, thus the report does not work.
Can anyone tell me if I am missong something fundamental here, or if this
report is fixed by a patch?
Thanks
MS
Subject: RE: [orahrms-l] Void Payment report
From: "Brobeck, Jason" brobeck@ppg.com
Date: Fri, 23 Jul 1999 09:27:36 -0400
This request makes extensive use of value sets for each of the parameters.
After picking your start/end dates, the payroll name field will only show
payrolls who had void payments between those two dates. The consolidation
set field will only show consolidation sets in that payroll that had void
payments between those dates. Same for GRE. Thats the reason it takes so
long for those list of values to appear. If there are no values in the
Payroll LOV then you haven't had any void payments between those 2 dates.
You can check out the value set attached to each parameter to see how its
figuring this out.
Jason Brobeck
PPG Industries, Inc.
Gross to Net summary - Wage Attachment fees not appearing in
Subject: [orahrms-l] Wage attachments Costing
From: "Michael Scott" mscott@goodegg.com
Date: Mon, 26 Jul 1999 11:27:44 -0400
Would anyone have any insight why my wage attachments fees are not
reflected on my Gross to Net summary, even though they are costed?????
Thanks
MS
Subject: RE: [orahrms-l] Wage attachments Costing
From: pkandra@civicdevelopment.com
Date: Tue, 27 Jul 1999 07:28:34 -0400
It's a known bug. If you're on R11, patches 935062 and 913411 are supposed
to fix this and quite a few other issues with reports
Deductions taken report - Consolidation Set Name parameter
Subject: [orahrms-l] Deductions Taken Report
From: "Phillips, Laura" LPhillips@jwrinc.com
Date: Mon, 26 Jul 1999 14:15:35 -0500
Title: Deductions Taken Report
Hello All -
Hopefully someone else has run into this same problem and can give me a fix.
My problem occurs when I try to run a Deductions Taken Report for a specific pay period. On the Deductions Taken Report parameters you are either asked for a Payroll Name OR a Consolidation Set Name (not both). When I chose the Payroll Name and asked for a specific deduction it worked great. For example, if I asked for a list of everyone being deducted for 401-K it gave me a small printout with everyone being deducted and the dollar amount deducted for that pay period. When I chose the Consolidation Set Name it would do nothing. In April, Tech Support said I needed to have that fixed and they gave me a patch (#730580). I applied the patch. Now, I continue to get nothing when choosing Consolidation Set Name but now I get a single sheet for EVERY SINGLE PERSON who is being deducted for 401-K when I choose Payroll Name. Needless to say, I would rather have three sheets with 401-K information instead of 400+ sheets with one person listed on each sheet. What it all boils down to is the patch screwed things up worse. Now that we have gone live, I really need this fixed. When I called support and explained the WHOLE story, they gave me a NEW patch to try. It turns out, the new patch is the same patch I applied in April that started this whole mess. Has anyone else ran into this problem or does anyone know of a patch for 10.7 to correct the other patch?
Thanks!
Laura
Data Retention, Format and Media requirements for the IRS
Subject: [orahrms-l] Data Retention, Format and Media requirements for the IRS
From: "Brown, Deb" DBrown@Mail.Donaldson.com
Date: Mon, 26 Jul 1999 17:12:49 -0500
We have a letter from the IRS blessing our data retention, format and media
for our mainframe HR/Payroll. Since we are in the process of implementing
HRMS, this will change.
I would like to know what other HRMS users are doing to provide the IRS with
this information. Has anyone had the IRS bless your data retention, format
and media solution for Oracle HRMS?
Thanks for any input you can provide.
Deb Brown
Donaldson Company
dbrown@mail.donaldson.com
Patch 913411 for Reports
Subject: [orahrms-l] Help with Patch 913411
From: "Michael Scott" mscott@goodegg.com
Date: Tue, 27 Jul 1999 19:41:09 -0400
We have taken a patch 913411 to fix the payroll register, Gross to Net and
add Payroll Activity Report in Version 11.02. The Payroll Regsiter and
Activity reports are crashing hard, erroring out on completion, with one
of the error messages being:
HR_6990_HRPORC_CHQ_SRW2_FAILED
APP-06990 Cheque Writer Report Failed with an error
I am not sure why it says this, as our checkwriter is working fine.
Anyway, any insight or shared experiences with this patch would be helpful,
as Oracle is stumped as well.
MS
Subject: RE: [orahrms-l] Help with Patch 913411
From: pkandra@civicdevelopment.com
Date: Wed, 28 Jul 1999 07:30:20 -0400
Michael,
Did you apply patch 935062 (or 871046) ? 913411 delivers the multi-threaded
versions of the reports you mention, while patch 935062 (or 871046) delivers
the multi-threaded architecture. Look in the readme for 913411 for the
pre-requisites.
Peter Kandra
Civic Development Group
(888) 800-7637 x2518
Subject: [orahrms-l] Re: Initial Balance Loads
From: "John Turner" jturner@SpinSoftware.com
Date: Wed, 28 Jul 1999 21:32:27 +1200
There is a document that provides some technical details about
initial loading of balances. I think it is shipped as an appendix to
the implementation guide. If you can't find it let me know and I'll
find a copy for you.
JT
John Turner
jturner@SpinSoftware.com
http://www.spinsoftware.com
Report for FIT and SS withheld out of sync
Subject: [orahrms-l] Serious issues?? report mismatch..
From: "manu kkk" manu1357@hotmail.com
Date: Thu, 05 Aug 1999 08:39:14 CDT
Hi All,
My setup is
10.7 NCA, HP-UX 10.2, Oracle 7.3.3.5.1 . Currently live with HRMS.
We are on weekly payroll.
1)
Every week after finishing the Payroll , we run a program 'Federal and State
Tax Remittance Report Manager'(short name PYFTRMGR)
under the 'US HRMS Responsibility' for showing the weekly FIT withheld, SS
withheld and various state withhelds.
2) I was tring to verify the figures on the report with the sum of what we
have withheld for the week for each employee in that week payroll. The file
which is generated from the 'Check Writer' is of the name format
p$req_id.ch. I am doing the following little script on this file:
grep " FIT " p$req_id.ch|cut -c65-73|awk '{sum= sum+$1} END {print sum}'
>fit.total
grep " MEDICARE " p$req_id.ch|cut -c65-73|awk '{sum= sum+$1} END {print
sum}' >medicare.total
grep " SS " p$req_id.ch|cut -c65-73|awk '{sum= sum+$1} END {print
sum}' >ss.total
To my surprise the figures dont match. These are off by around 100$, 200$
for each.
I request all HRMS gurus to pls answer this.
thanks a lot in advance..
Subject: Re: [orahrms-l] Serious issues?? report mismatch..
From: "William C.Stratton" bstratton@sprynet.com
Date: Thu, 5 Aug 1999 12:30:32 -0400
Let's eliminate some of the obvious. Do you have direct deposit employees?
These folks will not be in your checkwriter run. Did you run any quickpays
that processed after your checkwriter run? Did you do any balance
adjustments?
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: Re: [orahrms-l] Serious issues?? report mismatch..
From: "manu kkk" manu1357@hotmail.com
Date: Thu, 05 Aug 1999 13:14:38 CDT
Hi Bill,
Thanks for your time. Really appreciate this.
1) We are not on direct deposits yet.
2) We did run the quick pay after the check writer but the check file which
I am using for my script calculation is taking care of that.I mean I got the
first.ch file after the first check writer run and then I took the second.ch
file after the IInd check writer run which was done after a few quick pays
on 11 employees some of them were not taken in the first chekc writer run
and some of them were having wrong chekcs.
3) I manually removed the records from "first.ch" file for the employees who
were having records in "second.ch" and concatenated the second.ch file to
the "first.ch" file ready for my script processing.
4) I am not sure about the balance adjustments but 99.9% we did not do any.
Can you pls guide me in the right direction. Trying with Oracle Support for
last 2 days but no help yet.
thanks a lot
Correcting salary after generating NACHA report
Subject: [orahrms-l] question on 10.7 nca?? nacha/deposit advice...
From: "manu kkk" manu1357@hotmail.com
Date: Thu, 12 Aug 1999 09:45:29 CDT
Hi All,
We are live on 10.7 NCA on HP-UX. Planning to go on direct deposit
now but have one concern:
If after sending the NACHA file to the bank we come to know that someone's
salary amount was not correct then what is the way to handle that.
I was told that because there is no negative nacha process SO it is
not possible to handle this case in release 10.7 NCA..
But I am sure that there must be a way-out of this to handle this
situation.
All suggestions are welcome and will be really appreciated.
thanks
Subject: RE: [orahrms-l] question on 10.7 nca?? nacha/deposit advice...
From: "Cooprider, Karen" Coop@RGIS.com
Date: Thu, 12 Aug 1999 12:25:01 -0400
Your Bank should allow you to perform deletions for individual on your Nacha
file as well as perform adds. If it's timely you can roll back all the
payroll processes for just that individual. Run a quick pay and
pre-payments with the correct figures and call in an add to your bank.
Karen Cooprider
Salaried Payroll Manager
Coop@rgis.com
Mailing Labels
From: "Schwartz, Ken" kschwar@rwjf.org
Date : 18th August 1999
Subject: Mailing Labels
Greetings from Princeton, NJ!
My client has a requirement to produce 'mailing labels' for various reasons
and frequencies for different groups in their HR database.
Are there any standard report/processes that I can use?
Regards,
Ken Schwartz
Independent Consultant
Specializing in Oracle HRMS
Site: 609-720-7529
Cell: 404-226-6334
Mail: kenschwartz@mindspring.com
Site Mail: kschwartz@rwjf.org
From: "Bob Cody" Bob_Cody@norstanconsult.com
Date : 18th August 1999
Subject: Re: [orahrms-l] Mailing Labels
Ken,
ADE will allow you to export HR data based on a template you set up. This data
can be mail merged directly into a Word document for printing. The online help
for ADE in HR has a pretty good explanation of how to set this up.
Bob Cody
bob_cody@norstanconsult.com
NACHA Report -Records not broken logically - Query 1
Subject: [orahrms-l] NACHA output from Oracle Payroll 10.7 NCA
From: James Wood JWOOD@FAMILYDOLLAR.com
Date: Fri, 9 Apr 1999 16:01:31 -0400
All,
We are already live with Oracle HR/Payroll, attempting to set up
direct deposit. When we have run the NACHA output file from Oracle, though,
we have encountered several problems. The major one is the file format
itself; although the data is logically broken into 94 byte records (which it
should be according to the NACHA specs), the data is not physically broken
into these 94 byte records. Instead, it appears (in Notepad, Dos Editor,
etc.) as 2 long rows, well in excess of 94 bytes each. I verified that it
was logically set up as 94 bytes per record only by manually returning at
every 94 characters.
My question is what is required to produce this NACHA file that is
logically and physically 94 bytes per record? Is some programmatic
manipulation required? I haven't seen anything in Oracle documentation that
would suggest this, but I'm beginning to wonder if this is the only way
we'll be able to produce the necessary output. One last thing: we opened
this file in Unix and it looked the same way, so we've ruled out as a cause
the FTP process that moves the file from Unix to a local workstation and
from Unix to the bank.
Any suggestions would be much appreciated. Thanks,
James Wood
Family Dollar Stores
Subject: RE: [orahrms-l] NACHA output from Oracle Payroll 10.7 NCA
From: "Reyes, Ricardo" Ricardo.Reyes@fmr.com
Date: Fri, 9 Apr 1999 16:49:12 -0400
Use the fold -w94 command to split into 94 byte.
Rick
Subject: RE: [orahrms-l] NACHA output from Oracle Payroll 10.7 NCA
From: "Brobeck, Jason" brobeck@ppg.com
Date: Fri, 9 Apr 1999 17:02:00 -0400
We took the NACHA output and ran it through a host script. The script uses
the UNIX 'fold' command to wrap it 94 character line lengths (fold -w94).
Unfortunately, fold only ends each line with a linefeed where our
requirement was a CR/LF, so we had to append that to each line as well
(using the 'sed' UNIX command). We did all this at the point where we were
transferring the file from UNIX to our mainframe system for actual
transmission.
Hope that helps.
Jason Brobeck
PPG Industries, Inc.
Subject: Re: [orahrms-l] NACHA output from Oracle Payroll 10.7 NCA
From: "William C.Stratton" bstratton@sprynet.com
Date: Fri, 9 Apr 1999 17:14:19 -0400
Almost all of the files that come out of Oracle Payroll do not include
carriage returns and line feeds, as you have already discovered. Some banks
can accept this format, while others will want the line feeds included. We
generally would create a simple process during the procedure that sends the
NACHA file to the bank that would insert the needed control sequences. You
will encounter this same situation with your SQWL and year end files.
Hope this helps.
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
NACHA Report - Records not broken logically - Query 2
Subject: [orahrms-l] Reformatting Nacha file for our bank- Help
From: "Menke, Irene M." menke@Mail.Donaldson.com
Date: Thu, 10 Jun 1999 16:31:36 -0500
Hello,
We sent our first file test to our bank and they informed us it needed to be
broken out into 94 byte records / header, detail, total.
Has anyone experienced this and how did you resolve it.
Thanks for any help on this one.
Irene Menke
Donaldson Company
612.887.3605
menke@mail.donaldson.com
To: menke@Mail.Donaldson.com, OraHRMS-L@mail-list.com
From: mwest@Estee.com
Date: Thu, 10 Jun 1999 19:32:08 -0400
Irene,
I'm taking the liberty of reposting another users response to this question
in an earlier discussion. I beleive the response assumes you are on a Unix
platfrom.
"We took the NACHA output and ran it through a host script. The script uses
the UNIX 'fold' command to wrap it 94 character line lengths (fold -w94).
Unfortunately, fold only ends each line with a linefeed where our
requirement was a CR/LF, so we had to append that to each line as well
(using the 'sed' UNIX command). We did all this at the point where we were
transferring the file from UNIX to our mainframe system for actual
transmission.
Hope that helps.
Jason Brobeck
PPG Industries, Inc. "
I hope that this helps and Jason is in offended.
Regards,
Mark F. West
The Estee Lauder Companies
Subject: RE: [orahrms-l] Reformatting Nacha file for our bank- Help
From: "Jarnutowski, George J." JarnGJ@jea.com
Date: Fri, 11 Jun 1999 07:17:25 -0400
This is an undocumented feature. Use UNIX command - fold -w94 fromfile >
tofile
How to modify NACHA FF
From:
Lisa Palermo palermo_lisa@yahoo.com
Tue 8:56 PM
Subject:
[orahrms-l] Q: Modifying a FF - how to modify a NACHA FF that was not meant to be modified
The functional users tell me that the NACHA header and the NACHA files
needs to be modified for our bank. (I always thought that NACHA was
standards, but anyway...) When we try to modify NACHA batch headers or
any of the other NACHA
headers, they are protected.
Can anyone tell me the best approach to change this?
We were thinking about deleting and then replacing with a modified
version, or should we just modify the teXt in the FF_FORMULAS_F using
pl/sql?
Lisa Palermo,
Cap Gemini America Consulting
===
Lisa
From:
"Brobeck, Jason" brobeck@ppg.com
Tue 9:16 PM
Subject:
RE: [orahrms-l] Q: Modifying a FF - how to modify a NACHA FF that was not meant to be modified
On the ff_formulas_f table, update the business_group_id to your business
group for any of the 'seeded' formulas - this will let you modify the
formula via the normal Write Formulas form. After you are done modifying,
set it back to null, as I've seen some patches fail when we left seeded
formulas with a business group id filled in.
Btw, we had to do the same thing to our NACHA formulas.
Jason Brobeck
PPG Industries, Inc.
From:
"Mike Kattelman" MikeK@firsthealth.com
8/31/99 12:54 AM
Subject:
Re: [orahrms-l] Q: Modifying a FF - how to modify a NACHA FF thatwas not meant to be modified
To:
palermo_lisa@yahoo.com
We have implemented a custom ProC program to manipulate the file that is run via a request set
at the time the NACHA process is run. The file name can be derived via the request number that
is passed as a parameter via SRS. We had to add logic for each bank we dealt with.
MK-