Mixed queries on HRMS
Subject: [orahrms-l] HRMS Issues
From: Bekah Pheifer bpheifer@iquest.net
Date: Thu, 01 Apr 1999 16:15:43 -0500
Hi, everyone! We have several issues that we've been trying to resolve
and would appreciate any suggestions that you might have. We are on
10.7sc 16.1.
1. We have scale employees who often change organizations, but remain
at the same scale rate - therefore a change in their salary form is not
required. When their old assignment is ended, their regular wages
element entry is also ended automatically. It's as though Oracle
expects a salary change to occur as well. We've had to go in and remove
the end date to the element entry for each of these cases. Is there
something that we can do that will not automatically shut off the
regular wages element entry?
2. We've defined segment1 of the Cost Allocation Key Flexfield to be
cost center. We have a list of 278 values for that segment. In the the
Segment Values form (FNDFFMSV), the fields in the value section include
Value, Description, an Enabled checkbox and Effective From and To
dates. We are only able to disable/enable, add effective dates to or
modify the descriptions of 21 of the 278 existing values. On the others
we receive the message "FRM-40654: Record has been updated. Requery
block to see change." even though we haven't made a change. We can't
figure out why some can be changed and the majority can not. Oracle
Support have given us two newer versions of the form, but neither have
solved the problem.
3. We've had an Organization change their name from Line Stores to Line
Stores - Eastern Region. In Work Structures, we end dated the Line
Stores organization (effective 12/31/98) and created a new Org with the
new name effective 1/1/99. We created a new Hierarchy, by copying the
previous one, effective 1/1/99 to reflect this change. When we look at
Line Stores in the Hierarchy, the Exists in Hierarchy checkbox is
enabled - which it shouldn't be, since that organization ended on
12/31/98. When we look at the parent organization it has both Line
Stores and Line Stores - Eastern Region as children. How can we get
Line Stores out of the picture?
Any suggestions you can give would be very much appreciated.
Rebekah Pheifer
American Trans Air
Subject: Re: [orahrms-l] HRMS Issues
From: Sunil Desai sunild@best.com
Date: Thu, 01 Apr 1999 22:58:28 -0800
Bekah,
2. Check the values in each column for that specific row. Perhaps there is a
space in one the columns or appended to one of the values. This sort of problem
can only be detected via sql and not via the forms.
3. Organizations and hierarchies are not datetracked. You will need delete the
Line Stores from the new version of your hierarchy. (Why not change the
organization's name instead of creating a new organization?)
Sunil Desai
Subject: Re: [orahrms-l] HRMS Issues
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Fri, 02 Apr 1999 10:18:45 -0500
For your 2nd issue "FRM-40654: Record has been updated. Requery ..." how
did the records get into the database? Was it through the backend (i.e sql
proc)?. I had a client with this issue. Check that FND_FLEX_VALUES_TL has
a correcting row for each of the record in FND_FLEX_VALUES. The resolution
was to create a corresponding role in the translation table.
Manny.Wohiren@yale.edu
Access to sensitive data in Test environment
Subject: [orahrms-l] Accessibility of sensitive data on Test instances
From: carol.watson@natinst.com
Date: Fri, 2 Apr 1999 08:43:20 -0600
Hi all,
We'll be going live with HR by year-end and were wondering what other
people are doing about HR data on Test/Development instances. All of our
developers have access to the apps user password on our test boxes and
we're concerned about new accessibility to salary information and other
sensitive data when we refresh our test/development instances from our
production instance. How are you all handling this situation?
Thanks,
Carol Watson
IS Applications Manager
National Instruments
Austin,TX
(512) 683-5598
Subject: RE: [orahrms-l] Accessibility of sensitive data on Test instances
From: Charles Neal CGNeal@ci.las-vegas.nv.us
Date: Fri, 2 Apr 1999 08:21:41 -0800
Cc: "'carol.watson@natinst.com'" carol.watson@natinst.com
Here at the City of Las Vegas,
Salaries are public information, so this was not a problem for us.
I recommend this strategy:
After transfer from Live to Test,
always run a few SQL scripts that
1. randomly changes salary both upward and downward
[Per_Pay_Proposals, Per_Spinal_Point_Placements_f]
2. changes the first lines of address information to
the company's address. (Changing the City/State
can
cause tax problems.)
3. changes Social Security Numbers. You can start at
111-11-1111 and sequentially increment from there.
4. deletes all garnishment information
and optionally
5. changes the birthdate year
6. changes whatever else is sensitive
(company car, bonuses, etc.)
- Charles G. Neal
Systems Analyst II
Notification - %prod_label% is not available in Q:\ORAWIN
Subject: [orahrms-l] %prod_label% Notification
From: "Scott Paul" spaul@MAIL.NYSED.GOV
Date: Wed, 28 Apr 1999 08:25:29 -0400
Does anyone know the cause and correction of the following error:
Notification: "ERROR"
%prod_label% is not available in Q:\ORAWIN. The system administrator may have removed it while the Oracle Client Software Agent was running. Please notify the administrator, and try configuring your local Oracle home later.
For a little background each client is setup so that each morning when someone boots up their machine any changes or patches applied to the server that effects the client would automatically update the client from the sharagt.exe being placed in the startup.
This error started Monday morning at 9:30 am.
Any suggestions on rectifying the notification "error"?
As of today Wednesday I have not received any complaints that employees cannot access or have problems. Running HRMS applications.
It just that the Notification is annoying every morning.
List of APIs
Subject: [orahrms-l] API's
From: "Bacchus, Frank" fbacchus@rwjf.org
Date: Thu, 6 May 1999 08:49:59 -0400
Can anyone tell me where I can find a list of the available APIs for the
Financial and Human Resources/payroll Applications ?
Thank you.
Frank Bacchus
720-7529
Subject: RE: [orahrms-l] API's
From: pkandra@civicdevelopment.com
Date: Thu, 6 May 1999 09:08:49 -0400
For HR and Payroll, there is a document on the MetaLink site called What's
New in HRMS Version 11. It lists the API's in 11.0.1
Subject: [orahrms-l] FW: [orahrms-l] API's
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Thu, 6 May 1999 10:01:28 -0400
Is there a similar document for 10.7?
Subject: RE: [orahrms-l] FW: [orahrms-l] API's
From: pkandra@civicdevelopment.com
Date: Thu, 6 May 1999 10:16:47 -0400
Yes, Check MetaLink for a Word document named Oracle HRMS API's. I can
forward you a copy if you can't find it.
Subject: RE: [orahrms-l] API's
From: Annette Suarez asuarez@darc.com
Date: Thu, 6 May 1999 10:26:24 -0500
The HRMS Implementation guide has about 75 pages of API information.
Annette Suarez
Subject: Re: [orahrms-l] API's
From: CORNELIS E VAN WIJK CORNELIS.E.VAN_WIJK@slchicago.infonet.com
Date: 6 May 1999 09:56 GMT
Frank,
Log in to Oracle Applications using any responsibility. Then go in to
the Help menu on the menu bar, choose Oracle Applications Library.
Once in the Oracle Applications Library choose Human Resources. In
Human Resources choose New Features (is at the bottom), within New
Features choose New APIs, this will give you a listing of all publicly
callable business process APIs for Human Resources.
More information on how to use the HR APIs may be found in the HR
Implementation Guide under the Technical Essays: Callin APIs
Ed van Wijk
Sr. Consultant ITS
Sargent & Lundy
312-269-7822
Legal Ramifications of Loading Non-Employees into HR System
Subject: [orahrms-l] Legal Ramifications of Loading Non-Employees into HR System
From: "Kevin Jarrett" kejarr@copelco.com
Date: Fri, 11 Jun 1999 06:17:11 -0400
Hi everyone,
We've been asked to load consultants, temps, and other non-employees into
our HR database so that their names will be available in PER_PEOPLE_F for
other in-house applications.
What are the implications of this decision, if any, from an employment law
perspective? I seem to recall that this is inadvisable, something about the
tests/distinctions necessary to determine when someone is "an employee"
with all the rights associated therewith.
We would create a new PERSON_TYPE and only save a person form record (we
need to pass a name and PERSON_ID to our other apps), so at least they
won't be clogging up the database as EMPLOYEEs.
Thanks!
-kj-
Subject: RE: [orahrms-l] Legal Ramifications of Loading Non-Employees into HR System
From: Pat Keeley PKeeley@amctheatres.com
Date: Fri, 11 Jun 1999 08:41:17 -0500
Kevin,
There is no legal issues with having these people in your HR or Payroll
system. The tests are specific to the work, responsibility, control, and
personal risk assumed by the "contractor." If the tests fail, it wouldn't
matter what system you stored the person's information on. In most failed
cases the "Contractor" data has been stored on a manual or AP system. The
method used for storing the information had no effect on the results of the
test.
Hope this helps,
Pat
ARIS Corporation
Quarterly and year end process
Subject: [orahrms-l] Quarterly and year end process
From: Tony Chan tonywchan@hotmail.com
Date: Fri, 11 Jun 1999 09:54:21 PDT
Hi all,
Could someone provide me step by step procedures on quarterly and year end
process in 10.7NCA and 11x? I would also like to know about your experience
on these filings. Is there any white paper or forum on this particular
topic? Any help is appreciated.
Thanks,
TC
Audit Trail
Date: Wed, 11 Aug 1999 10:43:00 -0700
From: "Ashwin Ayancha" Ashwin.Ayancha@xilinx.com
Subject: Re: Audit Trails.
Hi All,
We are using Oracle Human Resources ver 11.0.2.
we want to implement the Audit Trail Process, So have anyone of you
implemented this process and what type of data you captured into the
reports built from Audit Trail process and how long it took to make up a
this type of report. Is it good to set this feature?, because it creates
all those shadow tables. If anyone is willing to talk on these, Pl send
your phone numbers so that we can talk to you before implementing this
feature for our project.
thanks in Advance,
Ashwin
Oracle vs PeopleSoft HR
Date: Mon, 2 Aug 1999 15:44:24 -0400
From: "Snyder, Andrew" Andrew.Snyder@CAI.COM
Subject: Oracle v. PeopleSoft HR
I am looking for information comparing the Oracle and PeopleSoft human
resources modules. Does anyone have any articles, specific web sites, white
paper, etc. on this topic?
Thanks
Date: Mon, 2 Aug 1999 15:46:17 -0500
From: "Ken Conway" ken.conway@bosscorporation.com
Subject: Re: Oracle v. PeopleSoft HR
Andrew:
I have a summary of a Gartner Group analysis of Oracle HRMS although there
is very little reference to PeopleSoft. Please feel free to call me and I
will discuss some of the separate strengths that we have observed from
PeopleSoft HRMS and Oracle HRMS. Both products have areas of strength and
both have some weaknesses.
--Ken
Ken Conway
BOSS Corporation
Better Organization Service Solutions
(214) 495-7654 Voice
(214) 495-7543 Fax
www.bosscorporation.com
Employee Tables and their relationships
Date: Tue, 7 Sep 1999 16:13:19 -0700
From: Karen Blackwell KBlackwell@rockshox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: HR/PA: Help with employee tables
I am experiencing a problem with foundation HR tables but have no TRM, no
documentation (for HR and PAY) and do not have HR or Payroll installed. Can
someone out there possibly help me out with a little info?
Situation:
We have an employee in our HR Employees table. When we navigate to the
Assignments zone, there is no data, but it has been entered several times.
I can confirm this by going directly to the per_assignments_f and selecting
based on the assignment number like 'employee_number%'.
Can someone assist me in identifying the tables, and their relationships so
that I might be able to step through the different tables to determine where
things might have gone wrong? I appreciate any assistance anyone is willing
to offer.
Thanks in advance.
My environment: 10.7NCA, 7.3.3.6 db, on Solaris 2.6
Karen
Date: Wed, 8 Sep 1999 15:54:05 +0530
From: "S RAGAVENDRAN" sripadra@wipsys.soft.net
To: oraapps-l@cpa.qc.ca
Subject: Re: HR/PA: Help with employee tables
Hi,
The following are the tables :
PER_PEOPLE_F
PER_ADDRESSES
PER_ASSIGNMENTS_F
PER_JOBS
PER_JOB_DEFINITIONS
PER_GRADES
PER_GRADE_DEFINITIONS
PER_POSITIONS
PER_POSITION_DEFINITIONS
The views which u can use :
per_people_v7
per_addresses_v
per_assignments_v7
U can describe the tables and views and get
definitions from SQL Plus.
regards,
Ragavendra
Date: Wed, 8 Sep 1999 06:20:17 -0700
From: Karen Blackwell KBlackwell@rockshox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: HR/PA: Help with employee tables
THANK YOU VERY MUCH!