Sunday, April 12, 2015

HRMS Interview Questions

What is Human Resources Management?
This is nothing but the labor force or personnel.
Human Resources Management is used for addressing the employees’ aspect of this continuous improvement. It helps the enterprises in reviewing and improving their business functions related to the personnel management

What are core flex field?
Job, Position, Grade, Competence
Payroll Flex Fields are: People Group, Cost Allocation

What are two modes of date Track and what is date track?
Update, Correction
Date tracking is to maintain a continuous history of the record of information over a period of time.
You can use date track history to view a report of every update ever made time and records.

The two DateTrack command icons on your window toolbar are:
Alter Effective Date
View DateTrack History 

How is employment information maintained in Oracle HRMS?
At table level, employee records are stored with effective start date and end date. Whenever you change any record in the Employee record in UPDATE mode, a new row is created at back-end. Hence history gets stored in system. At front end you have option.

What are six validation types?
Dependent, Independent, None, Special, Pair, Table

What are list types?
 List of Values, Long List of Values, Pop List

What are basic setups of oracle HRMS?
In oracle HRMS there are many modules like Core HR, Payroll, Self Service HR, OLM, iRecruitment,
Time and Labor, Compensation Work bench, Oracle Advanced Benefits, PMS.
Core HR and System Administrator is the Heart of Oracle HRMS.
All Basic setups will do in Core HR with the help of System Administrator.
System Administrator: We will create all Users’, Responsibilities, Flex Fields, Profile Values.
Core HR: We will create all Organizations, Locations, Jobs, Positions, Grades, Position Hierarchy,                Organization Hierarchy; these are the basic setups IN HRMS.

How to restrict the users to see the payroll data employee wise, they only can setup the
Basic elements and pay bonuses but cannot see the gross salaries of employees?
 Define Profile Security for the Employee.
 Define task Flow for the screen i.e. (People and Assignment Form Combined, Define Task Node).

What is element entry? What is the purpose of element entry?
 Element entry is to define element that is Earning Element or Deduction Element to Calculate
 Net salary/ Pay.

What is an Element? What are processing types of element?
Elements are nothing but components of Salary, They are
Basic, HRA, TA, DA, BONUS, House Allowance, Transport Earning, LOAN’s etc.
Processing Types are
Recurring- Element applies every period until the entry ended
Non-Recurring- Entry applies in one pay period only

What are termination rules of an element?
Actual Termination: For Non-Recurring element (end of pay period for employee leaves)
Final Close: Entries to stay open beyond the employee’s leaving, continue to pay employee
Last Standard Process: Date default to last day of pay period in which employee is terminated

How does u Define B.G?
1. Define Necessary Key Flex Fields like job, position, grade, competence, people group, cost allocation and compile all of them.
2. Go to Global HRMS Manager >Work structures >Organization >Define
By default: “Setup Business Group" available in the system. This BG info visible to all the employees, to represent a single Unit...Hence in order to make partition on the Employee data.

What is costing?
Costs of Assignment for accounting or reporting purpose. Using Payroll we can calculate and transfer costing details to GL and Project Management or Labor distribution.

What are costing types?
Costed, Fixed Costed, Distributed.

What is Costing sub module in Oracle HRMS?
There is no such module in HRMS. But the expenses incurred because of HR activities such as Recruitment expenses, Learning Expenses (Training, Training facilities etc) and Time & Labor expenses (Project related expenses) and other misc expenses.

Can we name certain DFFs (description flex filed) and their location?
Yes we can name certain DFF's and their location.

How many types of payrolls are there?
Payroll Period Types are:
Semi-Year, Quarter, Bi-Month, Calendar Month, Weekly, Bi-Weekly, Monthly
Extensively used payroll types are: 1. Weekly2. Bi-weekly3. Monthly

Different types of payroll runs?
  1. Regular Payroll Run 2.Quick Pay

How many types of Fast Formulas are there in HRMS?   
There is long list of fast formula types available, but their usage depends on relevant module. E.g. Oracle Payroll is used for payroll calculation, Element Skip for skipping the element based on element type

Why are we enabling Allow Dynamic Inserts in HRMS and What is the Purpose of doing it?
To allow insertion of new combinations in the combination table. For example, if you have entered a new value which doesn’t exist in the combination table in the database, allow dynamic insert option allows to accept that data entered by the user and store in table.

How people management is achieved using Oracle HRMS? 
People management means it gives you all the features and functionality you need to track and manipulate your data. From joining to leave the Organization to enter and track people form  the day they apply for a job to the day they leave your enterprise.

