Fusion HCM - For Starters

Here are few terminologies in Fusion that we need to look at - 

• Legal Employer - an entity that employs the workers. A legal employer is captured at the work relationship level. And all the employment terms and assignments within that relationship will automatically get assigned to that legal employer.

Extracting maximum benefit out of you Payroll Data

Unused or underutilized payroll data causes wasted HR staff time, as duplicated efforts and work often ensue to make up for this data gap. Here are several significant areas where your HRMS payroll data can add value to your business:

HR and PAYROLL Interview Preparation - Part IV

1. What is the Process to Reverse a Termination of employee?

You reverse a termination in order to make an employee active again.

Navigation: HR Responsibility >> Enter & Maintain >> Others >> End Employment

Search for the separated employee record  and click on ‘Reverse Termination’ button to undo the termination of an employee. As a result the person will become active employee again.

HR and PAYROLL Interview Preparation - Part I

In the next few posts I’ll post a collection of Oracle HRMS related questions which might prove useful for interview preparation

1. Can you call pl/sql package functions from within a Fast Formula?

Yes, It is done through Define Function screen in HR. In this screen we can register the pl/sql as “External Function” and reference it in Fast formula definition

Business Process terminologies explained with a real life example

The below example explains a few of the important terms and concepts used in the Oracle E-Business Suite. This would be a good starting point for the beginners to better understand the concepts behind Oracle Applications

HR Security Profile - Part II

Restricting Access to Records

You set up a security profile by identifying records of employees, applicants, contingent workers, and candidates in the system which you want users to be able to access. You identify the records by selecting work structures or other criteria in the application to which employees, applicants, contingent workers, or candidates are attached. For example, you could give users access only to the records of employees, applicants, contingent workers, or candidates in a single organization.

SQL Queries - Payslips

Here are two queries which can be used for fetching employee salary details. The user has to replace the classifications and element names with appropriate ones. The user can also add more elements in query no.2 to display more elements

1. SQL query to display employee salary (classification wise)

Imp HR and Payroll Tables - Part III

>> HR_ORGANIZATION_UNITS

This table holds the definitions that identify business groups and the organization units within a single business group. Additional information about classifications and information types for each organization is held in HR_ORGANIZATION_INFORMATION

Imp HR and Payroll Tables - Part II

>> PER_ADDRESSES

Holds address information for current and ex–employees, current and ex–applicants and employee contacts. Addresses have a specific address STYLE that identifies the address format for a specific country, or territory. A person may have more than one address at any one time, and each address can be in a different style.

The PRIMARY_FLAG identifies the primary address. Primary addresses are not DateTracked, but they are contiguous and cannot overlap. From the first date a person has an address to the last date they have an address, a person must have one primary address. Any secondary address can be disabled by entering a value in DATE_TO.