Retrieve employee assigment info from flow process BI Report
Summary:
Retrieve employee assigment info from flow process
Content (required):
Hi everyone,
I have a requirement which is to obtain information from employees with a BI report when they execute a flow process.
The test process I am using returns 1961 rows I have the following query:
The person_id count is correct, but when I try to fetch information from the assignment the count changes, this is the query:
WITH ARCHIVE
AS (SELECT prd.person_id,
PA.effective_date
FROM fusion.pay_payroll_rel_actions RA,
fusion.pay_payroll_actions PA,
fusion.pay_requests PR,
fusion.pay_flow_instances FI,
Tagged:
0