What are the modules available in Oracle HRMS?   
Human Resource/Core HR, Payroll, Time & Labor, OLM, Tutor, Workflow, Advanced Benefits,
Self-Service Human Resources, iRecruitment, Incentive Compensation, Intelligence Talent Management (Performance Management/PMS-Performance Management System).

What are domains in oracle HRMS? 
Core HR, self Service HR, Payroll, OAB, PMS, OTL, IRECURIMENT, OCB, WORKFLOW 

What are the reports available with Oracle HRMS?
Absences Report, Assignment Status Report, Current and Projected Progression Point Values Report, Element Link Details Report, Employee Increment Results Report, Employee Movements Report, Employee Summary Report, Full Personal Details Report, Full Applicant Details Report.

What are the reports available with Oracle HRMS?  
Absences Report, Assignment Status Report, Current and Projected Progression Point Values Report, Element Link Details Report, Employee Increment Results Report, Employee Movements Report, Employee Summary Report
Absences Report                                   Conc. Prog.    Compensation, Benefits and Payroll
Assignment Status Report                   Conc. Prog.       Workforce Sourcing and Deployment
Duplicate Person Report                      Conc. Prog.     Workforce Sourcing and Deployment
Employee Increments Result              Conc. Prog    Workforce Sourcing and Deployment
Employee Summary Report                 Conc. Prog.    Workforce Sourcing and Deployment
Entity Element Summary Report         Conc. Prog.    Enterprise and Workforce Management
Full Applicant Details Report                Conc. Prog.  Workforce Sourcing and Deployment
Full Assignment Details Report            Conc. Prog.   Workforce Sourcing and Deployment
Full Person Details Report                    Conc. Prog.    Workforce Sourcing and Deployment
Full Work Details Report                       Conc. Prog.    Workforce Sourcing and Deployment
Head Count Detail Report                     Conc. Prog.     Workforce Sourcing and Deployment
Head Count Summary Report               Conc. Prog. Workforce Sourcing and Deployment
Organization Hierarchy Report             Conc. Prog.     Enterprise and Workforce Management
Person Full History Report                   Conc. Prog.   Workforce Sourcing and Deployment
Position Hierarchy Report                    Conc. Prog.     Enterprise and Workforce Management
Requisition Summary Report               Conc. Prog.    Workforce Sourcing and Deployment
Terminations Report                             Conc. Prog.     Workforce Sourcing and Deployment
Workforce Count Report                       Conc. Prog.    Workforce Sourcing and Deployment
Worker Summary Report                      Conc. Prog      Workforce Sourcing and Deployment
Assignments Unavailable for Processing  Conc. Prog.      Payroll Process Management
Cost Breakdown Report for Costing Run    PDF       Payroll Process Management
Element Result Listing                                   PDF       Payroll Process Management
Employee Assignments Not Processed (Global)        Conc. Prog.     Payroll Process Management
Deduction Report                                                         Conc. Prog      Payroll Process Management
Employee Payroll Movements Report                       Conc. Prog.     Payroll Process Management
Location Change Report                                             Conc. Prog      Payroll Process Management

What are the reporting tools available with Oracle HRMS? 
Oracle Reports (D2K), XML Reports, Discoverer Reports

How is employment information maintained in Oracle HRMS?  
At table level, employee records are stored with effective start date and end date. Whenever you change any record in the Employee record in UPDATE mode, a new row is created at back-end. Hence history gets stored in system.
At front end you have option to select effective date to get effective record on that date.
Enter and Maintain contains most of the required information related to employee. If you have some more information to cover, you can use Extra Information or Special Information to store details.

What are the steps involved in implementation of Oracle HRMS?
Following are the steps to implement Oracle HRMS
 Define Key Flex fields
 Define Descriptive Flex fields
 Define Business Group
 Set required Profile Options
 Define Location
 Define Organization
 Define Grades
 Define Jobs
 Define Positions
 Set required Lookup values
 Set person type and Assignments type as per requirement
 Associate Special Information with your Responsibility
 Register Extra Information and associate with your Responsibility.

What are the system administration tasks in Oracle HRMS?  
Following are the tasks for system administrator: Set Profile Options, Create Menu and Request Group for Custom Responsibilities, Create Responsibilities, Create Users and Attached Responsibilities with User.

Oracle Payroll Retro Pay?
Retro Pay is a payment made for an event of past. Retro Pay stands for some old Payment due for the employee. This is used for Back Dated Salary Increments.
There are four ways. 1. Retro Pay by Run   
                               2. RetroPay by Aggregate
                               3. RetroPay by Element
                               4. Enhanced Retro Pay

