Integrating with Oracle Fusion Cloud ERP – L2L

Oracle Fusion Cloud ERP is a complete, modern, cloud ERP suite that provides companies with a modern cloud-based version instead of their classic on-prem ERP software. As customers move to the cloud, keeping their ERP and CloudDISPATCH in sync is often one of the first integrations our customers consider.

Below is a list of general use cases for integration with ERP systems like Oracle Fusion Cloud ERP. This information contains the general workflow and best practices we have discovered working with our customers.

General ERP Use Cases:

Spares / Inventory Management
Asset Management
Master Data Management
Allocation of Labor & Spares Costs from Shop Floor Activities
Production Orders and Status

Supported Versions Details:

We support all recent versions of Oracle Cloud Fusion. Customers have a number of options when it comes to integration.

Integration Methods and Best Practices:

General Considerations

When it comes to Oracle, L2L CloudDISPATCH integration API endpoints and use cases are well-known and documented. Depending on your specific spare parts reservations, ordering, receiving, and issuing procedures you will likely need to customize the integration to match your business needs. This is normal and average for this industry. Oracle is a very powerful financial system that allows for very advanced customizations that meet industry and company-specific policies, requirements, and regulations. Based on this you should plan on customizing and tailoring our best practices to fit your needs.

Oracle Connectivity Options

You have a couple of options when it comes to connectivity. From within the Oracle Integration platform, using the REST or Utilities adapters is the ability to consume web services from external systems like CloudDISPATCH, which might be a good option depending on your needs. Oracle Fusion Cloud data can also be accessed using middleware solutions that allow you to focus more on the business rules and data flow instead of the technical connection and API details. See the following documentation section for more information to determine which method is right for your integration.

Oracle Fusion Cloud Integration Documentation

Oracle has some great documentation that can be useful during an integration. Here are some links that we found useful.

Middleware Solutions

Depending on your established internal integration standards, you might develop this integration using an existing middleware solution. We have customers who have successfully completed this using some of the following middleware solutions:

https://docs.informatica.com/integration-cloud/data-integration-connectors/current-version/oracle-financials-cloud-v1-connector/introduction-to-oracle-financials-cloud-v1-connector.html

https://help.boomi.com/bundle/connectors/page/int-Oracle_fusion_connector.html

https://anypoint.mulesoft.com/exchange/org.mule.connectors/mule-oracleerpcloud-connector/minor/1.0/

L2L Integration Server

We provide an integration reference implementation as part of the L2L Integration Server. The L2L integration server provides ERP integration capabilities for a number of ERPs (JD Edwards, SAP, QAD, etc.) We understand that Oracle JD Edwards is not the same as the Oracle Fusion Cloud ERP, but this reference implementation may be beneficial in providing a good example of how to implement integration use cases for a number of industry-standard ERPs. The L2L Integration Server is an on-premise Java application with a number of pre-built ERP integrations. The L2L Integration Server runs behind your corporate firewall on a Linux or Windows host. It performs bi-directional synchronization between your L2L CloudDISPATCH Instance and your ERP system. You'll need to customize the database tables and fields according to your specific customizations, use cases, policies, and procedures. We provide the L2L Integration Server with the Java source code so you can easily extend and expand the functionality as you need. For more information regarding the L2L Integration Server, please get in touch with support.

L2L API Code Examples

You might be asking yourself, I'm technical, can't I just do this myself? YES! Based on how easy it is to use our API, a lot of customers jump right in and write custom integrations using the tools, programming languages, and platforms they are most comfortable with. If this is you, we've created a number of API code examples in all of the most popular programming languages. Check out our Github repository at:

https://github.com/leading2lean