Posts

Create a complex multi-subject area analysis in Oracle Transactional Business Intelligence

Image
Summary Oracle Transactional Business Intelligence (OTBI) is a great reporting tool that is embedded in a lot of Oracle's cloud services - including ERP Cloud, HCM Cloud and many others. A lot of reports and analyses come out-of-the box and you can use the BI tool itself to change existing reports and/or create new ones. Creating a new report is really easy and does not need any IT involvement. It involves dragging and dropping the fields you want analyse and then choosing a nice layout: But what if you want to need to do something much more complex such as combining data from different possibly unrelated subject areas and joining them together?  This blog will explain how you can do that and provide you an example. Subject Areas Data in the OTBI repository is grouped in subject areas. You can easily create your own analyses using the pre-defined subject areas. These subject areas are defined as follows in the online documentation : The BI repository defines the columns that are av
Post a Comment
Read more

Use your own approval engine with Oracle SAAS Applications

Image
  Summary There are a lot of approval flows that come out-of-the-box with Oracle's SAAS applications. Just think of the AP Invoices or Purchase Order approval flows in Oracle ERP Cloud. These flows are implemented by Oracle development in Oracle BPM. Most of the times a user-friendly user interface is also delivered allowing users to customize the approval flows without having to write code. Because as soon as you write code you lose upgradeability. But this user-friendliness comes at a cost: you do not have access to all the nice state-of-the-art features of Oracle BPM. Although you can implement 99% of your requirements using the delivered screens in an update-safe way, you might have a mandatory requirement that is not covered by what is available out-of-the-box. This blog explains a way to externalize some approval processes allowing you to use an external business process engine such as Oracle Process Cloud ( https://www.oracle.com/cloud/integration/process-cloud-service/ ) or
Post a Comment
Read more

Better Together: Oracle Cloud Applications APIs and Oracle API Gateway

Image
Summary This blog explains how to setup Oracle’s API Gateway – a serverless component from Oracle Cloud Infrastructure (OCI) – to directly call Oracle Cloud Applications REST APIs. I will show how it is done for Oracle ERP Cloud – but this applies to any API exposed by Oracle’s Cloud Applications. I will not only explain how the setup is done, but I will also explain why you would do this. This blog is not a tutorial on OCI or Oracle's API Gateway. Why? So, let’s start with the ‘Why’ question. What value can be derived from using Oracle’s API Gateway in front of Oracle Cloud Applications REST APIs? Quite a lot of value it seems. First of all, you need to know that Oracle Cloud Applications expose literally hundreds of REST APIs which can be called by other SAAS services, mobile apps, chat-bots and so on. The amount of innovation that can be created using those REST APIs is only limited by your imagination. But you don’t want to forget about security, right? The innovation you want
Post a Comment
Read more