OFSAA – Oracle Financial Services Analytical Application Installation Overview

Oracle Financial Services Analytical Application (OFSAA) is business intelligence application that enables financial institutes to measure and meet risk-adjusted performance objectives.

This post covers overview of OFSAA (v 7.2) installation

1. OFSAA Infrastructure consists of Database tier , Application tier, and Web Tier  (all three tiers can be on same machine or on different machines)

2. Minimal recommended configuration for OFSAA is 2 CPU, 4GB RAM and 1.5 GB Hard Disk (for dev/test environment)

3. OFSAA is certified on Sun/Oracle Solaris, IBM AIX, RedHat/Oracle Enterprise Linux, Microsoft Windows Server.

4. Certified Application Servers are IBM WebSphere, Apache Tomcat, Oracle/BEA WebLogic Server

5. Certified Database for OFSAA is Oracle Database

6. Hyperion Essbase is optional component. Hyperion Essbase is required only if you wish to use OLAP features of OFSAA.

7. If OFSAA is deployed on Windows Server and you wish to integrate OFSAA with LDAP server (for user authentication) then OPEN LDAP 2.2.29+ is required

8. OFSAA can be installed in

a) Single Tier Installation mode – All tiers i.e. database, application and web are installed on same machine.

b) Multi Tier Installation mode – one or all of Database, Application and Web Tier are deployed/configured on different machines. (install oracle database client on application tier)

9. Multiple Instances of Application or Web Tier can be installed for scalability and resilience . First application instance is called as Default Application Instance. Additional application instances can be added later.

10. Database used for OFSAA application should be created with default NLS_NCHAR_CHARACTERSET as AL16UTF16 and OPEN_CURSORS value should be at least 100 .

Step by step installation of OFSAA coming soon ..

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

12 comments
Nagesh says November 7, 2011

Waiting for the next post …..
Thanks for not leaving any stone untouched :)

Reply
» OFSAA - Oracle Financial Services Analytical Application : Installation High Level Steps Online Apps DBA: One Stop Shop for Apps DBA’s says November 8, 2011

[…] OFSAA – Oracle Financial Services Analytical Application : Installation High Level Steps Posted in November 8th, 2011 byAtul Kumar in ofsaa  Print This Post This post covers OFSAA (Oracle Financial Services Analytical Application) installation on WebLogic (as application server). For installation overview check my previous post here […]

Reply
» OFSAA - Oracle Financial Services Analytical Application : Installation Steps Online Apps DBA: One Stop Shop for Apps DBA’s says November 8, 2011

[…] OFSAA – Oracle Financial Services Analytical Application : Installation Steps Posted in November 8th, 2011 byAtul Kumar in ofsaa  Print This Post This post covers OFSAA (Oracle Financial Services Analytical Application) installation on WebLogic (as application server). For installation overview check my previous post here […]

Reply
Chitanya says October 1, 2012

Hi ,
what are the mandatory skills needed for the oracle ofsaa and in what areas need to be skilled
also how obiee is associated with ofssa

Reply
hari says January 7, 2013

Hi,
Can i have the data model for OFS Profitability Management.

Reply
hari says January 7, 2013

I am trying to install OFSAA, getting an ERROR : OFSAAI-1226(Mismatch in Java versions) can anyone help me on this. I have installed jdk1.6_29 on linux 64-bit 5.8 version.

Reply
rajfti12 says June 11, 2013

Atul,
Hi,
I am Looking for some help in implementing OFSPA version 6.1 on top of OFSAA 7.3.2 and OFSAPM. I have gone thru the entire installation and configuration document and ran the PA installer successfully to get the PA schema created but data didn’t get loaded in any of the dimension or fact tables.
Can you help?

Reply
NSHIT says August 29, 2013

Hi,

I’m looking to have a Sr.Consultant as a Trainer for a Training opportunity in Chennai. Please write to me in confidence: nishitb@crownpro.in OR nishitb@yahoo.com or call me on 9341772744

Thanks!
Nishit

Reply
rajeshmanoharan says February 27, 2014

Hi Atul,

Shall we install the OFSAA Application on Virtual machine ?

Regards,
Rajesh

Reply
Sadilya says November 22, 2015

Hi ,

I am looking for training in OFSAA, can you please guide me in this regard.

Reply
saugata chatterjee says April 6, 2016

Hi

Can OFSAA be managed and deployed using OEM12c?

Regards
saugata

Reply
Mritunjay says September 9, 2016

Need to understand how can we integrate OFSAA 8 with OBIEE 11g?

Reply
Add Your Reply