ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
HRMS - PAYROLL



Tracking Retirees and their benefits

Subject: [orahrms-l] HR: Retirees and benefits, COBRA
From: Lewis R Cunningham lcunning@lmumail.lmu.edu
Date: Tue, 20 Jul 1999 15:54:29 -0700

Hi,

I have a solution to my issue but wanted to check and see how others are doing this.

The issue: Tracking Retirees and their benefits.

How are any of you designating employees as retirees? Do you terminate them, for reason Retirement, and use a person_type of retiree?

That's the easy part. How do you track their benefits AND payments for benefits? Basically my client treats certain categories of retirees as a kind of COBRA. Based on certain criteria, they are entitled to full benes for a while, which they partially pay for, and then loose their eligibility after a time. I'm not talking about the 18 month COBRA termination eligibility. This is specific to my client and could be many years.

Tracking their elections is easy, give them a future final process date which is when the benefits end. But how do you (do any of you?) track retirement payments?

Also, a question on COBRA. California has a requirement to give terminated employees benefits for 29 months instead of 18 months, if they were disabled when terminated. Has anyone found a way to do this without customizing HR's COBRA module?

Thanks in advance,
Lewis
Lewis R Cunningham
Whitaker IT
Oracle Human Resources Functional and Technical Consultant
LewisC@rocketmail.com


Subject: RE: [orahrms-l] HR: Retirees and benefits, COBRA
From: "Beers, Al" abeers@kpmg.com
Date: Wed, 21 Jul 1999 00:06:17 -0400

My client lists retirees as employees (approximately 2000 retirees). They are assigned to their own payroll - Pension. Elements were created such as Retiree Health Plan, Pension earnings and deductions, etc. These elements are linked exclusively to the Pension payroll. If an employee is eligible and opts to retire, he is not terminated. Instead, he/she is transferred to the pension payroll.

My client is not utilizing the Oracle COBRA forms.

Al Beers
KPMG
Sr. Consultant, Oracle Practice
Houston Office: 713-319-2601
Client Site: 203-432-8467
Cellular: 281-788-5589


Subject: [orahrms-l] Fwd: HR: Retirees and benefits, COBRA
From: Lewis R Cunningham lcunning@lmumail.lmu.edu
Date: Wed, 21 Jul 1999 12:55:40 -0700

I have an answer on my COBRA question about the 29 months for terminated with a disability. Someone here on the listed pointed out that it's not just CA as I thought but standard nationwide. I went back and played with it and if a person has the disabled checkbox checked on the person screen and then is terminated, the COBRA benefit period is 29 months.

Thanks, Lewis



Journal Import of Payroll Costs

Subject: [orahrms-l] Journal Import of Payroll Costs
From: "Michael Scott" mscott@goodegg.com
Date: Wed, 21 Jul 1999 13:14:13 -0400

Trying to import multiple Journal entries based on Multiple payrolls in HRMS. The only recognizes one summary journal at import, and no transaction ID. Is anyone else having this problem in Version 11.

MS


Check Writer not printing

Subject: [orahrms-l] Check Writer Will Not Print
From: "Phillips, Laura" LPhillips@jwrinc.com
Date: Tue, 3 Aug 1999 11:51:06 -0500

Title: Check Writer Will Not Print
Hello All -

Having trouble with Check Writer. When trying to print salary checks or third-party checks, I submit request for Check Writer but nothing prints. When I hit the Reports button from the View Requests screen it says

Error

The Applications File Server could not open the file
/u04/app/applmgr/common/PROD/out/p123584.ch
for read.

Does anyone know what's going on? Support is working on the TAR but no answers yet.

Thanks in advance for any help.
Laura Phillips
Jim Walter Resources, Inc.


Subject: Re: [orahrms-l] Check Writer Will Not Print
From: "William C.Stratton" bstratton@sprynet.com
Date: Tue, 3 Aug 1999 13:33:04 -0400

Title: Check Writer Will Not Print
Checkwriter does not automatically print your check images to a printer. This process only prepares the check images and places them in your "OUT" directory. The name of the file will be p.ch where is the request id of the Checkwriter run. You are responsible for spooling the image file to the desired printer. This is actually a desired result, since you do not want the checks to start printing until you are ready for them. The checkwriter process has been known to run for a considerable amount of time before it completes.

You should, however, be able to view the image file via the View button on the request screen. I do not know why this is not working. Hopefully, this is what Oracle Support is working on, and not why the images do not automatically print.



Separate checks for each assignment

Subject: [orahrms-l] Multiple Assignments/Multiple Checks?
From: "Lewis Cunningham" lcunning@mediaone.net
Date: Tue, 3 Aug 1999 10:17:55 -0700

Hi.

I'm more of an HR person than a payroll person but I have a question.

I was just talking to a person at another site. They are still in the implementation phase not production. This is r11.

They're running a payroll and people who have multiple assignments are getting a seperate paycheck for each assignment. Now I could understand if they were on different payrolls but each assignment has the same payroll. Is this right? I thought it should be one check per person per business group.

Any insight would be appreciated,

Lewis
Lewis R Cunningham
Senior Oracle HR Consultant
lewisc@rocketmail.com


Subject: RE: [orahrms-l] Multiple Assignments/Multiple Checks?
From: "Schwartz, Ken" kschwar@rwjf.org
Date: Tue, 3 Aug 1999 13:30:23 -0400

Lewis:

Thats a 'feature' of the Oracle payroll system.

I believe that having multiple assignments generate a single check is gooing to be available in the future...like release 12.

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


Subject: Re: [orahrms-l] Re: Multiple Assignments/Multiple Checks?
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Wed, 04 Aug 1999 09:42:49 -0400

Dude
I saw your question and i thought someone answered correctly, hence i did not venture an answer. But, i do know how u feel when u don't get a good answer.

Anyway, if u have multiple assignments and have payroll and pay basis atttached to both assignments and assuming u have "earnings" element attached to both assignments the employee will get 2 checks. This is a standard feature of Oracle HR.

If u remember correctly at Yale (Lewis and I worked at Yale University for a period, b/4 he moved to good old California), we chose to attached earnings, PTO, Benefits elements, etc only to the Primary Assignment. All secondary assignments are for HR purposes only.

Regards
Manny


Subject: Re: [orahrms-l] Re: Multiple Assignments/Multiple Checks?
From: "Lewis Cunningham" lcunning@mediaone.net
Date: Wed, 4 Aug 1999 08:47:52 -0700

Actually, I do remember now. I thought that was a business decision instead a feature of Oracle.

Thanks, Lewis



Deposit Advice not printing

Subject: [orahrms-l] deposit advice ..not prinitng??
From: "manu kkk" manu1357@hotmail.com
Date: Wed, 04 Aug 1999 08:46:35 CDT

Hi All,
I am new to this forum and also to the HRMS world. So Pls bear with me if the questions look too stupid: My setup is HPUX 10.2, 10.7 NCA, HRMS package right now.

1) We are live since Jan '99 but still not on direct deposit. For testing the Direct deposit stuff we are doing the following steps:

-- Run the Payroll process on a set of 5 people. 4 of them have banking information entered for them but 1 has no banking info. Out of 4 persons having banking info , 2 of them have the info 'Prenote information' filled for them manually .

2) Run the prepayment on this set of persons.
3) Run the Check Writer.
3) Run the NACHA process after this.
4) At this instance we are able to see the pay process results and assignment process results from the 'US HRMS Manager' responsibility.
5) The person who had no info for banking details filled got the check from the check writer.
6) The two persons who had been filled the 'Prenote info' manually got the money into their bank a/c corectly (we are able to see that in the system under )
7) The remining 2 person who were having the banking details filled but no 'prenote info' got the checks thru check writer and were shown 0 amount under their 'Direct Deposit' head which makes sense I think.
8) When we run the deposit advice , it completes successfully but their is no output .

My question is why we are not getting any output from the 'Deposit Advice' process?? Any ideas/suggestions will be greatly appreciated.

thanks


Check Sorting - patches 935062 and 913411

Subject: [orahrms-l] Check Sorting - Patches, Customize report PAYRPCHK
From: "Shah, Nilesh" NileshS@ccai.net
Date: Thu, 5 Aug 1999 20:26:26 -0400

Did anyone apply the Patches 935062 and 913411 for the Check Sort problem. If yes did this solve the check sort problem. Did you have to do anything else apart from applying this patch.

We have not yet recd. this patch and are waiting for them.

Also has anyone tried to successfully modify/customize the report PAYRPCHK report to alter the sort sequence. I tried this today and was'nt successful. Since we need to sort by location and name. I joined the pay_assignment_Actions table to people and assignment table and performed order by location_id, full_name. The report's output does not change.

Thanks in advance.


Subject: RE: [orahrms-l] Check Sorting - Patches, Customize report PAYRPCHK
From: Peter Kandra pkandra@civicdevelopment.com
Date: Fri, 6 Aug 1999 07:03:10 -0400

We've applied both patches, and the CheckWriter is still not sorted correctly. If you query the tables, the assignment actions are processed in the sorted order, but the check writer itself isn't sorting them.


Subject: RE: [orahrms-l] Check Sorting - Patches, Customize report PAYRPC HK
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Fri, 6 Aug 1999 10:42:34 -0400

Nilesh/Peter: The check sorting is controlled by a package pay_chqwrt_pkg that is available in your PAY_TOP directory path on the server. This has a default sorting defined. Modify this package to suit you needs, include a custom check sort quickcode and you are set. Hope this helps.

Regards,
Tony Venkatesh
(301) 206-8452
(703) 793-0847
tonyv@mcsgroups.com


Subject: RE: [orahrms-l] Check Sorting - Patches, Customize report PAYRPC HK
From: "Shah, Nilesh" NileshS@ccai.net
Date: Fri, 6 Aug 1999 11:31:00 -0400

I did all that is mentioned below but to no success.

Have you used this and does it work.


Subject: RE: [orahrms-l] Check Sorting - Patches, Customize report PAYRPC HK
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Fri, 6 Aug 1999 11:37:08 -0400

Yes, it does work. You say you have done all this, but never mentioned it in your mail. I would strongly suggest looking into the package pay_chqwrt_pkg.

Regards,
Tony Venkatesh
(301) 206-8452
(703) 793-0847
tonyv@mcsgroups.com



Paymix Batch Process - Validation not working

Subject: [orahrms-l] Paymix Batch Process - Validate Batches
From: PA DAVID SELVARAJ DSELVARAJ@FAMILYDOLLAR.com
Date: Fri, 6 Aug 1999 10:19:55 -0400

When we run the Paymix batch Process to validate the batches, the validation is passing thro' for some of the batch lines even there's no element LINK exists for the particular assignment.

Did anybody encounter this problem?
Is there any patches to solve this problem?
We're on 10.7 NCA.
Any help would be appreciated. Thanks.
-- David Selvaraj


Regular Salary and Wages not processing

Subject: [orahrms-l] Regular Salary and Wages not processing
From: "Lyng, Janice E" jlyng@kpmg.com
Date: Wed, 11 Aug 1999 13:41:36 -0400

Folks,

I really need some advise on the following:
I am at a client site implementing Oracle Payroll Release 11.0.2 We are in the initial process of the Conference Room Pilot setup and we are just starting to test out basic Oracle functionality.

1. I have created a salary basis for salaried employees and designated the regular salary element to this basis.

2. I have linked the element regular salary to the appropriate payroll

3. I have given the employee information on the salary administration form.

4. The element does appears on the element entry form.

I receive the following error messages:
Error was encountered when processing assignment 91
Error was encountered when processing Element Type Regular Salary
Error was encountered when processing formula REGULAR_SALARY
An error occurred during formula execution:

No such formula (6)

I have logged a TAR with Oracle support... and I wait.

Can't anyone point me in a right direction to troubleshoot this???

Janice
Janice Lyng
Consultant
KPMG LLP
Phone - 518-427-4717


Subject: Re: [orahrms-l] Regular Salary and Wages not processing
From: Hankins Parichabutr Hankins@spinsoftware.com
Date: Wed, 11 Aug 1999 12:48:38 -0600

Is the REGULAR_SALARY formula somehow in an uncompiled state...?

"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/


Subject: RE: [orahrms-l] Regular Salary and Wages not processing
From: Scott Madole smadole@solbourne.com
Date: Wed, 11 Aug 1999 15:51:37 -0600

You probably need to run teh Bulk Compile formulas process. Check first to see if the formula "REGULAR_SALARY" is marked as verified. If it is not then run the Bulk Compile Formulas process from the Submit Request form under the responsibility of US HRMS Manager



Any white paper on Paymix Batch

Subject: [orahrms-l] Paymix Batch Process
From: PA DAVID SELVARAJ DSELVARAJ@FAMILYDOLLAR.com
Date: Wed, 11 Aug 1999 16:42:28 -0400

Is there any white paper on Paymix Batch Process.? Can anybody help me out where can i find it.?

Thanks in Advance
--David Selvaraj.


Subject: Re: [orahrms-l] Paymix Batch Process
From: OraHRMS-L List Owner gaclark@ibm.net
Date: Wed, 11 Aug 1999 18:37:05 -0400

David,

The US Implementation Guide contains a technical essay on PayMIX in Appendix A. Topics such as user customization, PayMIX architecture, and PayMIX processes are covered.



Voiding a check and its effect on GL

Subject: [orahrms-l] Void checks/Reversal impact on G/L
From: Ron Pribyl RPribyl@amctheatres.com
Date: Thu, 12 Aug 1999 11:09:00 -0500

Greetings:

We are on 10.6SC version of HRIS.

When we reverse a paycheck, the impact to the employee's records is correct - the wages, taxes, etc. are reduced appropriately.

As we have discovered, the reversal transaction is not passing to Oracle's General Ledger. We called Support and their answer was to roll back all costing beginning with current pay period through the effective date of the voided check. Since the voided check may have been written months ago, the idea of rolling back all the costing is not acceptable.

Their other solution was to make a manual journal entry for every reversed check. (I thought we are in the electronic age???)

How does anyone else handle this situation?

Ron Pribyl
Payroll Manager
AMC Theatres
Rpribyl@amctheatres.com


Subject: RE: [orahrms-l] Void checks/Reversal impact on G/L
From: Charles Neal CGNeal@ci.las-vegas.nv.us
Date: Thu, 12 Aug 1999 12:01:38 -0700
Cc: "'Ron Pribyl'" RPribyl@amctheatres.com

Did you Void the check or use the Reverse process?

'Void'ing doesn't 'void' the costing, so it really doesn't 'void' it from your cash records.

We use the Oracle reverse process which can be included in costing. We've referenced the book on the 'VOID' process and it is really for just voiding one check number (which no, still doesn't let your reconciliation records know about it, since they don't exist in Oracle) and replacing that with another check number. And even that doesn't work well when it subsequent payrolls have been processed.

Did you use the 'Reverse' process,
since it appears you are doing more than just 'voiding' a check?

- Charles G. Neal
Systems Analyst II / City of Las Vegas



Ceridian - intra-pay period changes

Subject: [orahrms-l] ATTN: Ceridian Source100 Interface Customers
From: "Kevin Jarrett" kejarr@copelco.com
Date: Thu, 12 Aug 1999 18:23:32 -0400

[If you are presently using, implementing, or are familiar with the Oracle HR/Ceridian Source100 Payroll interface, this message is for you. If not, sorry for the wasted bandwidth.]

Fellow Oracle/Ceridian interface clients and implementers,

We are being told by Ceridian that intra-pay period changes can create unexpected results when brought through the interface. Is that correct? If so, I'm curious as to how you are dealing with this.

Example:

A new employee starts on 09-Aug. The record is created and transmitted through the interface into S100 the next day during our normal "pull". Two days later, the employee's address changes. The interface view sees the change and sends the record through the interface again on a subsequent pull. In the process, the employee's status code (in this example) changes from "N" (new) to NULL.

Our users (across the USA) process changes in Oracle HR daily. We pull records through the interface daily (we typically load the prior day's activity each morning at 9am). In this scenario, once a new hire has their status reset, they are rejected when we transmit payroll.

Does anyone else have this problem? Is it a known limitation of the interface? Does it happen with ALL intra-pay-period changes? What is the workaround, if any?

Thanks in advance for your help,
-kj-
Kevin Jarrett Copelco Capital, Inc.
E-Commerce Project Manager Mount Laurel, NJ USA
kejarr@copelco.com http://www.copelco.com


SQL to get Employee details for a check

rom: "manu kkk" manu1357@hotmail.com
8/23/99 7:49 PM
Subject: [orahrms-l] HRMS SQL challange

Hi friends,
Need some help in SQL..
I want to develop some scripts for pulling out employee details for any given check date. My idea is to list out each earning and deduction for any employee for any given check date.

I am sure subscribers to this list must be having some ideas or some of you might have implemented this in your setup. I will really appreciate if anyone shares that with me. I want to undertake this to have a backup for my Quarterly tax reportsOr pls guide me in the right direction.

thanks a lot in advance
regds