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

Flow Schedule FF Not returning any value

Received Response
11
Views
6
Comments

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!