1. Administering Payroll Flows
  2. How Do I Use a Value Set in a Payroll Flow

How Do I Use a Value Set in a Payroll Flow

In this example you create a value set and use the input values for location name as an entry value for a flow.

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

Use the Value Sets task to create a value set. After you create a value set, use the Payroll Flow Patterns task to link the value set with a flow.

How to Create a Value Set that Returns all Locations

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

  1. Select the Value Sets task in the Setup and Maintenance area.

  2. On the Value Sets page, click Create.

  3. Enter these values.

    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.

How to Add the Value Set Codes to the Payroll Flow Patterns Page

Let's look at the steps to add the value set codes to the Payroll Flow Patterns page:

  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.

    Use the flow parameters to submit and complete the tasks in the flow pattern, or as a basis for deriving values to submit the remaining tasks in the flow pattern.

  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.