APIs for conversion of employee data
Subject: [orahrms-l] HR Conversions
From: "Deb Burgess, The Burcon Group" burcongp@gte.net
Date: Thu, 18 Mar 1999 03:34:20 -0800
I have two clients, one implementing 10.7SC and one implementing 11.02.
Both are HR only sites with payroll being handled by ADP. Up until this
point all of my implementations have either used manual conversions (you
know...the typing kind), or a 10.7 macro. I am frequently asked about
available API's for converting employee data. I cannot find any reference
to an API for this purpose. Does one exist? If so, where is it described
(I have looked into the 11 impl guide and user guide, 10.7 TRM and user
guide)?
Does anyone have a macro that is working in an NCA (11.01/11.02)
environment? I have heard that the problem with using a SC macro is
communicating to the apps server through the web server. How do you work
around this problem?
Have A Great Day!
Deb Burgess, (310) 898-8520
The Burcon Group (562) 420-6288
Subject: RE: [orahrms-l] HR Conversions
From: pkandra@civicdevelopment.com
Date: Thu, 18 Mar 1999 07:29:28 -0500
There is a section on API's in the HRMS Version 11 US Implementation Guide.
It's in the Technical Essays chapter. Oracle also has a few other documents
on their MetaLink site worth reading:
Oracle HRMS API's.doc
Oracle HRMS Calling API's.pdf
What's new in HRMS Version 11.pdf
Payroll Balance Conversion and effective date of elements
Subject: [orahrms-l] Payroll Balance Conversion
From: "Puri, Arjun (Exor Consultant)" apuri@sigeco.com
Date: Wed, 26 May 1999 17:37:30 -0500
Need some help on conversion of balances. In release 10.7 Prod 16.1SC
entering elements with the date 01-JAN-0001 as required in the documentation
resulted in the default to the 2001. The client therefore set up elements
prior to the inception of the organization, but not to 0001. We are now
ready to convert balances and all the documentation states that we must use
the 0001 date. Is there a work around to use our existing date 01-jan-1951.
Oracle has provided a way to bypass the default date of 2001, but we do not
want to go back and set up the elements and tables with the new date.
Subject: RE: [orahrms-l] Payroll Balance Conversion
From: Scott Madole smadole@solbourne.com
Date: Fri, 28 May 1999 06:56:54 -0600
The balance initializaton technical essay is a bit misleading. You DO NOT
need to create your initial load elements manually. You only need to load
the pay_balance_batch_headers and pay_balance_batch_lines tablels. Then run
the "create inital balance load structre" process from the us hrms manager
responsibility. (Sorry, I don't remember the exact name, but if you go to
submit concurrent requests and look at the list of values for
reports/processes, it will be eviden). Once this is done you can then run
the Load initial balance program the same way. The documentation seems to
imply that the create structures program only creates initial load elements
for legislative balances. This IS NOT TRUE.
Once you have loaded a batch of balances, you can load the
pay_balance_batch_headers and lines table with a new group of balances. If
you have new balances, you can run the "create initial balance structure"
program again, it will create new initial load elements, input values, and
intial balance feeds for the new balances. By the way, it will also create
these elements and input values with the effective_start_date of
01-JAN-1901.
Hope this helps,
Scott Madole
Solbourne
smadole@solbourne.com
Load Employees personal information
Subject: [orahrms-l] loading employees
From: Steve Silveri ssilver@dpc.com
Date: Thu, 15 Apr 1999 07:32:25 -0700
I am trying to load employees through the APIs. I need
to load
employees, addresses, position assignments, salary data.
I need to use
hr_employee_api.create_employee(
hr_person_address_api.create_person_address(
and what other APIs.....
Subject: RE: [orahrms-l] loading employees
From: "Gul, Metin" MGul@sigeco.com
Date: Thu, 15 Apr 1999 09:38:21 -0500
You may use the following API's :
hr_employee_api.create_us_employee
hr_person_address_api.create_us_person_address
hr_contact_rel_api.create_contact (you may need to put in contact data)
hr_position_api.create_position
hr_assignment_api.update_us_emp_asg_criteria
hr_assignment_api.update_us_emp_asg
hr_personal_pay_method_api.create_us_personal_pay_method
hr_upload_proposal_api.upload_salary_proposal
hope this helps.
Metin
Subject: RE: [orahrms-l] loading employees
From: "Matson, Mark J." MatsonMJ@bvsg.com
Date: Thu, 15 Apr 1999 09:40:55 -0500
Steve,
I presented a paper on this subject at the last two OAUG Conferences. A
current copy of the paper and code can be found at
http://www.bvsg.com/papers/oracle.html.
I hope this should answer most if
not all of your questions.
Mahalo (Thanks).
Mark J. Matson
BV Solutions Group
A Black & Veatch Company
Subject: RE: [orahrms-l] loading employees
From: Brenda Finley bfinley@standard.com
Date: Thu, 15 Apr 1999 07:46:00 -0700
Hi Steve... If you do a search in dba_source :
select distinct name
from dba_source
where type='PACKAGE BODY'
and (name like 'HR%API' or name like 'PY%API')
you will find the HR api's. The one API for elements starts with 'PY' and
not 'HR'.
Unfortunately there isn't an API for everything, but there is an API for the
big things.
Let me know if you have any specific questions. I loaded all our employee
information including positions assignments, salary, benefits, SIT, etc.
with API's.
good luck!
Brenda
Brenda Finley [Mailto:bfinley@standard.com]
Data Analyst IV, Business Technical Services
Standard Insurance Company
1100 SW Sixth Avenue, P3B
Portland, OR 97204
Subject: RE: [orahrms-l] loading employees
From: pkandra@civicdevelopment.com
Date: Thu, 15 Apr 1999 11:18:06 -0400
Assignments:
hr_assignment_api.update_emp_asg (a default assignment gets created when an
employee is created)
hr_assignment_api.update_emp_asg_criteria
Salary:
hr_upload_proposal_api.upload_salary_proposal
List of Balances and dimensions to load on Initial Balance Load
Subject: [orahrms-l] Initial balance upload
From: Robert Lawton zero_consultants@yahoo.com
Date: Sat, 24 Apr 1999 07:21:10 -0700 (PDT)
Hi,
I'm the functional consultant at a site implementing
HRMS. We are attempting to go-live mid-year, 1 June,
and therefore need to load balances for all employees.
Our technical team say they've done this before but
I'm not convinced and am concerned. They are
currently loading balances against the dimension
Assignment within GRE QTD and are going to load two
balances, first quarter and second quarter, which they
say will automatically update YTD. However, our first
test showed that many balances are missing, for
example Net, Payments, Gross Earnings, Regular
Earnings, etc. I've been through the balances on the
system and asked them to read the manuals to make sure
we don't miss anything. But wondered if anyone out
there has a complete list of all balances and
dimensions that should be loaded, eg. I saw a previous
message that said for FIT we have to load quite a few
balances, which we are not currently doing.
Help !
Robert.
Loading Purchasing Account
From: Steve Silveri [SMTP:ssilver@dpc.com]
Sent: Monday, April 26, 1999 6:13 PM
Subject: [orahrms-l] loading purchasing account
I need to load the po default account. I am using update_us_emp_asg .
When I include P_set_of_books_id, I get an error message
APP-51161 The set of books cannot be updated for an assingment.
If I do not use the set_of_books parameter, the PO account will
be loaded, but I still have to go into the form and update the set of
books.
hr_assignment_api.update_us_emp_asg (
p_effective_date => v_hr.hire_date,
p_datetrack_update_mode => 'CORRECTION',
p_assignment_id => v_assign_id,
p_object_version_number => v_version_number,
p_default_code_comb_id => v_default_ccid,
p_set_of_books_id => v_books_id,
p_tax_unit => v_busgroup,
p_soft_coding_keyflex_id => v_soft_id,
p_comment_id => v_comment_id,
p_concatenated_segments => v_segments,
p_effective_start_date => v_eff_start_date,
p_effective_end_date => v_eff_end_date,
p_no_managers_warning => v_no_manager_warning,
p_other_manager_warning => v_manager_warning);
Subject: RE: [orahrms-l] loading purchasing account
From: "Driver, Paul" p.driver@ic.ac.uk
Date: Tue, 27 Apr 1999 08:06:33 +0100
Hi Steve
I just rempoved the update to sob_id in the call and updated the assignment
table directly afterwards. It worked!
Cheers
Paul Driver
Load GRE and PO Account
Subject: [orahrms-l] GRE and PO account in API
From: Steve Silveri ssilver@dpc.com
Date: Mon, 26 Apr 1999 07:35:45 -0700
I need to load GRE data and the Default purchase account info.
It looks like the PO account would get loaded with:
hr_assignment_api.update_emp_asg
p_default_code_combination_id
p_set_of_books_id
I this true.
What API is GRE data loaded?
Thanks
Subject: [orahrms-l] RE: GRE and PO account in API
From: "Roberts, Mike" mike_roberts@nrel.gov
Date: Tue, 27 Apr 1999 07:20:12 -0600
Cc: "'SteveSilveri ssilver@dpc.com'"
To load GRE use:
hr_assignment_api.update_us_emp_asg
p_tax_unit
Send the organization_id of your GRE, but you have to send it as a character
not a number.
Michael Roberts
Senior Consultant
Softec Solutions, Inc.
Load Contact Information through API
From: Rajesh Babu nrajeshbabu@yahoo.com
Date: Mon, 3 May 1999 15:09:05 -0700 (PDT)
Hi All,
I am trying to Load contact information using API's.
How should I load Contact and their relationship using HR_contact_api &
hr_contact_rel_api.
As of now, I loaded the contact person from
person temp table having actioncode =2 (contacts)
Should I create a seperate temp. table as per contact_ rel api
parameters and load relationsship or how should I go about it.
Please provide suggestion as early as possible.
Thanks,
Rijinikanth
From: Brenda Finley bfinley@standard.com
Date: Mon, 3 May 1999 16:40:35 -0700
The contact api loads the person. The contact relationship api loads the
relationship between the two people. Oracle has done this in a very
confusing way... You have to create two relationships between an employee
and their contact (ie: spouse). (You run the contact_rel api twice) Once
with the employee as the 'contact' and once with the contact as the
'contact'. This allows you to go to the employee screen and see the contact
and then call up the contact from the people screen and see the employee as
the contact.
Look at how Oracle loads contacts when done via the GUI application and then
use that to make sure your api is working correctly. Also test this
thoroughly because it is not straightforward. You also need to make sure
your relationship types are defined clearly because there is meaning built
into them.
If you have more detailed questions, let me know.
Thanks,
Brenda
Loading Balances to Non-Recurring Elements
Subject: [orahrms-l] Loading balances to NON-Recurring Element !!
From: "Gul, Metin" MGul@sigeco.com
Date: Fri, 14 May 1999 11:30:11 -0500
Hi,
We are trying to load elements(recurring & non-recurring) and balances.
The issue is with the effective start date for non-recurring elements, from
what I know non-recurring elements belong to pay periods. For example you
could have bonus(non-recurring element) in Jan and March pay periods. So
what would be our effective start dates for this element if our live date is
in July ?
How do you approach this so you don't have to run into problems when you
load balances
for these elements ??
any help appreciated
thanks
Metin
Loading information of Terminated Employees
Subject: [orahrms-l] terminated employees through API
From: Steve Silveri ssilver@dpc.com
Date: Thu, 03 Jun 1999 12:51:15 -0700
I am loading employees(through the APIs in 10.7 and then in 11) in which
some of them have been terminated. However, they need to be loaded for
history puprposes. What is the best way to accomplish this?
Subject: RE: [orahrms-l] terminated employees through API
From: "Gul, Metin" MGul@sigeco.com
Date: Thu, 3 Jun 1999 14:51:35 -0500
I think you have bring them over as active and terminate them in Oracle,
there is a API for this.
Metin
Subject: RE: [orahrms-l] terminated employees through API
From: "Mavis O'Connor" moconnor@IR.ColoState.EDU
Date: Thu, 3 Jun 1999 14:17:02 -0600 (MDT)
Take a look at these APIs. They can terminate or suspend
employees and assignments:
APIs in Release 10.7.0.16.1SC
File Name Package Name Business Process Comments
peexebpi.pkh hr_ex_employee_api actual_termination_emp
peexebpi.pkh hr_ex_employee_api final_process_emp
peasgbpi.pkh hr_assignment_api suspend_emp_asg
peasgbpi.pkh hr_assignment_api final_process_emp_asg
You can get the full API list with the online help via the following:
Oracle Human Resources -> Other Topics -> New Features -> New APIs
Loading Inception-to-Date balances
Subject: [orahrms-l] ITD(inception to date) Balance Loading for user defined Balances !
From: "Gul, Metin" MGul@sigeco.com
Date: Tue, 8 Jun 1999 23:04:54 -0500
Hi everybody,
We are in the process of loading payroll balances. Most of the initial
balances are coming across okay except for two ITD balances (computer loan
accrued and US Savings Bond Toward Purchase). We get the error message:
"No time periods exist for this payroll currently."
It seems like the 'Initial Balance Structure Process' does not like the
dimensions that we are using.
Another issue is we defined a balance called 'Overtime Earnings' and need to
load this balance with ITD dimension as well in order to calculate a
deduction. This also seems to be a problem.
any help would be greatly appreciated.
TIA.
Metin
SIGECO
Subject: Re: [orahrms-l] ITD(inception to date) Balance Loading for user definedBalances !
From: SHR Rav hrsupt39@hotmail.com
Date: Sun, 20 Jun 1999 09:57:20 EDT
Hi
Can you give more info about the load like upload date, exact dimension
name. Are you getting this error to everybody or only to a perticular
Person.
Srini.Ravuri
Load selected initial balances
Subject: [orahrms-l] Initial Balance Loads
From: Terry Hodge tahodge@hotmail.com
Date: Wed, 09 Jun 1999 12:13:16 GMT
All,
I have a client which would like to only bring forward initial SUTA,
401k and stock purchase balances. This does not include any other balances,
such as gross wages ,etc.
I have suggested to do cut two w4s, and not bring any balances forward.
Does anyone have any suggestions, or input for this scenario?
Thanks in advance,
Terry
Subject: RE: [orahrms-l] Initial Balance Loads
From: Pat Keeley PKeeley@amctheatres.com
Date: Wed, 9 Jun 1999 08:18:38 -0500
Terry, Are they changing their federal employer Id number? Federal
legislation state that only one W2 per employee from a single employer ID is
to be issued, except when all the wage information does not fit on a single
W2. Another option would be to create an "electronic media" file for both
the legacy and the Oracle system that could be merged at year end and W2s
and the Federal Tape (or other type of file) created from the consolidated
file.
What about FUTA and SS limits? This would not be my suggested method of
converting. If they don't want to bring balances forward, I suggest they
wait until the first pay period of the year, otherwise they will be creating
some big headaches for themselves.
Pat Keeley
ARIS Corporation
Initial Balance Upload error PAY_52152_INV_ASS_BALS
Subject: [orahrms-l] Initial Balance Upload error : PAY_52152_INV_ASS_BALS
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Wed, 16 Jun 1999 15:09:06 -0400
Hello
During initial balance upload, i get the following error in the report
output. The error is :
PAY_52152_INV_ASS_BALS : no error text available . 95% of all balances
were converted successfully. The other 5% get this nasty error message
mention above.
Has anyone had experience with this error b/4.
We are running Oracle HRMS rel. 10.7, 16.1
Your suggestions would be appreciated.
Regards
Manny
Initial Balance Upload - white paper for
Subject: [orahrms-l] Initial Balance Loads
From: "Joanne Owsley" joanne.owsley@aris.com
Date: Tue, 27 Jul 1999 16:45:25 -0700
Does there exist documentation - White Papers, etc. - covering the initial balance load for Oracle Payroll. I've seen the White Paper on Balance Adjustments, but I don't think that's exactly what I am seeking. I'm hoping to find something from a technical perspective.
Thanks!
Requistion Import program
Subject: [orahrms-l] Requisition Import
From: "Joanne Owsley" joanne.owsley@aris.com
Date: Mon, 26 Jul 1999 15:17:54 -0700
Is there anyone out there familiar with a program called Requisition Import? It is set up in my client's production database and scheduled to resubmit every 15 minutes after completion. We suspect that it may be conflicting with the Payroll process. However, I don't know enough about it to draw conclusions. If anyone out there is familiar with this, I'd like to know what it does - specifically, does it hit on any HR or Payroll tables...
Thanks!
Joanne Owsley
Aris Corporation
Oracle Business Unit
Subject: [orahrms-l] FW: [orahrms-l] Requisition Import
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Tue, 27 Jul 1999 07:59:53 -0400
Requisition import is used to create purchase requisitions; typically the
requisition interface table is populated directly either for conversion or
for data being interfaced from another system. When Requisition Import runs,
it creates the Oracle purchase requisitions. The requisitioner and the buyer
(both required info on the purchase req) are validated against the employees
table (PER_PEOPLE_F?).
Ellen Young
Oracle Apps Project Manager
Family Dollar Stores, Inc.
eyoung@familydollar.com
Subject: RE: [orahrms-l] Requisition Import
From: "John Parker" jiparker@mindspring.com
Date: Sun, 1 Aug 1999 22:30:19 -0700
Joanne: The requisition import is the Oracle Purchasing process that transfers approved
requisitions to the purchase order 'pool'. This is normally set to automatically run every 30
minutes or so. Depending on the number of req.'s being processed it may or may not affect
payroll processing. Thanks, John Parker, KBACE Technologies Inc.