Techniques used to build PaaS4SaaS Mashup using Oracle Application Builder Cloud Service

Introduction Oracle ABCS is Oracles new citizen developer service allowing citizen developers the ability to quickly build applications for the web/mobile web. A common request from SaaS customers is the desire to have both standalone and embeded custom screens for their SaaS solutions. These obviously need to be feature rich, sexy UIs and above all […]

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

Integrating Sales Cloud and Service Cloud using ICS – troubleshooting issues with security configuration

Introduction This blog talks about a few “gotchas” when integrating Oracle Sales Cloud (OSC) and Oracle Service Cloud (OSvC) using Oracle’s iPaaS platform, the Integration Cloud Service(ICS). The idea is to have a ready reckoner for some common issues faced, so that customers can hit the ground running when integrating between OSvC and OSc using […]

Bulk import of sales transactions into Oracle Sales Cloud Incentive Compensation using Integration Cloud Service

Introduction Sales Cloud Incentive Compensation application provides API to import sales transactions in bulk. These could be sales transactions exported out of an ERP system. Integration Cloud Service (ICS) offers extensive data transformation and secure file transfer capabilities that could be used to orchestrate, administer and monitor file transfer jobs. In this post, let’s look […]

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

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

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

Integrating with Sales Cloud using SOAP web services and REST APIs (Part 3)

This is part 3 of the blog series that covers SOAP and REST integration with Sales Cloud. In part 1 and part 2, I covered SOAP services. In this part I’ll be covering Sales Cloud REST APIs Sales Cloud provides REST APIs that allow external applications to view and edit Sales Cloud data. A complete catalog of […]

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

Accessing Fusion Data from BI Reports using Java

Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher report from a SOAP Service and retrieve the report, as XML, as part of the response of the SOAP call.  This blog article serves as a follow on blog article providing a tutorial style walk […]

Using Event Handling Framework for Outbound Integration of Oracle Sales Cloud using Integration Cloud Service

Introduction: Oracle’s iPaaS solution is the most comprehensive cloud based integration platform in the market today.  Integration Cloud Service (ICS) gives customers an elevated user experience that makescomplex integration simple to implement. Oracle Sales Cloud (OSC) is a SaaS application and is a part of the comprehensive CX suite of applications. Since OSC is usually the […]

Integrating Oracle Sales Cloud (OSC) with Oracle Database as a Service (DBaaS) using PL/SQL

Introduction This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Database as a Service (DBaaS) using PL/SQL.The code snippet provided uses the REST API for Oracle Sales Cloud to create a new OSC contact from DbaaS. The PL/SQL uses UTL_HTTP commands to call the REST API for Oracle Sales Cloud.A sample use case for this […]

Cloud Security: Federated SSO for Fusion-based SaaS

Introduction To get you easily started with Oracle Cloud offerings, they come with their own user management. You can create users, assign roles, change passwords, etc. However, real world enterprises already have existing Identity Management solutions and want to avoid to maintain the same information in many places. To avoid duplicate identities and the related […]

Integrating Oracle Document Cloud and Oracle Sales Cloud, maintaining data level business object security

Introduction When customers see the rich functionality available in Oracle Documents Cloud they often ask if they can use this functionality within their Oracle Fusion SaaS Applications to store, and share, documents. At first the integration appears to be quite straightforward, e.g. use the Documents Cloud Web API, embed an iFrame that points to the relevant opportunity id folder in […]

Behind the Delete Trigger in Sales Cloud Application Composer

Cautionary Details on Delete Trigger Behavior with TCA Objects Developers and technically-inclined users who have ever needed to extend Oracle Sales Cloud are probably familiar with Application Composer (known as App Composer to its friends) — the built-in, browser-based collection of tools that makes it possible to extend Sales Cloud safely without requiring a level […]

Troubleshooting Techniques for a JCS-SX ADF Application Embedded in SalesCloud

Introduction I have been playing around with embedding an external ADF application (running on Oracle Java Cloud Service – SaaS Extension) within Oracle SalesCloud to demonstrate the trusted association (SSO) between SalesCloud and JCS-SX and ran into a couple of issues. I would like to share my experience of troubleshooting those issues and provide a few tips for fellow developer comrades […]

Integrating Documents Cloud Public Links to Sales Cloud – Sales Collateral use case

Introduction Oracle Documents Cloud and Oracle Sales Cloud working together is a perfect match to increase productivity. Better if integrates in a single UI. This post will show you how to integrate Oracle Documents Cloud with Oracle Sales Cloud using a simple “Sales Collateral” use case, which consist in showing a new menu item that shows documents […]

Integrating Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with Oracle Business Intelligence Cloud Service (BICS)

Introduction   This article describes how to integrate Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with Oracle Business Intelligence Cloud Service (BICS). The integration pattern covered shares similarities to those addressed in the previously published A-Team blog on: “Integrating Oracle Fusion Sales Cloud with Oracle Business Intelligence Cloud Service (BICS)”. The motivation behind this article […]

Integrating Oracle Sales Cloud with Oracle Business Intelligence Cloud Service (BICS) – Part 1

Introduction This blog describes how to integrate Oracle Sales Cloud with Business Intelligence Cloud Service (BICS). The blog outlines how to programmatically load Sales Cloud data into BICS, making it readily available to model and display on BICS dashboards. Three artifacts are created in the process: 1)    OTBI Answers / Analysis Request Sales Cloud data […]