Oracle Fusion Applications are a suite of applications built on Oracle Cloud that include cloud-based applications for enterprise resource planning, enterprise performance management, supply chain management and manufacturing, human capital management, and customer experience.
There are numerous use cases where standard object resides inside Fusion ERP needs to be extended to include more fields or completely new Custom object needs to be created.
In this blog, I will be covering how you can create a new Custom Object inside Fusion ERP and trigger transactions for that Custom object.
A Custom Purchase Order (PO) will be created inside Fusion ERP, as soon as record will be created, it triggers the event which Oracle Integration Cloud (OIC) has subscribed and get all the data, once data reached integration layer, it is invoking a Visual Basic Cloud Service Web application REST API to insert that data into VBCS application. In turn that PO can further be updated inside VBCS and send back updated information to Fusion ERP.
My Objective in this blog to show the low-level steps needed at Fusion ERP to create & publish Custom object. The Oracle Integration Cloud Integrations & VBCS assets I will not be covering in details.
High level steps to achieve desired outcome –
- Setup sandbox
- Create Custom Object
- Edit Pages
- enable ZCX_CUSTOM_OBJECT_EVENTS option
- Publish Sandbox changes
- Generate Integration events
- Test the Event Catalog to verify Custom Object.
- Create Integration Flow
- Test the Custom Object Event
Fusion ERP Configuration
Navigate to Configuration >> application composer
Custom object are disable. This functionality needs a sand box to access the custom object
So, let’s create a sandbox. Navigate to Configuration >> sandbox >> create sandbox
Enter the name of the sandbox, description, Publishable=Yes, and select all the tools on this page and hit create button
Once created, by clicking on newly created sand box you can enter that sandbox
Once you enter into Sandbox, you will see on top ribbon your Sandbox name. It exactly provides same navigation experience like main fusion ERP instance
Create Custom Object
Now, from top menu, navigate to Configuration >> Application Composer again and you will “Custom Object” highlighted now
Now, we are ready to create Custom Object, click on Custom object + button
It can take 1-2 minute to create Custom Object. Once its gets completed, you can see on left side CustomPO Custom Object got created –
Now, we ready to create fields inside Custom Object what we just created. I have used below structure but feel free to choose structure whatever you need.
|FiledName||Filed Type||Sample Value||Required/Searchable|
|Address||Text||4 Julis Ave, North Ryde||No/No|
For first Field e.g. accountName, select the data type as per your choice
Define all the properties and hit Save and Close button
Similar, create all field as per above tables. Once all fields get created its look something like this –
Edit Landing and Creation Pages
Once fields are created, next step to create pages, by default it creates 4 types of pages(landing page layout, creation page layout, details page layout and reusable region page layout) once you hit create “create default pages” option
This will few second and will create all default page which you can customize as per your needs –
Next step to modify default page layouts. So, first choose “Landing Page Layouts” by clicking on that It will take you to next screen where you can add more fields etc. click edit button
Move all the required filed as per your needs and click save and close–
Similarly move all the field for “Creation Layout”
Details page layout for adding line-item details etc, not using for this POC
Reusable page layout for header etc. which you want to keep in all pages, so nothing to change for this POC.
Enable ZCX_CUSTOM_OBJECT_EVENTS Profile option
Refer this MOS for more info – Document 2535444.1
Whenever you create or update a custom object, you must regenerate and republish the object. To regenerate and republish custom objects.
You must also set the profile option, ZCX_CUSTOM_OBJECT_EVENTS, which is used to enable and register custom object events. The profile option is disabled by default. If the profile option is not enabled then the Generate Integration Event function is not present under the Common setup in Application Composer.
When the profile option is enabled, custom object events are published and registered in CustomEventCatalog.xml. After custom objects are published and registered, users in Oracle Integration Cloud (OIC) can subscribe to the custom object events.
If the profile option is turned set to No, then OIC users will see nothing, even though they’ve subscribed the events.
Navigate to Setup and Maintenance
Offering: Sales > Functional Area = Sales Foundation > Task = Manage Administrator Profile Values.
Add the required application and set the profile option to Yes.
Save your changes.
Enter the “ZCX_CUSTOM_OBJECT_EVENTS” as Profile option code And hit search button
Next, step to publish to publish all the sandbox for all changes to get implemented
Generate Integration Events
Navigate to Application composer, select application=ERP and SCM Cloud >> and right click to get the option “Generate Integration Event”
Test the Event Catalog to verify Custom Object
Just replace your Fusoin ERP environment hostname in below URL and run the GET operation from POSTMAN after providing basic authentication-
Once you get output, search your Custom Business Object in result you should see the result.
OIC Integration Flow 1
Subscribe the Custom Object event in OIC, create OIC connection for Fusion ERP, then further create Integration flow with “App Driver Orchestration” flow and drag and drop Fusion ERP connection Instance as trigger option inside Integration flow and configure Business Event section
Add logger activity to log incoming Custom Object event. This will help us to identity what kind of payload is getting received at OIC level, and map the incoming result to logging variable
After logging, you can further call any REST API to pass incoming Custom Object Business event. In my case I was calling VBCS Business Object REST API to update VBCS BO with incoming event. So, my complete flow looks something like this –
Once, we activate this integration flow and create a new Custom Object inside Fusion ERP, OIC is expected to receive the event and update VBCS Business Object which has same definition as Fusion ERP Custom Object.
Test Custom Object Event
Login into Fusion ERP instance, Navigate to Others >> CustomPO1 option
Enter all the required details for all the mandatory/non-mandatory fields and hit save button. As soon as record gets saved, it should trigger event for OIC to consume.
Now, you can see event has been received in OIC
Click on header part of Message to see what’s came inside Event.
I hope this will give fair idea about how a developer can create Custom Object inside Fusion ERP and how the Custom Object Event can be trigger from Fusion ERP which can be digested by Oracle Integration Cloud Fusion ERP Adapter. Happy blogging 🙂