HR and PAYROLL Interview Preparation - Part IV

1. What is the Process to Reverse a Termination of employee?

You reverse a termination in order to make an employee active again.

Navigation: HR Responsibility >> Enter & Maintain >> Others >> End Employment

Search for the separated employee record  and click on ‘Reverse Termination’ button to undo the termination of an employee. As a result the person will become active employee again.

2. What is the Process to Rehire an ex-employee?

In order to rehire, you don’t need to reverse the termination, you will go to date at which you need to rehire an ex-employee. Find the person in Enter & Maintain screen and from ‘Action Type’ drop down on upper right corner of page, selection the ‘Employee’ option and click save, it will make the employee active again.

3. What is the difference between re-hire and reverse-termination?

In case of reverse termination, there is no gap between employee’s service history whereas when we re-hire, it does not cancels the termination record so we can get the service gap in employee’s employment history.

Assignment Number and Employee Number are always same for an employee who joined first time e.g. For an employee number 1234, assignment number will be same as 1234. But when you rehire a person, Oracle adds a number in its assignment number e.g. For an ex-employee 1234, assignment number after rehire will become 1234-2.

4. How we can create employee number in any specific format?

Through fast formula we can do. When we create business group, we configure the employee number generation method. Normally it is kept as automatic but if we want, we can select the Manual method and can write code in fast formula of the type ‘Person Number Generation’.

5. What are two profile option that we need to set to enable personalize Page link on self-service page?

Personalize Self-Service Defn                 Yes

FND: Diagnostics                                    Yes

6. How do you know if a specific Oracle patch has been applied in apps to your environment?

Use table ad_bugs, in which column bug_number is the patch number.

SELECT  bug_number ,

                 to_char(creation_date, 'DD-MON-YYYY HH24:MI:SS') dated,

                APPLICATION_SHORT_NAME,

               ARU_RELEASE_NAME

FROM apps.ad_bugs

WHERE bug_number = nvl(trim(:bug_number), bug_number)

order by dated desc

7. How to find, how many columns in any APPS TABLES ? 

select *

from dba_tab_columns

where table_name = :table_name_in_caps

8. What are different ways of correction of mistakes in Payroll Run

• Rollback
• Retry
• Reversal

9. What are the different element termination rules in Payroll?

• Actual Termination: For a nonrecurring element, select Actual Termination if you want the entries to close down at the end of the pay period in which the employee leaves
• Final Close: if you want the entries to stay open beyond the employee’s leaving date so that you can continue to pay the employee
• The Last Standard Process date: defaults to the last day of the pay period in which the employee is terminated, but you can set it to a later period when you terminate an employee

10. How can i know which application uses AME?

Select *

from AME_CALLING_APPS_VL