Monday, 9 April 2018

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.


10 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Awesome post. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion HCM Training

    ReplyDelete
  3. Awesome post. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion HCM Training

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here .Same as your blog i found another one Oracle Fusion HCM Technical . Actually I was looking for the same information on internet for Oracle Fusion HCM Technical and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  6. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.
    Oracle Fusion HCM Online Training

    ReplyDelete
  7. Merkur 15c Safety Razor - Barber Pole - Deccasino
    Merkur 15C https://deccasino.com/review/merit-casino/ Safety https://septcasino.com/review/merit-casino/ Razor - Merkur - 15C for choegocasino.com사이트 Barber Pole is the perfect https://aprcasino.com/ introduction to the Merkur 온라인 카지노 Safety Razor.

    ReplyDelete

How to sort data in rtf template

  How to sort data in rtf template Sort the data in Data model is the recommended approach. But if you want to sort the data in rtf template...