Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion PayRoll
  • 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

In this article, we will try to show how to use a Participation and Rate Eligibility’ Formula in Oracle Fusion Applications. This formula would work both for a Cloud as well as On-Premise Environment.

But before we delve deep into the topic let us try to understand what is meant by a Fast Formula. In the simplest terms a Fast Formula is a Code Snippet which allows us to add conditional logics (IF-ELSE constructs) and provide a way to customize the seeded solution . They are used across various places in the application with some of the most commonly known ones being Absence Management, Payroll, HCM Extracts, Benefits...etc. Some sample Fast Formulas of different types along with real project use cases may be referred via below links:

  1. Global Absence Accrual Fast Formula

  2. Global Absence Accrual Matrix Fast Formula

  3. Global Absence Entry Validation Fast Formula

  4. Global Absence Vesting Period Fast Formula

Also you may feel free to refer An Overview of Fusion Absence Management which demonstrates how a Fast Formula is used effectively to meet several business requirements in Absence Management Module.

But let-us come back to the current topic of ‘Participation and Rate Eligibility’ Fast Formula. This type of Fast Formula is used to determine custom logic to determine the participation eligibility of a population in a specific Absence Plan, Benefits Plan, Goal, Performance Document….

Business Requirement

Customer has configured a ‘Marriage Leave’ Absence Plan and they want to ensure that married Individuals who belong to either Assignee, OTP, Resident as Employee Category (which is configured as a Descriptive Flex-field Attribute namely PER_ASG_ATTRIBUTE5) should not be able to view the Absence Type on the Absence Entry Screen. Since there would be in numerous conditions via which individuals would be qualified as eligible we would add explicit conditions to set them ineligible and all others would be eligible.

The above details when captured in a Fast Formula the fast formula would be as below:

Formula Content

/***************************************************************************

FORMULA NAME: XX_ANC_ELIG_ASGTYPE_MARSTATUS_Married_NOAssignee_OTP_Resident

FORMULA TYPE: Participation and Rate Eligibility Formula

DESCRIPTION: This formula returns a 'Y' if the employee is married and not a Assignee, OTP, Resident

Change History:

Name Date Comments

---------------------------------------------------------------------------------

Ashish Harbhajanka 8-May-2015 Initial Version

*******************************************************************************/

DEFAULT FOR PER_PER_MARITAL_STATUS_MEANING IS ' '

DEFAULT FOR PER_ASG_ATTRIBUTE5 IS ' '

ELIGIBLE = 'N'

IF ((PER_PER_MARITAL_STATUS_MEANING = 'Married') AND (PER_ASG_ATTRIBUTE5 = 'Assignee'))

THEN(ELIGIBLE = 'N')

ELSE IF ((PER_PER_MARITAL_STATUS_MEANING = 'Married') AND (PER_ASG_ATTRIBUTE5 = 'OTP'))

THEN(ELIGIBLE = 'N')

ELSE IF ((PER_PER_MARITAL_STATUS_MEANING = 'Married') AND (PER_ASG_ATTRIBUTE5 = 'Resident'))

THEN(ELIGIBLE = 'N')

ELSE IF ((PER_PER_MARITAL_STATUS_MEANING = 'Married') AND (PER_ASG_ATTRIBUTE5 = 'XX Assignee'))

THEN(ELIGIBLE = 'N')

ELSE IF ((PER_PER_MARITAL_STATUS_MEANING = 'Married') AND (PER_ASG_ATTRIBUTE5 = 'XX OTP'))

THEN(ELIGIBLE = 'N')

ELSE IF ((PER_PER_MARITAL_STATUS_MEANING = 'Married') AND (PER_ASG_ATTRIBUTE5 = 'XX Resident'))

THEN(ELIGIBLE = 'N')

ELSE IF ((PER_PER_MARITAL_STATUS_MEANING = 'Married') AND (PER_ASG_ATTRIBUTE5 = ' '))

THEN (ELIGIBLE = 'Y')

RETURN ELIGIBLE

Steps to Create Fast Formula within the Application

Yep… we need to login to the application first with a user who has an Application Administrator Role Assigned (we will use HCM_IMPL user for this example)

 

Once you click on login we would land up on the Homepage

 



Next we need to click on the Navigator Icon on top left hand side and Click on ‘Setup and Maintenance 

 

Next we need to click on ‘Setup and Maintenance’ and this would bring us to the Functional Setup Manager page:

 

Next we need to search for ‘Manage Fast Formula’ Task

 


Next we need to click on the ‘Manage Fast Formulas’ Task and this would take us to a UI Screen where we can search and edit existing fast formulas as well as create a new one (using the + symbol)

 

We need to populate the below details:

The UI screen once populated would appear as below:

