ADP Payroll and HR interface - Query 1
Subject: [orahrms-l] ADP Interface
From: Hector Luciano HLuciano@dataforceus.com
Date: Tue, 2 Feb 1999 16:29:23 -0500
One of my clients will use Oracle HR and interface with ADP Payroll
software. Any experiences on this?
Thanks in advance
Hector I. Luciano
Director of Sales
Dataforce Corporation
(305) 471 0811 Ext. 123
(305) 471 9054 Fax
(305) 790 4589 Cell.
ADP Payroll and HR interface - Query 2
Subject: [orahrms-l] ADP Connection
From: "Schwartz, Ken" kschwar@rwjf.org
Date: Tue, 3 Aug 1999 08:56:07 -0400
Greetings from Princeton, NJ!
We are implementing Release 11.xx HR and have just converted our outsourced
payroll to ADP 4 Windows. We are interested in hearing from organiztions
that have implemnented or are about to implement ADP Connection.
According to the press release, this product is supposed to allow Oracle HR
to pass information directly to the ADP payroll.
If your organizatoin has an interface to ADP of any kind, I would like to
speak with you as well.
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
Deletion of Element Entry
From:
"Kevin Jarrett" kejarr@copelco.com
8/31/99 8:17 PM
Subject:
[orahrms-l] Oracle/Ceridian Interface -- Trigger to Disable Element Entry Deletion
Hi folks,
We're 10.7SC/16.1 HR only with the interface to Ceridian Source100 payroll.
The interface includes a trigger that prevents deletion (purging) of
element entries within Oracle. It is called:
OBJECT_NAME
--------------------------
HR_CER_ELE_ENTRY_VALUE_ARD
This trigger makes our life difficult when our users make keying errors,
especially when creating salary proposals. As a result, we can't delete or
change salary proposals once they are created. D'oh!
The trigger can be disabled but I am uncomfortable doing so. It's got to be
there for a reason.
Would anyone familiar with this interface and this specific trigger care to
comment?
Thanks, kj
From:
"Lewis Cunningham" LCunningham@gwmail.valencia.cc.fl.us
8/31/99 8:34 PM
Subject:
Re: [orahrms-l] Oracle/Ceridian Interface -- Trigger to Disable Element Entry Deletion
It's an integrity trigger. It's been a while since I read the docs but
Oracle and Ceridian don't want the 2 systems to get out of sync. If I
remember correctly though, that interface is based heavily on date
tracked views, as long as you haven't actually given the element to
anyone, you shouldn't feel uncomfortable disabling it, deleting the
element and then re-enabling. I wouldn't reccomend permenantly
disabling it though.
Lewis
ADP file load to GL - query 2
From: "Michael Porter" MPorter@pgahq.com
Reply-To: oraapps-l@cpa.qc.ca
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: ADP to Oracle GL???
Date: Mon, 25 Oct 1999 07:55:16 -0400 (EDT)
We use ADP for our Payroll system. Here is our basic process...
1) We send ADP our payroll data file via modem.
2) ADP generates a report and we retrieve it from them via modem.
3) Payroll person enters info into GLDI and loads into Oracle GL.
ADP claims they can send us an ASCII file that we can "automatically" load
into our GL. What I think they are really saying is that they can send us
a file that can be loaded into the GL interface table and we process it
just as though GLDI had put it there? We want to eliminate the maual
keying of the ADP payroll data into GLDI.
Anybody have any experience with this process???
TIA,
Mike
Date: Mon, 25 Oct 1999 10:01:25 -0700
From: Ganga Andru gandru@cisco.com
To: oraapps-l@cpa.qc.ca
Subject: Re: ADP to Oracle GL???
Mike,
You can take the data into GL both the ways. You need to assess which is
more convenient.
If the ASCII file from ADP has all relevant data, you can load it into GL
Interface using Sql*Loader . Alternatively, You can also open the ASCII
file in excel spread sheet and copy the relevant data into the appropriate
columns of Journal Template of GLDI.
Gangadhar
Date: Mon, 25 Oct 1999 10:24:39 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: ADP to Oracle GL???
Michael, I have written this interface twice and you
are on the right track.
Automatically will depend on your technical staff, but
the mapping is pretty easy with the accrual entries
being the only tricky area. The biggest problem I
faced was getting the file from the PC to a place
where a UNIX process could take over.
Another option to explore is to get the ASCII file and
import it into a GLDI spreadsheet.
Good luck.
Andy Schindler
NRC, Inc
Date: Mon, 25 Oct 1999 17:18:19 GMT
From: "Joe Lichtefeld" j_lichtefeld@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: ADP to Oracle GL???
We use a file from ADP and use SQL Loader to put it in the Oracle GL
interface table. Our issue is that the ADP system can not capture our GL
segments to the level of detail that we need. Therefore, in the Loader we
also map the data from ADP to what we need in Oracle.
Since we have the mapping step, we find that it is more efficient to use
this method versus using ADI.