User-defined, Extract Parameter for runtime not being recognised in root DG filter
Summary
User-defined, Extract Parameter for runtime not being recognised in root DG filterContent
Hello Colleagues:
I created an Extract Parameter that is included in “driver-root” Person DG filter (see All pics attached)
The Extract is not recognizing the run-time entry get picked up – a list of test employees separated by commas (person number) But will only work if added manually /* */ and uncomment. At one time it was working on a previous generation. Also need it picked by OIC program.
/*Filter */
ppos.period_type IN ('E') AND ppos.date_start = (SELECT MAX(ppos_in.date_start) FROM per_periods_of_service ppos_in WHERE ppos_in.person_id = ppos.person_id AND ppos_in.period_type IN ('E') AND ppos_in.date_start <= pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE') ) AND paaf.system_person_type IN ('EMP') AND paaf.assignment_type IN ('E') AND paaf.primary_flag = 'Y' AND paaf.effective_latest_change = 'Y' AND pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE') BETWEEN paaf.effective_start_date AND paaf.effective_end_date AND ( pay_report_utils.get_parameter_value('EMPLOYEE_IDS') IS NULL OR ( pay_report_utils.get_parameter_value('EMPLOYEE_IDS') IS NOT NULL AND ',' || pay_report_utils.get_parameter_value('EMPLOYEE_IDS') || ',' LIKE '%,' || papf.person_number || ',%' ) )