Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

Oracle Apps Interview Questions
  • 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: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

Oracle HRMS Payroll Interview Questions

Dear Learners and Job hunters for Oracle HRMS and Payroll. Please find some basic level questions that you
might be asked in an Interview. 


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 è akdload DOWNLOAD ( & other parameters)
In PRD you will do è akdload UPLOAD ( & other parameters)
On or after 11.5.10 Use responsibility “Functional Administrator”, then click
on Personalization Tab, and then click on Import/Export.
Next select the documents to be exported.
Go to the unix box and tar the personalizations into a .tar file.
On the Production environment unzip this tar file in location as entered in profile “FND: Personalization Document Root Path”.
Setting up of this profile is mandatory or else Oracle Framework would’nt know where to search for the files to be imported.

Anil Passi

Comments   

0 #1 venkat 2006-10-31 00:00
Hi, nice start, to the blog, i hope u post much more information, i think these helped me a lot, thanks for every thing and hoping to get more in future. great start. keep going please.
Quote
0 #2 venkat 2006-10-31 00:00
Hi, nice start, to the blog, i hope u post much more information, i think these helped me a lot, thanks for every thing and hoping to get more in future. great start. keep going please.
Quote
0 #3 Anil Passi 2006-11-15 00:00
Cheers Venkat, I will try to keep this blog as regular as possible
Quote
0 #4 Anil Passi 2006-11-15 00:00
Cheers Venkat, I will try to keep this blog as regular as possible
Quote
0 #5 Anil Passi 2007-03-31 00:00
Cheers Peter, you are right.

For each employee, a record always exists in PER_PERIODS_OF_ SERVICE, and it gets updated during termination.

Thanks,
Anil
Quote
0 #6 Anil Passi 2007-04-25 00:00
Hi Prashant,

Yo u can either use a Workflow Notification or SMTP email for this purpose.

How ever, try using the standard functionality described in link below
http://docs.google.com/Doc?id=dcfd8fsc_59c24m8t

Thanks
Anil
Quote
0 #7 Deepashree J 2007-08-03 12:47
Hi Anil,

Thank you very much for this fantastic bolg. It is very useful for aspiring consultants like me.

Take care..
Quote
0 #8 Deepashree J 2007-08-03 12:50
Hi Anil,

Thank you for creating a very useful blog. It is of great help for aspiring consultants like me.
Please post some more functional HRMS interview questions.

Regards,
Deep ashree J
Quote
0 #9 Farooque 2007-08-14 12:04
Excellent Excellent Site folks, It is really great work done by Anil.
Please add some more Interview questions and answers.
Quote
0 #10 Jyoti 2007-08-16 11:58
Hi Anil,

Thanks for ur Blog. It really help me a lot
Quote
0 #11 Pramil Agrawal 2007-09-15 10:03
Hi Anil,
I am very much pleased to see your blog.

I have got everything required for me to start preparation for oracle apps.

I am thankful of you.

Thanks
Pr amil
Quote
0 #12 Habeni 2007-12-13 00:14
Hi Anil,

What are the list of likely questions for core hr.
Quote
0 #13 Habeni 2008-01-03 19:08
I would like to know if U can help to guide me through exam for sys administrator IZ-232 thanks
Quote
0 #14 Rutuja 2008-01-28 08:26
Hi Anil,
Excellent site, it helps me alot.
please put more questions on HRMS Technical specially about API's and API Hooks.
Quote
0 #15 Facundo 2008-09-18 16:01
Hello, i would like to know the diference between two views.

- per_people_v
- per_people_f

I caný find it. :(

Thanks.
Quote
0 #16 emily 2009-02-17 08:34
send more interview questions on Oracle HRMS
Quote
0 #17 mamoun 2009-06-22 04:31
I am new in HRMS , i need your help!!!
How can i know if an employee is terminate from the work ?
I mean from the DB (coulmn and Table)

Please Help me
Quote
0 #18 mamoun 2009-06-22 06:21
I am new in HRMS , i need your help!!!
How can i know if an employee is terminate from the work ?
I mean from the DB (coulmn and Table)
Correct E-mail
Please Help me
Quote
0 #19 Mark 2009-07-09 06:38
And I thought this post was related to HR and payrolls..:) anyone who wants to prepare for IT positions should also contact an HR professional... :)

Mark
Busine ss Process Outsourcing
Quote
0 #20 Lalit 2010-07-14 15:45
If Actual_Terminat ion_Date is not null (Having a termination date) in Per_Periods_of_ Service Table then the employee is terminated in Oracle HRMS
Quote
0 #21 vipin123 2011-01-20 05:26
gr8 stuff
thanks for sharing your knowledge

http://soft-engineering.blogspot.com
Quote
0 #22 suzitha 2012-06-05 06:47
hi dexish really nice..........
Quote
0 #23 Iliyaz Khan 2015-02-06 08:36
Quoting Facundo:
Hello, i would like to know the diference between two views.

- per_people_v
- per_people_f

I caný find it. :(

Thanks.

per_people_v : is uses user interface where we enter (HRMS>>people>> enter and maintain scree)the data that data will go into per_people_v view

per_people_f: is secured view on top of per_all_people_ f
Quote
0 #24 Iliyaz Khan 2015-02-06 08:43
Quoting mamoun:
I am new in HRMS , i need your help!!!
How can i know if an employee is terminate from the work ?
I mean from the DB (coulmn and Table)
Correct E-mail
Please Help me

1. Person_type_id is changed as EX-employee in per_all_people_ f and effective start_date is terminated date and effective_end_d ate is 4712
2. One terminated record is populated with Assignment_stat us_type_id changed and effective start_Date is termination date and effective_end_d ate is 4712
3.Record is updated with accepted_termin ation_date,actu al_termination_ date is not null
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

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner