1. Consolidate Tasks from Multiple Oracle Applications Into a Unified List
  2. Learn About Consolidating Tasks from Multiple Oracle Applications Into a Unified List

Learn About Consolidating Tasks from Multiple Oracle Applications Into a Unified List

Oracle applications and enterprise applications running on Oracle's platform provide task lists to remind you of pending actions or to notify you of system changes. With multiple applications providing their own task lists, you need to log into each one to view its specific tasks, which is tedious and unproductive.

This solution shows you how to use Oracle Visual Builder to embed a PaaS task list into a Fusion Applications UI so that you can view all of your tasks in one place, regardless of notifying application.

Architecture

The architecture for this solution describes interactions between participating applications, Oracle Visual Builder and Oracle Identity Cloud Service (IDCS)
Description of consolidate_paas_ui_high_level.png follows
Description of the illustration consolidate_paas_ui_high_level.png

This code requires that all participating enterprise applications are configured with SAML 2 federation, so that navigation between them and the unified tasklist is seamless. It also requires oAuth trust is established between applications and IDCS so that each application's API can recognize the current Oracle Identity Cloud Service user. Each participating enterprise application must be able to provide a list of tasks over REST API and support oAuth. Finally, each enterprise application must allow a direct GET request to its task details page when reference to a task is provided.

The main web page, upon initiation, determines the list of configured enterprise applications and fetches the REST endpoint for each application to fetch a list of tasks. These REST API requests are made with an oAuth token inserted by IDCS. This oAuth token asserts the identity of the currently logged-in user. Upon receiving the results, the web page then translates the fields into a list of fields displayed on the main page. The list of tasks is also updated upon translating results from each configured enterprise application's REST endpoint. The list of tasks stops updating when all the endpoints have been accessed, or when there is a failure with an endpoint. In case of a failure, an error message is displayed at the top of the page and subsequent processing of task list REST endpoints is stopped.

Each task on the list has a link to task page URL native to the corresponding enterprise application, with a reference to a task in query parameters. When user clicks on a task on the unified tasklist, the relevant task page is launched on new tab. The target task page loads using Federated SSO, gets the task reference from request and displays the task details. User can perform any action supported by the native task page of the enterprise application.

Prerequisites to Consolidating Tasks from Multiple Oracle Applications Into a Unified List

To successfully complete this solution, first address these prerequisites:
  • This code requires Oracle Visual Builder 19.4.3 or later.
  • You need to have access to one or more SaaS or PaaS products that expose their list of Tasks via REST services.
  • All REST services must support OAuth for authentication and authorization.
  • The Oracle Visual Builder Web application provided in the code requires that the various Oracle Visual Builder, SaaS and any PaaS application have their identities federated.

Understand Consolidation Steps

Consolidating tasks from multiple Oracle applications into a unified list requires these steps:
  • Prepare your environment by cloning the repository to your local folder, add the files and folders from the repository (except highlevel.png and .gitignore) to a .zip file named UnifiedTaskList_VBCS.zip, and then import this .zip as an application to your Oracle Visual Builder instance.
  • Within Oracle Visual Builder add one or more SaaS or PaaS applications as task sources to configuration and update configuration as instructed in 'Sample configuration' section below.
  • Add a Oracle Visual Builder service connection to the REST API for each task source.
  • Run the application to test the task list.
  • Deploy the application to production Oracle Visual Builder instance.