What are the advantages of Oracle HRMS over peoplesoft HRMS?  
Oracle HRMS is more secured than People Soft HRMS.

What are the vital features of Oracle HRMS?  
Vital features are: People, Assignment, Work Structure, Compensation and Benefits

How do you declare bonus of an employee in Oracle HRMS Payroll?
Define one element (earnings) and use it to pay Bonus. Declaration is based on the functional inputs, suppose company wants to pay Bonus along with January Salary in Every Year, you can write the formulas accordingly.

What are the tools used with Oracle HRMS?
Oracle Reports, Discoverer, Standard seeded reports, View/List option of the menu - output could be exported in word/excel, Web ADI etc.

What is advanced benefits module in Oracle HRMS?
Oracle Advanced Benefits (OAB) takes care of the management of Benefits Administration part. It has very advanced features like Life Event Triggering / Processing, FSA administration, Reimbursement processing, Communications relating to Benefits etc.

What are the key tables used in HRMS?

How is new reports created in Oracle HRMS?
Discoverer, BI Reports, Copy existing report and register with different name.

What are the advantages achieved by an organization by using Oracle HRMS?
WS and  Compensation benefits with Assignments being the basis. This model is both flexible and adaptable. It is flexible, With Oracle HRMS you can define your own human resource model to reflect your own enterprise structures and policies. This information model lets you record the personal, work, and pay information for all the people you want to hold and process

Delete: Is used to delete the data from table
Purge: Is used to delete the data from recycle bin 

How to transfer an employee BG to BG with same employee number?
You can set your employee numbering as Global employee numbering at BG level to achieve this.  

There is only one Soft Coded Key Flex field. You have one structures associated to this key flex field for each country

What is difference between configuration, customization and interface?
Configuration means - configure the application according to client requirement.
Customization means alter / change /create forms, reports according to organization requirements.
Interface means connect your apps with other 3rd part application/ Transfer data from flat file to Apps 
Customization means: changing the source code of forms.
Interfacing: is used for importing/exporting data from any third party software’s
Configuration means: enabling the setup for business requirement.  
We heard the term: RICE (Reports, Interface, Customization and Extensions). The latest addition to this FRICE with Forms added to the list. 

What are flex fields in Asset? 
 Category Flex field
 Location Flexi field
 Asset key Flex field      

What is the difference between rehire and reverse-termination?
Hiring an ex-employee again after interviewing him for a certain position. So the person will have a new service record but the personal details might remain the same.
If the employee is terminated as per the process or by mistake and then there is a requirement to call back the employee immediately after termination, is known as reverse termination. That means reverse the process and retain the employee. While processing employment details continues with the same assignments and the same service period

What is a security profile?
Security profile provides more security within BG. It helps in determining what users have access to what data. The levels where you can have security profile are: Organization Position Payroll Supervisor User specific: you can restrict / give permission to any user you can also have Custom security

Is Address form is date tracked?
No, i dont think its data tracked.

Can we delete an employee forever? How?
Use ‘Delete personal record’ form from front end. But employee should not be an application user (end date the username before delete) and should not be having payroll run data.

Can you call pl/sql package functions from within a Fast Formula?
 Yes you can

How can we do this?
There is a Define Function screen in HR. In this screen you will register the PL/SQL as “External Function”.

How do you debug a Fast Formula?
You can create a message variable in Fast Formula. This message variable must also be registered as a Formula Result (In “Formula Result Rule” window).

What are the various levels where you can set up Payroll Costing Accounts?
Element Entry => Highest, Assignment => Second Highest, Organ ization => Third Highest,       Element Link => Fourth Highest,   Payroll => Fifth Highest

Technically speaking, how do you know from tables that an Employee has been terminated?
(a) The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type    EX_EMP
 (b) A record gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null

How can you make Employee Number generation Automated based on business rule etc?
Use Fast Formula

What is the difference between PER_PEOPLE_F and PER_ALL_PEOPLE_F?
PER_PEOPLE_F is a secured view on top of PER_ALL_PEOPLE_F. The secure view uses an API hr_security. show_person. This API internally checks for an entry in table PER_PERSON_LIST for the logged in person's security profile. A concurrent program named "Security List Maintenance program" will insert records in PER_PERSON_LIST
What is the use of approval work flow?
Oracle Service Contract leverages Oracle workflow to automate the contract approval process. After authoring the contract one can send it for approval and obtain signature on contract.

