Introduction
Oracle APEX is a low-code development platform that enables rapid creation of web applications with minimal effort. In addition to building standalone applications, Oracle APEX can also be used to build extensions for Oracle Fusion Cloud Applications.
Oracle provides detailed documentation and blogs explaining how APEX can be used to extend Fusion Applications. You can learn more from the following official resources:
- Integrating APEX with Fusion Applications
- Enhancing Oracle Fusion Applications with Oracle APEX: Getting Started
- Faster Extension Development with Oracle APEX and Fusion Apps REST Catalog
In this blog, I will perform a hands on scenaro how to use Oracle APEX REST Data Source functionality to connect to Oracle Fusion Cloud and display Fusion data in an APEX application.
Oracle Fusion REST APIs Overview
Oracle Fusion Cloud provides a rich set of REST APIs that allow secure access to business data across multiple domains such as:
- ERP
- SCM
- Financials
- Other business areas
These APIs can be used to access data like suppliers, orders, customers, banks, and more.
Below are some useful REST API documentation links:
- Financials REST APIs: https://docs.oracle.com/en/cloud/saas/financials/26a/farfa/index.html
- Supply Chain REST APIs: https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/26a/fasrp/index.html
Scenario Overview
For this demonstration, I will use the Banks REST API to integrate Oracle APEX with Oracle Fusion Banks Setup. The goal is to display and manage bank data in an APEX Interactive Report.
By integrating Oracle APEX with Oracle Fusion REST APIs, organizations can build simple and custom applications to view and analyze Fusion data without modifying the core Fusion system.
In a similar way, you can use other available REST APIs to develop additional customizations and integrations.
This YouTube video for a complete end-to-end demo, where the entire process is shown step by step in a simple and practical manner.
What Is Covered in This Demo
- Searching the Bank REST API endpoint
- Testing the REST API URL using Postman
- Creating a SaaS REST Data Source in Oracle APEX
- Displaying data in an APEX Interactive Report
- Viewing and updating bank data through APEX
- Verifying updated data in Oracle Fusion Manage Banks page
End-to-End Flow Explained Simply
Step 1: Search the Bank REST API Endpoint
Oracle Fusion exposes many REST APIs. For this scenario, we search for the Banks REST API.
This is the API Path for Bank all rest api
API Path: /fscmRestApi/resources/11.13.18.05/cashBanks
Visit Documentation for more details
Step 2: Test the API URL Using Postman
Before using the REST API in Oracle APEX, it is important to test it to ensure:
- The API is accessible
- Data is returned correctly
- Security and authentication are working as expected
This helps avoid issues later during application setup.
A REST client such as Postman can be used for testing. In this example, the API is tested using basic authentication.
Example endpoint:
Fusion Server URL + API Path
https://fa-euth-dev47-saasfademo1.ds-fa.oraclepdemos.com/fscmRestApi/resources/11.13.18.05/cashBanks
Step 3: Create SaaS REST Data Source in Oracle APEX
Oracle APEX provides a feature called REST Data Source, which allows APEX to connect to external REST APIs.
If you choose Saas Rest option, Apex will generate DML Methods such as GET, POST and Fetch.
Step 4: View and Update Bank Data in Oracle APEX
Once the REST Data Source is configured:
- An Interactive Report can be created in APEX
- An update form can be enabled on top of the REST Data Source
- Users can view and update bank data directly from APEX
Step 5: Verify Bank Data in Oracle Fusion
After updating the data in Oracle APEX, the changes can be verified by navigating to the Manage Banks page in Oracle Fusion Cloud.
This confirms successful integration between Oracle APEX and Oracle Fusion.
Conclusion
Oracle APEX and Oracle Fusion REST APIs work together to provide a simple, secure, and powerful solution fbuilding standalone webapplicaiton and as well extenson for Oracle Fusion Applications. This integration enables organizations to build user-friendly custom applications quickly, without impacting core Fusion functionality.
Watch the YouTube video that demonstrates the full end-to-end scenario.