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.

Top 5 Mistakes while implementing ERP

The promises of an integrated ERP (Enterprise Resource Planning) solution can inspire any business owner to approve a costly, time-consuming planning and execution process.  However, not all ERP implementations are successful; many end in frustration, failure and wasted resources. To prevent a disaster with your implementation, arm yourself with the right resources to avoid failure, including this article from Software ThinkTank (thinktank.net).

Thinking through the Top 5 Mistakes made when implementing an ERP system, we can identify the common problem areas most customers face and take the proper steps to avoid them.

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 III

Data Control Language (DCL) 

The Data Control Language (DCL) is a subset of the Structured Query Lanaguge (SQL) that allows database administrators to configure security access to relational databases.Two types of DCL commands are GRANT and REVOKE. Only Database Administrator’s or owner’s of the database object can provide/remove privileges on a database object.

GRANT:
Gives user’s access privileges to database.

Oracle SQL Statement Types and Usage - Part II

Data Retrieval or Query Language (DQL or DRL) :

SELECT clause will come under this category. Main usage of select to identify the result set column list.

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)

Integration of AME with Oracle EBS

Following is the list integrating applications within Oracle E-Business Suite that are enabled to integrate with AME -

• Advanced Benefits 
• Bills of Material
• Oracle Deal Management  
• Oracle Price Protection 
• Cash Management 

FRM-40654: Record has been updated by another user. Re-query to see change ..

A common problem which you might observe is  

"FRM-40654: Record has been updated by another user. Re-query to see change ...”

Application Utilities Lookups

Lookups provide lists of valid values for certain items of information. This has two key advantages: 

• It ensures that all users use the same terminology, which makes it easier to inquire and report on the information.

• It speeds up data entry because you can enter just enough to identify the value, and the system completes the entry.

In Oracle HRMS, a list of values is called a lookup type. Each value comprises a code, a meaning, and sometimes, a legislative tag.

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

Date / Time related queries

Get the first day of the month

Quickly returns the first day of current month. Instead of current month you want to find first day of month where a date falls, replace SYSDATE with any date column/value

SELECT TRUNC (SYSDATE, 'MONTH') "First day of current month" FROM DUAL

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

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.