What is the importance of below three profile options?
1. HR Business group
2. HR User type
3. HR Security
Based on these profile options all operating units linked to the same business group.  
HR Business Group: profile option is used to assign the business group to the responsibility
HR User type: to define which kind of user is using the responsibility (HR, payroll or HR with Payroll)
HR Security: it give access to specific operating units. By default application creates a security profile with same name as business group with all the privileges to all operating units. However, we can define our own security profile.
We can define business group for particular responsibility in hr business group.
We can define (HR user or HR with payroll) in hr user profile
we can define an operating unit in Hr security profile.
Profile: Hr%sec% ex. TATA MOTORS
and also we can define in Default operating unit in HR
security profile.
Profile: HR%DEF% ex. TATA cars     
HR: Security Profile
HR: User Type as Only HR/HR with Payroll
HR: Cross Business Group as yes/no, if yes. Then user can access data from other Business group too.
MO: Operating Unit, if Multi Org is set up for a BG then this is mandatory to setup ow optional.  

What is GRE/legal entity or GRE organization and its purpose and difference between it and other organization types?
GRE/Legal Entity: Use this classification to represent the following organizations:
 Ultimate Legal Entity: this represents the enterprise, and typically, the enterprise is the highest (global)  level of a business organization.
 Legal Entity: this represents the designated legal employer for all employment-related activities. The legal authorities in a country recognize this organization as a separate employer. In an organization hierarchy, a legal entity may report to an operating company or to the ultimate legal entity.
Consolidated Legal Entity: this organization acts on behalf of multiple operating companies that are not legally registered, or simply on behalf of the enterprise in a country.     

How can we do Final settlement in Oracle Payroll?
First you should manage all the formula process to calculate until terminated employee date
Create another type of payroll type Run- Final settlement.
Run the payroll.
For terminating an employee some elements needs to be attached The elements are as follows:
Retirement Compensation Information
Voluntary Retirement Information
Commuted Pension Information
Leave Encashment Information
Other Termination Information
Provident Fund Settlement Information
2).Link all these elements to your Payroll.
3).Attach all the above elements in your entries
4).Run quick pay for that particular employee.
1. For terminating an employee some elements needs to be attached to payroll of that employee.
   The elements like allowances, gratuity etc is to be attached with their pay value.
2. Go to end employment of that particular employee master and put an end date to it.
3. Then run the quick pay for that person.   

What is difference between MD 50 and MD 70?
MD050 is the Functional Design Document and
MD070 is the Technical Design Document.
For any component like Report, Interface etc we have to first get the requirements as to what is the source , destinations, what data should be moved and what functional validations would be required etc. All this would go into the MD050. Generally written by non-technical people like Business Analysts or Functional Consultants.

MD070 is the technical document that is written to fulfill the functional requirement specified in MD050. It includes the approaches you take, pseudo code, Validations, Data Sources, SQL Statements etc. 
MD 50 : this is functional design document
MD 70 : this is technical design document

Functional consultant will prepare the MD 50 document then
Technical consultant prepare MD 70 then technical consultant start his work according to document.

What differ between Extra information type and Special information type?
EIT -Descriptive DFF
SIT -Key flex field
Both store in different Tables.
EIT may be design in one record entry
SIT may be design as Effective Start Date and End Date
EIT: Extra Information which stores additional information
SIT: Whereas Special Info Identifies the entities.   
EIT and SIT Both are provided by Oracle to Capture Extra Information.
Basic differences would be EIT is similar like a DFF and also defined using DFF Definition Screen.
SIT is KFF and defined using Personal Analysis KFF Definition screen.
SIT generally used at Person Level, EIT can be defined at Person, assignment, contact, element, location and Job Level.
There are 2 columns date_to and date_from in SIT while no such columns are there in EIT.

User Acceptance Testing is usually done by Functional consultants before the project goes for release.
In UAT to test if the configuration is done according to the requirements given. Moreover, regression testing to some extent is also required apart from the core testing. If there is some discrepancies then immediately need to open a ticket to the Development team who did the configuration. Once that is resolved, the UAT can be checked as done as posted for peer sign off. Once peer sign off is done, it can be approved.   

What are multiple organizations?
An organization which contains different operation units but are put under one business group. 
Multi org is server side enhancement (application and database) which enable u to create multiple business units in an single enterprise.  

How to increase the salary of an employee?
In salary window correct the salary and end date the old salary and then add new salary and the date. 
Basic salary is changed from Salary Administration screen and other components are changed from the Entry Values Screen.
You can increase the salary of an employee from assignment screen you will find salary button.
Change the effective date and change the salary.
Go to People > Assignment screen > Salary screen
and create new salary  

