Oracle HCM Cloud Configuration for Employee
This section focuses on importing the files that are part of the package and configuring them in the Oracle Human Capital Management Cloud environment for the integration to run successfully. Make sure to follow the same sequence for successful configuration.
Importing the extract definition includes the following:
Creating a Profile
A user profile is a set of changeable options that affect the way Oracle applications appear and how they function. Oracle applications use a set of user profile options that are common to all the applications. In addition, each module has its own unique set of user profile options.
For Employee Integration extract definition, create the following profile:
Managing Profile Options
1. Navigate to Setup and Maintenance > Search > Manage Profile Options.
2. Click the add button (+) to create a profile.
(HCM_WACS_JOB_RATE_ANNUAL_HRS_PRF)
Profile Option Code: HCM_WACS_JOB_RATE_ANNUAL_HRS_PRF
Profile Display Name: “HCM: WACS Job Rate Annual Hours”
Application: Fast Formula
Module: Global Human Resources
Description: Global Human Resources
*Start Date: 1/1/51
![Edit Profile Option window that shows the text fields to be populated by the user to set a profile. Edit Profile Option window that shows the text fields to be populated by the user to set a profile.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration1-oraclehcm-createprofile.png)
3. Click Save.
4. Select the record under
Search Results: Profile Options![Manage Profile Options pages showing the Search Results: Profile Options section. Manage Profile Options pages showing the Search Results: Profile Options section.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration2-oraclehcm-selectrecord.png)
5. Enable the levels as shown in the figure below.
![Profile Option Levels detail showing Site and User options as Enabled and Updatable. Profile Option Levels detail showing Site and User options as Enabled and Updatable.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration3-oraclehcm-enablelevels.png)
6. Click Save and Close.
Managing Administrator Profile Values
1. Navigate to Setup and Maintenance > Search > Manage Administrator Profile Values and search for the “HCM_WACS_JOB_RATE_ANNUAL_HRS_PRF” profile.
2. Select the record under Search Results: Profile Options.
3. Click the add button (
+) in the
Profile Values section. Add the annual hours value.
![Manage Administrator Profile Values showing the Search Results: Profile Options section and the Profile Values section. Manage Administrator Profile Values showing the Search Results: Profile Options section and the Profile Values section.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration4-oraclehcm-addannualhoursvalue.png)
4. Select
Site in the
Profile Level drop-down list.
Profile Value indicates the number of working hours in an Organization Year.
![Detail of the Profile Level drop-down list that is located under the Profile Values section. Detail of the Profile Level drop-down list that is located under the Profile Values section.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration5-oraclehcm-selectsite.png)
This profile value is used to calculate the salary annual rate. The figure shows the default value 2080; it is the number of working hours in a year. Note that the hours vary based on the working days in an organization (to be used as per business case).
Value Sets
1. Login to the system with appropriate user or role.
2. Navigate to Setup and Maintenance > Search > Manage Value Sets for Global Human Resources.
3. Search for
Manage Value Sets for Global Human Resources (Workforce Structures).
![Search Task Results pop-up window that appears when selecting Manage Value Sets for Global Human Resources and contains its available functional areas, in this case, Workforce Structure and Workforce Information. Search Task Results pop-up window that appears when selecting Manage Value Sets for Global Human Resources and contains its available functional areas, in this case, Workforce Structure and Workforce Information.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration8-oraclehcm-managevaluesets.png)
4. Enter the details as in the table below.
a. To create a Manager Type with the following values:
HCM_WACS_MANAGER_TYPE_VS
HCM: WACS Manager/Supervisor Type
b. To create the Annual Rate Value Sets:
a. Login to the system with the appropriate user or role.
b. Navigate to Setup and Maintenance > Search.
c. Search for “Manage Value Sets for Global Human Resources” (Workforce Structures).
![Search Task Results pop-up window that appears when selecting Manage Value Sets for Global Human Resources and contains its available functional areas, in this case, Workforce Structure and Workforce Information. Search Task Results pop-up window that appears when selecting Manage Value Sets for Global Human Resources and contains its available functional areas, in this case, Workforce Structure and Workforce Information.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration13-oraclehcm-managevaluesets.png)
c. Enter the following details for the value set.
HCM_WACS_GET_PROFILE_JOB_ANNUAL_HRS_VS
Note: Annual Rate Value Set is based on “HCM_WACS_JOB_RATE_ANNUAL_HRS_PRF”.
d. Click Save and Close.
HCM_WACS_JOB_SET_VS
1. Create a new value set.
2. Enter the following details for the value set.
3. Search for Setup and maintenance > Search > Manage Value Sets for Global Human Resources (Workforce Structures).
4. Create a new value set and provide the details as below.
HCM_WACS_LEGISLATIVE_GROUP_VS
1. Create a new value set.
2. Enter details for the value set.
3. Navigate to Setup and maintenance > Search > Manage Value Sets for Global Human Resources (Workforce Structures).
4. Create new value set and provide the details as below.
Extract Upload
Make sure to upload the extract after all the configuration are done for all the Employee/Craft/Absence sections.
Important! Verify that Profile, Value sets and Fast formula are uploaded before running the extract upload process.
To extract the upload:
1. Login with the HCM/Data Exchange user role.
2. Navigate to
My Client Groups and click
Data Exchange.
![Home page showing the My Client Groups section where Data Exchange option is to be found. Home page showing the My Client Groups section where Data Exchange option is to be found.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration17-oraclehcm-dataexchange.png)
3. Click
Extract Definitions.
![HCM Extracts list where Extract Definitions option is to be found. HCM Extracts list where Extract Definitions option is to be found.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration18-oraclehcm-extractdefinitions.png)
4. Select Upload and click Browse.
5. Upload the extract file “HCM_EMP_WACS”. The file is available in the package.
![Extract Definitions page where the extract file is to be uploaded. Extract Definitions page where the extract file is to be uploaded.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration19-oraclehcm-extractdefinitionsfile.png)
6. Compile the extract. After successful compilation, click Validate.
7. Save the extract.
8. Click the edit icon (a pencil) to query the extract.
![Extract Definitions page showing the name and type of the extract. The pencil icon for editing is the second to the extreme right of the extract row. Extract Definitions page showing the name and type of the extract. The pencil icon for editing is the second to the extreme right of the extract row.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration20-oraclehcm-editicon.png)
9. Navigate to
Advanced and click
Extract execution Tree on the left navigation pane. When the status is green, validate it. Save and close.
![Edit Extract Definition page. To the right, the navigation pane. To the left, the extract’s different objects and their details, namely: type, xml tag, and status. Edit Extract Definition page. To the right, the navigation pane. To the left, the extract’s different objects and their details, namely: type, xml tag, and status.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration21-oraclehcm-editipage.png)
10. Click the extract definition.
![Extract Definitions page showing the name and type of the extract. Extract Definitions page showing the name and type of the extract.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration22-oraclehcm-clickextract.png)
11. Enter a definition to lock the extract. After successful lock, save and close.
![Define page. On the navigation pane to the left the first option, Define, is selected. To the right, the Extract Attributes and the Parameters section are shown. On the Extract Attributes section the Lock Definition checbox is selected. Define page. On the navigation pane to the left the first option, Define, is selected. To the right, the Extract Attributes and the Parameters section are shown. On the Extract Attributes section the Lock Definition checbox is selected.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration23-oraclehcm-defineandsave.png)
To verify the Run page:
1. Review all the values and mandatory fields.
![Define page. On the navigation pane to the left the first option, Define, is selected. To the right, the Extract Attributes and the Parameters section are shown. The table with the values and their fields is located under the Parameters section. Define page. On the navigation pane to the left the first option, Define, is selected. To the right, the Extract Attributes and the Parameters section are shown. The table with the values and their fields is located under the Parameters section.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration24-oraclehcm-checksetsandfields.png)
Note: The lookup values are also displayed in the Parameters section. The Legal Entity is not attached to smart LOV.
2. To refine the extract, search for the extract and navigate to Parameters > Edit.
3. Click
Legal Entity. Search and add the Legal Entity “LegalEmployerPVO” Smart LOV.
![Payroll Flow Patterns page. The Parameters tab, which is third from left to right, is selected. Legal Entity is to be found under the Flow Parameter column. Payroll Flow Patterns page. The Parameters tab, which is third from left to right, is selected. Legal Entity is to be found under the Flow Parameter column.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration25-oraclehcm-legalentity.png)
4. Navigate to the
Submit Extracts page and verify that the respective fields are populated with the appropriate values.
![Data Exchange page showing the HCM Extracts section, under which the Submit Extracts option is being pointed to. Data Exchange page showing the HCM Extracts section, under which the Submit Extracts option is being pointed to.](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration28-oraclehcm-submitextractslink.png)
5. On the
Submit Extract Instance page, verify that the
Manager Type,
Legal Entity and
Annual Rate fields, under the
Criteria section, are populated with values in accordance with the configuration.
![](../HCM-WACS_SETUP_GUIDE_22B/images/employeeIntegration30-oraclehcm-verify.png)
Note: If the Legal Entity, Manager Type and Annual Rate fields are empty, verify that the account accessing the data extract has privileges to perform extract configuration and submit extract definitions.
After the report is submitted, report extract is available in UCM for the Oracle Integration Cloud process.