OFSAAI – Oracle Financial Services Analytical Application Infrastructure : Installation Steps

This post covers OFSAAI (Oracle Financial Services Analytical Application Infrastructure) installation on WebLogic (as application server). For installation overview check my previous post here

  • Download  OFSAAI Software from eDelivery under product pack “Oracle Financial Services Products” -> “Oracle Financial Services Analytical Applications Infrastructure 7.2.3 for <O.S.>”

  • Installation Guide is under software
  • Licence Key required during OFSAA installation is available under software

. OFSAA Installation Steps

  1. Install Oracle Database
  2. Create database user to store OFSAA configuration SQL> create user configuser identified by welcome1;
  3. Grant privileges to user created in previous step by running privileges_config_user.sql SQL>@privileges_config_user.sql SQL>grant unlimited tablespace to configuser;
  4. Install JDK 1.6.0_17
  5. Install WebLogic Server 10.3.1 (If you are installing weblogic with 64 bit JDK then follow steps mentioned here )
  6. Create weblogic domain by running config.sh (For steps on how to create domain in weblogic click here )
  7. Create JDBC in domain with JNDI as jndi/FICMASTER (For steps on how to create/configure JDBC in WebLogic click here
  8. Fill value in file OFSAAI_InstallConfig.xml file (Use configuration guide embedded under installation guide for parameter and value )
  9. Create .profile in user $HOME with entry like export PATH=$JAVA_HOME/bin:$PATH export ORACLE_HOME=[path_of_oracle_home]
  1. Execute $HOME/.profile to set variables
  2. Install OFSAA by running Setup.sh GUI (This script will use OFSAAI_InstallConfig.xml as parameter file). If you hit error regarding elif then add below entry at top of file #!/bin/bash
  3. Create EAR & WAR file by running $OFSAA_HOME/ficweb/ant.sh set ANT_HOME to $OFSAA_HOME/ficweb/apache-ant-1.7.1
  4. Start OFSAAI Server by running $OFSAA_HOME/ficapp/ common/FICServer /bin/ reveleusstartup.sh (when prompted for system password, enter configuser schema password)
  5. Deploy EAR/WAR file created in previous step on WebLogic Server (For steps on how to deploy application is weblogic server click here )
  6. Copy libcpptripledes.so from $FIC_WEB_HOME/bin to $WL_HOME/wlserver_10.3/server/native/linux/x86_64 (change directory as per your O.S.)
  7. Re-Start WebLogic Server
  8. Test OFSAA application by accessing URL http://hostname:port/ofsaai/login.jsp

Stay tuned for issues and troubleshooting OFSAA

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

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

follow me on:

Leave a Comment:

28 comments
mgscott says February 27, 2012

Following these installation instructions – having everything up and running and showing me the OFSAA login screen use SYSADMN and my password which takes me to the change password screen which i enter the details then basically nothing happens. Have you seen this issue before? have any idea?

Reply
Atul Kumar says February 27, 2012

@ mgscott,

Yes, I had similar issue. Fix is to Update F_FORCED_PWD_CHANGE to ‘N’ for SYSADMN and SYSAUTH users in CSSMS_USR_PROFILE table

Reply
mgscott says March 3, 2012

Installing PFT tells me that ftpshare is invalid – although the absolute path is valid /home/oraapps/ftpshare has 777 permissions and executed the umask 0000 also. Any thoughts?

Reply
adnan.ali says May 17, 2012

Hi,
I am doing installation of OFSAAI on OEL 5.5 through your post at
http://onlineappsdba.com/index.php/2011/11/08/ofsaa-oracle-financial-services-analytical-application-installation-steps/
But i am getting the same error of elif. Although I have put the #!/bin/bash at the top of Setup.sh file but the same error. Please help me in this regards.
Thanks and Regards
Adnan Ali

Reply
Atul Kumar says May 19, 2012

@ adnan.ali

This could be because of junk characters. Run this command

dos2unix Setup.sh Setup.sh

This will fix your problem

Reply
adnan.ali says May 25, 2012

Thanks Atul.

This fixed my problem and I installed OFSAAI successfully.

Regards
Adnan

Reply
bee says May 26, 2012

Hi,
I am installing OFSAAI 7.3 for Linux 64 bit with websphere as my server.
I seem to be having trouble understanding what single-tier and multiple-tier installation means. My Database is installed on one machine while other software are on another machine. From the definition, this sounds like a multi tier installation, but i am confused how to edit my config file and what steps should i follow.
any suggestions?

Reply
adnan.ali says May 29, 2012

@bee,

Single Tier installation is simple, when you have all your servers on the same machine like db, web and application server. If you split the configuration on different machine then it is multi tier installation.
Make sure you have intalled db client on your application machine and they should ping the db with the same name entry as the db and define the all server entries in your OFSAAI_installConfig.xml

Reply
lakshith says July 19, 2012

Hi,
I have installed OFSAA 7.3 on the RHEL + Tomcat7.
Installed infrastructure. Able to login with SYSADMN/SYSAUTH. Getting LHS Menu.
However, “Connected to” drop-down is empty.

I want to get help on doing “System Configuration”.

Regards,
Lakshith

Reply
sujit_kumar says August 9, 2012

I am having an issue to create a user from OFSAAI UI. The Add User screen shows up fine, i enter the info and save, It goes fine. But i am unable to see the user for Authorizing through SYSAUTH. When i go back and try to recreate the user from SUSADMN it says that user already exists. Please advice.

Reply
sujit_kumar says August 9, 2012

@lakshith

Please follow OFSAAI User Guide to add the Information Domain

Reply
Lakshith says August 9, 2012

Resolved the issues i posted. Succesfully installed and configured FTP/PFT.

@Sujit_kumar
Eg. User1 mapped with UserGroup1
UserGroup1 mapped with Infodom1
UserGroup1 also mapped with Group1
Group1 have mapping with Roles

By default SYSAUTH is having authorization permission. Hope the default role is not modifed – confirm once.

If required then only have more than one infodom. Single Infodom is suffice

Regards,
Lakshith

Reply
sujit_kumar says August 9, 2012

@Lakshith

I Have only one Information domain and i did not modify any roles so far. Still unable to authorize through SYSAUTH.

Reply
Lakshith says August 9, 2012

@Sujit_kumar,

Login as SYSADMN:

Goto User/UserGroup Management screen in OFSAAI

1. create a UserGroup say UserGroup1
2. create a User say User1
3. map the User1 into the UserGroup1
4. map the UserGroup1 into the Infodom1
(say Infodom1 is the infodom you have created)

Then login as SYSAUTH:
Authorize all teh newly created things …
1. Authorize UserGroup mapping
2. Authorize User mapping

Note: Once you click Authorize button (Green button) make sure no entries in the section of the screen. (i.e., GoTo the same same screen again and see if anything is left for authorization – make sure all are authorized.)

Logout …
Try Login with the user (Authorized User)

Note: Better user AlphaNumeric combination for both username & passwords.

eg., TPUSER / Tp73User

Regards,
Lakshith

Reply
sujit_kumar says August 9, 2012

At this step,

Then login as SYSAUTH:
Authorize all teh newly created things …

I dont see any users to be Authorized….

Reply
Lakshith says August 9, 2012

ok, will you be able to login with the new-userid/pwd ?
You can connect with me in gmail-chat pmarimuthu@gmail.com

Reply
VuTA says October 24, 2012

Hi,
I am installing OFSAAI 7.3 for Linux 64 bit with weblogic as my server and in single tier mode.
But i can’t use some functions of OFSAAI like UMM upload model because it throug error “Package not loaded…”. Please help me!

Reply
abhiabhi001 says August 1, 2013

Hi,
How can we create a virtual environment using VMware for OFSAA using my production setup to make it wok on my laptop.

Reply
NAB-command centre says October 13, 2013

OFSAA server having to reload every time (weblogic/EAR-WAR file, restart server it goes down. Very unstable

Reply
abhiabhi001 says November 8, 2013

While creating the ear file for deployment using at.sh i am getting the following error:
No directory or file exist.
Is there any reoslution for the same.

Reply
sunny says November 27, 2013

Dear All,

Please write back to me, if you are looking for a change and new opportunities in OFSAA .

Regards
Sunny

Reply
adnan.ali says November 27, 2013

Hi Sunny,

I am looking for new opportunities. Please send me details at adnan_oxf@hotmail.com or adnan.ali.mehranian@gmail.com

Thanks and Regards
Adnan Ali

Reply
amitsharma73 says April 8, 2014

Hi Atul,
When i choose Microsoft Windows i get very less options compared to Linux. Is OFSAA mainly built for Linux OS.

Thanks,
Amit

Reply
madhu says December 2, 2014

Hi,
I am trying to access Import Model Screen under UMM(OFSAA version is 7.2.12) but the page doesnt get properly loaded i.e I see ETL.MODELUPLOAD package not loaded error. Also I see a dropdown box as well as a button but I see ETL.MODELUPLOAD Package not loaded texts near it.
Is there any browser settings issue or anything else please let me know. Need help on this urgently.

Reply
madhu says December 2, 2014

Hi,
I am facing another issue while Bulk excel upload i.e while uploading the excel file it gets hanged and nothing happens. Could you identify the possible causes for this issue.

Reply
aditya says May 17, 2017

Your blog was very helpful. Thanks for your efforts.

Reply
pude says June 10, 2018

Can you give me a guide to installing ofsaa 8.0.5. The Oracle guide is too long and a bit confusing. What i have managed to do is create the schemas and run the schema creator, run ./setup GUI and install OFSAAI, however after starting the ofsaai server, weblogic, icc and agent server, I cant access the OFSAA web applet. I have done the installation 4 times so Im very confident its a small issue of propbably something I’m overlooking.

Reply
Add Your Reply