What is work structure?
Work structure is a Business entity concept where first will define a Business group than follows the Business unit, departments, for Gre/legal entity. And also for reporting purpose. 
Work Structures provide the framework in which you place people they include:
- Enterprise and employer structures such as business groups, organizations and legal entities
- Work roles for employees such as Jobs and Positions
- Grade structures with related pay rates
- Payroll Groups with processing calendars.

How many types of extra information are there?
The Major Extra Information (EIT) Types in HRMS:
1. Location
2. Job
3. Position
4. People
5. Assignment
6. Element
7. Contact 

What is business requirement gathering?
Business requirement gathering is where we collect the information related to the organization. In hrms it is termed as CBB current business baseline document. This documentation is done in RD020      
When we talk about Oracle Applications, Oracle insists clients to fallow AIM methodology in their implantations.
GAP and FIT analysis using which the functional person will come up with a solution to the clients requirement.
To know the requirement of the client one should prepare BR100 i.e requirement gathering.
Based on which type of customization will be decided and MD50 will be documented and submits for review.  

What is the flow in HRMS?
We can define below given flow for HRMS Candidate -> People -> Assignment -> Payroll
Flow is the sequence in which window opens one after the other.
Oracle HRMS maintains four type of information flow
1. Applicant’s data
2. People (Employee’s)
3. Assignment Data (Employees Work Related Information)
4. Payroll Data.

What is an implementation? What is the exact role of an Oracle HR Functional Consultant in implementing Oracle HR?
The complete set of Oracle Applications implementation services include:
Project Planning and Management > Business Requirements Analysis > Business Process Improvement >
Application Setup and Configuration >  Data Conversion >  Customizations >  Module Implementation >
Database Administration > Trainings           
Implementation is the process where a functional guy needs to understand the requirement of the client business needs and map the same with the oracle HRMS. Functional person will be responsible for defining the rules and regulation in the system. He will develop the system in such a way that clients business needs meets.
Implementation is carrying out execution. Develop test and execute. An HRMS consultant does carry out planning, requirement gathering, finding out the gap between the ERP application and the client requirement. Analyze the requirement and givig solutions followed by setup documentation.

Why do we need Oracle Payroll?
We need Payroll software primarily to calculate net salary for the employees, and also for regulatory & reporting reasons. Oracle Payroll helps an Organization to manage the costing of their Employees

Payroll means processing a salary for salaried employee. There should be relation of “contract of service”
Payroll means an abstract of monthly salary details of an employee which is generated by computer

Can we capture just one value against each Element?
Wrong, you can capture upto 15 values [via Element Entry] per Oracle Payroll Element.

The Payroll process [conc short name PYUGEN] can be run for a specific Payroll i.e. for people enrolled to Monthly or Weekly payroll.
Hence Payroll_id is stored to capture parameter details.
A payroll action can also be restricted to a specific group of Elements, via ELEMENT_SET_ID.
A group of Elements are defined using a table PAY_ELEMENT_SETS, for example you wish to group all bonus related elements together.

Which Assignment Records were included in Payroll Actions:-
Pay_assignment_actions contains an entry for each Assignment_id that was eligible during Payroll Action.
For example if you run a quick pay, an entry for that specific assignment_id will be created in pay_assignment_actions.

What are the possible actions?
     Quick pay
     Payroll Run
     Magnetic Transfer [synonym to EOY-End of Year run]
     Transfer to GL......etc
A column named ACTION_TYPE [validated by lookup type ACTION_TYPE] is used to store the type of action.

What is the difference between quick-pay and payroll run?
Quickpay is functionality (available from assignment screen), by which you can run the payroll for single person assignment. It uses the same executable as that of actual Payroll run.

When the payroll engine runs, does Oracle calculate the first calculates the Deductions and then Earnings?
You can assign Priority to Element Classifications. If priority of Earning is 1 and Priority of Deduction classification is 2, then Earnings will be calculated first, and then deductions will be applied latter by the Payroll engine

What is payroll run results?
When payroll process runs, it reads the element entries for the assignment in pay_assignment_actions. For those element entries, payroll engine uses the entry value in "pay value" or it kicks off a fast formula if the element has a fast formula attached to that. The end result is that each eligible element gets a result. These results are stored in pay run result tables

What are the payroll run results tables?
Obviously the values are stored per element in Pay_run_results.
The input value used/derived by payroll engine is stored in Pay_run_result_values

