<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content

Green

color

Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color

Related Items

This website has now moved to http://apps2fusion.com





Payroll Elements and Element Links | Print |  E-mail
Written by Anil Passi   
Wednesday, 06 December 2006
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
Image


Define a Bonus element, of type Earning.

Image
Scroll the input value window to see the below fields where input value validations can be entered.
Image


Create an element link as below.
Image



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.

Comments (43)add
...
written by mukesh , December 06, 2006
Hi Anil,
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

Thanks,
Mukesh
...
written by mukesh , December 06, 2006
Hi Anil,
When we create an employee or attach payroll to employee,is there any defalut elements attached to employee?

Thanks,
Mukesh
...
written by Avais , December 06, 2006
Dear Anil,

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 ?.
...
written by Anil Passi , December 06, 2006
Hi Mukesh,

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

Thanks
Anil Passi
...
written by Anil Passi , December 06, 2006
Hi Avais

If you do not have customizations in AK Developer[specially iProc], then upgrade to 11.5.10 should be straightforward.

Surely you do need to do proper UAT and check if any workflow/customizations have been broken.

Metalink 259484.1 is a good starting point
...
written by mukesh , December 06, 2006
Hi Anil,
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

Thanks,
Mukesh
...
written by mukesh , December 06, 2006
Hi Anil,
When we create an employee or attach payroll to employee,is there any defalut elements attached to employee?

Thanks,
Mukesh
...
written by Avais , December 06, 2006
Dear Anil,

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 ?.
...
written by Anil Passi , December 06, 2006
Hi Mukesh,

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

Thanks
Anil Passi
...
written by Anil Passi , December 06, 2006
Hi Avais

If you do not have customizations in AK Developer[specially iProc], then upgrade to 11.5.10 should be straightforward.

Surely you do need to do proper UAT and check if any workflow/customizations have been broken.

Metalink 259484.1 is a good starting point
...
written by Latha , December 07, 2006
Hi Anil,

The articles are very helpful. Thanks very much for sharing the knowledge.

Can you please write about Year End Process/P35 as well.

Thanks
Latha
...
written by Latha , December 07, 2006
Hi Anil,

The articles are very helpful. Thanks very much for sharing the knowledge.

Can you please write about Year End Process/P35 as well.

Thanks
Latha
...
written by raajaa , December 08, 2006
Hi Anil,
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
...
written by Anil Passi , December 08, 2006
Hi Mukesh,Latha,Raja

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
...
written by raajaa , December 08, 2006
Hi Anil,
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
...
written by Anil Passi , December 08, 2006
Hi Mukesh,Latha,Raja

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
...
written by balkrishna , December 11, 2006
hi anil really good information center about apps at intial level.
i am working on payroll interface and API related with element entry name is hr_api_update.element_entry
where 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
...
written by balkrishna , December 11, 2006
hi anil really good information center about apps at intial level.
i am working on payroll interface and API related with element entry name is hr_api_update.element_entry
where 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
...
written by balkrishna , December 11, 2006
hi anil really good information center about apps at intial level.
i am working on payroll interface and API related with element entry name is hr_api_update.element_entry
where 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
...
written by balkrishna , December 11, 2006
hi anil really good information center about apps at intial level.
i am working on payroll interface and API related with element entry name is hr_api_update.element_entry
where 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
...
written by Gayathri , December 13, 2006
Hi Anil

Though I do not know abc of Oracle HRMS and payroll, guess your articles will make me a master :-) one fine day

Regards
Gayathri
...
written by Anil Passi , December 13, 2006
Hi Gayathri,

HRMS & 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,
Anil Passi
...
written by Gayathri , December 13, 2006
Hi Anil

Though I do not know abc of Oracle HRMS and payroll, guess your articles will make me a master :-) one fine day

Regards
Gayathri
...
written by Anil Passi , December 13, 2006
Hi Gayathri,

HRMS & 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,
Anil Passi
...
written by Priya , January 11, 2007
This information is tooooooooooo good.
Than Q so much for helping people like me
...
written by Priya , January 11, 2007
This information is tooooooooooo good.
Than Q so much for helping people like me
...
written by Anil Passi , January 12, 2007
You are mooooooooost welcome.
...
written by Anil Passi , January 12, 2007
You are mooooooooost welcome.
...
written by Prasad Raju , February 23, 2007
This article is very useful for us.Not only this every article is very good and also i like OA Framework and Oracle HRMS training.
...
written by Anil Passi , February 24, 2007
Thanks Prasad for your kind words.

Cheers
Anil
...
written by mohan , July 16, 2007
Hi 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
Katepalli.Mohan
...
written by Sharath Gajula , August 23, 2007
Hi 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_types_f => Element definitions
pay_element_input_values_f => Input values Definition
pay_element_links_f => Element Link definitions
pay_balance_feeds_f => Balance Feeds
pay_element_entries_f => Element entries
pay_element_entry_values_f => Element Entry Values
...
written by Anjani Pilla , August 30, 2007
Hi Anil,

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.
...
written by Harikishan , September 02, 2007
Hi Anil, How an employee attendance is linked to Oracle Payroll. at what stage and in which screen employee attendance is integrated for payroll calculation.

Thanks in Advance
Harikishan
...
written by raja , September 11, 2007
Hi anil, can u say me wat the steps to generate the Payroll for all the employees
...
written by Gupta Nagubandi , October 10, 2007
Hi Anil,

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.

Thanks a lot,
Gupta
Payroll Elements and Element Links
written by MANJUNATH MR , October 13, 2007
hey ANIL,
Seriously very good for beginners..its pretty clear about ur explanation as u pasted some screen shots under each topic..great buddy.
Element
written by kalpana , November 02, 2007
Anil:
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.

Thanks
Kalpana
...
written by Manoj_mukhi , November 13, 2007
Hi Anil

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@rediffmail.com

...
written by prasadraju , November 28, 2007
Hi Anil
Your explanation is so good in every topic.keep updating.so that it will be useful for all.
Mask Salary information
written by Nidhi , December 06, 2007
Hi Anil,
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_payPproposals table it seems there are links to other tables too which resulted in data corruption.
thanks,
Nidhi
...
written by Habeni , December 12, 2007
Hi Anil,
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,CWB,OAB,and OTL.

Thanks in advance


Balances Information
written by Mohit , January 23, 2008
Hi anil ,
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
You must be logged in to a comment. Please register if you do not have an account yet.

busy