In this blog, we’ll demonstrate how to manage Workflow Requests using REST API in Oracle Fusion HCM. Focusing on a resignation transaction, we’ll guide you through retrieving, updating, and approving workflows with simple steps. Let’s explore how to efficiently handle these processes using Postman and the Transaction Console.

Use Case: Can we query, get, retrieve, and update a Workflow Requests using REST API in Oracle Fusion HCM? 

Feasibility Check: In Oracle Fusion HCM as on 24D: Yes, this is achievable. 

Steps to perform for Approving Workflow Requests Using REST API in Oracle Fusion HCM 

• The transaction we will be considering for this use case is Resignation.
• Before taking any further steps, let’s confirm we have a proper workflow rule configured for a transaction.  

Example: Transaction initiated by employee >> Request is assigned to Line Manager for Approval. 

Step 1: Employee login into the application.  
Employee Name: John Cruz 

Step 2: Employee Navigate to Me >> Quick Actions >> Resignation 

Step 3: Employee Submits Resignation 

Step 4: Login as Manager 
Employee Name: Pierce Brooks 

Step 5: Manager sees Employee Resignation request in workflow: 

Step 6: Get the Transaction ID for the request from Tools >> Transaction Console
(you need to login with Admin credentials to check): 

 Step 7: Find the Transaction Number by running the query below.
(You need to login with Admin credentials to run these queries) 

SELECT * FROM FA_FUSION_SOAINFRA.WFTASK WHERE IDENTIFICATIONKEY = TO_CHAR(300000292586786) 

Step 8: Login to Postman application: 

Step 9: Select Get Method and pass the following on to the Request box:

https://fa-etit-saasfademo1.ds-fa.oraclepdemos.com/bpm/api/4.0/tasks/1400560

Note: 1400560 is a task number from the above step. 

• In the Authorization Tab, input the Username and password of the Manager. 

• Click on Send 
• Below Response will be received. 

• If we can clearly observe from the above response, the actionList, suggests the actions that can be performed by the requestor of this API request (which is manager).  

Level up your expertise with Oracle Fusion HCM Core Implementation Training

"actionList": [ 
    { 
            "length": 0, 
            "title": "CREATE_TODO", 
            "actionId": "CREATE_TODO", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "VIEW_PROCESS_HISTORY", 
            "actionId": "VIEW_PROCESS_HISTORY", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
   "title": "VIEW_TASK", 
            "actionId": "VIEW_TASK", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "VIEW_TASK_HISTORY", 
            "actionId": "VIEW_TASK_HISTORY", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "ESCALATE", 
            "actionId": "ESCALATE", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "VIEW_SUB_TASKS", 
            "actionId": "VIEW_SUB_TASKS", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "CUSTOM", 
            "actionId": "CUSTOM", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "SAVE", 
            "actionId": "SAVE", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "UPDATE_ATTACHMENT", 
            "actionId": "UPDATE_ATTACHMENT", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "UPDATE_COMMENT", 
            "actionId": "UPDATE_COMMENT", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "INFO_REQUEST", 
            "actionId": "INFO_REQUEST", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "REASSIGN", 
            "actionId": "REASSIGN", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "SUSPEND", 
            "actionId": "SUSPEND", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "DECOMPOSE_TASK", 
            "actionId": "DECOMPOSE_TASK", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
            "title": "DELEGATE", 
            "actionId": "DELEGATE", 
            "actionType": "System" 
        }, 
        { 
            "length": 0, 
       "title": "Approve", 
            "actionId": "APPROVE", 
            "actionType": "Custom" 
        }, 
        { 
            "length": 0, 
            "title": "Reject", 
            "actionId": "REJECT", 
            "actionType": "Custom" 
        } 
    ], 

• We will use “Approve” action, to Approve the request from API using Postman 

• To Approve the workflow, we need to do the following:  

In the Method select: PUT 
Paste the following in Request:  
https://fa-etit-saasfademo1.ds-fa.oraclepdemos.com/bpm/api/4.0/tasks/1400560 

In the Body, select the Raw option and base the following: 
{ 
    “action”:{“id”: “APPROVE”} 
} 
 
The request will look like the below: 

• Click on Send, and we will receive response stating the outcome: Approve, state: Completed 

• The request in the transaction console will show as Approved

References and Credits:  

• https://docs.oracle.com/en/cloud/saas/human-resources/24b/farws/Retrieving_List_of_Tasks.html 
• https://docs.oracle.com/middleware/12212/bpm/bpm-rest-api-ref/op-tasks-get.html

Author: Rafatullah BS is a Solution Architect at Fusion Practices