The Costing Allocation Key Flex field, during the business group definition it is being created and map with Cost Allocation KFF with following segments normally.
• Company • Cost Centre • Natural Account/Accounts Code
During the configuration of Cost Allocation KFF the most important concept is to set the Flex Field Qualifiers at each segment level, we have the five levels available for each segment i.e.
Assignment > Balancing > Element Entry > Element Link > Organization > Payroll
For the Company segment following setting can be applied
Payroll Checked
Balancing Checked
This setting will explain that the Company Account will be input at Payroll level (debit information) and balancing information will goes into credit information and on every segment level it is mandatory to define Balancing.
For the Cost Centre segment, I can set the following setting
Payroll Checked
Organization checked
Balancing checked
This setting will explain that the Cost Centre Account information will be input at Payroll and Organization  level (debit information) and balancing information will goes into credit information and on every segment level it is mandatory to define Balancing.
For the Natural Account segment, I can choose the following setting
Element Link Checked
Assignment Checked
Element Entry Checked
Balancing Checked 
This setting will explain that the Natural Account information will be input at following levels
Element Link, Assignment, Element Entry level information will directly hit the debit account and balancing information will goes into credit Account and on every segment level it is mandatory to define.

After this step we map Cost Allocation KFF Segments with GL Flex field Segments
In Oracle payroll, Costing information can be input at five levels
• Payroll
• Organization
• Element Link
• Assignment
• Element Entry
Now based on the above configuration, the following codes will be define at Payroll level.
Company 01
Cost Centre 000
For example if Business Group has four Departments i.e. FINANCE, HR, IT, Operations then on every organization the following information will be define at the Organization level
FINANCE: Cost Centre 001
HR: Cost Centre 002
IT: Cost Centre 003
Operations: Cost Centre 004
Note: Here the Cost Centre information will override with information available on Payroll Level.
Payroll Level 000
FINANCE Org Level 001

Creating SIT?
Login in as System Administrator -> Flexfield -> Key -> Segments

Search for Application (Human Resources) and Flexfield Title (Personal Analysis Flexfield)
Define a new row, we can call it MEDICAL_REIMBURSEMENT_KFF and the description can be Job Requests.
Next we click on "Segments" to define the form fields to be used in the application.

Field – Value Set(segments of given SIT)
Employee Name LOV
Nature of Sickness LOV
Details of Sickness 30Char
Hospital Name 30Char
Amount Allowed CRL_YES_NO
Amount Number

Multiple Payroll and Currencies Setup
This type of implementation is the challenging implementation and you create multiple payroll based on the currencies involved for example if you are paying your employees in USD,EURO,GBP KWD,BHD etc. then the best option is to create multiple payrolls based on each currency type e.g.
XX Payroll KWD
XX Payroll BHD
XX Payroll USD
For this you need to create multiple elements and their links based on each currency type e.g.
Basic Salary USD,            Basic Salary KWD,                      Basic Salary BHD
House Allowance USD,     House Allowance KWD,               House Allowance BHD

