Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion Blog
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Introduction

There is a business requirement that a specific type of leave can only be applied to a maximum of 6 hours per month.

This requirement can be achieved using “Global Absence Entry Validation” Fast Formula.

We would now try to demonstrate the process to accomplish the solution.

Worked-Out Example

We would need to perform the following steps:

  1. Create an Absence Type
  2. Create an Absence Plan
  3. Create a Validation Fast Formula
  4. Associate Absence Plan and Validation Fast Formula to Absence Type
  5. Verification 

Create an Absence Type

We would create an Absence Type titled “Short Emergency” which will have a UOM as hours.

Navigation: Setup and Maintenance -> Manage Absence Type -> Create

A screenshot of a social media post

Description automatically generated

 

Creating Absence Plan

Now we need to create an Absence Plan of “No-Entitlement” Type having UOM as hours.

Navigation: Setup and Maintenance -> Manage Absence Plans -> Create

 

A screenshot of text

Description automatically generated

 

Create a Validation Fast Formula

We will create a “Global Absence Entry Validation” Fast Formula.

Navigation: Setup and Maintenance -> Fast Formula -> Global Absence Entry Validation -> Create

Fast Formula Code

/* Formula Name: SHORT_EMERGENCY_ABS_VALIDATION

   Formula Type: Global Absence Entry Validation

   Description : Custom Validation Fast Formula to ensure that only 6 hours of leave can be applied in a month

   

   Change History:

   *************************************************************************************************

   Version Date Created By

   1.0 21-Jun-2020 Ashish Harbhajanka

   *************************************************************************************************

*/

DEFAULT for ANC_ABS_ENTRS_ABSENCE_TYPE_ID is 0 

DEFAULT for PER_PER_MARITAL_STATUS is ' ' 

DEFAULT for ANC_ABS_ENTRS_DURATION is 0 

DEFAULT FOR ANC_ABS_ENTRS_ABSENCE_STATUS_CD is ' ' 

DEFAULT FOR IV_TOTALDURATION is 0 

DEFAULT_DATA_VALUE for ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR is 0 

DEFAULT for ANC_ABS_ENTRS_ABSENCE_TYPE_ID is 0 


/*=========== DATABASE ITEM DEFAULTS END =====================*/ 

/*================ FORMULA SECTION BEGIN =======================*/ 

/*==============INPUTS SECTION BEGIN================*/ 

INPUTS ARE iv_start_date (date), iv_end_date (date),IV_TOTALDURATION 


ln_se_type_id = GET_CONTEXT(ABSENCE_TYPE_ID,0)  /* se stands for Short Emergency */ 

ld_abs_start_date = IV_START_DATE


lc_valid = 'Y'

ln_duration = 0

ln_new_duration = 0

ln_total_duration = 0

ld_start_date = ADD_DAYS(ADD_MONTHS(LAST_DAY(ld_abs_start_date),-1),1)

ld_end_date   = LAST_DAY(ld_abs_start_date)

   

CHANGE_CONTEXTS(START_DATE=ld_start_date, END_DATE=ld_end_date) 

(     

i=ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR.FIRST(-1)     

WHILE ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR.exists(i)      

LOOP         

( CHANGE_CONTEXTS(ABSENCE_ENTRY_ID=ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR[i])             

 ( 

CHANGE_CONTEXTS (ABSENCE_TYPE_ID = ANC_ABS_ENTRS_ABSENCE_TYPE_ID)

(

IF ( ( ln_se_type_id=ANC_ABS_ENTRS_ABSENCE_TYPE_ID) AND ( ANC_ABS_ENTRS_ABSENCE_STATUS_CD <> 'ORA_WITHDRAWN'))  

THEN            

(  ln_duration= ln_duration + ANC_ABS_ENTRS_DURATION )

i = i + 1

)              

 )

)

)


ln_new_duration = IV_TOTALDURATION


ln_total_duration = ln_duration + ln_new_duration


IF (ln_total_duration > 6)

THEN

(

VALID = 'N'        

ERROR_MESSAGE = 'XX_ANC_EXCEEDS_MAX_LIMIT'  /* 'You can only book cumulative absence of 6 hours in a month for Short Emergency Leave Type.' */        

RETURN VALID,ERROR_MESSAGE        

)         


VALID = lc_valid

RETURN VALID

 

 

Associate Absence Plan and Validation Fast Formula to Absence Type

We will need to associate Absence Plan to Absence Type.

Navigation: Setup and Maintenance -> Manage Absence Type-> Search (“Short Emergency”) -> Absence Plans and Reasons

A screenshot of a cell phone

Description automatically generated

 

Verification

As a last step, we would try to record some absences and check whether the desired functionality is achieved with above setup.

Navigation: My Client Groups-> Person Management -> Search Person -> Absence Records -> Existing Absences -> Click on (+)

A screenshot of a cell phone

Description automatically generated

 

Trying to Book another Absence on 5/5/2020

A screenshot of a cell phone

Description automatically generated

 

Booking in next month

A screenshot of a cell phone

Description automatically generated


Ashish Harbhajanka

Add comment


Security code
Refresh

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
22232425262728
2930     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner