Updating Date Tracked Assignment data with hr_assignment_api errors out
Subject: [orahrms-l] UPDATE DATE TRACKED ASSIGNMENT DATA WITH API ???
From: "Gul, Metin" MGul@sigeco.com
Date: Tue, 27 Apr 1999 16:18:46 -0500
I am trying to update existing assignment information for HR & payroll
employees. I am using
the api's :
1. hr_assignment_api.update_emp_asg_criteria
2. hr_assignment_api.update_emp_asg
Currently all employees effective start date for their assignment data is as
of their hire date in the system. so I want to change this and using the
above api's .
however I keep getting the following error messages if I use the 'UPDATE'
mode. when I use 'CORRECTION' I don't have any problem.
But I have to use the UPDATE mode because I am using different dates
obviously.
when I run the script I get the error message :
DECLARE
*
ERROR at line 1:
ORA-20001: APP-7179 DateTrack update not allowed for a record which started
today
Cause: You have tried to complete a date effective update for the record
which
starts on the same day.
Action: Change your DateTrack mode to correction or alter your effective
date.
ORA-06512: at line 292
Has anybody done assignment updates to change the existing effective dates
??
thanks
Metin
Subject: Re: [orahrms-l] UPDATE DATE TRACKED ASSIGNMENT DATA WITH API ???
From: "Bob Cody" Bob_Cody@norstanconsult.com
Date: Tue, 27 Apr 1999 19:50:12 -0400
Metin,
Oracle Applications DateTrack uses effective_start_date and
effective_end_date 's
to determine if a row is "Effective" for a particular SESSION_DATE when you
are
in the application.
When you choose to UPDATE a record within the app,the database record you
are
working on is updated. The effective_end_date is set to yesterday's date
and a
new record is created. The new record has an effective_start_date of
today's date.
If you were in the application and attempted to change this record again on
the same
day, Oracle would force you to do a CORRECTION because DateTrack only
maintains
the new row by the day, and you would now be chaging that new record with
todays date.
I'll bet you are calling both of the API's below in the 'UPDATE' mode.
When you make the first call, everything is OK because you have end dated
the old record and created
a new record.
When you make the second call you are probably erring because a row with
your effective_start_date
already exists from the first UPDATE.
Try leaving the first call as an UPDATE and changing the mode to
'CORRECTION' for the second call.
Bob Cody
Subject: RE: [orahrms-l] UPDATE DATE TRACKED ASSIGNMENT DATA WITH API ???
From: "Gul, Metin" MGul@sigeco.com
Date: Tue, 27 Apr 1999 19:12:41 -0500
Thanks Bob,
great idea, tried and works.
I don't know what I was thinking when I was trying to calling the api twice
with update mode eventhough we have been talking
about this date track issue so many times !!
Metin
Multiple active assignments for an employee
From: "Crawford, Erin" ECrawfor@JPI.com
To: "'orahrms-l@mail-list.com'" orahrms-l@mail-list.com
Subject: [orahrms-l] Multiple active assignments for an employee
Date: Fri, 30 Jul 1999 12:16:05 -0500
We have an employee with 2 active assignments where he should only have
one. When we went into his assignment screen to transfer him, instead
of just changing the existing HR Org. and choosing update, we went in
and inserted a record. This, in turn, created another record in his
assignment screen. We didn't notice this until sometime later, and now
it won't let us end date or delete the extra assignment. We get this
error message when we try: APP-07664: You cannot delete the assignment
when Assignment Action rows exist. The system will not allow deletion
of either one because one is his first assignment and the other has
payroll runs against it. I've tried going into our TEST instance (where
the same problem exists), date-tracked to the day before either one of
these assignments is effective, hitting the red 'X' and choosing 'All'
(to remove all future changes), and my screen locked for almost an hour,
never saving my changes. Has anyone had a similar issue? If so, do you
know how can I clean up this employee's record?
Thank you,
Erin Crawford
Business Analyst
JPI Partners, Inc.
972-556-6978
Subject: Re: [orahrms-l] Multiple active assignments for an employee
From: "Terry Hodge" tahodge@hotmail.com
Date: Mon, 02 Aug 1999 04:52:14 GMT
Erin,
In order to delete this assignment you must roll out every payroll run
for this assignment from past to present. Once you do this you will be able
to delete this assignment.
Do you know if any time entry or gross wages have been paid?
Hope this helps,
if you need further assistance.
You may forward to me.
Terry Hodge
Primary_Flag
Subject: [orahrms-l] Primary Flag to "Y"
From: "Tony Chan" tonywchan@hotmail.com
Date: Fri, 07 May 1999 09:01:45 PDT
Hi all,
Does anyone know the answer to the question below? This is a question that
was sent to me from a financial consultant this morning. I think if I
understand his question, he is asking how to set the primary flag to "Y"
from the app instead of from SQLPlus. Or in what condition the primary flag
will turn to "Y" or "N".
Thanks,
Tony
We are having trouble with one employee record in HR out. The
problem exhibits itself in INV and I have found the offending field in
the HR tables. Now I can not figure out how to change the field using
the OraApps screens. I do not want to SQL*Plus the change into PROD.
I did this in PILOT1 and it fixed the problem.
The employee has two assignment records in the table:
PER_ALL_ASSIGNMENT_F
The field is the PRIMARY_FLAG. For the record where the
EFFECTIVE_START_DATE
and EFFECTIVE_END_DATE fall within the current date the PRIMARY_FLAG is
set
to 'N'. Changing the PRIMARY_FLAG to a 'Y' for this record fixed the
problem.
Now the second record has the EFFECTIVE_START_DATE and
EFFECTIVE_END_DATE
are years into the future. This record has a PRIMARY_FLAG = 'Y'. Other
records in the DB have multiple records with both the PRIMARY_FLAGs set
to
'Y'.
Now I have looked in the forms under the navigation path:
People : Enter and Maintain
I queried up the employee and then clicked the Assignment button.
This form matches the record/fields in the database, however I can not
figure
out what sets this PRIMARY_FLAG.
Any ideas????
Subject: RE: [orahrms-l] Primary Flag to "Y"
From: pkandra@civicdevelopment.com
Date: Fri, 7 May 1999 12:41:47 -0400
An active employee with multiple assignments (or only one) must always have
a primary assignment. Go into the assignments screen, pull down the
alternative region and select Miscellaneous. There is a check box called
Primary.
API to update SIT
Subject: [orahrms-l] API to update SIT
From: sredrova@es.com
Date: Mon, 10 May 1999 17:23:58 -0600
I need to create and update SIT (Special Info Type) from outside the apps.
To create SIT, I use the API HR_SIT_API.create_sit and it works well.
But I was not able to find any API to update the SIT.
Does any one could tell me if there is such an API? Or if someone is using a
home built one. We are on 10.7 prod 16.1 SC
Thanks.
Stephanie Redrovan
Information Technologies
Evans & Sutherland Inc. (http://www.es.com)
sredrova@es.com · 801.588.1825
Subject: Re: [orahrms-l] API to Update SIT
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Wed, 26 May 1999 12:22:09 -0400
The api u need is apps.hr_sit_api.update_sit
Assigning Organization Name to an Employee gives an error
Subject: [orahrms-l] Error Message
From: "McLeod, Rosie" rMcLeod@wssc.dst.md.us
Date: Mon, 7 Jun 1999 15:56:01 -0400
Hello,
I developed a new Organization name and Location name effective
12/12/99. Whenever I attempted to assign the Organization name to an
employee I receive an Error Message: Value 4 is invalid. Whenever I assign
the new location to an employee, I have no problem.
Does anyone have any ideas?? Thanks
Rosie McLeod
Human Resources Division
Washington Suburban Sanitary Commission
301-206-8719
rmcleod@wssc.dst.md.us
Subject: RE: [orahrms-l] Error Message
From: Pat Keeley PKeeley@amctheatres.com
Date: Mon, 7 Jun 1999 15:31:29 -0500
Rosie,
Locations are not "date tracked," however Organizations are. My guess is
that you are trying to assign an Organization to the employee prior to the
effective date of the Organization.
Pat Keeley
ARIS Corporation
Assigning a salary basis to an employee's assignment gives an error: APP-51133
Subject: [orahrms-l] APP-51133
From: "Joanne Owsley" joanne.owsley@aris.com
Date: Mon, 7 Jun 1999 15:57:55 -0700
I am having difficulty assigning a salary basis to an employee's assignment. When I assign the salary basis, I get an error:
APP-51133: The location is not a valid work location for the assignment.
Has anyone else encountered this before? Other than the way the Regular Salary element is linked - in this case, it's linked to all payrolls - what is the connection between Salary Basis and location? Could this be related to Vertex?
I'd appreciate any insight on this.
Thanks in advance for your help.
Joanne Owsley
Subject: RE: [orahrms-l] APP-51133
From: "Gul, Metin" MGul@sigeco.com
Date: Mon, 7 Jun 1999 18:23:12 -0500
Joanne ,
Are you sure the problem is the salary basis ?
You are probably using the "apps.hr_assignment_api.update_emp_asg_criteria
" API for this.
Do you pass any org or location id's when you call this API ? If yes then
your location and organizations are not matching check those org and
locations.
If this does not work let me know.
bye
Metin
Subject: Re: [orahrms-l] APP-51133
From: "Joanne Owsley" joanne.owsley@aris.com
Date: Mon, 7 Jun 1999 16:39:47 -0700
Actually, this is happening when I try to hire a new employee through the
HRMS App forms
Subject: Re: [orahrms-l] APP-51133
From: Robert Story rstory@us.oracle.com
Date: Mon, 07 Jun 1999 19:42:56 -0400
Joanne,
This is most likely a problem with the address for the location on this assignment.
Check that the location address has a VALID US state, county and city name. The state name, county name and city name should be exactly the same as they are in the tables PAY_US_STATES, PAY_US_COUNTIES and PAY_US_CITY_NAMES respectively.
To validate against the tables, you can pick up the state, county and city form their respective list of values. Once a valid location is given to the assignment, this error will not occur and the defaulting of tax records will take place.
Regards,
Robert
Restricting users to see Contact Information
Subject: [orahrms-l] CustomForm/Task Flow/Secure Users
From: Lewis R Cunningham lcunning@lmumail.lmu.edu
Date: Tue, 15 Jun 1999 12:38:15 -0700
Hi all,
Let me start by saying I'm not customizing any forms, I'm using the
CustomForm feature under the security menu on the HR Manager GUI
responsibility.
I want to restrict some users so that they cannot see contact information.
Using CustomForm, I created a custom version of PERWSEPI with restriction
types of person type and the values of all person types except contact. I
created a new taskflow using this CustomForm instead of the regular default
F4 Enter Personl Info. I registered the new custom form as a function,
with the parameter calling my new taskflow, and since the users connect
through a secure user, i just changed their responsibilities menu to
reflect the custom function.
To make a long story short, it doesn't work. Any ideas of what I might be
missing or any steps I have skipped? I ran listgen just for giggles but it
didn't change anything,
Thanks for any help,
Lewis
Lewis R Cunningham
Whitaker IT
Oracle Human Resources Functional and Technical Consultant
LewisC@rocketmail.com
Subject: RE: [orahrms-l] CustomForm/Task Flow/Secure Users
From: pkandra@civicdevelopment.com
Date: Tue, 15 Jun 1999 16:56:02 -0400
We've also had problems getting the CustomForm feature to work. We wanted
to restrict employees to only certain elements. Oracle Support has had us
apply 2 patches, but neither fixed the problem. Our TAR has been open for
over 2 months now.
Peter Kandra
Civic Development Group
(888) 800-7637 x2518
Subject: [orahrms-l] Re: [orahrms-l] CustomForm/Task Flow/Secure Users
From: CORNELIS E VAN WIJK CORNELIS.E.VAN_WIJK@slchicago.infonet.com
Date: 15 Jun 1999 15:54 GMT
The answer might depend on which version of Oracle HR you are running.
From the way you describe what you did, it sounds like the custom form
is o.k., but the problem might be with the creation of the secure
user:
If you are on 10.7sc prod 16.1:
1. during your installation you should have applied the hr107sec.drv,
2. created your oracle id to attach to the secure user role,
3. registered this oracleid in oracle apps,
4. run the secure_users patch,
5. create your security profile and attach the oracle id to it,
6. run the generate secure user process,
7. run the listgen process,
8. create a datagroup for the secure user id,
9. attach the responsibility to a user.
In 10.7sc prod 16.1 you need to create a new oracle userid for each
new secure user you want to create. In version 11 this is no longer
necessary.
Hope this helps,
Ed van Wijk
Sr. Consultant
Sargent & Lundy
312-269-7822
Subject: Re: [orahrms-l] Re: [orahrms-l] CustomForm/Task Flow/Secure Users
From: Lewis R Cunningham lcunning@lmumail.lmu.edu
Date: Tue, 15 Jun 1999 15:05:27 -0700
Thanks. Actually the secure user works fine. It's only when we use the
customform and/or custom taskflow that we hit the problem. I'm pretty sure
it's the customform because we have other custom taskflows with no
customforms that do work.
Thanks for the input though,
Lewis
Subject: [orahrms-l] Fixed: CustomForm/Task Flow/Secure Users
From: Lewis R Cunningham lcunning@lmumail.lmu.edu
Date: Wed, 16 Jun 1999 14:52:16 -0700
Thanks everybody who responded. I finally figured it out. I needed to
delete the top node and recreate it with my custom form.
Thanks,
Lewis
Employees State Code and State Code Id #
Subject: [orahrms-l] HRMS - Employees State Code and State Code Id #
From: "Menke, Irene M." menke@Mail.Donaldson.com
Date: Thu, 17 Jun 1999 14:12:42 -0500
Could someone please tell me in what table I can find the following info for
the state where the employee works which can be different from where they
live.
State Code
State Tax Id #
Thanks in advance,
Irene Menke
Donaldson Company
612.887.3605
menke@mail.donaldson.com
Subject: RE: [orahrms-l] HRMS - Employees State Code and State Code Id #
From: Pallavi Grandhi pallavi.grandhi@deltec.com
Date: Thu, 17 Jun 1999 14:42:07 -0500
use the procedure get_work_codes, get_res_codes from package
pay_us_emp_dt_tax_val with appropriate parameters to get the work and res
state codes and names.
Hope this helps.
Pallavi Grandhi
Oracle Certified Application Developer (OCP)
651 628 7348
Subject: RE: [orahrms-l] HRMS - Employees State Code and State Code Id #
From: Bijus@mashreqbank.com
Date: Fri, 18 Jun 1999 19:26:02 +0400
that depends on where you store the state info. pls see in
hr_organization_units and hr_locations
Regards,
Biju Sebastian
Upload Ethnic Origin automatically
Subject: [orahrms-l] Ethnic Origin
From: Diane Patch DPATCH@FAMILYDOLLAR.com
Date: Tue, 13 Jul 1999 12:23:45 -0400
When our data was converted from our legacy system, Ethnic Origin was not
converted. We now need to populate this data so that we can run EEO
reports.
We have looked at the Person update API, but it does not have a field for
Ethnic Origin. Due to the volume that we have, we are looking for an
automated way to upload this information, unfortunately, we are coming up
empty. I am trying to find out if anyone has had a similar situation and
what you did to fix the problem.
We are live on release 10.7 Prod 16.1 NCA.
Diane Patch
HRIS Manager
Family Dollar Stores, Inc
(704)814-3315
DPatch@familydollar.com
Subject: RE: [orahrms-l] Ethnic Origin
From: pkandra@civicdevelopment.com
Date: Tue, 13 Jul 1999 12:45:30 -0400
Diane,
The fields in PER_PEOPLE_F are PER_INFORMATION_CATEGORY (which should be
US) and PER_INFORMATION1 (which should contain the appropriate QuickCode
value from the US_ETHNIC_GROUP QuickCode type.
Peter Kandra
Civic Development Group
(888) 800-7637 x2518
Subject: [orahrms-l] Re: [orahrms-l] Ethnic Origin
From: CORNELIS E VAN WIJK CORNELIS.E.VAN_WIJK@slchicago.infonet.com
Date: 13 Jul 1999 11:52 GMT
Diane:
We had a similar situation during the load of the data from our legacy
system. After we had loaded the employees with the
hr_employee_api.create_us_employee in our test environment we found,
after a while, that we had not loaded the ethnicity due to an
oversight. Luckily we were in test. We wrote a procedure that called
the hr_person_api.update_person to correct this. Ethnicity is the
p_per_information1 parameter in the hr_person_api.update_person.
Give me a call at 312-269-7822 if you have any more questions.
Good luck,
Ed van Wijk
Sr. Consultant
Sargent & Lundy
Subject: re: [orahrms-l] Ethnic Origin
From: "Bob OConnor" boconnor@vines.colostate.edu
Date: Tue, 13 Jul 99 11:36:26 -0600
Diane,
The api update_us_person has a parameter input p_ethnic_origin (done near the
end by the i-9 stuff).
apps.hr_employee_api.update_us_person
Good luck,
Bob
Bob O'Connor
Colorado State Univ
boconnor@vines.colostate.edu
970-491-4380
hr_assignment_api running very slow
Date: Wed, 18 Aug 1999 20:14:55 -0400
From: "Shah, Sandeep V" svshah@kpmg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Urgent!! Need Help with API
To all HR Gurus,
I am running assignment(hr_assignment_api) API which processes about 5,000
records. This program is running extremely slow. For 1,000 assignment
records it takes about 3 hours. This program during development was working
fine and it used to complete in 20 minutes. Any suggestion or any help will
be greatly appreciated.
Sandeep Shah
Senior Consultant
kpmg Consulting
Oracle Applications Practice
973-912-6532(vm)
804-662-2641(client)
svshah@kpmg.com
Date: Fri, 27 Aug 1999 08:33:59 -0400
From: "Shah, Sandeep V" svshah@kpmg.com
Cc: "Shah, Sandeep V" svshah@kpmg.com
Subject: URGENT:HRMS APIs (EMP AND ASSIGNMENT) RUNNING VERY SLOW!!
Hi all,
I am in process of converting employees into Oracle HRMS. Employee API for
8,000 employees took almost 7 hours and it was still running.
PER_ALL_PEOPLE_F table had about 14,000 records before conversion.
Assignment API (HR_ASSIGNEMENT_API.UPDATE_EMP_ASG_CRITERIA) is also running
extremely slow. I contacted Oracle Support and they don't have any definite
solution to this problem. I checked indexes on all main tables and they
seem to be in place as per the technical reference manual. My program does
complete successfully but after taking a long time. We need to convert
approximately 20,000 employees in total for Production.
Is there any way to improve performance of these APIs???? Does anybody else
has similar problem? Are there any patches for performance? We are on
Application Release 11.02, Database 8.05 and Operating System Sun Solaris
2.6. Any pointers or hints will be greatly appreciated.
Regards,
Sandeep Shah
Senior Consultant
Date: Fri, 27 Aug 1999 09:01:40 -0400
From: Mohan Thanikanti mthanika@camail2.harvard.edu
Subject: Re: URGENT:HRMS APIs (EMP AND ASSIGNMENT) RUNNING VERY SLOW!!
Hi,
We had similar problem. We had to convert 40,000 employees and it took
almost 24 hours to complete.
Since it is only one-time conversion , we were not concerned much...
MOHAN