Fusion ERP Custom Business Object Event Ingestion via OIC Fusion ERP Adapter !!!

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.

Demo Scenarios

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

Setup Sandbox

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.

FiledNameFiled TypeSample ValueRequired/Searchable
Accountname  TextBlackmoreNo/No
AccountNumber  Number1000  Yes/Yes
Address  Text4 Julis Ave, North Ryde  No/No
ContactName  Textmanish  No/No
ContactNumber  Number0405082374  No/No
ItemQuantity  Number2No/No
ItemPrice  Number100No/No
ItemTotalValue  Number200No/No
ApprovedStatus  TextAWAITINGNo/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

Publish Sandbox Changes

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.

Activity stream

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 🙂


Author: Manish Kumar Gupta

I am currently designated as Principal Presales Consultant in Oracle, Sydney, Australia. Having 20 + years professional experience. Currently Looking after Presales activities for iPaaS related Cloud Offering e.g. Oracle SOA Cloud Services (OSCS), Oracle Integration Cloud Service (OIC), MFT and Oracle API Platform etc. In past I have worked for many small to large companies. I have played various roles such as Integration Solution Architect / Integration Technical Architect / Integration Team Lead / Integration Specialist / SOA Infrastructure Admin / SOA Designer and SOA Developer in multiple companies. I have worked in various OFMW products such as Weblogic, OSB, BAM, SOA Suite, OWSM and Mediator etc. I have good hands-on experience in SOA Administration as well. In addition to that, have handful experience of SOA Architecture, Analysis, Design, Development, SIT Testing, Performance and Load Testing, Production and Post-Production Support for SOA projects.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: