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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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