Integration Overview
This section covers basic integration overview for Craft/Jobs integration. Oracle Human Capital Management Cloud (Jobs) is the central repository for the Jobs records.
The key attributes are captured from Oracle Human Capital Management Cloud and synced with Oracle Utilities Work and Asset Cloud Service using two modes:
• Bulk (Initial Upload)
• Incremental Upload
This seamless integration between Oracle Human Capital Management Cloud and Oracle Utilities Work and Asset Cloud Service helps to have the same Jobs and Grades rates (summarized) defined across both platforms.
The goal of this integration is to create a central depository of Jobs in Oracle Human Capital Management Cloud which is primarily mapped to Principle Craft in Oracle Utilities Work and Asset Cloud Service. The integration has the ability to synchronize crafts and related craft rates from Oracle Human Capital Management Cloud to Oracle Utilities Work and Asset Cloud Service.
Design
Bulk Upload
Bulk Upload will be an initial upload from Oracle Human Capital Management Cloud to Oracle Utilities Work and Asset Cloud Service, where all Job/Craft information is extracted in UCM using XML format through Data Exchange that is the inbuilt functionality of ERP. The selection of the craft/jobs in the Oracle Human Capital Management Cloud module is done using an extensible flexfeild that stores a value if it is Oracle Utilities Work and Asset Cloud Service job or not. Only Active Jobs in the system are part of the integration.
Incremental Update
The incremental upload will handle sync for a set of changes made within job information.
The following functions are part of Jobs integration:
• Add/update the Job record from the tabs in Oracle Human Capital Management Cloud
• Information or rate change in Job
• Active/Inactive of Job
Jobs extract report has the listed mandatory parameters (Job Set, Annual Rate and Effective Date).
This report extract will have both Crafts and corresponding rates, which will be handled in Oracle Integration Cloud using one service. (This is one-way integration from Oracle Human Capital Management Cloud to Oracle Utilities Work and Asset Cloud Service.)
• The integration timeline needs to be decided by a business that can be scheduled in the BI report setup. (Incremental report will take only the changes from last run date - delta and new records).
• Filter criteria in Job extract:
• Job-status is ACTIVE (Bulk), INACTIVE/INACTIVE (Incremental)
• Initial load, only active jobs are interfaced and incremental load both Active and Inactive jobs are interfaced.
• WACS JOB (Flexfield is set to YES)
• Job Set (Based on Legislative Unit - can be global or specific to one legislative unit): Mandatory
• Effective Date: Mandatory
JOB HCM Extract extracts the data based on the effective date and need to be decided before executing /scheduling the report.
Business Rules
Following are the business rules:
• Craft rate is derived from the grades linked to Job.
• If multiple rates (Hourly, weekly, yearly, etc.) are attached to the single grade then maximum annual factor (hourly) grade is considered for the average calculation.
• After the initial run, for all next report run:
• Check if there is a change in Craft rate (If X=X go to step2, X !=X- Go to Step3).
• If no change = Effective date should be the same
• If the rate is changed, update the rate with an effective date of the assignment.
Sample Craft Rate
The craft rate will be average from all the average grades of the Job. In the following example, the average rate will be 15, which will be sync to craft rate in Oracle Utilities Work and Asset Cloud Service.
• Manual addition of expense account for Craft and attach at the craft level. This is a prerequisite to the integration.