Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

HRMS Miscellaneous
  • 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

Search Courses

Please find the common setup steps that are required during almost all the Oracle HRMS Implementations. Please note that this is not a BR100 document.
HRMS Key FlexFields
In any HRMS Implementation, you will be required to design your flexfields. Some of the important Key Flexfields are listed below.
Job Flexfield
Usually couple of segments max

Grade Flexfield
Normally used to work out Payscales

Position Flexfield

Cost Allocation Flexfield
This may not be used when using Labour Distribution module.
Different segments are made visible at different levels. For example you will hide the company segment against Element Entry.

People Group Flexfield

Special Information Types


Note on all HRMS KFF :- Usually you will have Dynamic insertion set to True for these flexfields.


HRMS Descriptive FlexFields
I am listing some common DFF’s configured in Oracle HRMS.
Additional Personal Details
Avoid using this, as you should leverage the Special Information Types. Use this DFF only when you want the details to be made visible from the Main Employee screen.

Additional Assignment Details
Avoid using this, as you can use EIT’s against the Assignment. However, you can use this DFF when you want the details to be made visible from the Main Assignment screen itself.

Additional Element Type Details
Use this DFF during Implementation, to cross reference the Element Codes [or their equivalent codes] from the legacy system. This will help you during Payroll migration.


Add'l Period of Service Det's
Use this DFF when you wish to capture information against an employee when they are Terminated. For example “Legal Sue Flag” oouch…to capture if this guy sued your company, or to capture redundancy terms etc, or to capture negotiated notice period…blaah


Additional Grade Details
You may have mapping grade codes in Legacy system tied into this DFF [because legacy system may not have had a Flexfield kind of design]


Define Value sets and Lookup Codes to Support the KFF & DFF’s & Std Process
Some examples for Lookup Codes that you will define are:-
Employment category
Absence Reason



Define Person Types
You will do this almost in every implementation when doing Oracle HRMS setup. For example in Public sector Universities, a student can become a tutor and hence be called Bursary. Every business has its own terminology when it comes to defining person types.


Common Notifications
Confirmation notification to an employee when their grade or salary details change
Notifications related to Stock / Share Options allocation etc


Define Company Locations
Define all the physical locations/addresses where employees can be working. This gets attached to the assignment record of the person.


Define your business group
For example “Go4gold Asset Management”
This is defined in the Organization screen itself,
You can define various defaults like Employee Number/Applicant Number Generation being Manual or Automatic. Also, here you will attach the structure of all the Key Flexfields which you define in Step 1 of this document. Also the default Payroll currency gets attached to the Business group.



Define your Organizations
You will always implement Organization Hierarchy in Oracle HRMS. Organizations are usually related to the Cost Centre.


Define Organisation Hierarchies
Relate the Organizations that you defined in previous step.


Define jobs
We defined the Job Flexfield in the beginning. Here we assign values to jobs.



Define grades
We defined the Grades Flexfield in the beginning. Here we assign values to grade


Define the responsibilities and Security Profiles [Also link the two]
You will not only be defining responsibilities, but you will also be securing the list of Employees that can be visible from those responsibilities. For this security, you define something known as Security Profile
To give you an example of that, lets say that you want a Departmental head to be able to see list of Employees that work within his Organization/sub-Organization. To achieve this you will define a security profile and will attach the Organization hierarchy to this security profile[starting from his Organization node in hierarchy]
Security profiles can also filter employees on Grade etc. For example, for a responsibility named “HRMS CEO”, you only wish to display employees that are Manager grades. Security profiles can also be created by attaching a filtering SQL to them.
Effectively, following items can help you build a security profile:-
Organisations / Organization Hierarchy
Positions
Payroll ( e.g. to restrict the viewable list of Employees by Monthly payroll)
argh ! this reminds me that we haven’t defined Payroll as yet.


Define Payroll
You will specify the periodic cycles of Payroll, i.e. Monthly, Weekly etc.
Not only that, some statutory information like Employers Tax Reference etc will be captured against the Payroll definition.
Optionally specify the suspense account, default costing account against the Payroll Definition.


