Skip to main content

Oracle HCM Integration

An overview on integrating Oracle HCM to Workia to get your process going.

Written by Carlo Arazas
Updated yesterday

Oracle Fusion Cloud HCM is a comprehensive, cloud-native HR software suite designed to manage the entire employee lifecycle, from hiring to retirement. It integrates core HR, payroll, talent management, and workforce management into a single platform featuring AI-embedded tools for improved decision-making and a unified employee experience

With our Oracle HCM integration, you can easily automate and synchronize your records from your Oracle HCM system to Workia.

How to connect Oracle HCM to Workia?

An initial connection must be established from Oracle HCM to begin the integration. To get started, click on your Profile Icon > Settings > Connections. Navigate to the Oracle HCM connection and click Connect.

💡 Quick check! An active integration will show a green check mark on the top of the card on the connections screen and an "Enabled" status tag on connection settings indicating that the integration is in use.

Once you have opened the connection settings screen, you will find a list of fields requiring the Oracle HCM details needed to connect to the Workia app. An asterisk (*) denotes that it is a mandatory field and must be provided for the integration to work.

Fields required for the connection:

  • Issuer* —Trusted issuer name for your Oracle API authentication.

  • Username*

  • Private key* — Private key associated with your public certificate. For more information on how to retrieve private key refer to Oracle API documentation.

  • Certificate fingerprint* — Must be base64 encoded. For more information on how to retrieve your certificate fingerprint refer to Oracle API documentation.

  • Subdomain* — Provide the subdomain(e.g.servername.fa.us2.oraclecloud.com).

After inputting the required details to the connection settings, click on "Connect" to proceed with the integration.


Once connected, you will see the Connection success status appear beside the "Disconnect" button on the lower left corner of the connection settings.


Enabling the Oracle HCM connection

In the connection settings screen, click on "Enable" on the upper right of the screen. Select which roles can search and select employees from Oracle HCM during move initiation. Users with this permission will be able to pull employee data directly from Oracle HCM into Workia.


Your connection with Oracle HCM will be active and the Enabled status tag will appear on the upper right corner of the connection settings.

💡Note: Please review role access carefully. Granting this permission may allow users to view sensitive employee data available in Oracle HCM, such as compensation or other confidential fields.

What Oracle HCM fields are supported?

The table below shows all the available fields that are mapped from Oracle HCM to Workia.

Oracle HCM

Workia

Person Number

Employee Number

Email

Email

First Name

First Name

Last Name

Last Name

Date of birth

Date of Birth

Phone Number

Phone Phone Number

Workers Address

Employee Address

Gender

Gender

Marital Status

Marital Status

Salaries - Date From

Annual Base Salary Effective Date

Salaries - Annual Salary

Annual Base Salary Amount

Salaries - Currency Code

Annual Base Salary Currency

Business Unit

Org info - Business Unit

Legal Employer Name

Org info - Legal Entity

Cost Center

Cost Center

Job Name

Job Title

Grade Code

Job Grade

Start Date

Hire Date

Actual Termination Date

Termination Date

How do I disable and/or remove the Oracle HCM integration?

Disabling the Oracle HCM connection

To disable the connection, go to the Oracle HCM connection settings and click on the "Enabled" status tag on the upper right corner of the connection settings.

A modal will appear, click on the "Disable" button to stop the connection from Oracle HCM to Workia.


This will stop any updates or changes that rely on this connection, but do note that your Oracle HCM account is still connected to Workia!

Removing your Oracle HCM connection

To disconnect and remove your Oracle HCM account from Workia, click on the "Disconnect" button on the lower left corner of the connection settings.


Do note that in order to use the integration again, you must re-enter your Oracle HCM login details on the connection settings.



Did this answer your question?