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

Business Requirement

We want to create a HCM Extract wherein we would like to get Element Related Details and would like to restrict the data only for Element which belong to either Element1’ or Element2’

We can achieve this using a Fast Formula

Fast Formula Content

/*

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

Formula Name: Element Name HCM Extract Data Filter Criteria

Formula Type: Extract Criteria

Description: Custom Fast Formula To use as HCM Extract Data Filter Criteria. Only Element1 and Element2 would be included in HCM Extract

Created By   : Ashish Harbhajanka

Creation Date: 10-Mar-2017

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

*/

DEFAULT FOR ELEMENT_BASE_NAME IS 'null'

INCLUDE = 'FALSE'

 

IF

(

(ELEMENT_BASE_NAME = 'ELEMENT1') /*Use Appropriate Element Names as Applicable for your Environment*/

OR

(ELEMENT_BASE_NAME = 'ELEMENT2')

)

THEN

(INCLUDE = 'TRUE')

RETURN INCLUDE

 

Application Snapshot


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

<<  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