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