Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Retrieve employee assigment info from flow process BI Report — Cloud Customer Connect
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

Retrieve employee assigment info from flow process BI Report

Received Response
11
Views
4
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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