1. Administering Oracle Payroll Interface
  2. Integrate Absence Records

Integrate Absence Records

Generate payroll interfaces using the Global Payroll Interface For Absence template to integrate absence records with third-party payroll vendors.

Basic absences (person level) and advanced absences (assignment or day wise) are supported.

Absences that are effective within the specified extraction window (process start and end date params) will be extracted. Only those employees who have absences effective within the specified extraction window will be included in the extraction.

Day wise absence records can be created for each day of the absence duration and each absence entry within the total absence duration can be associated with an assignment.

Here's how you configure the payroll interface using the Global Payroll Interface For Absence template:

  1. On the Home page, click the Data Exchange quick action under the My Client Groups tab.

  2. Search for and select Extract Definition on the Data Exchange page.

  3. Create an extract. Click the + sign to create an extract and select ‘Create from Template’. On the Create Extract Definition page select Global Payroll Interface For Absence from Source Template > Payroll Interface. Complete these fields:

    • Name: Provide the name of the interface. The application generates the flow with this name. Let's say, the name is ABC Payroll Interface, then the flow gets generated as Run ABC Payroll Interface.

    • Start Date: Provide a start date to create the extract definition.

    • Consumer: Select appropriate payroll partner from the LOV. If the payroll partner is not available in the LOV select Undefined and include details of the payroll vendor in the field Additional Details.

    • Changes Only: Ensure that you have selected this check box.

    • Legislative Data Group: Search for and select an appropriate legislative data group.

    • Source Template: Select the source template as Global Payroll Interface For Absence.

  4. Click OK. You will find a list of default objects and attributes that are available.

  5. Select Person Absences from the list of Business Objects. From the list of attributes on the right pane for Person Absences , select the attributes you may need

  6. To integrate day-wise and assignment-wise absence records: Select Assignment Absences from the list of Business Objects. From the list of attributes on the right pane for Assignment Absences , select the attributes you may need

  7. Once you have selected the attributes, click Review in the left-most pane to review your selection.

  8. Click Save to submit your configuration and wait for the status to reflect Ready.

Run the generated Absence Interface

Use the Submit a Flow task to submit the global payroll interface process.

  1. On the Home page, navigate to My Client Groups > Payroll > Submit a Flow Task.

  2. Select the Legislative Data Group.

  3. Search for and select the name of the extract definition provided during creation of the payroll interface.

  4. On the Enter Parameters page, enter these parameters.

    Parameter

    Value

    Payroll Flow

    Enter a meaningful name.

    Changes Only

    Changed and marked attributes/All attributes/Changed attributes

    Object Group

    The application extracts data depending on the conditions mentioned in the selected object group.

    • If the object group is a group of payrolls, the application considers all employees associated with the payrolls that are mapped to this object group for extraction. This enables data corresponding to multiple payrolls being reported in a single output file.

    Payroll

    Payroll is an optional parameter you can use if you want to extract employees by payroll.

    If you specify payroll, the application extracts only those employees that are mapped to a particular payroll.

    Note: The application will extract data only if you provide either an Object Group or a Payroll or a combination of both.

    Process Start Date

    Enter the start date of the extraction window.

    Absences that are effective within the specified extraction window (process start and end date parameters) will be extracted.

    Process End Date

    Enter the end date of the extraction window. The application considers this date as the effective as of date and extracts those records effective as on this date.

    Absences that are effective within the specified extraction window (process start and end date parameters) will be extracted.

    Instance Name

    Development/Production/QA Test

    Process Configuration Group

    Select the required process configuration group

    Baseline Only

    Yes/No

  5. Click Submit. Monitor the status of the process to successful completion.

Use Customer Extensible Attributes

Use the customer extensible attributes included in the Global Payroll Interface for Absence template.

Depending on your requirements configure the values for these fields using fast formulas. Fast formulas created for various fields as required are mapped with their respective extensible field and the value returned by the formula will be populated in the GPI output file. Here are the tasks needed:

  1. Enable the extensible attributes.

  2. Configure a fast formula to define the Override Value of these extensible fields.

  3. Map the Fast Formula in the Configure Payroll Interface Properties.

Customer extensible attributes are available at both Person and Assignment absences section and can be used to report additional absence data. The two available data element are:

Level

Data Elements

Person Level

Person Absence Field 1

Person Absence Field 2

Assignment Level

Assignment Absence Field 1

Assignment Absence Field 2
To enable the extensible attribute, follow the below steps:

  1. On the Home page, click the Data Exchange quick action under the My Client Groups tab.

  2. Search for and select Extract Definition on the Data Exchange page.

  3. Create an extract. Click the + sign to create an extract and select ‘Create from Template’. On the Create Extract Definition page select Global Payroll Interface For Absence from Source Template > Payroll Interface. Complete these fields:

    • Name: Provide the name of the interface. The application generates the flow with this name. Let's say, the name is ABC Payroll Interface, then the flow gets generated as Run ABC Payroll Interface.

    • Start Date: Provide a start date to create the extract definition.

    • Consumer : Select appropriate payroll partner from the LOV. If the payroll partner is not available in the LOV select Undefined and include details of the payroll vendor in theAdditional Details field.

    • Changes Only: Ensure that you have selected this check box.

    • Legislative Data Group: Search for and select an appropriate legislative data group.

    • Source Template: Select the source template Global Payroll Interface For Absence.

  4. Click OK.

  5. From the list of Business Objects select Person Absences under Global Person Information. From the list of attributes on the right pane for Person Absences , enable the attributes Absence Extensible Field1 and Absence Extensible Field2.

  6. Select Assignment Absences from the list of Business Objects. From the list of attributes on the right pane for Assignment Absences , enable the attributes Absence Extensible Field3 and Absence Extensible Field4.

  7. Click Review to review your selection.

  8. Click Save to submit your configuration and wait for the status to reflect Ready.

Configure a fast formula to define the Override Value of these extensible fields:

On the Home page, click the Fast Formulas quick action under the My Client Groups tab to create a fast formula of type Extract Rule. This formula should return the override value through a variable called l_computed_val. The variable returning the computed value should have the name l_computed_val.

Map the Fast Formula in the Configure Payroll Interface Properties:

Use Configure Payroll Interface Properties to map the Fast Formulas you defined against the respective Extensible field, for the Global Payroll Interface.

Follow these steps to configure payroll interface properties:

  1. On the Home page, click the Data Exchange quick action under the My Client Groups tab.

  2. Select Configure Payroll Interface Properties under Data Exchange Configurations on the Data Exchange page.

  3. Select the required Global Payroll Interface.

  4. In the Absences Extensible Fields Formula Map section map the Fast Formulas in the Override Value field to the respective Extensible Field.