Oracle Business Process models are back for Fusion Cloud

For the earlier releases of Siebel CRM the Official Bookshelf (pdf version here) also contained a documentation of Business Processes to describe the activity flow within the Application from a starting point to a end point like the example below:


However, these have been discontinued from Version 7.5 for forth following releases. While some parts of the Oracle Organizations certainly maintained these afterwards as Assets, these were not general available as part of the official documentation anymore. For the new Fusion Application Software, which combines all previous separated products from PeopleSoft, e-Business Suite and Siebel into a single Application, the Business Process models are back. While they are not published on alongside the Official Documentation they are accessible via the Oracle Support Portal at the following site: Oracle Fusion Business Process Models: Homepage (Doc ID 1542019.1).

The above site lists the following Level 1 Business process area e.g. Marketing. Level 2 of the Business Process then describes the step in the process e.g. Develop Campaign and afterwards Execute Campaign. The Level 3 then contains a detailed activity flow in MS Visio e.g. Launch Campaign and Manage responses.

Business Process Area

01 Enterprise Planning and Performance Management

02 Marketing

03 Sales

04 Order Fulfillment

07 Supply Chain Planning

09 Product Management

10 Production

11 Procurement

12 Materials Management and Logistics

14 Project Management

15 Financial Control and Reporting

16 Cash and Treasury Management

17 Asset Lifecycle Management

19 Enterprise Information Management

21 Workforce Deployment

22 Workforce Development

23 Compensation Management


BICS development life-cycle

Within an on-premise scenario, the OBIEE development life-cycle was quite simple:

  1. connect to a data warehouse and import the warehouse tables (metadata import to physical layer)
  2. build OBIEE metadata model (RPD)
  3. upload the RPD into Weblogic using the Deployment screen

Within a cloud scenario the BICS development life-cycle is quite the same, but requires some additional steps and some decisions on the development model: either using web-based BICS developer or upload of full RPD file developed using OBIEE Admin Tool.

While it’s possible to develop the complete metadata model within the cloud using the BICS web-based Modeller, like below:


the capabilities of this web-based Modeller are more limited. Due to this there is no option to edit or change the uploaded RPD file within the web-based BICS modeller afterwards. The process to upload a locally developed (OBIEE) metadata model (.rpd file) to the BICS Cloud is called “lift&shift”.

The required setup for this OBIEE to BICS development life-cycle using lift & shift is described in below diagram:


For the BICS development life-cycle setup the data of the Fusion Cloud e.g. HCM or ERP is assumed to be already present within a Oracle Database Cloud (DBaaS/DBCS). For this setup all components (formally probably referred to as “server” components) are provisioned on the Oracle Public Cloud behind a firewall and only the IT Development Tools (IDE) are installed on a developer machine like a desktop or laptop.

The following integrations need to be setup:

Integration point Integration point Description documentation/links
BICS DBaaS Connect the BI Cloud (BICS) to the Database Cloud (DBaaS) to analyse the stored data e.g. extracted Fusion HCM data How Does Oracle BI Cloud Service Integrate with Oracle Database Cloud Service?

Managing Database Connections

(local) SQL Developer DBaaS Connect the local SQL Developer e.g. installed on a Computer or Laptop to the Database Cloud (DBaaS) Accessing a Database Cloud Service instance using Oracle SQL Developer

Connecting to a Database Cloud Service (DBaaS) Instance Through an SSH Tunnel

(local) BI Admin Tool  (RPD file) BICS upload the local developed .rpd file (using the OBIEE Admin Tool) into the BI Cloud (BICS) Uploading Data Models from Oracle BI Enterprise Edition

“Lift and Shift” On-Premise RPD to BI Cloud Service (BICS)

How to Upload OBIEE RPD to Oracle BICS

BICS Lift and Shift of BIAPPS Content

To create Backup as part of the development life-cycle refer to the following article:

BIAPPS on PAAS – Backup and Restore – Introduction

To connect between DBaaS and the Fusion Application Cloud (SaaS):

BIAPPS on PAAS – Source Connectivity

The above scenario uses the Oracle Database Cloud for storing the data. If the Data is not stored in the Oracle Database Cloud, but the Oracle Schema Cloud Service which is bundled for-free with BICS then the data must be loaded into BICS using the BICS Data Sync tool:


Within the all above scenario the (“server”) components are provisioned on the Oracle Public Cloud. For a scenario where some components like the Database still reside on-premise the following tool needs to be installed on the server hosting the Oracle Database:


as described in this article from Oracle.

ODI 12c: Upgrade Benchmarks

Please find below some Upgrade Benchmarks for upgrading the (Database) Repository for Oracle ODI 11g to ODI 12c using the ODI Upgrade Assistant which performs all necessary steps to convert the Repository e.g. upgrading the 11g interface to 12c mapping concept, as seen in below step:


Below is a table with the benchmarks for the respective Repositories:

Repository Repository Size in MB (measured by XML export size) Time duration
MASTER 150 33 Minuets
WORK REPO 1 250 15 Hours
WORK REPO 2 150 15 Hours

The Oracle support also features a Technote containing some tips to improve the process:

ODI Upgrade Hangs With Upgrade Progress Stucks at x% (Doc ID 1664300.1)

provide access to OTBI and BI Administration Role

Fusion Application Cloud users can access the Reporting and Analytics (OTBI) module via the Fusion Sitemap listed under “Tools”:


This opens the embedded Analytics Catalog which contains all items for each domain such as Human Capital Management:


To grant access to Reporting and Analytics, the Cloud Admin User or another User having received the “IT Security Manager” Role can provide access to OTBI:


