How to use Fast Formula in HCM Extract

Requirement 
Can we use Fast Formula in HCM Extrat to derive any Database calculation ?

Solution 
Oralce provides rule type attribute in HCM extract.  We can use this type to use fast formula driven attribute. 

In order to access Fast formula in Extract attributes, use type = "Extract Rule" 

If using GET_VALUE_SET method to cal value set ( only TABLE type value set are supported). Please ensure you pass value to ID field as well.  

HCM Extract Migration

HCM Extract provides export and import options. For any new development work, migration approach should be export/import.

Export Extract Definition
My Workforce >> Data Exchange >> Manage Extract/ Extract Definition >> Search Extract  and Click export icon ( 3rd one having up arrow key symbol)  

This will download the XML version of Extract definition. 

Import Extract Definition 

My Workforce >> Data Exchange >> Manage Extract/ Extract Definition >> Click on Import Icon ( opposite of export and available at top left corner , beside +) 

It will prompt to Give Extract Name and file Import. 

Limitation - Extract Name must be unique during Import. This is why this method doesn't really helpful if change is in existing extract. 

It also doesn't allow to delete extract  if it did ran in past. So you can't delete and reuse same name. 

For Operational Support, all changes to existing extract need to be done manually. 

Execution of HCM Extract

Extract Submission 
Option 1 
My Workforce >> Data Exchange >> Submit a Process or Report >> Submit Extracts

Option 2 
My Workforce >> Data Exchange >> Submit Extract  >> Search Extract  >> Submit

Option 3 
My Workforce >> Data Exchange >> Manage Extract/ Extract Definition >> Search Extract  and Click on Submit Extract Icon ( Last in list, a box with arrow key) 

Option 4
My Workforce >> Data Exchange >> Submit a Process or Report >> Search for Recently Completed Runs >> Open Action List >> Submit Similar 



Extract Scheduling 
Option 1 
My Workforce >> Data Exchange >> Submit a Process or Report >> Schedule



Extract Rollback
Option 1 
My Workforce >> Data Exchange >> Submit a Process or Report >> Search for Recently Completed Runs >> Open Action List >> Roll Back >. This will submit roll back request and results will disappear from original run