PR8

Once we click on continue

And now we need to add the Formula Content into the Formula Text Area

 

clip_image001.png We could see that the compile status shows a (X)  and that’s because we have not saved and Compile the same

PR11

Once we click on ‘OK’ we could see that the compile status icon has changed from (X)  to ( )

 

Next we should click on the ‘Done’ button on top right hand corner of the page and we would land up on the ‘Search Fast Formula’ Page'

 

In order to confirm that the fast formula is successfully created we should search for the same here and when we type the Fast Formula Name in the Formula Name field:

PR14

Yipeee!!  We can find the Fast Formula and the compilation status is also set to compiled.

And with this we have reached the end of this article.

This is just a simple prototype showcasing the capabilities of Participation and Rate Eligibility Fast Formula and many more complex things can be achieved using the same. Do give a try and feel free to reach out to us in-case you need any specific inputs/ suggestions.

Thank You for your time and have a nice day!!


Ashish Harbhajanka

Comments   

0 #1 онлайн дневник 2022-08-11 04:19
Your style is so unique in comparison to other folks I've read stuff from.
Many thanks for posting when you've got the opportunity,
Guess I will just bookmark this blog.
Quote
0 #2 calendário em branco 2022-08-12 18:13
Ꭲhankfuⅼness too my father whoo shared with me concerning this blog,
this blog іs genuineⅼy aѡeѕome.

Herre is my webpage - calendário em branco: http://amesinstrumentcompany.com/__media__/js/netsoltrademark.php?d=earnvisits.com%2Findex.php%3Fpage%3Duser%26action%3Dpub_profile%26id%3D264865
Quote
0 #3 modelo de calendário 2022-08-15 13:36
Appreciation tⲟ my father whο informed mme aƅout this blog, this blog is truly aweѕome.



My web blog modelo
de calendário: http://brewdirect.net/__media__/js/netsoltrademark.php?d=mycustom.top%2Findex.php%3Fa%3Dstats%26u%3Dmei63y83715
Quote
0 #4 january calendar 2022-08-19 04:01
I love your blog.. very nice colors & theme. Did you design this website
yourself or did you hire someone to do it for you? Plz reply as I'm looking to create my own blog and would like to find out where u got this from.
cheers

my website; january calendar: https://mootools.net/forge/profile/calendar
Quote
0 #5 calendário de maio 2022-08-19 09:56
Hello there, just became alert to your blog through Google, and found that it is
really informative. I'm going to wattch oout for brussels.I will be grateful if you continue this in future.
A lot of people will be benefited from yoir writing. Cheers!


my webpage; calendário de maio: https://linktr.ee/7.calendar.pt
Quote
0 #6 шаблон дневника 2022-08-21 18:33
I blog often and I seriously appreciate your information. Your article has really peaked
my interest. I'm going to book mark your website and keep checking for
new details about once a week. I subscribed to your RSS feed as well.


Here is my website шаблон
дневника: https://vc.ru/life/477671-dorogoy-dnevnik-kak-ezhednevnye-zapisi-proishodyashchego-i-refleksiya-vliyayut-na-zdorove-nastroenie-i-pamyat
Quote
0 #7 二月日历可打印 2022-08-22 04:46
Good article. I'm facing many of these issues as
well..

Also visit my site ... 二月日历可打印: https://weibo.cn/sinaurl?u=https:%2F%2F7calendar.com%2Fcn%2F
Quote
0 #8 дневник 2022-08-22 17:20
Right here is the right webpage for anybody who really wants to find out about this topic.
You understand a whole lot its almost tough to argue with you (not
that I actually will need to…HaHa). You definitely put a
fresh spin on a subject that's been discussed for many years.

Great stuff, just great!

Here is my web site :: дневник: https://vc.ru/life/477671-dorogoy-dnevnik-kak-ezhednevnye-zapisi-proishodyashchego-i-refleksiya-vliyayut-na-zdorove-nastroenie-i-pamyat
Quote
0 #9 coloring pages pdf 2022-08-24 20:36
Hi every one, here every person is sharing such familiarity, so it's pleasant to read this website, and I used to pay a visit this weblog every day.


my blog post: coloring pages pdf: https://linktr.ee/coloringly
Quote
0 #10 Printable calendar 2022-09-06 00:53
Useful info. Lucky me I found your web site by accident, and I'm surprised why
this coincidence did not took place in advance!

I bookmarked it.

Check out my site :: Printable calendar: https://indigorosee.com/2021/01/24/how-to-prepare-for-a-successful-semester/
Quote
0 #11 打印日历 11 月 2022-09-17 01:50
Appreciate this post. Let me try it out.

Here is my web-site - 打印日历 11 月: https://www.guhub.top/
Quote

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