HRMS Technical interview Questions

HRMS Technical Interview Questions

Q) What is SIT?

->   

•  SIT: SIT is basically a KFF.This we can use to capture additional person information.

• The KFF which we are using here is Personal Analysis Keyflexfield. We can create and assign N number of SITs to a person.
• Table PER_PERSON_ANALYSES and PER_ANALYSIS_CRITERIA
• The API to create SIT information is HR_SIT_API.
•  Define a structure for the Personal Analysis Keyflexfield. For this you have to navigate to Application Developer > Flexfield > Key > Segments Query for Personal Analysis Flexfield.
• Enable the SIT.
• For this navigate to US Super HRMS Manager > Other Definitions > Special Information Types
• Select the special information types you want to use in your Business Group.
• Enable each type by checking the Enabled check box.
• Check the other boxes to specify how you plan to use the special information type. This makes it available in the list of values in other windows as follows:
• a. Job : in the Job Requirements window
• b. Position : in the Position Requirements window
• c. Other : in the Special Information window
• d. Skill : in the Skill Provisions and Search for Event windows in Oracle Training Administration
• The OSHA and ADA check boxes are for US users only.

 Q) What is EIT?

-> 

• EITs are basically Descriptive Flexfield (DFF).Standard product has EIT DFFs defined in forms such as Person, Assignment, and Job etc. We can add segments to the defined DFF based on our requirements so that it will appear in corresponding screen. Compared to SIT EIT has added security. We can enable EIT for specific responsibility.
• The DFF which we are using here is Extra Person Information under Human Resources application.
• Register the Extra Information Types.
  Navigate to Super HRMS Manager Responsibility. Select Register Extra Information Types (EITs) standard concurrent program from the SRS window. Give appropriate values and submit.
  Concurrent Program Name:- Register Extra Information Types (EITs) Parameters Table Name :- PER_PEOPLE_INFO_TYPES [Select it from the drop down available.
  Since it is a people EIT hence, we have to select this value]
  Information Type :- <Name of our EIT> [identify the EIT from the LOV]
  Multiple Rows :- <Value can be Yes/No> Yes: - if we select Yes, it means we are allowing users to enter more
  than one record for this EIT definition No:- If we select No, it means users are allowed to enter only one
  record for this EIT definition. Legislation Code*:- <Select the proper legislation for the EIT information type>. Here we are selecting "United States".
• API Name : HR_PERSON_EXTRA_INFO_API
   Table Name : PER_PEOPLE_EXTRA_INFO
• Assign the EIT to responsibility.
  Navigate to HRMS responsibility -> Security > Information Types Security. 

Q) What are the standard KFF and tables used for the same?
->
 Table : 
              1. FND_ID_FLEXS
              2. FND_ID_FLEX_SEGMENTS
              3. FND_ID_FLEX_SEGMENTS_TL
              4. FND_ID_FLEX_STRUCTURES
              5. FND_ID_FLEX_STRUCTURES_TL
1. Grade :

• Flex Field Name: Grade Flexfield

• Flex Code : GRD

• Table Name : PER_GRADE_DEFINITIONS

2. Job :

• Flex Field Name: Job Flexfield
• Flex Code : JOB
• Table Name : PER_JOB_DEFINITIONS

3. Position :

• Flex Field Name: Position Flexfield
• Flex Code : POS
• Table Name : PER_POSITION_DEFINITIONS

4. Costing :

• Flex Field Name: Cost Allocation Flexfield
• Flex Code : COST
• Table Name : PAY_COST_ALLOCATION_KEYFLEX

5. Competence FlexFields. 

6. People Group FlexFields.

Q) Tables used for DFF.
-> 
Tables
1. FND_DESCRIPTIVE_FLEXS
2. FND_DESCRIPTIVE_FLEXS_TL
3. FND_DESCR_FLEX_COLUMN_USAGES
4. FND_DESCR_FLEX_COL_USAGE_TL
5. FND_DESCR_FLEX_CONTEXTS
6. FND_DESCR_FLEX_CONTEXTS_TL

 Q) Tables used for Fast Formula.
->

• FF_FUNCTIONS 
• FF_FUNCTION_PARAMETERS
• FF_FORMULAS_F 
• FF_FORMULA_TYPES 
• FF_DATABASE_ITEMS 
• FF_GLOBALS_F 

 Q) Can we run Quick Pay for multiple Employee?
-> No, We can run Quick Pay for single Employee because we need to run it from employee's Assignment Screen.

Q) How to debug Fast Formula?
->
1) Message in output format

e.g.
mess = 'person is' +first_name

return mess

2) Logging from fast formula execution engine

e.g.
ff_utils.set_debug (ff_utils.ROUTING + ff_exec.FF_CACHE_DEBUG);

Q) Can we use Database function in Fast Formula? If yes then how?
-> Yes, we need to register the Database Function using below navigation.
Total Compensation -> Basic -> Fast Formula -> Formula Function

Q) Tables affected by Hiring an employee?
->
Per_all_people_f
Per_all_assignments_f
Per_periods_of_service
Hz_parties

Q) What is the difference between Rehire and Reverse Termination?
-> Rehire - Select Ex-Employee after interview for respective Position. It will create new service record(Person_id will change).
    Reverse Termination - It is the process of retain the employee. Service period will be the same.

Dynamically Enable/Disable parameter using special type valueset.

Requirement : 

 

Enable/Disable parameter using "Special" Type Valueset.

Steps: 

1) Create First Parameter with value set as per the requirement. Here I used Yes_No standard value set.

2) Create Dummy parameter with value set with NONE as type:

    

 3) Create "Special" Type Value set for third parameter :

 

Click on Edit information and select validate as event.

 

Use below code for validation:

FND PLSQL "BEGIN
IF ':$FLEX$.DUMMY_VS' ='N' THEN
NULL;
END IF;
END;"

Note:- Here you need to use value set which was used in "dummy" parameter.

 4) Define the Concurrent using above parameter: 

 

 5)Attach value set which we create in step 2 to Dummy parameter 

 

Select Default type as SQL Statement.

Default Value : SELECT 'N' from dual where :$FLEX$.i_all_employee = 'N' 

NOTE : - Hide this parameter.

 6) Attach Special type Value set to 3rd parameter which we created in Step 3.

 

7) Save your work.

8) Run the concurrent

If All Employees is Yes then Single Employee WWID parameter should be disable

 

 If All Employees is No then Single Employee WWID parameter should be enable and user enterable.

 

In this way you can  dynamically enable/disable parameter using special type value set.

For more Oracle Fusion HDL Videos  please click here

For more Oracle Fusion Extract PDF Output Videos  please click here