Thursday, June 11, 2015

Implement Skip Rule using Fast Formula in Oracle HRMS R12


Scenario
----------
Employer wants to give quarterly bonus(Supplemental Earnings) to the employees.

Step1: (Create Element)

Navigation:

HRMS Responsibility ->Total Comp-> Basic -> Earnings

Name: QUARTER_BONUS
Reporting name: QUARTER_BONUS
Classification: supplemental Earnings
Category: bonuses
Type : Recurring
Last Standard Process
Calculation rule: Flat amount
Save 

Step2: (Link this Element with Payroll)
HRMS Responsibility ->Total Comp-> Basic -> Link
Search your earning and link to payroll 

Step3: (Write Fast formula for Skip Rule)

Navigation:
HRMS Responsibility ->Total Comp-> Basic -> Fast formula -> Write Formula

Name : xx_once_per_quater
Type:  element skip
Click on Edit-> Fast Formula is written here

Structure of Fast Formula
/*************************************************
FORMULA NAME:  XX_ONCE_PER_QUARTER
FORMULA TYPE: ELEMENT Skip
Description: Formula to process once every quarter for monthly payroll
*********************************/
Default for PAY_PROC_PERIOD_NUMBER is 0
SKIP_FLAG = ‘Y’
IF
PAY_PROC_PERIOD_NUMBER = 3 OR
PAY_PROC_PERIOD_NUMBER = 6 OR
PAY_PROC_PERIOD_NUMBER = 9 OR
PAY_PROC_PERIOD_NUMBER = 12 THEN
(
SKIP_FLAG = ‘N’
)

RETURN SKIP_FLAG

CLICK ON VERIFY-> Save

Step4: (Associate this Skip Rule to the element)

Navigation
HRMS Responsibility ->Total Comp-> Basic->Element Description
Query your earning element (QUARTER BONUS)
in the skip rule field give name of the skip rule
That is XX_ONCE_PER_QUARTER
Save

No comments:

Post a Comment