We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

User-defined, Extract Parameter for runtime not being recognised in root DG filter

Question
13
Views
0
Comments
edited Feb 14, 2021 5:11PM in HCM Integrations

Summary

User-defined, Extract Parameter for runtime not being recognised in root DG filter

Content

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 || ',%'         )     ) 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!