Define Elements
This setup will be driven by your Payroll Requirement


Define Balances and Fast Formulas
Balances capture the running totals of Elements, for example Leave remaining Balance will be defined as “Total permission Holidays” MINUS “Element Entry value for Days Off Taken” MINUS “Element Entry values for Comp Off”. Effectively, you will attach Elements to a Balance. A balance will have dimensions like Yearly, Monthly etc. For example, Annual Leave balance will have YTD dimension.



Anil Passi

Comments   

0 #1 Anil Passi 2006-12-01 00:00
Yes you are correct, a default assignment against the Business Group Organization gets created. A default period of service record gets created too[when you create an employee]
Quote
0 #2 Mukesh 2006-12-01 00:00
Hi Anil,

When we create an employee,which all tables gets popolated.As per my understanding
per_all-peopl e_f
and
per_all_assig nment_f
is per_period_of_s ervice
table poplated at the time of creation of employee i know once its get poplated when we terminate an employee but for creation of employee I am not sure.

Please let me know.

Thanks for your such efforts.

Tha nks,
Mukesh
Quote
0 #3 Anil Passi 2006-12-01 00:00
Yes you are correct, a default assignment against the Business Group Organization gets created. A default period of service record gets created too[when you create an employee]
Quote
0 #4 Mukesh 2006-12-01 00:00
Hi Anil,

When we create an employee,which all tables gets popolated.As per my understanding
per_all-peopl e_f
and
per_all_assig nment_f
is per_period_of_s ervice
table poplated at the time of creation of employee i know once its get poplated when we terminate an employee but for creation of employee I am not sure.

Please let me know.

Thanks for your such efforts.

Tha nks,
Mukesh
Quote
0 #5 Ram 2006-12-02 00:00
hi anil,
can u put some important tables on HRMS
Quote
0 #6 Ram 2006-12-02 00:00
hi anil,
can u put some important tables on HRMS
Quote
0 #7 mukesh 2006-12-04 00:00
Hi Anil
Thanks for your comment.
As Ram has asked important tables for HRMS ,
I would say following tables are major HRMS tables :

PER_ALL_PEO PLE_F
PER_ALL_ ASSIGNMENT_F
P ER_PERIOD_OF_SE RVICE
PER_JOBS
PER_GRADES
P ER_ALL_POSITION
HR_ALL_ORGANI ZATION_UNITS
H R_OPERATING_UNI TS
PAY_ELEMENT _ENTRIES_F
PAY _PAYROLL_ACTION S
PER_PERSON_A NALYSES
PER_AN ALYSIS_CRITERIA
PER_ABSENCE_A TTENDANCES
PER _ABS_ATTENDANCE _REASONS
HR_LO OKUPS

For more tables in HRMS one should refer pertrm.pdf on metalink.

Re gards,
Mukesh
Quote
0 #8 Anil Passi 2006-12-04 00:00
Thanks Mukesh, for helping me out with this query.
Quote
0 #9 mukesh 2006-12-04 00:00
Hi Anil
Thanks for your comment.
As Ram has asked important tables for HRMS ,
I would say following tables are major HRMS tables :

PER_ALL_PEO PLE_F
PER_ALL_ ASSIGNMENT_F
P ER_PERIOD_OF_SE RVICE
PER_JOBS
PER_GRADES
P ER_ALL_POSITION
HR_ALL_ORGANI ZATION_UNITS
H R_OPERATING_UNI TS
PAY_ELEMENT _ENTRIES_F
PAY _PAYROLL_ACTION S
PER_PERSON_A NALYSES
PER_AN ALYSIS_CRITERIA
PER_ABSENCE_A TTENDANCES
PER _ABS_ATTENDANCE _REASONS
HR_LO OKUPS

For more tables in HRMS one should refer pertrm.pdf on metalink.

Re gards,
Mukesh
Quote
0 #10 Anil Passi 2006-12-04 00:00
Thanks Mukesh, for helping me out with this query.
Quote
0 #11 Jay 2006-12-16 00:00
Dear Anil,
What is mandatory field of assignment ?


