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

 

I would request all of the readers to kindly go through the below articles before proceeding with this one (its fine if you are already aware of the concepts..but it may serve as a good refresher too):

 

HCM Extract Components in Oracle Fusion Cloud: An Introduction

 

Using an Extract Rule Type Attribute for a HCM Extract in Oracle Fusion HCM Cloud Application

 

In the above articles we have tried to explain what are the different components of an HCM Extract and also how to use an Extract Rule Type Attribute for an HCM Extract.

 

This article too is about defining a Extract Rule Type Attribute but it has some major enhancements to the previous one (Using an Extract Rule Type Attribute for a HCM Extract in Oracle Fusion HCM Cloud Application ) in sense that while we used to return a static (hardcoded) value from the Fast Formula here we would try to have a dynamic value ( value derived from individual’s details as stored in the database).

 

In this example, we would try to fetch the Length of Service (referred to as LOSInDays from here on) for each individual.

 

We would calculate this details by finding the difference (in days) between the current date and the person’s enterprise hire date.

 

So let’s get started.

 

Fast Formula Details

 

Attribute Name/Label/Prompt

Attribute Value

*Formula Name

GetLOSInDays

*Type

Extract Rule

Description

Calculates the Length of Service In Dates

Legislative Data Group

 

Effective Start Date

1/1/00

Type of Editor

Text

Text

<Check Below Table>

Formula Text

DEFAULT FOR DATA_ELEMENTS IS EMPTY_TEXT_TEXT

INPUTS ARE DATA_ELEMENTS (TEXT_TEXT)

ld_effective_date = GET_PARAMETER_VALUE_DATE('EFFECTIVE_DATE')

ld_emp_hire_date = TO_DATE(SUBSTR(TRANSLATE(DATA_ELEMENTS['ENTERPRISEHIREDATE'],'01234567890:.-TZ', '01234567890:.- '), 1, 19), 'YYYY-MM-DD HH24:MI:SS')


ln_los_in_days = DAYS_BETWEEN (ld_effective_date,ld_emp_hire_date)

RULE_VALUE = TO_CHAR(ln_los_in_days)

RETURN RULE_VALUE

Application Screenshot

 

If we use the below details and create the Fast Formula , save and compile it then the application screen would appear as below:


Ashish Harbhajanka

Comments   

0 #1 pharmacepticacom 2021-06-20 01:29
tadalafil uses https://pharmaceptica.com/
Quote
0 #2 alfqsi 2022-05-06 12:23
hydro plaquenil doctors prescribing hydroxychloroqu ine near me
Quote
0 #3 evxqmv 2022-05-07 05:41
hydroxychloroqu ine what is it plaquenil medication
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