How can I integrate Oracle Payroll and Labor Distribution for automated payroll distribution?

Use the Oracle Fusion Payroll Transaction Source to import payroll costs from Oracle Fusion Payroll.

Note: Payroll costs must be accounted in order to be distributed to Projects.

You must have the following privileges to perform these tasks:

  • Manage Payroll Pay Elements for Project Labor Cost (PJC_MANAGE_PAY_ELEMENTS_FOR_PROJECT_PRIV)
  • Transfer Payroll Costs to Projects (PAY_TRANSFER_TO_PROJECTS_PRIV)
  • Manage Project Labor Distributions (PJC_MANAGE_PROJECT_LABOR_DISTRIBUTIONS_PRIV)
  • Manage Project Labor Schedules (PJC_MANAGE_PROJECT_LABOR_SCHEDULES_PRIV)
  • Manage Project Labor Schedules at Element Level (PJC_MANAGE_PROJECT_LABOR_SCHEDULES_AT_ELEMENT_LEVEL_PRIV
  • Use REST Service - Payroll Element Definition List of Values (PAY_REST_SERVICE_ACCESS_PAYROLL_ELEMENT_DEFINITION_LOV_PRIV)
  • Use REST Service - Workers List of Values (PER_REST_SERVICE_ACCESS_WORKERS_LOV_PRIV)

Manage Project Payroll Pay Elements Eligible for Distribution in Oracle Payroll

This task enables you to set up the pay elements to be distributed to Projects.

To manage project payroll pay elements, navigate to Labor Distribution and click the Manage Project Payroll Pay Elements tab. The Manage Project Payroll Pay Elements page appears. Search and select a payroll pay element and click Edit to update the Start and End dates during which the payroll pay element will be effective.

Note: You can't edit the name of the payroll pay element.

Manage Pay Element to Expenditure Type Derivation

This optional task enables you to map payroll pay elements to project expenditure types. These derivations enable you to set up one labor schedule per person, but have different expenditure types based on the pay elements being distributed.

To manage pay element to expenditure type derivations, navigate to Labor Distribution and click the Manage Pay Element Expenditure Type Derivation tab. The Manage Pay Element Expenditure Type Derivation page appears. Search for a pay element or expenditure type to view and edit related derivations.

To create a pay element expenditure type derivation, click Create. The Create Pattern side panel appears. Give the derivation pattern a Name, select the Pay Element and Expenditure Type that you want to map together, and specify the Start and End dates for the mapping. Save your changes, and your mapping is done. When the Import Payroll Costs process is next run, costs that belong to the pay element in your derivation rule will be listed under the expenditure type that you listed in your derivation mapping.

Manage Project Cost Date Derivation Using the Manage Labor Distribution Profile Options Task

Note: You must be an Applications Administrator to perform this task.

Use the Expenditure Item Date Derivation for Payroll Costs profile option to change the default derivation rule. Optionally, change the default value of Payroll Process Start Date to Payroll Process End Date. This change derives the expenditure item date based on the latest date of the labor schedule version end date, assignment end date, or the pay period end date instead of the start of those date-bounded objects. You can view this profile option upon searching for it in the Manage Profile Options setup and maintenance task. By default, it is enabled at the site level. Depending on your requirement, you can enable this at the product or user level.

To update the project cost date derivation profile option value, navigate to Setup and Maintenance > Manage Administrator Profile Values and search for the Expenditure Item Date Derivation for Payroll Costs profile option in the Profile Display Name field. When you select this profile option, the Profile Values section displays the value that is set for the profile option. Click the Profile Value field in this section to update it.