Please find an article on Oracle Payroll that explains Elements and Element Links. I will try to keep this explanation as simple as possible.
Why do we need Oracle Payroll?
We need a Payroll software primarily to calculate net salary for the employees, and also for regulatory & reporting reasons. Oracle Payroll also helps an Organization manage the costing of their Employees.
Why do we need elements and element links in Oracle Payroll?
Let me take an example to explain this. Say a pseudo company named "XX Passi Inc" employs only two type of people:-
1. Manager Grade
2. Clerk Grade
Let’s say this company has a policy that only Manager Grade people must be paid Bonus. How is Oracle Payroll going to work this out?
For simplicity, think of an element being a record that is attached to employee assignment. Alternately, think of Element being a variable that is stored in database table[or rather is an array of variables]. In Oracle Payroll we will define an element named Bonus. This element will be attached to all the people that have grade of “Manager”. Against each manager, an amount will be captured in this element record.
See the screenshots at bottom of article
Right, so bonus amount will be entered against each employee, in their element entry record?
Correct, however our design demands that only Managers can be assigned Bonus element.
How can we restrict eligibility of bonus element just for Managers, so that Clerks do not ever get paid the bonus even accidentally?
In Oracle Payroll we have something called as Element Link. Using Element Link, we make an Element eligible to a person or to a group of people. In this case, we will create an element link for bonus Element :- linking that to grade "Manager".
Given that we do not link bonus element to Clerk grade, it will not be possible to create a bonus element entry for a clerk.
Hmmm, by using element links we can apply a filter who can be assigned an element?
Absolutely, and you have various filtration criteria at your disposal. For example, element link can be created against organization or a payroll(monthly or weekly) etc. Beyond filtration, you can assign default costing information too and also validations against the entered values.
Does this imply that a Manager can not receive bonus, unless an element link exists to make Manager grade eligible for Bonus?
Correct. But please note that usage of grades is just one of the many ways by which a group of people can be made eligible for element. But for simplicity, we stuck to the manager theory in this article.
Lets do the same example with numbers.
Anil Passi -- Manager
John -- Clerk
Suzy -- Manager
Linda -- Clerk
Anil will get a bonus of $100, whereas Suzy will get $50 bonus.
John and Linda will not be eligible for Bonus element, hence can’t be paid bonus.
Element Classification Screen
Define a Bonus element, of type Earning.
Scroll the input value window to see the fields like Default, Lookup & Value Set where input value validations can be entered.
Create an element link as below.
You can now go to person record, and then assignment screen and click on Element/Entry button, to enter Bonus Amount of $100 against Anil
Do we have Elements that can hold the Tax figures?
Indeed, Tax related elements are Classified as Deductions. Coming to classification, we use Classification to group similar Elements together.
Do we create all the Elements from Scratch?
You do at times, but the elements driven by Legislation are delivered pre-installed by Oracle. For example in UK, National Insurance elements come pre-installed.
Can we capture just one value against each Element?
Wrong, you can capture upto 15 values[via Element Entry] per Oracle Payroll Element.
When the payroll engine runs, does Oracle calculate the first calculates the Deductions and then Earnings?
You can assign Priority to Element Classifications. If priority of Earning is say 1 and Priority of say Deduction classification is 2, then Earnings will be calculated first, and then deductions will be applied latter by the Payroll engine.
Apps2Fusion Articles 
Comments
very good article, it has cleared the concept on element.
Can you please explain about:
fast farmula, oracle advance benefits and element classification because these terms are gernally used with element and payroll
Than ks,
Mukesh
When we create an employee or attach payroll to employee,is there any defalut elements attached to employee?
Th anks,
Mukesh
First of all I really appreciate your efforts for serving Oracle community. Anil, I have one wnquiry, We want to migrate our current EBS 11.5.9 to 11.5.10. Can you pls. pls. guid me in that. I mean Can we migate by applying maintenance pack or we have do more ?.
If you have a look at Element Link screen, there is a checkbox named Standard. If this checkbox is checked, then element will be assigned to eligible assignments by default
Than ks
Anil Passi
If you do not have customizations in AK Developer[speci ally iProc], then upgrade to 11.5.10 should be straightforward .
Surely you do need to do proper UAT and check if any workflow/custom izations have been broken.
Meta link 259484.1 is a good starting point
very good article, it has cleared the concept on element.
Can you please explain about:
fast farmula, oracle advance benefits and element classification because these terms are gernally used with element and payroll
Than ks,
Mukesh
When we create an employee or attach payroll to employee,is there any defalut elements attached to employee?
Th anks,
Mukesh
First of all I really appreciate your efforts for serving Oracle community. Anil, I have one wnquiry, We want to migrate our current EBS 11.5.9 to 11.5.10. Can you pls. pls. guid me in that. I mean Can we migate by applying maintenance pack or we have do more ?.
If you have a look at Element Link screen, there is a checkbox named Standard. If this checkbox is checked, then element will be assigned to eligible assignments by default
Than ks
Anil Passi
If you do not have customizations in AK Developer[speci ally iProc], then upgrade to 11.5.10 should be straightforward .
Surely you do need to do proper UAT and check if any workflow/custom izations have been broken.
Meta link 259484.1 is a good starting point
The articles are very helpful. Thanks very much for sharing the knowledge.
C an you please write about Year End Process/P35 as well.
Thanks
Latha
The articles are very helpful. Thanks very much for sharing the knowledge.
C an you please write about Year End Process/P35 as well.
Thanks
Latha
Can you please let us know the steps involved in Payroll processing.From payroll processing to GL...How exactly these steps are involved..can you please brief
I will write on the requested topics, please give me a weeks time, I have been very busy thanks to xmas party and workload
Thanks,
Anil Passi
Can you please let us know the steps involved in Payroll processing.From payroll processing to GL...How exactly these steps are involved..can you please brief
I will write on the requested topics, please give me a weeks time, I have been very busy thanks to xmas party and workload
Thanks,
Anil Passi
i am working on payroll interface and API related with element entry name is hr_api_update.e lement_entry
w here i have find the mapping of the parameter of the api ..if u right some article then please think this topic it will give great healp and give the details related to payroll and hrms
i am working on payroll interface and API related with element entry name is hr_api_update.e lement_entry
w here i have find the mapping of the parameter of the api ..if u right some article then please think this topic it will give great healp and give the details related to payroll and hrms
i am working on payroll interface and API related with element entry name is hr_api_update.e lement_entry
w here i have find the mapping of the parameter of the api ..if u right some article then please think this topic it will give great healp and give the details related to payroll and hrms
i am working on payroll interface and API related with element entry name is hr_api_update.e lement_entry
w here i have find the mapping of the parameter of the api ..if u right some article then please think this topic it will give great healp and give the details related to payroll and hrms
Though I do not know abc of Oracle HRMS and payroll, guess your articles will make me a master
Regards
Gayathri
HR MS & Payroll is one of the easiest modules to work upon, the problem is to get started. Hence I my emphasis on basics.
If there is something that you do not understand in these articles, then let me know. I am more than happy to revisit the article to explain further.
Thanks,
An il Passi
Though I do not know abc of Oracle HRMS and payroll, guess your articles will make me a master
Regards
Gayathri
HR MS & Payroll is one of the easiest modules to work upon, the problem is to get started. Hence I my emphasis on basics.
If there is something that you do not understand in these articles, then let me know. I am more than happy to revisit the article to explain further.
Thanks,
An il Passi
Than Q so much for helping people like me
Than Q so much for helping people like me
Cheer s
Anil
u r articles are highly apreciated.Now i am developing reports on HRMS (PAYROLL).
1)there are 16 elements defined against each employee.
2)I have to calcullate salary of an employee(FOR ANY MONTH OF THE ANY YEAR).
3)how to capture the value against the element and is i have to add the value or subtract how can i know that.
4)how can i know exactly the salary after deductions(What is the salary is organization is paying to that employee).
5)what are the main tables i have to take consideration.
THANKS & REGARDS
Katepal li.Mohan
You need to perform the following steps.
1. When you create Earnings elements provide the classification of those elements as Earnings and when you create deductions elements provide the classification as Pre-Tax Deductions or Voluntary Deductions based on the functional requirements. If you are working for US, you can use Earnings or Deductions templates.
2. You need to create Balance feeds( if not created) to the balance Total Pay. This is the balance that is used to provide the Net Pay of the Employee. All Earnings should add to this balance and all the deductions should subtract. ( Total Compensation > Basic > Elements > Balance Feeds)
3. Create Element entries of those 16 elements for the Employee's assignment. ( Assignment > Entries).
4. Provide some value against each input in the entry values ( Assignment > Entries > Values)
5. Following tables might be useful for you
pay_element_typ es_f => Element definitions
pay_element_inp ut_values_f => Input values Definition
pay_element_lin ks_f => Element Link definitions
pay_balance_fee ds_f => Balance Feeds
pay_element_ent ries_f => Element entries
pay_element_ent ry_values_f => Element Entry Values
your information is very much helpful for me. I would like to request you for a small material which gives me an introduction to Oracle HRMS Payroll.
Thanks in Advance
Harikis han
The information you are providing is really very very helpful.. I just started working on HRMS/Payroll and this information is really helping me in understanding the modules quickly.
Thank s a lot,
Gupta
Seriously very good for beginners..its pretty clear about ur explanation as u pasted some screen shots under each topic..great buddy.
I am trying to create a vision element as a pre-tax decuction. The 'Vision ER' should get automatically generated. Right? This is not happening. I see the sepcial inputs and special features but not the ER elemnt. Please advise as to what I am missing.
Thank s
Kalpana
During net browsing for Date Track concept, i got your explanation as well as i read some more articles. It is excellent explanation. Really you are a unique master.
I salute you by heart.
I need your valuable suggestion regarding my carrer.
since 4 years i am working in Dubai as HR system Admin. I have worked on one HRMS Product (HR_BASE). But i am not familar about HRMS.
Can you give me some tips how to familiar with Oracle HRMS.
If possible for you, pls mail me on my personal email- M_mukhi
Your explanation is so good in every topic.keep updating.so that it will be useful for all.
Nice post.
Please can you tell me how to delete salary information directly from the base tables? Client wants a script to remove all salary information. I have updated the per_payPproposa ls table it seems there are links to other tables too which resulted in data corruption.
tha nks,
Nidhi
I find your site very interesting and knowledgeable and all the topics are so challenging, I would like to know more or give me a guidelines steps of implementation of core HRMS/payroll,CW B,OAB,and OTL.
Thanks in advance
yesterday only i came to know about the site ,this is really amazing bcoz we know bits and pieces of HRMS,payroll but hw to correlate within modules and functionality is what ur posts are helping me out....please take some of ur precious time to help us out in understanding costing concepts
do you know any Utility to copy the existing deduction element in Oracle payroll. i have to create 16 new elements. i want to take eaxisting element attributes and copy to new element
Simply I say good work. Indeed very helpful.
Regar ds.
Ali
"You can now go to person record, and then assignment screen and click on Element/Entry button, to enter Bonus Amount of $100 against Anil"
about from this paragraph.
RSS feed for comments to this post