_ALL: Table holds all the information about different operating units. Multi-Org environment. You can also set the client info to specific operating unit to see the data specific to that operating unit only.
_TL: are tables corresponding to another table with the same name minus the _TL. These tables provide multiple language support. For each item in the table without _TL there can be many rows in the _TL table, but all with different values in the LANGUAGE column.
_B: these are the BASE tables.
They are very important and the data is stored in the table with all validations.
If anything happens to the BASE table data, then it is a data corruption issue.
_F: these are date tracked tables, which occur in HR and Payroll. there are two date columns EFFECTIVE_START_DATE and EFFECTIVE_END_DATE which together with the PK identifies a row uniquely.
_V: tables are the views created on base tables
_VL: views for multi language tables which combines the row of the base table with the corresponding row of the _TL table where the LANGUAGE = USERENV (’LANG’).
_S: are sequences, used for finding new values for the primary key of a table.
_A: are Audit Shadow Tables
_AVN and _ACN: are Audit Shadow Views (when data was changed, and with what values

What is the difference between a Job and a Position?
Job is general one, whereas Position is specific term to its roles and responsibilities.
 POSITION:  Finance Manager, HR Manager, Junior SOFTWARE ENGINEER, (this is position which is specific to the role to be played).

Can a job have multiple positions? 
Job is generic. Yes a job can have multiple positions.

Important Tables in HRMS?
pay_element_entries_F,  pay_elements_links_F,

What is the difference between SECURED VIEWS and NON SECURED VIEWS?
1. Secured views display information only for the current period.
2. Unsecured views is used to get the information from the entire rows

APIs: Application Programmatic Interface?
 API is nothing but a logical grouping of PL/SQL packaged procedures and functions, which acts as an interface to the database.
APIs are in Oracle HRMS. For every insert/update or delete to any of the base tables, an API is available.
APIs are primarily used to validate the data being inserted into the base tables and also for inserting or updating the data on deleting the data from the base tables.

Define APIs and use in Oracle HRMS?
API’s are used in HR to insert the data into the Base tables. The user does not have 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 different types of parameters are IN / INOUT / OUT of these parameters few are mandatory, without which the process won’t complete. Generally when we use API we give data FOR: Object Version Number, Effective Date, P_Validate
HR_EMPLOYEE_api example: hr_employee_api.create_employee
hr_organization_api Example: hr_organization_api.create_organization
Every API has a number of parameters. Generally, the optional parameters are followed by a default value, e.g. p_email_address in varchar2 default null.
Control Parameters
Control parameters are the mandatory parameters common for all the APIs.
This is one of the control parameters. For insert APIs, p_object_version_number is an OUT parameter. For update APIs, p_object_version_number is an IN OUT parameter.
This is an IN parameter. It decides that the record needs to be saved to the database or not Default value for p_validate is FALSE. If TRUE value is passed, data will be validated and not saved to the database.
Note: Commit needs to be written in the code explicitly in order to save the changes done by APIs to the database.
APIs that are used to insert/update/delete the date tracked data have this control parameter. This is a mandatory IN parameter that defines the date from which the current change needs to be applied.
APIs used to update the date tracked data have this control parameter. Valid values for this parameter are: UPDATE, CORRECTION, UPDATE_OVERRIDE and UPDATE_CHANGE_INSERT
APIs used to delete date track data have this control parameter. Valid values for this parameter are: ZAP, DELETE, FUTURE_CHANGE, and DELETE_NEXT_CHANGE

List of Important APIs?
Work Structures



If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?
Responsibility level. Responsibility level will override FUNCTION level personalizations

Say you have done a lot of Personalization’s to Self Service Screens. But all these Personalization’s were done in DEVELOPMENT environment. How will you migrate these personalization’s to PRODUCTION environment?
Before 11.5.7…Use AKLOAD
This is a java program given by Oracle. This is the only way you can script it.
In DEV you will do AKLOAD DOWNLOAD ( & other parameters)
In PRD you will do AKLOAD UPLOAD ( & other parameters)
On or after 11.5.10 Use responsibility “Functional Administrator”, and then click on Personalization Tab, and then click on Import/Export.
Next select the documents to be exported.
Go to the UNIX box and tar the personalization’s into a .tar file.
On the Production environment unzip this tar file in location as entered in profile “FND: Personalization Document Root Path”.
Setting up of this profile is mandatory or else Oracle Framework wouldn’t know where to search for the files to be imported.

How to restrict iRecruitment external visitors to access only responsibilities on the external server?
Set the Server Trust Level for the server to External, Set the Trust Level of the iRecruitment external responsibilities to External too.

Is SSHR a dependency for iRecruitment?
IRecruitment has no dependence on SSHR

Does iRecruitment support “Candidate Qualifying Questionnaires” where the candidate must answer vacancy-specific questions correctly prior to submitting an application?
iRecruitment currently does not support this function, For now this can be achieved by having a set of simple questions using flexfield to get those responses and a user hook to validate them as part of the apply process.

Do we track vacancy history?
IRecruitment does not track changes to the vacancy. If changes to a field are to be traced use the Audit capability in APPs.

Following is the execution order of the test plan elements:
Configuration elements
Post-Processors (unless SampleResult is null)
Assertions (unless SampleResult is null)
Listeners (unless SampleResult is null)
Configuration Elements allow you to create defaults and variables to be used by Samplers. They are used to add or modify requests made by Samplers.
They are executed at the start of the scope of which they are part, before any Samplers that are located in the same scope. Therefore, a Configuration Element is accessed only from inside the branch where it is placed.
There are two kinds of functions:
User-defined static values(or variables): It allow the user to define variables to be replaced with their static value when a test tree is compiled and submitted to be run.
Built-in functions:
threadNum :get thread number
samplerName :get the sampler name (label)
machineIP :get the local machine IP address
machineName :get the local machine name
time :return current time in various formats
log :log (or display) a message (and return the value)
logn :log (or display) a message (empty return value)
StringFromFile :read a line from a file
FileToString :read an entire file
CSVRead :read from CSV delimited file
XPath :Use an XPath expression to read from a file
counter :generate an incrementing number
intSum :add int numbers
longSum :add long numbers
Random :generate a random number
RandomString :generate a random string
UUID :generate a random type 4 UUID
TestPlanName :Return name of current test plan
Listeners helps us to view the result of samplers in the form of graphs, trees, tables or simple text in some log files. As a Sampler component of JMeter is executed they provide visual access to the data gathered by JMeter about the test cases
JMeter functions are special values that can populate fields of any Sampler or other element in a test tree. A function call looks like this:
Variables are referenced as:
Java application designed to load test functional behavior and measure performance. It was originally designed for testing Web Applications but has since expanded to other test functions.
Apache JMeter may be used to test performance both on static and dynamic resources (files, Servlets, Perl scripts, Java Objects, Data Bases and Queries, FTP Servers and more). It can be used to simulate a heavy load on a server, network or object to test its strength or to analyze overall performance under different load types. You can use it to make a graphical analysis of performance or to test your server/script/object behavior under heavy concurrent load.

Payroll Documents:
i. Time sheets
ii. Job sheets
iii. Time recorders
iv. Payroll registers
v. Pay-in-slip (pay slip)
these are the evidence documents should be maintained by the business units, out of these pay slip is issued to the employees stating his work details and deductions made (including employer's deductions).
By default a JMeter thread will send requests without pausing between each sampler. Timers helps us to define a period to wait between each request. Example of Timers are Constant Timer, Gaussian Random Timer, Synchronizing Timer, Uniform Random Timer, Constant Throughput Timer.

Important Tables in HRMS?
PER_ASSIGNMENTS, PER_PAY_BASIS, PER_PAY_PROPOSALS, Per_all_people_F,                                            
per_person_types, per_person_type_usages, per_addresses,
per_contact_Relationships, per_periods_of_service, Per_all_assignments_f,
per_pay_groups, per_jobs, per_job_Definitions, per_grades, per_grade_definitions,
hr_all_position_definitions, hr_all_locations, pay_all_payrolls_F,
pay_element_entry_values_F, pay_element_entries_F, pay_elements_links_F,

Concurrent program status and Phases

Life cycle of a concurrent request?
A concurrent request proceeds through three, possibly four, life cycle stages or phases:
Request is waiting to be run
Request is running
Request has finished
Request cannot be run

Request is waiting for the next available manager.
Program to run request is incompatible with other program(s) currently running.
Request is scheduled to start at a future time or date.
A child request is waiting for its Parent request to mark it ready to run. For example, a report in a report set that runs sequentially must wait for a prior report to complete.
Request is running normally.
Parent request pauses for all its child requests to complete. For example, a report set pauses for all reports in the set to complete.
All requests submitted by the same parent request have completed running. The Parent request is waiting to be restarted.
Running request is terminated, by selecting Terminate in the Status field of the Request Details zone.
Request completes normally.
Request failed to complete successfully.
Request completes with warnings. For example, a report is generated successfully but fails to print.
Pending or Inactive request is cancelled, by selecting Cancel in the Status field of the Request Details zone.
Running request is terminated, by selecting Terminate in the Status field of the Request Details zone.
Program to run request is not enabled. Contact your system administrator.
On Hold
Pending request is placed on hold, by selecting Hold in the Status field of the Request Details zone.
No Manager
No manager is defined to run the request. Check with your system administrator.

Submitting Requests?

Administrators can assign individual programs/sets, all programs/sets in a request group, programs/sets belonging to one or more applications, and so on, either to the user directly or to a role that can then be assigned to one or more users.

If applications are included in the request groups, all programs/requests sets that are created in these applications will also be automatically included. Please note that request submission applies to both programs and request sets.
The following types of "instance sets" can be used for assignment (but administrators can create new instance sets based on their needs):
·         All programs in a particular request security group
·         All request sets in a particular request security group
To enable this functionality, the following are seeded:
·         Permission "Submit Request"
·         Permission "View Request"
·         Permission Set "Request Operations" containing the permissions "Submit Request" and "View Request"
·         Object "Concurrent Programs"
·         Object Instance Set "Programs that can be accessed"
·         Object Instance Set "Request sets that can be accessed"
To grant access to a request security group to a role, follow these steps:
1.      Define your role (User Management responsibility).
2.      Define your request security group (System Administrator responsibility).
3.      Define your grant (Functional Administrator responsibility).

Viewing Requests?

You can control users' access to viewing requests with RBAC.
Note: In previous releases, the Concurrent: Report Access Level profile was used to control privileges to report output files and log files generated by a concurrent program. This profile is no longer used.
Seeded "instance sets" allow administrators to grant:All requests submitted by a user
·         All requests submitted by a user for a given application
·         All requests belonging to a program submitted by a user
           All requests belonging to a request set submitted by a user


Be Independent said...

very good collection of questions nd answers

Abhishek Yadav said...

loved it

Post a Comment

Best Blogger TipsGet Flower Effect