Sunday, September 14, 2014

Core HRMS Interview Questions 1


What are basic setups of oracle HRMS?



In oracle HRMS there are so many modules like Core HR, Payroll, Self Service HR, Oracle learning management, iRecruitment, Time and Labour, Compensation Work bench, Oracle Advanced Benefits, Performance Management System etc., Core HR and System Administrator are the Heart of Oracle HRMS.

All basic set ups will do in Core HR with the help of System Administrator.

In system administrator we will create all the Users and Responsibilities, Flex fields, Profile values etc., In core HR we will create Organizations, Locations, Jobs, Positions, Grades, Organization Hierarchy, position Hierarchy, We will create all the employees also. These are the Basic setups in HRMS.



What are the differences between 11i and R12 HRMS


Oracle 11i
Oracle 12
The Legal Entity, the Set of Books and the Operating Unit… all of these were defined using the Organizations form typically through the HRMS or Inventory responsibilities.
the Legal Entity, the Primary Ledger and Operating Unit are all defined using the the Accounting Setup Manager.
the Bank Accounts are defined at the Operating Unit level.
Bank Accounts are defined at Legal Entity Level which can be accessed by multiple Operating Units.
there are only 6 validation types viz. Dependent, Independent, None, Pair, Special and Table
there are 2 additional validation types called ‘Translatable Independent’ and ‘Translatable Dependent’
Reporting Currencies -MRC Reporting set    
Reporting Currency of books
Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2
Release 12 its 10g R2 (10.2.0.2)


What are 2 modes of date track in Oracle APPS?
There are two Date Track modes are as follow:
·         Update
·         Correction


Difference between correction/update
· If you choose Update, Oracle HRMS changes the record as from your effective date, but preserves the previous information. 
· If you choose Correction, Oracle HRMS overrides the previous information with your new changes. The start and end dates of the snapshot you have corrected remain the same.

What is the use of Date Track?

1) It is used to maintain the record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION.

2) The value of the Data Track record depends on the date.

3) Tables ending with _F are date track tables.

4) To control data tracked rows, every Date Track table must include Effective_start_date & Effective_end_date.

5) The Effective_Start_Date indicates when the record inserted.

6) The Effective_End_Date indicates when the record updated or deleted.



Types of flexfield’s and Types

There are around twelve KFFs in Oracle HRMS; out of which six are mandatory for a successful Core-HR implementation. The mandatory KFFs are:
  • Job
  • Position
  • Grade
  • People Group
  • Cost Allocation
  • Competency

Apart from the mandatory ones, there are a few optional KFFs present in the Oracle HRMS. Like:

  • Personal Analysis
  • Collectively Agreed Grades Flex field
  • Soft Coded Key Flex field
  • Bank Details Key Flex Field
  • Training Resources
  • Item Contexts Flex Field.



Mandatory flexfield’s for BG

The mandatory KFFs are:
  • Job
  • Position
  • Grade
  • People Group
  • Cost Allocation
  • Competency

Difference between KFF and DFF

Key Flexfield
Descriptive Flexfield
A Key Flexfield as the name suggest is a key building block of a module and is required for defining the structure of objects of that module e.g. The Account Structure, Item Structure etc.
A descriptive Flexfield as the name suggests helps more in describing an object (like a transaction or screen) more than the available fields on that screen
Key Flexfield captures mandatory business information like company department, account etc.
Descriptive Flexfield captures additional business information like name of the company’s MD etc.
KFF is Mandatory
DFF is optional
KFF displays like text item
DFF displays like []
KFF’s data are stored in the segments
DFF’s data are stored in the attributes
30 segment columns are reserved for KFF’s data
15 attribute columns are reserved for the DFF’s data.

2 comments: