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

A little strange it may sound first time but there are business use case where-in we want to have an absence type which should allow absence recording only if done via some specific users. Those users will be able to apply the absence for everyone but no-one else should be able to record absence apart from them.

The delivered application functionality categorises users into:

  1. Employees
  2. Line Managers
  3. Administrators

But any further bifurcation isn’t delivered. This essentially means that an absence type can be enabled only for Administrators but we cannot restrict this to ensure that only ADMIN1, ADMIN2 can record absence against it but not all other Administrators.

In this post, we would demonstrate how we can achieve this functionality through a custom solution.

So, let’s get started.

Worked Out Example

We would have to perform a series of setups to achieve this functionality. We can break them down into the following steps:

  1. Create Absence Type
  2. Create a Custom Profile Option (Assign Values to Specific Admin Users)
  3. Create a Custom Table Value Set
  4. Create a Custom Fast Formula of Participation and Rate Eligibility Type
  5. Attach the Custom Fast Formula to the Absence Type Created at Step 1
  6. Verify Results

 

Create Absence Type

We will create a simple Absence Type (say “Special Leave”) and the important attribute values are mentioned in table below:

Attribute Name

Attribute Value

Effective Start Date

01-Jan-1951

Name

Special Leave

Pattern

Generic Absence

UOM

Days

Legislative Data Group

US Legislative Data Group

Status

Active

Eligibility Type

SPECIALLEAVE_ABSENCE_TYPE_ELIG 

Enable Administrative Updates

Checked

 

A screenshot of text

Description automatically generated

 

Create Custom Profile Option

We would need to create a custom profile option (SPECIALLEAVE_ABSENCE_TYPE_VISIBLE which would hold ‘N’ at Site Level and ‘Y’ for Admin Users (HCM_IMPL7 in this example) who are authorised to record absence. All other Admin users do not have a entry here and hence they should not be able to record the absence). Details of the profile option are below:

Navigation-> Setup and Maintenance->Manage Profile Options-> Create

Attribute Name

Attribute Value

Profile Option Name

SPECIALLEAVE_ABSENCE_TYPE_VISIBLE

Profile Display Name

Special Leave Absence Type Visibility

Application

Absence Management

Module

Absence Recording

Start Date

1/1/1951

Description

Custom Profile Option created to verify whether special leave absence type is visible

Profile Option Level (Site)

Enabled (Checked), Updatable (Checked)

Profile Option Level (User)

Enabled (Checked), Updatable (Checked)

 

A screenshot of a social media post

Description automatically generated

Assign Profile Option Values

We will assign profile option values for this newly created profile option.

Navigation->Manage Administrator Profile Values->SPECIALLEAVE_ABSENCE_TYPE_VISIBLE

Profile Option Name: ALLOW_SPECIALLEAVE_ABSENCE_BOOKING

*Profile Level

Product Name

User Name

Profile Value

Site

   

N

User

 

HCM_IMPL7

Y

 

A screenshot of a social media post

Description automatically generated

 

Create a Custom Table Value Set

We will now create a custom table type value set.

Navigation-> Setup and Maintenance -> Manage Value Sets -> Create

Attribute Name

Attribute Value

Value Set Code


SPECIALLEAVE_ABSENCE_TYPE_VISIBILITY_VS

 

Description

Custom Table Type Value Set which returns the profile value assigned to SPECIALLEAVE_ABSENCE_TYPE_VISIBLE

*Module

Absence Management

Validation Type

Table

Value Data Type

Character

*FROM Clause

fnd_profile_option_values fpov , fnd_profile_options_b fpob

*Value Column Name

fpov.profile_option_value

ID Column Name

fpov.profile_option_value

WHERE Clause

fpov.profile_option_id = fpob.profile_option_id 

and fpob.profile_option_name = 'SPECIALLEAVE_ABSENCE_TYPE_VISIBLE' 

and     fpov.level_value =fnd_global.user_guid

 

A screenshot of a cell phone

Description automatically generated

 

Create Custom Fast Formula

We would now create a custom Fast Formula of Global Absence Entry Validation Type.

Navigation-> Setup and Maintenance-> Fast Formulas -> Create

Fast Formula Text

/* Formula Name: SPECIAL_LEAVE_ELIGIBILITY

   Formula Type: Participation and Rate Eligibility

   Description : Custom Global Participation and Rate Eligibility Attached to Special Leave Absence Type

   

   Change History:

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

   Version Date Created By

   1.0 22-Jun-2020 Ashish Harbhajanka

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

*/

   

lc_eligible = 'N'

lc_val_set_has_val = 'N'

lc_visibility_val = 'N'

ELIGIBLE = 'Y'


lc_val_set_has_val = GET_VALUE_SET('SPECIALLEAVE_ABSENCE_TYPE_VISIBILITY_VS')


IF ISNULL(lc_val_set_has_val) = 'N'

THEN

(

lc_val_set_has_val = 'N'

lc_visibility_val = 'N'

)

L_LOG = ESS_LOG_WRITE('Value of lc_visibility_val is: ' || lc_visibility_val)

L_LOG = ESS_LOG_WRITE('Value of lc_val_set_has_val is: ' || lc_val_set_has_val)


IF (lc_val_set_has_val = 'N')

THEN

(lc_eligible = 'N')

ELSE

    (lc_eligible = 'Y')

   

ELIGIBLE = lc_eligible


RETURN ELIGIBLE

 

A screenshot of a social media post

Description automatically generated

Create Eligibility Profile

We will create a “Eligibility Profile”.

Navigation->Setup and Maintenance->Eligibility Profiles->Create

A screenshot of a cell phone

Description automatically generated

Assign Eligibility Profile to Absence Type

Now we will attach the Fast Formula to Absence Type

Navigation->Setup and Maintenance -> Manage Absence Types -> Special Leave

A screenshot of text

Description automatically generated

 

Verifying Results

Now we will login with an ADMIN user (HCM_IMPL7) who is allowed to record absence booking for “Special Leave” and check result.

A screenshot of a social media post

Description automatically generated

 

We will now login with another ADMIN user (HCM_IMPL) who is not authorized to record the absence and verify result.

A screenshot of a social media post

Description automatically generated

 

We will verify the same from Employee Login (SANDY.KIM) and she would not be able to see the Absence Type too in the dropdown

A screenshot of a social media post

Description automatically generated

And finally, when we even try as Line Manager (AMY.MARLIN) we would see that she also is not able to view the Absence Type.

A screenshot of a social media post

Description automatically generated

Summary

So, this is how we can make use of Participation and Rate Eligibility Fast Formula to restrict visibility of an Absence Type. One can extend this logic to meet new requirements. 

And with this I would end this post.

Hope this was a good read, Thanks all for your time and have a nice day ahead.

You can download the Fast  Formula file from below:

SPECIAL_LEAVE_ELIGIBILITY_FF.sql


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

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner