HR-GL - X Validation
Date: Mon, 12 Jul 1999 10:13:31 -0400
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: HR-GL - X Validation
Hi GL/Hr Gurus,
We want to prevent bad assignments in HR (to avoid Xvalidation violations).
Is there any way to enforce GL Cross validation rules in HR?
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
ADP payroll file load to GL
Date: Wed, 28 Jul 1999 08:58:38 EDT
From: "Larry Mandras" lemandras@hotmail.com
Subject: ADP Payroll file to load into G/L
Has anyone been successful in obtaining a readable file from ADP in order to
post a Payroll journal to the General Ledger system. We would like to
receive the file from ADP and either load it to the G/L interface table, or
load it through GLDI.
Thanks in advance....Larry Mandras
Date: Wed, 28 Jul 1999 09:15:12 -0400
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Re: ADP Payroll file to load into G/L
Hi Larry,
I don't remember all the details, but I was successful in working with ADP
to get a readable file from ADP to load into the GL Interface table, and
then imported it with a custom source of ADP Payroll.
If your question is "is it feasable", the answer is YES!!! I would give
yourself at least two months to work with ADP on this, they don't move very
fast, and usually you have to go back to them a few times for minor changes.
Good luck!!!
Bill
Date: Wed, 28 Jul 1999 09:33:30 -0400
From: Harry Swallow harry.swallow@interpath.net
Subject: Re: ADP Payroll file to load into G/L
We're doing that now. ADP sends us two Payroll Journal files; a data file,
and
a report. Both are encrypted, and have to be downloaded from ADP to a PC
running ADPS's PC/Payroll for Windows. The files are decrypted using the
ADP
software, then the data file is FTP'd to the Oracle database server. We use
SQL*Loader to load it into a custom table, then run a PL/SQL script to
summarize
it (the data is VERY detailed), and insert rows into the GL Interface.
E-mail
me directly if you'd like more details.
Date: Wed, 28 Jul 1999 12:33:45 -0300
From: Ken Heckbert kheckbert@ccgw.cc.hollandc.pe.ca
Subject: Re: ADP Payroll file to load into G/L -Reply
Bill and Larry,
We're just about to begin implementing the ADP Payroll
system here, and we were wondering about an interface to
the Oracle GL as well. In the package ADP sent us, they
included the file specs for a flat ASCII file of GL transactions
that the ADP Payroll automatically produces after every pay
run. I assumed that was all the information I needed to load
the transactions (using the GLDI initially). Is there something
else we should be aware of? I'm concerned, Bill, by your
comment that the process may take a couple of months to
resolve.
Thanks,
Ken Heckbert
Finance Officer
Holland College
Date: Wed, 28 Jul 1999 12:01:43 -0400
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Re: ADP Payroll file to load into G/L -Reply
I also received an ASCI file from ADP, and wrote a basic SQL* Loader program
to upload the file to the GL_INTERFACE table. My comments regarding a
couple of months to work with ADP was that I first had to give them the
format that I required, then wait for ADP to generate the ASCI file and send
it, and then test the process. I found the turnaround was a few weeks, and
I went back to the 2 - 3 times with corrections/changes. The total process,
start to finish, took a few months.
It's better to start this process early than to leave it until a few weeks
before "go-live" date.
Hope this advice helps!!!
Bill
Date: Thu, 29 Jul 1999 09:36:19 +0530
From: "M. Kalyansundaram" kalyan@wipsys.soft.net
Subject: RE: ADP Payroll file to load into G/L
Dear Larry,
We also do the same for our payroll processing in US. We get the file into
a spreadsheet and then through the excel macro we could easily load the
same into the apps. We did not get the file in any specific format. We got
the regular output of ADP (which comes out of the windows version) and
convert the file to spreadsheet.
Good luck.
Best regards.
Kalyan.
M. Kalyansundaram
Senior Consultant
Wipro Infotech Software & Services
Applicant Management Facility
Date: Wed, 28 Jul 1999 13:40:56 -0400
From: "Whited, Carolyn" WhitedC@orau.gov
Subject: HR Applicant Management facility
I would like to talk with anyone who is currently using the Applicant
Management facility in Oracle Human Resources. We have tried to implement
this functionality and have experienced problems with the coordination of
other products that us the same HR tables.... like costing in Projects and
Payroll processing of individuals who have job applications which result in
a change in appointment before the completion of the costing of a payroll
run..... thanks for any information you can provide., cw
Carolyn Whited
Systems Analyst, ORAU Oracle System Support
Whited, Carolyn.vcf
Oracle Self Service Human Resources
To: "'William C.Stratton'" bstratton@sprynet.com, OraHRMS-L@mail-list.com
Subject: [orahrms-l] Oracle Self Service Human Resources
From: "Frith, Andrew" Andrew.Frith@viasystems.com
Date: Thu, 4 Feb 1999 14:31:48 -0000
We are implementing HRMS 11.02 HR and Payroll and are investigating the use
of the approval workflows. I am a bit confused by the difference between
Oracle Self Service Human Resources and the Line Manager Direct Access and
Employee Direct Access in Oracle Web employees.
Please could somebody summarise the differences. What needs to be installed?
Many Thanks,
Andrew Frith
AR integration with HR
Subject: [orahrms-l] AR Integration with HR
From: "SAN TAYI" san5371@hotmail.com
Date: Sat, 06 Feb 1999 11:50:14 PST
Hi Folks!
We are on Release 11.0 and have implemented AP,PO and GL and are
currently implementing AR.
In AR we have to define salespersons. Do we have to define salespersons
as Employees First??
In the second phase of our implementation, we may be implemnting HR.
What is the best way to resolve this issue.
Thanks
SAN
Oracle HR/Ceridian Payroll interface
Data import problems
Subject: [orahrms-l] HR: Ceridian Interface View Questions
From: "Kevin Jarrett" kejarr@copelco.com
Date: Wed, 17 Feb 1999 09:59:44 -0500
Hi folks,
We are implementing the Oracle HR/Ceridian Payroll interface and are having
trouble getting data to the Oracle database views. We expected to have
problems but things are getting out of hand. I've got several tars logged
with Oracle support.
I'd post the questions here but to save bandwidth I'll just ask anyone that
has a moment to drop me a line via email or call (800.257.8451 x3140)
whenever it's convenient.
Thanks in advance,
-kj-
Ceridian Payroll interface - With one new hire, everyone treated as new hire
Subject: [orahrms-l] HR: Odd Ceridian View Behavior
From: "Kevin Jarrett" kejarr@copelco.com
Date: Fri, 2 Apr 1999 12:55:10 -0500
Hi everyone,
Our Ceridian interface is installed in our test system and working well,
with one nagging exception.
Whenever we new-hire someone, the LAST_UPDATE_DATE in
HR_CERIDIAN_EMPLOYEE_V is reset to the SYSTEM DATE (i.e., the date of the
new hire) for everyone who is in the same GRE as the new hire. WTF?!!?!
Has anyone seen this before? The result is that the interface thinks every
person's record has changed and ALL are passed through as new hires. They
are already in the Ceridian System, so they error out, but man, what a
mess!
We have secured and applied all required patches for the views.
The interface works beautifully, passing deductions, benefits, and all
employee data, flawlessly as far as we can tell.
What could be causing this?
Here is the SQL that generates LAST_UPDATE_DATE in HR_CERIDIAN_EMPLOYEE_V.
I've checked every one of these columns and NONE of them have today's date,
so I obviously don't understand how this function can be returning the
system date for the value in question.
Please click here for the sql
Any thoughts?
Thanks in advance...have a great holiday!
-kj-
Kevin Jarrett Copelco Capital, Inc.
Project Manager 700 East Gate Drive
kejarr@copelco.com Mount Laurel, NJ 08054
Oracle/Ceridian Interface Requires Seeded Pay Elements
Subject: [orahrms-l] HR: Oracle/Ceridian Interface Requires Seeded Pay Elements
From: "Kevin Jarrett" kejarr@copelco.com
Date: Wed, 7 Apr 1999 14:03:02 -0400
Hi everyone,
We've just discovered that the Ceridian interface views _require_ us to use
the seeded elements Regular Salary and Regular Wages. Problem is, all our
exempt employees do not use the seeded regular salary element, they use a
salary element we created: "Annual Salary." During the initial setup, the
VP of HR balked at having salaries expressed in monthly units (as would be
necessary with "Regular Salary") so we set up another earning with an
annual input value. If we only could have known...
Anyway, when we make a change to an exempt employee's pay, the views don't
pick it up. D'oh! At least the Non-exempt folks are ok and we can continue
testing.
We appear to have two options:
Change every salaried employee's basis, salary, salary proposal details
(including DFFs), and all elements affected by or related to monthly
salary for ~400 employees. Also change every report and custom procedure
we've developed to reflect the fact that PROPOSED_SALARY in
PER_PAY_PROPOSALS now has a value equal to 1/12th the prior figure.
Change the Oracle/Ceridian views to reference our "Annual Salary"
element instead of "Regular Salary".
Has anyone experienced with the O/C interface encountered this before? What
did you do?
I've got Oracle Support working on an estimate of what's involved with #2.
Thanks in advance for any advice,
-kj-
Subject: Re: [orahrms-l] HR: Oracle/Ceridian Interface Requires Seeded Pay Elements
From: "Mavis O'Connor" moconnor@IR.ColoState.EDU
Date: Wed, 7 Apr 1999 14:17:11 -0600 (MDT)
Kevin,
We have had no problems using the seeded element, Regular Salary,
to express annual salary amounts in the salary administration
form and the element entries form. We, too, do not wish to use
monthly units since we always use the annual salary in all
reports analyses, etc. Although the element entry form for
Regular Salary is misleading because it carries a label "monthly
salary" like the input value called "monthly salary" you can
use an annual amount here and it works just fine. When we
run our monthly payrolls Regular Salary automatically pays 1/12
since we chose "annual" when we set up the salary basis.
It sounds to me like you could avoid the painful conversion to
monthly salaries and continue to use annual rates with the
seeded element as we are doing.
Mavis O'Connor
Colorado State University
moconnor@ir.colostate.edu
Passing termination and leave status information to Ceridian
Subject: [orahrms-l] HR: Process, DoNotProcess PAY_SYSTEM_STATUS Settings (HR Only)
From: "Kevin Jarrett" kejarr@copelco.com
Date: Wed, 21 Apr 1999 09:27:28 -0400
Hi everyone,
We are an HR-ONLY client implementing Oracle HR (10.7SC/16.1) with the
interface to Ceridian Source100 Payroll.
We are in active payroll testing and are encountering problems passing
termination and leave status information on to Ceridian. I think something
may be wrong on the Oracle side, I'm just not sure.
According to Ceridian, the Oracle EMP view provides two fields for Ceridian
to determine the employee's status:
PAYROLL_STATUS (derived from PAY_SYSTEM_STATUS in
PER_ASSIGNMENT_STATUS_TYPES or PER_ASSIGNMENT_STATUS_TYPE_AMENDS,
whichever is not null)
DATE_LAST_PAID (derived from FINAL_PROCESS_DATE in
PER_PERIODS_OF_SERVICE)
All our active people have a PAYROLL_STATUS of (P)rocess. All our
employees currently on leave have a PAYROLL_STATUS of (D)o not process. So
far, so good.
When we terminate someone and input a FINAL PROCESS DATE on the
termination window in Oracle, that date is passed to the EMP view (as
DATE_LAST_PAID) but the employee's PAY_SYSTEM_STATUS remains (P)rocess.
Why? This seems illogical to me, other than the fact this person could
be "paid" one last time, so to speak.
When we terminate someone and do NOT input a FINAL PROCESS DATE on the
termination window in Oracle, no DATE_LAST_PAID is passed to the EMP
view (since it does not exist) but the PAY_SYSTEM_STATUS becomes (D)o
Not Process.
I would understand the scenario in #1 above if a subsequent process (like
running a payroll) would change the PAY_SYSTEM_STATUS to (D)o not process.
But we are not running payroll, and as far as I know, noo such process will
occur.
Can anyone enlighten me as to how this is all supposed to work, especially
anyone familiar with the Ceridian interface?
Thanks, kj
Kevin Jarrett Copelco Capital, Inc.
Project Manager 700 East Gate Drive
kejarr@copelco.com Mount Laurel, NJ 08054
Subject: [orahrms-l] RE: HR: Process, DoNotProcess PAY_SYSTEM_STATUS Settings (HR Only)
From: "Kevin Jarrett" kejarr@copelco.com
Date: Wed, 21 Apr 1999 13:42:18 -0400
FYI -- turns out that since we are "HR Only" we didn't see the need to use
different dates for DATE_LAST_PAID and ACTUAL_TERMINATION_DATE, but that's
exactly what the interface wants. Thanks to Gunther Dusek of Interactive
Software in Dallas, TX for pointing this out this little tasty tidbit. Once
again the listserv saves that day. Woooo-hoooo! The Net RULEZ!
Thanks, kj
Kevin Jarrett Copelco Capital, Inc.
Project Manager 700 East Gate Drive
kejarr@copelco.com Mount Laurel, NJ 08054
Interface with Frick
From: Schmit, Mark [SMTP:mschmit@Mail.Donaldson.com]
Sent: Wednesday, March 17, 1999 4:15 PM
Subject: [orahrms-l] Frick
I would like to hear from someone about the Frick file creation routine
anyone is using. I have Frick's year 2000 formats but I'd like to confirm
with a fellow Frick user about where they are pulling their information
from for the specified fields.
Thanks,
Mark Schmit
Donaldson Inc.
(612) 703-4606
Subject: RE: [orahrms-l] Frick
From: James Wood JWOOD@FAMILYDOLLAR.com
Date: Wed, 17 Mar 1999 17:35:04 -0500
Mark,
Feel free to contact me off-line for more information, but here are
the tables we're pulling from for our interface to Frick:
per_people_f
per_assignments_f
per_jobs
per_job_definitions
per_assignment_status_types
pay_payrolls_f
per_pay_proposals
per_periods_of_service
hr_locations
pay_payrolls_f
per_addresses
pay_element__entry_values_f
pay_input_values_f
pay_element_types_f
pay_element_links_f
pay_element_entries_f
hr_organization_units
hr_organization_information
pay_run_result_values
pay_run_results
pay_payroll_actions
pay_assignment_actions
We're running Oracle HRMS 10.7 and we subscribe to Frick's Unemployment
Verification plan (meaning we have to send employee, payroll period, YTD
gross wage, and termination data for each and every one of our employees).
The format we use is the one specified by Frick as Y2K compliant. Like I
said, please let me know if I can help further.
James Wood
Family Dollar Stores
(704)847-6961 x4843
Integration of HR with Workflow
Subject: [orahrms-l] Integrating HR and Workflow
From: "Bob OConnor" boconnor@vines.colostate.edu
Date: Wed, 24 Mar 99 11:09:32 -0700
Hello,
I am interested in finding anyone who has integrated HR/payroll with Oracle
Workflow. Please contact me directly at: boconnor@vines.colostate.edu.
Thanks,
Bob
Bob O'Connor
Colorado State Univ
boconnor@vines.colostate.edu
970-491-4380
Subject: Re: [orahrms-l] Integrating HR and Workflow
From: Lewis R Cunningham lcunning@lmumail.lmu.edu
Date: Wed, 24 Mar 1999 11:21:16 -0800
I've done work with HR and Workflow. What kind of integration are you
interested in?
Lewis
HRMS integration with Projects - Query 1
Subject: RE: [orahrms-l] HRMS & Projects Integration
From: "Deb Burgess" dburgess@burcon-group.com
Date: Wed, 7 Apr 1999 09:44:38 -0700
I have a client who will be using R11.02 HRMS as a single point of entry for
all HR & Payroll related transactions. Payroll will be sent to ADP for
check runs. They will also be installing PT&E to capture all time and
expenses through projects. Has anyone integrated projects with HR to pass
timecard details? They would like to only enter timecard info in projects,
pass it to HR and then have HR pass to ADP. Anyone have any ideas? Is it
do-able? Or, more realistically, is it feasible?
Have A Great Day!
Deb Burgess, The Burcon Group
562.420.6288 (Office)
310.898.8520 (VM/Pager)
310.488.7608 (Mobile)
Subject: [orahrms-l] RE: HRMS & Projects Integration
From: "Dina Rotem (h)" dinar@rafael.co.il
Date: Thu, 08 Apr 1999 22:51:50 +0300
Hi Deb,
I haven't integrated Projects time with Payroll.
But I suggest you would be aware that Oracle will stop supporting PT&E
in the near
future. May be it's not worth starting with that now.
There are some other products in Projects to capture time & expenses,
either connected
or disconnected. You may also want to check what Time management has
to offer. I've
had understood that they have some integration with Projects.
Dina
How to generate Organization Charts
Subject: [orahrms-l] Organization Charts
From: "Diane Lundgren (MP)" DLUNDGREN@exchange1.mnpower.com
Date: Wed, 24 Mar 1999 12:51:00 -0600
Hi - I'm looking for any information on how companies are generating
organization charts that include employee name, job title, reporting
line. Is there software available that interfaces with Oracle? Does
Oracle have this functionality available in future releases? We are
currently on Release 10.7 16.1.
Subject: RE: [orahrms-l] Organization Charts
From: sredrova@es.com
Date: Wed, 24 Mar 1999 12:22:08 -0700
We are interfacing Oracle HR data to orgplus, which is a very robust tool
for org charting. We are also looking at a solution with VISIO.
Let me know if you need any further information.
Stephanie Redrovan
Information Technologies
Evans & Sutherland Inc. (http://www.es.com)
sredrova@es.com · 801.588.1825
Subject: Re: [orahrms-l] Organization Charts
From: "Scott L. Frost" sfrost@noblestar.com
Date: Wed, 24 Mar 1999 14:35:29 -0500
In the past I have simply used tools such as Powerpoint's Organization Chart
features to create the org charts. This is really useful, especially
because you can have administrative assistants easily update them without
having to become Oracle saavy.
To get some automated graphical charts, you can use ADE which is included
with Oracle HRMS to generate GUI drag and drop Org charts (as well as
position hierarchy charts which it sounds like you are looking for). You
can modify the look of these somewhat (rounded boxes versus square) but they
are not really that robust. You can also print these charts, but again,
formatting may be an issue.
I'd recommend running the ORganization Hierarchy report and having an Admin
transfer it one time over to a program such as powerpoint. It will be
easier to maintain, especially if you have a lot of turnover.
Hope this helps!
Scott
Scott Frost
Oracle HRMS Consultant
Noblestar Systems Corporation
http://www.noblestar.com
Noetix and Business Objects
Subject: [orahrms-l] HR: Noetix and Business Objects
From: "Kevin Jarrett" kejarr@copelco.com
Date: Tue, 30 Mar 1999 07:59:57 -0500
Hi all,
Got a call from Noetix and now I'm stoked about the potential this tool has
for us (to ease reporting in HR).
Anyone using Noetix and BO in Oracle HR, specifically?
How about Noetix and BO in general?
Any opinons about Noetix overall?
Thanks in advance,
-kj-
Kevin Jarrett Copelco Capital, Inc.
Project Manager 700 East Gate Drive
kejarr@copelco.com Mount Laurel, NJ 08054
Subject: Re: [orahrms-l] HR: Noetix and Business Objects
From: Kconway@manu.com
Date: Tue, 30 Mar 1999 09:03:22 -0500
Our initial look at the Noetix product was very positive. Please include
me on any information you receive on this, if possible, as their product is
something I want to evaluate this year.
Thanks in advance,
Kathleen Conway
Manager, Employee Benefits, Programs and HRMS
Manugistics, Inc.
2115 E. Jefferson St.
Rockville, MD 2082
Subject: RE: [orahrms-l] HR: Noetix and Business Objects
From: Brenda Finley bfinley@standard.com
Date: Tue, 30 Mar 1999 07:49:39 -0800
We use Noetix here with HR (10.7 16.1SC) and Discoverer 3.0. I've had mixed
feelings about it. It does provide a number of basic views on the
information and it provided me with a lot of information on the
relationships between the tables so that we could create many of our own
views. However, I still had to create quite a few custom views since the
Noetix views were still too normalized for what our users needed. For
example, we needed to see Job and Position DFF's with the employee
information, but Noetix didn't provide any of this. It put the job and
position DFF's with the jobs and positions, respectively. Also, the
benefits views are a bit sparse.
In a nutshell, I'm glad we bought Noetix - but I've used the views more as
learning tools than to actually query the data. The technical documentation
is good (much better than Oracle's documentation!) and the customer support
is good. Just be sure you don't customize any of the views (copy them
instead) and if you're using the views with Discoverer, don't change any of
the business areas (including adding joins between Noetix views), because
when you upgrade Noetix, all of this will be lost.
When we bought Noetix, we didn't have as good a handle on the reporting
needs of our HR users as we should have, which was a mistake. It's hard to
test the usefulness of a product when you don't know what your users need!
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] HR: Noetix and Business Objects
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Tue, 30 Mar 1999 14:52:26 -0500
We have used Noetix for both Financials and HR. Good product but needs a
some training to make the most of it. Also, helps to have standard queries
setup for users which they can tweek and do what-if analysis. Our front-end
has been MS-Access as well as Crystal Reports - both work quite well.
NOTE: Noetix for HR is strictly HR type information; no Payroll balances,
etc.
Regards,
Tony x8452
http://www.mcsgroups.com
Integration of Payroll with GL
From: Bijus@mashreqbank.com
Date: Wed, 5 May 1999 13:51:47 +0400
Hi
Can somebody give me some insight on Payroll-GL integration?
Thanks & Regards,
Biju Sebastian
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Wed, 5 May 1999 08:08:14 -0400
Here are the basics:
The cost allocation flexfield is used to cost your payroll transactions (you
can cost at various different level, including element, job, element link,
payroll, etc.) You map the cost allocation flexfield to your accounting
flexfield within the payroll application. You can set up cross-validation
rules on your cost allocation flexfield, but unfortunately, there is not
standard report that will output the results of the violation of these rules
prior to transferring the transactions to the GL. If you don't create some
type of custom report, you don't get your violations until you attempt a GL
import (this is assuming you are using cross-validation rules on your
accounting flexfield). You then need to rollback the payroll(s) causing the
problem(s), fix the costing, and rerun the payroll. Errors in your costing
process w/in the payroll application itself will "post" transactions to the
suspense account that you define for each thing that you cost).
HR and Projects integration - Query 2
Subject: [orahrms-l] Projects & HR Integration
From: "Deb Burgess" dburgess@burcon-group.com
Date: Sat, 24 Jul 1999 09:22:35 -0700
I have a client who is implementing 11.02 with the full suite of financials,
manufacturing, HR, Projects. The HR/Projects integration is killing us
(mostly from the Projects side).
The current issue involving HR is the employee cost rate which is
an Oracle design problem (according to Oracle). Projects creates its own
tables for Compensation rules (Exempt/Non Exempt) and requires an hourly
rate for each employee. It apparently does not read the tables in HR for
compensation rules and hourly or salary rates. A TAR has been opened and
Oracle Support is looking for a SQL statement to load the data from HR to
projects.
This cannot possibly be a new issue. To maintain cost rates in both HR and
projects would be a nightmare. This client only has 700+ employees. What
do you do if you have thousands? Has anyone created a work around for this?
Is there a piece of functionality we are missing (e.g., setups?). Is one
work around standard cost rates rather than variable by employee???
We are scheduled to go into solution design the first week in August. Right
now, we are missing a big piece of the solution. Any help would be greatly
appreciated.
Have a Great Day!
Deb Burgess, The Burcon Group
"Putting The Pieces Together"
562/420-6288 (Office)
562/420-6288 (Fax)
310/898-8520 (VM/Pager)
310/488-7608 (Mobile)
Subject: RE: [orahrms-l] Projects & HR Integration
From: "Schilling, Mark" MSchilli@ciena.com
Date: Sat, 24 Jul 1999 13:57:08 -0400
In 10.7 SC we wrote the logic into the PA Labor Costing Client Extension.
Projects still needs a standard hourly rate per employee, so when the DISTRIBUTE LABOR COSTS program is run (concurrent request) it calls the Labor Costing Client Extension.
The extension we wrote passes HOURLY salary basis as amount, decodes for ANNUAL / 2080,
DAILY /8 etc. It depends on how many salary basis you set-up in HR.
This is not new, I figure almost all of the HR/PA installed users I talked to at OAUG have had to do this. I don't know why Oracle won't build the trigger to
1) calculate labor cost when the expenditure is saved and
2) set a profile option to calculate project labor cost from HR compensation rates using the '2080' work hours in a year.
The Oracle Consultants I have spoken to about this consistently maintain that
a) most of their clients DO NOT figure on 2080 hours per year or want to include bonus / stock plans in the compensation and
b)that they don't want to lose the functionality of using HIGHER rates in PA as a way of loading the rates with standard overheads, etc ( I guess kind of a pre-burden burden)
I my experience, a) is not the case and b) pushes inaccurate Direct Labor numbers to the GL.
I'll see what client extension code I could share with you.
Mark Schilling
CIENA Corp.
Linthicum Maryland
410.694.5768
Oracle Payroll Interface Kit
Subject: [orahrms-l] Oracle Payroll Interface Kit
From: "M Hurley" jmhurley@hotmail.com
Date: Wed, 28 Jul 1999 21:45:14 EDT
I was wondering if anyone has implemented Oracle 11 over the past 3 - 5
months and has interfaced to a 3rd Party Payroll using the Oracle Payroll
Interface Kit that will become standard in Release 11i BUT from what I
understand has been ported back to R11.
Even if you have not implemented but have heard of this functionality I
would appreciate your comments/insight.
Marc Hurley