Oracle Human Capital Management Cloud Configuration for Craft
This section focuses on importing the files that come as a 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.
The following topics are included:
Defining Extensible Flexfield
To define an extensible flexfield:
1. Navigate to Setup and Maintenance > Search.
2. Click
Manage Workforce Structures Extensible Flexfields.
![Search Tasks page where Manage Workforce Structures Extensible Flexfields result is being pointed to. Search Tasks page where Manage Workforce Structures Extensible Flexfields result is being pointed to.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration1-OHCMC-defineextensibleflexfield.png)
3. Click
PER_JOBS_EIT_EFF.
![Manage Workforce Structures Extensible Flexfields page where PER_JOBS_EINT_EFF option is being selected. Manage Workforce Structures Extensible Flexfields page where PER_JOBS_EINT_EFF option is being selected.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration2-OHCMC-clickPER_JOBS.png)
4. Click the pencil icon to edit.
![PER_JOBS_EINT_EFF view on the Manage Workforce Structures Extensible Flexfields page. The pencil icon to edit is the fourth element from left to right under Search Results. PER_JOBS_EINT_EFF view on the Manage Workforce Structures Extensible Flexfields page. The pencil icon to edit is the fourth element from left to right under Search Results.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration3-OHCMC-editicon.png)
5. On the
Manage Workforce Structures Extensible Flexfields edit view, click
Manage Contexts.
![Manage Workforce Structures Extensible Flexfields edit view. The Manage Context button is the fourth and last element from right to left on the upper right corner of the page. Manage Workforce Structures Extensible Flexfields edit view. The Manage Context button is the fourth and last element from right to left on the upper right corner of the page.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration4-OHCMC-managecontext.png)
6. Click the add button (
+).
![Manage Contexts page. The add button is the fourth element from left to right on the first row under Search Results section. Manage Contexts page. The add button is the fourth element from left to right on the first row under Search Results section.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration5-OHCMC-addicon.png)
7. Add Context Usage and Add Context Sensitive Segments.
Flexfield Name: Job EIT Information
Flexfield Code: PER_JOBS_EIT_EFF
Display Name: WACS_JOB
Code: WACS_JOB
API name: WacsJob
Description: WACS JOB
Enabled: YES
Instruction Help Text: WACS Job
![Edit Context page showing the Context Sensitive Segments section and the Context Usage tab. Edit Context page showing the Context Sensitive Segments section and the Context Usage tab.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration6-OHCMC-adddetails.png)
8. Click
Save.
![Edit Context page showing the Context Sensitive Segments section and the Context Usage tab. The Save button is the third element from right to left on the upper right corner of the page. Edit Context page showing the Context Sensitive Segments section and the Context Usage tab. The Save button is the third element from right to left on the upper right corner of the page.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration7-OHCMC-savedetails.png)
9. Navigate to Context Sensitive Segments and click the add button (+) to add a segment. Fill the data as shown below.
Name: WACS_JOB
Code: WACS_JOB
API Name: wacsJob
Data Type: Character
Value Set: Yes or No
Prompt: WACS_JOB
Display Type: List of Values
BI Enabled: Yes
![Context Sensitive Segments add view with the text fields to be populated in accordance with the above instruction. Context Sensitive Segments add view with the text fields to be populated in accordance with the above instruction.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration8-OHCMC-adddetails.png)
10. Click
Save and Close.
![Edit Context page. The Save and Close button is located on the upper right corner. Edit Context page. The Save and Close button is located on the upper right corner.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration9-OHCMC-WACS_JOB.png)
11. Select the search result and click the add button (
+).
![Manage Workforce Structures Extensible Flexfields page. The add icon is the fifth element from left to right under the Associated Contexts tab, which is under the Job Extra Information: Details section. Manage Workforce Structures Extensible Flexfields page. The add icon is the fifth element from left to right under the Associated Contexts tab, which is under the Job Extra Information: Details section.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration10-OHCMC-selectandadd.png)
12. Search for “WACS_JOB”. Click Apply and then OK. The Associate page is shown as below after the Associated context is attached.
13. Click Save and Close.
14. Deploy Flexfield as shown below and make sure that the deployment status is highlighted in green.
![Manage Workforce Structures Extensible Flexfields page. The Deploy Flexfield button is the eight element from left to right on the row immediatly under the Search Results heading. Manage Workforce Structures Extensible Flexfields page. The Deploy Flexfield button is the eight element from left to right on the row immediatly under the Search Results heading.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration12-OHCMC-deployflexfield.png)
To attach an EFF to a job in ERP:
1. Query any job that needs to be attached. Filter WACS JOB and attach EFF.
2. Navigate to
Setup and Maintenance >
Search >
Manage Jobs.
![Search Task Results window that pops up after selecting Manage Jobs. This window displays the different job tasks and their functional areas. Search Task Results window that pops up after selecting Manage Jobs. This window displays the different job tasks and their functional areas.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration13-OHCMC-managejobs.png)
3. Query the Required JOBS.
![Manage Jobs page showing the Search and Search Results sections. The pencil icon to edit is the fourth element from left to right of the row that is immediatly under the Search Results section. Manage Jobs page showing the Search and Search Results sections. The pencil icon to edit is the fourth element from left to right of the row that is immediatly under the Search Results section.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration14-OHCMC-managejobspage.png)
4. Click the job name and edit it.
![Job edit view. The Edit button is the second element from right to left within the Basic Details section that is shown when the Job Deitals tab is selected. Job edit view. The Edit button is the second element from right to left within the Basic Details section that is shown when the Job Deitals tab is selected.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration15-OHCMC-editjob.png)
5. Click
WACS Job and select
Yes from the LOV.
![WACS_JOB section under Job: Extra Information. WACS_JOB section under Job: Extra Information.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration16-OHCMC-WACS_JOB.png)
6. Click Done.
JOB006 is displayed in the Bulk extract or Incremental (if any changes).
Fast Formula
To use the Fast Formula file from the package available for Job extract:
1. Navigate to Setup and Maintenance > Search > Fast Formulas.
2. Enter
Formula Name,
Type and
Description from the package (refer to the accelerator package on Market Place). Click
Continue.
![Fast Formula page showing the Create Fast Formula pop-up window where the mentioned fields are to be populated. Fast Formula page showing the Create Fast Formula pop-up window where the mentioned fields are to be populated.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration17-OHCMC-createfastformula.png)
3. Take the text file (HCM_WACS_JOB_RATE_FF.txt) from the accelerator package and paste its code to Fast Formulas.
Formula Name: HCM_WACS_JOB_RATE_FF
Type: Extract Rule
Effective Start Date: 1/1/51
Description: HCM: WACS JOB Rate Calculation
4. Save it and click
Compile.
![Fast Formulas page. The Compile button is the third element from right to left on the upper right corner. Fast Formulas page. The Compile button is the third element from right to left on the upper right corner.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration19-OHCMC-fastformula-savecodeandcompile.png)
5. Make sure the Compile Status shows a green icon with a check-mark.
Business Intelligence Report Template for Job (Used in Data Exchange)
This template is used in data exchange to calculate the average rate of the job using the midpoint of multiple grades attached to it. For more information, refer to the Business Rules section.
Use the “.xdo.calatalog” file from package to a specified folder: Shared > Custom > HCMJOBWACS
Migrating Reports in Oracle Cloud Instance
The migration process involves un-archiving the report and data model.
To migrate reports in Oracle Cloud Instance:
1. Navigate to Tools > Report and Analytics.
2. Browse to the folder where the report and data model is placed.
3. Create a “HCMWACSJOB” folder in
Shared Folder >
Custom Folder (the name cannot change).
![Detail of the Transactional Business Intelligence catalog showing the Folders navigation pane to the left. My Folders folder is being selected. Detail of the Transactional Business Intelligence catalog showing the Folders navigation pane to the left. My Folders folder is being selected.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration20-OHCMC-BIreport-createfolder.png)
4. Use the files in the package with an extension of “xdo.catalog”.
5. Un-archive the report and data model.
![Detail of the Transactional Business Intelligence catalog showing the Folders navigation pane to the left and the Tasks pane under it. The Unarchive option appears on the right column of the My Folders section under Tasks. Detail of the Transactional Business Intelligence catalog showing the Folders navigation pane to the left and the Tasks pane under it. The Unarchive option appears on the right column of the My Folders section under Tasks.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration21-OHCMC-BIreport-unarchive.png)
6. Un-archive files in the new instance.
a. Navigate to the folder where the report should be uploaded.
b. Click Unarchive in the Tasks pane.
c. The system prompts to browse and upload the file from your desktop. Make sure to select the “.xdo.catalog” file for the report.
![Detail of the Transactional Business Intelligence catalog showing the Folders navigation pane to the left. The HCM_JOBWACS folder is being selected. Detail of the Transactional Business Intelligence catalog showing the Folders navigation pane to the left. The HCM_JOBWACS folder is being selected.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration22-OHCMC-BIreport-selectfile.png)
Extracting an Upload
To extract an upload:
1. Navigate to Tools > Report and Analytics > Data Exchange > HCM Extract.
2. Click Upload and Browse.
3. Upload the extract file “HCM_JOB_WACS”.
![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/craftIntegration23-OHCMC-extractUpload-dataexchange.png)
4. Click Compile and Validate.
5. Query the extract. Navigate to Advanced and click Extract Execution Tree.
6. After the Compile Status is green, click Save and Close.
7. Click the extract definition. Lock and save it.
8. Check all the value sets and mandatory fields are set.
9. Click the name of the extract.
10. Check if the Run screen is populated with the appropriate values in the respective fields.
11. On the
Submit Extracts page, search for the job extract.
![Submit Extracts page. The job extract search field is located immeadiatly under the Extracts heading. Submit Extracts page. The job extract search field is located immeadiatly under the Extracts heading.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration28-OHCMC-extractUpload-searchjobextract.png)
12. Click the
Extract Name and verify the
Legislative Group and
Job Set values.
![Submit Extract Instance page showing the General Information and the Criteria sections. The Job Set and the Legislative Group mandatory fields are under the Criteria section. Submit Extract Instance page showing the General Information and the Criteria sections. The Job Set and the Legislative Group mandatory fields are under the Criteria section.](../HCM-WACS_SETUP_GUIDE_22B/images/craftIntegration29-OHCMC-extractUpload-verifyvalues.png)