Legacy migration facility
Subject: [orahrms-l] Oracle HRMS Legacy Migration Facility
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Fri, 5 Feb 1999 08:43:11 -0500
Oracle HRMS has very recently come out with a new feature called "DATA PUMP"
that will help anyone looking for an easier way to load legacy data into
Oracle HRMS.
The predefined APIs for data load are still used and strongly recommended by
us because they enforce all the business rules in the system and guarantee
the integrity of any data loaded into the system. Now with this new
facility, we can support rapid implementation by simplifying and
standardizing the common tasks associated with loading batch data into HRMS
tables. We don't have to write programs to call the APIs for data loading;
the data pump utility calls the APIs. All we have to do is load data into
interface or batch tables.
Regards,
Tony x8452
http://www.mcsgroups.com
Subject: Re: [orahrms-l] Oracle HRMS Legacy Migration Facility
From: "Gregory A. Clark" GACLARK@us.oracle.com
Date: 05 Feb 99 07:33:31 -0800
Tony,
Thanks for the useful information on Data Pump.
A white paper entitled "Oracle HRMS Data Pump" is available in the Oracle
Payroll Technical Library for all customers who have access to Oracle MetaLink.
Regards,
Greg
Subject: [orahrms-l] Data Pump White Paper
From: "Gregory A. Clark" GACLARK@us.oracle.com
Date: 05 Feb 99 09:55:03 -0800
For those customers who have access to Oracle MetaLink...
1. Link to http://support.oracle.com/metalink/
2. Enter User Name and Password
3. Navigate: Applications => Oracle HRMS => Oracle Payroll => White Papers
4. Download file "Oracle HRMS Data PUMP(PDF)"
Regards,
Greg
HRMS DataPump
From: Shah, Sandeep V [SMTP:svshah@kpmg.com]
Sent: Friday, June 11, 1999 10:14 AM
Subject: Question on HRMS DataPump
Hi all,
I am looking for some info on Data Pump. I already have a white paper
from
Oracle. However, I am looking for any previous experience using datapump
to convert employees. Is it faster than writing custom programs? Any
help
will be greatly appreciated.
Thanks,
Sandeep Shah
Senior Consultant
kpmg Consulting
Oracle Applications Practice
973-912-6532(vm)
804-662-2641(client)
svshah@kpmg.com
Date: Mon, 14 Jun 1999 07:18:50 -0500
From: "Matson, Mark J." MatsonMJ@bvsg.com
Subject: RE: Question on HRMS DataPump
Sandeep,
I have not used the DataPump, but I have read the white paper from Oracle.
It seems that whether you use the DataPump or the base APIs, you will still
have to write some custom code. I presented a paper at two OAUG Conferences
discussing the use of the HR APIs for employee conversion into Oracle. A
copy of the paper and code can be found at
http://www.bvsg.com/papers/oracle.html
I hope this helps.
Mahalo (Thanks).
Mark J. Matson
BV Solutions Group
A Black & Veatch Company
Data migration
Date: Mon, 28 Jun 1999 18:01:52 -0400
From: "Bartoletti, Michael" BartolMi@rf.suny.edu
Subject: Data Migration
We are analyzing the HR APIs for loading data into the Oracle applications.
There does not seem to be any defined method for migrating data into
flexfields in the HRMS suite. Does any one have any comments on how this
may be done?
Thanks
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
mailto:bartolmi@rf.suny.edu
Load Salary - APP-51312 error
Date: Fri, 25 Jun 1999 11:08:40 -0700
From: Steve Silveri ssilver@dpc.com
Organization: Dataproducts
To: "'OraHRMS-L@mail-list.com'" OraHRMS-L@mail-list.com
Subject: [orahrms-l] APP-51312
I am loading employees and trying to load salries as well.
When I get to the hr_upload_propoasal_api I get the error
APP-51312 Salary Component cannot be created for the salary proposal.
This worked with 10.7 API, but we are now going up on 11.03. I added
p_change_amount_1 in 11.03 because it kept telling me the
salary was null. Otherwise the calls are the same. Any ideas? The
beginnning of the call looks like
v_obj_version1 := NULL;
v_obj_version2 := NULL;
v_proposal_id := NULL;
v_ppc_obj_1 := NULL;
v_component_id_1 := NULL;
v_component_reason_2 := NULL;
v_approved_2 := NULL;
v_ppc_obj_2 := NULL;
hr_upload_proposal_api.upload_salary_proposal(
p_change_date = v_hr.hire_date,
p_business_group_id = v_busgroup_id,
p_assignment_id = v_assign_id,
p_pay_proposal_id = v_proposal_id,
p_proposed_salary = v_amount,
p_object_version_number = v_obj_version1,
p_ppc_object_version_number_1 = v_ppc_obj_1,
p_component_reason_1 = 'NEWH' ,
p_approved_1 = 'Y',
p_change_amount_1 = v_amount,
API and employee nos.
Date: Thu, 17 Jun 1999 17:07:17 PDT
From: Mani Gounder gmanni@hotmail.com
Subject: Oracle HRMS
Hi,
I am on Oracle HRMS rel 11 NCA, and I have some questions related to the
Oracle HRMS application.
1. Is there any Open Interface tables and the corresponding standard
procedures exists in Oracle HRMS as like we have the same in Oracle
Financials and Manufacturing applications?.
2. To load the data into the application tables, is there any standard APIs
available in HRMS(HR & Payroll) as like we have the same in Oracle
Financials, Oracle Projects, etc.,. if so, in which manual I can find the
details about those?.
3. The fields like employee number, etc., how they are generated in HRMS?.
Any ideas or thoughts on this would be greatly appreciated.
Thanks,
Mani Gounder.
Date: Fri, 18 Jun 1999 07:45:36 -0400
From: "Bartoletti, Michael" BartolMi@rf.suny.edu
Subject: RE: Oracle HRMS
There are a bunch of HRMS APIs for loading the data. There is also
something called HR Data Pump. There is a list in help for the HR APIs. If
you need more information please let me know.
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
mailto:bartolmi@rf.suny.edu
Date: Fri, 18 Jun 1999 15:07:00 -0500
From: "Matson, Mark J." MatsonMJ@bvsg.com
Subject: RE: Oracle HRMS
I wrote and presented a paper at two OAUG Conferences discussing the HR
APIs. A copy of the paper and code can be found at
http://www.bvsg.com/papers/oracle.html
I hope this will help to answer
some of your questions.
Mahalo (Thanks).
Mark J. Matson
BV Solutions Group
A Black & Veatch Company
Load Tax Balance and actuals
Subject: [orahrms-l] Re: Payroll, Balance upload(tax+actual)
From: "lakshmi mannem" prasuna_ml@hotmail.com
Date: Mon, 15 Feb 1999 07:04:05 PST
Hi All
I have a client who implementing R11. I have to load balances both tax
balances and actuals. We are planning to go live by July 1st.
I am getting two flat files one for taxes and another for actual
balances.
I would appreciate if some body let me know the process how to load
these balances. Is there any hidden problems.
Thanks in Advance
Raju
oracle HR consultant
prasuna_ml@hotmail.com
Subject: [orahrms-l] Fw: [orahrms-l] Re: Payroll, Balance upload(tax+actual)
From: "William C.Stratton" bstratton@sprynet.com
Date: Tue, 16 Feb 1999 13:51:00 -0500
I noticed that you did not get any answers to this question, probably since
the question is not an easy one to answer via email. Oracle's balance load
process is very complex and requires a thorough knowledge on how tax
balances are stored. The best place to start is the technical essay in the
back of the Oracle HRMS US Implementation Guide. You will quickly notice
that there are many balances to load, including but not limited to:
Gross Earnings
Supplemental Earnings for FIT
Supplemental Earnings for FUTA
Supplemental Earnings for Medicare
FUTA Taxable
FUTA Liability
SS EE Taxable
SS ER Taxable
Def Comp 401K
Def Comp 401K for Medicare
Def Comp 501K for SS
and so on ( I didn't even start to talk about state related tax
balances!!).
All of these balances, and many more, must be explicitly loaded using the
PAY_BALANCE_BATCH_HEADERS and PAY_BALANCE_BATCH_LINES tables, and running
the balance load processes discussed in the technical essay titled "Initial
Balance Loading for Oracle Payroll", also in the Implementation guide. This
is a very iterative and time consuming process. Do not underestimate the
time and effort needed to successfully complete this very important task.
How well you do this task will determine how easy your year-end processing
will be.
All of your balances, both tax and element, must be loaded prior to your
first live payrun. Once the first run is performed, you cannot go back and
try again, without rolling back all of your payruns.
Good Luck!!!!
Bill Stratton
BOSS Corporation
Initial tax balance upload
Subject: [orahrms-l] Re: Initial tax balance upload
From: "lakshmi mannem" prasuna_ml@hotmail.com
Date: Thu, 25 Feb 1999 13:25:23 PST
Hi All
I am trying to load the tax balances in to Oracle Payroll. My flat file
look like this: this is with dimension YTD only
emp no
comp no
tax unit id
fit withheld(ytd)
fit taxable(ytd)
ss ee withheld
ss ee taxable
ss er withheld
ss er taxable
med ee taxable
med ee withheld
med er taxable
med er withheld
futa er withheld
futa er taxable
sit ee withheld
sit ee taxable
sui ee withheld
sui ee taxable
My problem is while querying the database for balance type id for
balance like FIT TAXABLE, FUTA ER WITHHELD, SS ER WITHHELD, SIT EE
TAXABLE, i AM GETTING NOTHING.
COULD SOME BODY THROW SOME LIGHT HOW CAN I GET THE BALANCE_TYPE_ID TO
INSERT INTO PAY_BALANCE_BATCH_LINES TABLE.
I think I have to load the two tables batch_headers, batch_lines for
each balance separately or is there any other process.
I would appreciate if some gurus in this field help me out.
Thanks in advance
Raju
Subject: Re: [orahrms-l] Re: Initial tax balance upload
From: "William C.Stratton" bstratton@sprynet.com
Date: Fri, 26 Feb 1999 08:39:53 -0500
As you already discovered, Oracle's tax balances do not map exactly as you expected. You will have to manipulate your flat file quite a bit to get it into a format so that you can use SQL/Loader to load the PAY_BALANCE_BATCH_HEADERS and PAY_BALANCE_BATCH_LINES tables (and yes, this is the only supported Oracle method to do initial balance loads). For example, to load FIT you will need to load these balances (and this is the easy one!!!):
Gross Earnings
Supplemental Earnings for FIT
Supplemental Earnings for NWFIT
Def Comp 401K
Section 125
FIT Withheld
My advice to you is to study the technical essay in the appendix of the HRMS Implementation Guide. This will give you a good primer on all of the required balances. This task is not an easy one, so do not underestimate the time it takes to complete this successfully.
Good Luck!!!
Bill Stratton
BOSS Corporation
API to load organization data
Subject: [orahrms-l] API for loading organization data?
From: James Wood JWOOD@FAMILYDOLLAR.com
Date: Fri, 12 Mar 1999 07:46:53 -0500
In order to provide the quarterly Bureau of Labor Statistics reports (aka
"Work-site reports"), we've learned that we need to set up each one of our
3,100 stores as an Organization; then we need to set up each of these as a
"Work-site Reporting Organization". Manually, this would total 6,200
entries, something we're obviously not looking forward to.
Has anyone else encountered a similar situation and, if so, are you aware of
an API which could automate this process? Any suggestions would be greatly
appreciated. Thanks,
James Wood
Family Dollar Stores
Subject: RE: [orahrms-l] API for loading organization data?
From: "Jewell, Sharon L" sljewell@kpmg.com
Date: Fri, 12 Mar 1999 10:20:14 -0500
You may want to load locations first. The following are available to
complete the organization load.
The peperbb1.pkh identifies those apis available for the 'building
blocks for core personnel entities'.
Locations api: hrperbb1.insert_location
The peoru01t.pkh provides the organization units
Organization units api: hr_organization_units_pkg.insert_row
The peori01t.pkh provides the organization classification
Organization classification api: hr_org_information_pkg.insert_row
Sharon
Sharon Jewell, CPA
Manager
kpmg
PSW Consulting
Oracle Applications
714.445.5744
sljewell@kpmg.com
Subject: Re: [orahrms-l] API for loading organization data?
From: louis_avrami@es.adp.com (Louis Avrami)
Date: Fri, 12 Mar 1999 16:44:58 -0500
When I saw this message I remember a web site with HR API information.
Info on the URL is below. Hope that it helps.
Thanks again to Mark Matson for making this information available.
Lou Avrami
http://www.bvsg.com/papers/oracle.html
Initial Balance Upload (UNDO TRANSFER) Mode
Subject: [orahrms-l] Initial Balance Upload (UNDO TRANSFER) Mode
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Wed, 17 Mar 1999 08:36:26 -0500
Hi Folks
While running initial balance upload with UNDO TRANSFER, the concurrent
request complete with a status of error. The report log shows the
following error message:
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 1696
ORA-06512: at "APPS.PY_ROLLBACK_PKG", line 2026
ORA-06512: at "APPS.PAY_BALANCE_UPLOAD", line 4160
ORA-06512: at "APPS.PAY_BALANCE_UPLOAD", line 4500
ORA-06512: at line 4
If u have experience with this issue i will be glad to hear from u.
We have Oracle HRMS release 10.7.
Regards
Manny
User Emulator Software
From: Pat Keeley PKeeley@amctheatres.com
To: "'HRMS List Service'" OraHRMS-L@mail-list.com
Date: Mon, 21 Jun 1999 14:26:34 -0500
Subject: [orahrms-l] User Emulator Software
Are any of you familiar with a software called "Platinum?" It is a "user
emulator" package. I was thinking it might be helpful for loading data (in
place of Excel macros). I would like to hear from anyone with experience
with this package or other similar packages.
Thanks
Pat Keeley
Date: Mon, 21 Jun 1999 13:03:06 -0700
To: Pat Keeley PKeeley@amctheatres.com
From: Lewis R Cunningham lcunning@popmail.lmu.edu
Subject: Re: [orahrms-l] User Emulator Software
I've used various macro products and some are useful for testing (some more
than others). I wouldn't use it for data loading because of timing issues.
It's easy for the macro to get confused and out of sync.
To load data, use the APIs. They won't let you load every piece of data,
but will handle the bulk of it.
Lewis
ANY API for Loading the W-4 form in HR
Subject: [orahrms-l] ANY API for Loading the W-4 form in HR ??
From: "Gul, Metin" MGul@sigeco.com
Date: Thu, 25 Mar 1999 15:58:43 -0600
Hi All,
We are implementing Oracle HR & Payroll in 10.7 SC.
Just wanted to know , if anybody came across with W-4 tax forms for federal,
state and county. I will need to bring over some employee details into these
forms, is there any API out there that I am not aware or do I have to do it
manually writing it to the tables ??
thanks
Metin Gul
mgul@sigeco.com
Subject: RE: [orahrms-l] ANY API for Loading the W-4 form in HR ??
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Thu, 25 Mar 1999 17:35:33 -0500
Metin: The option of manually writing it to the tables is out of question.
There is an unsupported API (PAY_US_EMP_TAX_RULES_PKG.Update_Row) you could
use, but you have to be extremely careful since the tax area is very
sensitive for payroll processing. If the number of employees you are
dealing with is not big, your best bet is to have data-entry folks key this
in. Let me know if you need any further information.
Regards,
Tony x8452
http://www.mcsgroups.com
Subject: RE: [orahrms-l] ANY API for Loading the W-4 form in HR ??
From: "Gul, Metin" MGul@sigeco.com
Date: Thu, 25 Mar 1999 16:58:35 -0600
Masoor,
Thanks for your quick reply ! We have about 950 active employees so I don't
know how pleased the functional folks going to be...
I looked at the tables, for federal, state, county and city there are tables
as :
PAY_US_EMP_FED_TAX_RULES_F
PAY_US_EMP_STATE_TAX_RULES_F
PAY_US_EMP_COUNTY_TAX_RULES_F
PAY_US_EMP_CITY_TAX_RULES_F
somebody told me that they loaded this tables manually meaning writing to
the tables, I think they used Excel macros if I remember correctly.
anyway if the API exists I would gladly use it, however to use update_row,
the employee should have some rules (data or row in the table) already
existing.
right ?
thanks
Metin
Subject: [orahrms-l] Re[2]: [orahrms-l] ANY API for Loading the W-4 form in HR ??
From: pat_keeley@power-one.com
Date: Thu, 25 Mar 1999 15:33:37 -0800
Metin,
My prior clients used the unsupported API, It worked fine. You just
won't get any help from Oracle. So -- just make sure you test
everything.
Pat Keeley
Subject: RE: [orahrms-l] ANY API for Loading the W-4 form in HR ??
From: pkandra@civicdevelopment.com
Date: Fri, 26 Mar 1999 08:14:04 -0500
The API's are:
PAY_US_EMP_DT_TAX_RULES.INSERT_FED_TAX_ROW
PAY_US_EMP_DT_TAX_RULES.INSERT_STATE_TAX_ROW
PAY_US_EMP_DT_TAX_RULES.INSERT_COUNTY_TAX_ROW
PAY_US_EMP_DT_TAX_RULES.INSERT_CITY_TAX_ROW
These tax API's can be very tricky. I'd suggest using a consulting resource
who's done this before.
Subject: RE: [orahrms-l] ANY API for Loading the W-4 form in HR ??
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Fri, 26 Mar 1999 08:21:08 -0500
Metin: You are on the right track. This API has to be run twice - once to
create the default tax records and then to update the rows.
Regards,
Tony x8452
http://www.mcsgroups.com
Subject: re: [orahrms-l] ANY API for Loading the W-4 form in HR ??
From: "Bob OConnor" boconnor@vines.colostate.edu
Date: Fri, 26 Mar 99 8:04:13 -0700
Oracle has a date-tracked W4 patch out. This patch includes new API
functionality which causes the Address and assignment api to create default tax
records. It then also provides additional api to do the update of tax
records.
We are using these to transfer our 11,000 employees.
Until this came out we used two methods to get a default tax record created and
then to update the tax record.
1) This call is right out of assignment form.
apps.pay_us_emp_dt_tax_rules.default_tax_with_validation
(p_assignment_id => c1.assignment_id
,p_person_id => c1.person_id
,p_effective_start_date => c1.effective_start_date
,p_effective_end_date => c1.effective_end_date
,p_session_date => sysdatev
,p_business_group_id => 0
,p_from_form => 'Assignment'
,p_mode => null
,p_location_id => null
,p_return_code => l_return_code
,p_return_text => l_return_text);
2) the second method is to write directly to pay_us_emp_fed_tax_rules_f (and
state...) to update the exemption etc info.
Please note: neither of these two methods is supported by oracle and hence the
reason for coming out with the new API. I believe the patch number is 760309.
Bob
Bob O'Connor
Colorado State Univ
boconnor@vines.colostate.edu
970-491-4380
Version of Visual Basic Macro for Rel. 11
Subject: [orahrms-l] Release 11 Visual Basic Macro
From: "Deb Burgess, The Burcon Group" burcongp@gte.net
Date: Wed, 31 Mar 1999 03:18:21 -0800
Does anyone have a version of the load macro that works with Release 11? I
have been very successful using the 10.7SC version for setup and data loads.
For small implementations it cannot be beat. I have heard that a different
macro is required for R11 due to the insertion of the Web server.
Have A Great Day!
Deb Burgess, The Burcon Group
562.420.6288 (Office)
310.898.8520 (VM/Pager)
310.488.7608 (Mobile)
Problem loading initial balances - Adjustment not valid
Subject: [orahrms-l] Loading Benefit Details using HR_ENTRY_API effective end dates are not taken
From: Lewis R Cunningham lcunning@lmumail.lmu.edu Conversion of Life-to-Date Balance
Date: Thu, 29 Jul 1999 15:57:09 -0700
Date: Fri, 30 Jul 1999 10:13:29 -0400
From: "lakshmi mannem" prasuna_ml@hotmail.com
Date: Thu, 01 Apr 1999 07:26:30 PST
Hi folks
I am in the middle of balance conversion. I loaded the balances
sucessfully for my own employees(means entered the data through
screens).
Now I am trying to load the balances for the actual employees. Now I am
getting the errors "Adjustment is not valid" while uploading the initial
balances. Can some body out there knows what is means.
TIA
Raju
Date: Tue, 13 Apr 1999 12:30:13 -0700
-- This is forwarded for my co-worker, he can read but not send
Hi
I am working Apps 10.7SC16.1 on AIX.I am using HR_ENTRY_API package to
load all the benefit details into the oracle from external system.In that
package i am using insert element entry procedure.This procedure got
parameters to pass effective start date and effective end date.But when i
pass the values to those parameters,the procedure is only taking the
effective start date.The effective end date is always set to
31-DEC-4712.But i wanna control effective end date from my data.Could any
one help me in this problem?
Thank You
Lewis R Cunningham
Whitaker IT
Oracle Human Resources Functional and Technical Consultant
LewisC@rocketmail.com
From: "joanetta counce" jcounce@oaklandnet.com
Subject: Conversion of Life-to-Date Balances
Hi All:
We are implementing Oracle 10.7 SC, version 16.1 on a Dec Alpha 8400 with a
Unix operating system. We are having trouble loading our life-to-date
balances. We have been told that Oracle does not support loading
life-to-date balances but it does support the balances once they've been
loaded.
Has anyone converted life-to-date balances to the Oracle payroll module?
Please contact me asap, this is holding up our entire payroll conversion and
in the next week may impact our go-live date.
Thanks for your support.
Joanetta Counce
City of Oakland
Project Lead for HRMS
Jcounce@oaklandnet.com
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Subject: RE: Conversion of Life-to-Date Balances
Joanetta: The way to load Lifetime-to-date balances is by navigating to the
Adjust balances and Adjust Tax balances screens, setting your effective date
to the beginning of year prior to implementation and then entering the
balances for each employee. The automated balance load option in 10.7 SC
does not work for LTD balances. I would test out the LTD balance load for a
few employees and use the overloaded functions in the balance packages (in
assignment mode) to retrieve balances and validate. Hope this helps to put
your implementation on track again.
Regards,
Tony Venkatesh
(301) 206-8452
(703) 793-0847
tonyv@mcsgroups.com