Set Effective Date Parameter in HCM Extract
- Define Extract and Include Attribute to display EFFECTIVE_DATE parameter
- Navigate to Refine Extract
- Set Effective Date parameter to be non-Mandatory (could make it non-display)
- Drill down to Tasks -> JRTestSysdateParam (The Submit action is the actual interface that calls the HCM Extract)
- Filter by Submit action
- Edit EFFECTIVE_DATE parameter to be POST SQL – select sysdate-30 from dual
- Run Extract
- Output is as follows: