Using Date Based Partitioning for OTBI Extracts with Data Sync to Improve Performance

For other A-Team articles about BICS, OAC, and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), Oracle Analytics Cloud Service (OAC), and other relational databases. I have previously written about the tool’s ability […]

Discover Utility : A Tool to Collect Comprehensive Configuration Details of a Fusion Applications Instance

Introduction Oracle Fusion Applications is a large collection of artifacts at various levels – from Application Modules,URLs and Web services at the top levels to storage, hostnames and IPs at the lower layers with numerous connection and configuration settings and tunable parameters within and across the various products in different layers.  Often administrators need values […]

Transport Layer Security (TLS) and Web Service Connections in SaaS Integrations

A Checklist for Success with TLS Why We Need This Despite the full feature sets and capabilities that Oracle builds into their software-as-a-service (SaaS) cloud applications, there are still going to be occasional customers with business requirements that cannot be satisfied solely with a single SaaS subscription.  In these cases, it is possible to extend […]

BI Cloud Connector – Download Data Extraction Files

Introduction The Oracle Fusion based SaaS offerings provide an interesting tool to extract data and to store them in CSV format on a shared resource like the built-in UCM server or a Storage Cloud: BI Cloud Connector (BICC). The extracted data can be copied from these cloud resources and downloaded to local resources, before post-processing […]

Migrating your Fusion Applications Auth OHS to a DMZ server

Introduction There maybe a need to expose your application to non-employees outside of your organization such as suppliers who make use of supplier portal. This article is intended to describe how you can do this after you have already provisioned your Fusion Applications environment. Main Article In this article we will describe the steps needed […]

FAQ: Integrating E-Business Suite using Integration Cloud Service

1. Is the connectivity agent necessary for the EBS Adapter even when my services are deployed inside DMZ and publically accessible. No. The connectivity agent is only required when EBS REST services are not available on public internet. 2. Can I connect to EBS database from ICS and invoke PL/SQL procedures? Yes, you can use […]

Load Balancer Configuration for Fusion Applications

Background The Fusion Applications installation guide describes how load balancers are used and which features are required when planning a highly available Fusion Applications environment. The Oracle documentation does not contain supplier specific configuration settings for the load balancers. The purpose of this post is to help facilitate the discussion between the networking teams and […]

Using the Oracle SCM Cloud R12 REST API

Overview Starting with Release 12, Oracle SCM Cloud provides a REST API – which is easier to use in a lot of cases than the SOAP API and also offers some additional capabilities like the access to the WorkOrder service. Also it can be very easily used by the Oracle IoT Cloud Service and Oracle […]

Integrating Microsoft SharePoint Document Management with Oracle Sales Cloud

Overview Customer Relationship Management (CRM) software, now referred to more often as Customer Experience (CX) software, tends to be customized or extended more often than HCM, ERP, or SCM applications.  The reason:  enterprise business processes in the customer experience realm tend to be non-standard and more diverse across organizations.  With wide diversity, it is impossible […]

Using Business Events in E-Business Suite to send messages to other applications via ICS

Introduction In this article, I will discuss and demonstrate the use of Business Events in E-Business Suite (EBS) to integrate it with other applications using Integration Cloud Service (ICS). The Oracle Workflow Business Event System is an application service that leverages the Oracle Advanced Queuing (AQ) infrastructure to communicate business events between systems. This functionality is leverage […]

Loading Data into Oracle BI Cloud Service using BI Publisher Reports and SOAP Web Services

Introduction This post details a method of loading data that has been extracted from Oracle Business Intelligence Publisher (BIP) into the Oracle Business Intelligence Cloud Service (BICS). The BIP instance may either be Cloud-Based or On-Premise. It builds upon the A-Team post Using Oracle BI Publisher to Extract Data from Oracle Sales and ERP Clouds. […]

Integrating Commerce Cloud using ICS and WebHooks

Introduction: Oracle Commerce Cloud is a SaaS application and is a part of the comprehensive CX suite of applications. It is the most extensible, cloud-based ecommerce platform offering retailers the flexibility and agility needed to get to market faster and deliver desired user experiences across any device. Oracle’s iPaaS solution is the most comprehensive cloud […]

Cloud Security: Seamless Federated SSO for PaaS and Fusion-based SaaS

Introduction Oracle Fusion-based SaaS Cloud environments can be extended in many ways. While customization is the standard activity to setup a SaaS environment for your business needs, chances are that you want to extend your SaaS for more sophisticated use cases. In general this is not a problem and Oracle Cloud offers a great number […]

Cloud Security: Using Fusion Application Web Services with Message Protection

Introduction Oracle Fusion Applications offers a number of WebServices to allow other applications to incorporate the Fusion Applications functionality. To prevent data leakage, these WebServices follow a common security pattern that requires access authentication and message protection using message signing and/or message encryption. To use such a WebService, the WSDL of each service provides all […]

Oracle Sales Cloud REST APIs – Handling Child Objects

Introduction Oracle Sales Cloud provides a comprehensive set of customization tools and configuration options to implement customer-specific business cases. In this article I would like to put a spot light on an imaginary situation Customer is active in an industry like Hightech, Mechanical Engineering or Tooling and uses Oracle Sales Cloud for their sales processes […]

How to change the nodemanager password on a machine with no AdminServer installed in a Fusion Applications environment

Introduction   In a Fusion Applications environment where a machine has been provisioned with no AdminServer it is not possible to change the node manager password using the console. For security and during cloning you may need to change this password and this article describes how to do that.     Description of environment   […]

Fusion Applications : Priming the Server Startup

Introduction After restart of the Fusion Applications (FA), the very first clicks can at times get slow responses compared to subsequent clicks to the same pages, as a result of cache’s not being populated yet. As with any Java application, this is normal as a large number of objects (classes, ADF objects, Profiles etc.) need […]

Creating custom Fusion Applications User Interfaces using Oracle JET

Introduction JET is Oracle’s new mobile toolkit specifically written for developers to help them build client slide applications using JavaScript. Oracle Fusion Applications implementers are often given the requirement to create mobile, or desktop browser, based custom screens for Fusion Applications. There are many options available to the developer for example Oracle ADF (Java Based) and Oracle JET (JavaScript […]

Transport Level Security (TLS) and Java

Know Which Versions of TLS are Supported in Recent Java Versions NOTE:  A more comprehensive examination of TLS and what to examine when setting up web service integrations in Oracle Cloud Saas extensions has been published.  See Transport Layer Security (TLS) and Web Service Connections in SaaS Integrations In the twenty-plus years of the Internet’s […]

Best practice for Inventory Management with Oracle Fusion Applications

Introduction The Oracle Inventory stores information about all Oracle software products installed in all the Oracle homes on a host provided the product was installed using Oracle Universal Installer (OUI). How many Oracle Inventories are needed on a host and where to put those inventories are two common questions we get from the customers installing […]