Use a Value Set in a Payroll Flow

This example demonstrates how you can create a value set to retrieve input values for location name as a parameter for a flow.

Use the location parameter when you run the flow to generate multiple reports in a sequence. Use the search option on the parameter to select an appropriate location value.

Create a Value Set that Returns all Location Names

Let's look at the steps to create a value set that returns all location names.

1. Navigate to the Setup and Maintenance area and select the Value Sets task.

2. On the Value Sets page, click Create.

3. Enter these values.

   Details to Create a Value Set

   Field	Value
   Value Set Code	LOCATION_VS
   Description	Locations
   Module	Payroll Flows
   Validation Type	Table
   Value Data Type	Character
   FROM Clause	pay_ flows_pf
   Value Column Name	pft.flow_name
   Value Column Type	VARCHAR2
   Value Column Length	100
   ID Column Name	pf.base_ flow_id
   ID Column Type	Number
   ID Column Length	18
   WHERE Clause	Pf _flow_ id = {PARAMETER. LOCATION_IP} Note: LOCATION_IP is the input value name.
   ORDER BY Clause	pft.flow_name

4. Optionally, to secure the value set, select the Data Security check box and provide the Data Security Resource Name.

   Note: You can enable data security only if the value set is based on a single table or view.

5. Click Save.

Add the Value Set Codes to the Payroll Flow

Let's look at the steps to add the value set codes to the Payroll Flow.

1. Use the Payroll Flow Patterns task from Payroll in My Client Groups on the Home page.

2. Create a flow to meet your requirements, add the required tasks, and arrange them in a sequence.

3. Select the Parameters tab, and click Create, and create an empty parameter.

4. Select the new parameter and click Edit and add these parameter details.

   Field	Value
   Display Format	Value Set
   Lookup	Enter the Value Set Name, LOCATION_VS, in this example.

5. Optionally, enter the Owner and Checklist information, and then click Next.

6. Click Submit. When you run the flow, the Location parameter renders as a smart list of values. You can use the search option to select a location.