1. Export Employee Records from Workday to SAP
  2. Install and Configure the Recipe

3 Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

  1. On the Oracle Integration Home page, in the Use a recipe/accelerator section, click View all.
  2. Find the recipe you want to install.
  3. Hover over the recipe, then click Install Install icon.

    A message confirms that the recipe was successfully installed, and the recipe card shows INSTALLED.

  4. Hover over the recipe again, and click Configure Configure icon to configure the resources of the recipe.

    The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the Oracle Workday Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Host Name Enter the Workday host name. For example: https:// wd2-impl-services1.workday.com
    Tenant Hame Enter the tenant’s name of the account created for Oracle Integration on Workday. See Configure Workday.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Workday Username Token Policy.
    Workday Integration User Enter the username of the account created for Oracle Integration on Workday. See Configure Workday.
    Password Enter the password of the account created for Oracle Integration on Workday.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  6. To return to the project workspace, click Go back Back icon.

Configure the Oracle SAP Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, upload the adapter inbound properties file. See JCO Connection Properties Files.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Username Enter the username to connect to the SAP instance. See Configure SAP.
    Password Enter the password to connect to the SAP instance.
  4. In the Access type section, select an agent group for accessing the service hosted on your premises behind the firewall.
    1. Select Connectivity agent and click Associate agent group.
    2. In the resulting window, select an agent group and click Use.
  5. Click Save. If prompted, click Save again.
  6. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

    A message confirms if your test is successful.

  7. To return to the project workspace, click Go back Back icon.

Configure the Lookup Tables

The recipe contains the following lookup tables. Edit them as necessary.

  • WORKDAY_SAP_COUNTRY_CODE: Use this lookup to map Country Codes between Workday and SAP.
  • WORKDAY_SAP_PERSONNEL_SUBAREA:Use this lookup to map Location Org Code in Workday to Personnel Subarea in SAP.
  • WORKDAY_SAP_PERSONNEL_AREA: Use this lookup to map Region Org Code in Workday to Personnel Area in SAP.
  • WORKDAY_SAP_EMPLOYEE_SUBGROUP: Use this lookup to map Worker Subtype in Workday to Employee Subgroup in SAP.
  • WORKDAY_SAP_GENDER:Use this lookup to map Genders between Workday and SAP.
  • WORKDAY_SAP_LANGUAGE: Use this lookup to map Languages between Workday and SAP.
  • WORKDAY_SAP_EMPLOYEE_GROUP:Use this lookup to map Worker Type in Workday to Employee Group in SAP.
  • WORKDAY_SAP_EMPLOYEE_PROPERTIES: Use this lookup to store the properties configured for this recipe as shown in the following table.
Property Description Value
WorkdayReportName Name of the Workday EIB report. EIB_Workday_To_SAP_ERP_Worker_Report
Client SAP Client Id 800
SenderPort SAP port created for Oracle Integration A000000072
SenderPartnerNumber SAP partner profile created for Oracle Integration OIC_SAP_WD
PlanVersion SAP plan version 1
ObjectType SAP object type for employee P
AssignmentObjectType SAP assignment object type S
NumberRangeNumber SAP number range number for employee personnel number (PERNR) 2
NumberRangeObject SAP number range object for employee personnel number (PERNR) RP_PREL
IdocStatusDelimiter Delimiter for SAP EDIDS table query result |
EndDate SAP default end date 99991231
HiringActionType SAP action type for employee hiring action 1
HiringActionReason SAP reason for action for employee hiring action 6
CompanyCode SAP company code 1000
OrganizationalKey SAP organizational key 1000
OrganizationalUnit SAP organizational unit 1000
AdministratorGroup SAP administrator group 1000
ControllingArea SAP controlling area 1000
NameFormatIndicator SAP name format indicator 0
FormOfAddress SAP form of address 1
  1. In the Configuration Editor, click Lookups to view the lookup tables in the recipe. Click the name of the lookup table to edit.
  2. In the Value column, enter or map the appropriate values for the properties.
  3. Click Save. If prompted, click Save again.
  4. To return to the Configuration Editor, click Go back Back icon.