FAQ's Oracle Hrms
FAQ's Oracle Hrms
A Workforce Measurement Type (WMT) that measures full time equivalent. Although the actual value and
calculation may vary, this value is taken from the Assignment Budget Value (ABV) in Oracle HRMS. If the
Assignment Budget Value in Oracle HRMS is not set up then a Fast Formula is used to determine the
value to be calculated.
Extra information are available in various While SIT's are all in one place (Special
locations (screens) such as: Person, Information Screen).
Assignment, Position...etc;
Securing an EIT is different than securing an Where SIT is secured through custom nodes
SIT (EIT is specific to legislation and and workflows).
responsibility.
While there is none in EIT. For each record in SIT, there is Start and
End dates
1. What are flex field Qualifiers? What is the purpose of a flex field qualifier? Why is it
needed when you can have a unique name for a segment?
Ans: Flex field qualifiers are basically used to identify the nature of the segment at the
flex field level. Qualifiers like Balancing, Cost Center, Inter Entity, Natural Account etc..,
Indicates the type of segment.
For Ex-> Normally company segment is qualified as Balancing, which will intimate that
the debits should balance the credits for a particular account for a specified company.
i.e.., for a specific GL code combinations.
Hence having unique names to the segments/flex field has no connection with this as
the purpose of the above is totally different.
1. Optionally, enter the reason for the termination. You can define valid reasons as values
for the Lookup Type: LEAV_REAS.
Note: When you enter the termination reason of deceased and an actual termination date, if
an employee's date of death has not been entered in the Other Information tabbed region of
the People window, it is set to the actual termination date.
If you use Oracle Payroll in the UK and the employee is deceased, you must select
the reason Deceased. This records the information on.
2. Enter the termination dates. Only the Actual date is required. This is the date when
the employee's person type changes to Ex-employee. The Notified and Projected
dates are for information only. The Final Process date is a date after which no
further pay processing for the employee can occur, if you are using Oracle Payroll.
If you need to process pay for the employee after his or her termination, set the Final
Process date later than the Actual date, or leave it blank.
This means that the employee's assignments are given the default user status for the HR
System Status Terminate Assignment. If there is more than one user status defined for this
system status, the system prompts you when you choose the Termination button, to select
which status to enter on the employee's assignments.
If you do not need to continue processing, set the Final Process date to the Actual date.
Note: If you are an Oracle Payroll user, you must also enter a Last Standard Process Date. This
is the last date for normal processing, while the Final Process date is the last date for late
payments. Element entries are closed down on the Last Standard Process Date, the Actual
date, or Final Process date, depending on how you have defined the elements.
3. When the information is complete, choose the Terminate button to complete the
termination.
4. KFF’s in Payroll?
Payroll:
Bank Details Flex Field, Cost Allocation Flex Field, People Group Flex Field
8. Security Profiles and if I have to see only one organization in one location and as
single operating unit? Then.
10.Absence management?
Absence Balance Information
When you define an absence type, you specify whether the application should maintain
an increasing balances, a decreasing balance, or no balance of time off. The balance is
a running total of the hours or days an employee has taken for the absence type, as
recorded in the Duration field.
11. How many types of key flex fields are there in Oracle HRMS?
Ans: Human Resources: Job Flex Field, Position Flex Field, Grade Flex Field,
Competence Flex Field, Personal Analysis Flex Field, Soft Coded Flex Field
13. Name the date track profile options with their usage?
16. What are the flex field qualifiers of Cost allocation KFF?
19. What is the difference between effective date and latest start date in people window?
Ans: Alter Effective Date Window is to set the effective date and remove the end date.
Latest start date is the date when the new employee joins the company on the
effective date.
Ans: REC_TYPE
Leaves the person type unaltered. However, you can update the person type manually
to indicate that the employee is on secondment, for example.
In the destination business group, HRMS creates or updates employee assignment, and
contact records using information from the deployment proposal. The person type and
assignment status are those entered in the deployment proposal for the new
assignment.
Go to Organization, click on business group and select the option under business group
info and make the employee generation number as manual or automatic.
26. IF THE CUTOFF IS 21-JAN-2011 AND NEW EMPLOYEE JOINS ON 25-JAN-2011, WHAT IS
THE PROCEDURE TO GET THE PAY FOR NEW EMPLOYEE?
ANS: RUN QUICK PAY
Flexfield qualifier identifies segment in a flexfield and segment qualifier identifies value in a
segment.
There are four types of flexfield qualifier 1) Balancing segment qualifier 2) cost center 3)
natural account and 4) intercompany
segment qualifier :- 1) allow budgeting 2) allow posting 3) account type 4) control account
and 5)reconciliation flag
Is it possible to enable/disable only few fields of any DFF?
Yes, it is possible to enable or disable few fields in DFF by using Check Box
Yes this can be done with Custom.pll It has a procedure call Event.In this procedure u
can capture events like when-new-form-instance,when-new-item-instance etc So
capture tht event on which u want to disable your DFF and use
name_in('system.current_form/item') to know the name of ur DFF and then using form
built-in
Standard DFF's are given by Oracle. We need not register. We can register
only Custom DFF’s.
How do I enter the default value of Key flex field or DFF segment?
What is the difference between key flex field and Descriptive flex field?
Key Flexfield is used to describe unique identifiers that will have a better meaning than
using number IDs. e.g a part number, a costcentre etc
DFF:-
->USED TO CAPTURE EXTRA INFORAMATION FROM ENDUSER
->WE HAVE CONTEXT FIELD
->MAX DFF'S REGISTER
->USED ATTRIBUTE COLUMNS
->DFF ACCEPTS WHAT EVER DATA FROM
END USER
Context Sensitive segments in descriptive FFs are segments which can be made
available or not based on the values entered by the Users in a 'Context' field. This helps
in building a value based logic for the FF
Based on our requirements we categorize the employees in to groups for easy identification
purpose.
How do I enable a database column to use it in a DFF segment?
Open Flexfield => Descriptive=>Register and query required DFF. Click on "Columns"
button enable/disable required columns there.
Which procedure should be called to enable a DFF in a form?
FND_DESCR_FLEX.DEFINE (BLOCK => 'BLOCK_NAME'
,FIELD => 'FORM_FIELD_NAME'
,APPL_SHORT_NAME => 'APP_NAME'
,DESC_FLEX_NAME => 'DFF_NAME'
);
How many flexfields are there in total modules
There are Two types of flexfielld they are
2. keyflexfield
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 are Budgeted through providing
the Costing information trhough the Cost Allocatiion Flex Field details in respective windows.
Even the employee pay and facilities are also been costed and allocated through the same
Cost Allocation Flexfield information.
All these expenses are later transferred to General Ledger, to have an overall accounting at
one particular point
PER_ALL_PEOPLE_F
PER_ALL_ASSIGNMENTS_F
HR_ALL_ORGANIZATIONS_UNITS
PER_LOCATIONS_ALL
PER_POSITION_DEFINITAION
PER_POSITIONS
PER_GRADES
PER_JOBS
PER_PERSON_TYPES
PER_ASSIGNMENT_TYPES
PER_PERSON_TYPE_USAGE
PER_PEOPLE_EXTRA_INFO
PER_DISABILITIES
PER_QUALIFICATIONS
PAY_PEOPLE_GROUP
Well date tracking is a feature in Oracle HRMS esp with all tables whose names end with _F
eg: per_all_people_f. Now what happens here is we cannont purge a record what we can do is
end date a record and if we need to create an extension eg: of an assignment then we end-
date the assignment and on a new record that is appended to the table we create a new
record with starting date after the end date and can restate the assignment, used in cases of
Re-hire after end of assignment or in the extension of assignment beyond the end date. It
helps Oracle maintain historical data and hence the tables are data trackable.
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.
RE: What are the advantages of Oracle HRMS over peoplesoft HRMS?
Oracle HRMS is more secured than People Soft HRMS.
Qns 2:
Say you have done a lot of Personalizations to Self Service Screens.
But all these Personalizations were done in DEVELOPMENT environment.
1. Regular pay
2. Quick pay
3. SSHR
Oracle Self-Service Human Resources. An HR management system using an intranet
and web browser to deliver functionality to employees and their managers.
4. iRecruitment
iRecruitment is a web-based recruitment solution that enables your enterprise to
manage all recruitment activities using a single self-service interface and provides an
easy-to-use interface for job seekers as well.
iRecruitment includes a separate homepage for each group of iRecruitment users: site
visitors, registered users, managers, recruiters, and agency users. The homepages
outline the iRecruitment functions available for each user, and provide direct access to
these functions.
Well date tracking is a feature in Oracle HRMS esp. with all tables whose name sends with _F
eg: per_all_people_f. Now what happens here is we cannot purge a record what we can do is
end date a record and if we need to create an extension e.g.: of an assignment then we end-
date the assignment and on a new record that is appended to the table we create a new
record with starting date after the end date and can restate the assignment used in cases of
Re-hire after end of assignment or in the extension of assignment beyond the end date. It
helps Oracle maintain historical data and hence the tables are data track table.
HRMS includes Payroll, but we have Payroll as a separate application when query KFFs. There
are 10 KFFs in HRMS.
1. Job KFF
2. Position KFF
3. Grade KFF
4. Competence KFF
5. People Group KFF and 6. Cost allocation KFFs are part of Payroll Application.
Above six are mandatory KFFs which we need to create before creating BG.
7. Personal Analysis KFF (based on the requirement) Example: Special Information Type
8. CAGR KFF (If there exists structured Unions and contingent workers) this will not be used
normally.
9. Soft Coded KFF.
10. Bank Details KFF (if there is no localization for the country we need to create the structure)
There are many tables used in HRMS. I have listed some tables.
PER_ALL_PEOPLE_F
PER_ALL_ASSIGNMENTS_F
HR_ALL_ORGANIZATIONS_UNITS
PER_LOCATIONS_ALL
PER_POSITION_DEFINITION
PER_POSITIONS
PER_GRADES
PER_JOBS
PER_PERSON_TYPES
PER_ASSIGNMENT_TYPES
PER_PERSON_TYPE_USAGE
PER_PEOPLE_EXTRA_INFO
PER_DISABILITIES
PER_QUALIFICATIONS
PAY_PEOPLE_GROUP
There are many tables which are important under HRMS but to name some of them
1) HR_POSITIONS
2) PER_ASSIGNMENTS
3) PER_PAY_BASIS
4) PER_PAY_PROPOSALS
5) HR_ORGANIZATIONS
6) HR_ORGANIZATION_UNITS etc..,
It’s been a while since I worked on Oracle apps but still I am sure these are correct tables.
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_POSITIONS,
HR_ALL_POSITION_DEFINITIONS,
HR_ALL_LOCATIONS,
PAY_ALL_PAYROLLS_F
PAY_ELEMENT_ENTRY_VALUES_F,
PAY_ELEMENT_ENTRIES_F,
PAY_ELEMENTS_LINKS_F,
PAY_ELEMENT_TYPES_F
S?
10. 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.
11. What are the advantages achieved by an organization by using Oracle HRMS?
1. Using Oracle HRMS you have a single source of employee info which can be leveraged
using other modules of Oracle Apps. It also provides integrated multi org structure
which can be effectively used in other modules of Apps. It also defines structured group
job grade roles etc which are required for the successful operation of an organization.
2. 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.
3. Remember the pyramid kind structure: People, WS and Compensation benefits with
Assignments being the basis.
4. This model is both flexible and adaptable. It is flexible so that you can reflect the needs
of different companies or different groups within the same company. It is adaptable so
that you can easily change the basic model as your enterprise changes.
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 Set
Full Applicant Details Report
Full Assignment Details Report
Full Person Details Report
Full Work Details Report
Job and Position Skills Matching Report
Organization Hierarchy Report
Position Hierarchy Report
Requisition Summary Report
Salary Review Report
Skills Matching Report
Staffing Budget Details Report
Terminations Report
Examples;
Customization means we are customizing the standard object (Report/Form) which is provided
by oracle applications.
Interface means which data comes from third party and we are loading into the system.
Configuration means just like installation of software.
In layman's wording:-
Customization means changing the source code of forms.
Interfacing is used for importing/exporting data from any third party software
Configuration means enabling the setup for business requirement.
When an 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 .It means you reverse the process and retain the employee…When you reverse
terminate the process the termination details are cleared and his employment details
continues with the same assignments and with the same service period.
attribute