Human Resource Budgets

In Oracle HRMS, we can define non-monetary budgets, such as headcount or full-time equivalents (FTEs) that are based on organization’s work structures. Budgets can be defined against an organization, job, grade, position, or any combination of these. You can monitor the budgets by comparing the budget values with actual values derived from employee assignments.

For example, you might define a headcount budget of two for the position Marketing Manager. The variance of the actual value from the budget value depends on the number of employees assigned to that position at any time. A negative variance indicates a vacancy.

3 signs to tell you to bring in an HRMS Consultant

When you are selecting and implementing a new HRMS the stakes are high and mistakes can be costly. An external consultant can provide guidance but the impact to your project budget may cause you to think twice. However an external consultant may be the tipping point that makes your project successful. Here are 3 signs that your HRMS selection and implementation project would benefit from a consultant’s services.

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:

Oracle SQL Statement Types and Usage - Part I

Let me introduce SQL by statements type, here statements defines set of commands. Generally statements can fall under the following category

• Data definition Language (DDL)
• Data Retrieval or Query Language (DQL or DRL)
• Data Manipulation Language (DML)
• Data Control Language (DCL)
• Transaction Control Language (TCL)

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 III

1. What is the difference between Extra Information Type (EIT) and Special Information Type (SIT)?

EIT and SIT Both are provided by Oracle to Capture Extra Information. Following are the main differences:

• EIT is based on DFF whereas SIT is based on KFF of Person Analysis
• EIT is stored in PER_EXTRA_INFO tables where as SIT is store in PER_PERSON_ANALYSES and PER_ANALYSIS_CRITERIA tables

HR and PAYROLL Interview Preparation - Part II

1. What is Date Track concept in Oracle HRMS?

Oracle HRMS has a date track feature which enables to maintain past, present and future state of data. It enables 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

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

Absence Management - Basic Setup

This article will get you going with the very elementary setup of absence management. For relatively complex concepts like accruals, holiday calendar, etc. will be taken in future posts.

HRMS and PAYROLL Key Flexfields - Part I

In this document I will try to propose a possible way to configure the KFF’s one by one of HRMS & Payroll. One should keep in mind that this is not something carved in stone and the design should be finalized only after thorough study of business and understanding of client’s requirement is done.

Oracle Payroll Taxonomy

For starters, we must know the most common terms associated with Oracle Payroll. We must know the processes and taxonomy in order to understand the basics easily, so here we go.

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.

HR Security Profile - Part I

As part of your implementation plan, you identify who will use Oracle HRMS, what information they require, and how they use it. You can control a user's access to database elements such as records, fields, forms, and functions, and you can also control a user's access to other user records and data.

Table Joins in SQL - Part I

In Oracle as data is not stored in a single table, we usually have to draw data from multiple tables together in a meaningful way. To show this data from multiple tables in one query, Oracle allows us to perform table joins. 

Behavior of DateTracked Forms

This section describes the behavior of forms that incorporate DateTracking. When you begin to update or delete a record on a DateTracked form, you are prompted with a number of choices. This section describes the choices and their effect on the DateTracked table.The term "today" refers to the effective date set by the user.

DateTrack Feature in HRMS

Being an engineer i always had difficulty handling concept of ‘Date’. However through this article I would try to explain my understanding of DateTrack feature in Oracle Apps.

DateTrack adds the dimension of time to an application's database. It is a means of maintaining a history of changes to personnel records. The value of a DateTracked record depends on the date from which you are viewing the data. It applies to the People and Assignment details of a person’s record in Oracle HR. Each of the areas that are date tracked within a record are date tracked independently. 

Payroll Costing - Introduction

This is one of the most important and vital feature of Oracle Payroll and HRMS on the whole. It’s through the Costing that Human Resources interact with the Oracle Financials (GL). Costing as a concept is to account the cost incurred on an employee in terms of compensation provided to him/her by the organization. Oracle achieves this through three processes - 

What are APIs?

Application Program Interfaces (APIs) are standard stored procedure, package or functions created for performing specific activities like employee creation, assignment creation, etc There are 3 types of APIs which exists in EBS.

Table vs. View – Any difference?

Many of us might struggle to give a precise answer to this question. This article might just help ..

The difference between a view and a table is that views are definitions built on top of other tables (or views), and do not hold data themselves. To put it in simple words, a view is a virtual table which also consists of rows and columns just like a table. Views have no direct or physical relation with the database.

Imp HR and Payroll Tables - Part IV

>> PAY_PAYMENT_TYPES

This payroll table holds details of the payment types that can be processed by the system. Used to define specific payment methods in PAY_ORG_PAYMENT_METHODS_F

>> PAY_ORG_PAYMENT_METHODS_F

This payroll 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