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:
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:
Once we click on continue
And now we need to add the Formula Content into the Formula Text Area
We could see that the compile status shows a (X) and that’s because we have not saved and Compile the same
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:
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!!
Comments
Many thanks for posting when you've got the opportunity,
Guess I will just bookmark 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
My web blog modelo
de calendário: http://brewdirect.net/__media__/js/netsoltrademark.php?d=mycustom.top%2Findex.php%3Fa%3Dstats%26u%3Dmei63y83715
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
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
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
well..
Also visit my site ... 二月日历可打印: https://weibo.cn/sinaurl?u=https:%2F%2F7calendar.com%2Fcn%2F
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
my blog post: coloring pages pdf: https://linktr.ee/coloringly
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/
Here is my web-site - 打印日历 11 月: https://www.guhub.top/
RSS feed for comments to this post