Payroll encumbering
Date: Wed, 30 Jun 1999 10:46:31 -0400
From: "Bartoletti, Michael" BartolMi@rf.suny.edu
Subject: PAYROLL: Payroll Encumbering
We have been in contact with Oracle to get a defined solution/work around
for payroll encumbering. I heard that some people at Cal Tech worked with
Oracle on this. If there is anyone who has information on this I would
appreciate it.
Thanks
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
mailto:bartolmi@rf.suny.edu
Payroll Cost Reports and Balancing
From: "Michael Scott" mscott@goodegg.com
Date: Sun, 4 Jul 1999 15:49:47 -0400
Subject: [orahrms-l] Payroll Cost Reports and Balancing
Here is a situation,
Running cost information on payrolls and the costing appears to be correct.
The issue is that none of the balancing information is reflected on the
costing reports or on the Journal import. Does anyone have any insight
into this.
Thanks and Happy 4th of July to all.
MS
From: "William C.Stratton" bstratton@sprynet.com
Subject: Re: [orahrms-l] Payroll Cost Reports and Balancing
Date: Tue, 6 Jul 1999 08:36:15 -0400
Sorry Mike,
This is a feature and not a bug. We have complained about this for some time. At many of our clients, we have actually written our own GL journal report so that we could see these balancing entries.
The Journal import, however, should have the balancing entries. We have not seen this problem. Can you see the balancing entries via the costing screen on the Payroll Process Results? Can you query the source costing tables (can't think of the name right now) and see them there? When is the first time that you cannot see these entries in the actual file (on the Payroll side or the GL side)?
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
Payroll to multi-departmental employee
Date: Thu, 8 Jul 1999 11:05:50 EDT
From: GWRR@aol.com
Subject: Oracle Payroll
Hello all:
I have a client who requirements include the following:
Employees work in several departments within the same pay period. Employee
Earnings, Employer's tax expenses and Employer's benefit expenses must be
costed to the appropriate department.
1. If I use multiple assignments for the employee, the costing is correct,
but Oracle Payroll prints multiple employee checks for each assignment (which
is not acceptable to the client).
2. If I attach multiple elements to the employee, the costing of earnings is
correct, but the remaining employer's tax and benefit expenses are costed to
the employee's home department (costing set at organization level) only.
3. I cannot use the allocation function in Payroll as all earnings are to be
costed to the appropriate department at 100%.
Does anyone have suggestions on how this requirement can be accomplished in
Oracle Payroll.
Thanks,
Gwen
Payroll in Public Sector
Date: Thu, 8 Jul 1999 14:34:27 EDT
From: GWRR@aol.com
Subject: Oracle Payroll in Public Sector
Hello,
Are you a Public Sector entity using Oracle Payroll?
If so, I would like to talk to you regarding how you resolved some of the
issues my client is facing in setting up Oracle Payroll to meet its
requirements, such as: overload pay, summer contracts, retirement plans, etc.
Thanks,
Gwen Walker
Date: Thu, 8 Jul 1999 14:10:48 -0700
From: "joanetta counce" jcounce@oaklandnet.com
Subject: RE: Oracle Payroll in Public Sector
Gwen:
I'm interested in public sector Oracle payroll clients as well. Are you
from the public sector? I'm unable to determine what company or public
sector agency you're from, let me know.
Joanetta
Date: Thu, 8 Jul 1999 17:33:56 EDT
From: GWRR@aol.com
Subject: Re: Oracle Payroll in Public Sector
I am working at Valencia Community College. We have some rather unique
requirements in regards to payroll processing. This is why I am interested
in speaking with other public sector Oracle Payroll clients.
Gwen
Date: Fri, 9 Jul 1999 08:48:55 -0400
From: "Bartoletti, Michael" BartolMi@rf.suny.edu
Subject: RE: Oracle Payroll in Public Sector
I am at State University of NY and we also are implementing HR/Payroll and
have some unique (maybe) requirements. Let me know what you want to know.
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
mailto:bartolmi@rf.suny.edu
Payroll Costing performance
Date: Mon, 12 Jul 1999 09:04:52 -0600
From: Brad Stauf brad.stauf@solbourne.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Question about Oracle PY costing performance
I had a question from an Oracle commercial HRMS user on R11.0.3/Solaris and
I wanted to relay it. They have about 3,000 employees and their Payroll
costing runs about 4 hours (it was 20 and they had Oracle's SPG in to do
some tuning). Not sure of peak CPU usage or memory buffer hit ratios or
pinning (we haven't been asked to do an in-depth analysis yet) but they are
pretty hardware and database-savvy so I think they have eliminated hardware
bottlenecks. They were wondering what kind of performance other companies
are seeing. They have 6 costing flexfield segments in one organization
(probably 2,000 people) and 10 in the other (about 1,000 people). Does
anyone have any comparable figures they could share? Please e-mail cc me on
any replies and thanks in advance.
Brad Stauf - Technical Director
Solbourne - SAP & Oracle consulting
(303) 417-2800 (v)
(917) 677-9320 (f)
bstauf@solbourne.com
Validate Check Numbers
From: nmolstad@usmarine.com
FromDomain: USMARINE
To: OraHRMS-L@mail-list.com
Date: Tue, 29 Jun 1999 07:29:14 -0700
Subject: [orahrms-l] Check Numbers
Does anyone know of a way within the Oracle application to validate check
numbers to prevent a check number from being used more than once? We are
having a problem with duplicate check numbers begin issued in error.
From: Diane Patch DPATCH@FAMILYDOLLAR.com
Subject: RE: [orahrms-l] Check Numbers
Date: Tue, 29 Jun 1999 15:51:47 -0400
We are also having this problem as well and have not figured out a way to
validate the check number. We would also be very interested to find out if
anyone has a solution to this problem. This is causing us problems with the
bank and with our bank reconciliation.
Diane Patch
HRIS Manager
Family Dollar Stores, Inc
DPatch@familydollar.com
From: Ron Pribyl RPribyl@amctheatres.com
Subject: RE: [orahrms-l] Check Numbers
Date: Wed, 30 Jun 1999 09:23:45 -0500
We have found nothing within Oracle.
As a 'work-around', we use the following procedure to validate continuous
check numbers.
1) With print image file we use a PC program called Monarch to strip
check numbers & amounts from file.
2) The results are saved in Excel format.
3) In Excel we use a formula to check the numbering sequence.
a) Column A - Check#
b) Column B - Amount
c) Cell C2 - =A2-Beg_Ck_No+2 (Copy down)
d) Cell D2 - =ROW(C2)-C2+D1 (Copy down)
Using Data/Filter/Autofilter on Column D, you can quickly find
duplicate/missing checks.
Contract salaries
Date: Tue, 6 Jul 1999 11:22:15 -0600 (MDT)
From: "Mavis O'Connor" moconnor@IR.ColoState.EDU
Subject: [orahrms-l] Contract Salaries
Does anyone have experience creating their own elements and
formulas to pay employees a contract salary amount with
specific start/end dates. We want to negotiate and pay a
flat amount (such as $8,000) to pay someone for the dates
May 18, 1999 through August 4, 1999 and have the $8000
prorated throughout the 4 monthly pay periods (May, June, July,
and August). One would need to know the end date and the
contract amount in order to pro-rate how much to pay them
in the other months.
If you have done something similar and have ideas or examples
you can share please let me know.
From: Bijus@mashreqbank.com
Cc: moconnor@IR.ColoState.EDU
Subject: RE: [orahrms-l] Contract Salaries
Date: Wed, 7 Jul 1999 10:16:30 +0400
Connor,
I guess i understood yr requirement clearly.
Element
Contract Salary Amount (Non Rec/Info)
input - start date
End date
Amount
Balance
Contract Salary Amount (ASG_ITD / Add)
logic. create the entries for this element whenever needed and update the
balance. In the actual payroll calculation formula, pro rate it monthly
depending on the no of days in the payroll period and add to the earning
element and deduct from the balance. do until this balance become zero.
If you need more clarity,
0097-14-7066355
Biju Sebastian
From:
Hankins Parichabutr Hankins@spinsoftware.com
7/8/99 10:21 AM
Subject:
Re: [orahrms-l] Contract Salaries
To:
Bijus@mashreqbank.com, moconnor@IR.ColoState.EDU
CC:
OraHRMS-L@mail-list.com
Hello Mavis,
I would recommend creating a Flat Amount earning from the Earnings screen,
then add input values to the generated earning for...
"Contract Start"
"Contract End"
"Total Contract Amount" (or something)
Without going too far into it, you'd also need to customise the generated
formula for the earning by...
+ Make call to a custom function - straightforward modification of calculation
section in generated formula.
+ Write the plsql function to perform the custom proration. Contract Start
and End dates could be used to determine how many pay periods exist between
the contract start and end dates; then divide the contract amount by the
number of pay periods and you can pay the employee the same amount each pay
period until the contract is over -- I presume this is what you'd want to
do...or maybe you want to pay him based on the number of days worked in a
given month ?
You could get fancy and pay the employee half the contract amount in the first
pay period of the contract, then a reduced amount in the remaining pay
periods...or get really draconian and pay the employee at a reduced rate until
the last pay period before the contract ends and then pay up the remaining
half or three-quarters !
+ Add "stop rule" functionality to the formula - ie. if there's no pay period
between the current period and the contract end date, then stop the earning
(return STOP_ENTRY).
Other questions which you've probably addressed and should be asked regarding
this approach:
Will the employee remain active on the payroll system when the contract is
over?...
Or will you change their assignment status to something which will not be
included in subsequent payroll runs when the contract is over/fulfilled ?
Can someone have concurrent or overlapping contracts? Would this affect the
calculation at all? Is any kind of validation required in this area?
What happens if the contract is broken before the contract end date?
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/
Printing signatures and Bank details
Date: Fri, 25 Jun 1999 13:02:59 -0500
To: "'orahrms-l@mail-list.com'" orahrms-l@mail-list.com
From: "Krishnasamy, Balaji (Exor)" bkrish@sigeco.com
Subject: [orahrms-l] LaserForms.Plus
Hi,
We are using LaserForms.Plus from EverGreen / Synapsis . We are unable to
print Signature and Bank Details on the checks. Our Env is Digital Unix 4.0c
and Oracle Rel 10.7 Prod 16.1 SC. Any inputs will be highy appreciated.
Balaji Krishnasamy
401K ER/EE Contribution
From: "Michael Scott" mscott@goodegg.com
To: OraHRMS-L@mail-list.com
Date: Thu, 1 Jul 1999 11:39:34 -0400
Subject: [orahrms-l] 401K ER Contribution
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
Date: Fri, 02 Jul 1999 10:41:19 +1200
From: Hankins Parichabutr Hankins@spinsoftware.com
To: Michael Scott mscott@goodegg.com
CC: OraHRMS-L@mail-list.com
Subject: Re: [orahrms-l] 401K ER Contribution
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/
Validation of GL Code Combinations in Payroll Costing
Subject: [orahrms-l] Validation of Account Code Combinations in Payroll Costing
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Date: Tue, 16 Feb 1999 13:35:44 -0500
Is there any way the GL code combinations generated out of Payroll Costing
Process can be validated against cross validation rules in Payroll?
Presently, we are facing a problem where, when the payroll costing is
imported into GL, a number of cross validation rule violations occur.
Apparently, there seems to be no way of validating this in payroll itself
before the costing is transferred to GL.
Has anyone any solution for this?
Gopal Krishna
Consultant-Mastech
Family Dollar Stores
Corporate Office
Tel: 704-847-6961 X3379
E-mail- gkrishna@familydollar.com
Subject: [orahrms-l] Fw: [orahrms-l] Validation of Account Code Combinations in Payroll Costing
From: "William C.Stratton" bstratton@sprynet.com
Date: Tue, 16 Feb 1999 14:42:12 -0500
You are correct. Payroll does not validate the code combinations when the
costing process is run. My guess is that you would have to write your own
report to list the combinations that have not been setup. This process would
have to be run after the Payroll Costing process. All employees who had
violations would have to be rolled back in the Costing run. If the problem
was on the link screen, then the codes could be corrected and the costing
process rerun. If the problem was on a time card or an element entry, then
the entire payroll process would have to be rolled back for the offending
employee, corrected, and then rerun. It just might be easier to fix the
problem on the journal entry in GL and correct the problem in payroll so
that it would not happen again.
To: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com, OraHRMS-L@mail-list.com
Subject: RE: [orahrms-l] Validation of Account Code Combinations in Payroll Costing
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Tue, 16 Feb 1999 15:00:43 -0500
Gopal: Only you have to do is setup the cross-validation rules for the Cost
Allocation Key Flexfield. This is a part of the Oracle Payroll module and
then your Payroll Costing process will adhere to the cross-validation rules.
Let me know if you need any further help or information.
Regards,
Tony Venkatesh (301) 206-8452
http://www.mcsgroups.com
Subject: [orahrms-l] Fw: [orahrms-l] Validation of Account Code Combinations in Payroll Costing
From: "William C.Stratton" bstratton@sprynet.com
Date: Tue, 16 Feb 1999 15:51:07 -0500
Tony,
Would this handle the case where some of the segments are defined at the organization level and the remaining segments are defined at the element link level? They don't come together until you run the costing process. Do they then error out with an appropriate error message when costing is run?
Subject: RE: [orahrms-l] Fw: [orahrms-l] Validation of Account Code Combinations in Payroll Costing
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Wed, 17 Feb 1999 08:21:31 -0500
Bill: The costing run will consider all segment values gathered from
various levels, check them against the x-validation rules and if they don't
meet the criteria, move those records to suspense. Now, what Oracle Payroll
does not give you is a detailed report that breaks out the money sitting in
suspense by its error message. We developed a custom Suspense Account
report that pulls-out all details that make up that suspense account. This
way we can fix all the errors and clear-out the suspense account before
tranferring to GL. Hope this helps.
Regards,
Tony (301) 206-8452
http://www.mcsgroups.com
Fast Formula to modify dedn element calculation
Subject: [orahrms-l] Fast Formula Question
From: Matt_Nebel@gallup.com
Date: Tue, 16 Feb 1999 17:31:27 -0600
I have a situation where I need to modify a 401k deduction element
calculation, but need it to skip a group of 5 people. All can be identified
by employee_number. In SQL I would use:
if ppx.employee_number not in ('10000','10001','10002','10003','10004').
What is the fast formula equivalent?
The database item for employee_number is PER_EMP_NUMBER
Thanks,
Matt Nebel
The Gallup Organization
Payroll accrual entries on monthly basis
Subject: [orahrms-l] Payroll Accrual
From: MAS GOPAL KRISHNA GKRISHNA@FAMILYDOLLAR.com
Date: Wed, 17 Feb 1999 14:25:54 -0500
Cc: "'mVenkate@wssc.dst.md.us'" mVenkate@wssc.dst.md.us
Is there any way I can set up Payroll to create monthly accrual entries? We
have different payrolls which are either weekly or biweekly. The number of
days accrual in a month varies from month to month and payroll to payroll.
Presently, the accrual is done manually on spreadsheet.
Gopal Krishna
Consultant-Mastech
Subject: Re: [orahrms-l] Payroll Accrual
From: pat_keeley@power-one.com
Date: Wed, 17 Feb 1999 13:56:45 -0800
Cc: mVenkate@wssc.dst.md.us
Gopal, I assume you are trying to setup a way to transfer the
information to the GL.
The standard accrual provided by Oracle does not creat an entry to GL.
The accruals are not calculated based on the payroll processing cycle,
but are prorated over the year.
Employer liability elements can be designed using Fast Formula that
will create the costing entries required to pass the information to
the GL. Just a word of warning here, watch your processing
priorities. If the priorities are incorrect, they will cause you some
grief when you modify the "Formula Results."
Good Luck,
Pat Keeley
ARIS Corporation
1-800-331-8326 ext 5237
Subject: Re: [orahrms-l] Payroll Accrual
From: "Ken Conway" k_conway@sprynet.com
Date: Wed, 17 Feb 1999 15:53:16 -0600
Gopal Krishna:
There is no built-in feature within Oracle HR/Payroll to generate automatic
monthly GL accruals. This process will have to be customized based on your
particular needs. You could create your custom process based on a number of
things:
1. An average of payroll costs for previous pay period
2. An average of payroll costs for previous month
3. Review current time period actual time cards and calculate projected
costs. Of course, choosing this option could become almost as complex as
writing your own payroll system.
The key here is to find out what the true requirements within GL and then
prepare to create a custom process to generate entries into GL_INTERFACE.
Hope this helps,
Ken
Ken Conway
BOSS Corporation
Bank Reconciliation
Subject: [orahrms-l] Bank Reconciliation
From: "Menke, Irene M." menke@Mail.Donaldson.com
Date: Mon, 22 Feb 1999 11:38:59 -0600
Hello,
We use a software package called positive pay - to inform our bank of all
checks we issue out of each Payroll. At period end- the bank will send us
back a file of all checks we have issued.
We understand that Oracle AP has a reconciliation feature.
We also understand that Oracle HRMS does not.
Is anyone aware if Oracle plans to add this feature in a future release and
if so do you know which release that might be.
Thank you.
Irene Menke
menke@mail.donaldson.com
612.887.3605
Subject: Re: [orahrms-l] Bank Reconciliation
From: "William C.Stratton" bstratton@sprynet.com
Date: Mon, 22 Feb 1999 13:12:05 -0500
I believe Oracle announced at the last HRMS SIG meeting that bank
reconciliation for payroll checks would be handled within the Cash Management
module. I can't remember if they gave either a release number or date on
when to expect this enhancement. Until then, you will have to construct your
own reconciliation subsystem.
Subject: [orahrms-l] FW: [orahrms-l] Payroll Check Reconciliation
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Mon, 17 May 1999 09:26:06 -0400
I understand that HRMS is integrated with Cash Management for bank
reconciliation in Version 11.
Subject: RE: [orahrms-l] FW: [orahrms-l] Payroll Check Reconciliation
From: "Bacchus, Frank" fbacchus@rwjf.org
Date: Mon, 17 May 1999 09:43:02 -0400
This means that you will have to have Cash management installed also ?
Frank
Subject: [orahrms-l] FW: [orahrms-l] FW: [orahrms-l] Payroll Check Reconciliation
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Mon, 17 May 1999 10:44:12 -0400
That's right, but CM is not a huge undertaking to set up. Getting the bank
to provide the file in the correct format is the most time consuming (in my
experience).
View Employee Paycheck History
Subject: [orahrms-l] HRMS Paycheck History
From: "Menke, Irene M." menke@Mail.Donaldson.com
Date: Mon, 22 Feb 1999 15:36:13 -0600
Could someone pls tell me if it is possible to view an employees history of
paychecks on the Oracle HRMS system. I need the ability to view by employee
or for a certain group of employees all their paycheck detail for a specific
period of time other than period to date,
mtd,qtd,ytd.
And if this is possible - pls tell me what tables I should be getting this
info from - or are there any reports which do this built into the system.
Thank you ,
Irene Menke
menke@mail.donaldson.com
612.887.3605
Subject: Re: [orahrms-l] HRMS Paycheck History
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Tue, 23 Feb 1999 12:22:17 -0500
Yes it is possible. Why write a report when u could just use the balance
package to get the same result by dimension. The mtd, qtd and ytd are
simply different dimension.
The balance package name and the fuction u need is pay_balance_pkg.get_value
The function get_value is an overloaded function. U simply pass the
defined_balance_id (which is the balance name and the dimension, e.g qtd)
and then the assignment_action_id.
It works great.
Regards
Manny.Wohiren@yale.edu
Subject: RE: [orahrms-l] HRMS Paycheck History
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Tue, 23 Feb 1999 14:36:42 -0500
Irene: Once the pre-payment process is completed, you can identify check
numbers and amounts from Pay_Assignment_Actions and Pay_Pre_Payments tables,
respectively. No need to use the pay_balance_pkg for this. We created our
positive pay filing using this information. Hope this helps.
Regards,
Tony x8452
http://www.mcsgroups.com