Elements for data feed to vendors
Subject: [orahrms-l] Vendor Interfaces (401(k), W2's, various medical enrollments)
From: "Dan Kelly" dkelly@estee.com
Date: Tue, 20 Apr 1999 11:15:57 -0400
We need to produce data feeds to various vendors from our new Oracle
HR/Payroll system. We would appreciate any help as to where we may find
this data as the technical reference manual is somewhat cryptic. We are
under a tight deadline. Please contact me (516.425.8311), or post messages
to this server. Thank you very, very much in advance!
These are some of the interfaces which we need to produce:
Fidelity for 401(k) contributions (captured in an SIT)
Sykes (Prudential) for Flexible Spending Account (FSA)
Ceridian for taxes
medical vendors
employee stock purchase (handled via an SIT)
stock options (SIT)
Good day,
Dan Kelly (dkelly@estee.com) 516.425.8311 Estee Lauder Companies, Melville,
New York
Subject: Re: [orahrms-l] Vendor Interfaces (401(k), W2's, various medical enrollments)
From: Lewis R Cunningham lcunning@lmumail.lmu.edu
Date: Tue, 20 Apr 1999 09:58:10 -0700
All of these items should really be elements, not SITs. If defined as
elements, you can create a generic package for exporting the data. The
tables you need to look at are pay_element_types_f, pay_element_entries_f,
and pay_element_entry_values_f.
There are standard element classifications for 401k, medical, stock
purchase. Medical vendors would be defined as a carrier external
organization and the linked on one of the elements further information fields.
Lewis
Secure User feature giving errors
Subject: [orahrms-l] Secure User
From: "Winn, George H." gwinn@Mail.Donaldson.com
Date: Tue, 25 May 1999 07:59:18 -0500
We are attempting to use the Secure User feature to allow our remote plants
to access their employees only in order to perform new hire, and employee
maintenance functions.
We have established secure user id's and our plant HR representatives are
able to access only their employees. However, when we attempt to execute
certain functions we run into the following errors:
New Hire:
1) On the assignment form, after entering the organization, job etc., after
entering the location we receive the following error message: "FRM 40735
WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06550"
This error does not occur if I use the location of our corporate
headquarters in Minnesota, with the organization of the remote out of state
manufacturing plant.
2) On the salary form, we get the same message after entering the date in
the change date field in the Salary Proposal region.
Salary History:
After selecting the "Salary History" button we get the following error
message: "FRM-40735: POST-QUERY trigger raised unhandled exception
ORA-06550"
Grade Comparatio:
After selecting the "Find" button we get the following error message:
"FRM-40735: POST-QUERY trigger raised unhandled exception ORA-06550"
We have executed the 107sec.drv in the per_top directory, and subsequently
ran ROLEGEN, SECGEN and LISTGEN.
We are using 10.7SC.
Anyone have any thoughts?
George Winn
Donaldson Company, Inc
email: gwinn@mail.donaldson.com
voice: 612.887.3833
fax: 612.887.3148
Subject: Re: [orahrms-l] Secure User
From: Mike Peterson peterson@kbace.com
Date: Tue, 25 May 1999 09:24:49 -0400
George,
Have you applied the following patch from Oracle ftp site:
ftp://209.246.5.40/apps/patchsets/HR_PAYROLL/SECURE_USER/
It must be run for each oracle id you created. Make sure you review the readme
file.
-Mike Peterson
Subject: Re: [orahrms-l] Secure User
From: jurodriguez@answerthink.com (Juan Rodriguez)
Date: Tue, 25 May 1999 10:28:55 -0400
George,
Generally these unhandled exceptions errors(when working with secure
users) are due to your secure users not having priviliges to certain
objects in the database. Please make sure that your DBA gives your secure
user access priviliges to all objects that the apps user(or any other app
user if you have multiple installs) especially all the synonyms. You
should be OK afterwards. Let me know if it works.
Cheers!
Juan Rodriguez
jurodriguez@answerthink.com
US_ETHNIC_GROUP vs. ETH_TYPE
Subject: [orahrms-l] US_ETHNIC_GROUP vs. ETH_TYPE
From: "Kevin Jarrett" kejarr@copelco.com
Date: Mon, 7 Jun 1999 06:50:44 -0400
Hi everyone,
Trying to understand the difference between these two quickcode items.
US_ETHNIC_GROUP - 7 pre-determined (install-created) values, system access
level (not changeable)
ETH_TYPE - no values, extensible access level
My questions:
1) Which one should we be using? (the first one is currently active)
2) Can we change from one to the other after having gone into production?
(ewwwww...)
Thanks!
-kj-
Subject: RE: [orahrms-l] US_ETHNIC_GROUP vs. ETH_TYPE
From: "Venkatesh, Masoor" mVenkate@wssc.dst.md.us
Date: Mon, 7 Jun 1999 08:51:51 -0400
Kevin:
You want to use the US_ETHNIC_GROUP quickcodes. This is an upgrade in Prod
16.1. Your production system should use this quickcode - and the base
migration is transparent. Any custom forms, reports that were reading the
ETH_TYPE quickcode will have to be modified to read US_ETHNIC_GROUP
quickcode.
Regards,
Tony Venkatesh
(301) 206-8452
(703) 793-0847
tonyv@mcsgroups.com
Initial Balance Structure Creation
Subject: [orahrms-l] "INITIAL Balance Structure Creation" process : URGENT !!
From: "Gul, Metin" MGul@sigeco.com
Date: Tue, 15 Jun 1999 12:25:06 -0500
I am running the process 'initial balance structure creation' process for a
batch for my balance conversion. Then I am trying to run a separate batch
with only 6 different balances to run this step. And I keep getting same
error message : "NAME ALREADY EXISTS, APPS.HR_UT "
I don't see any reason why I should get this error message, I have tested
those balances with the right dimensions before in other instances and I am
trying to run this process for these lines for the first time and still get
this message. When I go and check the balance names there are no initial
feeds created.
Has anybody experienced this problem before ?
any help appreciated, as usual Oracle can't seem to find anything.
Metin
Setting Date Tracking for YTD balances
Subject: [orahrms-l] Date Tracking
From: "Schmit, Mark" mschmit@Mail.Donaldson.com
Date: Wed, 16 Jun 1999 10:13:45 -0500
When I'm using the pay_balance.get_values package to get a YTD balance, I
will usually run the program a few days after the fiscal YTD period ends.
How do I set the date tracking so that the get_values procedure knows to get
a YTD balance from the previous fiscal year?
Mark Schmit
Donaldson Inc.
(612) 703-4606
Subject: Re: [orahrms-l] Date Tracking
From: Thaddeus Inekuku tinekuku@hotmail.com
Date: Wed, 16 Jun 1999 19:53:05 PDT
Mark,
The pay_balance_pkg.get_value package function is an overloaded routine.
You can use it with either of the following sets of parameters
1. Assignment_id, effective_date, defined_balance_id
2. Assignment_action_id, defined_balance_id
To get YTD values for the previous year, use the former with the the
effective_date as the last day of the year for your specific year.
Thaddeus Inekuku
Answerthink Consulting Group
Setup for Costing State and Local Taxes
Subject: [orahrms-l] Costing State and Local Taxes
From: "Julie Hertzler" Hertzler.Julie@summitgroup.com
Date: Wed, 16 Jun 1999 14:54:27 -0500
We have a need to cost State and Local taxes to separate accounts on the general ledger for each state and locality. I followed the instructions in the Payroll User Guide for setting up segments in the Cost Allocation flexfield for State Code, County Code, City Code, and School District Code. Unfortunately, the documentation stops there. It sounds like the amounts for state and local tax are collected by jurisdiction code, but I am not sure what to do next in order to match the jurisdiction codes to the correct GL account. Does anyone have experience with costing state and local taxes?
Julie Hertzler
Summit Group
email: hertzler.julie@summitgroup.com
Subject: Re: [orahrms-l] Costing State and Local Taxes
From: Manny Wohiren Manny.Wohiren@yale.edu
Date: Wed, 16 Jun 1999 16:22:22 -0400
U can cost state and local taxes at the element link screen. Query the element in question and assign the costing info for both Dr and Cr.
Regard
Manny.Wohiren@yale.edu
Subject: RE: [orahrms-l] Costing State and Local Taxes
From: Pat Keeley PKeeley@amctheatres.com
Date: Wed, 16 Jun 1999 15:30:36 -0500
Julie, this is where the fun starts!
You need to develop a table that maps the one account you use in payroll
plus the State, County, City, and SD codes to the GL account.
The SQL guru then writes a routine that takes the file generated when
payroll runs the "Transfer to GL" process, runs it through this conversion
table, replaces the original file with the newly converted file. Voila! You
have the correct GL account numbers. My guru, then made this a "set" so
that the conversion process would not be overlooked.
Hope this helps.
Pat Keeley
ARIS Corporation
Draw and Commission Elements
Subject: [orahrms-l] Draw and Commission Elements
From: pkandra@civicdevelopment.com
Date: Fri, 18 Jun 1999 08:05:07 -0400
We have several employees receiving an earnings element called Draw as an
advance on commission. Our payroll staff is looking for a way to
automatically deduct this amount when the employee does receives commission.
Any ideas or suggestion are welcome.
Thanks,
Peter Kandra
Civic Development Group
(888) 800-7637 x2518
Subject: RE: [orahrms-l] Draw and Commission Elements
From: "Govindarajan, Ravi" RGovinda@USChamber.com
Date: Fri, 18 Jun 1999 09:07:18 -0400
Title: RE: [orahrms-l] Draw and Commission Elements
I had a similar scenario. In our case the commission data comes from an external system (Sales Comp). Every time they (SC) calculate the commission they query into Payroll tables for the "Draw" amount paid to employees. If any $ is paid it will be deducted from the commission and pass it to the CN_PAYMENTS_API (Oracle SC/Payroll interface table). Payroll takes it from there and using Paymix the data moves to the specific Payroll period. This way we avoided any deduction process in Payroll. As an alternative to this we also looked into creating a deduction element which can be linked to employees. Using Fast Formula for Commission element the "Draw" can be deducted during the payroll run. This way you can keep tack of the $ amount deducted with in Payroll. You can look into both ways. Good luck.
By the way our Sales Comp is custom built.
Ravi G.
Cap Gemini
ragovind@usa.capgemini.com
Subject: RE: [orahrms-l] Draw and Commission Elements
From: Bijus@mashreqbank.com
Date: Fri, 18 Jun 1999 19:36:35 +0400
Cc: pkandra@civicdevelopment.com
Define the following elements
1. Advance on commission ( the one you mentioned) Earning/Direct/Multiple
entry allowed (it depends on the policy of you company)
Keep an ITD balance against this element (ADD)
2. Commission Earning/Direct/Multiple entry allowed - this will record the
actual commission. Kick off another element called
Deduction on Commission due to Advance (Indirect), which will go and check
the above mentioned balance and make deduction against commission.
Hope it's clear to you.
Regards
Biju Sebastian
Increase length of Location Name Field
Subject: [orahrms-l] Location Name
From: "Barnett, Janet L." jlbarnet@mountaineergas.com
Date: Wed, 23 Jun 1999 08:41:04 -0400
When setting up locations, is there a way to increase the length of the
location name field?
If so, how? Be detailed, please.
Thanks.
Janet Barnett
Mountaineer Gas Company
Subject: RE: [orahrms-l] Location Name
From: Pat Keeley PKeeley@amctheatres.com
Date: Wed, 23 Jun 1999 08:17:43 -0500
Janet,
I've not seen any way to increase the length of the name and I would be
concerned about the domino affect, if you found a way. Silly question, but
why would you want to increase the size of this field? It isn't used for
anything except an identifier, it won't print on your checks or other
standard reports.
Pat Keeley
Subject: RE: [orahrms-l] Location Name
From: Terry Hodge tahodge@hotmail.com
Date: Wed, 23 Jun 1999 14:47:48 GMT
Janet,
Oracle would not support any changes to any lengths of fields that you may
change. With as many patchsets that we have to maintain if you do increase
the name , it may break other specific items within Oracle.
Terry
Change rate for Vacation Pay Element
Subject: [orahrms-l] Vacation Rate Override
From: "Julie Hertzler" Hertzler.Julie@summitgroup.com
Date: Tue, 6 Jul 1999 13:38:14 -0500
I have a question about changing the Rate for the Vacation Pay element.
We have a need to change an employee's pay Rate when we pay for Vacation time. We are able to change the Rate on the Vacation Hours (Information) element when we enter time through PayMIX. However, the seeded Vacation Pay element formula does not look at override rates that may have been entered in PayMIX.
We tried setting up a new Vacation Pay element to pay for vacation time, and an information element for Vacation Hours, but we haven't been able to figure out how to change the formula for the new Vacation Pay element to look at the information element for the Vacation Hours and the override rate. We still need to use the Vacation Hours element because we are using a Vacation PTO accrual plan.
Does anyone have any suggestions on how we can change the vacation rate without having multiple entry with the new Vacation Pay element for the hours and new rate, and the Vacation Hours Information element for the hours on the PTO accrual plan?
Thanks for your suggestions.
Julie Hertzler
Summit Group
email: hertzler.julie@summitgroup.com
Adding a new Business Group and linking it to Organizations
Subject: [orahrms-l] New Business Group
From: "Barnett, Janet L." jlbarnet@mountaineergas.com
Date: Tue, 13 Jul 1999 11:04:27 -0400
We have setup our own Business Group. After doing that, we continued to
define our other organizations. Next, I changed the system profiles,
under HR:Security Profile to
the new name of the organization. When I go back to review the
organziations, the only ones I can see are the new business group and
the old setup business group.
I realize now, I probably should have set up the new business group,
then changed the system profiles, then added the other work structures.
Is there anyway around this?
Please help!
Janet Barnett
Mountaineer Gas Company
Subject: RE: [orahrms-l] New Business Group
From: "Frost, Scott" sfrost@noblestar.com
Date: Tue, 13 Jul 1999 11:44:53 -0400
Hi Janet-
Unfortunately because you created the old organizations using the old
Business Group in your profile, those organizations now have the original
Business Group identifier attached to their records. You can examine
HR_ORGANIZATION_UNITS to see this effect via SQL. (use the TRM)
Basically, this means you now have to re-setup your old organizations using
the new business group in your profile. I have run into clients before that
will forget that step and go ahead and setup dozens of employees....as soon
as they change that business group profile, they cannot see their employees
anymore.
I would say if it is possible to restore a fresh copy of your database and
start over from scratch. You can try deleting the records, but it really
depends on how you want to proceed. If you are in a test instance, then it
won't matter much. Perhaps it is a chance to test your back and recovery
strategy as well! This way, you can ensure you have nothing but clean data,
and other implementors will not get confused themselves. If it is early
enough, then it is a learning experience. Otherwise, you just have to
re-setup your organizations.
Hope this helps! Feel free to ask further questions.
Good luck!
Scott
Scott L. Frost
HRMS Consultant
Noble(star Systems Corporation
703.464.4000 x2549
http://www.noblestar.com
Secure user - Payroll access problem
Subject: [orahrms-l] Secure Users Problem?
From: Ellen Young EYoung@FAMILYDOLLAR.com
Date: Wed, 14 Jul 1999 09:59:40 -0400
We recently updated the PAYWSACT form (Payroll Processes from the front-end)
to version 4.0.38. When we try to access payroll data from this form using
the seeded responsibilities (e.g., US HRMS Manager), it works fine. However,
when we attempt to use a customized responsibility, we get the error Form
40505 - ORACLE error, unable to perform query. We know that this is a
security issue and have been working with WWS to attempt to fix it, but have
been unsuccessful. This are the actions that we have taken:
Checked LISTGEN - it is running successfully daily for all secure users.
Attempted to run ROLLGEN as US HRMS Manager - Got errors on Revokes.
Tried the following per Oracle Support:
Logged on as APPS
grant select on pay_payroll_actions_v6 to paymanager;
grant select on pay_us_gtn_tax_units_v to paymanager;
Executed View Payroll and Assignement process form and received same error
on same table.
Any suggestions?
Ellen Young
Oracle Apps Project Manager
Family Dollar Stores, Inc.
eyoung@familydollar.com
Subject: Re: [orahrms-l] Secure Users Problem?
From: Lewis R Cunningham lcunning@lmumail.lmu.edu
Date: Wed, 14 Jul 1999 09:29:59 -0700
You can choose Display Database Error from the help menu to see exactly why
it can't query.
I'm assuming the views Oracle told you to try are new for that patch so,
try this:
log in to sql*plus as apps
grant all on pay_payroll_actions_v6 to hr_secure_user;
grant all on pay_us_gtn_tax_units_v to hr_secure_user;
The next 2 steps might not be necessary but don't hurt so I do them anyway.
run Generate Secure User from processes and reports using your secure user
name.
Run Security List Mainteneance from processes and reports.
Try to access it again.
Lewis
Paying and reporting for Non-resident aliens
Subject: [orahrms-l] Paying and reporting for non-resident aliens
From: "Lyng, Janice E" jlyng@kpmg.com
Date: Mon, 19 Jul 1999 18:53:36 -0400
Hello Group.
I am currently working at a client site where they have a large population
of non-resident alien individuals. During the setup of the Oracle HRMS
Payroll module (Release 11.0.2), the system configuration needs to address
the business requirement of tracking the amounts paid to non-resident aliens
separate from the amounts paid to resident aliens to meet year-end tax
reporting requirements.
Generally, non-resident aliens receive a Form 1042-S and resident aliens
receive a Form W-2.
What I believe I must do is setup an element for each non-resident
reportable income code and tie each to a salary basis. If I allow these
individuals to be paid with the pre-defined element of regular wages or
regular salary, I believe the amounts will feed a balance which will appear
on a Form W-2 instead of the required Form 1042-S. This is not what I want.
Has anyone tackled this issue??? And are there other solutions that you
have tested and documented the success?
Any thoughts and suggestions would be greatly appreciated!!
Janice Lyng
Consultant
KPMG LLP
Phone - 518-434-7246
Security profiles not working
Subject: [orahrms-l] HRMS security
From: "Barnett, Janet L." jlbarnet@mountaineergas.com
Date: Tue, 10 Aug 1999 16:20:32 -0400
I have am trying to limit the employees a person may view by using
security profiles and responsibilities.
I have:
1. created a responsibility
2. created a security profile and tied it to an organization in an
organization hierarchy
3. changed system profile for the new responsibility for security
profile to look at the new security profile.
4. run listgen
The new responsibility sees the employees, but so does all the other
responsibilities even though they also have security
profiles pointing to other organizations.
What am I missing?
Janet Barnett
Mountaineer Gas Company
Subject: [orahrms-l] Re: HRMS security
From: "George Richardson" RICGE01@fallon-clinic.com
Date: Wed, 11 Aug 1999 09:00:19 -0400
Be sure in the security profile that you have unchecked the boxes to view all organizations.
George Richardson
Database Administrator
x54492