Regards,
Jay
Quote
0 #12 Jay 2006-12-16 00:00
Dear Anil,
What is mandatory field of assignment ?


Regards,
Jay
Quote
0 #13 Anil Passi 2006-12-17 00:00
HiJay

When you create a persion record, say by using an API, you will notice that a default assignment gets created. The default organization allocated to the assignment is Business Group itself. Another mandatory field is primary_flag. Similarly i think a default grade is assigned too.

Howver From the database perspective, not much is mandatory when defining assignment. But in any implementation, you will define Assignment number, Postion, People Group,Grade, FullTime/Partti me, probation period...etc.

Thanks
Anil Passi
Quote
0 #14 Anil Passi 2006-12-17 00:00
HiJay

When you create a persion record, say by using an API, you will notice that a default assignment gets created. The default organization allocated to the assignment is Business Group itself. Another mandatory field is primary_flag. Similarly i think a default grade is assigned too.

Howver From the database perspective, not much is mandatory when defining assignment. But in any implementation, you will define Assignment number, Postion, People Group,Grade, FullTime/Partti me, probation period...etc.

Thanks
Anil Passi
Quote
0 #15 Ramesh 2006-12-19 00:00
Hi Anil
I am facing an issue in the deducting the salary based on the employee abscence.to eb more clear

I defined an Abscence element(non recurring) multiple entry
With input value Pay value and DAYS with Unite DAY

now when I try to find the database item for the DAYS i am not able to get the data base item which i can use to calculate the amount to be deducted based on the number of leave taken

Please advice me in this.It is very critical as my migaretion to stage is put on hold due to this issue

Regard s
Ramesh Kumar S
Quote
0 #16 Ramesh 2006-12-19 00:00
Hi Anil
I am facing an issue in the deducting the salary based on the employee abscence.to eb more clear

I defined an Abscence element(non recurring) multiple entry
With input value Pay value and DAYS with Unite DAY

now when I try to find the database item for the DAYS i am not able to get the data base item which i can use to calculate the amount to be deducted based on the number of leave taken

Please advice me in this.It is very critical as my migaretion to stage is put on hold due to this issue

Regard s
Ramesh Kumar S
Quote
0 #17 Ramesh 2006-12-20 00:00
Hi Anil
yes the data base item is checked but it is said by oracle that it is the nature of the product, if the elment is multiple entry and the if the input value has the unit as Day then the database item will not be created

my requirement is i need to deduct the slary of the employee if he is abscent on that element

Rega rds
Ramesh Kumar s
Quote
0 #18 Ramesh 2006-12-20 00:00
Hi Anil
yes the data base item is checked but it is said by oracle that it is the nature of the product, if the elment is multiple entry and the if the input value has the unit as Day then the database item will not be created

my requirement is i need to deduct the slary of the employee if he is abscent on that element

Rega rds
Ramesh Kumar s
Quote
0 #19 saran 2007-04-18 00:00
Hi anil,
I have task at hand to implement payroll for an indian orgnanisation , we will be having HR in shared mode , do we have any document which tells what all functionalities we get with HR shared mode installation and also any document which tells about all the setups required for payroll...
You r timely response would be highly appreciated.
T hanks
Saran
Quote
0 #20 Anil Passi 2007-06-04 00:00
Hi Aravind,

You can created Job Groups, and these groups can be created to belong to a Business Group.
Hence other business groups will not be able to use the jobs belonging to these groups
Menu path:- Work structures > Job > Job Group

I know this partially answers your questions, but then Oracle HRMS currently partially supports your business requirement

To resrict on nationality, you can try this
1. Create a DFF or lookup, essentially do something to map a Job/Job Group to nationality
2. Use forms personalization to modify LOV Query to reflect that relationship


