Extracting Data from Fusion SaaS via View Objects with Data Sync

For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent 2.5 […]

Using Data Sync to Extract and Load Data from Fusion SaaS using the BI Cloud Connector (BICC) and UCM

For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent release, […]

Monitoring SaaS Application Performance in EM using RUEI

Introduction Performance and efficiency are essential to having a positive user experience and the diagnosis of click and flow activities can be a complex task in a SaaS environment where access to various log files is limited. Oracle Real User Experience Insight (RUEI) – monitors real user activity, records user session data and provide web […]

Adding FA AppIDUsers to the no password expiry policy in R12

Introduction During provisioning of a new FA instance the passwords for FA AppIDUsers like FUSION_APPS_PROV_PATCH_APPID or similar users will expire after 120 days which is the standard value for normal OID users. This article is intended to describe how you can apply the no password expiry policy to all FA AppIDUsers in a newly provisioned R12 […]

BI Cloud Connector – Deletion of Data Extract Files on UCM

Introduction This blog post is the continuation of the formerly shared article about BI Cloud Connector (BICC) Data Extraction File Downloading. In the previous blog post I gave an introduction into BICC and we discussed the options how to download the data extraction files from Storage Cloud or the internal built-in Universal Content Management (UCM) […]

Applying P4FA using FASPOT on Fusion Release 12

Introduction Patches for Fusion Applications (P4FA) are collections of one-off fixes and tech stack updates (e.g. Fusion MiddleWare, Database, Weblogic Server, etc.) compiled and certified for Fusion Applications where an installation of them improves system stability and performance substantially. Every Fusion Application release has its own set of P4FA patches and it is mandatory to apply […]

Getting Credentials in Fusion Applications

Introduction Oracle Fusion Applications is configured to save normal user names and credentials in Oracle Internet Directory (OID) and used for authentication purposes. Many of the applications store connection usernames and credentials they need in the credential store and retrieve these from the store when required. This article shows how Fusion Applications Administrators can retrieve […]

Enabling SSL for Fusion Applications Login Pages

Introduction During IDM provisioning you can enable SSL for all external traffic as per the diagrams below. If you need to enable SSL post provisioning then read through the remaining steps in this post on how to enable SSL post provisioning. To enable SSL during provisioning you need to select the EDG Topology: In the last screen Load […]

Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 2: Step-by-Step Example

Following the overview in Part 1, I will now show detailed steps how to create the event subscriptions. In our example, we will use an “Item Creation” event (from SCM cloud). Prerequisite: Register CSF Key in SaaS In a FA-based SaaS instance, the outbound call of a webservice uses a OWSM security policy which retrieves the […]

Using Business Events in Fusion-based SaaS with Oracle Integration Cloud Service – Part 1: Overview

Introduction For integration with all Oracle Fusion based Cloud services – like Oracle Sales Cloud and Oracle SCM Cloud, each service provides Business Events which external applications or integrations can subscribe to. Oracle Integration Cloud Service (ICS) or the new offering Oracle Integration Cloud (OIC) allow very easily to receive (subscribe) to these events and […]

IDCS Integrations Series Part II:Integrating Fusion Application with IDCS

Overview Last year at OOW, I conducted Hands On Lab on Fusion integration with IDCS. We had a full room of audience with loads of questions. That inspired me to write this blog. One of the most common requirements as Fusion is deployed in OPC is, how to centrally manage users and implement Single Sign-On […]

Adding New Fusion Applications Product Offerings using Incremental Provisioning

Introduction A product offering is a logical grouping of features and functionality of Oracle Fusion Applications. Customers who have excluded certain product offerings during their base installation and would like to add these or would like to add newly released product offerings can only do so during upgrade using Incremental Provisioning (IP) IP provides the ability to […]

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 from Oracle Fusion SaaS

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 Fusion SaaS 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, […]

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 […]