Oracle E-Business Suite 12.1 and 12.2 can be integrated with Oracle Business Intelligence Enterprise (OBIEE) 12c as a BI reporting solution. Claremont supports a number of customers that use this functionality.
To remain fully supported by Oracle it is necessary to migrate from OBIEE to a new product called Oracle Analytics Server (OAS) and this upgrade needs to happen before December 2021.
In this article, Kevin Behan, Managed Services DBA Consultant at Claremont, details why this step is required, what this involves technically, and what the impact will be on your existing OBIEE reports.
Oracle’s support policies around OBIEE 12c are a little complicated.
According to Oracle Lifetime Support for Fusion Middleware, Fusion Middleware 12.2.x remains in Premier Support until Aug 2025.
However, a note on this entry refers to more information in the Oracle Fusion Middleware Error Correction Policy.
This is My Oracle Support Note Database, FMW, Enterprise Manager, TimesTen In-Memory Database, and OCS Software Error Correction Support Policy (Doc ID 209768.1)
This in turn points to note Error Correction Support Dates for Oracle Fusion Middleware 12c - FMW/WLS (Doc ID 1933372.1)
Examining this Note reveals that the sub-release of Fusion Middleware 12.2 becomes important.
All versions below the terminal release 12.2.1.3 will be out of Error Correction Support from Dec 2021. So what is the difference between Lifetime Support and Error Correction Support?
Oracle provides a definition: In effect, new security fixes and bug fixes are not released for the sub-versions any longer in Error Correction Support. For example, fixes for critical security alert CVE-2020-14750 in Nov 2020 were only released on versions 12.2.1.3 and 12.2.1.4 as they were the only two versions in ECS at the time.
Therefore in order to remain fully supported and to be eligible to receive any future critical bug fixes, the application must be on a version that is still within Error Correction Support.
So if you are using OBIEE with E-Business Suite, is the solution to simply upgrade to 12.2.1.4? Unfortunately not and here the picture becomes more complicated yet again.
There are two parts to the OBIEE installation – the OBIEE application itself, and the Fusion Middleware Infrastructure that underpins it and here is where we have a problem.
According to Oracle Note Is Oracle Business Intelligence 12.2.1.4 Certified or Supported With Fusion Middleware Infrastructure 12.2.1.4? (Doc ID 2606828.1)
This means that while the OBIEE application can be upgraded to version 12.2.1.4, the Fusion Middleware stack can only be used up to version 12.2.1.3 - the possible latest version of the technology stack possible is OBIEE 12.2.1.4 on top of Fusion Middleware 12.2.1.3.
But we know that version 12.2.1.3 will leave Error Correction Support in Dec 2021? How then do we keep the full technology stack of OBIEE/Fusion Middleware in Error Correction Support?
With this in mind, what is the answer to this apparent conundrum?
Oracle’s advice is “Customers who wish to have FMw Infrastructure 12.2.1.4 should upgrade or migrate to Oracle Analytics Server (the re-branding of Oracle Business Intelligence)”
Now we need to look at Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Analytics Server Error Correction Support (Doc ID 1664916.1)
Note that this information contradicts the previous Oracle document which stated OBIEE 12.2.1.4 was in ECS until Aug 2025 whereas this document suggests it is actually Dec 2023. Moreover, there are no published dates at all for either Lifetime Support or Error Correction Support for Oracle Analytics Server.
Clearly, Oracle is still in the process of finalising their support offering for OBIEE/OAS and the fact that this information is spread across a number of documents makes it hard to get a clear picture (by my count this is the sixth document in the chain we have had to follow).
Nevertheless, the direction of travel is clearly moving from OBIEE to OAS, and in order to meet the challenge of the next critical milestone date of Dec 2021 (end of Error Correction for Fusion Middleware 12.2.1.3 which is the latest version certified with OBIEE 12c) a migration from OBIEE to OAS needs to be considered.
Oracle’s reference to Oracle Analytics Server as the “re-branding of Oracle Business Intelligence” suggests that there is little actual difference between the two products and that this is merely a matter of nomenclature.
This is however a little misleading as there are clear functional differences between the two products. Oracle provides a Feature Comparison so it is perhaps not going to be that straightforward.
The migration path from OBIEE to OAS is documented fairly well by Oracle
Claremont has carried out this exercise on an internal demonstration environment and the technical steps are summarised below:
cd /backup/stage/FMW_12.2.1.4.0
/app/java/latest/bin/java -jar fmw_12.2.1.4.0_infrastructure.jar
cd /backup/stage/OAS
export _JAVA_OPTIONS="-Djava.io.tmpdir=/app/OBIDEV/tmp"
/app/java/latest/bin/java -jar Oracle_Analytics_Server_Linux_5.9.0.jar
cd $ORACLE_HOME/oracle_common/upgrade/bin
./ua -readiness
cd $ORACLE_HOME/oracle_common/upgrade/bin
./ua
cd $ORACLE_HOME/oracle_common/common/bin
./reconfig.sh -log=/app/OBIDEV/stage/OBIDEV_12214.log -log_priority=ALL
cd $ORACLE_HOME/oracle_common/upgrade/bin
./ua
cd $DOMAIN_HOME/config/fmwconfig/biconfig/OBIS
vi NQSConfig.INI
Find the [SERVER] section.
Add line:
ENABLE_XML_DATA_SOURCE = YES;
cd $DOMAIN_HOME/config/fmwconfig/biconfig/OBIPS
vi incubation.properties
oracle.bips.marketing.enabled=true
oracle.bips.auth.nextGenAuth=false
Update various server configuration files to allow integration with eBusiness Suite
authenticationschemas.xml
localedefinitions.xml
localemappings.xml
tnsnames.ora
opatch napply -oh $ORACLE_HOME -phBaseFile linux64_patchlist.txt
Following the proof of concept migration to OAS on our internal environment, we then carried out a functional assessment. The key findings were:
We are now planning with our customers that use OBIEE a migration project to move them all over to Oracle Analytics Server.