In this example a new Employee called “OTBIUser” should receive access to OTBI. The User should receive the following Roles by the Cloud Administrator:


To grant the User “OTBIUser” access requires to follow the TechNote from Cloud R12 and onwards as the standard BI Roles (such as BI Author or BI Consumer) can’t be assigned to Users directly any more. Instead, it is required to create a custom Role based on the standard (OOTB) Role and assign those custom role to the User to act e.g. as BI Administrator.


After the User has received the role, an Administrator must run the “Retrieve Latest LDAP Changes” ESS Job to reflect these changes. This process may actually take up to 8 hrs. for the changes to take effect.


Oracle recently announced that it will enhance the EU Cloud in Germany/Frankfurt with additional services for PaaS and IaaS. This additional services are expected to be available during the second half of the calendar year and are enhancing the current SaaS services which are already available within the EU Cloud in Germany.

This expansion of the Oracle Cloud EU Region in Germany will consist of three high bandwidth/ low latency sites providing the required levels of failure protection and availability. As part of the EU Cloud Region, this will also ensure a single data jurisdiction (together with other sites in the UK and Amsterdam).

The full press release can be found here.

Oracle BI12c: placing custom images in BI Server and reference using fmap

For Oracle BI 12c custom content such as images or pdf help files needs to be placed in the following directory:


where /../ is a dynamic folder name such as v-PLM12aFeu7Y.

Within a Report or Dashboard this path may be referenced using the following syntax:



fmap:foldername/file_name (if a subfolder “foldername” was created below /res)

the below links provide further information on using fmap or placing custom resources within Oracle BI:
Storing Custom Files Locally and Using the fmap Function to Reference Them
How to configure static content in OBIEE 12c

fixing: BAR file export for non UTF-8 char set

The following Error message was display when exporting the BAR file from Oracle BI 12c:

SEVERE: Error while reading application-role.
apr 12, 2017 1:53:22 PM ProcessApplicationRole

SEVERE: Error while reading application-role.
apr 12, 2017 1:53:22 PM RemoveUnrequiredNodes
SEVERE: Failed on removing unrequired node during Invalid byte 2 of 3-byte UTF
-8 sequence.
apr 12, 2017 1:53:22 PM
inImpl exportServiceInstance
SEVERE: Failed in modifying content of migrated jazn file D:\workDir\exportSICus
apr 12, 2017 1:53:22 PM
ndler exportServiceInstance
SEVERE: Failed running exportServiceInstance API of
znMetadataManagerGenericPluginImpl Failed in modifying c
ontent of migrated jazn file D:\workDir\exportSICustomization\ssi\metadata\authm
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
at java.lang.reflect.Method.invoke(
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyMethod.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.core.PyObject.invoke(Unknown Source)
at org.python.pycode._pyx133.exportServiceInstance$4(/D:/Oracle/Obiee12c
at org.python.pycode._pyx133.call_function(/D:/Oracle/Obiee12c/bi/lib/bi
at Source)
at Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.pycode._pyx165.f$0(<console>:1)
at org.python.pycode._pyx165.call_function(<console>)
at Source)
at Source)
at org.python.core.Py.runCode(Unknown Source)
at org.python.core.Py.exec(Unknown Source)
at org.python.util.PythonInterpreter.exec(Unknown Source)
at org.python.util.InteractiveInterpreter.runcode(Unknown Source)
at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
at org.python.util.InteractiveInterpreter.runsource(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
at java.lang.reflect.Method.invoke(
at weblogic.WLST.main(

apr 12, 2017 1:53:23 PM
SEVERE: Error during export service
stanceLifeCycleException: Failed running CreateServiceInstance API of
apr 12, 2017 1:53:23 PM exportServ
SEVERE: Failed in running all the handlers during export service instance.
Traceback (innermost last):
File "<console>", line 1, in ?
File "/D:/Oracle/Obiee12c/bi/lib/bi-bar.jar!/wlstScriptDir/ServiceInstanceLife", line 84, in exportServiceInstance
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
at java.lang.reflect.Method.invoke(
xception.ServiceInstanceLifeCycleException: BAR-00005


To fix this error the special characters needed to be removed from the Application Role name, such as the following example:


After the removal of the special character from the Application Role name the BAR file could be created successfully.

changing the default data type of number formats

to change the default format used by the Oracle BI EE 11g the following configuration file needs to be changed:


E.g. for two digits behind the number separator:

<dataFormat minDigits="2" maxDigits="2" commas="true" 
negativeType="minus" xsi:type="saw:number";

After saving and restarting the BI Server, the numbers are displayed with two digits behind the number separator.

fixing: Data filter expression VALUEOF(NQ_SESSION.”variable”; for Applicaton Role is considered as non conditional, error: [nQSError: 23006]

After migrating from Oracle BI EE 11g to Oracle BI 12c the RPD consistency checker shows the following Error message with Error # 38197:

Data filter expression VALUEOF(NQ_SESSION.”variable”) for Applicaton Role is considered as non conditional, error: [nQSError: 23006] The session variable, NQ_SESSION.variable, has no value definition
Within OBI EE 11g consistency checker this was neither thrown as a Error message nor as a Warning.

Within the consistency checker of 12c, this is throwing as a error. To fix this a default value needs to be specified for each variable besides the Authorization Block. For this go to Manage| Variables |  Session |Initialization Blocks and double click on a Name e.g. Business Groups.

And open “Edit Data Target” within the variable Target area and assure that the Default Initializer as a default value as shown below:
After running the consistency checker again, the error message disappears.