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.
Flow Schedule FF Not returning any value
Summary:
I am working on a FF type 'Flow Schedule', by effective date we should get the payroll process date.
Created a Value set and FF. Both has valid and while testing offline in sql not getting any value.
Select pay_ff_functions.gvs ('STL_PAYROLL_CALENDAR_VS','|P_EFFECTIVE_DATE='''||'2022/06/12'||'''') VALUE FROM DUAL
==========================
Value set query:
------------------------------
SELECT pact.effective_date
--paa.payroll_rel_action_id payment_rel_action_id, pfv.base_flow_name, pact.effective_date pay_date,paa.serial_number,pact.CREATION_DATE
FROM PAY_FLOWS_VL pfv, pay_flow_instances flow, pay_requests req, pay_payroll_actions pact, PAY_PAYROLL_REL_ACTIONS paa, pay_time_periods ptp
0