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

Oracle Integration November 2020 update for Oracle Applications Adapters

Prakash Masand
Senior Principal Product Manager


Oracle Integration is one of the most robust Integration platform for Integrating with Oracle Applications may it be Fusion Applications like ERP Cloud, Engagement Cloud or NetSuite and Service Cloud. Oracle Integration November 2020 update continues to build on the momentum of differentiating Oracle Integration platform for integrating Oracle Applications by providing deep functional, simplified and differentiating features. Thus enabling customers to consume business value from Oracle Applications at a rapid pace in continuum with the Oracle applications updates.

In November 2020 update we are pleased to announce following updates to the Oracle Application adapters:

Fusion Application Adapters Improvements

Fusion application adapters are one of they key strategic adapter for the Oracle Integration platform, Oracle Integration continues to update the adapter with the features meeting customer needs and improving overall experience of the adapter. One of such improvement done in November 2020 update is cherry picking child REST resources. This enables Integration architect to pick & chose the child resources that are needed for their businesses. In the absence of this feature Integration architect would end up having all the child resources in the integration artifacts resulting in unmanageable number of elements to traverse through in mapper as well as unnecessary load at the runtime. 

Let's now double click on the new features for the fusion application adapters.

  1. Cherry picking child REST resources

This feature allows integration architect to pick & chose child resources they want to include in the integration flow based on their business needs. Let us first consider an example, you want to query the supplier information and fetch contacts and sites information alone. The supplier REST resource include wide variety of child resources, right from addresses, contacts, currency lookup to products and services information, just to be precise there are 15 child resources for supplier resource. 

As per the above example, let's say you are configuring the supplier business resource in the ERP Cloud Adapter. As you select the Suppliers business resource wizard would now prompt you to cherry pick the desired child resource. To select the child resource simply select the desired child resource from left hand side list box and click highlighted button to move the child resource to a selected child resources list. Please note you can select maximum upto 10 child resources for a particular invoke.

As you select the desired child resource, ERP Cloud adapter is going to include only the selected child resource in the response of the business resource. This will not only improve experience of mapping the response from business resource in your further processing of integration flow but also reduce the memory foot print at runtime, reduce the network payload that gets exchanged over wire resulting in improved experience both from design time and runtime perspective. Let me give you purview of impact by showing the difference in mapper, please see below left hand side mapper is with current functionality and right hand side of the mapper is with the November release having cherry picked child resources.

As you can see in above picture, highlighted fields are eliminated in the right hand slide mapper, there by improving experience of mapping, reducing payload that is fetched at runtime and improving the overall performance of the integration flow.

NetSuite Application Adapter Improvements

Oracle Integration continues to invest in the NetSuite Adapter further spear heading the robust capabilities of integrating with the NetSuite applications meeting customer needs, simplifying access and thereby addressing wider use cases. In the November update NetSuite adapter gets enhanced concurrency limit, this means customers get high concurrency limit when they integrate with NetSuite using Oracle Integration. In the current scenario customer has a concurrency limit on invoking integration APIs concurrently based on the license they have purchased. This will enhance the concurrency limit to 100 irrespective of the license they have subscribed for the NetSuite applications. NetSuite adapter also has couple of functional enhancements in the November update viz. 1) Support for Initialize / InitializeList operations in the adapter. 2) Improved support for item and transaction records in the NetSuite applications. The initialize / initializelist operations gives an ability to the integration architect to pre populate the specific record with the values from related reference record and brings in all important efficiency in building the flow and consistency in the execution.

  1. Enhanced NetSuite concurrency limit

This is of huge value to our Oracle customers and demonstrates how Oracle values loyal customers by providing enhanced value for their investment and trust in choosing multiple Oracle services. The enhanced concurrency limit is applicable only for the invokes performed through connections created using TBA Authorization flow, please note TBA Authorization flow is a new security policy introduced in the NetSuite adapter. The TBA Authorization policy brings in multiple benefits to customers viz. 1) It is much more secure as user does not have to enter the credentials in the Oracle Integration. 2) Customer would get enhanced concurrency limit whenever invokes are performed using such connections. 3) It is really simple to configure the connection, as all user has to do is to click on Provide consent in the connection page and follow the prompts. 

Please note: NetSuite Adapter TBA Authorization flow security policy is not supported with the new customer defined hostname feature for the Oracle Integration service instance. 

Lets now see in detail how would one configure the TBA Authorization security policy in NetSuite Adapter:

Step 1. As you would go to the NetSuite Adapter connection page, you will find new security policy "TBA Authorization Flow" that requires user to click on Provide Consent button as highlighted below.

Step 2. As user clicks on "Provide consent" button Oracle Integration would open a new tab, where user has to enter the Oracle Integration credentials and click "Log In".

Step 3. Oracle Integration will navigate to the NetSuite page, where user would need to enter the NetSuite credentials.

Step 4. Select the desired role, enter any additional security question and click Submit or Allow as prompted by the NetSuite application.

Step 5. As you select the role and click Allow, NetSuite will exchange token with the Oracle Integration and Oracle Integration should prompt you success of authorization as below.

Step 6) You can now test the connection on the connection page and it should successfully connect with the NetSuite application using the token obtained via TBA authorization flow.


  1. Support for Initialize / InitializeList operations

This is a really powerful feature for Integration architects as they do not need to populate the records from scratch, rather they can pre populate the records from the reference objects. As an example if you are designing a flow to initiate the cash refund, now this cash refund is against the cash sale, and NetSuite adapter allows you to initialize the cash refund record from cash sale where cash sale is a reference object where details like createdfrom, line items and amount are pre populated. Once you have the real object initialized through reference, integration architect only needs to worry about updating the required attributes and perform the transaction. 

Lets now look at the experience of configuring the Initialize / InitializeList operation in NetSuite Adapter:

Step 1. Initialize Operation is added under "Miscellaneous" operation type.

Step 2. Select the desired transaction type, this is the record type that you want to initialize, as discussed above I am selecting CashRefund from the list.

Step 3. NetSuite adapter shall populate the initialize reference objects, based on the selected transaction type, in our example it shows CashSale and ReturnAuthorization.

Integration architect can also turn on the checkbox for system to list all the reference types, this is helpful for scenarios where listed reference type aren't helpful for the customer. If you choose this option, please make sure to select compatible Transaction and Reference Types. Selection of incompatible types will lead to runtime exceptions.

Step 4. Now that you have defined Intialize CashRefund invoke action, you need to map the CashSale internal ID so that flow can fetch Cash Sale record for initializing the Cash Refund record. Here is the example of mapping to Initialize invoke that initialize's the Cash Refund record.

Step 5. Now that you have Initialized CashRefund you can use the same to perform the desired CRUD operations, here is the example of mapping between initialized record and basic record of CashRefund.



This concludes the summary of enhancements done in the Oracle Application adapters for November 2020 release. Oracle Integration continues to invest heavily in the Oracle application adapters, and is committed to provide best possible experience to Oracle application customers. I hope you are as much excited as I am to see these features live in your Oracle Integration and use them for solving your business needs.


Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.