Get Started with Redwood for Oracle Cloud HCM Begin Now
How to limit the List of Values displayed in Payroll Parameter in Payroll Flow
Summary:
We currently have 3 Payrolls ( Payroll 1, Payroll2 and Payroll3) for US and we are going to move all the Employees from Payroll 1 to Payroll 2 and want to ensure that user can not select the Payroll 1 while submitting the Payroll Calculation Flow. We used Sql Bind in Payroll Parameter to limit the payrolls but it is not working, i am still able to see all three payroll.
I tried below queries with Sql Bind but none of them seems to be working-
select distinct PayrollDPEO.PAYROLL_NAME,PayrollDPEO.PAYROLL_ID from PAY_ALL_PAYROLLS_F PayrollDPEO where PayrollDPEO.PAYROLL_NAME not in ('Payroll 1 ')
0