Oracle SAAS - Integration, Configuration and Extension

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...

  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...