The Integration blog covers the latest in product updates, best practices, customer stories, and more.

February 2021 Oracle Integration Fusion Application Adapters Enhancements

Prakash Masand
Senior Principal Product Manager

Oracle Integration is a customer preferred Integration platform for Integrating with Oracle Fusion Applications viz. ERP Cloud, Engagement Cloud, and HCM Cloud. Oracle Integration Feb 2021 update brings in even further functional enrichments to the already feature-rich Oracle Fusion Application adapters and continues the lead as a customer choice of platform for integration. 

In February 2021 update we are pleased to announce the following updates to the Oracle Fusion Application adapters:

1) Support for EFF/DFF flex fields in REST resources

Oracle Fusion applications support associating descriptive (a.k.a. DFF fields) or extensible (a.k.a. EFF fields) flexfield with which you can create custom attributes for the business objects. As customers define, associate, and leverage DFF & EFF fields for enriching the business objects, the real value of enriched business objects is reaped only when the enriched information is exchanged seamlessly to and fro between Oracle Fusion Cloud applications and the rest of business applications in customer footprint. Please note this capability has been enhanced for ERP Cloud and HCM Cloud adapters.

Let's now look at the experience of defining context, extended type with business REST resources in Oracle fusion application adapters. Let's say you are trying to fetch item information from ERP Cloud using itemV2 business REST resource, this REST resource includes ItemGlobalDFF and ItemEffCategory as DFF & EFF fields and you would like to leverage them in the integration flow. One would add the invoke endpoint to the orchestration and select the itemV2 business REST resource in the wizard, as you select the main resource wizard will prompt you to select the desired child resource. The ability to select the desired child resource was added recently in November 2020 OIC release, reducing the payload size that is exchanged on the network as well as simplifies developer experience by showing only important & desired elements in mapper.

Step 1) Let's select the desired child resources for the ItemV2 business REST resource as shown in the below image:

Step 2) Now, let's click the Next button, and the configuration wizard will allow you to define the flex fields context, to define context select the desired flex field from the drop-down as shown in the below image:

Step 3) Select the desired context that you would like to leverage for the integration, as an example I have chosen Production context for ItemEffCategory.

Step 4) Now that we have defined contexts for DFF and EFF fields, let's go to the mapper that is added by the adapter for the configured endpoint. As you scroll down in the mapper, you will find the items "Item Global DFF" and "Item Eff Category" listed. As you right-click them in the mapper, a context menu shall popup allowing the integration developer to extend the selected type as per the configured context.


Step 5) Mapper will add the selected extended type in the mapper for your consumption, as shown in the below image for the "Item Global DFF" and "Item EFF Category" items.


This allows the integration developer to consume, exchange, and transform the enriched business objects information in the business REST resource operation just like any regular business REST field, enabling customers to reap the full reward from enriched business objects.

2) Support for workers business objects in Employee atom feeds

Oracle HCM Cloud Adapter has been enhanced to support the worker business objects for an Employee atom feed. Oracle HCM Cloud worker business object is much more enriched in comparison to the Emps business object, and as worker business object is superset there is no loss of functionality. The adapter will continue to support the emps business object for existing integrations however new endpoint configuration will fetch the worker business object. To leverage the worker business object in employee atom feeds, all the integration developer needs to do is turn on the "Include Business Objects in ATOM feeds" option in the wizard as you have done in the past for the Emps business object. As you turn it on, the adapter will now generate the employee business object in the mapper for your consumption, as shown below:


This concludes the summary of enhancements done in Oracle Fusion Application adapters, I hope you are excited to use these enhancements and get business value from them in your business processes.

Join the discussion

Comments ( 1 )
  • Hrishikesh Saturday, February 27, 2021
    Excellent enhancement..this will really simplify the programmers life and the overall oic4saas adoption
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.