Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

HR and Payroll
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive
 

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.


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.
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.


Anil Passi

Comments   

0 #1 mukesh 2006-12-06 00:00
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

Than ks,
Mukesh
Quote
0 #2 mukesh 2006-12-06 00:00
Hi Anil,
When we create an employee or attach payroll to employee,is there any defalut elements attached to employee?

Th anks,
Mukesh
Quote
0 #3 Avais 2006-12-06 00:00
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 ?.
Quote
0 #4 Anil Passi 2006-12-06 00:00
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

Than ks
Anil Passi
Quote
0 #5 Anil Passi 2006-12-06 00:00
Hi Avais

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
Quote
0 #6 mukesh 2006-12-06 00:00
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

Than ks,
Mukesh
Quote
0 #7 mukesh 2006-12-06 00:00
Hi Anil,
When we create an employee or attach payroll to employee,is there any defalut elements attached to employee?

Th anks,
Mukesh
Quote
0 #8 Avais 2006-12-06 00:00
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 ?.
Quote
0 #9 Anil Passi 2006-12-06 00:00
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

Than ks
Anil Passi
Quote
0 #10 Anil Passi 2006-12-06 00:00
Hi Avais

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
Quote
0 #11 Latha 2006-12-07 00:00
Hi Anil,

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
Quote
0 #12 Latha 2006-12-07 00:00
Hi Anil,

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
Quote
0 #13 raajaa 2006-12-08 00:00
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
Quote
0 #14 Anil Passi 2006-12-08 00:00
Hi Mukesh,Latha,Ra ja

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
Quote
0 #15 raajaa 2006-12-08 00:00
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
Quote
0 #16 Anil Passi 2006-12-08 00:00
Hi Mukesh,Latha,Ra ja

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
Quote
0 #17 balkrishna 2006-12-11 00:00
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.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
Quote
0 #18 balkrishna 2006-12-11 00:00
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.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
Quote
0 #19 balkrishna 2006-12-11 00:00
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.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
Quote
0 #20 balkrishna 2006-12-11 00:00
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.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
Quote
0 #21 Gayathri 2006-12-13 00:00
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
Quote
0 #22 Anil Passi 2006-12-13 00:00
Hi 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
Quote
0 #23 Gayathri 2006-12-13 00:00
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
Quote
0 #24 Anil Passi 2006-12-13 00:00
Hi 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
Quote
0 #25 Priya 2007-01-11 00:00
This information is tooooooooooo good.
Than Q so much for helping people like me
Quote
0 #26 Priya 2007-01-11 00:00
This information is tooooooooooo good.
Than Q so much for helping people like me
Quote
0 #27 Anil Passi 2007-01-12 00:00
You are mooooooooost welcome.
Quote
0 #28 Anil Passi 2007-01-12 00:00
You are mooooooooost welcome.
Quote
0 #29 Prasad Raju 2007-02-23 00:00
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.
Quote
0 #30 Anil Passi 2007-02-24 00:00
Thanks Prasad for your kind words.

Cheer s
Anil
Quote
0 #31 mohan 2007-07-16 13:19
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
Katepal li.Mohan
Quote
0 #32 Sharath Gajula 2007-08-23 17:29
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_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
Quote
0 #33 Anjani Pilla 2007-08-30 15:57
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.
Quote
0 #34 Harikishan 2007-09-02 04:41
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
Harikis han
Quote
0 #35 Tomas Boncompte 2007-09-11 06:10
Hi anil, can u say me wat the steps to generate the Payroll for all the employees
Quote
0 #36 Gupta Nagubandi 2007-10-10 05:26
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.

Thank s a lot,
Gupta
Quote
0 #37 MANJUNATH MR 2007-10-13 05:38
hey ANIL,
Seriously very good for beginners..its pretty clear about ur explanation as u pasted some screen shots under each topic..great buddy.
Quote
0 #38 kalpana 2007-11-02 14:34
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.

Thank s
Kalpana
Quote
0 #39 Manoj_mukhi 2007-11-13 08:35
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-
Quote
0 #40 prasadraju 2007-11-28 12:12
Hi Anil
Your explanation is so good in every topic.keep updating.so that it will be useful for all.
Quote
0 #41 Nidhi 2007-12-06 19:29
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_payPproposa ls table it seems there are links to other tables too which resulted in data corruption.
tha nks,
Nidhi
Quote
0 #42 Habeni 2007-12-12 04:05
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,CW B,OAB,and OTL.

Thanks in advance
Quote
0 #43 Mohit 2008-01-23 05:24
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
Quote
0 #44 baltimorecity 2010-07-16 15:34
Thanks in advance fro the help

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
Quote
0 #45 Ali Hassan 2014-02-17 05:00
Hello Anil,
Simply I say good work. Indeed very helpful.

Regar ds.
Ali
Quote
0 #46 Sajid 2014-11-05 10:34
Can you Please explain more. I didn't last like.

"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"
Quote
0 #47 Chinna 2015-04-28 05:56
Thank you Anil. Good Article.
Quote
0 #48 Free Link Exchange 2021-07-29 02:34
Awesome! Its truly remarkable article, I have got much ckear idea
about from this paragraph.
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Aug 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
        1
  2  3  4  5  6  7  8
  9101112131415
16171819202122
23242526272829
3031     

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner