Install and Configure ORACLE BI APPS 11.1.1.7.1 along with OBIEE 11.1.1.7.0

http://www.oracle.com/technetwork/articles/bi/mcginley-bi-apps-1993643.html http://sunnyobi.blogspot.com/2013/07/installation-and-configuration-of-bi.html Hello all, I am writing this post to provide the BI Apps 11.1.1.7.1 installation steps along with OBIEE 11.1.1.7.0. If you didn’t install OBIEE 11.1.1.7.0 then follow all the steps from starting. Otherwise, skip the first 4 steps and continue. but make sure you have the weblogic 10.3.6 or upgrade to it, which is mandatory for ODI and BI Apps 11.1.1.7.1 products. The current BI APPS version is certified with just Oracle as Target db. So the Oracle db version should be 11.2.0.3 +. Because ODI is using JDBC drivers to connect to Oracle and will open multiple JDBC connections during the load. The DB versions prior to 11.2.0.3 are not supporting multiple JDBC connections at a time. So Oracle 11.2.0.3+ are mandatory for successful ETL loads. •Install JDK 1.6.X (JDK 1.7 is not certified by ODI 11.1.1.7) •Install weblogic 10.3.6 (ODI 11.1.1.7 must be installed on WL 10.3.6) •Run OBIEE 11.1.1.7.0 RCU utility to create BIPLATFORM and MDS schemas. •Install and configure OBIEE 11.1.1.7 •Install ODI with All components and “Skip Repository Configuration” option. •Run OBI Apps RCU to create schemas for: ◦ODI Master and Work Repositories (DEV_BIA_ODIREPO) ◦Oracle Business Applications Components (DEV_BIACOMP) ◦Oracle Business Analytics Datwarehouse (DEV_DW) ◦Update to MDS schema. •Install BI Apps 11.1.1.7.1 •Apply FMW Platform Patches: – This is an important step to avoid the BI Apps configuration failure irrespective of what type OBIEE installation (software only / Enterprise) you did. Download “Oracle Fusion Middleware Platform Patches for Oracle Business Analytics Applications Suite” from the Oracle Business Intelligence Applications 11.1.1.7.1 media pack on Oracle Software Delivery Cloud. ◦D:\Middleware\Oracle_BI1\perl\bin> perl D:\Middleware\Oracle_BI1\biapps\tools\bin\APPLY_PATCHES.pl D:\Middleware\Oracle_BI1\biapps\tools\bin\apply_patches_import.txt •Update BIACOMP Schema with ATGLite patch scripts: ◦sqlplus DEV_BIACOMP/ ◦SQL> D:\Middleware\Oracle_BI1\sdf\DW\ATGPF\sql\fndtbs_11170_upg.sql •Configure BI Apps 11.1.1.7.1. Basically, The biapps configuration is a process of extending existed weblogic domain(bifoundation_domain) with deploying new applications like biacm,odiconsole and etc… •Integrate ODI security with OPSS: ◦D:\Middleware\user_projects\domains\bifoundation_domain\bin>setDomainEnv.cmd ◦D:\Middleware\user_projects\domains\bifoundation_domain>java weblogic.WLST D:\Middleware\Oracle_BI1\bifoundation\install\createJPSArtifactsODI.py embedded –ADMIN_USER_NAME weblogic –DOMAIN_HOSTNAME localhost –DOMAIN_PORT 7001 –DOMAIN_HOME_PATH D:\Middleware\user_projects\domains\bifoundation_domain •Setup ODI Studio to connect to BI Apps repository: ◦Open ODI Studio from windows Start à All Programs à Oracle à ODI Studio ◦In ODI Studio window, click on connect to Repository. ◦In Oracle Data Integrator Login window, Click on + icon to add a login credentials. ◦Provide all the details required as per the below screen. ◦Click Ok, and now you will see the Oracle Data Integrator Login window. ◦Login with the BI apps Admin username and password. ◦Upon Successful authentication, now we connected to BI Apps 11.1.1.7.1 Repository. ◦In ODI Studio, On Left hand window, you can see the ODI Designer, Operator, Topology and Security tab panes for easy navigation to perform the required tasks. ◦Click on Designer pane, and expand the Project list. Here you will see the BI Apps project folder and its mappings directories.