Oracle HCM to JSM Assets
Configure the connection to Oracle HCM by going to OnLink (Manage your apps) - Connections. Then click on Add System and select “HR Assets Sources”. You will need username, password and URL (e.g. url - https://domain.oraclecloud.com:443, servername.fa.us2.oraclecloud.com) to connect.
Once connection is established, please review instructions here to get started with setting up an Assets import configuration. You can then access OnLink app from the “Manage your apps” menu to further configure and set the field level mapping.
Here’s an example mapping configuration. Any field available in this Oracle API can be used to map to the asset attribute.
key:PersonNumber=WorkerID
map:WorkEmail=User
map:FirstName=First Name
map:LastName=Last Name
map:assignments.0.ManagerId=ManagerUserId
Here’s a breakdown of some of the mapping configuration items:
Key or Map | Description |
---|---|
| The keyword “key” refers to using Worker ID as a unique identifier. This allows OnLink to update the record. |
| Maps email to User which can be an attribute of type User |
| Can be set to any other API from Oracle as well - REST API for Oracle Fusion Cloud HCM Update the mapping based on the API response to import data from any Oracle API to JSM Assets |
Any other field returned by the API can be used in the mapping.
OnLink processes data in two steps - Get Data and Import Data. To manually test, you can click on Get Data first and then wait until you see “No more pending records. Data will be imported on next Import run.” message in Job Logs. Then, click on Import. Production runs are fully automated based on the schedule you choose.