Extract/BIP Query
To Schedule HCM Extract to run Sysdate+1 Log in to the application as an HCM Administrator. Navigator > Data Exchange > Refine HCM Extracts. Select the Payroll Flow. On the Manage Payroll Flow Patterns page, go to the Tasks tab, highlight the appropriate task, and click Edit. Click the pencil icon below the tabs (Tasks, Task Sequence, Parameters). Click the Edit pencil icon next to the task that you want to edit. On the Edit Task Details: Basic Information flow, locate the Effective Date parameter and click on that row. The Effect Date: Parameter Details region will now show at the bottom of the screen. In the Effect Date: Parameter Details region, set these parameter values: Parameter Basis = Post SQL Use Below query SELECT NVL((SELECT flow_param_value FROM ...