Creating 90 Days Absence Plan

05/01/2021 Creating 90 Days Absence Plan
LOGIN REGISTER
HOME TRAININGS FUSION BLOG EBS BLOG
AUTHORS
CONTACT US
Oracle Gold Partners, our very popular training

packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.
SEARCH COURSES
Search Packages / Online Trainings
CREATING 90 DAYS ABSENCE SEARCH

TRAININGS
PLAN
Search Pa
We're Online!
https://apps2fusion.com/oracle-fusion-online-training/165-oracle-articles/2627-creating-90-days-absence-plan 1/27
Details 
Category: Oracle Articles
Published: 08 October 2020

FULLY
VERIFIABLE
TESTIMONIALS
Vote 5 Rate
Like 0 f Share Tweet

Share
Introduction
Business Requirement is: + FUSION APPS TRAIN

CKAGE
1. A Frontloaded Accrual Plan where employee should get y informative course
enrolled automatically on the hire date vided coverage on many as
he R12 & Fusion Trainings
2. Employee should get de-enrolled on the 90th day
ning material was g
3. Employee will accrue hours equivalent to 3 working days.
Read Full Testim
4. Any used balance on the end of 90th day should expire
5. Absence cannot be booked against the plan after 90th day Praveen Sriniv
Solution ://www.linkedin.com/in/pra
The solution would involve performing various steps which are:

All Testimonial
1. Creating a “Global Absence Accrual Matrix” formula to
ensure Accrual is equal to hours employee works in 3 days.
(So if a employee is 8 hours worker his accrual will be 24
hours, for 6 hour worker it will be 18 hours) APPS2FUSION -
2. Creating a Derived Factor based on Length of Service (This EVENT LIST
will be used to create a eligibility profile which will
determine whether a employee is eligible to remain enrolled << Jan 2021 >>
Mon Tue Wed Thu Fri Sat S
in the plan or not)
1 2
3. Creating a Eligibility Profile based on the Derived Factor
4 5 6 7 8 9
created in step 2
11 12 13 14 15 16
4. Configure Absence Plan
18 19 20 21 22 23
5. Configure Absence Type and Associate Plan configured in 25 26 27 28 29 30
step 4 with the absence type
6. Hire an employee
We're Online!
7. Manually calculate the 90th Working Day and run “Update

Accrual Plan Enrolments” scheduled process for the plan Search ...
created in step 4 (This should be a daily scheduled process
Search
for this solution to work)
8. Record Absences and Verify Results

ENQUIRE FOR
Creating Global Absence Accrual Matrix TRAINING
A Global Absence Accrual Matrix formula needs to be created which

will calculate the accrual value dynamically.
In summary,
Assuming an employee is a 5 day worker with weekly working hours

as 40 his accrual should be 40/5 * 3 = 24 hours
Similarly, if he is a 5 day worker with weekly working hours as 45 his

accrual should be 45/5 * 3 = 27 hours
Since the value depends on the employee’s Assignment Working

Hours field which will vary for each employee we will use a fast
formula to dynamically calculate the value.
The Logic of the fast formula is below:
ANC_90_DAYS_PLAN_ACCRUAL
/***************************************************************
FORMULA NAME: ANC_90_DAYS_PLAN_ACCRUAL
FORMULA TYPE: Global Absence Accrual Matrix
DESCRIPTION: This sample formula returns accrual for 3 working days conve
Change History:
Name Date Comments
------------------------------------------------------------------------------------------------
-----------
Ashish Harbhajanka 03-Oct-2020 Initial Version
------------------------------------------------------------------------------------------------
-----------
****************************************************************
/*=========== DATABASE ITEM DEFAULTS BEGIN ===============
DEFAULT FOR PER_ASG_PERSON_NUMBER is 'X'
We're Online!
DEFAULT FOR PER_ASG_NORMAL_HOURS is 0
DEFAULT FOR PER_ASG_FREQUENCY is 'Z'

DEFAULT FOR PER_ASG_FREQUENCY_MEANING is 'XYZ'
/*=========== DATABASE ITEM DEFAULTS ENDS================ Enter The Below De

First Name*
lc_person_number = PER_ASG_PERSON_NUMBER
ln_asg_normal_hours = PER_ASG_NORMAL_HOURS
Last Name*
lc_asg_frequency = PER_ASG_FREQUENCY
lc_asg_freq_meaning = PER_ASG_FREQUENCY_MEANING
Email*
L_DATA = ESS_LOG_WRITE('ln_person_number: ' || lc_person_number)

L_DATA = ESS_LOG_WRITE('ln_asg_normal_hours : ' || to_char(ln_asg_norm Country Code*
-None-
L_DATA = ESS_LOG_WRITE('lc_asg_frequency: ' || lc_asg_frequency)
L_DATA = ESS_LOG_WRITE('ln_asg_freq_meaning: ' || lc_asg_freq_meaning Phone*
IF (lc_asg_frequency = 'W') Enter your enquiry*

THEN
( Training of your interes
ln_accrual = ROUND(((ln_asg_normal_hours / 5) * 3),2)
) Enter the Captcha
accrual = ln_accrual
L_DATA = ESS_LOG_WRITE('ln_accrual: ' || to_char(ln_accrual))
Reload
RETURN accrual
Submit Reset
Creating Derived Factor Based on Length of Service
A derived factor needs to be created based on the Length of Service,

this will be used to determine whether a employee is eligible to remain
enrolled in the plan or not.
We're Online!
ARTICLES
Apps2Fusion
Articles
GET EMAIL
UPDATES
Creating Eligibility Profile Enter your email addre
A new eligibility profile will be created which will make use of “Less
than 90 Days” derived factor Subscribe
Powered by Google
FeedBurner
Configure Absence Plan
Plan Attributes Tab:

We're Online!
Participation Tab:
Accruals Tab:
Entries and Balances Tab:
We're Online!
Creating Absence Type
Type Attributes Tab:
Plans and Reasons Tab:
Display Features:
We're Online!
Action Items Tab:
Hire an Employee
We're Online!
Run “Update Accrual Plan Enrolments” Scheduled Process
Record Absences and Verify Results
Balance on Hire Date (10/2/2020)
We're Online!
Recording First Absence
Recording Second Absence
Recording Third Absence
We're Online!
Trying to Book 4th Absence (When Balance has exhausted)
Trying to record Absence on 91st Day
Summary
So we can summarise that the employee is not able to record any

absence on or after 91st working day.
We're Online!
In nutshell the summary is:

Employee Plan Enrolment Start Date: 10/2/2020
Periodic Accrual: 24 hours on 10/2/2020
Absences Recorded on 10/5/20 , 11/18/20 and 12/14/20 for 8 hours
each
Employee Plan Enrolment End Date: 12/31/2020 (90th day)
ASHISH HARBHAJANKA
 Prev Next 
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
We're Online!
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
........
MORE ARTICLES FROM THIS AUTHOR
Control Absence Type Visibility Based on Plan Balance
Control Absence Type Visibility Based on Plan BalanceV3
At Least One Parameter Value Required
Smart Navigate to Person Management from Report
Output Column
Stop Accruing Leaves when Employee on Leave of
Absence
Displaying Impacted Assignment Details when Position
De nition is changed
Allow Absence Recording After 50 Calendar Days from
Hire Date
Restrict new absence recording during system upgrades
in Oracle HCM Cloud Absence Management
Diagnostic Test to nd Duplicate MCPD Assignment
Records created by Position Synchronization ESS
Impact of Vesting And Waiting Period On Absence
Accrual Plan Balance
Performing Mass Assignment Change In Oracle HCM
Cloud Release 13 20A
Control Report Execution based on user roles
Extract Failed Lines Feature in HCM Data Loader
Allow Absence Recording by Speci c Admin Users
We're Online!
Restrict Changes on Approved Historical Absences

A Worked out Example of using Message Token in Oracle
HCM Cloud
A brief Overview of Extracts Process Diagnostic Report
An Overview of Master Report - Absence Data Integrity
Detection
Absence Setup to Restrict Absence Recording to 6 hours
per month
Download Report Data Via Single Click in Oracle HCM
Cloud Application
Generating DOR Letters - New Feature in Release 13 20B
An Overview of Donation Plan and Its Usage in Oracle
Cloud Absence Management
Creating Custom ESS Job to Get Employee Absence Plan
Balance
Automating Absence Plan Discretionary Disbursement in
Oracle HCM Cloud
A How-To Article Illustrating Process to Hide Quick
Actions in RUI
Schedule a BI Publisher Report Based on Custom Fast
Formula
Alternative Absence Flow on Overbooking Absence
Password Protect an OTBI Output File in Oracle HCM
Cloud
Using Conditional Replacement Feature in HCM Extracts
Generate and Load Data Using Custom Payroll Flow
Pattern
Creating Custom ESS Job to get Assignment Audit History
in Oracle HCM Cloud Application
Allow Absence Type Visibility for Speci c Users
Alternative Absence Work ow Approval Routing Based
on Absence Reason
Creating Custom List of Values Source for Scheduled
Jobs
ObfuscatedSwedishWorkerAutomated HCM Extract in
Oracle Fusion HCM Cloud
Understanding the Use and Importance of Di erent
XMODE Values while Executing a BI Report
We're Online!
Generate Load and Report Data Using Custom Payroll

Flow Pattern
Loading Data Into Oracle HCM Cloud Using
Parameterized BI Publisher Report
Enforcing User Speci c Validations in Global Absence
Recording
Running a Periodic Alert in Oracle Fusion HCM Cloud
Application
An Overview of Update Accrual Plan Enrollment
Scheduled Process
Understanding Inactive Users Report
A Worked Out Example of Changing Label Name in
Uni ed Sandbox
An Introduction of Employment Diagnostic Master -
Report
Creating Custom Extract to Fetch Absence Entry Details
Mandatory parameter feature in BI Data Model in Oracle
HCM Cloud Application
Automatic Plan Re-Enrollment and withdrawal of existing
absences due to change in Hire Date In Oracle Fusion
Application Release 20A
GET_PLAN_BALANCE vs GET_ACCRUAL_BALANCE
An Overview of Delivered OTBI Analysis Open
Requisitions Aging - Detail By Recruiter
Create Mass Legal Employer Change in Oracle HCM
Cloud Application
Creating A Simple OTBI Analysis Using Sections and
Table Prompts
Release 13 20B New Feature - Areas of Responsibility
Template
Smart Classi cation of Extract Record Instance Using
Identi er Attribute In Oracle Fusion HCM Cloud
Application
Embedding a Parameterised BI Report within a
Dashboard in Oracle HCM Cloud Application
Performing Mathematical Calculations on an Extract Rule
Attribute
Defaulting Business Attribute Using Autocomplete Rules
in Oracle HCM Cloud Application
We're Online!
Load Data into Oracle HCM Cloud Using HCM Data

Loader Transformation Fast Formula
Developing Low-Code/No-Code Reports in Oracle ERP
Cloud Application
Creating a Performance Tile Report in Oracle ERP Cloud
Application
Creating a Waterfall Graph In Oracle ERP Cloud
Application
Verifying Workforce Structures Position Row In Oracle
An Introduction of Person Setup Validations Diagnostic
Test In Oracle HCM Cloud Application
Loading Data Into Oracle HCM Cloud Using BI Publisher
Report
Adding Business Object Validation Rules in Oracle HCM
Cloud Application
Generating Password Protected PDF Reports from
Simple Click on Springboard Icon
A How-to Article about using Legend View In an OTBI
Analysis
An Overview of Assignment Data Integrity Report In
Oracle HCM Cloud Application
An Introduction to HCM Event Diagnostics in Oracle HCM
Cloud
An Overview of User Experience Related Changes
Introduced in Release 13 Update 18B
Storing Non-Unique Values In a Custom Lookup In
Oracle HCM Cloud Application - A Worked Example
Purge Person Data from Test Environments In Oracle
Generating CSV File from HCM Extracts in Oracle HCM
Cloud Application
Minimum Working Age Criteria in Oracle Fusion HCM
Cloud Application
Format Mask Feature in Oracle HCM Cloud BI Report
Creating a New Employee using the Newsfeed Layout in
Oracle HCM Cloud Release 13 (Update 18B)
Person Validations Diagnostic Test In Oracle HCM Cloud
Application
We're Online!
Identifying Value of DBI Item In Oracle HCM Cloud

Application
Embedding Multiple Charts and Data Table in a BIP
Report
Running Parameterized Reports from Navigator Menu
And Springboard Icon in Oracle Fusion HCM Cloud
An Overview of User Password Changes Audit Report
Creating Custom Transaction Rules under HCM
Experience Design Studio Feature in Oracle Fusion HCM
Creating Absence Management Usage Report In Oracle
Position Synchronization in Oracle HCM Cloud
An Overview Of Absence Migration Report in Oracle
Adding Business Object Field Validation Rules in Oracle
Identifying Roles which controls the Menu Items in
Oracle Fusion HCM Cloud Application
Using Image and Static Text in OTBI Analysis
An Overview of "My CV" Report - A Delivered Self Service
Report in Oracle HCM Cloud
An Overview of Functional Setup Manager In Oracle HCM
Cloud Release 13
Creating Fusion BIP Reports From Static Data
Creating Reconciliation Report In Oracle ERP Cloud
Application
Performing "Change Legal Employer" Transaction In
Oracle HCM Cloud (Newsfeed Layout Release13 Update
18B) : A Worked Example
Creating Letter Format Reports from OTBI Analysis
Displaying Warning Message On Absence Recording
Page In Oracle Fusion HCM Cloud Application
Fetch HDL Keys from Oracle HCM Cloud Application
Automatic User Account Creation In Oracle ERP Cloud
Application
Creating an Employee Self Service Report from a Normal
BIP Report in Oracle Fusion Cloud
Role and Privilege Mapping OTBI Analysis In Oracle HCM
Cloud Application
We're Online!
Deriving Extract Attribute Value Using Data Elements

And Extract Input parameter
An Introduction to Worker Report - BIP Report Delivered
By Oracle in Fusion Cloud Application
Getting Started with Inbound Integration using HCM
Data Loader In Oracle Fusion HCM Cloud
WHAT Is SQL
Creating a Pipe Delimited Report from an OTBI Analysis
In Oracle HCM Cloud Application
XML Publisher Report Development and Migration
Con guring Parallel Approval In Oracle HCM Cloud
Conditional Formatting Feature in OTBI Analysis in ERP
Cloud Application - Use Case Example
Enabling Error Noti cation Feature In HCM Extracts in
An Overview of Seeded Approval Flow in Oracle Fusion
HCM
Creating a Password Protected PDF Output in Oracle
Fusion Cloud Application
An Overview of Oracle ERP HCM Cloud Application
Release 12 Global HR New Features
Using GUID and SourceKeys to Edit Data Fields for a
Record created from Application UI in Oracle Fusion
Creating a Parameterized ESS Job in Oracle HCM Cloud
Application
Using Substring Function In OTBI Analysis In Oracle ERP
Cloud Application
Generating Di erent Output Formats from an Oracle
Fusion BI Cloud Report A Worked Example (3)
Capturing Transactional Changes Using an OTBI Analysis
Purge Person Diagnostic Test in Oracle Fusion
Application A Worked Example
Reusing Data Elements of One Data Set Into Another
Data Set In Oracle Fusion Cloud SQL Query Data Source
based Data Model
Creating Dynamic Password Protected PDF Output In
Oracle HCM Cloud Application V1.2
We're Online!
An Introduction of Line Manager Dashboard In Oracle

Fusion HCM Cloud Application
An Introduction to Uni ed Sandbox Feature in Oracle
Fusion Application Release 13 19D
Scheduling OTBI Analysis to receive Excel Output via
Email in Oracle Fusion Cloud Application
Correct/Edit Legal Employer Name In Oracle Fusion HCM
Cloud Application
Running Custom Dashboard by a single click in Oracle
Fusion HCM Cloud
Creating .dat les from BI Publisher Report In Oracle
Creating an Absence Details Report using OTBI Subject
Area in HCM Cloud Release 12
Coexistence Mapping
Using Record Calculation Extract Attribute for HCM
Extract in Oracle Fusion HCM Cloud Application
WHY FUSION ?
Using Expression Variable Functionality in Oracle Fusion
Cloud BI Data Model
Debugging Fast Formula in Oracle ERP Cloud Application
Creating ESS Job from a BIP Data Model (with Pie Chart
Embedded)
Parallel Processing Technique to Fetch Large Volume of
Data Using BI Report In Oracle Fusion Cloud
Menu Customizations in Oracle Fusion Cloud
Applications
Global Absence Vesting Period Fast Formula - A Sample
Example
Setting Up User Preferences in Oracle Fusion
Applications
How-To Article About Setting up a Banner in Oracle
Fusion Cloud
Generating .dat les from HCM Extracts In Oracle HCM
Cloud Application
BI Report to Identify Whether a Person is Employee or
Contact In Oracle HCM Cloud Application
Creating BI Publisher Data Model Using Query Builder In
Oracle ERP Cloud
We're Online!
Uploading BI Report Output to Content Server

Developer Connect Feature for Fusion Cloud
Integrations
Displaying Meaningful Error Messages In a Oracle Fusion
Cloud BI Report
An Introduction to Role Provisioning and De-provisioning
in Oracle Fusion HCM Cloud Application
Assigning Value Set to Element Input Value In Oracle
Initiating Self Service Transactions in Oracle Fusion
Application
User Account Noti cation Template Creation and
Modi cation In Oracle HCM Cloud Release 12
Notifying Changes Using HCM Extract
Changing Label of a Fusion UI Field using Page
Composer
Understanding UPDATE and CORRECTION Actions in
Creating BI Publisher Parameterized Report using Oracle
BI EE as Data Source
Converting a Normal User to a Read Only User in Oracle
Comparing Output of a BI Report with OTBI Report In
Oracle Fusion Cloud Application
Canceling Scheduled Extract in Oracle HCM Cloud
Application
Applying UPDATE and CORRECTION Mode Changes to
PersonName Metadata using HDL Files In Oracle Fusion
Using Extract Criteria Fast Formula in Oracle HCM Cloud
Application A Sample Example
An Introduction To HCM Data Loader - Next Generation
Conversion Tool for Fusion Applications
Delivered Date Time and System Functions In OBI
Analysis
Displaying Total Rows Fetched By OTBI Analysis, Logged
In User, Current Date and Time In Oracle Fusion Cloud
Application
We're Online!
Using a Custom Payroll Flow Pattern to Submit a

Parameterized Report in Oracle Cloud Application
BI Catalog Component Audit Report – A Custom Report
To Identify BIP Report Execution Details
Creating a OTBI Analysis to identify all individuals having
Duplicate National Identi ers
Passing Date Type Parameter from an ESS Job to a BI
SQL Data Model in Oracle Cloud Applications
Creating a Dynamic Fast Formula Based Extract Rule
Attribute for an HCM Extract
An Overview of HR Helpdesk Feature in Oracle HCM
Cloud Release 13
Creating Custom Messages in Oracle Applications
Creating Multilingual Reports in Oracle Fusion
Applications A Worked Example
Bursting OTBI Analysis Data In Oracle HCM Cloud
Generating EText Output From HCM Extracts In Oracle
An Introduction To Role Delegation Feature in Oracle
Alert Composer Feature In Oracle Fusion HCM Cloud
Application
Creating an OTBI Analysis Using SET Operators in Oracle
Fusion Application
Creating BI Publisher Data Model Using Secured List
Views
Creating a Worker Detail Report Using OTBI In Oracle
HCM Cloud
Generating Email Noti cations Using OTBI In Oracle
Fusion Cloud
HCM Extract Components in Oracle Fusion Cloud: An
Introduction
Generating Letter Format Reports in Fusion Applications
– A Worked Example
Dynamically Changing Values of Dependent Parameter
of a BIP Report in Oracle Fusion HCM Cloud Application
Identifying Whether Employee Record is New Hire or an
Assignment Change Record In Oracle Fusion Cloud
We're Online!
An Overview of Workforce Modeling Feature in Oracle

Fusion Application
Why To Use HCM Data Loader
Displaying Current Logged User in a OTBI Report in
An Overview of Approval Rules in Fusion Pro le
Management
An Overview of Customization Layers in Fusion Cloud
Application
Performing Mass Update in Oracle Fusion Applications
Need and Importance of Fusion Dashboard Pages
Embedding BI Report in a Dashboard in Oracle Cloud
Application
Creating Flow Patterns in Fusion Applications
Global Absence Accrual Fast Formula In Fusion Absence
Management: An Introduction
A How-To Article About Using a User De ned Parameter
as HCM Extract Filter Criteria in Oracle Fusion Cloud
Application
How-To Con gure HCM Data Loader in Fusion
Applications
An Overview of Agents in Oracle Fusion Application
Modifying the Look and Feel of Fusion Application
A How-To Article About Creating a Master-Detail OTBI
Analysis
Creating and Scheduling an Excel Report using BI
Publisher in Oracle Fusion Cloud Application
An Overview of Element Input Validation Fast Formula in
Fusion Applications Data Mapping - From HCM Screens
To DB Field
Scheduling OTBI Reports in Fusion Cloud ERP
Executing a Fusion Cloud BI Report by a Simple Click on
Springboard Icon
HCM Delete Diagnostics Sample Use Case
Global Absence Partial Period Accrual Rate Fast Formula
in Oracle Fusion Cloud - A Sample Example
Scheduling Extract In Oracle HCM Cloud – A Worked
Example
We're Online!
An insight into Oracle Fusion HCM Cloud Application

Release 12 OTBI Subject Areas
How-to Migrate Custom HCM Extract
Making Changes to Assignment Data using HDL Files in
Creating an OTBI Analysis with a lter criteria based on
another analysis
Delta Changes HCM Extract - A Use Case
Global Absence Accrual Matrix Fast Formula In Fusion
Absence Management: An Introduction
An Overview of HCM Spreadsheet Data Loader
Creating an OTBI Analysis from Logical SQL in Oracle
HCM Cloud
Global Absence Accrual Fast Formula - A Sample
Example
How-To Create Calendar Data Type for a Presentation
Variable in OTBI Analysis
Adding a New Category and Page in Oracle Fusion
Application
Creating ESS Job For a BIP Report having multiple user
input parameters In Oracle HCM Cloud Application
Using Schedule Trigger in Oracle Fusion Cloud
Application A Worked Example
Using an Extract Rule Type Attribute for a HCM Extract in
Modifying Date Format of a BIP Parameter
Defaulting Current Day, Month and Year as Parameter
Value of a BI Report
An Introduction To ADF Desktop Integration - A Worked
Example
Global Absence Entry Validation Fast Formula - A Sample
Example
One Extract for all HCM Outbound Integrations
Loading Data into Oracle HCM Cloud Using Inbound
Interface Delivery Option
Creating Direct Database Query in OTBI
An overview of fusion absence management – Absence
type de nition and use (Part 2)
We're Online!
Using Page Composer to Edit Component Properties in

Oracle Fusion Cloud
Creating Employee Record using WebService In Oracle
Multiple Parameter Value Selection Feature In a Oracle
Fusion Cloud BI Report
Creating BI Publisher Report from a Web Service
Areas of Responsibility Report in Oracle HCM Cloud
Application
WEBADI-A-Sample-Implementation
Creating Comma Separated Value Report Using BI
Publisher in Oracle Fusion Cloud Application
Data Extraction - HCM Extracts or Reporting Tools -
Which one to use when and why
Fusion Applications - Creating Custom HCM Extract
Generating An Output File with .CSV Extension from an
E-Text Template Based BIP Report In Oracle HCM Cloud
Application
A Whitepaper on Document of Records Explains What,
Why along with a Use case Example
Creating HCM Approval Transaction Detail Report in
Oracle HCM Cloud
Creating Job Set in Oracle Fusion Application
Fetching List of Scheduled Processes using BI Report in
Oracle Cloud
Matching Person Record Criteria in Oracle Fusion HCM
Cloud Application
Creating a Custom Independent Value Set in Oracle
HCM Data Loader Overview
Transfer Employees between Legal Employer in Oracle
Fusion HCM Cloud
Sample HDL Files for Loading Worker Records in Oracle
Uploading Data Files to UCM Content Server of Oracle
Fusion Cloud Using a Standalone Java Application
Creating an E-Text Template based BIP Report in Oracle
ERP Cloud Application
We're Online!
Participation and Rate Eligibility Fast Formula in Oracle

Fusion HCM Cloud - A Sample Example
Creating dependent parameters for a BI Publisher
Report in Oracle Fusion Cloud Application
FUSION APPLICATIONS – USER ROLE DETAIL REPORT
User Hook Implementation – A Sample Example
BIP Bursting In Oracle Fusion Cloud
Sending Output of Concurrent Programs as Email
Attachment
Understanding Lookups in Oracle Fusion Application
Global Transfer In Oracle HCM Cloud Application
Identifying Table Name In Oracle ERP Cloud Application
How-To Create a Custom BIP Report In Fusion
Applications
What is HCM Data Loader
An Overview of Fusion Absence Management Part 1
Absence Accrual Entry Details Report
Loading Worker Record Using HDL Template
A Whitepaper on How-To Create Custom HCM Extract in
Fusion Applications
How to Create a Custom ESS Job in Fusion Applications
Some Commonly Used Queries in Oracle HCM Cloud
An Overview of Pro le Options in Oracle Fusion Cloud
A AA
LATEST POPULAR OUR COMPANY

ARTICLES ARTICLES
Follow us on twitter
Oracle Subscribe to
Join us on Facebook
Enterprise New Oracle
Performance Apps Articles Self Paced Courses
Reporting on this Custom home

Cloud Service Website by About Apps2Fusion
(EPRCS) Email
Corporate Trainings
Training Basic
At Least One Concepts - Finance Transformation Experts
We'reParameter
Online! List of useful
Value Oracle Apps

Required Articles
Dependent XML
getting rolled Publisher
o when and Data
processing Template -
life event SQL Query to
Control develop BI
Absence Publisher
Type Visibility Reports
Based on Forum - For
Plan Balance Oracle Apps
Control Customization
Absence and
Type Visibility Extensions
Based on OA
Plan Framework
BalanceV3 Tutorials
Training
QUICK
MENU ABOUT
APPS2FUSION
Follow us on
twitter Apps2Fusion
Join us on are
Facebook passionate
about Fusion
Self Paced
Cloud E-
Courses
Learning and
Custom
classroom
home
trainings.
About Training is
Apps2Fusion our core
Corporate business and
Trainings we have
been doing
Finance
this for many
Transformation
many years.
Experts
We work
hard to
advise
trainees with
right career
We're Online! paths. We
have
published
various ve
star rated
Oracle Press
Books each
was best
sellers in its
category. We
have helped
many and
could help
you as well.
Copyright © 2021. Oracle Fusion Training & Fusion ELearning. Designed by Shape5.com Joomla
Templates
We're Online!

Creating 90 Days Absence Plan

Uploaded by

Copyright:

Available Formats

Creating 90 Days Absence Plan

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Creating 90 Days Absence Plan

Uploaded by

Copyright:

Available Formats

05/01/2021 Creating 90 Days Absence Plan

HOME TRAININGS FUSION BLOG EBS BLOG

Oracle Gold Partners, our very popular training

Search Packages / Online Trainings

CREATING 90 DAYS ABSENCE SEARCH

Published: 08 October 2020

Like 0 f Share Tweet

Business Requirement is: + FUSION APPS TRAIN

The solution would involve performing various steps which are:

7. Manually calculate the 90th Working Day and run “Update

A Global Absence Accrual Matrix formula needs to be created which

Assuming an employee is a 5 day worker with weekly working hours

Similarly, if he is a 5 day worker with weekly working hours as 45 his

Since the value depends on the employee’s Assignment Working

The Logic of the fast formula is below:

DEFAULT FOR PER_ASG_FREQUENCY is 'Z'

/*=========== DATABASE ITEM DEFAULTS ENDS================ Enter The Below De

L_DATA = ESS_LOG_WRITE('ln_person_number: ' || lc_person_number)

IF (lc_asg_frequency = 'W') Enter your enquiry*

Creating Derived Factor Based on Length of Service

A derived factor needs to be created based on the Length of Service,

Creating Eligibility Profile Enter your email addre

Configure Absence Plan

Plan Attributes Tab:

Entries and Balances Tab:

Creating Absence Type

Type Attributes Tab:

Plans and Reasons Tab:

Action Items Tab:

Run “Update Accrual Plan Enrolments” Scheduled Process

Record Absences and Verify Results

Balance on Hire Date (10/2/2020)

Recording First Absence

Recording Second Absence

Recording Third Absence

Trying to Book 4th Absence (When Balance has exhausted)

Trying to record Absence on 91st Day

So we can summarise that the employee is not able to record any

In nutshell the summary is:

ABOUT THE AUTHOR

Oracle Fusion HCM Techno Functional Consultant with

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or

e) RESTFUL API / Web Service Call

g) End to End Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

Restrict Changes on Approved Historical Absences

Generate Load and Report Data Using Custom Payroll

Load Data into Oracle HCM Cloud Using HCM Data

Identifying Value of DBI Item In Oracle HCM Cloud

Deriving Extract Attribute Value Using Data Elements

An Introduction of Line Manager Dashboard In Oracle

Uploading BI Report Output to Content Server

Using a Custom Payroll Flow Pattern to Submit a

An Overview of Workforce Modeling Feature in Oracle

An insight into Oracle Fusion HCM Cloud Application

Using Page Composer to Edit Component Properties in

Participation and Rate Eligibility Fast Formula in Oracle