Oracle HRMS Technical Interview Questions 2

How to make concurrent program end with warning?

If the concurrent program is of type PL/SQL, you can assign a value of 1 to the “retcode” OUT Parameter.
For a Java Concurrent program, use the code similar to below
ReqCompletion lRC;
//get handle on request completion object for reporting status
lRC = pCpContext.getReqCompletion();
lRC.setCompletion(ReqCompletion.WARNING, "WARNING");

How do you link a Host type concurrent program to Concurrent Manager?

 
 Assuming your executable script is LOADPO.prog, then use the commands below
cd $XXPO_TOP/bin
ln -s $FND_TOP/bin/fndcpesr $XXPO_TOP/bin/LOADPO

 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 HH24MISS') dated
FROM   apps.ad_bugs
WHERE  bug_number = TRIM('&bug_number') ;

How do you send a particular Oracle Apps Workflow Activity/Function within a workflow process into background mode.

 If cost of the workflow activity is greater than 50, then the workflow activity will be processed in background mode only, and it won’t be processed in online mode.

 What are the various ways to kick-off a workflow

 
 You can either use wf_engine.start_process or you can attach a runnable process such ghat it subscribes to a workflow event.

When starting (kicking off) an oracle workflow process, how do you ensure that it happens in a background mode?

 
--a)if initiating the process using start_process, do the below
    wf_engine.threshold = -1;
    wf_engine.createprocess(l_itemtype
                           ,l_itemkey
                           ,'<YOUR PROCESS NAME>');
    wf_engine.startprocess(l_itemtype, l_itemkey)
--B) When initiating the workflow process through an event subscription, set the Execution Condition Phase to be equal to or above 100 for it to be executed by background process.

 On 10g, how will you use awr?

 By running below scripts. These are both the same scripts, but with differing parameters.
$ORACLE_HOME/rdbms/admin/awrrpt.sql
$ORACLE_HOME/rdbms/admin/awrrpti.sql
 

How will you configure Apache to run in Debug mode, specifically usefull when debugging iProcurement ( prior to 11.5.10).

 
 After 11.5.10, FND Logging  can be used for debugging Oracle iProcurement.
Prior to 11.5.10
 ----STEPS IN A NUTSHELL-----
cd $ORACLE_HOME/../iAS/Apache
vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/ssp_init.txt
    DebugOutput=/home/<<SID>>/ora9/iAS/Apache/Apache/logs/debug.log
    DebugLevel=5
    DebugSwitch=ON

vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.conf
    ApJServLogLevel debug

vi $ORACLE_HOME/../iAS/Apache/Jserv/etc/jserv.properties
    log=true

 How will you add a new column to a List Of Values ( LOV ) in Oracle Applications Framework? Can this be done without customization?

 
 Yes, this can be done without customization, i.e. by using OA Framework Extension coupled with Personalization. Implement the following Steps -
a) Extend the VO ( View Object ), to implement the new SQL required to support the LOV.
b) Substitute the base VO, by using jpximport [ similar to as explained in Link ]
c) Personalize the LOV Region, by clicking on Add New Item. While adding the new Item, you will cross reference the newly added column to VO.



Important Tables in HRMS

1. per_all_people_f   This table will provide us the very basic information about the employee. The very data from the first screen we see when we open the ‘People -> Enter and Maintain’ form goes into this table.

2. per_all_assignments_f   This table will store all the information which is been entered in the employee assignment form.

3. per_addresses    This table will store all the information which is been entered in the employee address form.

4. per_pay_proposals     This table will store all the information which is been entered in the employee salary form.

5. per_person_types_tl     This table is used to find the type of the employee. This table is linked with the per_all_people_f with the person_type_id to find out the type of person.

6. per_jobs_tl    This table will contain the various types of JOBS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.

7. per_grades_tl    This table will contain the various types of GRADES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct grade name from the employee.

8. hr_locations_all    This table will contain the various LOCATIONS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct location name from the employee.

9. pay_all_payrolls_f    This table will contain the various types of PAYROLLS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct payroll name from the employee.

10. per_pay_bases    This table will contain the various types of PAY BASES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct pay basis name from the employee.

11. per_assignment_status_types_tl    This table will contain the various types of assignment types in oracle. The assignment types generally would be ‘Active Assignment’ etc.. This table is been linked with the per_all_assignments_f table to retrieve the correct job name from the employee.

12. per_person_type_usages_f    This table will store the correct person type of the particluar employee. We should never depend on the person type present in the per_all_people_f table. Instead we need to link the person_id with this table and get the correct person type.

Key Flexfields (KFFs) in HRMS

 
=>Job KFF, 

=>Grade KFF, 

=>People Group KFF, 

=>Position KFF, 

=> Cost Allocation KFF, 

=> Competence KFF

What are Date Track Tables? 

Every update in the Table, we will save the change in the form of a Record to provide the facility to find the information at any point of time.
These tables are post fixed by _F

What are secured Views?

 
The Views which do not have the _all to be said as secured views.
Per_all_people_F
per_people_f
per_all_assignemtns_f
per_assignments_f
pay_all_payrolls_F
per_payrolls_f

The differece between both secured views and non secured views is 

 
1.Secured views display information only for the current period
2.Unsecured views is used to get the information from the entire rows

APIs in HRMS

 
API are used in HR to insert the data into the Base tables. As its very secured system, the user does nothave the facility to copy the data directly into the Base tables.When we write the inbound interfaces / use WebAdI, the systems will use the APIs to store the data into system.The API are published by oracle with number of parameters.The different types of parameters are IN / INOUT / OUT.Of these parameters few are mandatory, with out which the process wont complete.Generally when we use API we give data for  Object Version Number, Effective Date, P_Validate
HR_EMOYEE_api ex hr_employee_api.create_employee
hr_PERSON_api
hr_organization_api 

Ex: hr_organization_api.create_organization
hr_applicant_apI
hr_assignment_api

 

What are the reports which you have done in HR?
HR PAYROLL COSTING 

 
This report is used to display the information about the employees, the assignements which were given to the employees along with the payroll details including the Hours Paid, Salary, NI, Pension, Car Allowances and Other Allowances.
p_datetrack_update_mode, p_datetrack_delete_mode in HRMS API

Understanding the p_datetrack_update_mode Control Parameter in HRMS API

 
The p_datetract_update_mode control parameter enables you to define the type of DateTrack change to be made. This mandatory parameter must be set to one of the values as mentioned below
UPDATE - Keep history of existing information
CORRECTION - Correct existing information
UPDATE_OVERRIDE - Replace all scheduled changes
UPDATE_CHANGE_INSERT - Insert this change before next scheduled change
 

Understanding the p_datetrack_delete_mode Control Parameter

The p_datetract_update_mode control parameter enables you to define the type of DateTrack deletion to be made. This mandatory parameter must be set to one of the following values
ZAP - Completely remove from the database
DELETE - Set end date to effective date
FUTURE_CHANGE - Remove all scheduled changes
DELETE_NEXT_CHANGE - Remove next change