Thanks,
Ani l Passi
Quote
0 #21 Aravind 2007-06-04 00:00
Hi Anil,
your site is really good.I have a query regarding Job setup in HRMS.
How do we define Jobs specific to Department/Orga nization/Nation ality Basis of the Employee?Do we have a provision to do the above setup?
Regards ,
Aravind M
Quote
0 #22 Jhakas0007 2007-08-28 11:36
Hi Anil,
Woul dyou have any documenets on Advance Benefits and Performance Management. Would appreciate if you could share the same if you have it.
Thanks and Regards
Vikram
Quote
0 #23 RamachandranN 2007-09-14 07:02
We would like to transfer employees of particular payroll to a New Business Group over PEOPLE, ASSIGNMENT, ELEMENT ENTRIES, SALARY SCREEN, ABSENCE

Should we use API to transfer them individually or Is there any Transfer Business Group functionality exists in Oracle HR?

How do you recommend??

Re gards,
Ram
Quote
0 #24 udayreddy 2007-10-30 09:32
Hi Anil,

This First time i am visiting ur site, I felt very happy after visiting the site. I am working first time on international payroll, we are implementing payroll to one of middle east countries where we don,t have localization. i need to know what are all the mandatory patches to be apply for international payroll.

Hope you reply for this soon.

Thanks

Uday
Quote
0 #25 Srinivas Dodla 2007-12-27 13:20
Hi Anil,

I have created a job group. I wanted to apply this to an employee. can you tell me how to apply this job group while creating an employee.

Than ks in Advance.

Srini vas Dodla.
Quote
0 #26 saliou fall 2008-02-02 07:59
Hi Anil,
Great Website indeed!

I am getting my feet wet in HRMs Fast Formula and facing this challenge on Database Items definitions:
Wh en crusing though FF code, how do I know what data the Database Items relate to?
Name can be intuitive to some degree, but I do trust guess work, ik there a query, a table that would crearly specify the data the database item is pointing to?

Thanks,

S aliou
Quote
0 #27 Sanjib Panda 2008-02-18 13:44
Dear Anil,

When i am trying to set up Oracle HR,for UAE localisation, am getting the error on entering employee employement details in assingment window.Am unable to enter the field "Employer".

Ki ndly revert me.

Thanks
Nar en
Quote
0 #28 Sabs 2008-03-03 09:59
Anil,

I recently took place in new company and I have found a formula using this "MSR_GET_MARRIA GE_DATE()" When I asked HR department they said they have no marriage date field in the front-end view. How can I find out where the information is being picked up for this function? and how to get the marriage date option available in the front-end for HR?

I think my question has some similarity with the February 02, 2008 post.


Sabs
Quote
0 #29 Susant 2008-04-04 09:00
Job and Position Assigment error

When we assign Job and Position in Assignment form of Employee> enter and Maintain, and save the information I get an error message mentioning "Please Choose an existing Combination".
Other details given are :
"Position Flexifield" used while giving details in BG
"Job Flexifield" used while giving details in BG
Grade and Groups have not been used.
Do let me know if anyone has any idea of resolution.
Quote
0 #30 Parthasarathy 2008-04-22 03:36
Hi Anil,
Can you briefly explain what is difference between position hierarchy and supervisor hierarchy?

Thanks
Partha
Quote
0 #31 Ashish Puri 2009-08-24 07:23
Hi Anil,

I have used Security Model in HRMS..I created a Business Group..Using Assign Security Profile Screen in HRMS, I have assigned the Business Group and Default Security Profile to my User and the Responsibility. .Further I have found a new HRMS Resp. got created with suffix as that of my Business Group..

Now when I'm trying to define the Job Group (Work Structures->Org anisations->Job ->Job Group), it does not show me the Business Group that I have defined, rather its showing me Vision Corporation...

Could you please let me know if there is any specific profile option for the same..

You can mail me at .

Thanks for your patience..

Tha nks,
Ashish Puri
Quote
0 #32 JP 2010-02-05 16:42
Hi Everyone,

I have created a Job Group with my own name and created few jobs under the job group which i have created, but when i go to position it says no job exists, it is not showing in the list of values but it is showing the jobs which i created under the job group which the application creates when we create a Business Group. Can anyone guide me is there any setup where we need to set the job group which i created or how?

Regards,
JP
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  May 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
    1  2  3  4  5
  6  7  8  9101112
13141516171819
20212223242526
2728293031  

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner