App Connect

 View Only

Using IBM® App Connect to interact with Oracle Human Capital Management

By Shahmini Arumugam posted Mon June 13, 2022 05:06 AM


Oracle Human Capital Management is a complete cloud-based human resource management solution that enhances the capabilities and experiences of Human Resources (HR).

Oracle Human Capital Management transforms the conventional administrative functions of HR departments, such as recruitment, training, payroll, compensation, and performance management into opportunities to drive engagement, productivity, and business value.

Oracle Human Capital Management (HCM) supports several modules that are grouped into the following categories:

  • Human Resources
  • Talent Management
  • Recruiting
  • Learning
  • Workforce Management
  • HCM Analytics
  • Payroll

Building a flow in App Connect with Oracle Human Capital Management

Use IBM App Connect to build flows that integrate with Oracle Human Capital Management and other applications. The connector is displayed as Oracle Human Capital Management on the IBM App Connect User Interface (UI).

Provide the following information to connect App Connect to your Oracle Human Capital Management cloud instance.

Required credentials


Endpoint URL

The URL of your Oracle Human Capital Management cloud instance


The username to log in to your Oracle Human Capital Management cloud instance


The password for the specified username

The following table lists the Oracle Human Capital Management objects that can be run in App Connect.

Absence plan balances

Job requisitions

Talent person profile attachments

Absence records


Talent person profile work histories

Campaign details


Talent person profiles

Candidate attachments

Performance evaluations

Time record event requests

Candidate education

Performance goals

Time records

Candidate experiences

Personal payment methods

Worker assignments

Candidate licenses and certifications


Worker reports


Salary components


Direct reports

Talent certifications

Job requisition attachments

Talent competencies

Scenario: Create a list of workers for an upcoming assignment in Google Sheets from Oracle Human Capital Management workers' records


Consider the following scenario where you use App Connect to create a flow to integrate Oracle Human Capital Management with Google Sheets and notification applications.

Oracle Human Capital Management retrieves workers’ details and creates an entry in Google Sheets whenever a worker’s status is ‘inactive’, which indicates that the worker is not attached to any assignment. A notification is then sent through Microsoft Teams whenever an employer’s detail is added to the list in Google Sheets. This flow helps to assign eligible workers to an upcoming assignment.

For this scenario:
  1.  You run a scheduler-based flow that retrieves workers and worker assignments from Oracle Human Capital Management through a batch process.
    • The Retrieve workers operation retrieves workers from Oracle Human Capital Management records.
    • The Retrieve worker assignments operation retrieves the period of service of a worker.
  2. Include an If and Else conditional statement node from the Toolbox.
    1.  If the Oracle Human Capital Management assignment status type is ‘INACTIVE’, it retrieves the talent person profiles based on the person number.
      Input for If condition:  
        if {{$OracleHumanCapitalManagementRetrieveworkerassignments.AdditionalProperties.AssignmentStatusType}} = INACTIVE
      1.  An entry is made in the Google Sheets with the worker’s details. For example: Create-rowSpreadsheet-columnsc. Else, a Slack message is sent to the intended channel with the following content: Person ID is active, not available for project

          3. A Microsoft Teams notification is posted on a dedicated channel stating that the Google Sheets is updated with the worker’s allocation status.

          IBM® App Connect supports a wide range of data formats, application infrastructures, and integration styles. For more information, see IBM® App Connect connectors.