Skip to main content

Oracle HCM

Oracle HCM Cloud connector for managing workers, departments, jobs, positions, and absences.

Categories: Human Resources, HRIS, HCM, Workforce Management

What you can ask​

  • List employees with upcoming performance reviews in the next 30 days.
  • Pull the headcount by department as of the end of last quarter.
  • Find every employee on PTO this Friday for staffing planning.

Set up​

Oracle HCM needs an OAuth application from your organization before anyone can connect. An organization admin completes these steps once.

  1. Go to Organization > Connectors and find Oracle HCM. Click Enable, and choose which tools to allow.
  2. Create an OAuth application in the Oracle HCM developer portal.
  3. Add the Redirect URI shown in the connector settings to the application.
  4. Copy the application's Client ID and Client Secret into the connector, then save it.
  5. Each member connects their own account the first time they use it.

⚠️ Warning: Do not enter your Devs.ai or Oracle HCM login email or password in the OAuth application fields.

To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.

Tools​

Oracle HCM offers 44 tools. Admins choose which ones agents can use. See Tool permission groups.

Read (27)​

View and search information without changing it.

ToolWhat it does
download_payslip_attachmentsBulk-download attachments for a payslip via POST /payslips/action/downloadAttachments, returned base64-encoded.
get_absenceGet a single absence record by personAbsenceEntryId from Oracle HCM.
get_departmentGet a single department by OrganizationId from Oracle HCM.
get_jobGet a single job by JobId from Oracle HCM.
get_locationGet a single location by LocationId from Oracle HCM.
get_organizationGet a single organization by OrganizationId from Oracle HCM.
get_payslipGet a single payslip by DocumentsOfRecordId from Oracle HCM via GET /payslips/{id}.
get_positionGet a single position by PositionId from Oracle HCM.
get_workerGet a single worker by PersonId from Oracle HCM.
get_worker_assignmentsGet work relationships for a worker from Oracle HCM.
get_worker_contact_infoGet contact information for a worker from Oracle HCM via the /emps endpoint.
list_absence_plan_balancesGet time-off / PTO balances for a worker from Oracle HCM via GET /planBalances.
list_absencesList absence records from Oracle HCM via /absences GET.
list_departmentsList departments from Oracle HCM via /departments GET.
list_jobsList jobs from Oracle HCM via /jobs GET.
list_locationsList locations from Oracle HCM via /locations GET.
list_organizationsList organizations from Oracle HCM via /organizations GET.
list_payslip_balance_historyList earnings and deductions (balance history) for a payslip from Oracle HCM.
list_payslip_documentsList documents attached to a payslip via GET /payslips/{id}/child/documents.
list_payslip_historyList historical payment details for a payslip from Oracle HCM.
list_payslip_paymentsList net pay distribution (payment details) for a payslip from Oracle HCM.
list_payslip_summaryList summary information for a payslip from Oracle HCM.
list_payslipsList payslips from Oracle HCM via GET /payslips.
list_positionsList positions from Oracle HCM via /positions GET.
list_workersList workers from Oracle HCM via /workers GET.
read_payslip_textRead a payslip's file (usually a PDF) as text; prefer over download_payslip_attachments to READ a payslip. payslip_id: DocumentsOfRecordId from list_payslips.
validate_credentialValidate Oracle HCM credentials by making a lightweight API call.

Write (6)​

Create or send data.

ToolWhat it does
create_absenceCreate a new absence record in Oracle HCM via /absences POST.
create_departmentCreate a new department in Oracle HCM via /departments POST.
create_jobCreate a new job in Oracle HCM via /jobs POST.
create_organizationCreate a new organization in Oracle HCM via /organizations POST.
create_positionCreate a new position in Oracle HCM via /positions POST.
create_workerCreate a new worker in Oracle HCM via /workers POST.

Delete or overwrite (11)​

Remove or replace existing data.

ToolWhat it does
delete_absenceDelete an absence record from Oracle HCM.
delete_departmentDelete a department from Oracle HCM.
delete_jobDelete a job from Oracle HCM.
delete_organizationDelete an organization from Oracle HCM.
delete_positionDelete a position from Oracle HCM.
update_absenceUpdate an absence record in Oracle HCM.
update_departmentUpdate a department in Oracle HCM.
update_jobUpdate a job in Oracle HCM.
update_organizationUpdate an organization in Oracle HCM.
update_positionUpdate a position in Oracle HCM.
update_workerUpdate a worker in Oracle HCM.
⌘J