Oracle Fusion Applications Integration with Microsoft Teams now available

November 21, 2023 | 5 minute read
Angelo Santagata
Architect
Text Size 100%:

In November 2023, Oracle announced that Oracle Social Network has reached "End of Life" and from Fusion Applications Update 24C it will no longer be available for use. This sample solution has been made available and demonstrates how to integrate Fusion Applications with Microsoft Teams. Please see Oracle support note 2965583.1 for more details on the Oracle Social Network Cloud Service (OSN) end of life. 

Customers can now choose to implement this custom solution or implement their own solution . Furthermore the source code to the solution has been released with an OTN license that allows production use and modifications. Customers can implement this solution as is, or they can customize/extend the solution to meet their needs.

Supported Features

The solution supports the following features:

  • Ability to create teams, and associated conversations, in Microsoft Teams for an Oracle Fusion business object, all from within the Oracle Fusion user interface
  • Ability to view conversations stored in channels, within Oracle Fusion, without needing to use the Microsoft Teams client.
  • Ability to view conversations that support text, images, emojis and links to attachments.
  • Ability to view conversations in Oracle Fusion without being a member of the team. If you have access to the object in Oracle Fusion then you are able to view the conversation.
  • Ability to navigate to the specific conversation in Microsoft Teams. When this is done, you are automatically added to the team and will receive Microsoft Teams notifications etc.
  • Non-Oracle Fusion users can be added to conversations without needing an Oracle Fusion Applications account.
  • Support for 13 objects in Oracle Fusion
  • Support for change events for 5 Oracle Fusion objects. When an object is changed in Oracle Fusion, a message is added to the conversation in Microsoft Teams and the header card is updated.
  • Extensible architecture, ready to support new objects and change events or add custom functionality, e.g., auditing data to a custom database of your choice.
  • Conversation data is stored only in Microsoft Teams

 

Example Screenshot

Conversation Creation with Optional Change Events

When users navigates to a supported object in Oracle Fusion, they will have the option to show the Microsoft Teams conversation. If the object doesn’t have a conversation associated with it, the user is then given the option of creating a conversation for this object without needing to navigate to Microsoft Teams.

Create Channel Dialog

When conversations are created, a header card is automatically created as the first message of the conversation. The header card displays customizable key information related to the object. For objects which support change events, the header card is kept up to date and a message highlighting the changes is added to the conversation. This means members of the conversation are immediately notified of changes.

Supported Objects in V1

The integrated in version 1 supports the following object and change events . If you want to support a new object it is possible by following one of the guides in the "Whats Next" section, e.g. How to add support for new objects in Fusion Applications User Interface

Supported Objects

Fusion Product Family Fusion Business Object Supported Oracle Fusion User Interface Screen Supports Change Capture?
Procurement Requisitions Purchase Requsition  No
Procurement Purchase Order Purchase Order No
Procurement Sourcing Manage Negotiations No
Supply Chain Manufacturing
Work Order
Edit Work Orders Yes
Supply Chain Maintenance Asset Manage Assets Yes
Supply Chain Transfer Order Manage Transfer Order Yes
Finance Journal Batch Manage Journals (Tasks) Yes
Finance Receiveable Invoices Billings No
Finance Payables Invoices Manage Invoices No
Finance Period Close Period Close No
Sales Contract Manage Contracts No
Sales Opportunity Opportunities Yes
Sales Activity Sales Activities Yes

Whats Next?

For more information on this solution the best approach is to download the solution from https://www.oracle.com/middleware/technologies/fusion-applications-downloads.html . The download file will contain all the install guide , a user guide and all the source code for the solution.

We have also published the following blogs here on A-Team chronicles explaining the architecture and how we can extend the sample :

A-Team

Angelo Santagata

Architect

25+ years of Oracle experience, specialising in Technical design and design authority of Oracle Technology solutions, specialising in integrating technology with Oracles SaaS products.

Extensive credible communication skills at all levels, from hard core developers to C-Level executives.

Specialities: Oracle Fusion Apps Integration, Oracle Cloud products, SaaS Integration architectures, Engaging with SIs & ISVs, Technical Enablement, Customer Design Reviews,  advisory and project coaching.

TOGAF 9 Architect and Oracle Cloud Infrastructure Architect Certified