At times an administrator may need to identify which version of software one or more of the middleware components is within fusion applications. Before downloading and installing ODI Studio, you would need to know which version of ODI that particular release of Fusion Applications was running.
While this article references the BI software components, the same approach applies to most middleware tools within Fusion Applications.
Assuming you have access to the SYSTEM schema within the Fusion database, there is a simple way to identify the version of the majority of the middleware components.
The system.schema_version_registry$ table stores this information.
Run this SQL statement to list out the components, and their software versions:
select distinct comp_id, version from system.schema_version_registry$ order by comp_id;
In an R7 environment, the results will look similar to this:
In this case, the version of ODI is 18.104.22.168.
If you need to find the version of Essbase - open a command prompt at the $BIInstance/Essbase/essbaseserver1/bin directory and run the 'startMAXL.sh' command.
That will show you the version. In this case - it's 11.1.2.
This article provides an easy method for identifying which versions of middleware are present within a Fusion Applications environment.