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: