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

Many a times there could be a genuine business need where-in we are supposed to make some changes to the existing setups in the Absence Configuration and we do not want any new absence recording to be entered by the system via either UI Entry , HDL , REST or any other method.

While there are multiple ways like:

  1. Raise a SR with Oracle to ensure the server can be brought down during the upgrade period
  2. Hide Menu Item from Structure
  3. Personalize the “Manage Absence Records” page to hide the “+” icon
  4. Remove privileges from the delivered / custom role to ensure the Absence Recording pages are not visible to end users

But, none of the above approach is full proof as while the above options may restrict new absence entry from UI but it would not be able to restrict absence entry via HDL or REST API.

So in such situation we can make use of “Global Absence Entry Validation” fast formula.

In this example, we will demonstrate how we can achieve this.

So, without further ado let’s get started.

Configuration Steps

In order to achieve the functionality mentioned above we would need to perform the following steps:

  1. Create a new message which will be displayed when a new absence transaction is being created.
  2. Create a custom Global Absence Entry Validation Fast Formula
  3. Attach the newly created Formula to all active absence type

 

Creating new message

We will create a new message which will have the following details:

Attribute Name

Attribute Value

Message Name

SYSTEM_UPGRADE_IN_PROGRESS_ERR

Application

Absence Management

Module

Absence Recording

Message Number

100000002

Message Type

Error

Logging Enabled

Checked

*Short Text

System is undergoing mandatory updates. No new absence transaction can be created now. Please try after 24th August 2020

 

A screenshot of a social media post

Description automatically generated

 

Creating a new Global Absence Entry Validation Fast Formula

We would also need to create a “Global Absence Entry Validation Fast Formula”. Details of the formula is below:

Attribute Name

Attribute Value

Formula Name

SYSTEM_UPDATES_IN_PROGRESS_VAL

Formula Type

Global Absence Entry Validation

Description

Validation Formula to ensure no absences are entered during system upgrades

Effective Start Date

1/1/1951

Legislation

 

Formula Text

See Table Below

 

SYSTEM_UPDATES_IN_PROGRESS_VAL: Formula Text

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

FORMULA NAME: SYSTEM_UPDATES_IN_PROGRESS_VAL

FORMULA TYPE: Global Absence Entry Validation

DESCRIPTION: Validation Formula to ensure no absences are entered during system upgrades

Change History:

Name               Date         Version  Comments

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

Ashish Harbhajanka     19-Aug-2020    DRAFT 1A   Initial Version

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

DEFAULT FOR IV_START_DATE IS '4712/12/31 00:00:00' (date)

DEFAULT FOR IV_END_DATE IS '4712/12/31 00:00:00' (date)

DEFAULT FOR IV_START_TIME IS '00:00'

DEFAULT FOR IV_END_TIME IS '23:59'


INPUTS ARE IV_START_DATE (date), 

  IV_END_DATE (date), 

  IV_START_TIME(text),

  IV_END_TIME(text)

   

   

VALID = 'N'

ERROR_MESSAGE = 'SYSTEM_UPDATES_IN_PROGRESS_ERR'

RETURN VALID,ERROR_MESSAGE

 

A screenshot of a social media post

Description automatically generated

 

Associating Validation Fast Formula to Absence Type

Ideally we should attach the newly created Validation Fast Formula to all active absence type to ensure none of the absence recording takes place but for now we will only attach the fast formula to one absence type (‘Sick’ absence type for this example) for sake of simplicity.

Navigation: Setup and Maintenance -> Manage Absence Type -> Search for “Sick” Absence Type -> Correct-> Add “SYSTEM_UPDATES_IN_PROGRESS_VAL” to Validation Formula field

A screenshot of a cell phone

Description automatically generated

 

And with this our configuration steps are complete. Next, we will try to verify our setup and check if we get desired results.



Verification

We will verify the setup by trying to record absence in two ways namely via UI and via HDL

Verification from UI

We will pick a employee (employee number 40 for this example) and try to book an absence of “Sick” absence type.

A screenshot of a cell phone

Description automatically generated

 

Verification Using HDL

We would try to perform the same transaction(using exact same data attributes) using HDL.

The HDL file would look like:

PersonAbsenceEntry.dat (HDL File Content)

METADATA|PersonAbsenceEntry|PersonNumber|Employer|AbsenceType|AbsenceReason|AbsenceStatus|ApprovalStatus|StartDate|StartTime|EndDate|EndTime

MERGE|PersonAbsenceEntry|40|US1 Legal Entity|Sick|Cold|SUBMITTED|APPROVED|2020/08/10|08:30|2020/08/10|17:30

 

We will save the above content in a file named PersonAbsenceEntry.dat and zip the same (File Name of zipped file is Emp40_AbsenceEntryHDLLoad.zip)

And when we try to load the HDL file we get below error:

A screenshot of a social media post

Description automatically generated

Conclusion

So, this is how we can restrict recording of new absences by making smart use of Validation Fast Formula in Oracle HCM Cloud Absence Management.

While, we have only demonstrated that the restriction applies to both UI and HDL but the same will be applicable for REST / SOAP web services too and the reason for this assumption is that the HDL load also internally calls the loader service ( which is the same one called by REST / SOAP web service) and if we get error in HDL we will get the same via REST /SOAP too. I have not tried this but you may try and share your findings.

Also, one important point to note is this entire process would not be able to any “WITHDRAWN” action performed on existing absences as Global Absence Entry Validation does not gets triggered when a existing absence is WITHDRAWN.

And, with this I have come to the end of the article, hope this was a good read and you guys have understood the concept.

Thank you all for your time , have a great day ahead.

 

Downloadable file

Emp40_AbsenceEntryHDLLoad.zip


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