plz, I am looking for a good stuff oracle interview questions on HRMS and payroll to help me to select a good applicant for my company
email me at (alruwaished@hotmail.com)
faleh
oracle interview questions on hrms and payroll
-
- Posts: 388
- Joined: Wed Oct 03, 2007 11:32 pm
- Location: Saudi Arabia
Define the following items and explain the usage of each,
Consolidation Set.
Salary Basis.
Payment Method
Payroll
Valid Payment Method
Assigning employee to a payroll.
Creating Elements
Defining an Element's Input Values
Element Set
Assignment Set
Payroll Run
Correction to existing payroll run
Rollback
Post payroll processes
Consolidation Set.
Salary Basis.
Payment Method
Payroll
Valid Payment Method
Assigning employee to a payroll.
Creating Elements
Defining an Element's Input Values
Element Set
Assignment Set
Payroll Run
Correction to existing payroll run
Rollback
Post payroll processes
-
- Posts: 8
- Joined: Sat Jul 21, 2007 4:17 pm
- Location: Qatar
<font face="Verdana">Qns 1. Can you call pl/sql package functions from within a Fast Formula?
Ans 1. Yes you can
-->How do we do this?
-->There is a Define Function screen in HR. In this screen you will register the pl/sql as ?External Function?.
-->If we want to pass a parameter PAYROLL_ID to this external pl/sql Function, how do we do it ?
-->The ?Define Function? screen has a button named ?Context Usage?. This button opens up a window in which you can
register the parameters.
Qns 2: P35 report is run after the ?End Of Year (EOY)? process.
Do you know which tables does EOY process populate.
P35 and P60 reports uses these tables which get populated by EOY
Ans2: FF_ARCHIVE_ITEMS
FF_ARCHIVE_ITEM_CONTEXTS
Qns 3: How do you Debug a Fast Formula?
Ans 3: You can create a message variable in Fast Formula.
This message variable must also be registered as a Formula Result( In ?Formula Result Rule? window).
Qns 4: What are the various levels where you can Set up Payroll Costing Accounts?
Which levels take the highest precedence? **Assume Labor Distributions is not implemented**
Ans4;
Element Entry => Highest
Assignment => Second Highest
Organization => Third Highest
Element Link => Fourth Highest
Payroll => Fifth Highest
Qns5: Technically speaking, how do you know from tables that an Employee has been terminated?
Ans 5:
(a) The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP
(b) A record gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null
Qns6: How can you make Employee Number generation Automated based on business rule etc.
Ans6: Use Fast Formula.
Qns7: What is the difference between per_people_f and per_all_people_f
Ans7: PER_PEOPLE_F is a secured view on top of PER_ALL_PEOPLE_F. The secure view uses an API hr_security.show_person.
This API internally checks for an entry in table PER_PERSON_LIST for the logged in person's security profile. A concurrent
program named "Security List Maintainence program" will insert records in PER_PERSON_LIST
Oracle HRMS Self Service Interview Some Simple Questions
Qns 1 :
If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?
Ans 1:
Responsibility level. Responsibility level will override FUNCTION level personalizations.
Qns 2:
Say you have done a lot of Personalizations to Self Service Screens.
But all these Personalizations were done in DEVELOPMENT environment.
How will you migrate these personalizations to PRODUCTION environment?
Ans2:
Before 11.5.7?Use AKLoad
This is a java program given by Oracle. This is the only way you can script it.
In DEV you will do
Ans 1. Yes you can
-->How do we do this?
-->There is a Define Function screen in HR. In this screen you will register the pl/sql as ?External Function?.
-->If we want to pass a parameter PAYROLL_ID to this external pl/sql Function, how do we do it ?
-->The ?Define Function? screen has a button named ?Context Usage?. This button opens up a window in which you can
register the parameters.
Qns 2: P35 report is run after the ?End Of Year (EOY)? process.
Do you know which tables does EOY process populate.
P35 and P60 reports uses these tables which get populated by EOY
Ans2: FF_ARCHIVE_ITEMS
FF_ARCHIVE_ITEM_CONTEXTS
Qns 3: How do you Debug a Fast Formula?
Ans 3: You can create a message variable in Fast Formula.
This message variable must also be registered as a Formula Result( In ?Formula Result Rule? window).
Qns 4: What are the various levels where you can Set up Payroll Costing Accounts?
Which levels take the highest precedence? **Assume Labor Distributions is not implemented**
Ans4;
Element Entry => Highest
Assignment => Second Highest
Organization => Third Highest
Element Link => Fourth Highest
Payroll => Fifth Highest
Qns5: Technically speaking, how do you know from tables that an Employee has been terminated?
Ans 5:
(a) The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP
(b) A record gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null
Qns6: How can you make Employee Number generation Automated based on business rule etc.
Ans6: Use Fast Formula.
Qns7: What is the difference between per_people_f and per_all_people_f
Ans7: PER_PEOPLE_F is a secured view on top of PER_ALL_PEOPLE_F. The secure view uses an API hr_security.show_person.
This API internally checks for an entry in table PER_PERSON_LIST for the logged in person's security profile. A concurrent
program named "Security List Maintainence program" will insert records in PER_PERSON_LIST
Oracle HRMS Self Service Interview Some Simple Questions
Qns 1 :
If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?
Ans 1:
Responsibility level. Responsibility level will override FUNCTION level personalizations.
Qns 2:
Say you have done a lot of Personalizations to Self Service Screens.
But all these Personalizations were done in DEVELOPMENT environment.
How will you migrate these personalizations to PRODUCTION environment?
Ans2:
Before 11.5.7?Use AKLoad
This is a java program given by Oracle. This is the only way you can script it.
In DEV you will do
-
- Posts: 2
- Joined: Fri Jun 24, 2011 5:32 am
- Location: Austria
-
- Posts: 2
- Joined: Fri Jun 24, 2011 5:32 am
- Location: Austria
If you want to get more materials that related to this topic, you can visit: http://jobinterviewquestions.biz
Best regards.
Best regards.
Who is online
Users browsing this forum: Google [Bot] and 1 guest