Supervisor on EE - Assignment effective date
Subject: [orahrms-l] Supervisor On EE Assignment
From: "Jarnutowski, George J." JarnGJ@jea.com
Date: Tue, 20 Jul 1999 12:20:56 -0400
Cc: "Oakes, Beverly A." OakeBA@jea.com
We are on 10.7 SC and my company is in the process to put Supervisors to an
Employee Assignments in order to do Organization charts, etc.
My question, when I'm on the Assignment form and the Effective date of this
person assignment is 13-Mar-1972 and we put a Supervisor on the employee
with a effective date of 16-Mar-1987 we get the following message "APP
-07599: Supervisor is not valid for the duration of the assignment". Have
several of these. Any suggestions before I go to ORACLE support?
Subject: Re: [orahrms-l] Supervisor On EE Assignment
From: "Carol L Ortiz" clortiz@us.oracle.com
Date: Tue, 20 Jul 1999 13:23:35 -0400
Cc: "Oakes, Beverly A." OakeBA@jea.com
George --
Here's an example from a Tar with the same APP-07599 error message:
Assignment eff dates:04/26/99 to EOT
Supervisor eff dates: 06/15/99 to EOT
You can't add a supervisor that did not exist on 04/26/99 to the assignment.
You
can Update the record to begin on 06/15/99 with the supervisor. This will
cause two records to be in the database for the assignment; 1 for 04/26/99 -
06/14/99 with no supervisor and another for 06/15/99 with the supervisor.
Carol
Carol L. Ortiz
Senior Technical Analyst
Oracle Support Services
Email: clortiz@us.oracle.com
Fax: 407-458-4205
Subject: RE: [orahrms-l] Supervisor On EE Assignment
From: "Schwartz, Ken" kschwar@rwjf.org
Date: Tue, 20 Jul 1999 13:18:41 -0400
Cc: "Oakes, Beverly A." OakeBA@jea.com
George:
This error is due to the dates on the assignment form. I would 'update'
something on each persons assignment. The purpose of the 'update' would be
to change the effective date. Once the effective date is changed, the error
message should go away.
By the way, if you wish to have someone appear as a 'manager' for a
particular organization, there is a manager flag on the assignment record,
miscellaneous category. Check that box to have that employee appear as the
'manager' on the Organization Hierarchy Report, a standard Oracle HR report.
Please contact me directly if you need additional assistance.
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] Supervisor On EE Assignment
From: "Scott Frost" sfrost@noblestar.com
Date: Tue, 20 Jul 1999 13:56:26 -0400
Great suggestions....
also, be careful if you are using the Position Hierarchy to manage your
supervisors, you may run into a problem having 2 supervisors over an
employee. This happens if you do not enter a FINAL PROCESS date on the
TERMINATION screen after an employee has been terminated from a position.
You must also make certain that you perform the FILL POSITION HIERARCHY
PROCESS. This will make the necessary updates due to employee assignment
changes.
Good luck!
Scott
Subject: [orahrms-l] Re: [orahrms-l] Supervisor On EE Assignment
From: CORNELIS E VAN WIJK CORNELIS.E.VAN_WIJK@slchicago.infonet.com
Date: 20 Jul 1999 12:13 GMT
On the assignment form when populating the supervisor region you will
have a choice of correction or update, this shows in a pop_up window.
The form should allow you to do an update even if the supervisor's
record is not valid for the duration of the employee's assignment. It
will not allow you to do a correction. For a correction the
supervisor record has to be valid during the entire duration of the
employee's assignment. The same is true when using the oracle hr apis
to migrate or update data from a legacy system
Also bear in mind that the supervisor you enter on the assignment form
is a personal supervisor for an employee and is not updated by the
system. In order to create organization and position charts you would
use the organization and position hierarchies to show management
reporting lines.
Ed van Wijk
Sr. Consultant
Sargent & Lundy
hr.PER_PEOPLE_EXTRA_INFO table
Subject: [orahrms-l] hr.PER_PEOPLE_EXTRA_INFO
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Wed, 28 Jul 1999 09:11:06 -0400
Folks
Could u please select count(*) from HR.PER_PEOPLE_EXTRA_INFO and let me
know if u have any rows in this table.
Thanks a bunch.
Regards
Manny.Wohiren@yale.edu
Unable to Assign an Address to an employee
Subject: [orahrms-l] Unable to Assign an Address to an employee in HRMS
From: sena@enoc.co.ae (SENAPATHY SRINIVASAN (GTS))
Date: Mon, 02 Aug 1999 20:55:36 +0400
Unable to Assign an Address to an employee in Define People Enter & Maintain
Form
I was trying to create an address for an employee in the People Enter & Maintain
Form form in Oracle HRMS. The basic employee details had already been created. I
then clicked on the address button. This transported me to the addresses form.
Here HRMS is expecting values in the City, State, Country fields. When I try to
enter a value in the City field, I received a message that the value was
invalid. I then realised that this field was controlled by a LOV. Where does one
enter values to populate this LOV. Is this a Key FF, Desc FF or a Quick Code.
The 10.7 SC online help is silent about this and no context sensitive help is
available. Help required urgently.
Thanks Senapathy
Subject: Re: [orahrms-l] Unable to Assign an Address to an employee in HRMS
From: "Lewis Cunningham" lcunning@mediaone.net
Date: Mon, 2 Aug 1999 10:47:51 -0700
I'm tying to think of where that would be entered. I don't ever remember
having to key in cities. Is it possible something didn't get seeded during
the install? I don't have apps available to me right now to check but there
is something under the menu option, can't remember the name now, somthing
like Other Definitions. It's right above the security option in the HR
Manager GUI responsibility. I think I remember something about cities there
but I've never had to use it.
I think I would check the install logs. Hope this helps,
Lewis
Subject: [orahrms-l] Re(2): [orahrms-l] Unable to Assign an Address to an employee in HRMS
From: jurodriguez@answerthink.com (Juan Rodriguez)
Date: Mon, 02 Aug 1999 14:45:39 -0400
Senapathy,
City names are part of the Oracle HRMS legislative data that is dowloaded
during the post install steps of the applications.
The city data is used for tax calculations in a payroll environment. In
R11.02 the main person flow had the wrong address form and even HR only
environments had the address validation executing.
Are you in an HR only environment? HR and Paroll? If the later is the
case, Oracle does give you a form to add cities and city details to the
database. This is due in part to the ever changing legislative environment
in the payroll world.
Hope this helps!
Juan
Subject: [orahrms-l] Still Unable to Assign an Address to an employee in HRMS
From: sena@enoc.co.ae (SENAPATHY SRINIVASAN (GTS))
Date: Tue, 03 Aug 1999 13:15:20 +0400
To add to my previous messge, we are on Financials, HR & Payroll. We are
planning to implement HR & Payroll only after Financials stabilises. We are
doing only those HR related setups that are mandatory for Financials to work
currently. I am mandatorily required to enter an address for the employee in HR,
so that the employee can be automatically created as a vendor in Oracle Payables
and be used for Expense Report Processing. We are in the Middle East and need
our states and cities to be feature in the address here. I had already tried to
go the Cities form in the Other Definitions form, but could not add any values.
In this situation, can someone tell me, how to get the City, State, County, ZIP
code combinations in, so that I can enter the address in the Define Employee
Form.
Thanks Senapathy
Subject: RE: [orahrms-l] Still Unable to Assign an Address to an employee in HRMS
From: Sandy Honigsberg Sandy.Honigsberg@orange.co.il
Date: Tue, 3 Aug 1999 13:01:26 +0200
Personal addresses in HR are entered in the "Personal Address Information"
descriptive FF.
It is a specialised structure in that it does not have Attributes; rather
the Columns are
various address components.
The Personal Address Information DFF is Context sensitive and the system
allows you to create your own local address structure. Within that
structure, the
value sets you associate to any segment (such as City) are entirely at your
discretion. That would include free text, though I would strongly suggest
that segments such as cities, regions, etc be validated. Validation may be
done via Independant Value sets or Table validated Value sets that draw from
the Quickcode table (FND_COMMON_LOOKUPS).
Good luck
Sandy Honigsberg
Malam Systems
Subject: Re: [orahrms-l] Unable to Assign an Address to an employee in HRMS
From: "Kevin Jarrett" kejarr@copelco.com
Date: Tue, 3 Aug 1999 07:55:01 -0400
Senapathy,
The earlier posters were correct to ask you for more information about your
setup.
Which release are you on? Also, are you HR only or HR and Payroll? Finally,
who did the install and when?
I can only speak to release 10.7, not 11, as that is my only area of
expertise. That being said, we've been through hell and back with VERTEX
(the program that controls City/State combinations). If you're on 10.7, you
can either email me directly or post back here, and I'll share what I
know...otherwise, someone more familiar with 11.x can speak up.
Let me know, thanks.
-kj-
Kevin Jarrett Copelco Capital, Inc.
E-Commerce Project Manager Mount Laurel, NJ USA
kejarr@copelco.com http://www.copelco.com
Subject: RE: [orahrms-l] Unable to Assign an Address to an employee in HRMS
From: Laurie Bosley lbosley@solbourne.com
Date: Tue, 3 Aug 1999 08:12:02 -0600
Senapathy,
It appears from your message that you're on 10.7, but for the record adding
cities, states and zip codes is standard functionality in release 11.
Subject: Re: [orahrms-l] Still Unable to Assign an Address to an employee in HRMS
From: Diana Kane diana_kane@compuware.com
Date: Tue, 03 Aug 1999 09:32:44 -0500
If the HR post installation steps were not completed, you will have similar
problems. Check with the person who did the install to assure that all
post installation steps for HR have been completed and all manditory
patches have been applied.
Subject: Re: [orahrms-l] Still Unable to Assign an Address to an employee in HRMS
From: "Kevin Jarrett" kejarr@copelco.com
Date: Wed, 4 Aug 1999 06:50:03 -0400
>>>
If the HR post installation steps were not completed, you will have similar
problems. Check with the person who did the install to assure that all
post installation steps for HR have been completed and all manditory
patches have been applied.
<<<
Diana has NAILED IT!
Senapathy, you should run, not walk, to the nearest person who can validate
your apps install. There are queries that can be run to test for the
existence and correct number of VERTEX objects in the schema. Trust us. The
post-install steps (and subsequent patches) are REQUIRED to get VERTEX up
to speed, and without them, address validation will never work.
I also see that no one (yet) has warned you about the dangers of
implementing HRMS after Financials. While you may be aware of the risks, I
want to be sure to let you know -- if you don't get the HR and Payroll
functional staff involved NOW, while you are building the base structures
that are shared across the Financials and HRMS applications, I guarantee
you will experience horrors that make your missing city validation issue
look like child's play.
Like they say, been there, done that. :/
To help, I'll email you under separate cover an excellent white paper on
this very subject that was presented by Kimberly Fain, a good friend and
former colleague of mine at Oracle Consulting.
I'll close with this quote, which I am paraphrasing another former Oracle
colleague:
"Implementing Oracle HRMS after Financials without any involvement from the
HR and Payroll functional experts is akin to adding a full basement to an
existing house. It can be done, but it's not easy, and it's expensive as
hell."
Good luck to you, sir!
-kj-
Subject: [orahrms-l] Unable to Assign an Address to an employee
From: sena@enoc.co.ae (SENAPATHY SRINIVASAN (GTS))
Date: Wed, 11 Aug 1999 14:48:56 +0400
Thank you for the overwhelming response to the above problem. We managed to
solve the problem by inserting the relevant records that create an address for
the city using SQL. This approach is working fine and is now tested.
Senapathy
Not assigning Job/Position to individuals that run through payroll
Subject: [orahrms-l] Not assigning Job/Position to individuals that run through payroll
From: "Pennington, Kenneth" kennethpennington@kpmg.com
Date: Wed, 4 Aug 1999 14:22:38 -0400
I am working with a client who has a person type/"employment" type where
careful considerations have to be made so that the individuals in this
category do not appear to be "employees" of the organization. These
individuals are Academic Fellows that do not provide service/s to the
organization but receive stipends for training, scholarship activity, and/or
other personal development like activities. These individuals will be paid
through payroll, can receive benefits, and can have OSHA, Affirmative
Action, and location specific relationships to the organization.
The client has developed a solution that would not give the individual a
position and job. Payment to the individual would not be done through the
regular wages or regular salary element. On the Salary Administration Form,
salary of $0.00 will be assigned. An additional element will be added to
the element entry to pay their stipends.
We will be going live with Oracle Human Resources and Payroll release
11.0.2. Does anyone know if there will be any long-term and/or short term
issues that could arise from this setup?
Thank you in advance for your input into this issue...
Ken Pennington
KPMG LLP, Consultant
Subject: Re: [orahrms-l] Not assigning Job/Position to individuals that runthroughpayroll
From: Gina Williams gmw2366@ritvax.isc.rit.edu
Date: Thu, 05 Aug 1999 11:30:12 -0400
We are live on 10.7 NCA and have a similar, although not identical setup
that we are using to pay our Adjunct Faculty Members.
These people are given the person type of employee, although they do not
receive benefits. They are similar to contract workers. (I suppose you
could call their person type whatever you want to, we have another
person type called "Student employee".)
Our Adjuncts have their own Organization called Adjunct Faculty Org and
their own people group (Adjunct faculty-Exempt). They do not have jobs
or positions. Their employment category is parttime-regular.
We use recurring flat amount earnings elements which we end date so that
they only pay for the period the person works (ie: 6 weeks or 3 semi pay
periods) and we put in $0.00 on the salary administration screen.
We have set them up with a separate salary basis called Semi Monthly
Salary which does not use the seeded Regular Salary element.
The only problem that we ran into, was that when we set the end date of
the element for the same date as a payroll end date (ie: payroll runs
7/31/99 and the element end date was set to 7/31/99) a rollback in the
payroll was reversing our end dates and people were getting overpaid if
we did not catch it before the next payroll. We now end date the
elements for 1 day after the payroll end date which coincides with the
end date of the element.
We were told by Oracle support that a vote will be held on this soon to
determine whether or not this (bug!) should be considered an
enhancement. Enhancement request number #429275.
Hope this helps.
Good luck,
Gina Williams
Business Analyst
Human Resources Department
Rochester Institute of Technology
8 Lomb Memorial Drive
Rochester, New York 14623
716-475-6075
GMW2366@RIT.EDU
Automatic Employee numbering to start with 1000 and not with 1
Subject: [orahrms-l] Automatic Employee Numbering
From: SBur433633@aol.com
Date: Tue, 3 Aug 1999 09:32:57 EDT
On 11.02.
We want to start the automatic employee numbers at 1000 instead of Oracle's
default of 1.
Does anyone know how to define the start number.
Subject: Re: [orahrms-l] Automatic Employee Numbering
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Tue, 03 Aug 1999 10:01:18 -0400
select * from hr.PER_NUMBER_GENERATION_CONTROLS
For your business group and the type (for example) EMP, update the
next_value to 1000.
Regards
Manny.Wohiren@yale.edu
Subject: RE: [orahrms-l] Automatic Employee Numbering
From: "Schmit, Mark" mschmit@Mail.Donaldson.com
Date: Tue, 3 Aug 1999 09:04:20 -0500
I'm going to assume that the automatic numbering of employees is already
set. If not, e-mail me back and I'll show you what code to change to get
that set to automatic.
But you will want to:
update per_number_generation_controls
set next_value = 1000
where business_group_id = (select the correct organization_id
from hr_organization_units for the business group you want)
and type = 'EMP';
Hope this helps.
Mark Schmit
Donaldson, Inc
612.703.4606
Automatic Numbering of Emplyees has frozen
Subject: [orahrms-l] Automatic Employee Numbering
From: "Michael Scott" mscott@goodegg.com
Date: Fri, 6 Aug 1999 11:41:29 -0400
We are using Automatic employee numbering, which seems to have frozen at
1776 (How patriotic, I hope oracle HR PAyroll is not declaring its
independence). Does anyone have ideas why it will not assign new
sequential numbers, or how to unlock this suppossed freeze on new numbers?
I am taking this one too ORacle Support.
Thanks
MS
Subject: Re: [orahrms-l] Automatic Employee Numbering
From: "Ken Conway" ken.conway@bosscorporation.com
Date: Fri, 6 Aug 1999 11:05:50 -0500
Michael:
This is a new one to me. I would start with your DBA to see if any of
tables or sequences are locked. If there is nothing obvious, then you
should promptly call Support.
Good luck,
Ken
Ken Conway
BOSS Corporation
Better Organization Service Solutions
\(214) 495-7654 Voice
(214) 495-7543 Fax
www.bosscorporation.com
From: Stroud, Wayne
Sent: Friday, August 06, 1999 11:06 AM
To: 'Michael Scott'; 'OraHRMS-L@mail-list.com'
Subject: RE: [orahrms-l] Automatic Employee Numbering
Mike, I've seen this happen once before (the number wasn't 1776
though). We deleted the last employee that was entered and keyed him
back in, it cleared the problem and it never has happened since.
Strange.
Thanks,
Wayne
Employee number - skips when Applicant becomes employee
From: Stroud, Wayne
Sent: Friday, August 06, 1999 10:00 AM
To: OraHRMS-L@mail-list.com
Subject: Applicant to Employee numbering problem
Hello everyone,
We are running 11.02 using applicant tracking (the Applicant Quick Entry
form) and have automatic numbering for Employees and Applicants. If we
enter a new employee in directly as an employee, the employee numbering
works great incrementing by 1. When we enter Applicants through the
quick entry form, it also works incrementing the applicant number by 1.
However, when we accept an Applicant and then hire them making them an
Employee, the employee number is incremented by 2 (skipping a number).
It's as if the next available number is getting hit twice by hiring an
Applicant to Employee. We have Oracle looking at this, but haven't heard
anything yet. Has anyone using the Applicant Quick Entry form, accepting
and then hiring the employee seen this before or does it work correctly
for you? By the way, our test instance 11.03 is working the same way.
Thanks in advance for any help,
Wayne
Subject: RE: [orahrms-l] Applicant to Employee numbering problem
From: "Pennington, Kenneth" kennethpennington@kpmg.com
Date: Mon, 9 Aug 1999 11:00:47 -0400
Greg,
I ran into the same issue with a recent client. The value set just 'stuck'
according to Oracle Support.
They gave us the SQL code below to fix the issue.
select max(next_value)
from per_number_generation_controls;
(get the value)
Then do:
update per_number_generation_controls
set next_value = {value from above +1}
where type = 'EMP' and business_group_id = {your BG id}
Hope this helps...
Correction Vs update, SOE and W2 implications
From:
Adam Gates AGATES@FAMILYDOLLAR.com
26 Aug 1999 8:52 PM
Subject:
[orahrms-l] Correction versus Update, SOE and W2 implications
Fellow Oracle HR and Payroll Colleagues,
We process thousands of changes per week on employee's records in Oracle HR
and PAYROLL.
Some of our dilemma's is to combat the situation where an employee's name
changes (i.e. Jane Doe---to---Jane Elk),
or correction to spelling (i.e. Jane Dooe---to---Jane Doe),
or correct the social security number,
and process these as CORRECTION vs. UPDATES.
This seems to be creating 2 different records vs. just keeping one record,
and we are unable to view the old information especially SOE's.
(i.e.We can't see Jane Doe's SOE's anymore, because her name does not exist
in the system!!!)
Also, quite possibly effects W2's, something for every one to think about!!
Has anyone else came across this issue?
If so, how did you fix or overcome the problem?
Thanks in advance for any help or comments.
Adam Gates
agates@familydollar.com
From:
"Bob Cody" Bob_Cody@norstanconsult.com
8/31/99 2:54 AM
Subject:
Re: [orahrms-l] Re-Submitting Question on CORRECTION vs. UPDATE, no feedback yet on this issue!
To:
AGATES@FAMILYDOLLAR.com
Adam,
Have your users check out the date track
instructions in the
Oracle Payroll User's Guide (1-9 to 1-15 for 10.7 SC)
It sounds like someone may be updating when
they should be correcting.
Update creates a new record.
Bob Cody
bob_cody@norstanconsult.com
Make Secondary Assignment as Primary
From:
"shekhar reddy" shekharhrms@hotmail.com
27 Aug 1999 6:50 AM
Subject:
[orahrms-l] end primary assignment and make secondary as primary
Hi ,
i am trying to end a primary assignment and make the secondary assignment
as the primary assignment ,i could not sort out the way to implement this
through the API's .any help regarding this is appreciated
Thanks
Shekar