Fusion HCM Technical Assistance

  To Get Tax Calculation card effective date   select rgi.effective_start_date   from pay_dir_cards_f dc ,fsion.pay_value_definitions_vl dcd , pay_dir_card_components_f dcomp , pay_dir_card_definitions_vl pdccdt , pay_value_definitions_f pvd , pay_range_items_f rgi where 1=1 and dcomp.dir_card_comp_id = :{PARAMETER.FED_CMP_ID} AND dcd.dir_card_definition_id = dc.dir_card_definition_id and dcd.base_display_name = 'US_EMPLOYEE_WITHHOLDING_CERTIFICATE' and dcd.legislation_code = 'US' and dcomp.dir_card_id = dc.dir_card_id and sysdate between dcomp.effective_start_date and dcomp.effective_end_date and pdccdt.dir_card_comp_def_id = dcomp.dir_card_comp_def_id and pdccdt.base_component_name = 'ORA_HRX_WTH_FEDERAL' and pdccdt.legislation_code = 'US' and pvd.source_id = dcomp.dir_card_comp_id and pvd.source_type = 'PDCC' and sysdate between pvd.effective_start_date and pvd.effective_end_date and rgi.value_defn_id = pvd.value_defn_id and rgi.calc_type_id =...

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 ...