Import Microsoft Excel time entry data into Paymix table
Subject: [orahrms-l] Automating Paymix Table
From: "Shrestha, Amal" AShresth@JPI.com
Date: Mon, 9 Aug 1999 16:42:50 -0500
We are on Oracle HMRS 10.7. We would like to import Microsoft Excel
time entry data into Paymix table and continue with validation/transfer
processes.
Please let me know if there is anyone who has developed ways to do this.
If you have, I would appreciate you helping defining formats and
procedures to import this data into ORACLE.
Thanks!
Amal Shrestha
Application Developer
JPI
600 E. Las Colinas Blvd. # 500
Irving, TX 75039
Phone: 972-556-3840
FAX: 972-556-3860
mailto:ASHRESTH@JPI.com
Subject: Re: [orahrms-l] Automating Paymix Table
From: "Ken Conway" ken.conway@bosscorporation.com
Date: Tue, 10 Aug 1999 08:43:11 -0500
Amal:
You will want to write to the tables pay_pdt_batch_headers,
pay_pdt_batch_lines, & pay_pdt_batch_checks. As far as procedures are
concerned, I attempt to organize batches based on work locations and/or on
who is the payroll manager responsible for approval. You will want to
create a naming convention for the batch names so that it is easy for a
payroll manager to identify batches from one location to another and one
week from another, etc. Please feel free to give me a call, and I will help
you to strategize further.
Good luck,
Ken
Ken Conway
BOSS Corporation
Better Organization Service Solutions
(214) 495-7654 Voice
(214) 495-7543 Fax
www.bosscorporation.com
Load Vertex information to Payroll
Subject: [orahrms-l] URGENT!!!!!!!!!!!!! Regarding Vertax
From: "Rajesh Patel" Patelra@rockfordcorp.com
Date: Thu, 12 Aug 1999 12:09:13 -0700
Hi guys,
We upgrade Oracle HRMS and Payroll from 10.7SC to Rel 11.0.3. I'm
looking for guidance on Vertex's payroll tax updates for Oracle HRMS
For Rel 11.0.3 and How we can load this Vertax information in
Payroll.
I will appreciate your help in this regarding.
Rajesh
patelra@rockfordcorp.com
602-517-3037
Subject: RE: [orahrms-l] URGENT!!!!!!!!!!!!! Regarding Vertax
From: "Smith, Amy" Amy.Smith@fmr.com
Date: Thu, 12 Aug 1999 20:56:18 -0400
If you apply all of the mandatory patches for 11.03 listed
on Oracle's ftp site, one of them is 850621 - this is the
Cobol Vertex code. Along with this, you need the latest
monthly .dat file that comes directly from Vertex.
Amy Smith
Application Support - Oracle HRMS
Phone: (603) 791-7201
Email: amy.smith@fmr.com
Pager: (800) sky-8888 PIN# 1572913
Load Legacy Data - best way to
From:
"Barnett, Janet L." jlbarnet@mountaineergas.com
8/23/99 8:33 PM
Subject:
[orahrms-l] legacy data
What is the preferred(best) method of loading legacy data into the HRMS
database(vers 11.02)?
I have read about the API's. Does anyone have sample SQL programs I
could review for ideas? I'm fairly new
with SQL. Thanks for your help.
Janet Barnett
Mountaineer Gas Company
From:
"Schwartz, Ken" kschwar@rwjf.org
8/23/99 8:51 PM
Subject:
RE: [orahrms-l] legacy data
To:
"'Barnett, Janet L.'" jlbarnet@mountaineergas.com
Janet:
Either use the API's, Data Pump (fancy term for API's) or direct enter the
data using the various Oracle HRMS forms.
If you do not have a great amount of data, then direct entry is the best.
You can also use it as a training vehicle for the HR department as well as
anyone else that will use the system.
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
Load Positions - ORA-06508 error
From:
Rajesh Babu nrajeshbabu@yahoo.com
Tue 1:21 AM
Subject:
[orahrms-l] error with loading positions using hr_position_api.create_position
Hi All,
We had no problems in loading positions using
HR_POSITION_API.CREATE_POSITION until yesterday.
But when we try to load new set of positions, it gives an error
(ORA-06508: PL/SQL: could not find program unit being called).
Did anyone face this kind of error or situation.
Thanks in advance.
Rajesh