Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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