Home

Financial Services Analytical Applications

Contents

1. Exit Help Previous Create 10 Creating Domain window displays the progress of the domain creation process Once the domain is created successfully click Done 2 30 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide F Fusion Middleware Configuration Wizard BEE Creating Domain ORACLE Progress Cte i _sts Cs r Preparing Extracting Domain Contents Creating Domain Security Information Saving the Domain Information Storing Domain Information String Substituting Domain Files Performing OS Specific Tasks Performing Post Domain Creation Tasks Domain Created Successfully Domain Location Aveblogic webl1 01 3 hea user_projects domains MockSol Admin Server URL http ips88rev 7007 eo Sal i Deletion of a Domain in WebLogic Navigate to the following lt WebLogic Installation directory gt user_projects domains lt domain name gt bin Execute stopWebLogic sh to stop the Weblogic domain Delete the WebLogic domain Populate installation configuration xml In the pre configuration process of Infrastructure installation you can populate the OFSAAT InstallConfig xml using XML_Utility jar file The XML Utility helps you to populate the OFSAAI_InstallConfig xml with the required interaction parameters in a GUI mode installation To create a new OFSAAIT Inst
2. Name AdminServer Listen address All Local Addresses x Listen port 7007 SSL listen port ut SSL enabled O Exit Help Previous Next e Make anote of the Listen Port or SSL Listen Port value for example 7007 since the same has to be re entered in the Servlet port field during Infrastructure installation The Configuration Summary window is displayed You can verify the configuration details of the WebLogic domain and click Create This creates a domain server thereby enabling deployment of multiple Infrastructure applications on a single WebLogic Pre Installation Configuration 2 29 F Fusion Middleware Configuration Wizard x Configuration Summary ORACLE Click on an item in the Domain Summary pane on the left to inspect its attributes in the nae awe Details pane below You can make limited adjustments by clicking Previous to return to a Deployment prior panel If everything is satisfactory click Next MockSol Aweblogic weblt 01 3 bea user_projects cdomail Server Details L Adminserver Attribute Value Name Basic WebLogic Server Domain Description Create a basic WebLogic Server domain without installing sample application Author Oracle Corporation Location Aweblogic webl1 01 3hheawiserver_10 3 commontemplates domains wis jar
3. Distribute application ves Map virtual Use Binary Configuration o fo Desloy antaronise beans ver Application name _vpgs73 Override class reloading settings for Web and EJS modules Reload interval in seconds Deploy Web services No Validate Input off varn fail warn Process embedded configuration No File Permission dlle755 s08755 a8755 s18755 _ Application Build 10 Unknown Allow dispatching includes to remote No resources i Allow servicing includes from remote No resources Business level application name Asynchronous Request Dispatch Type Disabled Allow EJE reference targets to resolve automatically Cell Node Server Slick bere _Frevious Finish Cancel No 14 This will deploy the Infrastructure Application on WebSphere Once the installation is successful message appears click Save to save the master file configuration 4 36 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 15 C Errors 0 Varnngs 0 ntormatons Messages ADUASOOTY The EBOepicy program completed or fie oresete w as TBBL Soner ease Ser enpro tes test Dw steme 77 170E ODI moca OF ADUASOOS The applicator crymoce 2 a configures n me WenSorere Appicaton Server repeetory ADUALOS The brary references for he Mataies optons package are crested ADUALOOLE The applicator crymock72 co
4. Configure Members Reverse Population This property should be set for reverse population of Members for the Dimensions in required Information Domains VALUE Members Reverse population VALUE Y N CODE EXAMPLE MEMBER_REVERSE_POP 1 MEMBER REVERSE _POP O NFODOMS DIMENSION_I RAFUSION 1 Y D V ALUE Configure Hierarchy Reverse Population This property should be set for reverse population of Hierarchies for the Dimensions in required Information Domains VALUE Hierarchy Reverse population VALUE Y N CODE EXAMPLE HIERARCHY_REVERSE_PO HIERARCHY_REVERSE_PO P S INFODOM DIMENSIO P ORAFUSION 1 Y N_ID VALUE Post Installation Configuration 4 59 Configure Maximum Levels allowed in Hierarchies This property is required to set the maximum levels allowed to build the Hierarchies tree structure VALUE CODE EXAMPLE Hierarchy Maximum level MAX_DEPTH INFODOM MAX _DEPTH FUSION 15 allowed for the hierarchy in VALUE particular information Domain VALUE Integer number e The Maximum Levels allowed in the hierarchies is less than or equal to 15 If the Hierarchy Reverse population is set as Y and more than 15 levels are created then the alert is displayed as The number of levels exceeding the limit e If the maximum level allowed is set as more than 15 and hierarchy reverse population is set as Y then an error is displayed as Error occurred in Reverse populating the hierarch
5. For ORACLE DB type it is jdbc oracle thin lt lt DB Server Name gt gt lt lt Port Number gt gt lt lt Oracle SID gt gt For DB2UDB DB type it is jdbc db2 lt lt DB Server Name gt gt lt lt Port Number gt gt lt lt Database Name gt gt You need to specify the appropriate details corresponding to the information suggested in brackets For example in ORACLE DB you can specify the Port number as 1521 and the SID as ORCL Enter the Database Date in mm dd yyyy format The specified date is selected when an Information Domain is created System Configuration 6 17 Field Description Block Size Optional Specify the Block Size when you have selected ORACLE as the database type The details are available in the INIT ORA file which stores the initialization parameters of Oracle DB 3 Click Save to save the Database Details for DB Server Modify Database Details for DB Server By default the Database Details for DB Server Database Master window displays the database setup details specified during the installation The database details are editable and you can modify the required information except the Database Type For more information refer Add Database Details for DB server page 6 15 Note The database date when modified does not get auto updated You need to manually update the date in the database parameters of NLS_DATE_FORMAT file and restart the BD Also the to_date function translation is no
6. DO Only Use only roles and policies that are defined in the deployment descriptors Custom Roles Use roles that are defined in the Adminastration Console ese poboies that are defined in the deployment descriptor Custom Roles and Pelcies Use only roles and policies that are defined in the Administration Console Advanced Use a castom model that you have configured on the realm s configuration page Source accessibility How shod the source flies be nade accessible Use the defauits defined by the deployment s targets Recommended selector Copy this app cation onto every target for me Orno desloyment the Ses vl be coped automescally to the marrage servers to niich the applicator is targeted Iwill make the deployment accessible from the following location Locotions loradata2 wtt035 OracleMidcieware user_peojects donsat Prowde the locator fon mhere af targets wil access ths sopicaton s Ses The 6 often a shared drectory You mst ense Se sopicaton Ses exst mn Sys locator and tut each target can reach the locaton Back Next Fran Cancel 3 The deployment summary window is displayed Select Yes take me to the deployment s configuration screen option and click Finish 4 42 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Instal Application Assistant Beck Fan Cancet Review your choices and click Finish Ok Finish to complete the Genlo
7. Copyright 2006 Quadbase Systems Inc All rights reserved NAG Limited NAG Limited 2005 Portions utilize NAG s C library All rights reserved Gnuplot V 4 2 0 Copyright 1986 1993 1998 2004 http www gnuplot info Third Party Software B 1
8. The Information Domain name is required during the application installation It can be created during pre install steps of applications installer or infrastructure infodom creation process A new Information Domain must be created pointing to the Atomic schema Alternately an existing Information Domain may also be used Copy the entire EPM apps installer download directory to the server location Including the DataModel directory Give read write and execute permission to all the files present in this directory Specify the log file path and name in the log4j xml Please update the value attribute marked in the following screenshot lt DOCTYPE log4j configuration SYSTEM log4j dtd gt lt log4j configuration xmlns log4 http jakarta apache org log4j gt lt appender name ConfigReveleusFileAppender class org apache log4 RollingFileAppender gt lt param name file value Ju02 setupkit ALM60 log FTP60 1log 7 gt lt param name Append value true gt Make sure the path given in the log4j xml file has read write execute permission Execute the config_table_privileges_for_atomic_user sql script in config schema This file will be present inside FIC_HOME directory There must be at least one segment mapped to this Information Domain For more information on System Administration Defining Segment Maintenance Details see Oracle Financial Services Analytical Applications Infrastructure User Guide The
9. Where Dimension_ID Dimension ID In OFSAAI 7 3 the seeded key dimensions have already populated MEMBER_CODE_COLUMN If there is an associated code attribute which is present from OFSAAI release 7 3 0 for capturing the alphanumeric member code remove it manually as follows If the attribute currently contains values e Update the alphanumeric codes from the attribute table to the Member Code Column of the member table That is Execute the Update_Dimension_Code procedure using steps detailed in the Data Model Utilities Guide For example Either run fn_updateDimensionCode from SQL Plus or use a Batch to run TRANSFORM DATA with the Update_Dimension_Code procedure for your Dimension ID e Remove the attribute values from the dimension attribute table DIM_ lt DIMENSION gt _ATTR For example if you are updating the Common Chart of Accounts Dimension where Attribute Name is COMMON COA CODE Member_B_Table_Name is DIM_COMMON_COA B and Attribute Table Name is DIM_COMMON_COA_ATTR execute the following statement Delete from DIM COMMON COA_ATTR where Attribute _ID Select Attribute ID from REV_DIM ATTRIBUTES TL where Attribute Name COMMON COA CODE and dimension id select dimension_id from REV_DIMENSIONS B where member b table name DIM COMMON COA B e Remove the attribute definition from REV_DIM_ATTRIBUTES_B and REV_DIM_ATTRIBUTES_TL tables This is necessary to prevent the Dimensio
10. modiy ad or elete tens N thes Gonan Control Montong Ths page declines a kit of Jawa EE appikabons and standalone application modes that have been inatalied to thes doman detailed appkabons and mosses can be started stopped updated redepioyed or deleted from the doman by first selecting the acglkcaton name and using the controls on the page To retal a raw accication or modde for deployment to targets in thes doman chch the Install button P Costornize this table kaist Update Dokte Stat Sco Showing Ito Lot 1 Previous Next Mow do L z katsi Update Oekte Stet Step Showing Lto tof 1 Previous Next Faal an Enterprise appkcation Configure an Enterprise okon Update redeploy an Enterprise api ation Rat od shop s Gephoyed Urterprise seekaten Monier the modules of an Enterprise ack abon Orph LO modes baaa Web scelkaton 5 Click Yes in the confirmation dialog to stop the selected deployment Another confirmation message is displayed and the state of the deployment is change from Active to Prepared Messages A Selected Deployments have Deen requested to stop Summary of Deployments Control Montong THs page Gapteys a ist of Java EE applicators and stand sione agplicaton modes Suet Neve been metalied to tus doman Installed applicators and modules Can be started stooped Located edepioyed or deleted fom the doman by frst selecting the appicaton name and using The controls
11. Pre Installation Configuration 2 1 Installer 4 Uncompress the unzip installer file using the command uncompress unzip_ lt os gt Z Note Sometimes you may notice an error message uncompress not found No such file or directory when the package is not installed Contact your UNIX administrator to resolve this issue 5 Make sure that the file has execution permissions set If not run the command chmod 751 unzip_ lt os gt 6 To unzip a file using this utility run the command unzip_ lt os gt a lt name of the file to be unzipped gt For example unzip_aix a OFSAAI7 3_installer zip Environment and Software The environment and software requirements for OFSAAI installation are explained in this section The components that are installed during the Infrastructure installation process are categorized into three layers Infrastructure Web Server Infrastructure Application Server and Infrastructure Database Server components OFSAA Infrastructure can be deployed in a single machine or on multiple machines In a single tier mode the three layers are installed on the same machine In a multi tier mode various combinations of installing the layers are possible as given below e OFSAA Infrastructure can be deployed in a single machine or on multiple machines In a single tier mode the three layers are installed on the same machine In a multi tier mode various combinations of installing the layers are possible as given b
12. home ofsaai to store the Staging Area details then specify the path as home ofsaai ftpshare Specify the port number for SFTP FTP 2 40 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Interaction Variable Parameter Parameter Variable APP_USER_ID_SA Specify the SFTP FTP user ID for Application Layer Staging Area Database Layer Interaction Variable Parameter Variable Parameter DB_SFTP To use SFTP for Database Layer specify the value as 1 To use FTP for Database Layer specify the value as 0 DB_DRIVE_TM Specify the Technical Metadata drive path DB_PORT_NO_TM DB_USER_ID_TM DB_DRIVE_BM DB_PORT_NO_BM DB_USER_ID_BM DB_DRIVE_SA DB_PORT_NO_SA For example if you have created a folder ftpshare under the path home ofsaai to store the Technical Metadata then specify the path as home ofsaai ftpshare Specify the port number for SFTP FTP Specify the SFTP FTP user ID for Database Layer Technical Metadata Specify the Business Metadata drive path For example if you have created a folder ftpshare under the path home ofsaai to store the Business Metadata then specify the path as home ofsaai ftpshare Specify the port number for SFTP FTP Specify the SFTP FTP user ID for Database Layer Business Metadata Specify the Staging Area drive path For example if you have created a folder ftpshare under
13. Ends with Generate Cancel Note e Application and Source names are dynamic e The installer will ask to select the application source pair during installation e The source recommended may be an RDBMS based source in which case the source should be defined on the same schema as the one in which the solution is being installed e Once an application and source has been created in the framework you cannot create a new application and source with the same name The source created earlier will hence be re used for installing the new OFS Applications be it on an information domain infodom already containing an OFS Application or a new infodom As a result if you need to install an OFS Application into an infodom 2 there will be a mismatch since the pre created source will point to schema of infodom 1 e Itis recommended for the current release that you do not create multi infodom installation unless you intend to do it ona non production environment where ETL activities will NOT be performed through OFS Infrastructure A 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide B Third Party Software Software Details The Apache Software License Version 1 7 1 This product includes software developed by the Apache Software Foundation http www apache org Apache License Version 2 0 January 2004 http www apache org licenses Quadbase Systems Inc
14. Resolution Ports mentioned in OFSAAI InstallConfig xml file cannot be NULL Error code OFSAAI 1154 Cause Validation failed Resolution Check the error message shown in the pop up 11 42 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1155 Cause Low disk space Resolution Check the pop up message to know the required amount of disc space Use df k command to check available space Error code OFSAAI 1156 Cause Error while updating FICWeb cfg for HTTPS changes Resolution Update http to https present in lt OFSAAI_INSTALL_DIRECTORY gt ficapp common FICServer conf FICWeb cfg Error code OFSAAI 1157 Cause Error while updating web xml for HTTPS changes Resolution Update FIC_WEBPROTOCOL place holder to https present in lt OFSAAI_INSTALL_DIRECTORY gt ficweb webroot WEB INF web xml Error code OFSAAI 1158 Cause Error writing the uninstall data into uninstall xml Resolution Check the exception message written in the log file configured in Log4j xml Error code OFSAAI 1159 Cause Failed to append footer to the log file Resolution Check the exception message written in the log file configured in Log4j xml References 11 43 Error code OFSAAI 1160 Cause Error while connecting to the configuration schema Resolution Check the exception message written in the log file configur
15. Select the option as either FTP or SFTP and enter the other details as tabulated Field Description Drive Specify the physical path of the FTP SFTP shared directory Drive For example e ftpshare Port Number Specify the database FTP SFTP port number 6 12 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 4 Field Description User ID Password By default the SFTP port number is 22 and can be changed if the port is enabled Specify the user ID that is used to perform an FTP SFTP in the machine where the database server is located It is mandatory to specify the FTP SFTP User ID Enter the password which is same as the specified password for FTP SFTP user ID by the administrator The password is represented by asterisk for security reasons Ensure that there are no special characters in the password specified Modify Web Server Details You can update the pre defined Web Server details and FTP SFTP Details in the Server Master window To update the existing web server details perform the following steps 1 Database Details Database Details in the System Configuration section facilitates you to define the database setup details after you have configured the database server within the Infrastructure System The Infrastructure Database server for which you need to specify the database setup details could have been installed in any o
16. Yes INSTALL_APP Install 0 No Default 0 Application tier components be 1s Ves installed INSTALL_ADMIN_ Install admin BI 0 No Default 0 BI components 1 Yes Applicable only if INSTALL_WEB 1 OR INSTALL_DB 1 INFODOM_NAME Information Not Applicable MANDATORY Domain infodom SEGMENT_CODE Segment Code Not Applicable MANDATORY TABLESPACE Tablespace name Not Applicable MANDATORY INFODOM_TYPE New Infodom or 0 New Specify Infodom Type Existing Infodom 1 Existing Mandatory if this an App Layer Installation Applications Installation 8 27 Property Name Description of Permissible values Comments Property That is you have specified INSTALL_APP 1 APPL_TNS TNS Name of the Not Applicable MANDATORY Infodom database APPL_USER User id of the Not Applicable Mandatory if this an Database Schema App Layer Installation for new Infodom and if you want to create anew infodom That is you have specified INSTALL_APP 1 and INFODOM_TYPE 0 APPL_PWD Password of the Not Applicable Mandatory if this an Database Schema App Layer Installation for new Infodom and if you want to create anew infodom That is you have specified INSTALL_APP 1 and INFODOM_TYPE 0 APPL_URL JDBC Connection Not Applicable Mandatory if this an String of the App Layer Installation Database Schema and if you want to for new Infodom create anew infodom That is you have specified INSTALL_APP 1 and INFODOM_TYPE 0 RAC STATUS whether the Not Applicable Mand
17. component e For more information on specific EPM apps v 6 0 see their individual Installation Manuals available at Oracle Technology Network OTN at http docs oracle com cd E28033_01 homepage htm The Oracle Financial Services Analytical Applications Infrastructure Product comprises of components that are installed in Web Application and Database layer Hence if you have installed Oracle Financial Services Analytical Applications Infrastructure in a multi tier architecture the Oracle Financial Services Applications installer must be invoked on each of the computers that host the Oracle Financial Services Analytical Applications Infrastructure tier This chapter is applicable for the following products Oracle Financial Services Asset Liability Management Oracle Financial Services Profitability Management Oracle Financial Services Funds Transfer Pricing Oracle Financial Services Pricing Management Transfer Pricing Component Oracle Financial Services Asset Liability Management Analytics Applications Installation 8 1 e Oracle Financial Services Hedge Management and IFRS Valuations For a Single tier installation the installer is required to be invoked only once on the machine that hosts all the Oracle Financial Services Analytical Applications Infrastructure tiers This section describes the installation process where the Three Product setup components are installed on separate machines with the Product installation on separ
18. e For more information on specific EPM apps v6 0 see their individual Installation Manuals available at http docs oracle com cd E28033_01 homepage htm Before any Financial Services Application Installation Kit programs are run ensure that the following pre installation activities mentioned in the checklist are all completed successfully The Financial Services Application Installation Kits include the following applications e Oracle Financial Services Asset Liability Management e Oracle Financial Services Profitability Management e Oracle Financial Services Funds Transfer Pricing e Oracle Financial Services Pricing Management Transfer Pricing Component e Oracle Financial Services Asset Liability Management Analytics e Oracle Financial Services Hedge Management and IFRS Valuations Pre Installation Applications Activities Checklist 7 1 The Tasks are as follows Oracle Financial Services Analytical Applications Infrastructure must be successfully installed on a certified environment Oracle Financial Services Asset Liability Management Analytics can be installed after installing Oracle Financial Services Asset Liability on the infodom It is implicit that all base software versions and patch levels required by the operating system of Oracle Financial Services Analytical Applications Infrastructure v 7 3 is available and adhered to If Infrastructure installation is on multitier environment execute the following commands in t
19. make sure that the ports are enabled on the machine The servlet port can have 80 or 443 as port numbers if Default http https ports are being used The FTP Port 21 or SFTP Port 22 and protocol must be enabled on the machines on which Infrastructure Application and Database components will be installed 2 18 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide WebServer Configuration for Infrastructure Application You can configure the web server in the following ways as required Click on the links to view the section in detail e WebSphere Configuration for Infrastructure Application Deployment page 2 19 e WebLogic Configuration for Infrastructure Application Deployment page 2 22 WebSphere Configuration for Infrastructure Application Deployment You can deploy multiple Infrastructure applications on different profiles of a stand alone WebSphere application server To create multiple WebSphere Profiles in a stand alone server use the command line option as explained subsequently A profile is the set of files that define the runtime environment At least one profile must exist to run WebSphere Application Server Creation of New Profile in WebSphere The Profile is created in WebSphere through command line using the manageprofiles sh which resides in lt WebSphere Install directory gt Appserver bin The command to create a profile without admin security through
20. 1 to 20f2 Previous Next iNew Delete ope pe p G S o Fustonps jdbc FUSIONRHEL Load Balancing AdminServer RORDS jdbc RORRHELQT Load Balancing AdminServer New Ociet i Registries XML Entity Caches How do L 5 Create JDBC multi data sources Create JDBC data sources Showing 1 to 2of2 Previous Next Delete JDBC multi data sources System Status a Health of Running Servers Failed 0 Critical 0 Overloaded 0 T____ Warning 0 E o 3 Click the New button Create a New JDBC Multi Data Source window is displayed Note Data Sources which needs to be added to new JDBC Multi Data Source should be already created You also have the option to select Generic Data Source or Grid Link Data Source while creating a Data Source For more information refer Create Data Source or Create Grid Link Data Source Create a New JDDC Multi Data Source Net Carte Configure the Multh Data Source The following propertes nil be used to dentty your new JOC mult data source What would you Re to name you new DSC muid date source Gimme JDBC Muhi Data Source d What JOT name would you ike to assign to your new JOSCE must data source AE INDI Name jdbc izfodonsane What algorithm type for Pis JOGC Mult Osta Source would you like to select AE Aigorthm Type Load Balancing ren cance Enter the JDBC source name JNDI name and the Algorithm Type in the respective fie
21. 4096 To check the number of processes use the following command ulimit u Note This section is applicable if the OS is AIX Ensure IBM XL V9 runtime compiler is installed on all the machines used for OFSAAI installation if this is on AIX It can be downloaded from the following link at http www 1 ibm com support docview wss rs 2030 amp context SSJTIL amp uid swg24015997 amp loc en_US amp cs utf 8 amp lang en Download Package Name is xlcpp rte 9 0 0 aix base tar Z The above package is also applicable for AIX 6 1 2 8 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Hummingbird Exceed 7 0 must be available on all the client machines to be used for infrastructure installation This is required to run the Installation Kit in GUI Mode and also to set the Report Display Configuration page 4 54 However this software is not required if the installation mode is SILENT On all machines in which Infrastructure components will be installed the PATH variable in the user profile of the machines must point to Java Runtime installation The machine on which the Infrastructure Web components are installed the PATH variable in the user profile of the machine must point to Java Development Kit installation Note Itis recommended that Java is installed in the directory without spaces If installed in the path with spaces OFSAAI may not work In Java 64 bit
22. Address Related Changes c ice ern ei ir renter ni ete eteneteiesneteetentee 4 60 Configure Information Domain schema privileges 0 ccccessee eee ete tee eter eteeteeeees 4 63 Configure Infrastructure Server MeMOLY 0 ccccscc eee cee eee eeer sess seen seer seseteneennneteae 4 64 TE 9 lt a EO oo eo 4 66 Information on Patches installed in the environment ccccceeeeeeeeeeeeeceeeeeeeeeeeeenenes 4 69 OLAP Data Server Configura Nons aa e a Ea a aap aa E ea aean 4 70 Object Migration HttpsURLConnection configuration for WebLogic ss sssss1ss1ss1 1 4 70 Configuration for User Attributes Screen ccccccccccecesecseenecneenecnecneececteeeeeeeseeeneeniees 4 71 Configuration of Infrastructure POrtS ssssesessesirtstrttrrtnttrtnttntnttntintnttntnnt at tnen nenene neee 4 71 Modify Web Servet Port cc i icccsisscscupeciteccsgticvencanstetegenanes cyenasaneannsed tasendtacedhenastoneaasuteventin 4 74 OFSAAI Setup Information Fetching Tool cccccccccccsecsecseenecnseceeeetecneeenestieeeeneeenaees 4 74 Eneryption Chang ets tsic tected tee eh teed led a Rea dee 4 75 Configuring HTTPs Certificate information cccccccccccesceeeseetseenecnseceeneceeeeensaeeaeenee 4 75 Infrastructure Configuration for LDAP ieciisissii naina aeai a iadaaa 4 75 Configure OFSAAT Web Services nurin yin ia aia a a a 4 80 Deploy OFSAAT W b S fyices iini eea aa a aeia a a aa a 4 84 Configure Oracle database
23. Configuration Guide Data sources Data sources gt Default Datasource gt JAAS J2C authentication data Specifies a list of user identities and passwords for Java TM 2 connector security to use 2 Prefix new alias names with the node name of the cell for compatibility with earlier releases Apply E Preferences New Delete OF Select Alias gt User 10 gt Description gt You can administer the following resources D GXSiSOREY upgsconf FICMASTER N FICMASTER g x Zone2N i F rorffw o GXSiSOREV Zone2NodeOS ROROENC rorpac O SriiRev Zonezhodets UPGSPFT upgspft upgspft GXSLSOREV upgsprod upgsprod C Zoneanededs uecsoRcp oO GXSiSOREY upgsror upgsror ZonezNodedS UPGSROR GXSiSOREV upgssand upgssand D Zonetiodeds uscssano o x Zone2n VASTEST upgsconf upgsconf Total 8 2 Specify the list of User IDs and Passwords for Java 2 Connector Security 3 Enter the Alias User ID Password and Description Ensure the following e The User ID to be specified is the Oracle user ID that is created for the respective Information Domain e Specify the config database user ID and password information for the jdbc FICMASTER data source and specify the atomic database user ID and password information for the atomic schema data source that you created earlier Post Installation Configuration 4 11 Data sources Rata sources gt Default Datasource gt JAAS 32 authentication data gt New Specifies a l
24. Configure port numbers used by OFSAAInfrastructure OFSAAInfrastructure install directory Application Layer Y Database Layer Y Web Layer Y Infrastructure Java Pon 3425 ICC Server Port 9815 ICC Native Port 9817 Infrastructure Native Port 8721 Infrastructure Agent Port 9812 OLAP Data Server Port 10101 Message Server Port 4376 Router Port 4379 AM Port 6702 Web Server Port 12123 Enter Database Details Select your Database Oracle IP Address Port Number SID Config schema username Config schema password seeceeee Cancel Change 4 72 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Note For more details about the Ports used in Infrastructure see pre installation activities check list page 2 7 The Configure OFSAA Infrastructure Port Changer window displays the following e The path in which Infrastructure components have been installed is displayed e The check boxes corresponding to Application Layer Database Layer or Web Layer are enabled based on the components that are installed on the current machine In the event you have performed a single tier installation on the current machine the check boxes for all three components will be enabled If you have installed more than one category of components on the current machine the corresponding check boxes for the respective components you have installed will be enabled To edit the port v
25. Current Location 097273 sppicators 5 upg7273ear open drectory Next Cance 1 Inthe Choose targeting style window select the Install this deployment as an application and click Next The Optional Settings window is displayed If required enter a name for the deployment in the Name field Install Application Assistant Back Next Cance Choose targeting styte Targets are Me servers dusters and virtual hosts on which this deployment un There are several ways you Can target an aoplicaton Install this deployment as an application The aoplcaton and its components wil be targeted to the seme locators Ths g the most common usage Install this deployment as a brary Agokcaton lmranes are deployments thet are aveladie for ofer Geployments to share LOranes should be avaladie on al of the targets ning her referenone sopicetors 2 In the Security setting select the DD only option to specify that only roles and policies that are defined in the deployment descriptors should be used Also select the I will make the deployment available from the following location option under Source accessibility Click Next to continue Post Installation Configuration 4 41 Install Apphcatbon Assstact Sea Mess Fear Cercei Optional Settings You can modify these settings o accept the defauts General Wheat co you nant So meme Ths Geployment Mame upg 273 Security What security mode do you mant to use wath ths applicaton
26. DB_USER_ID_BM value cannot be NULL or NA Error code OFSAAI 1203 Cause Resolution Invalid configuration in OFSAAI_ PostInstallConfig xml file DB_PORT_NO_SA value cannot be NULL or NA Error code OFSAAI 1204 Cause Resolution Invalid configuration in OFSAAI_ PostInstallConfig xml file DB_USER_ID_SA value cannot be NULL or NA 11 52 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1205 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution SECURITY_USER_ID value cannot be NULL or NA Error code OFSAAI 1206 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution SECURITY_SHARE_ NAME value cannot be NULL or NA Error code OFSAAI 1207 Cause Invalid configuration in OFSAAI_PostInstallConfig xml file Resolution WEB_LOCAL PATH value cannot be NULL or NA Error code OFSAAI 1208 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution WEB_SHARED_STORAGE ENABLE value can take only 0 or 1 Error code OFSAAI 1209 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution WEB_FTP_ENABLEvalue can take only 0 or 1 Error code OFSAAI 1210 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file References 11 53 Resolution WEB_SFTPvalue can take only 0 or 1 Error
27. Information Domain Drive Joracie rheldb ftpshare Configuration Port Number 2 Segment Metadata Mapping Segment Map Security Hierarchy Security Web Server Details IP Address 10 184 134 147 7077 Serviet Port 22 User Id Password Design OFSAAI Menu _Cancel_ _Help Rules Setup Configuration 2 Administration EA Advanced Analytics Infrastructure HA AMHM UMM Offline Population Financial Services Applications Web Sever within the System Configuration section of Infrastructure system facilitates you System Administrator to add and modify the Web Server set up details You can access Web Server window by selecting System Configuration in left menu and selecting the Server Details section By default the Web Server Server Master window displays the pre configured web server details in the View mode Add Web Server Details In the Infrastructure system you can create multiple web servers to route users through different web servers For example you can route internal and external users through different web servers However one of the Web Server has to be defined as primary server You can add a web server by specifying the Web Server details and FTP SFTP Details in the Server Master window 6 10 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide OFSAA Infrastructure Windows Internet Explorer ORACLE Connectedto ATom73stT M Home S Unified Met
28. Installation 3 To enable https configuration on Infrastructure assign value 1 to HTTPS_ENABLE in OFSAAI InstallConfig xml for Silent mode OFSAAIT installation Configure Tomcat The servlet engine required by the Infrastructure application is Tomcat The servlet engine is expected to be installed on the machine identified as the Infrastructure Web Post Installation Configuration 4 45 Server as stated in the section Environment page 2 2 Instructions on configuring Tomcat are given in this section Tomcat User Administration The Tomcat administration and manager application does not provide a default login You are required to edit CATALINA_HOME conf tomcat users xml as instructed below This file contains an XML lt user gt for each individual user which will display the username and password used by admin to log into Tomcat and the role names admin user is associated with Example lt user name admin password admin roles standard manager gt Add the manager role to any one of the existing username password combination as shown in the example mentioned earlier Use the same username password to which the manager role has been assigned to access the Tomcat Application Manager If the Tomcat server is already running it requires a re start after the earlier configuration is done Configure Tomcat to use JAVA 64 bit Executable Navigate to the CATALINA_HOME bin folder Edit the setclasspath sh as explained s
29. IntroductlOnisiiviiaiichinial aaa adn Ate S aia Adah nai ads 11 1 OFSAAT Installations FA Os ena cise iae lee ais ee and ed ical 11 2 OFSAAT Configuration FAQS ti sitdetecaiiantsi adie Maat aaa ai a aN 11 5 Errr Dictionary aae aa aoa andi EE a a R aE AE EEEE Eea EA E a a a EA ERA 11 9 Defining Application Sources Introduction iniia ch iaia a a ara aieeaa ar eaaa aaa ea Aa EE Ea EEA aA A 1 Creating an Application Source sssssisssssiisnssiirirsiistnnsriinsrnstissintnsrnntinsrartnsrnnernnrnren erene ee A 1 Third Party Software Software Def S a a a a a reta B 1 vii Send Us Your Comments Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Release 7 3 Part No E28235 01 Oracle welcomes customers comments and suggestions on the quality and usefulness of this document Your feedback is important and helps us to best meet your needs as a user of our products For example e Are the implementation steps correct and complete e Did you understand the context of the procedures e Did you find any errors in the information e Does the structure of the information help you with your tasks e Do you need different information or graphics If so where and in what format e Are the examples correct Do you need more examples If you find any errors or have any other suggestions for improvement then please tell us your name the name of the company who has licens
30. OFSAAI 1230 Cause WEBSERVER path given is not valid Resolution Provide valid WEBSERVER path in WEBSERVERPATH tag of OFSAA _InstallConfig xml file Error code OFSAAI 1231 Cause Invalid IP address Resolution Provide a valid IP address in OFSAA Infrastructure Server Details For more information check InfrastructurePreValidations Log file 11 58 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide A Defining Application Sources Introduction Application Sources must be created within Data Integrator for the Application Installation to copy the relevant files for the seeded loaders For more information about the Data Integrator and Defining Sources see Oracle Financial Services Analytical Applications Infrastructure User Guide Creating an Application Source Follow the steps below to create the application sources that are necessary for the installation to copy the relevant files for the seeded loaders 1 Verify user s group for which the application user has been assigned ETL Analyst role This allows the user to access the Data Integrator menu 2 Confirm that an FS Data Model has already been successfully uploaded to the Information Domain 3 Login as the application user and navigate to Unified Metadata Manager gt Data Integrator Framework gt Warehouse Designer gt Data Sources 4 Define Source Applications e Create Applicatio
31. Specify how many days Internet Explorer should save the iist of webstes you have visted Days to keep pages in history Cx core Cx caneet_ soo In the Internet Options window select the Security tab and select the Internet option under Select the Web content zone to specify its security settings Click Default Level under Security level for this zone Post Installation Configuration 4 67 Internet Options General Security Privacy Content Connections Programs Advanced Select a zone to view or change security settings amp y 9 Local intranet Trusted sites Restricted sites Internet Q This zone is for Internet websites except those listed in trusted and restricted zones Security level for this zone Allowed levels for this zone Medium to High Medium high Appropriate for most websites Prompts before downloading potentially unsafe content Unsigned ActiveX controls will not be downloaded Loe _corcet_ If the browser is accessed through Windows XP this Infrastructure installation site needs to be added to the list of trusted sites This can be done from the Internet Options window Select the Security tab and select the Trusted Sites option Click the Sites button In the Trusted Sites window that is displayed enter the Infrastructure URL in the Add this Web site to the zone box Click Add 4 68 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Instal
32. as specified during installation Name Enter the database Name Ensure that there are no special Locale Identifier characters and extra spaces Note that for Oracle database the TNS Transparent Network Substrate database name should be same as SID Select the locale from the drop down list The specified locale is identified at the time localization set up 6 16 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Field Description User ID Password JDBC Driver Name JDBC Connection String Date Format Specify the atomic schema User ID to access the database The system authenticates the specified User ID before providing access Enter the password required to access the database The system authenticates the specified password before providing access The default JDBC Driver Name is auto populated based on the database type selected 1 For MSSQL DB type it is com microsoft jdbc sqlserver SQLServerDriver 2 For ORACLE DB type it is oracle jdbc driver OracleDriver 3 For DB2UDB DB type it is com ibm db2 jcc DB2Driver In case of modification ensure that the specified driver name is valid since the system does not validate the Driver Name The default JDBC Connection String is auto populated based on the database type selected For MSSQL DB type it is jdbc microsoft sqlserver lt lt DB Server Name gt gt lt lt Port Number gt gt
33. be installed Pre install Configuration C Application Layer Pre insta 3 C Databse Layer C Web Layer Please Choose the option to configure Adminstrative Reports Yes O No Along with appropriate Oracle Financial Services Analytical Applications Infrastructure layer select Administrative Reports to configure the Administrative Reports application Note e Fora single tier Oracle Financial Services Analytical Applications Infrastructure 7 3 installation you must select Application Layer Database Layer and Web layer For a multi tier Oracle Financial Services Analytical Applications Infrastructure 7 3 installation select the corresponding layer installed on the machine e If Admin Blis already configured through the previous product installation the subsequent product installation without Admin BI option may alter the existing Admin BI configuration settings e Inthe case of ALM BI solution the preceding screen would look as following 8 18 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Solution Setup ttroducbon Please choose the OF SAA Layers on wehich Soksion is to be instated Pre Install Configuraton C Application Layer J Databse Layer 6 The following window will be displayed which will prompt to select the infodom from list of infodoms present in the setup enter segment code and enter the application schema s TNS name Note Segment na
34. c ccccccceeeeeeeccecceeeeeeeeeececeeaaeceeeeeeeeeeseccaeaeeeeeeeeeeseeeeees 4 10 JOBG Connection Pooling a eaae ae Metadata Sites ae 4 12 Configure Resource Reference in WebLogic Application Server cccccccecseeeeseeteeeees 4 13 Create Data Source teicu ds ccesiseeccdedeetitetaavscecgucdegssctaeeueespasicesuedivest cv edeeiidh ame ENEE 4 13 Create GridLink Data SOULCE ieee ee ee re rennin re eree tener tereseeteeeteretenaseneee 4 19 Configuring Multi Data SOULCES cccccccceecsecnecneeee ene ceeesecaecaeeaecseeneensesneseeeaeenes 4 20 Advanced Settings for Data Soutces ni uge riai e aiai eaii EAS 4 24 JDBC Connection Pooling 22 2 nienia a ee ee E a E E 4 26 Configuration of Resource Reference in Tomcat Application Servet ccccccsceenees 4 27 Create Wa ta Source rts tiie sie ett ao AEEA a a daaa a aaa 4 27 JDBC Connection Pooling iieri est Adeeb hie ed eee ee ee ee ia 4 28 Configure WebSphere eairt aeai aiae aeaa e aaa aE ealag tabs 4 29 Create WebSphere BAR Fie irongpne air e aa a Eae Eae aE Ad cece ee eee 4 29 Deploy WebSph re EAR Fil siiatrdeet eing ee pee te ee Eee edd A 4 29 WebSphere HTTPS Confisurationie incite hele Re ee eli 4 38 Configure WebLOgiC iena a at spanish sha aa E dash aves baled dha EAEE E EARR 4 38 Create EAR WAR file for WebLogic iisi ee ee ee eee eene seer iaaa aaa aain Ea 4 38 WebLogic EAR WAR Files Deployment 0 cies ee ee ten eene eter eteetenreteeeseneeeneee 4 39 WebL
35. conf and start the server e When saving Database Server Details during Infrastructure Configuration the Infrastructure server must also be started in the foreground do not use nohup to answer the following prompt which appears in the Unix server command on Save Start Stop Infrastructure Services 5 1 The host 10 123 45 678 is currently unknown to the system The host key fingerprint is 1023 1e 35 46 7f 81 e7 16 6b 33 e8 59 f7 d cf 5b b1 Do you want to allow this host key Yes No Always Always should be entered when prompted and Save operation will complete successfully in the Database Server Details window e You can also start the Infrastructure Server by executing the command nohup reveleusstartup sh amp Starting the process using nohup and amp will return the command prompt without having to wait till the process completes However this command cannot be used when you are starting the server for the first time or starting after changing user password in the configuration database schema 2 Select the required web server start up option from the following table Type Description Starting WebSphere profile On the machine in which Websphere is installed navigate to Webshpere_Install_Directory AppServer lt profiles gt lt profile name gt bin and execute the command startServer sh server1 Starting WebLogic Domain On the machine in which WebLogic is installed navigate to lt WebLogic In
36. configuration schema and to facilitate that you need to execute the file lt Infrastructure Database Layer Install Directory gt config_table_privileges_for_atomic_user sql from the Infrastructure config database before the Information Domain is created You System Administrator need to have SYSADM function role mapped to your role to access and modify the Information Domain details You can access Information Domain in left menu of System Configuration By default the Information Domain Maintenance window displays the pre configured Information Domain details and allows you to add modify and delete Information Domains 6 22 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Create Information Domain You can create Information Domain only when you have a defined database which has not been mapped to any Information Domain To add Information Domain details 1 Select Add button from the Information Domain Maintenance window The window is refreshed and enables you to populate the required data in the fields OFSAA Infrastructure Windows Internet Explorer Eek Financial Services Analytical Applications Infrastructure ORACLE apo OREP A Cast agn Doe OTD Last Faled Logn Daie 01 06 2012 110 Connectedto Atomz3st M Information Domain Maintenance h Home B Unified Metadata Manager HCF Rules Framework Ef Forms Framework BA Operations EE system Configuration Serv
37. date formats is supported by Financial Services Applications and is initialized in Global Preferences e Equivalent Oracle DB date formats for UI date format Note These date formats are for internal usage and the user should not modify them e lt infodom gt _SOURCE_NAME This is the Source Name respective to the infodom used for T2T definitions e SIMPLE_BATCH_PAGE_SIZE This controls the number of tasks listed per page The recommended default value is 50 records page 9 6 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 10 Uninstall Infrastructure Components Introduction The uninstallation process will uninstall all Infrastructure and FS Application related files from the installed directory Before you start the uninstallation process ensure that no open connections exist to the Config schema and Infrastructure servers are shutdown To uninstall Infrastructure run the profile Navigate to FIC_HOME directory and grant execute permission to UnInstall sh file Execute UnInstall sh and follow the instructions e Uninstallation does not remove the Infrastructure application from Web Server This has to be done manually e The entries in the profile file will have to be removed manually e Incase of multi tier architecture uninstallation must be performed on all the machines in which Infrastructure components are installed e Make sure that no user
38. details for business metadata Check InfrastructurePreValidations log file for the error message and provide correct details for ftpshare Error code OFSAAI 1224 Cause Unable to validate Application layer ftpshare details for staging area 11 56 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Resolution Check InfrastructurePreValidations log file for the error message and provide correct details for ftpshare Error code OFSAAI 1225 Cause Unable to validate SECURITY_SHARE_NAME Resolution Check InfrastructurePreValidations log file for the error message and provide correct details for SECURITY_SHARE_ NAME SECURITY_USER_ID Error code OFSAAI 1226 Cause Mismatch in Java versions Resolution Update the value mentioned for JAVA_BIN tag in OFSAAI Installconfig xml to JDK 1 6 Error code OFSAAI 1227 Cause Mismatch in Java versions Resolution Ensure that the 64 bit java executable is present in the path mentioned in set in JAVA_BIN tag of OFSAAI Installconfig xml Error code OFSAAI 1228 Cause WEB_FTP_ENABLE is not configured properly Resolution Make sure WEB_FTP_ENABLE value is 0 in remote WEBSERVER configuration References 11 57 Error code OFSAAI 1229 Cause Tnsping failure Resolution Ensure that you are able to do tnsping The command is tnsping lt Instance name gt Error code
39. e Error ORA 02275 such a referential constraint already exists in the table e Error ORA 01430 column being added already exists in table e Error ORA 02303 cannot drop or replace a type with type or table dependents Execute the dm_post_ lt APP_ID gt _ins_6_0 sql on the ATOMIC schema where APP_ID stands for ALM FTP PFT HM e Restore the backup table of rev_object_register e Restore data from backup tables For more information on list of tables see the individual EPM apps v6 0 Installation Manuals available at http docs oracle com cd E28033_01 homepage htm e For upgrade from 5 6 or below navigate to FIC_APP_HOME common FICServer bin and Execute UpgradeConfig sh e For Admin BI configuration follow the steps mentioned in Oracle Financial Services Administrative Reports on OBIEE 11g Configuration Note docx under FIC_HOME adminbi e The web xml under the path FIC_WB_HOME webroot WEB INF should have Resource tag if not present add the tag and replace ORDEMO with the INFODOM name lt resource ref gt lt description gt DB Connection ORDEMO lt description gt lt res ref name gt jdbc ORDEMO lt res ref name gt lt res type gt javax sql DataSource lt res type gt lt res auth gt Container lt res auth gt lt resource ref gt Expand the Server Types under Servers option in the Left menu Click WebSphere application servers option This will display the Application Servers page Navigate to the Web Co
40. e Required Database Type and Database Driver should be selected Post Installation Configuration 4 15 Create a New JDBC Data Source Beck Next cake JOEL Data Source Properties The following properties mi be used to densify your new JOSC date source Database Type Orde What database driver would you ike to use to create database comectons Note ndicates that the diver s expbotly supported by Orade Webloge Server Database Ortver Oracle s Denver Thin XA for instance connections Versions 9 0 1 and later Beck Next Cance 5 Select the Database driver from the list You need to select the Database Driver depending on database setup i e with or without RAC Click Next 6 Select the Supports Global Transactions check box and select the One Phase Commit option Create a ew JDBC Data Source Bact Next Cancer Transaction Options You have selected non KA JOSC driver to create database conmection in your new data source Does ths data source support gobs transactons If yes please choose the transaction protocol for ths data source Supports Global Transactions Select ths opton f you meant to enable non Ka JBC commectons fon the date source to pertopete n Gobel tarsactors usne the Loppng Last Resource LR Tecsecton optrnreton Recommended n piace of Emuiate Tno Phase Commit Legging Last Resource Select tes option f you ment to enable non Ka JBC connections fon the data source to emisie Dartepeton n giobal tereactors us
41. from the server Note e The data model xml file should be available in the server e If the installation is being performed on an existing information domain the data model that is planned to be selected in this panel should be merged with the data model that was previously uploaded in the information domain If the installation is being performed on a new information domain data model that is either customized or merged with other data models can be selected in this panel 11 The following window displays pre model upload details Verify the details before proceeding to the next step Click Next to proceed for model upload 8 10 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Solution Setup Intooxcdon Please review the folowing before Continuing Pro instal Configuration Information domain Name NEWINFO bare reel prt Oats Model xmi tile FTP_Datamodelson ERwin xmi Path ORACLE FINANCIAL SERVICES Clicking Next will start the model upload process This process will take some time depending on the size of the data model and available physical memory in the environment User will not be able to take any further action on the window until the model upload process is complete Also this step cannot be rolled back If the model upload fails then a pop up message with relevant error and the log file path will be displayed Review errors and take
42. in Tomcat Click Undeploy link against the deployed Infrastructure application to remove the Infrastructure application deployed S Apache ee Software Foundation http www apache org Tomcat Web Application Manager Wal ACCP Cabos HIM Manas titie Manaoes ret Serti Slats tass erwt ant SP taamoas __Expire sessions ue et caase tenga Uorsger agoucenes vee t L Expire seasons wen weal 20 amais PETTE Re emut net apocaner we i Set ee Bees Uncepey A confirmation message is displayed on the application Infrastructure being uninstalled 10 6 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide ue Ap ache re Foundation Softw it are w apache org Uninstall Infrastructure Components 10 7 11 References Frequently Asked Questions Introduction This section information is developed to help you resolve some of the OFSAAT Installation and Configuration issues This is not an official support document and just attempts to share the knowledge of problem resolution to a few of the known issues What is Oracle Financial Services Analytical Applications Infrastructure Oracle Financial Services Analytical Applications Infrastructure powers the Oracle Financial Services Analytical Applications family of products It performs the processing categorizing selection and manipulation of data and information needed to analyze understand an
43. is connected to the database while uninstalling the Infrastructure Database Layer e All the Database objects from atomic schemas have to be dropped manually e The file under ftpshare location has to be deleted manually Uninstall Infrastructure Components 10 1 Uninstall EAR Files in WebSphere Following are the steps outlined to uninstall any previously deployed application 1 Open the URL in the browser window http lt ipaddress gt lt Administrative Console Port gt ibm console https if SSL is enabled The login window is displayed Login with the user id that has admin rights 2 Expand Applications gt Application Types gt WebSphere enterprise applications from the left menu The Enterprise Applications window displays all the deployed applications set ante sem se TE Views Al tents ole Daye B Guded Actes Enterprise Appi ations 8 Servers 2 Jee this page to manage installed applicabons A unge apckkabon can be deplored onto mooie B teptcators ne r weet el ates a otot Update ber de Uyn bpon OC Export Fle B eoh os eSoTyY Select Nane Aogikabon Ratus Q You can aGeurester the following resources 7 AlxGaST os BServkes E eroro OrlautAccto ac K Bsearty hom B Enveceerert avery gt E System adres on E Users and Groups E Montonng and Tung E Troutierhcoang 8 Servae reg avon 8 uoo 3 Select the checkbox adjacent to the application to be uninstalled and click Stop and Click Un
44. is displayed with the list of all the applications deployed In the Deploy section enter the Context Path provided during the installation as lt context name gt Enter the Path where the lt context name gt war file resides by default FIC_WEB_HOME lt context name gt war in the WAR or Directory URL and click Deploy Post Installation Configuration 4 49 eae Context Path reqared uppa J IM Configarsten tie URL WAR ex Orectory URL loratata tappinsiappwebionebiupps T war WAR Sle se deploy Select WAR te 19 upload C C Tas Gagos check sdl trigger a AA garbage cofiecton Use 4 with eseme caution oa production systems Seer Macros ysrems ie ewe 2610 154 ein Copyright 1999 2012 Apache Software FOSIDOA Upon successful deployment of the application a confirmation message as shown in the following figure is displayed 4 50 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide See Apache Software Foundation http www apache org Tomcat Web Application Manager Stet Step Arner wince Expee sessions nc N Set iaa Grai noii Expresessicns e ces 3 fat Sep Sees pases Expre sessions we cea 3 Son ine Sene Duaan Expre sessions ween D Sat Sop Apoed Uncdesty C Expre sessions wer ces 30 Stet Sass Asaa Uecepey For information on starting the Tomcat server see Starting Infr
45. or home db2insti sqllib java on Linux TM If a value is specified for you you may click Next to accept the value Class path Directory location for ojdbc6 jar which is saved as WebSphere variable S ORACLE_JOBC_ORIVER_PATH oracle orajdbc app orajdbc product 23 2 0 client_t jdbe lib e The Oracle JDBC driver Download ojdbc6 jar for Oracle 11g R2 file corresponding to the required version of Oracle Client can be downloaded from the following URL http www oracle com technetwork database enterprise editio n jdbc 112010 090769 html e Once downloaded you need to place the file in required folder in your system While creating the JDBC Provider ensure that the path to the jar file in the folder is specified in the Class path field in the Enter database class path information window 6 Verify the details and click Finish to create the JDBC Provider Post Installation Configuration 4 5 Create a new JDBC Provider Create a new JOEC Provider Create new vider Summary of actions Ea z ter cells GXS5150REV Zone2Node05Cell nodes GX5150REV Scope Zone2NodeOS serversiserveri Step 3 Summary JDBC provider name Oracle JOBC Oriver Description Oracle JOEC Oriver Class path ORACLE_JDBC_DRIVER_PATH ojdb lt 6 jar S ORACLE_JOBC_ORIVER_PATH Joradie orajdbe app orajdbe product 11 2 0 cient_1 jdbe lib imel melas name oracle jdbe pool OracleConnectionPoolData Sourc
46. required space Infrastructure Application Layer 113 MB Infrastructure Database Layer 125 MB Infrastructure Web Components 275 MB Infrastructure EAR WAR file deployment in web layer 307 MB Space used for WebSphere Profile Creation 200 MB Space used for Tomcat 270MB Note Make sure that tmp area has a minimum of 1 4 GB space Optional Enable http compression on the web server note that some web servers may require specific plugins to enable http compression You can contact your System Administrator to enable http compression Oracle Database Configuration The Oracle Service and the Oracle TNS listener must be started on the machine which is designated as Infrastructure Database Server The Oracle SID that will be used by the application must be specified as an appropriate entry in tnsnames ora In case of multi tier installation the tnsname and SID should be the same in both the Application and Database Layers The oracle database alias name created for oracle instance and oracle service name should be the same In a multi tier installation in which the Database server and Application Server are in different machines the Application Server must have Oracle Database Client installed 2 10 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide OFSAAT installation requires a minimum of two database schema users usually referred to as
47. section from server xml file in CATALINA_HOME conf directory to avoid conflict during undeploy and re deploy of the WAR file Place comment lt gt in between the context path section For example lt l lt Context path pr2test docBase home perfuser tomcat 7 0 19 webapps pr2test debug 0 reloadable true crossContext true gt lt Resource auth Container name jdbc PR2ATM type javax sql DataSource driverClassName oracle jdbc driver OracleDriver username prZatm password pr2atm url jdbc oracle thin 10 184 74 99 1521 PERFTEST maxActive 100 maxIdle 30 maxWait 10000 gt lt Context gt gt Restart the Tomcat service by doing the following e Login to the Unix server through a terminal emulator e Navigate to catalina_home bin directory Uninstall Infrastructure Components 10 5 e Stop the tomcat services using the command shutdown sh e Start the tomcat services using the command startup sh 2 Open the URL in Browser window http lt IP address gt lt Tomcat server port gt The Tomcat home page is displayed Click the Tomcat Manager link on the Left menu Login with the user id that has admin rights For user creation in tomcat refer to the section Tomcat User Administration page 4 46 3 Click Tomcat Manager link on the LHS menu and login with the user id that has admin rights The Tomcat Web Application Manager is displayed with the all the applications deployed
48. server You can also configure a web server which is installed in other machine as primary web server by selecting the checkbox Specify the local path location where the static files need to be copied in the primary server For example e revftp System Configuration 6 11 Field Description Shared Storage Enabled OFSAAIT Context Protocol FTP Enabled The static files such as Infrastructure OBIEE reporting server pages are copied to the specified location Note The Web Server Unix user must have read write privileges on the Local Path directory If not contact your system administrator Select shared storage enabled checkbox to access the static files or folders shared in another web server within the network The files are read from the specified directory instead of copying to the primary web server Enter the context in the OFSAAI Context field Select the protocol as either HTTP or HTTPS from the list Infrastructure supports FTP SFTP into Web Server and streaming of files In case FTP SFTP is not allowed in a Web Server due to security reasons system can stream the data across Web Servers so that the Client need not compromise on their Security policy Select FTP enabled checkbox to configure Web Server FTP details and to create FIV path automatically 3 Optional If you have selected the FTP Enabled checkbox you can specify the Drive Port Number and user details in the FTP details section
49. tabulated System Configuration 6 5 Field Description Security User ID Enter the user ID which has the same user rights as the user who installed Infrastructure The Application server validates the database user Id Password to the database server s for connection purposes Security Password Specify the password for the user who would be accessing the security share name The password is represented by asterisk for security reasons Security Share Name Enter the path locating the DB components installation folder which has been specified by the user who has installed the infrastructure system For example D Infrastructure 5 Click Save to save the Database Server details Modify Database Server Details To update the existing database server details 1 Select Modify button from the Server Master window The window is refreshed and enables you to edit the required data in the fields 2 Update the Database Server details as required Except for the OS type which is auto populated you can edit all other details including IP Address Server Socket Port and FTP details in the Technical Metadata Business Metadata and Staging Area tabs For more information refer Add Database Server Details page 6 3 3 Click Save to save the changes Application Server Application Server refers to a computer in a distributed network which provides the business logic for an application program The Application Se
50. the path home ofsaai to store the Staging Area details then specify the path as home ofsaai ftpshare Specify the port number for SFTP FTP Pre Installation Configuration 2 41 Interaction Variable Parameter Parameter Variable DB_USER_ID_SA SECURITY_USER_ID SECURITY_SHARE_NAME Specify the SFTP FTP user ID for Database Layer Staging Area Specify the User ID using which the Database layer has been installed In case of Multi tier specify the FIC_LHOME path of the Database layer In case of Single tier enter the value as specified in the tag USER_INSTALL_DIR which is the valid absolute path where all Infrastructure components are required to be installed Web Layer Interaction Variable Parameter Parameter Variable WEB_LOCAL_PATH Specify the local path of Web Server WEB_SHARED_STORAGE_ENAB To enable Web Layer shared storage specify the value as LE WEB_FTP_ENABLE WEB_SFTP WEB_DRIVE 1 To disable Web Layer shared storage specify the value as 0 To enable FTP SFTP specify the value as 1 Else specify o Note that in case if the WebServer is configured on a remote machine set the WEB_FTP_ENABLE value as 0 Specify the value only if WEB_FTP_ENABLE is set to 1 To use SFTP for Web Layer specify the value as 1 To use FTP for Web Layer specify the value as 0 Specify the value only if WEB_FTP_ENABLE is set to Awe Specify the SFTP FTP drive p
51. the following message will be displayed and you will be returned to the prompt BUILD SUCCESSFUL Time taken 4 38 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 4 The EAR file lt contextname gt ear is created on the machine on which Infrastructure Web components are installed under FIC_WEB_HOME directory Note This process overwrites any existing version of EAR file that exists in the path WebLogic EAR WAR Files Deployment The steps for deploying Infrastructure application in WebLogic is as follows 1 On the machine in which WebLogic is installed navigate to lt WebLogic Installation directory gt user_projects domains lt domain name gt lt bin and execute startWebLogic sh d64 file to start WebLogic Open the following URL in the browser window http lt ipaddress gt lt admin server port gt console https if SSL is enabled The Sign in window of the WebLogic Server Administration Console is displayed Ensure that you have started Infrastructure Server by executing reveleusstartup sh as mentioned in Start Infrastructure page 5 1 Sign on with the WebLogic user name and password having privileges to deploy the EAR file From the left hand menu under Domain Structure click Deployments The Summary of Deployments window appears Click Install The Install Application Assistant window is displayed Post Installation Configura
52. the status of the installation of Infrastructure components The log configReveleus log provides the status of execution of scripts creation of tables and port changes Any of these reported Warnings Non Fatal Errors Fatal Errors Exceptions in each of these logs should be brought to the notice of the OFSAAI Infrastructure Support Recommended not to proceed until the reported problems are adequately addressed How do Completely Uninstall OFSAA Infrastructure OFSAA Infrastructure can be completely uninstalled by performing the steps provided in the Uninstalling Infrastructure page 10 1 11 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide OFSAAI Configuration FAQs On the UNIX System terminal Error message shows reveleusstartup sh java Execute permission denied while executing reveleusstartup sh file What is to be done Ensure JAVA_BIN environment variable path is set on the unix user terminal from where the reveleusstartup sh file is invoked Ensure the profile where the environment path settings are made has been executed successfully What happens when the OFSAAI Application Server does not proceed even after providing the system password System Password provided when prompted should match with the Oracle Config password provided during installation and check whether connection to the Config schema can be established through sqlplus If Reva
53. to configure the log4j xml file 2 38 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Tag Tag Value priority value Enter any of the following values DEBUG INFO WARN ERROR Note if priority value is set to DEBUG then the log messages for all the levels are written DEBUG has the highest priority and ERROR has the least priority in the following sequence DEBUG gt INFO gt WARN gt ERROR appender ref ref The appender name specified in the appender ref ref tag is used for logging messages By default ConfigReveleusFileAppender is provided in the log4j xml File Enter the file path in the value tag Ex oracle setupapp log OFSAAIGUL log Append Enter true to append log messages recommended By specifying False each log file is replaced with new log message MaxFileSize Enter the value of log file size Ex 1000kb MaxBackupIndex The value indicates the maximum number of backups of the Log file created ConversionPattern The conversion pattern in which the messages are logged in the in Log file is as indicated d E dd m yyyy hh mm ss OFSAAT 5p m n Configure OFSAAI_PostlInstallConfig xml File Configure the Application Layer Database layer and Web layer components in the OFSAAT_PostInstallConfig xml Always ensure that all the three Interaction Variable Pre Installation Configuration 2 39 Parameter APP_SFTP DB_
54. values Note DSNID refers to Information Domain name e dn DSNID lt DSN ID gt ou Domains LDAP_DIRECTORY_ROOTCONTEXT e changetype add e mappedsegments lt Mapped segments gt e dsnid lt DSN ID gt e infodomname lt Information Domain Name gt e objectClass Infodom e objectClass top e infodomdescription lt Information Domain Description gt Example dn DSNID FUSIONMOCK ou Domains dc FTP1 dc com mappedsegments dsnid FUSIONMOCK infodomname FUSIONMOCK objectClass Infodom 4 78 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide objectClass top infodomdescription FUSIONMOCK Then navigate to the LDAP installation directory and execute the following command ldapmodify D ROOTDN w ROOTPASS f data Domains dif Note You can add entries for multiple information domains at the same time Migration of Data from CSSMS tables to LDAP Server If you are using LDAP authentication it is required to migrate all the details from the CSSMS table which contains the information entered using the Infrastructure Administration module under Security Management to the LDAP Server To migrate data from CSSMS tables to LDAP server 1 Invoke the LDAP_Migration sh file in FIC_HOME MigrationUtilities Migration_LDAP bin Folder The Select Source and Destination for Migration window is displayed with the option to migrate the data from CSSMS to
55. 0 0 0 ccc cc cece ee terre tere tneeteeeeeeees 7 1 8 Applications Installation Introductions naina a Mie hada Maan elias sade ka ae ithe 8 1 GUI Installation ncn nada e a iene eA Aa E 8 2 Machine A Product App Layet cccccccccesecs iE ee Eara arae AAAA EEE LAE E aa re aE 8 2 Machine B Product Database Layel ccccccccceccccttecseeetecnseeseenescaeenecnseceeeeseeaeeaeenieenees 8 15 Machine C Product Web layer 2 scc0 tics nele piee aang eel eee de edit 8 21 Silent Installation iae iaaii aa a a a aa Ganeia e aa A EA A badieascdbehedeebaedd 8 26 vi 9 Post Application Installation Activities 10 11 Post Application Installation Checklist 0 0 00c ccc eee eee eeee eee eeeeeseneeseeeseeeseneeseeetetees 9 1 Configuration of FusionApps properties 0 cccce eee ceee eens e cree cree sens eeseseneseseesseeenneenaee 9 6 Uninstall Infrastructure Components Introductions sient tid ain tien this tiated Adie aide edt aednaecdeanieiiscid 10 1 Uninstall EAR Files in WebSphete 00 0cccccec eee cee cee ennee cesses eee teesneessneeseeteaeenaes 10 2 Uninstall EAR WAR Files in WebLogic 0 c cece ce ee cette cert ee eee teat teeta ae tae teeseaeteeeeaeeaes 10 3 Uninstall WAR Files in Tomcat 0 0 000 cece cette tee a aa tener te eee E aaa e eaa aaia ie 10 5 References Frequently Asked Questions 00c ccc ce ee ene tener erent ene enn ates seneetereseeesnneseratentee 11 1
56. 0 or 1 Error code OFSAAI 1091 Cause The WEB_SERVICES is provided with a value other than 0 or 1 as parameter Resolution The WEB_SERVICES value take only 0 or 1 as parameter References 11 29 Error code OFSAAI 1092 Cause The ERWIN_VERSION parameter is provided with a value other than 7 1 or 7 3 Resolution The ERWIN_VERSION parameter must be provided with either 7 1 or 7 3 as value Error code OFSAAI 1093 Cause The SFTP_ENABLE parameter is provided with a value other than 1 or 0 Resolution Provide the SFTP_ENABLE parameter value either as 1 or as 0 Error code OFSAAI 1094 Cause The name of server is too big Resolution Provide proper IP address of the servers Error code OFSAAI 1095 Cause The name of database server is too big Resolution Provide proper IP address of the database servers Error code OFSAAI 1096 Cause Ping to server is failed Resolution Ensure that the servers configured in OFSAAI InstallConfig xml are in the network and ping utility is available to the user 11 30 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1097 Cause The name of Application server is too big Resolution Provide the correct Application server IP address in OFSAAI InstallConfig xml file Error code OFSAAI 1098 Cause The name of Web server is too big Resolution Provide the c
57. 2 22 WebLogic Configuration for Infrastructure Application Deployment ccccen 2 22 Creation of New Domain in WebLogic ccccccccccsecsectseeeeeeteenaeeecnaeeseenseceeeeenaeeseenes 2 22 Deletion of a Domain in WebLogic cceccccet cece ene ceene eects cnieceeeeteenaeeneenieeseeeeeens 2 31 Populate installation configuration xMl 0cccccee cece eens tees eens eeeeeeeeeseeeeeeeeeeseeeennees 2 31 Layers within the OFSAAT InstallConfig xml cccccccecccceeccneeeeeenecneeeneeneeeeeeneeeeneeees 2 32 lop4j xml Configuration on cc Site ch hire Shh eae eae at al oe ine Bante Wh bale a 2 38 Configure OFSAAI_PostInstallConfig xml File 0cccccccccsceecsseeeecnteeneeeteeneeeseenaeeeenees 2 39 3 Infrastructure Installation Installation Process ccccce 3cieese Ee aa decbend a a ea deena E e a a a eA 3 1 GUI Mode Installation irria a n ee A dc ont ede 3 2 Silent Mode Install ati oniinn ele ee os Se ee ce el 3 12 4 Post Installation Configuration Configure Resource Reference 0 ccc ee ee en ni renner tent nne eno teetenesnieaseenenngs 4 1 Configure Resource Reference in Infrastructure Web Application ccccceeeereeees 4 2 Configure Resource Reference in WebSphere Application Servel ccccccccceeeseeeeeteenes 4 2 Create JDBC Providetiscn adh a iene Aidan ne en dele 4 2 Cr ate the Data Sourceninct aisien win pe e a e ata neni ict tales dente aden 4 6 J2C Authentication Details
58. 8 3 Log on to the server in which Tomcat is installed Deploy Tomcat WAR Files Before deploying the WAR files ensure that the previously deployed applications of Infrastructure are uninstalled For the procedure to uninstall the previously deployed Infrastructure war files see Uninstall WAR Files in Tomcat page 10 5 On the machine that hosts Tomcat follow the steps outlined to deploy Infrastructure application 1 Open the URL in Browser window http lt IP address gt lt Tomcat server port gt https if SSL is enabled The Tomcat home page is displayed 4 48 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Home Documentation Configuration Wiki Mailing Lists Find Help Apache Tomcat 7 0 19 ene ache Software Foundati if you re seeing this you ve successfully installed Tomcat Congratulations Oher Deweloads Oher Decomemarion Gat involved Uiscetlareout Apache Sefware boundetion Ioma Connectors Lomat Commectors renee Cota Tamanna mea Decumentupen EAM Beccatones Leas a Teos Toman Nias mamaya Sotesuane nenea Qoe Qectoes ee Inasta Yaneura Atrnasea Copyngm 1993 2011 Apache Software Foundaton Al Sights Reserved Click the Manager App The Connect to dialog is displayed Login with the user id that has admin rights For user creation in Tomcat refer to the section Tomcat User Administration page 4 46 The Tomcat Web Application Manager window
59. A mast be installed and configured on the machine The FiCserver is runing and ail other OF SAAI servers are shut down price to start of he saluton instaladon Please ensure he OF SAN version is 7 3 Note At any point if yoa wish to edit peeviousiy entered information you may access he previous screens by clicking on the Previous buton 3 Select the log mode for this installer If Debug is selected the passwords will be printed in the Log File Solution Setup Please select he Log Mode required for this Installation Note Eyou select Debug mode the passwords will be printed in the bog fle The log file will be weiten in the path spectiod in the log4j xmi Sle of the installer 4 Enter the 9 digit Customer Identification number provided during the OFSAAI installation Applications Installation 8 3 T Solution Setup Click Next to continue 5 The Pre Setup Information window requests for setup information Select the appropriate Oracle Financial Services Analytical Applications Infrastructure layer that has been installed on the machine Example Application Layer Solution Setup Introduction Pre Install Corifiguration Please choose the OFSAN Layers on which Solution is to be installed Application Layer C Databse Layer L Web Layer Please Choose the option to configure Admintstrative Reports Yes O No Along with appropriate Oracle Financial Services Analytical Applications I
60. AI Installation and Configuration Guide Error code OFSAAI 1145 Cause Error while choosing installation component Resolution To install all the three components give INSTALLMODE value as 1 in the OFSAAT InstallConfig xml Error code OFSAAI 1146 Cause Error while choosing installation component Resolution Choose at least one component to install Error code OFSAAI 1147 Cause Java Bin path is invalid Resolution Set proper JAVA_BIN path in OFSAAI InstallConfig xml Error code OFSAAI 1148 Cause Invalid web application server path Resolution Provide proper web application server path in OFSAAI InstallConfig xml Check the path provided in WEBSERVERPATH tag of OFSAAT Installconfig xml Error code OFSAAI 1149 Cause Invalid password for default users Resolution Enter a valid password for OFSAAI default users GYSADMN and SYSAUTH Password must be at least six characters long and alphanumeric References 11 41 Error code OFSAAI 1150 Cause Validation for database is failed Resolution Check the error message shown in the pop up Error code OFSAAI 1151 Cause Database component details are blank Resolution Fill up all the fields in the Database component details panel Error code OFSAAI 1152 Cause Error while copying AESCryptKey ext Resolution Check the error message shown in the pop up Error code OFSAAI 1153 Cause Ports are empty
61. Acronyms Conventions Description AIX Advanced Interactive eXecutive DEFQ Data Entry Forms and Queries DML Data Manipulation Language xi xii Conventions Description EAR EJB FTP GUI HTTPS J2C J2EE JDBC JDK JNDI JRE JVM LDAP LHS OFSAAI OLAP OS RAM RDBMS SFTP Enterprise Archive Enterprise JavaBean File Transfer Protocol Graphical User Interface Hypertext Transfer Protocol Secure J2EE Connector Java 2 Enterprise Edition Java Database Connectivity Java Development Kit Java Naming and Directory Interface Java Runtime Environment Java Virtual Machine Lightweight Directory Access Protocol Left Hand Side Oracle Financial Services Analytical Application Infrastructure On Line Analytical Processing Operating System Random Access Memory Relational Database Management System Secure File Transfer Protocol Conventions Description SID System Identifier SSL Secure Sockets Layer TNS Transparent Network Substrate URL Uniform Resource Locator VM Virtual Machine WAR Web Archive XML Extensible Markup Language See Related Information Sources on page xiv for more Oracle product information Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http www oracle com pls topic lookup ctx acc amp id docacc Access to Oracle Su
62. BER_CODE_COLUMN specifies the member table column which holds the alphanumeric member code This is optional for numeric dimensions where alphanumeric and numeric member codes would be equivalent e MEMBER_COLUMN specifies the numeric member code column A new installation by default will have the seeded key dimensions configured as numeric although those dimension member tables include a column for alphanumeric member codes You can configure any of these dimensions as alphanumeric For more information refer to Configure Alphanumeric Dimensions page 4 86 You might also need to run some SQL updates for numeric dimensions For more information refer to Configure Numeric Dimensions page 4 88 Configure Alphanumeric Dimensions To configure an editable dimension as alphanumeric and to remove the optional code attribute from prior releases you have to back up the affected dimension tables like REV_DIMENSIONS_B REV_DIM_ATTRIBUTES_B REV_DIM_ATTRIBUTES_TL and DIM_ lt DIMENSION gt _ATTR and perform the following steps on each applicable dimension 4 86 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Set the member type as alphanumeric VARCHAR2 in REV_DIMENSIONS_B and identify the member table s alphanumeric code column name if it is not populated already Update REV_DIMENSIONS_B SET Member Data Type Code VARCHAR2 Member Code Column Alphanumeric Column Name
63. ECT FROM V NLS_PARAMETER WHERE PARAMETER NLS_NCHAR_CHARACTERSET can be executed Error code OFSAAI 1133 Cause The default NLS_CHARACTERSET of Oracle instance is not AL32UTF8 Resolution Oracle instance must be created with the default NLS_CHARACTERSET as AL32UTF8 Use SELECT FROM V NLS_PARAMETER WHERE PARAMETER NLS_CHARACTERSET to check the status Error code OFSAAI 1134 Cause Error while fetching NLS_CHARACTERSET Resolution Ensure that SELECT FROM V NLS_PARAMETER WHERE PARAMETER NLS_CHARACTERSET is executable Error code OFSAAI 1135 Cause Value of maximum number of open cursor is less than 200 11 38 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Resolution Value of maximum number of open cursor should be at least 200 Check the value using SELECT VALUE FROM V PARAMETER WHERE NAME OPEN_CURSORS and set the value to 200 using ALTER SYSTEM SET OPEN_CURSORS 200 Error code OFSAAI 1136 Cause Resolution Error while fetching value of maximum open cursors Ensure that SELECT VALUE FROM V PARAMETER WHERE NAME OPEN_CURSORS is executable Error code OFSAAI 1137 Cause Resolution Select privilege on SYS V_ PARAMETER view is not provided Execute privileges_config_user sql and provide configuration schema name to give required privileges You need to login as SYS user to execute thi
64. Id You can access Database Server window by selecting System Configuration in left menu and selecting the Server Details section By default the Database Server Server Master window displays the pre configured database server details In order to add or modify the database server details you need to ensure that e The FTP SFTP service should be installed on the Web Application and DB Server e The FTP SFTP ID for Web App and DB server has to be created through the Computer Management option under Administrative Tools for all the installations other than UNIX installations e This user should belong to the administrator group e The FTP SFTP password for Web App and DB server needs to be specified in the Computer Management option under Administrative Tools In addition the 6 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Password Never Expires option has to be checked Note The Server Master window displays the pre configured Database Server Details specified during OFSAA Infrastructure Installation For more information refer to Database Server Details configuration in Start Infrastructure page 5 1 Add Database Server Details You can add a database server by specifying the Database Server Details FTP Details and Security Details To add database server details 1 Select Add button from the Server Master window The window is refreshed and en
65. Install_Directory gt AppServer profiles lt profile name gt properties to zero Edit this file and ensure that the default timeout value 180 in the original line com ibm SOAP requestTimeout 180 is changed to 0 The commented line in the file must be com ibm SOAP requestTimeout 0 Following configuration steps are required to process struts request on WebSphere These steps allow processing the struts filter Log in to WebSphere Admin Console Navigate to Application Servers gt lt server gt gt WebContainer Settings gt Web Container gt Custom Properties Add the following property Property Name com ibm ws webcontainer invokefilterscompatibility Value true Tomcat related Prerequisites Ensure that Tomcat is installed in directories where the directory names do not contain spaces If the directory name contains spaces then accessing the application may pose problems Uninstall any previously deployed applications hosted in Tomcat This must be done prior to the start of the installation The user ID that will be used to install the Infrastructure Web components must be given write permissions to the Tomcat installation directory Set the CATALINA_HOME environment variable to the Tomcat Installation directory For more information see Tomcat User Administration page 4 46 2 14 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide You m
66. Installation and Configuration Guide Security Management gt System Administrator gt Segment Maintenance section Create Add User with access to all permissions For information see OFSAAI 7 3 User Manual Administration gt Security Management gt User Administrator section Note Each new file that is created in the ftpshare folder of any installation layer should be granted specific explicit permission If you encounter any problems during setup please contact Infrastructure Support Stop Infrastructure Services To stop Infrastructure services 1 On the machine in which Infrastructure Application components have been installed navigate to FIC_APP_HOME common FICServer bin and execute the command reveleusshutdown sh Stop ICC server On the machine in which Infrastructure default Application components have been installed navigate to FIC_LHOME ficapp icc bin and execute the command iccservershutdown sh Note Only Infrastructure Default Application Server would hold ICC component Stop Back end server On the machine on which Infrastructure Database components have been installed navigate to FIC_DB_HOME bin and execute the command agentshutdown sh Start Stop Infrastructure Services 5 5 6 System Configuration Introduction System Configuration is an integral part of Infrastructure administration process and facilitates System Administrators to provide security and operational fra
67. LDAP or vice versa Select Source amp Destination for Migration LDAP To SMS SMS To LDAP Ok Close Select the SMS to LDAP option and click OK The Select Entities to Migrate window is displayed You can select the data that you wish to migrate such as Users User Groups Functions Roles Segment Profiles Holiday Master Function Role Maps User User Group Maps User Group Role Map and User Group Domain Map Post Installation Configuration 4 79 Select Entities To Migrate y User y User Group Function Role Segment Profile Holiday Function Role Map User User Group Map User Group Role Map User Group Domain Map Migrate Close Select the entities that you wish to migrate and click Migrate The migration takes place and a confirmation window is displayed You can verify the data migrated to LDAP server through the LDAP Browser 4 You should also enter the passwords for all the users as passwords are not migrated in migration process Configure OFSAAI Web Services Web Services in OFSAAI is meant for exposing a web service to asynchronously or synchronously execute requested tasks offered by OFSAAI The following configuration steps are to be done only if you are using the Web Services feature of OFSAAI Configure DynamicWSConfig xml File For each third party web service that needs to be accessed using the OFSAAI Web services framework and the operations to be invoked corresponding entries are t
68. Multi Tier Installation Option You may choose to install the three components on separate machines with the servlet engine on the same machine identified as the infrastructure web server This particular architecture would be as follows e Infrastructure database components are installed in Machine A e Infrastructure Application components are installed on Machine B e Infrastructure web components are installed on Machine C e Web server is installed in on Machine C The following diagram illustrates the possible combinations in a Multi Tier Installation Option I MachineA Machine B Machine C Database Application components Web server Web components components Pre Installation Configuration 2 5 Multi Tier Installation Option Il You may choose to collapse the Infrastructure Database and Application layers into one machine and host the Infrastructure web layer along with the servlet engine on a separate machine This particular architecture would be as follows e Infrastructure database and application components are installed on Machine A e Infrastructure web components are installed on Machine B e Web server is installed on Machine B The following diagram illustrates the possible combinations in a Multi Tier Installation Option II Machine A Machine B Web server Database and Web Application components components Multi Tier Installation Option Ill You can choose to host the Infrastructure data
69. NAME gt lt INPUT ORDER SORDER PARAMNAME PARAMNAME ARGTYPE SARGTYPE CLAS SNAME CLASSNAME gt lt OUTPUT PARAMNAME S PARAMNAME RETURNTY PE RETURNTYPE CLAS SNAME CLASSNAME gt lt OPERATION gt lt WEBSERVICE gt lt WEBSERVICES gt lt XML gt The DynamicWSConfig xml has the following placeholders which has to be updated depending on the web service chosen and the mode of accessing it For each Web service to be accessed the entire webservice tag in the DynamicWSConfig xml file must be repeated The following placeholders should be set in accordance to the parameters published in the third party wsdl files webservices to be accessed The stub class specified must implement the com iflex Oracle Reveleus execution webservice EXEWebIF interface Attributes for WEBSERVICE tag CODE Unique number within the xml file and cannot be 999 or 0 ENDPOINT soap address location in the wsdl service name tag of the wsdl file TARGETNAMESPACE The attribute value for the targetNamespace of the wsdl definitions tag XMLNS_XSD The attribute value for the xmlns s of the wsdl definitions tag ENCODINGSTYLE The attribute value for the xmIns soapenc of the wsdl definitions tag SERVICENAME Name of the service found under the wsdl service name tag of the wsdl file PORTTYPENAME wsdl p
70. OFSAAI 1046 Cause DB2PATH bin not found in PATH variable Resolution Provide DB2PATH bin in PATH variable Error code OFSAAI 1047 Cause DB2PATH sqllib lib not found in LIBPATH variable Resolution Provide DB2PATH sqllib lib in LIBPATH variable 11 20 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1048 Cause Resolution User does not have permission to create directory to write the logs Give write permission to write log in the specified directory entered in Log4j xml file Check the log file path configured in log4j xml Ensure that the user is provided with write permission Use chmod command to give permission Error code OFSAAI 1049 Cause Resolution Locale in OFSAAI _InstallConfig xml is null Make sure LOCALE tag in OFSAAI _InstallConfig xml has value en_US Error code OFSAAI 1050 Cause Resolution Property File with locale name does not exist or locale mentioned in the OFSAAI InstallConfig xml is not supported by the installer Make sure LOCALE tag in OFSAAI_InstallConfig xml has value en_US and MyResources_en_US properties is present in setup kit directory Error code OFSAAI 1051 Cause Resolution The en_US locale is not installed in the System Install en_US locale in the system Error code OFSAAI 1052 Cause Resolution Invalid servlet port entere
71. OLD IP Host Addresses with the new WEB Server IP Host Address Update the OLD IP Host Addresses with the new WEB Server IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address The following tabulated are the tables and corresponding columns that need to be updated 4 62 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Table Name Column Name CONFIGURATION ETLSOURCEDETAILS DB_MASTER DSNMASTER FICSYSMASTER SETUP_SERVER_INFO DB_SERVER_INFO SETUP_PORTS OLAP_MASTER WEB_SERVER_INFO BATCH_PARAMETER BATCH_PARAMETER_ MASTER APP_SERVER_INFO Update the PARAMVALUE for JICSHOST V_SRV_IP_ADDR DBIPADDRESS JDBCCONNSTR DBSERVER OLAPIPADDRESS WEBIPADDRESS APPIPADDRESS DBIPADDRESS AM_IP_ADDRESS DBIPADDRESS V_DBSERVERIP V_APPSERVERIP V_WEBSERVERIP OLAPIPADDRESS WEBIPADDRESS V_PARAMETER_VALUE V_PARAMETER_VALUE APPIPADDRESS Configure Information Domain schema privileges As the Information Domain Schema uses some of the tables from the configuration schema ensure to execute the following file from the Infrastructure configuration database user before Information Domain is created Post Installation Configuration 4 63 lt Infrastructure Database Layer Install Directory gt con
72. ORS 200 Pre Installation Configuration 2 11 If the Infrastructure database components and Infrastructure database server engine is designated on two different physical machines Oracle client must be installed in the system where Infrastructure Database Components are being installed The Oracle SID that will be used by the application must be specified as an appropriate entry in tnsnames ora file in the system where Infrastructure Database Components are being installed and also in the system where Oracle Database Server Engine is installed Make sure that the tnsname and SID are the same in both the Database Components Layer and Database Server Engine The Oracle instance must be created with the default NLS_CHARACTERSET as AL32UTF8 and the default NLS_LENGTH_SEMANTICS as CHAR However these options are auto validated during the OFSAAI installation Ensure that at least 512 MB temporary tablespace and at least 512 MB default tablespace are available in the machine in which Infrastructure configuration schema will be installed On the machine which is designated to be the Infrastructure database server ensure that the ORACLE HOME environment variable is set pointing to the Oracle Installation path directory in the profile file Ensure that a minimum of 10 MB or higher quota is granted to the users config and atomic for the default tablespace Note After the installation is done you need to execute config_t
73. Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Release 7 3 Part No E28235 01 February 2014 ORACLE Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Release 7 3 Part No E28235 01 Copyright 2014 Oracle and or its affiliates All rights reserved Primary Author Arpana Danayak Contributor Anand Shekar Aneesh Kurian Susan Bernstein Rusma Harvey Chris Tanaka Niraj Biswal Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International Inc AMD Opteron the AMD logo and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices UNIX is a registered trademark of The Open Group This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering di
74. Orede Mddewere user _projects domans vog N The path to the source of the deployable urit on the Adminstraton aocicatons 1997273 ea Server More Info Deployment Plane ro plan specfed The path to the deployment plan document on Administaton Server More info Staging Mode ret specie The mode thet speofies whether a deployment s fies are copied fon a source on the Adminstraton Server to the Managed Server s staging area Garg sopicaton preparation More inf Secerity Hodet 00y The security model that is used to seare a deployed modde Mere Info Deployment Order 100 An integer value that indicates when ths unt is deployed relatve to other deplorable units on a server during startup More inf amp Deployment Principal A string value thet ecicates what pinapa should be used when deploying Name the fie or archive during startup and shutdown This principal wil be used to set the arrent maiyect when calling out nto application code for interfaces such as ApphcatontfecyceListener If no pinapa name is speciied then the anonymous principal wil be used More Info ito tof Previous Next Showrg 1 to lof 1 Previous Next 5 In the left menu click Deployments Select the newly deployed Infrastructure application and click Start gt Servicing all requests Ensure that the Infrastructure server should be up and running 4 44 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Install
75. Petey ErtirePoot Cery or reret cance 4 12 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Configure Resource Reference in WebLogic Application Server In WebLogic you can create Data Source in the following ways e For anormal Database instance Generic Data Source page 4 13 can be created e When Database is RAC configured Gridlink Data Source page 4 19 has to be created e When Load Balancing Fail over is required Multi Data Source page 4 20 has to be created Create Data Source The following steps are applicable for both config and atomic data source creation 1 Open the following URL in the browser window http lt ipaddress gt lt administrative console port gt console https if SSL is enabled The login window is displayed Login with the user id that has admin rights ORACLE WebLogic Server 11g Administration Console Welconm Log nto werk mth the WebLope Server doman Veernanne manazer Posewor OTTEET 2 From the left menu under Domain Structure click Services gt JDBC gt Data Sources The Summary of JDBC Data Sources window is displayed Post Installation Configuration 4 13 Summary of JDBC Data Sources MockSol WLS Console Mozilla Firefox DAR E Edt vew History Bookmarks Tools Help lt X B http 10 184 74 118 7007 console console portal _nfpb true amp _pageLabel GlobalJDBCDataSour
76. SFTP and WEB_SFTP are same Also the port number provided among the Application Layer Database layer and Web layer components should be either SFTP or FTP The Post installation configuration steps can be performed only during installation of OFSAAIT Application Components in case of Multi tier architecture and when the Post Install configuration is enabled Application Layer Interaction Variable Parameter Parameter Variable APP_SFTP APP_DRIVE_TM APP_PORT_NO_TM APP_USER_ID_TM APP_DRIVE_BM APP_PORT_NO_BM APP_USER_ID_BM APP_DRIVE_SA APP_PORT_NO_SA To use SFTP for Application Layer specify the value as 1 To use FTP for Application Layer specify the value as 0 Specify the Technical Metadata drive path For example if you have created a folder ftpshare under the path home ofsaai to store the Technical Metadata then specify the path as home ofsaai ftpshare Specify the port number for SFTP FTP Specify the SFTP FTP user ID for Application Layer Technical Metadata Specify the Business Metadata drive path For example if you have created a folder ftpshare under the path home ofsaai to store the Business Metadata then specify the path as home ofsaai ftpshare Specify the port number for SFTP FTP Specify the SFTP FTP user ID for application layer Business Metadata Specify the Staging Area drive path For example if you have created a folder ftpshare under the path
77. SegmentMetadata Mapping FIV Password Segment Map Security Hierarchy Security cance lig Design OFSAAI Menu Rules Setup Configuration Administration id Advanced Analytics Infrastructure SA AMHM UMM Offline Population Financial Services Applications 2 Enter the OLAP details as tabulated Field Description Server IP Enter or select the OLAP server IP from the drop down list The OLAP Server IP address is the IP address of the machine on which OLAP server is running Type Select the OLAP database type from the drop down list The available options SQLOLAP ESSBASE EXPRESS DB2OLAP ORACLE 6 20 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Field Description Note the following while selecting the OLAP DB type s By selecting ESSBASE and DB2OLAP you need to specify different user id and password for Cube Creation and Cube Viewing to avoid locking of the cube when the cube is being built By selecting SQLOLAP and EXPRESS you need to specify one set of user id and password common for both Cube Creation and Cube Viewing By selecting ORACLE you need not specify user id and password for Cube Creation and Cube Viewing In the same server Multiple OLAP types can be installed in the same server and configured in OFSAAI Locale Identifier Select the locale from the drop down list The specified locale is identified a
78. Step 1 Enter basic information Summary of actions Step 2 Select JOSC Options Values provider cells GXS1SOREV Zone2Node0SCell nodes GXS1SOREV Scope Zone2NodeOS servers servert settles for the Data source name AtomT data source INOI name jdbe ORYMOCK Step 4 Setup Select an existing Oracle JOBC Dri security aliases JDBC provider Bil esos y i o ohh dass oracle jobc pool OracleConnectionPoolDataSource URL jdbc oracle thin 10 184 108 91 2522 0rcliigr2 Data store helper class com ibm websphere rsadapter Oracle10gDataStoreHelper name z _ Use this data source in container managed true persistence CMP Component managed authentication alias none ee eee none Container managed none authentication alias Previous Finish cancel You can also create and map J2C authentication alias after creating the data source 8 You must create another Data source by following the earlier procedure with jdbc FICMASTER as JNDI name pointing to the configuration schema of Infrastructure J2C Authentication Details The following steps are applicable for creating both config and atomic J2C Authentication To create J2C Authentication details perform the following steps 1 Select the newly created Data Source and click the JAAS J2C authentication data link under Related Items Click New 4 10 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and
79. TUS Enter the RAC status as 0 Note If RAC STATUS is 1 the DBSERVER value can remain as NA RAC URL Enter the jdbc string value when RAC_STATUS is 1 DBUSER Specify the Database user name which is the user created for configuration database schema For example configuser DBNAME Specify the Database name as OracleSID DBPORT Specify the Database port to default value 2 34 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Interaction Variable Parameter Variable Parameter ABS_DRIVER_PATH Specify the Database driver path as lt ORACLE_HOME gt jdbc lib The ABS_DRIVER_PATH refers to the JDBC driver files path OLAP_SERVER_IMPLE Specify the value as 1 to configure OFSAAI OLAP feature else enter MENTATION 0 SFTP_ENABLE To enable SFTP specify the value as 1 or specify 0 to use FTP option LOCALE By default the value is en_US which should not be modified changed APPLICATION Interaction Variable Parameter Variable Parameter ERWIN_VERSION Enter the version as 7 1 7 3 POST_INSTALL Note This post configuration will update server details of Application Web and Database layer If post configuration of OFSAAI setup has to be done through the installer then specify this tag as 1 else 0 If you have specified the value as 1 refer to Configure OFSAAI_PostInstallConfig xml page 2 39 File section If you have specified this tag as 0 you need to
80. USTSTORE STRUSTSTORE DD TRUSTSTOREPASS STRUSTPAS SWORD DD KEYSTORE SKEYSTORE DD KEYSTOREPASS SKEY PASSWORD PROVIDER SPROVIDER DATE FORMAT MM dd yyyy ct Infrastructure Configuration for LDAP This provides you with the option of using LDAP Lightweight Directory Access Protocol authentication or Infrastructure SMS authentication for logging on to Infrastructure Post Installation Configuration 4 75 If you are using the Infrastructure authentication the user and user group details profile creation function and role maintenance and other mappings can be done through the Infrastructure Administration module under Security Management The data in this case will be updated in the CSSMS table However if you wish to use LDAP for user authentication then you have to ensure that the LDAP server is installed and configured Note e Make sure that OPEN LDAP 2 2 29 is installed and configured e Before doing the following configuration it is required to select the Authentication type as LDAP in the Configuration window of Infrastructure This window can be accessed by selecting System Configuration gt Configuration in the Left menu of Infrastructure e Inthe Windows machine in which LDAP Server is installed go to the OpenLDAP installation directory through the command prompt and execute the following command to start the LDAP server slapd d 1 Config
81. WAR file OFSAAI war file For more information see Tomcat WAR Files Creation page 4 47 and Tomcat WAR Files Deployment page 4 48 Ensure that the previously deployed applications in Tomcat are removed before starting the re deployment Start all OFSAAI servers All servers should be directly started in the server e If the Web Server is WebSphere re create and re deploy the WAR file OFSAAI war file Ensure that the previously deployed applications in WebSphere are removed before starting the re deployment Start all OFSAAI servers All servers should be directly started in the server For more information see WebSphere EAR Files Creation and WebSphere EAR Files Deployment page 4 29 e If the Web Server is WebLogic re create and re deploy the WAR file OFSAAI war file Ensure that the previously deployed applications in WebLogic are removed before starting the re deployment Start all OFSAAI servers All Post Application Installation Activities 9 3 servers should be directly started in the server For more information see WebLogic EAR WAR Files Creation page 4 38 and WebLogic EAR WAR Files Deployment page 4 39 e Start all Oracle Financial Services Analytical Applications Infrastructure v7 3 Servers For assistance in starting the servers see Starting Oracle Financial Services Anaytical Applications Infrastructure Servers page 5 1 e Assign the appropriate administrator application user groups to the Oracle Financ
82. _preferences e rev_group_filter e rev_hierarchies 6 26 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide rev_hierarchy_filter rev_hierarchy_levels rev_hier_definitions rev_hier_flattened rev_hier_maintanance rev_locale_hier rev_member_dependencies rev_mf_process_output_details rev_mf_process_output_master rev_model_output_details rev_model_output_master rev_model_primary_key_details rev_model_simulation_details rev_model_simulation_master rev_object_dependencies rev_property_columns rev_property_stp rev_tables_b rev_tables_tl rev_table_classification_b rev_table_classification_tl rev_table_class_assignment rev_table_class_properties System Configuration 6 27 e rev_table_properties e rev_tab_columns e rev_tab_columns_mls e rev_user_bihier e rev_user_cube e rev_virtual_tables e rev_virtual_tables_mls e sys_stg_join_master e sys_tbl_master The following tables are no longer created during Information Domain creation but are created during EPM Applications installation with the FIC_HOME scripts atomic create dm_common_ddl sql script e fsi_db_info e fsi_engine_lookup e fsi m_auto_balancing e fsi_rollup_signage_cd e fsi_rollup_signage_mls e fsi_signage_cd e fsi_signage_mls e rev_column_requirements Modify Information Domain By default the Information Domain Maintenance window displays the details of the selected Information D
83. a analysis OFSAA Infrastructure Windows Internet Explorer Eek Financial Services Analytical Applications Infrastructure User stuser ORACLE 3 Dat i 120 A D M Connected to ATOM73ST In Setup LIN Connectedto Atom73stT M Information Domain Maintenance M Home Unified Metadata Manager SEF Rules Framework ff Forms Framework Description atom73st BA Operations B system Configuration I Is authorization required for Business Metadata S Server Details Database Server Information Domain Details Name ATOM73ST Is this a Staging Information Domain Application Server Web Server Database Details OLAP Details Information Domain Configuration Segment Metadata Mapping Segment Map Security Hierarchy Security Design OFSAAI Menu Rules Setup Configuration a z Administration amp amp Advanced Analytics Infrastructure amp AMHM UMM Offline Population Financial Services Applications Asa ree isen Epee cance ter Information Domain in the System Configuration section facilitates you to define and maintain the Information Domain Details within the Infrastructure system e The Information Domain Maintenance window can be accessed only if the Server details are defined and at least one database has been created e One Information Domain can be mapped to only one database and one database can be mapped to only one Information Domain e The Information Domain schema makes use the tables from the
84. a HTTP s connection to external resource from WebLogic server the following exception comes because of underlying API uses WebLogic implementation Caught Exception creating connection java lang ClassCastException weblogic net http SOAPHttpsURLConnection To avoid this problem add a java option entry DUseSunHttpHandler true in setDomainEnv sh file which resides in the WebLogic server Ensure that Sun Implementation is required to Support Object Migration for https protocol using self signed certification 4 70 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Configuration for User Attributes Screen The User Attributes feature of Infrastructure allows you to enter additional attributes for a user The CSSMS_ATTRIB_MAST table in the Config schema should be loaded with data based on the additional attributes that are required to be captured for a user The field labels in the User Attributes screen of Infrastructure will be dependent on the values that are entered in this table Following is an example of the data to be loaded in the CSSMS_ATTRIB_MAST table CSSMS_ATTRIB_MAST table ATTRIBUTE_ID ATTRIBUTE_DES ALLOWED_VALUES TYPE Cc PH Phone Number 0 HT Home town Bangalore Mumbai Delhi 1 Chennai MGR Manager select case when v_usr_id 2 lt USER gt then null else v_usr_id end v_usr_name from cssms_usr_profile Here ALLOWED_VALUES column holds t
85. able to write properties file Resolution Check the exception message in the InfrastructurePre Validations Log file 11 26 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1078 Cause Invalid Customer Code Resolution Ensure that the customer code doesn t contain any space and it is exactly the same as the code provided during the shipment Error code OFSAAI 1079 Cause Invalid value in XML File Resolution Check the OFSAAI pre configuration manual to update the OFSAAI InstallConfig xml properly and check InfrastructurePreValidations Log file Error code OFSAAI 1080 Cause Invalid JAVA_BIN path Resolution Provide proper JAVA_BIN path in OFSAAI installConfig xml file Error code OFSAAI 1081 Cause The ORACLE_HOME path is not set properly Resolution Set ORACLE_HOME environment variable in profile Example ORACLE_HOME software oracle11gr2 product 11 2 0 dbhome_1 export ORACLE_HOME Error code OFSAAI 1082 Cause The ISAPPSERVER value is not one for single tier installation References 11 27 Resolution For single tier installation ISAPPSERVER tag value must be one in OFSAAI InstallConfig xml file Error code OFSAAI 1083 Cause The ISDBSERVER value is not one for single tier installation Resolution For single tier installation ISDBSERVER tag value must be one in OFSAAI InstallConfig xml
86. able_privileges_for_atomic_user sql from configuration schema with the required session permission In the prompt displayed specify the atomic schema name Locale Settings 2 12 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Essbase Configuration WebSphere related Prerequisites The following locales must be installed on the machine in which Infrastructure Database components will be installed en_US UTF 8 AIX Solaris en_US utf8 For RHEL en_US ISO8859 1 AIX Solaris en_US iso88591 For RHEL The HYPERION HOME ARBORPATH and ESSBASEPATH environment variables need to be set in the user profile where OFSAAI Database components are installed Example ARBORPATH essbase essbase11121 Oracle Middleware EPMSystem11R1 common EssbaseRTC 64 11 1 2 0 export ARBORPATH ESSBASEPATH essbase essbase11121 Oracle Middleware EPMSystem11R1 common EssbaseRTC 64 11 1 2 0 export ESSBASEPATH HYPERION_HOME essbase essbase11121 Oracle Middleware EPMSystem11R1 export HYPERION_HOME Ensure that the following library paths exists in the user profile ARBORPATH bin Additional Information Hyperion Essbase is required only if you are using the OLAP feature of OFSAAI ESSBASEPATH and ARBORPATH both refer to the same path Pre Installation Configuration 2 13 You must set the timeout value in the soap client props file in lt WebSphere_
87. ables you to populate the required data in the fields ODR User stuser OFSAA Infrastructure Windows Internet Explorer Financial Services Analytical Applications Infrastructure ORACLE z Logor bout Last Login Date 01 06 2012 01 22 57 PM L ed Login Date 01 06 2012 Connectedto ATOM73sT Server Master A Home a DataBase Server Details S Unified Metadata Manager SF Rules Framework Efa Forms Framework EA Operations 18 system Configuration B Server Details IP Address Socket Server Port OS type FIP C 10101 FTP Details Application Server Web Server Technical Metadata Database Details OLAP Details Information Domain Business Metadata f Staging Area Drive Joracie rheldb ftpshare Port Number Configuration User ld Segment Metadata Mapping Segment Map Security Hierarchy Security Design OFSAAI Menu Rules Setup Configuration amp Administration a amp Advanced Analytics Infrastructure SA AMHM UMM Offline Population Financial Services Applications Password Next gt Cancel Help 2 Enter the Database Server details as tabulated Note Few of the fields in Database Server details are auto populated based on the options specified during application installation and are not editable System Configuration 6 3 Field Description IP Address Socket Server Port OS Type FTP SFTP If the IP address of the Infrastructure configuration servers is sp
88. adata Manager B Rules Framework ff Forms Framework Ee Operations B system Configuration Qh Serer Details Database Server Application Server Web Server Database Details OLAP Details Information Domain Configuration Segment Metadata Mapping Segment Map Security Hierarchy Security Design OFSAAI Menu Rules Setup Configuration 2 Administration EA Advanced Analytics Infrastructure ZA AMHM UMM Offline Population Financial Services Applications Financial Services Analytical Applications Infrastructure ESTES User stuser Server Master Web Server Details IP Address Serviet Port Is Primary 10 184 134 147 7077 2 v Local Path Please enter a valid path oracle rhelweb ftpshare Shared Storage Enabled V OFSAAI Context Protocol FTP Enabled FTP Details FTP Drive Port Number User Id Password To add web server details ofsa73 https 7 v SFTP Joracle rheldb ftpshare 22 rhelweb Save _ _Cancet_ _Help 1 Select Add button from the Server Master window The window is refreshed and enables you to populate the required data in the fields 2 Enter the Web Server details as tabulated Field Description IP Address Servlet Port Is Primary Local Path Enter the IP address of the web server Specify the web server port number For example 21 Select the checkbox if you are defining a primary web server All the static files will be copied to the defined web
89. allConfig xml do the following 1 Run XML_Utility jar under OFSAAI Installation kit directory by executing java jar XML_Utility jar Enter the interaction parameters as explained in Layers within the OFSAAIT InstallConfig xml page 2 32 section Pre Installation Configuration 2 31 3 Click Create XML to create new OFSAAI InstallConfig xml Note the Following e You need to copy the populated OFSAAI InstallConfig xml to OFSAAT installer kit directory before proceeding with OFSAAI installation e You can also manually edit the OFSAAI_InstallConfig xml e Hummingbird Exceed is required to invoke XML_Utility on the remote server Layers within the OFSAAI_InstallConfig xml Optional Refer to the following instructions to edit OFSAAI_InstallConfig xml file manually Layers are divided into different Interaction Groups The Interaction Group defines the type of Interaction Variables Interaction Variables contains the Interaction Parameters required for the installation of Infrastructure Manually enter the following Interaction Variables value as defined subsequently If a value is not applicable enter NA and ensure that the value is not entered as NULL The variables are as defined in the following four Interaction Groups Click the links to view the section in detail Refer to the following table to populate the OFSAAT InstallConfig xml file e GENERAL page 2 32 e APPLICATION page 2 35 e DATABASE page 2 35
90. alue enter the new port value User has the option to change the required ports and leave the other ports unchanged Only the ports for which values are modified will change and the ports that are unchanged will retain its default value Note e All ports on a machine must be unique e The range of port numbers that are given should preferably be between 1025 and 65535 e The servlet port can have 80 or 443 as port numbers if Default http https ports are being used Select the Database Type as Oracle from the options provided in the dropdown The IP Host Address of the machine on which the corresponding database is installed will be populated The Port Number on which the database is listening is displayed The SID details are displayed The Configuration Schema username is displayed Enter the configuration schema password in the config schema password field Click the Change button to initiate the port changes Click Cancel to exit the program To execute PortC jar in CMD mode Post Installation Configuration 4 73 1 On each machine navigate to the path FIC_LHOME 2 Enter the command java jar PortC jar CMD Then enter the requested information to change the ports Once the port numbers are changed in the Infrastructure configuration a message will be displayed confirming the changes The log Portchanger log in the Infrastructure installation path provides the status of port changes performed For the earlier
91. application source will be created during installation process You can also create the application source prior to installation as documented in Appendix A Defining Application Sources page A 1 Make sure FICServer is up and running before proceeding for installation All other Oracle Financial Services Analytical Applications Infrastructure Servers must be shut down and Oracle 11g database must be running Have the following information available and handy before starting the Application Installation Information Domain name if you are using an existing infodom In case of a new infodom following details are required e Atomic schema user id e Atomic schema password e Atomic schema JDBC connection string Pre Installation Applications Activities Checklist 7 3 e Take a backup of the table rev_object_register before proceeding with installation e Rename the lt Infodom_name gt FusionMenu xml located in ficweb folder to Temp_FusionMenu xml prior to installation of Apps 7 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 8 Introduction Applications Installation e The term EPM apps mentioned in this chapter refers to Oracle Financial Services Funds Transfer Pricing Asset Liability Management Profitability Management Oracle Financial Services Asset Liability Management Analytics Hedge Management and IFRS Valuations Pricing Management Transfer Pricing
92. ariable Example PATH ORACLE_HOME bin PATH export PATH Error code OFSAAI 1038 Cause Exception while fetching path variable Resolution Make sure echo PATH is executable 11 18 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1039 Cause Exception while fetching ARBORPATH Resolution Make sure echo ARBORPATH is executable Error code OFSAAI 1040 Cause ARBORPATH environment variable not set Resolution Set ARBORPATH environment variable as ARBORPATH lt PATH gt export ARBORPATH Error code OFSAAI 1041 Cause ARBORPATH environment variable not set Resolution Set HYPERION_HOME environment variable as HYPERION_HOME lt PATH gt export HYPERION_HOME Error code OFSAAI 1042 Cause ESSBASEPATH environment variable not set Resolution Set ESSBASEPATH environment variable as ESSBASEPATH lt PATH gt export ESSBASEPATH References 11 19 Error code OFSAAI 1043 Cause DB2PATH environment variable not set Resolution Set the DB2PATH environment variable Error code OFSAAI 1044 Cause Error while fetching DB2PATH from PATH variable Resolution Make sure that the echo DB2PATH command is executable Error code OFSAAI 1045 Cause DB2PATH sqllib bin not found in PATH variable Resolution Provide DB2PATH sqllib bin in PATH variable Error code
93. astructure page 5 1 section Non SSL Port Configuration Ensure that the following connect tag under Define a non SSL HTTP 1 1 Connector on port 8080 in lt Tomcat_installation_folder gt conf server xml file is uncommented for Non SSL Configuration By default it is uncommented lt Connector port 8080 protocol HTTP 1 1 connectionTimeout 20000 redirectPort 8443 gt Note To disable connection timeouts set connectionTimeout value to 1 The port mentioned as connector port is the Web Application Server port or Servlet port in Infrastructure SSL Port Configuration Ensure that the following connect tag under Define a SSL HTTP 1 1 Connector on port 8443 in lt Tomcat_installation_folder gt conf server xml file is uncommented for SSL Configuration By default it is commented Post Installation Configuration 4 51 lt Connector port 8443 protocol HTTP 1 1 SSLEnabled true maxThreads 150 scheme https secure true clientAuth false sslProtocol TLS Note The port mentioned as connector port is the Web Application Server port or servlet port in Infrastructure For more information related to SSL Configuration on Tomcat refer http tomcat apache org Additional Configurations Refer to the following sections for detailed module specific post installation configurations Configure FTP SFTP The following FTP SFTP configurations have to be done before working on Infrastructure All
94. astructurePre Validations Log file to resolve the error Error code OFSAAI 1112 Cause Error in retrieving JAVA_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly Error code OFSAAI 1113 Cause Error in retrieving NATIVE_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly Error code OFSAAI 1114 Cause Error in retrieving AGENT_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly Error code OFSAAI 1115 Cause Error in retrieving ICC_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly Error code OFSAAI 1116 Cause Error in retrieving ICCNATIVE_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly 11 34 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1117 Cause Error in retrieving OLAP_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly Error code OFSAAI 1118 Cause Error in retrieving MSG_SERVER_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly Error code OFSAAI 1119 Cause Error in retrieving ROUTER_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly Er
95. ate machines Machine A will be used to install Product Application Layer components Machine B will be used to install Product Database Layer components and Machine C will be used to install Product Web Layer components Note e This section holds applicable if Oracle Financial Services Analytical Applications Infrastructure is installed on separate machines A B and C respectively e The setup steps outlined in the following sections for the 3 layers gives a generic overview for installation of EPM apps However for more detailed instructions regarding the installation of the specific applications see the installation manuals of the concerned application available from the OTN GUI Installation Machine A Product App Layer Procedure 1 To begin Oracle Financial Services Analytical Applications installation execute Setup sh ORACLE FINANCIAL SERVICES Copyright 1993 2012 Oracle andir ts affiliates All rights reserved 8 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 2 On invoking the installer the Introduction window will display the pre requisites for installation Ensure that the pre requisites are satisfied before you proceed Solution Setup Tris user interface will guide you Ihrough the sokBon setup Before proceeding with fhe installation you must ensure the following The Oracle Financial Services Analyical Appications infrastructure OF SA
96. ath for web layer 2 42 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Interaction Variable Parameter Parameter Variable WEB_PORT_NO Specify the value only if WEB_FTP_ENABLE is set to 1 Specify the Port Number for web layer WEB_USER_ID Specify the value only if WEB_FTP_ENABLE is set to 1 Specify the SFTP FTP User ID for web layer Pre Installation Configuration 2 43 3 Infrastructure Installation The following information helps you to install the Infrastructure Components Note The OFSAAI 7 3 installation is supported only in US English This chapter covers the following topics Installation Process GUI Mode Installation Silent Mode Installation Installation Process The following process helps you to install Infrastructure on a Single Multi tier Mode 1 Login to the Unix machine where OFSAAI Installer files are copied Provide execute permission for Setup sh OFSAAInfrastructure bin OFSAAI InstallConfig xml XML_Utility jar validateXMLInputs jar and CustReg DAT Configure OFSAAI _InstallConfig xml and Log4j xml with related information values This is mandatory for both the modes of installation GUI SILENT e Ensure that the Database component is installed first e If Post Installation Configuration is enabled OFSAAI_PostInstallConfig xml also needs to be configured Execute the profile Navigate to
97. ation 4 37 e lt cell name gt is the cell name given during profile creation e lt contextname gt is the context name given during installation WebSphere HTTPS Configuration Ensure to perform the following steps for Configuring an HTTPS Transport on WebSphere 1 Create a profile using the Profile Creation Wizard in WebSphere Note down the https port specified during this process and use the same as servlet port or web server port during OFSAAI Installation To enable https configuration on Infrastructure assign value 1 to HTTPS_ENABLE in OFSAAI _InstallConfig xml for Silent mode OFSAAI installation Configure WebLogic Create EAR WAR file for WebLogic The Enterprise ARchive EAR files is required to assemble servlets jsp files web pages and other static content into a deployable unit This EAR file creation is required to reflect the changes made to the web xml file Following are the outlined steps 1 Start WebLogic Domain by navigating to the path lt WEBLOGIC_INSTALL_DIR gt Bea user_projects domains lt DOMAIN_NAME gt bin and execute the command startWeblogic sh d64 On the machine in which Infrastructure Web components have been installed navigate to the FIC_WEB_HOME directory At the prompt enter ant sh This will trigger the creation of EAR file lt contextname gt ear Note lt contextname gt is the context name given during installation On completion of the EAR files creation
98. ation Domain a list of tables are created using the script files For more information refer following List of Tables Created in Information Domain If the tables are not created there could be a problem in connecting to the database or there may not be sufficient space in the database Ensure that there is proper space allocated Ensure that there is enough space allocated and then save the Information Domain Note On saving an Information Domain the following tables will be created in the Atomic database mapped to this information domain e bp_meas_map e cubedetails e exceptions e fsi_data_type_desc e fsi_id_type_cd e fsi_id_type_mls e fsi_message_log e fsi_mls e fsi m_lookup_b e fsi m_lookup_master e fsi m_lookup_tl e fsi m_object_definition_b e fsi m_object_definition_tl e fsi m_object_defn_comments e fsi_process_errors e rev_amhm_umm_hier_def e rev_amhm_umm_hier_execution System Configuration 6 25 e rev_amhm_umm_hier_levels e rev_app_preferences_metadata e rev_app_user_preferences e rev_bihier e rev_column_properties e rev_column_property_cd e rev_column_property_mls e rev_cube e rev_data_filter e rev_description_tables e rev_dimensions_b e rev_dimensions_tl e rev_dimension_type_code_cd e rev_dimension_type_code_mls e rev_dim_attributes_b e rev_dim_attributes_tl e rev_dim_mgmt_comments e rev_expression_details e rev_fusion_macros e rev_glbl_preferences_metadata e rev_glbl_user
99. ation and Configuration Guide Summary of Deployments Control Montereg This page Gsplays a ist of 5 redesioved or deleted 4o jes that have been installed to ths domain installed appiicatons and moduies can be started stopped updated e ond using the controls on ths page To retail a new appicaton o modue for Gepioyment to targets n ths donan d P Customize this table Deployments matet Uposie Deine Sanw Suey Serwong af requests Serwong only adewestraton requests metal Usdste Debie Siny Sisov The following window will confirm that the application has been started The State of the deployed application will be displayed as Active if started successfully Summary of Deployments Coatrel Monitoring This page Gapleys ist of EE appicators and stand alone appicaton modes that have Deen retalied to Tes doman nstalied applications anc modules can De started stopped updated ecepoyed or deleted fon the donan by frst selecting the application name and using the controls on tis page O metal anen applicator or module Sr Gepioyment to targets in tes donan cick he nstal button V Customize this table WebLogic HTTPS Configuration Ensure to perform the following steps for Configuring an HTTPS Transport o 1 Create a domain using the Domain Creation Wizard in WebLogic 2 Note down the https port specified during this process and use the same as servlet port or web server port during OFSAAI
100. ation is enabled the client browser will need to disable the proxy servers through the client browser s internet options The OFSAAI login window is displayed Start Stop Infrastructure Services 5 3 OFSAA Infrastructure Login Screen Windows Internet Explorer Financial Services Analytical Applications Infrastructure ORACLE Language US English User ID Password There are two in built system administration users provided by the system e SYSADMN Login with the password that was provided during installation e SYSAUTH Login with the password that was provided during installation You can login to the system using the SYSADMN User ID Note that there is no T in the SYSADMN login USER ID Enter the password that was provided during installation On the first login you will be prompted to change the password Once you have logged into the Infrastructure system you need to perform the following additional configurations to setup the OFSAAI environment e Define Server Details for Database Application and Web servers For information see Server Details page 6 1 section e Add Database Details For information see Database Details page 6 13 section e Create an Information Domain For information see Information Domain page 6 22 section e Create a Segment For information see OFSAAI 7 3 User Manual Administration gt 5 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI
101. ation servers where you want to install the modules that are contained in your application Modules can be installed on the same application server or dispersed among several application servers Also specify the Web servers as targets that serve as routers for requests to this application The plug in configuration file plugin cfg xml for each Web server is generated based on the applications that are routed through Clusters and servers WebSphere cell ipa024dorNode05Cell node ipa24dorNode05 server server1 Apply beancache jar rem WebSphere cell ipa024dorNode0SCell node ipa24dorNode0S server serverl OFSAAI Web aixpr2 war WEB WebSphere cell ips024dorNiode05Cell node ips24dorliode0S server servert Application INF wab xml 9 The Map resource references to resources window is displayed Map each resource defined in your application to a resource JNDI name defined earlier Install New Appx ation Specify options for installing enterprise applications and modules Sex Multiple INDI Names Modify Resource Authentication Methec ofsa73 war WEB INF web xml 10 After mapping the resource reference click Modify Resource Authentication Method Specify the authentication method created earlier You can specify config for FICMASTER resource or atomic for atomic resource as the authentication method Post Installation Configuration 4 33 Install New Application Spe
102. ations Installation 8 5 w SolutionSetup Intro ucton Do you wat to create a new information domain dnfodomi or use Pra nstall Configuration an existing one istallation Summary New Infocom falling O Bxtsting Infodom ORACLE FINANCIAL SERVICES E Paealdak sr E 7 4 If the option New Infodom is selected the following panel will be displayed which will seek the following details to create an infodom Specify a DB name for the new infodom Please make a TNS entry with the DB name specified in the tnsname ora file in the Oracle server Enter the newly created atomic schema user name password and jdbc url in the relevant fields lt Solution Setup Please enter Pe Sotlowing to create a mew informadon domain DE Name for infodom Database NEWDB TESTSCHEMA Application Schema JDBC URL jibe oracle thin dt 184 74 54 1527 REVELEUS Click Next to continue e Inthe following window 8 6 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Specify the name and description for the new infodom to be created Specify a segment name to be created Note Segment name should not exceed 10 Characters In addition specify the Application server and database server log path for infodom maintenance to be created Solution Setup Please enter the following to create a new infoematon domain Click Next to continue In the f
103. atory if this an Database Schema App Layer Installation for new Infodom is a RAC database and if you want to create anew infodom 8 28 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Property Name Description of Property Permissible values Comments INFODOM_DESC APPFTP_LOG_PAT H DBFTP_LOG_PATH OBI_HOST OBI_PORT description for the Database Schema for new Infodom Infodom Maintenance log path to be created for the new Infodom for applayer Infodom Maintenance log path to be created for the new Infodom for DBLayer Host Name of the OBIEE Server Port Number of the OBIEE Server Not Applicable Not Applicable Not Applicable Not Applicable Not Applicable Applications Installation That is you have specified INSTALL_APP 1 and INFODOM_TYPE 0 Mandatory if this an App Layer Installation and if you want to create anew infodom That is you have specified INSTALL_APP 1 and INFODOM_TYPE 0 Mandatory if this an App Layer Installation and if you want to create anew infodom That is you have specified INSTALL_APP 1 and INFODOM_TYPE 0 Mandatory if this an App Layer Installation and if you want to create anew infodom That is you have specified INSTALL_APP 1 and INFODOM_TYPE 0 Applicable if INSTALL_ADMIN_BI 1 Applicable if INSTALL_ADMIN_BI 1 8 29 Property Nam
104. base components on a separate machine and collapse the Infrastructure application and web layers along with the servlet engine onto a separate machine This particular architecture would be as follows e Infrastructure database components are installed on Machine A e Infrastructure application and web components are installed on Machine B e Web server is installed on Machine B The following diagram illustrates the possible combinations in a Multi Tier Installation Option III 2 6 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Machine A Machine B ody Web server Database Application and components web components Multi Tier Installation Option IV You can also choose to host the Infrastructure Application components on a separate machine and collapse the Infrastructure database and web components along with the servlet engine on a separate machine This particular architecture would be as follows e Infrastructure database and web components are installed on Machine A e Infrastructure application components are installed on Machine B e Web server is installed on Machine A The following diagram illustrates the possible combinations in a Multi Tier Installation Option IV Machine A Machine B Web server Database and Application Web components components Pre Installation Activities Checklist Before starting on the OFSAAI Installation Kit ensure tha
105. ble Parameter MSGPORT 6501 ROUTERPORT 6500 AMPORT 6505 WEB Interaction Variable Parameter Parameter Variable WEB_SERVICES PROXYHOST PROXYPORT PROXYUSERNAME PROXYPASSWORD NONPROXYHOST STORE_AS If OFSAAI Web Services is required specify the value as 1 Else enter 0 It is client specific and refers to the host computer name on which the proxy server is running A proxy can be used to establish communication between OFSAAI Web Application and the Application Server Client along the web server gateway if present It is client specific and refers to the port of the proxy server if enabled It is client specific and refers to the authentication name of the proxy server if enabled It is client specific and refers to the authentication password of the proxy server if enabled It is client specific and refers to the host computer name which should be directly connected if enabled which can bypass the proxy server Refers to the Content Store Area for document storage in OFSAAI You need to manually specify the path of the machine where OFSAAI will be deployed and the installer configures updates these paths in configuration files Enter the folder name You can specify DocStorage for convenience or any name other than ftpshare since the parent directory already has ftpshare folder in the path export home OFSAAI ftpshare Pre Installation Configuration 2 37 Int
106. ble to take all appropriate fail safe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Contents Send Us Your Comments Preface 1 About this Manual Introduction aaia aai aaa a ea Eaa aeae EAA AREETA EER EEA EEE EEE 1 1 SCOPC EP E O E A T T E 1 1 What s changed in OQOFSAAL7 3 cicih arie etp eita cateta adai e aaora eea k eenaa aaa at tEn 1 2 Organization of the Manual syiciieriiinbisidepetein keedan he repa etatai adiasa iai hiriak 1 4 2 Pre Installation Configuration Guidelines to Unzip Infrastructure Installer 0 nesnennneneeiieenssinennsinstnssnnrinnrnsenssnnrensresennne 2 1 Environment atid Softwares ssaa a a a a aa a aa aa ekaan aaki 2 2 Software EnVIrOnmENt silasa a ea a a a aa aA a aeae a EEEE S 2 3 Control Panel SettitgSast ihia niee aea aa aaa eaa aae a aE a ae aat 2 3 Infrastr
107. bsolute path where the Java executable files reside Example Path for a 32 bit installation is JAVA_BIN gt usr jdk instances jdk1 6 0 bin Pre Installation Configuration 2 33 Interaction Variable Parameter Variable Parameter Ensure that the Absolute Java Path for 64 bit Solaris installation is kds sparc sun solaris10 pkg jdk1 6 0_26 bin sparcv9 APPSERVER Specify the hostname or IP address of the server where the OFSAAI Application Layer is being installed For example 10 184 74 110 WEBSERVER Specify the hostname or IP address of server where the OFSAAI Web layer is being installed For example 10 184 74 110 Note If you are installing the Web layer on one server and intend to deploy the OFSAAI web application EAR on another server you always need to specify the hostname of the server on which you are installing the Web Layer and not the hostname of the server on which you are deploying the web application EAR This may also need a manual hostname update at a later point For more information refer IP Host Address Related Changes page 4 60 section DBCOMP_IP Specify the hostname or IP address of the machine where OFSAAI Database Layer is being installed For example 10 184 74 110 DBSERVER Specify the hostname or IP address of the machine where Database Server is installed For example 10 184 74 61 SMTPSERVER Specify the hostname or IP address of the machine on which SMTP optional service is running RAC STA
108. ce tag details in Server xml file from the CATALINA_HOME conf folder In case of Tomcat only Atomic lt Resource gt will exist If using WebSphere as Web server Login to the WebSphere Administration Console from the left side menu navigate to Resources gt JDBC gt Data Sources A list of data sources will be populated on the right side Select the appropriate Data Source and edit the connection details In this case both Config and Atomic data sources will need to be modified If using WebLogic as Web server Login to the WebLogic Administration Console from the left side menu under Domain Structure list box expand the appropriate Domain and navigate to Services gt JDBC gt Data Sources A list of data sources will be populated on the right side Select the appropriate Data Source and edit the connection details In this case both Config and Atomic data sources will need to be modified Restart the OFSAAI services 6 30 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide l Pre Installation Applications Activities Checklist Pre Installation Applications Activities Checklist e The term EPM apps mentioned in this chapter refers to Oracle Financial Services Funds Transfer Pricing Asset Liability Management Profitability Management Asset Liability Management Analytics Hedge Management and IFRS Valuations Pricing Management Transfer Pricing component
109. ceTablePage X Bx coove P Bl Most visited Getting Started Latest Headlines Customize Links EE B Summary of JDBC Data Sources Mo EE ORACLE WebLogic Server Administration Console Change Center Home Log Out Preferences Record Help a Welcome manager Connected to MockSol ica hereon estate Home Summary of JDBC Data Sources Configuration editing is enabled Future Summary of JDBC Data Sources changes will automatically be activated as you modify add or delete items in this domain A JDBC data source is an object bound to the JNDI tree that provides database connectivity through a pool of JDBC connections Applications can look up a data source on the JNDI tree and then Domain Structure borrow a database connection from a data source MockSol a This page summarizes the JDBC data source objects that have been created in this domain Environment Deployments E Services D Customize this table Messaging JDBC Data Sources Mukti Data Sources New _ Delete Data Source Factories Persistent Stores H name amp JNDI Name Targets Foreign JNDI Providers M ssaTom Data Sources Filtered More Columns Exist Showing 1 to 1 of 1 Previous Next jdbc DEMOINF AdminServer Work Contexts XML Registries New Delete Showing 1 to 1of1 Previous Next XML Entity Caches x How do L a e Create JDBC data sources Delete JDBC data source
110. chema schema from lt Infrastructure Installation Directory gt ficapp common FICServer conf LDAP_LDIF folder to LDAPServer Schema folder 2 Copy the Domains dif and Reveleus dif files from lt Infrastructure Installation Directory gt ficapp common FICServer conf LDAP_LDIF folder to OpenLDAPServer folder Note Make sure that the ROOTCONTEXT in the Domains dif and Reveleus ldif files are the same as slapd conf file 3 Provide the appropriate entries for rootdn rootpass and rootcontext in slapd conf file in the OpenLDAPServer folder Post Installation Configuration 4 77 4 Add the following text as the first line of the slapd conf file include schema reveleusSchema schema Note The earlier steps of the configuration are for OpenLDAP Server only If you need to configure Infrastructure for any other LDAP Server you will have to make the changes appropriately 5 In the command prompt navigate to the LDAP installation directory and execute the following command Idapadd D ROOTDN w ROOTPASS f data Reveleus ldif This is for creating the entries for Users User Groups Functions Profiles Segments Domains Roles and HolidayMaster in the Data information Tree of LDAP 6 Make an entry in the Domains dif file for each Information Domain that is created through the Infrastructure UI To add an entry corresponding to the new information domain to the Domains ldif file add the following block of text with the appropriate
111. cify ARGTYPE as xmlstring CLASSNAME Represents class name of input object parameter Attributes for OUTPUT tag PARAMNAME Output parameter name to be returned by the web service RETURNTYPE Output parameter Data Type If the web service response is a complex object then specify RETURNTYPE as object CLASSNAME Represents class name of output object parameter web xml Entries Navigate to lt OFSAAI Installation Directory gt EXEWebService lt WebServer gt ROOT WEB INF and edit the web xml file as explained below Entry for WSConfig File The WSCONFIG file DynamicWSConfig xml is available in the lt WebServer Deployment Path gt EXEWebService ear EXEWebService war conf directory This file can be placed in any directory that is accessible by the application The path where the WSCONFIG file is placed must be specified in place of WSCONFIGFILELOCATIONS in the below block of text in web xml 4 82 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide lt context param gt lt description gt WebServices Configuration File lt description gt lt param name gt WSCONFIGFILE lt param name gt lt param value gt SWSCONFIGFILELOCATIONS lt param value gt lt Specify the Location of DynamicWSConFig xml gt lt context param gt Proxy Settings In the following block of text in web xml file replace the lt param value gt given in bold below with approp
112. cify options for installing enterprise applications and modules ofsa73 war WEB febe RHELATOMST INF web xml POCRMBATONST EOSS 11 Each resource reference that is defined in your application must be mapped to a resource javax sql DataSource Was Reve Authentication eed ofsa73 war WEB fiebe RHELATOMST Loa Brova 12 Map Virtual hosts for Web Modules window is displayed Select the Web Application check box and Click Next 4 34 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Install New Application Specify options for installing enterprise applications and modules Step 1 Select installation options m Map St modules to servers Map ource references to resources Step 5 Summary Specify the virtual host where you went to install the Web modules that are contained in your application You can install Web modules on the same virtual host or disperse them among several hosts Apply Multiple Mappings eo OFSAAI Web Application 13 The Summary page is displayed Go through the page and click Finish Post Installation Configuration 4 35 Install New Application iB Specify options for installing enterprise applications and modules Summary of installation options Options Values Precompile JavaServer Pages files No Directory to install application rces
113. code OFSAAI 1185 Cause Resolution Invalid configuration schema password Provide correct Oracle Configuration schema password Error code OFSAAI 1186 Cause Resolution Invalid configuration in OFSAAI_ PostInstallConfig xml file APP_DRIVE_TM value cannot be NULL or NA Error code OFSAAI 1187 Cause Resolution Invalid configuration in OFSAAI_ PostInstallConfig xml file APP_PORT_NO_TM value cannot be NULL or NA Error code OFSAAI 1188 Cause Resolution Invalid configuration in OFSAAI_ PostInstallConfig xml file APP_USER_ID_TM value cannot be NULL or NA References 11 49 Error code OFSAAI 1189 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution APP_DRIVE_BM value cannot be NULL or NA Error code OFSAAI 1190 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution APP_PORT_NO _BM value cannot be NULL or NA Error code OFSAAI 1191 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution APP_USER_ID_BM value cannot be NULL or NA Error code OFSAAI 1192 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution APP_DRIVE_SA value cannot be NULL or NA Error code OFSAAI 1193 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution APP_PORT_NO_SA value cannot be NULL or NA 11 50 Oracle Financial Services Ana
114. code OFSAAI 1211 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution WEB_DRIVE value cannot be NULL or NA if WEB_FTP_ENABLE value is 1 Error code OFSAAI 1212 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution WEB_PORT_NO value cannot be NULL or NA if WEB_FTP_ENABLE value is 1 Error code OFSAAI 1213 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution WEB_USER_ID value cannot be NULL or NA if WEB_FTP_ENABLE value is 1 Error code OFSAAI 1214 Cause Invalid password for default user SYSADMN Resolution Provide alphanumeric password of at least six characters Error code OFSAAI 1215 Cause Invalid password for default user SYSAUTH 11 54 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Resolution Provide alphanumeric password of at least six characters Error code OFSAAI 1216 Cause Resolution Invalid locale selection Choose the serial number for the specific locale Error code OFSAAI 1217 Cause Resolution JAVA Bin Path is not properly configured Ensure that the JAVA path specified in your environment is same as the JAVA_BIN path specified in OFSAAI_InstallConfig xml To know the specified Java Path in your environment use the command which java From the output you can ignore java and ensure that the r
115. command line is as follows manageprofiles sh creat profileName lt profile gt profilePath lt profile path gt templatePath lt template path gt nodeName lt node_name gt cellName lt cell_ name gt hostName lt host name gt Example Susr home gt manageprofiles sh create profileName mockaix profilePath websphere webs64 Appserver profiles mockaix templatePath websphere webs64 Appserver profileTemplates default nodeName ipa020dorNode04 cellName ipa020dorNode04Cell hostName ipa020dor The command to create a profile with admin security through command line is as follows manageprofiles sh creat profileName lt profile gt profilePath lt profile path gt templatePath lt template path gt nodeName lt node_name gt cellName lt cell_name gt hostName lt host_name gt enableAdminSecurity true adminUserName lt Admin User Name gt adminPassword lt Admin User Password gt samplespassword lt sample User Password gt Example Susr home gt manageprofiles sh create profileName mockaix profilePath websphere webs64 Appserver profiles mockaix templatePath websphere webs64 Appserver profileTemplates default nodeName ipa020dorNode04 cellName ipaO20dorNode04Cell hostName ipaO20dor enableAdminSecurity true adminUserName ofsaai adminPassword ofsaai samplespassword ofsaai Pre Installation Configuration 2 19 Note While using the manageprofiles sh command to create a N
116. configure the FTP SFTP server details through the OFSAAI User Interface DATABASE Pre Installation Configuration 2 35 Interaction Variable Parameter Variable Parameter CONTEXT_PATH Enter the Application Name by which the Infrastructure Web application EAR WAR files are created This serves as an identifier to access the application after deploying the same in the configured web servers Context Name can be of alpha or alphanumeric combinations like abcd abcd123 For example https lt IP ADDRESS gt lt SERVLET PORT gt Context Name login jsp HTTPS_ENABLE This parameter variable facilitates you to access OFSAAT Application through HTTP HTTPS communication protocol For HTTPS communication between end users and OFSAAI web application set this parameter to 1 For HTTP communication set this parameter to 0 Specify the following Infrastructure Communicating ports Ensure that the Port Numbers should range from 1025 to 65535 If Default http https ports are being used the Servlet port can have 80 or 443 as port numbers If you use a port number that is different from the default value you must update the SERVLETPORT tag JAVAPORT 9999 NATIVEPORT 6666 AGENTPORT 6510 ICCPORT 6507 ICCNATIVEPORT 6509 OLAPPORT 10101 SERVLETPORT 9080 2 36 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Interaction Variable Parameter Varia
117. d INSTALL_APP 1 0 If you want to create anew ETL app src pair 1 If you want to use an existing pair ETL_APP_DESC Please give Not Applicable Mandatory if you description for the want to create new ETL ETL App app src pair That is you have specified ETL_APPSRC_TYPE 0 ETL_SRC_DESC Please give Not Applicable Mandatory if you description for the want to create new ETL ETL Src app src pair That is you have specified ETL_APPSRC_TYPE 0 How to install in Silent Mode 1 The installer folder contains a template file Silent template Create a copy of this file and rename the copy as Silent props 2 Edit the file Silent props and specify the parameters as per the requirements 3 Ensure FIC Server is running and all other OFSAAI servers are shutdown prior to the start of Solution installation 4 On the UNIX Command prompt execute the following command Applications Installation 8 31 e Setup sh SILENT 5 Refer to the console log or the file preinstall log for any error messages How to install a Customized Data Model To support the model upload for customized data model perform the following steps e Rename the customized data model file as lt APP_ID gt _ Datamodel xml Here APP_ ID stands for ALM FTP PFT HM PRMGR Example FTP_Datamodel xml e Take a back up of the released data model xml file that is packaged with the installer e Copy the customized data model into the DataModel directory of
118. d entry and does not get cleared blank automatically Organization of the Manual The Installation Manual is organized into the following chapters Pre Installation Configuration section consists of the pre configuration activities that are to be completed successfully for proper installation and functioning of the Infrastructure Application The Pre Installation activities include the Patch Unzip Process Environment setup Infrastructure Installation options Pre Installation Activities Checklist WebServer Configurations and Populating Installation Configuration xml file Infrastructure Installation section details the steps to be followed during the Infrastructure installation You can click the Help button in the Installation screens for instructions Post Installation configuration section details the list of activities to be performed after installing Infrastructure application The Post Installation activities include configuring Resource References in Infrastructure Application WebSphere WebLogic and Tomcat Creating and deploying EAR WAR file in respective Web Application Servers There is an Additional Configuration section with information related to module specific configurations Start Stop Infrastructure Services details the sequence and the process of starting this application 1 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide System Configuration prov
119. d in OFSAAI _InstallConfig xml file Enter any valid Servlet port as Default HTTP port 80 Default HTTPS port 443 or any valid port between 1024 and 65535 References 11 21 Error code OFSAAI 1053 Cause Invalid port entered in OFSAAI InstallConfig xml file Resolution Enter Port values between 1024 and 65535 Error code OFSAAI 1054 Cause Invalid port entered in OFSAAI InstallConfig xml file Resolution Enter only Numeric Port values Error code OFSAAI 1055 Cause Invalid port entered in OFSAAI InstallConfig xml file Resolution Enter Port values between 0 and 65535 Error code OFSAAI 1056 Cause All Port values are not unique Resolution Enter unique value for all the ports Error code OFSAAI 1057 Cause Cannot Bind to Port mentioned in OFSAAT InstallConfig xml Resolution Provide an alternate port number 11 22 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1058 Cause Execution of ORACLE query failed Resolution Check the exception message to resolve the issue Error code OFSAAI 1059 Cause Database layer is already Installed with the current user Resolution Ensure that the configuration schema mentioned in OFSAAI InstallConfig xml is completely cleaned Error code OFSAAI 1060 Cause Execution of Insertion into TEMP table for the Ports failed Re
120. d report on specific performance risk compliance and customer insight issues What is the purpose of OFSAA Infrastructure Oracle Financial Services analytical applications infrastructure helps control data quality and provides a consistent approach across applications for assigning business assumptions and accessing shared data for computations underlying Oracle s Financial Services analytical applications Infrastructure is comprised of a set of frameworks that operates on and with the Oracle Financial Services Analytical Applications Data Model This infrastructure delivers unified metadata across the stack and provides a single set of computational engines stochastic modeling methods and business rules to feed overlapping but independent analytical business functions such as profitability economic capital FTP and regulatory capital Pre integrated and extensible with common objects and dimensions this infrastructure powers business user analyses with performance that scales to meet the demands of the world s largest institutions References 11 1 OFSAAI Installation FAQs Where can I get more information on OFSAA Infrastructure More information is available on the Oracle website at the following location http www oracle com us industries financial services 046939 html What are the different components that get installed during OFSAA Infrastructure OFSAA Infrastructure installation processes are categorized into three laye
121. display name for the resource Description The optional description for the resource Post Installation Configuration 4 3 Create a new JDEC Provider Create a new JOBC Provider Set the basic configuration values of a JOBC provider which encapsulates the specific vendor JOBC driver implementation classes that are required to access the database wizard fills in the name and the description fields but you can type different values cells GXS2 SOREV iZone2NodeOSCell nodes GXS1SOREV Zone2NodeOS servers serveri Database type Oracle Provider type Oracle JDEC Driver x Implementation type y Connection pool data source Name Oracle JO8C Driver Description Oracle JDBC Driver 5 Specify the directory location for ojdbc 6 jar file Do not use trailing slash file separators Click Next 4 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Create a new JDBC Provider Create a new JOBC Provider Step 1 Create new JOBC provider Set the environment variables that represent the JDEC driver class files which WebSphere R Application Server uses to define your JDBC provider This wizard page displays the file names you supply only the directory locations of the files Use complete directory paths when you type the JDBC driver file locations For example C SQLLIB java on Windora R
122. dows Internet Explorer ORACLE Connectedto aTom7z3st M Home amp Unified Metadata Manager EY Rules Framework qf Forms Framework Type BA Operations Name BS System Configuration E Server Details Database Server Application Server Web Server IP Address User Id Password Database Details JDBC Connection String OLAP Details Date Format Information Domain Block Size Configuration Segment Metadata Mapping Segment Map Security Hierarchy Security Design OFSAAI Menu Rules Setup Configuration a Administration EA Advanced Analytics Infrastructure amp AMHM UMM Offline Population Financial Services Applications Locale Identifier JDBC Driver Name He Financial Services Analytical Applications Infrastructure User stuser Database Master Database Details for DB Server 10 184 134 147 ORACLE RHELATOMST en_US rhelatomst oracle jdbc driver OracleDriver idbc oracle thin DESCRIPTION A mm dd yyyy NaN E Ea msl Gace To add database details for DB server 1 Select Add button from the Database Master window The window is refreshed and enables you to populate the required data in the fields 2 Enter the Database Server details as tabulated Field Description IP Address Select the Database IP Address from the drop down list This list displays the database server IP address defined during the set up Type By default ORACLE Database Type is selected
123. e implementation dass name 7 The options to Save and Review are displayed Click Save Create the Data Source The following steps are applicable for both config and atomic data source creation 1 Open the following URL in the browser window http lt ipaddress gt lt administrative console port gt ibm console https if SSL is enabled The login window is displayed Login with the user id that has admin rights 2 Expand the Resources option in the left menu Click JDBC gt Data sources option The Data sources page is displayed 4 6 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Wetegeaied Sodong Conmcle Wekeme meck i Male Logat Wem A tasts S Saee pon welcome oe e E D etet Acovmer Parapen Pip For baid heip i B torrons Une this page te odt the settingi of deterouwue thet is sisodeted wth pour velectied JORC provider The dotesowrce objet solod a hath sveptes you epptceten wth commectons tor ecoersing the Getebere Lown more about thes tort in o negad ifa A moter whent B appie sess peted etts oorder o bit of tesh repi and mare genera ifermaten wheut the topt cover u dapa Seren ee Coheed there SIC 5s denpa thereat Lore cemrwer i a B tope Cotmpe Pega heip Gaerewces Senge apection the level at which the sarace definition ix mobie For detated pd Seide rhormaten on whet roope is and how R works iaa the somos settee Dale CAject pes me
124. e OFSAAI 1167 Cause Failed while searching for log Resolution Error while searching for DEBUG WARNING ERROR and INFO messages in the log file configured in Log4j xml Check the error message in log Error code OFSAAI 1168 Cause Error while updating defipath in configuration table Resolution Execute following statement UPDATE CONFIGURATION SET PARAMVALUE DEFIPATH WHERE PARAMNAME DEFIHOME WEBSPHEREDEFIPATH IS WEBSPHERE_INSTALLPATH K CONTEXTPATH gt EAR lt CONTEXTPATH gt WAR DEFI WEBLOGIC DEFI PATH WEBLOGIC _DOMAIN_HOME gt APPLICATIONS lt CONTEXTPATH gt EAR lt CONTEXTPATH gt WAR DEFI TOMCAT lt TOMCATPATH_WEBAPPS gt CONTEXTPATH DEFI OAS lt DEPLOY_OAS_HOME gt lt CONTEXTPATH gt lt CONTEXTPATH gt DEFI References 11 45 Error code OFSAAI 1169 Cause Failed to update web xml file Resolution Tomcat Add following after FIC_PHYSICAL_HOME and FIC_HOME lt param value gt lt TOMCAT_WEBAPPS gt lt CONTEXT_PATH gt lt param value gt WebSphere lt param value gt lt serverPath gt lt contextPath gt ear lt contextPath gt war lt param value gt WebLogic lt param value gt lt serverPath gt applications lt contextPath gt ear lt contextPath gt war lt param value gt OAS lt param value gt lt serverPath gt lt contextPath gt lt contextPath gt lt param value gt Error code OFSAAI 1170 Cause Error while creat
125. e profile Example CATALINA_HOME home appuser apache tomcat 6 0 29 export CATALINA_HOME References 11 15 Error code OFSAAI 1024 Cause User does not have permission to write in CATALINA_HOME lib Resolution Make sure user has permission to write into CATALINA_HOME lib directory Use chmod command to give write permission Error code OFSAAI 1025 Cause IBM XL V9 runtime compiler did not match Resolution Make sure IBM XL runtime compiler is version 9 Use Islpp 1 grep vacpp cmp rte awk print 2 command to check the runtime compiler version Error code OFSAAI 1026 Cause Exception while checking IBM XL V9 runtime compiler Resolution Make sure the Islpp 1 grep vacpp cmp rte awk print 2 command is executable Error code OFSAAI 1027 Cause Inadequate permission to the user Resolution Least required user permission is 755 Use umask 022 command to provide the permission Error code OFSAAI 1028 Cause Exception while fetching user permission Resolution Ensure that umask command is getting executed 11 16 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1031 Cause Resolution Timeout value in the soap client props file of Web Sphere profile is not 0 Set timeout value to zero in the soap client props file of Web Sphere profile Check InfrastructurePreValidati
126. e Applications window is displayed integrated Setutiees Cormcte Wekeme Mem All tacks g H oedet Acree an pours B toren Ure ther page te merege miteted epp reheni a magie seppien sor be deployed orts maiipie servers E wypis stans B Pretence wA mun owp inenet unnn Updern Moie Unde Remove tie Con Capen Oe Expert hte Baga E sopie even Troer oe ona M MM bond HWedtiphers ou aiea S Mare nferrnamen abs ediphere stapje opdi o aor Fors basmass tove sopin os neers Seien nome apphistan statua Cp Cormenand Ansista Ner atnrut aten ar jait Uia heuren etmene the teiseng rossunios sumtna eames Sor lart what Rat anteeminatnn B terranes B teroes uiian hd B breneneu gD mu F teren odma ey otea r B Users sad Greens Tetai Berner g ont Tonnes Phi Try H sermo arog otea B wo This Enterprise Applications screen helps you to e Install new application e Uninstall existing applications e Start or Stop the installed applications Pre Installation Configuration 2 21 Deletion of WebSphere Profiles To delete a WebSphere profile do the following 1 Select the checkbox adjacent to the required application and click Stop Stop the WebSphere profile to be deleted Navigate to the lt WebSphere_Installation_Directory gt AppServer bin directory Execute the command manageprofiles sh delete profileName lt profile_name gt Delete the profile folder for example lt WebSphere_Ins
127. e Description of Permissible values Comments Property OBI_CONTEXT Context Name of Not Applicable Applicable if UPLOAD_MODEL MODEL_TYPE DATAMODEL DM_DIRECTORY ETL_APP_NAME ETL_SRC_NAME the OBIEE Server whether you want 0 No to perform Model Upload 1 yes released data model 0 released or customized data model 1 customized the path for the Not Applicable customized data model the file name for the Not Applicable customized data model The ETL application Not Applicable name The ETL Source into Not Applicable which the Table 2 Table ETL definitions on staging tables will be deployed INSTALL_ADMIN_BI 1 Mandatory if INSTALL_APP 1 Mandatory if INSTALL_APP 1 Mandatory only if you want to upload the customized data model That is you have specified MODEL_TYPE 1 Mandatory only if you want to upload the customized data model That is you have specified MODEL_TYPE 1 Mandatory if this an App Layer installation That is you have specified INSTALL_APP 1 This Source must be mapped to the above ETL Application 8 30 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Property Name Description of Permissible values Comments Property ETL_APPSRC_TYPE create new ETL 0 New Mandatory if this an App Src pair or use App Layer installation an existing one 1 Existing That is you have specifie
128. e Packs One off patches navigate to the following path depending on the WebServer configured and clear the cache Post Installation Configuration 4 85 e Tomcat lt Tomcat installation folder gt work Catalina localhost lt Application name gt org apache jsp e WebLogic lt Weblogic installation location gt domains lt Domain name gt servers lt Server name gt tmp _WL_user lt Application name gt qaelce jsp_servlet e WebSphere lt Websphere installation directory gt AppServer profiles lt Profile name gt temp lt Node name gt gt server1 lt Application name gt lt war file name gt Dimension Configuration Alphanumeric and Numeric Codes OFSAAI supports both numeric and alphanumeric dimensions Both dimension types require a numeric member code An alphanumeric dimension will additionally store an alphanumeric member code A numeric dimension can optionally store an alphanumeric code as well but it will be equivalent to the numeric code value After the OFSAAI installation you may need to run SQL updates on the REV_DIMENSIONS _B table This table stores the required dimension metadata including dimension member data type and the member column names for dimension member tables where the numeric and alphanumeric codes are stored Specifically in REV_DIMENSIONS_B e The column MEMBER_DATA_TYPE_CODE with value NUMBER identifies a dimension as numeric and value VARCHAR2 identifies a dimension as alphanumeric e MEM
129. e WEB page 2 37 GENERAL Interaction Variable Parameter Variable Parameter LICENSEKEY Specify the license key provided to you If not contact Oracle support 2 32 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Interaction Variable Parameter Parameter Variable Customer Code Installation Mode Choose Component s USER_INSTALL_DIR WEBSERVERTYPE Absolute Java Path Specify the Customer Code provided to you E delivery downloads can use EDELIVERY as the Customer Code and for physical shipments via media it is customer specific and you need to contact Oracle support Specify the Installation Mode as indicated For Single Tier enter 1 For Multi Tier enter 2 Select the Infrastructure component s that you want to install on the current machine For Single Tier installation specify the value as 1 for all the installed components namely ISAPPSERVER ISDBSERVER and ISWEBSERVER else enter 0 For Multi Tier installation specify the value as 1 for the component being installed and enter 0 for other components Enter a valid absolute path where all Infrastructure components Web Application and Database Components are required to be installed Example USER_INSTALL_DIR gt oradata6 revwb7 Oracle lt InteractionVaria ble gt Specify the Servlet engine as indicated Tomcat 1 WebSphere 2 WebLogic 3 Enter the a
130. e development O Production Mode Require the entry of a username and password and do not poll for applications to deploy O Other JDK WebLogic JRockit JDK recommended for better runtime performance and management Location Exit Help Previous Next The Select Optional Configuration window is displayed Select Administration Server A WebLogic Server domain must have an Administration Server You can also select Manages Servers Clusters and Machines and RDBMS Security Store if required Click Next to continue Pre Installation Configuration 2 27 F Fusion Middleware Configuration Wizard x Select Optional Configuration ORACLE Administration Server Modify Settings C Managed Servers Clusters and Machines Add or Delete Modify Settings CO RDBMS Security Store Modify Settings Exit Help Previous Next 8 The Configure the Administration Server window is displayed Enter the details of the Administration Server such as the Name Listen address Listen Port and SSL listen port in the relevant fields For secure login using https select SSL enabled check box Click Next 2 28 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 9 F Fusion Middleware Configuration Wizard Configure the Administration Server ORACLE Discard Changes
131. e installation has execute permissions e If error resembles Graphical installers are not supported by the VM The console mode will be used instead then check whether any of the X windows software has been installed eg Hummingbird Exceed is started and configured to Graphical mode installation Note Type xclock from prompt and this should display clock in graphical mode e If error resembles No Java virtual machine could be found from your PATH environment variable You must install a VM prior to running this program then check whether java path is set in PATH variable For details on setting the environment variables refer to the OFSAA Infrastructure Installation guide under section pre requisites e Check whether sufficient temporary space is available e Ensure the movement of OFSAA Infrastructure Installer text files to the target system is done in the Text mode so that Setup sh file does not contain control line feed characters M During installation if error message shows OracleDriver Files Not Found Please Choose The Right Path To Continue Check whether the provided path for Oracle Driver files is correct and whether the user has permissions to access the files During installation if error always resembles User must have CREATE TABLE CREATE VIEW CREATE TRIGGER CREATE INDEX CREATE SEQUENCE CREATE PROCEDURE though the oracle schema user created has the mentioned privileges OFSAA Infrastructure instal
132. e location of log files Click Next The Installation Complete window is displayed Infrastructure Installation 3 11 g OFSAAInfrastructure felis Installation Complete License Congratulations Oracle Financial Services Analytical Applications Preinstall Setup infrastructure has been succesfully installed Installation Install Complete Click on Done to exit the installer ORACLE FINANCIAL SERVICES InstallAnyehere 9 Click Done in the Installation Complete window to exit the installer Note In GUI mode of installation the known_host file does not get updated automatically You need to manually create an entry by executing the command sftp lt Unix Username gt lt ip address gt and entering the corresponding password for the specified Unix User name Silent Mode Installation When you have executed the command Setup sh SILENT in the command prompt enter the following parameters 1 License Agreement To accept the License Agreement input Y 2 Infrastructure Config Database Password Enter the configuration schema password 3 Locale for installation Enter the option as indicated on screen The order of Locales displayed will differ depending on OS Ensure to select the appropriate option 4 Default Infrastructure Administrator Password Enter the password for SYSADMIN user and SYSAUTH user You will need to re enter the passwords 3 12 Oracle Financial Services Analytical Applica
133. ecified during setup the same is auto populated and cannot be modified If not select the IP address by clicking on the drop down list The socket server port is auto populated from dynamicservices xml file in the ficserver configuration path and should not be edited By default the port number is 10101 The OS type Operating System of the database is auto detected by the Infrastructure Application and cannot be edited The system supports only similar OS types in a single implementation and does not support UNIX with NT combination FTP refers to the transfer of files such as metadata and staging files from one server to another SFTP refers to secure FTP for transfer of files from one server to another Note the following 1 The FTP SFTP option specified during setup is auto populated and is not editable 2 The FTP SFTP information should be created manually prior to entering the details The application validates the information ensuring that the value in FTP SFTP and Host DB is not blank 3 When there is a change to the FTP SFTP path the old files should be physically moved to the new path The system ensures that all new files are generated transferred into the new path 3 The FTP Details consists of e Technical Metadata tab which consists of the path to ERWin file which in turn 6 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide
134. ect web component ftp details Error code OFSAAI 1178 Cause Invalid WEBLOGIC_DOMAIN_HOME path References 11 47 Resolution Provide valid path for WEBLOGIC_DOMAIN_HOME tag in OFSAA _InstallConfig xml file Error code OFSAAI 1179 Cause OFSAAI PostInstallConfig xml is not valid Resolution Check the InfrastructurePreValidations Log for the exception message Error code OFSAAI 1180 Cause Invalid path for Application layer Technical Metadata ftp drive path Resolution Provide a valid path for Application layer Technical Metadata ftp drive path Error code OFSAAI 1181 Cause Invalid path for Application layer Business Metadata ftp drive path Resolution Provide a valid path for Application layer Business Metadata ftp drive path Error code OFSAAI 1182 Cause Invalid path for Application layer Staging Area ftp drive path Resolution Provide a valid path for Application layer Staging Area ftp drive path Error code OFSAAI 1183 Cause Unable to connect to write into Database component ftp drive 11 48 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Resolution Make sure FTP user has permission to write into FTP drive Error code OFSAAI 1184 Cause Resolution Invalid configuration in OFSAAI_ PostInstallConfig xml file Check the InfrastructurePreValidations Log for the error message Error
135. ecurity Hierarchy Security Design OFSAAI Menu Rules Setup Configuration B Administration EA Advanced Analytics Infrastructure amp AMHM UMM Offline Population Financial Services Applications You System Administrator need to have SYSADM function role mapped to your role to access and modify the OLAP details You can access OLAP screen in LHS menu of System Configuration By default the OLAP Details screen displays the pre configured server details specified during the installation Add OLAP Details You can add OLAP details by specifying the server IP database type and locale Ensure that the OLAP server is configured before adding the OLAP details To add OLAP details 1 Select Add button from the OLAP Details window The window is refreshed and enables you to populate the required data in the fields System Configuration 6 19 OFSAA Infrastructure Windows Internet Explorer Ce Financial Services Analytical Applications Infrastructure User stuser ORACLE Setup Li Connectedto ATOM73ST A Home B Unified Metadata Manager SE Rules Framework Efi Forms Framework Type ESSBASE Operations Locale Identifier en_US E E system Configuration Server Details Database Server Application Server User Id thelcubecr Web Server Database Details OLAP Details Server IP 10 184 134 147 For Cube Creation Password Information Domain For Cube Viewing Configuration FIV User Id
136. ed in Log4j xml Error code OFSAAI 1161 Cause Error while disconnecting from the configuration schema Resolution Check the exception message written in the log file configured in Log4j xml Error code OFSAAI 1162 Cause Error while committing to the updates in the configuration schema Resolution Check the exception message written in the log file configured in Log4j xml Error code OFSAAI 1163 Cause Error while updating the locale information Resolution Check the exception message written in the log file configured in Log4j xml Error code OFSAAI 1164 Cause Exception while adding insert_cssms_folder_function_map sq file Resolution Execute insert_cssms_folder_function_map sq file after logging into configuration schema and check the error in log configured in Log4j xml 11 44 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1165 Cause Failed to append header to the log file Resolution Check the exception message written in the log file configured in Log4j xml Error code OFSAAI 1166 Cause Failed to copy the driver files Resolution Copy ojdbc6 jar to following location APP LAYER lt FIC HOME gt ficapp common FICServer lib WEB LAYER lt FIC_LHOME gt ficweb webroot WEB INF lib DATABASE LAYER lt FIC_LHOME gt ficdb etl classes and lt FIC_LHOME gt ficdb lib Error cod
137. ed our products the title and part number of the documentation and the chapter section and page number if available Send your comments to us using the electronic mail address financialservices_ww oracle com Please give your name address electronic mail address and telephone number optional If you need assistance with Oracle software then please contact your support representative or Oracle Support Services If you require training or instruction in using Oracle software then please contact your Oracle local office and inquire about our Oracle University offerings A list of Oracle offices is available on our Web site at www oracle com Preface Intended Audience Welcome to Release 7 3 of the Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide This guide is intended for System Administrators SA who is instrumental in installing and configuring the Infrastructure application Forward This user guide documents the OFSAAI Installation and Configuration for all versions of release 7 3 Some functional improvements have been introduced in various service packs and point releases within release 7 3 This section documents the levels at which various functional enhancements to the OFSAAT Installation and Configuration were first introduced Installation and Configuration Release 7 3 1 0 0 e Supports both numeric and alphanumeric dimensions Conventions and
138. el upload will be executed Navigation Go to Control Panel gt Java gt Java Tab 2 Update Java Runtime Parameter for JRE 1 6 0_07 4 56 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide The following is an example to update the parameter to Xmx800m Product Name JRE Version 1 6 0_07 Location C Program Files Java jrel1 6 0_07 Java Runtime Parameters Xmx800m SFTP Configuration for Excel Document Upload To perform Excel Document upload in a multi tier architecture where App server and Web server are on different machines the Webserver user should be provided with the App layer FTP SFTP user credentials File transfer to App layer will be performed during the Excel Upload In single tier architecture with Webserver on remote machine the file transfer is performed through FTP SFTP while accessing the ExcelUpload functionality Here the App Web and the DB layers are in same machine but the Webserver is in a different machine Therefore the files are transferred to App layer with App layer FTP SFTP user credentials Note In the above two scenarios the UNIX user and FTP SFTP user of the App layer can be same or different In case the users are different the FTP SFTP user should have the write permission in the App layer In single tier architecture where Webservers are on same machine the ExcelUpload folder will be created dynamically while acce
139. elow e Infrastructure Web and Application components on one machine and infrastructure Database components on a separate machine e Infrastructure Web components on one machine and Infrastructure Application and Database components on a separate machine e Infrastructure Web and Database components on one machine and Infrastructure Application components on a separate machine Note You can also opt for hosting Database Engine on a remote machine Refer Single Tier Installation with Database Engine on Remote Machine page 2 4 section for more details 2 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Regardless of the choice of the above options each machine that is used should have the minimum configuration of two CPUs and 8 GB RAM Further depending on the number of users and the number of applications that are deployed using the Infrastructure application the exact hardware configuration has to be worked out Note If more than one server is installed on a single machine for example if Application and Database Servers are on a single machine ensure all the items in Pre Installation Activities Checklist for each of the servers are available on that machine Linux 6 is not supported for EPM v6 0 even though AAI supports it Software Environment Please refer to Support Note 1070591 1 at https support oracle com for information on technology components that are
140. ent in current folder Resolution Copy OFSAAInfrastructure bin into installation kit directory Error code OFSAAI 1006 Cause File CustReg DAT is not present in current folder Resolution Copy CustReg DAT into installation kit directory Error code OFSAAI 1007 Cause File OFSAAT InstallConfig xml is not present in current folder Resolution Copy OFSAAI InstallConfig xml into installation kit directory References 11 11 Error code OFSAAI 1008 Cause File validateXMLInputs jar is not present in current folder Resolution Copy validateXMLInputs jar into installation kit directory Error code OFSAAI 1009 Cause File log4j xmlis not present in current folder Resolution Copy log4j xml into installation kit directory Error code OFSAAI 1009 Cause File log4j xmlis not present in current folder Resolution Copy log4j xml into installation kit directory Error code OFSAAI 1010 Cause Unknown error occurred Resolution Make sure to provide proper argument SILENT or GUI to the Setup sh file Error code OFSAAI 1011 Cause XML validation failed Resolution Check InfrastructurePreValidations Log for more details 11 12 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1012 Cause Property file with locale name does not exist Resolution Copy MyResources_en_US properties to t
141. er Details Database Server Application Server Web Server Information Domain Details Name ATOMST Description atom73st M 1s authorization required for Business Metadata RZ Is this a Staging Information Domain Database Details OLAP Details Configuration SegmentMetadata Mapping Segment Map Security Hierarchy Security Design OFSAAI Menu Rules Setup Configuration SE Administration eB Advanced Analytics Infrastructure A AMHM UMM Offline Population Financial Services Applications 2 Enter the Information Domain details as tabulated Field Description Name Enter the name of the Information Domain Ensure that the name specified is of minimum 6 characters long and does not contain any special characters or extra spaces Description Enter the description of the Information Domain Ensure the description field is neither empty nor exceeds 50 characters Is authorization required Select the checkbox if user authorization is required to access for Business Metadata Business Metadata Is this Staging Select the checkbox if you are creating a Staging Temporary Information Domain Information Domain 3 Click Next and enter the database details as tabulated System Configuration 6 23 Field Description Database Server Select the database server from the drop down list The list contains all the defined database servers Database Name Select the database name from the drop down l
142. eraction Variable Parameter Variable Parameter UPLOAD_AREA_CM Refers to the absolute Content Upload path for document uploads in OFSAAI You need to manually specify the path of the machine where OFSAAI will be deployed and the installer configures updates these paths in configuration files Ex db2 revmock lt OFSAAIT deployed path gt Uploaddoc DOWNLOAD_AREA_CM Refers to the absolute Content Download path for document downloads in OFSAAI You need to manually specify the path of the machine where OFSAAI will be deployed and the installer configures updates these paths in configuration files Ex db2 revmock lt OFSAAIT deployed path gt Downloaddoc WEBSERVER PATH Enter the web application instance deployment path as indicated For Tomcat specify the Tomcat directory path till webapps Such as oradata6 revwb7 tomcat webapps lt For WebSphere enter the WebSphere path lt WebSphere profile directory gt installedA pps lt NodeCellName gt Such as data2 test WebSphere AppServer profiles lt Profile_Name gt i nstalledApps aix imfNode01Cell Where aix imf is Host name For WebLogic provide the WebLogic home directory path weblogic webl1013 bea wlserver_10 3 WEBLOGIC DOMAIN_H Applicable only if the Web server type is WebLogic OME home weblogic bea user_projects domains mydomain log4j xml Configuration You can configure the logging mechanism of installer using the log4j xml Refer to the following table
143. es JTA Select Sis coter only if your sopicaton can tolerate heran conditens tmulte Two Phase Commit Select this opton f you want to enable non KA JOSC comnectons from the data source to pertopete in gobel transactions using the one phase commit Tansacton processing With ths option no other resources can pertopete N the global Tersacton One Phase Commit Beck Nea Cance 7 Click Next to continue The Connection Properties window is displayed 4 16 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Create a New JDBC Data Source Beck Next Cancel Connection Properties Define Connection Properties What 6 the name of the database you mould ike to connect to Database hame fagbu Whats the name or IP address of the database server Host Name 10 185 74 80 What is the port on the database server used to connect to he cotabese Port 1521 What database account User name do you mart to use to Create database comectors Database User Name ssatom What g the database account password to use to Cente database comectors Password eoccee Coefirm Password soseo Sack Next Canoe Enter the required details such as the Database Name Host Name Port Oracle Atomic Schema User Name and Password and click Next The Test Database Connection window is displayed Post Installation Configuration 4 17 Create a New JDBC Data Source Tes Configeratos Beck Ne
144. espace and a rollback tablespace The recommended naming convention for these tablespaces is TEMP_TS and ROLLBACK_TS respectively Instrument tables such as FSI D_MORTGAGES FSI_D_TERM_DEPOSITS FSI_D_LOAN_CONTRACTS or LEDGER_STAT can be moved from the DATA_TS to different tablespaces depending on performance requirements User can use table partitioning as a method of placing segments of a table s data into different tablespaces Indexes on the above tables can be created in INDEX_TS tablespace The previous version of ALM 5 6 and also the earlier versions of ALM mandated the presence of a table space named DATA_TS It was also mandatory that this tablespace should be System Managed or Locally Managed with Uniform Option Starting with ALM v6 0 e The tablespace in which ALM would create the RES_DTL_XXXXX and CONS_DTL_XXXXX tables name need not be named as DATA_TS The tablespace name is parameterized and captured during the installation of ALM 6 0 ALM will create any newer output tables only within this tablespace e Itis no longer necessary for the tablespace to be Locally Managed with Uniform Option For ex The tablespace may simply be Locally Managed i e without UNIFORM option After upgrading to ALM 6 0 it is not necessary to move existing tables out of the DATA_TS tablespace Such tables could continue residing within DATA_TS 6 14 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installatio
145. ess for ecceri te he pech vender database of row mater when the belo D agpi tasi eraworerart Laem mare about thiu tarh in a guided aata A paded ectwity provider bat of asv is mpiapod tath stepi and more Geren efcrrmaton bast the Wc B serves D hepe Cobetpeltchertendet Call Nate spaltcertundet lervereservert Page halp E tevewces Mare cterrmatein sast tebedeiers Scope spectes the level at which the renounce defrvton is Taata Otgem pidi mitepure nebi Far detaded wnfcrmaton on what scope a and how R wos at the iit ainai tele amm and Aronian a Sus comedic ata Bec Modes altdortadell Lerversserwet e OAC preweters ia aa D Peene Dota sewces WebSphere a A E terser Adapters COT BD Aspactornons beans B Cocke inrtonces Sele Here tepe 2 Desvons Bua Yow can edramirter the folowing reszurced Buen O Racha ths Freee Medenipatdemetel tovererereri Derby embedded non D terewie Lowrenment XA JOS Prewster oe Modempeltdometed teversrever PTL B securty 0 B Ceveramene Tatai E spren sdmmcrte ses D uren wd dreps E Menmermg ond T oneg CECE E Service meag otea S woo Select the Scope from the list Scope specifies the level at which the resource definition is visible Click New to add new JDBC Provider The Create a new JDBC Provider window contains the following options Enter the following options Database Type Oracle Provider Type Oracle JDBC Driver Implementation Type Connection pool data source Name The required
146. essage is displayed indicating that the test was successful Post Installation Configuration 4 25 Messages WP Test of FIOMASTER on server AdmirGerver wes success4u Settings for FICMASTER Confguraten Targets Monitoring Coto Searty Stetexcs Testing Use ts page to test database comectors in ts DEC cata soure b Customere this table Test Data Source filtered More Columas Exist 4 Once the Data Source is created successfully the following messages are displayed e All changes have been activated No restart is necessary e Settings updated successfully If not follow the earlier steps to recreate the data source Settings for FICMASTER Confgveton Targets Monitoring Control Searity No JDBC Connection Pooling To define the JDBC connection pooling ensure that you have created JDBC Provider and Data source to access the data from the database 1 Click the newly created Data Source DATA_SOURCE and navigate to the path Home gt Summary of Services JDBC gt Summary of JDBC Data Sources gt JDBC Data Source lt INFODDOM_NAME gt 2 Set the values for Initial Capacity to 10 Maximum Capacity to 100 Capacity Increment by 1 Statement Cache Type to LRU and Statement Cache Size to 10 as shown in the following figure 4 26 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Initial Capacty 10 More bfo Monin Capacity 190 miele Capacity incre
147. esulting path matches JAVA_BIN path configured in the OFSAAI InstallConfig xml Error code OFSAAI 1218 Cause Resolution SFTP configuration for server details is invalid APP_SFTP and DB_SFTP tag value in OFSAAI_PostInstallConfig xml must be the same 0 or 1 If WEB_FTP_ENABLE is 1 APP_SFTP DB_SFTP and WEB_SFTP value must be the same 0 or 1 Error code OFSAAI 1219 Cause Resolution Unable to validate Application layer ftpshare directory for technical metadata Check InfrastructurePreValidations log file for the error message and provide correct details for ftpshare References 11 55 Error code OFSAAI 1220 Cause Resolution Unable to validate Application layer ftpshare directory for business metadata Check InfrastructurePreValidations log file for the error message and provide correct details for ftpshare Error code OFSAAI 1221 Cause Resolution Unable to validate Application layer ftpshare directory for staging area Check InfrastructurePreValidations log file for the error message and provide correct details for ftpshare Error code OFSAAI 1222 Cause Resolution Unable to validate Application layer ftpshare details for technical metadata Check InfrastructurePreValidations log file for the error message and provide correct details for ftpshare Error code OFSAAI 1223 Cause Resolution Unable to validate Application layer ftpshare
148. ew Profile in WebSphere you can also use validatePorts to validate if the specified ports are not reserved or in use Additionally you can specify new ports with startingPort lt base port gt which specifies the starting port number to generate and assign all ports for the profile For more information on using these ports refer WebSphere manageprofiles command at http publib boulder ibm com infocenter wasinfo v6rl index jsp topic 2Fcom ibm websphere base doc 2Finfo 2Faes 2Fae 2Frxml_mana geprofiles html Manage Applications in WebSphere To manage the installed applications in WebSphere perform the following steps Open the administrator console using the following URL http lt ipaddress gt lt Administrative Console Port gt ibm console Example http 10 80 50 53 9003 ibm console https if SSL is enabled Note The Administrative Console Port value can be taken from the serverindex xml file in lt WebSphere Profile Directory gt config cells lt Node Cell gt nodes lt Node Name gt directory The Integrated Solutions Console login window is displayed 2 20 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide sn is a Log in to the console User ID upgs73 Password Log in 1 Log in with the user id that has admin rights 2 In the left menu expand the Applications gt Application Type gt WebSphere Enterprise Applications The Enterpris
149. executable Error code OFSAAI 1069 Cause Error in the locale installation method Resolution Ensure that locale a command is executable Error code OFSAAI 1070 Cause Error during the extraction of setup_locales exe file Resolution Give admin right to the Windows user Error code OFSAAI 1071 Cause Error in reading locales installed in Windows Resolution Check the exception message and provide admin rights to the Windows user Error code OFSAAI 1072 Cause Error during the selection of distinct locale Resolution Check the exception message to resolve the issue References 11 25 Error code OFSAAI 1073 Cause Exception while taking input to copy the AESCryptKey ext file Resolution Check the exception message in the InfrastructurePre Validations Log file Error code OFSAAI 1074 Cause Error in handling the AESCryptKey ext file Resolution Provide the correct database component details Error code OFSAAI 1075 Cause Installation terminated after two failed attempt to copy the AESCryptKey ext file Resolution Provide correct database component details and check whether SFTP or FTP is enabled Error code OFSAAI 1076 Cause OFSAAI InstallConfig xml is not configured for Content Management Resolution If WEB_SERVICES tag value is one then STORE_AS UPLOAD_AREA_CM and DOWNLOAD_AREA_CM values must be configured Error code OFSAAI 1077 Cause Un
150. ext param gt OFSAAI Home Entry This entry should point to the Application layer Web layer of the OFSAAI installation and should be accessible Replace FIC_HOMES in the following block of text in web xml with lt WebServer Deployment Path gt EXEWebService ear EXEWebService war Post Installation Configuration 4 83 lt context param gt lt description gt OFSAAI Web Home lt description gt lt param name gt FIC_HOME lt param name gt lt param value gt FIC_HOMES lt param value gt lt OFSAAI Installation Folder gt lt context param gt lt context param gt lt description gt OFSAAI Web Home lt description gt lt param name gt FIC_ PHYSICAL HOME lt param name gt lt param value gt FIC_HOMES lt param value gt lt OFSAAI Installation Folder gt lt context param gt DynamicWSConfig xml For each third party web service that needs to be accessed using the OFSAAI Web services framework and the operation to be invoked make corresponding entries into this file This file is to be placed in the location that is specified in the web xml as WSCOMNFIGFILE parameter Deploy OFSAAI Web Services You can deploy OFSAAI Web Services separately if you had not configured OFSAAT Web Services as part of the installation 1 Complete the manual configuration of OFSAAI Web Services 2 Navigate to lt OFSAAI Installation Directory gt EXEWebService lt WebServer gt and execute ant sh This w
151. f option from Forms Framework module This can be achieved through the use of BI Publisher with templates created in BIP attaching the same to Form and exporting based on the attached template e Replicating the existing Information Domain option during configuring of new Information Domain in System Configuration gt Information Domain e Phase out of earlier Data Quality feature link from Unified Metadata Manager gt Data Integrator to accommodate enhanced Data Quality Framework e OFSAAI Server Administrative Console utility to enable management of OFSAAI servers sh file OFSAAI Installer New Features e Enhanced validation for Pre requisites and configurations for Post Installation About this Manual 1 3 Limitations AAT Installer validates most of the pre requisites and post installation configuration steps automatically during infrastructure installation e OFSAAI Setup Information Fetching Tool This tool helps you to retrieve the related environmental details about OFSAAI e Logger Mechanism AAT installer uses log4j to define various logger levels e Encryption Changer This utility updates all the existing encrypted values in OFSAAI configuration schema and related files as per the newly generated AES encryption key Following are the limitations of OFSAAI 7 3 AAI Installer When you have entered an invalid password in the GUI panel the data in Password field has to be manually cleared for a next passwor
152. f the following ways Click Save to save the Web Server details Select Modify button from the Server Master window The window is refreshed and enables you to edit the required data in the fields Update the Web Server details as required You can edit all the Web Server Details and FTP details in the Server Master window For more information see Add Web Server Details page 6 10 Click Save to update the changes Single tier with multiple Information Domains hosted across machines Multi tier with multiple Information Domains hosted across machines Single tier with single Information Domain on the same machine System Configuration 6 13 e Multi tier with single Information Domain on the same machine as Infrastructure DB Server You System Administrator need to have SYSADM function role mapped to your role to access and modify the database details You can access Database Details window in the left menu of System Configuration By default the Database Details for DB Server Database Master window displays the pre configured database server details specified during the installation OFSAA Tablespaces A tablespace consists of one or more datafiles OFSAA installation requires a minimum of two tablespaces with the naming conventions listed in the following table Tablespace Name Contents and Usage DATA_TS Location of the OFSAA tables INDEX_TS Location of the OFSAA indexes You also need to define a temporary tabl
153. features provided in OFSAAI are used Open the file AMHMConfig properties present in the FIC_WEB_HOME webroot conf directory to set the properties for the following e Member Deletion e Attribute Default Date Format e Members Reverse Population e Hierarchy Reverse Population e Maximum levels allowed in Hierarchies e Node Limit for a Hierarchy Tree e Configuration for Dimension and Hierarchy Management has to be done only after the application solution installation is done e These properties are specific to infodom INFODOM Name of the infodom DIMENSION_ID Dimension ID for which the property to be set Important For any change made to the AMHMConfig properties file to take effect restart the webserver Configure Member Deletion This property should be set to allow the user to delete the Members for the Dimension VALUE CODE EXAMPLE 4 58 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Member Deletion Configuration VALUE Y N MEMBER_DEL INFODOM MEMBER _DEL ORAFUSION DIMENSION_ID VALUE 1 Y Configure Attribute Default Date Format This property should be set to display the Default Date Format for Date type Attribute in Attributes window VALUE Attribute Default Date Format DB_DATE_FORMAT DD MO N YYYY CODE EXAMPLE ATTR_DEF_DATE_FORMAT ATTR_DEF_DATE_FORMAT SINFODOM DB_DATE_F ORAFUSION DD MON YY ORMAT YY
154. fig_table_privileges_for_atomic_user sql Configure Infrastructure Server Memory The memory settings for Infrastructure Application Server Tomcat WebSphere and WebLogic can be edited for customizing memory settings and garbage collector settings depending on the available hardware configuration as explained below These settings are base minimum and has to be incremented considering the deployment metrics into account The increments are usually handled in multiples of 128mb for heap and 64mb for stack Infrastructure Application Server Memory Settings You can configure the Infrastructure Application Memory settings as follows Locate reveleusstartup sh file which resides in the folder lt OFSAAI Installation Directory gt ficapp common FICServer bin Edit X_ARGS field in this file for customizing memory settings and garbage collector settings depends on the hardware configuration This has a default value X_ARGS Xms200m X_ARGS X_ARGS DELIM Xmx2048m Note This parameter is modified in 7 3 2 IR and you need to modify X_ARGS_APP variable in the profile file to customize Java Memory Settings for Model Upload based on the Data Model size Tomcat Memory Settings Perform the Tomcat Memory Settings as follows Folder lt CATALINA_HOME gt bin File catalina sh This file can be edited for setting customized memory settings and garbage collector settings depending on the available hardware configuration Add the memory
155. file Error code OFSAAI 1084 Cause The ISWEBSERVER value is not one for single tier installation Resolution For single tier installation ISWEBSERVER tag value must be one in OFSAAI InstallConfig xml file Error code OFSAAI 1085 Cause All server values are not the same for single tier installation Resolution All server values must be 1 for single tier installation Make ISAPPSERVER ISDBSERVER and ISWEBSERVER tag values as 1 in OFSAAI InstallConfig xml file Error code OFSAAI 1086 Cause No layers are selected for multi tier installation Resolution For multi tier installation select at least one layer 11 28 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1087 Cause For installation of all layers INSTALLMODE is not 1 Resolution For installation of all layers select INSTALLMODE as 1 in OFSAAI InstallConfig xml file Error code OFSAAI 1088 Cause The RAC_STATUS value is provided with a value other than 0 or 1 Resolution The RAC_STATUS value can take only 0 or 1 Error code OFSAAI 1089 Cause The RAC URL is not set in the OFSAAT _InstallConfig xml file Resolution Set the RAC URL in the OFSAAT InstallConfig xml file Error code OFSAAI 1090 Cause The OLAP_SERVER_IMPLEMENTATION is provided with a value other than 0 or 1 Resolution The OLAP_SERVER_IMPLEMENTATION value can take only
156. gine IP address gt lt DB Port gt lt SID gt maxActive 100 maxIdle 30 maxWait 10000 gt lt Context gt Note Post Installation Configuration 4 27 e The lt Resource gt tag must be repeated for each of the information domains that are created e After the earlier configuration the WAR file has to be created and deployed in Tomcat For more instructions refer the Tomcat WAR Files Creation page 4 47 and Tomcat WAR Files Deployment page 4 48 sections JDBC Connection Pooling To define the JDBC connection pooling do the following Copy ORACLE_HOME jdbce lib ojdbc 6 jar to the path TOMCAT_DIRECTORY lib Edit the server xml present under the path TOMCAT_DIRECTORY conf with the following changes which is required for connection pooling lt Context path SCONTEXTNAMES docBase APP DEPLOYED PATHS debug 0 reloadable true crossContext true gt lt Resource auth Container name jdbc INFODOM_ NAMES type Javax sql DataSource driverClassName oracle jdbc driver OracleDriver username SATOMICSCHEMA USERNAMES password SATOMICSCHEMA PASSWORDS url SJDBC_CONNECTION_ URL maxActive 100 maxIdle 30 maxWait 10000 removeAbandoned true removeAbandonedTimeout 60 logAbandoned true gt lt Context gt Note TOMCAT_DIRECTORY should be replaced by Tomcat application installed path CONTEXTNAMES should be replaced by Oracle Fi
157. grain objects like Dimensions Metrics Security Maps and User Profile to higher order objects like Rules Models and Analytic Query Templates which are assembled using the lower grain ones In addition to application definition tools it provides the entire gamut of services required for Application Management including Security Service Workflow Service Metadata Management Operations Life cycle Management public API s and Web Services that are exposed to extend and enrich the tooling capabilities within the applications OFSAAI provides the framework for building running and managing applications along with out of the box support for various Deployment Models Compliance to Technology standards and supporting a host of OS Middleware Database and Integration with enterprise standard infrastructure Infrastructure architecture provides you a choice of platforms The available options enables you to choose the environment based on their preference system performance and cost parameters This guide details the steps involved in installing OFSAAI in the released environment About this Manual 1 1 What s changed in OFSAAI 7 3 New Modules New Features Following are the list of new and not supported features in 7 3 version of OFSAAI Oracle Cubes This module facilitates to define cubes using Business Metadata objects such as Dimensions Hierarchies and Measures The generated Rule and data files can be used to load data and b
158. gt files EAR WAR files are installed on Machine A and Infrastructure Web Application lt Change to Archive gt files or EAR WAR files are deployed on the Web server installed on Machine B Multi Tier Installation Multiple architectures are possible with the multi tier option in Infrastructure There are four types of multi tier installation options In the multi tier installations Multi Tier option is selected in the Infrastructure Installation Mode and the components Application Database or Web whichever is are being installed in the particular machine must be selected in the Choose Component s 2 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Note For all multi tier installation options stated the Infrastructure database components must be installed first In all multi tier installations communication must be established between machines A and B either through IP addresses or hostnames In all the above multi tier options you also have the provision to configure the database engine in a Remote machine This requires a TNS entry of database engine machine in database components machine In such cases the machine that has the database components installed on it requires the database client of the same version to be also installed on it In case of multi tier installation the tnsname and SID should be same in both the application and database layers
159. hat is used to perform an FTP SFTP in the machine where the database server is located It is mandatory to specify the FTP SFTP User ID Enter the password which is same as the specified password for FTP SFTP user ID by the administrator The password is represented by asterisk for security reasons Ensure that there are no special characters in the password specified 4 Click Save to save the changes Web server refers to a computer program that delivers serves content such as Web pages using the Hypertext Transfer Protocol HTTP over the World Wide Web The Web Server in the Infrastructure system constitutes the presentation layer The Infrastructure Web Server presentation layer can be implemented in the following two ways e Installation of Single Web Server e Installation of Primary Web Server and a Secondary Server System Configuration 6 9 OFSAA Infrastructure Windows Internet Explorer Eek Financial Services Analytical Applications Infrastructure User stuser ORACLE gin Dat Connectedto ATom73stT Server Master S Home Unified Metadata Manager EY Rules Framework fh Forms Framework Ee Operations Is Primary v B system Configuration Local Path Please enter a valid path oracle rhelweb ftpshare Shared Storage Enabled V E Server Details OFSAAI Context ofsa73 Database Server Protocol https v Application Server FTP Enabled K Database Details ETP Details OLAP Details FIP C SFTP
160. he DB Layer terminal chmod R 777 lt ftpshare folder gt Navigate to ftpshare folder and set the umask shown as follows This will make sure that all the new files created will have 666 file permission cd lt ftpshare folder gt umask 0000 The Config and Atomic schema should be two distinct Oracle database users Please execute privileges_atomic_user sql The correct database privileges and tablespace quota should be granted to the Config Schema User prior to OFSAAI installation The correct database privileges and tablespace quota should be granted to the Atomic Schema User prior to Information Domain or Infodom creation For more information on Information Domain creation see Information Domain page 6 22 All Infrastructure Configuration Steps should be completed including e Configuring the Database Server page 6 2 e Configuring the Application Server page 6 6 e Configuring the Web server page 6 9 e Configuring Database Details page 6 13 e Creating the Information Domain page 6 22 The Database Administrator should ensure that there is a TNS entry for the Database name provided The Database name provided should be the name of the Atomic Schema The TNS entry should be added to the ORACLE_ HOME network admin tnsnames ora file located in the machine where the Oracle database server is installed 7 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide
161. he setup kit directory and keep en_US in LOCALE tag of OFSAAI InstallConfig xml Error code OFSAAI 1013 Cause File OFSAAI _InstallConfig xml OFSAAI_PostInstallConfig xml not found Resolution Copy OFSAAI InstallConfig xml OFSAAI_ PostInstallConfig xml to the setup kit directory Error code OFSAAI 1014 Cause XML node value is blank Resolution Make sure all node values except SMTPSERVER PROXYHOST PROXYPORT PROXYUSERNAME PROXYPASSWORD NONPROXYHOST or RAC_URL are not blank Error code OFSAAI 1015 Cause XML is not well formed Resolution Make sure that OFSAAI InstallConfig xml is valid Try to open the file through Internet Explorer for a quick way to check validity If it is not getting opened create new OFSAAI InstallConfig xml using the XML_Utility jar Error code OFSAAI 1016 Cause User installation directory contain blank spaces References 11 13 Resolution Provide an installation path that does not contain spaces Check the tag USER_INSTALL_DIR in OFSAAT InstallConfig xml file This path should not contain any spaces Error code OFSAAI 1017 Cause User installation directory is invalid Resolution Provide a valid installation path Check if you are able to create the directory mentioned in USER_INSTALL_DIR tag value of OFSAAI InstallConfig xml file Error code OFSAAI 1018 Cause User does not have the permission to create directory Resolution Provide
162. he values that can be specified for the attribute and TYPE specifies how to get the allowed values The values that can be specified in the TYPE column are as follows e 0 USER INPUT e 1 Comma Separated Values e 2 Execute the SQL select query in ALLOWED_VALUES column to get the list of allowed values The query should select two columns the first of which will be the actual values and the second the description which will be displayed in the select list e lt USER gt should be replaced with a valid Infrastructure user id Configuration of Infrastructure Ports This step is applicable only in the event you wish to change any of the ports used by Infrastructure services after the installation process The ports that are used by the Infrastructure application are distributed across the machines on which Infrastructure Post Installation Configuration 4 71 Web Application and Database components have been installed Therefore you must perform the port changes on all the machines on which Infrastructure components have been installed PortC jar can be executed in the following two modes e GUI e CMD To execute PortC jar in GUI mode ensure that the Hummingbird Exceed to be running and do the following 1 On each machine navigate to the path FIC_LHOME 2 Enter the command java jar PortC jar GUI 3 The Configure OFSAA Infrastructure Port changer window is displayed OFSAAInfrastructure Port Changer Oo x
163. ial Services Analytical Applications Administrator user in User UserGroup Map e ADMINISTRATOR e ALM Application Administrator Group e Funds Transfer Pricing Application Administrator Group e Profitability Application Administrator e TPOL Application Administrator e HM Application Administrator Note ADMINISTRATOR User Group is required for access to seeded batches in Batch Execution Map the appropriate Infodom to the required application user groups in UserGroup Domain Map Complete all required User Group Authorizations with sysauth user 9 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Batch with Batch_Table_Class_Req task needs to be created and executed for any Information date This step will ensure the object registrations are validated and made available to the individual applications Once the batch is setup every time a data model is uploaded or a new dimension is registered this batch needs to be executed Steps to create and execute a batch for Batch_Table_Class_Req task 1 Navigate to Operations then Batch Scheduling 2 Define a New Batch Use the following for the new Batch Definition Define a New Batch Select an Empty Batch and Name the Batch Component ID Transform Data Description Object Registration Click Parameter Datastore Type EDW Datastore Name lt select from list of value gt IP Address lt select from list of
164. ides information on Configuring Server details Database Details OLAP Details and Information Domain The Pre Installation Applications Activities Checklist outlines the pre installation activities that must be completed successfully prior to initiating the Application Installation Kit run Applications Installation chapter describes the installation process where the Three Product setup components are installed on separate machines with the Product installation on separate machines The Post Application Installation Activities chapter outlines the post installation activities that must be performed once the installation of the Oracle Financial Services FTP PFT ALM ALM BI TPOL HM IFRS Products are completed Uninstall Infrastructure Components section provides step by step instruction to uninstall the Oracle Financial Services Analytical Applications Infrastructure application Frequently Asked Questions chapter attempts to provide answers in resolving few of the OFSAAI Installation and configuration issues Error Dictionary This section is a compilation of all the error codes which might get displayed during installation process The section has information related to the cause and resolution of each error code Defining Application Sources chapter provides the steps to create an application source Since Infrastructure makes use of the Third Party Freeware the license agreements for the same are attached in the concluding secti
165. ig Schema password perform the following steps 1 Change the Config schema user password in the database Delete the FIC_HOME conf Reveleus SEC file Shutdown the OFSAAI App service cd FIC_APP_HOME common FICServer bin reveleusshutdown sh Start the Infrastructure Server in foreground directly on the server or through X Windows software using the command reveleusstartup sh A pop up window will appear with a prompt Enter System Password Enter the new Config schema password The service will start and initialize itself if it was able to successfully connect to the DB Post successful startup of the service if wanted the Infrastructure server may be shutdown and restarted in the background using nohup mode System Configuration 6 29 OFSAA Infrastructure Atomic Schema password modification in Post Installation To change the Atomic Schema password perform the following steps 1 Login to the application from the browser using SYSADMN account or any user id which has System Administrator role mapped Change the Atomic schema user password in the database Login to OFSAA Navigate to System Configuration gt Database Details window Select the appropriate connection and edit the password Navigate to Unified Metadata Manager gt Technical Metadata gt Data Integrator gt Define Sources window Update the appropriate Source details If using Apache Tomcat as Web server update the lt Context gt gt Resour
166. ility page 4 52 for more details Error Dictionary Introduction This contents of this section has been created with the interest to help you resolve the installation issues if any There is a compilation of all the possible errors that might arise during the installation process with the possible cause and the resolution to quickly fix the issue and proceed further with the installation Accessing Error Dictionary Instead of scrolling through the document to find the error code you can use the pdf search functionality In the Find dialog box available in any of the Adobe Acrobat version that you are using to view the pdf document perform the following instructions to quickly find the error resolution 1 With the Installation pdf open press Ctrl F or select Edit gt Find 2 The Find dialog box is displayed as indicated e If you are using Acrobat Reader 10 0 or later the Find dialog box is as displayed OFSAAI 1003 x op x References 11 9 e If you are using Acrobat Professional 8 0 or later the Find dialog box is as displayed BOFSAAI 1003 3 Enter the error code that is displayed on screen during Infrastructure installation 4 Press Enter The search results are displayed and highlighted as indicated in the following Error code OFSAAI 1003 cause JAVA_HOME bin not found in PATH vanable Resolution mport lt JAVA_HOME gt bin into PATH variable Example PATH JAVA_HOME bin PATH exp
167. ill trigger the EAR WAR file creation which is required for the deployment 3 Deploy the generated EXEWebService EAR EXEWebService WAR file into the WebServer If you have already chosen to configure OFSAAI Web Services as part of the installation just deploy the generated EXEWebService EAR EXEWebService WAR file into the OFSAAI Deployment area in WebServer profile Configure Oracle database operations A configuration file OracleDB conf has been introduced to accommodate any configurable parameter related to operations on oracle database If you do not want to set a parameter to a specific value then the respective parameter entry can be removed commented off form the OracleDB conf file which resides in the path FIC_DB_HOME conf As of now the OracleDB conf file has only one parameter namely CNF_DEGREE_OF_PARALLELISM This parameter indicates the degree of parallelism to be used for a DML operation if parallel DML is explicitly enabled in the session with the ENABLE PARALLEL DML clause of the ALTER SESSION statement The default mode of a session is DISABLE PARALLEL DML If CNF_DEGREE_OF_PARALLELISM is not set then the default degree as decided by Oracle will be used 4 84 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Configure Message Details in Forms Designer You can configure the Message Details in Forms Designer under Data Entry Forms and Queries module by upda
168. in Source window is displayed Select the option Generate a domain configured automatically to support the following products and click Next Pre Installation Configuration 2 23 F Fusion Middleware Configuration Wizard x Select Domain Source ORACLE Generate a domain configured automatically to support the following products O Base this domain on an existing template Next Exit Help Previous 4 The Specify Domain Name and Location window is displayed Enter the Domain Name and Location You can also click Browse to navigate to the WebLogic configuration directory Click Next 2 24 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide F Fusion Middleware Configuration Wizard Specify Domain Name and Location BEE ORACLE Enter the name and location for the domain Domain name MockSol Domain location Aveblogicwebl1 01 3easuser_projects domains Browse Exit Help Previous The Configure Administrator Username and Password window is displayed Enter the username and password to be assigned to the Administrator Make sure that the password is of minimum 8 characters in length Re enter the password for confirmation and add a brief description Click Next Pre Installation Configuration 2 25 F Fusion Middleware Configurati
169. ing AESCryptKey ext Resolution Check the exception message and re install OFSAAI Error code OFSAAI 1171 Cause Exception during updation of configuration tables Resolution Check the exception message written in the Log configured in Log4j xml Error code OFSAAI 1172 Cause Error while executing the SQL statement Resolution Check the exception message written in the Log configured in Log4j xml Look for open cursor value integrity constraint and unique constraint Error code OFSAAI 1173 Cause Failed to update the FicDB cfg file 11 46 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Resolution Replace following value in lt FIC_LHOME gt ficdb conf FICDB cfg INSTALLAPPSERVERIP gt APPLICATION LAYER IP ADDRESS and 6666 with NATIVE PORT Error code OFSAAI 1174 Cause File OFSAAT _ PostInstallConfig xml not found Resolution Copy OFSAAI_ PostInstallConfig xml into the installation kit directory Error code OFSAAI 1175 Cause POST_INSTALL value is neither 0 nor 1 Resolution Update POST_INSTALL value in OFSAAI _InstallConfig xml to either 1 or 0 Error code OFSAAI 1176 Cause Unable to connect to Database component ftp drive Resolution Provide correct database component ftp details Error code OFSAAI 1177 Cause Unable to connect to Web component ftp drive Resolution Provide corr
170. install 4 The Uninstall Application window is displayed Click OK to confirm 10 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 5 S Guded Acowtes 2 Servers B topkcabons D ogian types E Services B Pevorces Bsearty 8 rwroremert E System sdmrest aon Users and Grows B Mortonng and Tune 8 Treubleshouwrg Service etegraton Svc Click Save to save the master file configuration Uninstall EAR WAR Files in WebLogic On the machine that hosts WebLogic follow the steps outlined to uninstall any previously deployed application 1 Open the URL in the browser window http lt ipaddress gt lt admin server port gt console https if SSL is enabled The login window of the WebLogic Server Administration Console is displayed Login with the WebLogic user id and password having administration privileges The WebLogic Server Administration Console is displayed Click the Deployments link on the LHS menu The Summary of Deployments window is displayed Click Stop gt Force Stop Now option from the drop down list Uninstall Infrastructure Components 10 3 ORACLE Weblogic Server Administration Console a eee Heme Logat Preferences E Record Help 2 Welcome manager Corrected to Mocktel View changes and restarts Lernsseilen ite Configr ten editing 6 enabled Fare Suerenary of Deployment Changes will sutomatx aly be sctewated as you
171. installed on Solaris the PATH variable must be set till sparcv9 The same path must be selected during the installation Example usr jdk instances jdk1 6 0 bin sparcv9 SMTP services must be running on any one of the machines The machines need not be the ones identified for installation of Infrastructure components This is required by the DEFQ module of Infrastructure This configuration is optional The machines that will be used for the installation of Infrastructure components must be on the network and must be able to fetch each other s hostname This is required in the event the installation is required to be performed using the hostnames instead of the IP addresses ERwin 7 1 or 7 3 is used for data modeling the RAM size of the infrastructure application tier should be proportional to the size of the ERwin model For optimal performance in Application Server layer of OFSAAI the RAM size must be around 20 times the size of the Erwin model If multiple machines are used for the Infrastructure installation the server date and time set at each machine must be the same Different date time settings on each machine will lead to improper functioning of the scheduler in the Infrastructure application Pre Installation Configuration 2 9 The minimum space required for installing the Infrastructure components is as follows Ensure that the machines in which the Infrastructure components are installed have the following minimum
172. is displayed Infrastructure Installation 3 7 OFSAAInfrastructure felis Application Database Web Component Details License Please enter Infrastructure Application DatabaseMVveb Preinstall Setup Component password Installation install Complete ORACLE FINANCIAL SERVICES installAnyerhere Note In case of multi tier installation you will be prompted for this option only when application component and post installation configuration are enabled Enter the Infrastructure Application Database Web component password Note For a multi tier installation when the Database component is not getting installed you are prompted to provide the Database Component Details User Name Password and Installation Directory After providing the Database component details you are prompted to provide the Application and Web component FTP SFTP passwords depending on the component being installed 6 Click Next The Pre Installation Summary window is displayed 3 8 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 7 OFSAAInfrastructure fc B a Pre installation Summary License Please review the following before continuing Preinstall Setup installation Product Name OFS AAInfrastructure Version 7 3 Installation Folder exporthome setupkiVOFSAAI uired 0 Megabytes Available Space 915 MegaBytes Selected Locale en_US ISO8858 1 I
173. ist The list contains all the database names contained within the server OLAP Server Select the OLAP server from the drop down list The list contains all the servers defined in OLAP Details OLAP Type Select OLAP Type from the drop down list The available options are 1 ESSBASE 2 ORACLE 3 SQAOLAP Generate BI hierarchy Select the required option to re generate all the Business Intelligence Hierarchies either upon Data Load or upon Transformation or both By default None option is selected 4 Click Next 5 Specify the file location path of ERwin Log and Scripts file on the application server Example An ERWIN file path could be oracle app73 ftpshare lt infodom gt Erwin e Erwin file stores TFM and Database Model XML files e Log file stores the Log data for all the Backend and Front end components e Script file stores Table Creation scripts 6 Specify the file location path of Erwin Log and Scripts file on the database server For example an ERWIN file path could be home db73 ftpshare lt infodom gt erwin The specified details provided for the database and application server details will be mapped to the Information Domain A consolidated data would be stored in the DSNMASTER table in the config schema database 7 Click Save to save the Information Domain details 6 24 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide On creating an Inform
174. ist of user identities and passwords for Java TM 2 connector security to use General Properties Alias tm User IO upgs73 Passvord essee Description Atomic Instance ox Reset Cancel 4 Click Save and save the details JDBC Connection Pooling To define the JDBC connection pooling ensure that you have created JDBC Provider and Data source to access the data from the database 1 Click the newly created Data Source DATA_SOURCE and navigate to the path Data sources gt DATA_SOURCE gt Connection pools 2 Set the values for Connection timeout to 0 seconds Maximum connections to 100 connections and Minimum connections to 10 connections as shown in the following figure You can also define Reap Time Unused Timeout and Aged Timeout as required Data courses gt gt Connes tion pools Ure this peoe to set properties that impad the teming of conmedion management terhe Aidh can affect the performance of your apebcetion Consider the default values carefully pour applicamon requeements might warrant changing there values Configuration Generel Preperties Scope r dortode0ice Jes ipal dorNode0i servers iserve Adxacaad senneser pazl Cennetien Umes A bre eres b seconds Cennaedion gool egusiem erogeres Mexunuen connedions 190 connadions Minimum comnechons io connections Reap time 100 seconds Unused timeout 2e 00 seconds Aged teneout fo seconds Purge
175. ji Level ieoi B Searty B Envecemere ota ayer E System admwesty abon B Users and Groups B Montorng and Tug E Trobleshocting 8 Service rteq amon auo 4 Preparing for the application installation window is displayed 4 30 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Preparing for the application installation Specify the EAR WAR JAR of SAR module to upload and install Path to the new application Local file system Full path O Remote file system Select the Remote file system and Click Browse to select the EAR file generated for OFSAAI to upload and install This file name will be displayed in the Specify Path box provided Click Next Preparing for the application installation Specify the EAR WAR JAR or SAR module to upload and install Path to the new application Local file system Browse Remote file system Full path feebserver vabs t6M WebSphere AppServer 6 Select the Fast path option and click Next Preparing for the apphcation imstallation How do you want to install the application Fart Path Prompt only when additional information is required O Detailed Show all installation options and parameters E Choose to generate default bindings end mappings 7 Select Installation Options window is displayed Click Next Post Installation Configuration 4 31 Install New App
176. lation and Configuration Guide Internet Options x Trusted sites f x General Securty Priv onnections Pr Advanced e ane You can add and remove websites from this zone All websites in this zone wil use the zone s securky settings Select a zone to view or change security settings e a J Add this website to the zone Local intranet Trusted sites sain ae This zone contains websites that you trust not to damage your computer or your Files Security level for this zone Ad for this sone A Require server verification https for all stes in this zone Medium wisn before downloading potertially unsafe Unsigned Active controls wll net he doveieeded Coc C ce too _ Click OK in the Internet Options window to save the settings Information on Patches installed in the environment For getting details on the patches that are installed in the OFSAAI environment query the table INFODOM_PATCHES in the lt configuration gt schema select from infodom_patches INFODOM_PATCHES table in configuration schema gives the information of the patches which are already applied in OFSAAI environment Table Name Description V_INFODOM Name of INFODOM N_SERIAL_NO Serial No of patch V_PATCH_NAME Version of the patch applied V_REMARKS Remarks D_APPLIED_DATE Patch application date You can run the following query to get information about the patches that are applied Post Installation Configurati
177. lds Click Next Additional Information 4 22 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide e The data source name needs to be provided in the Name field e The JNDI Name has to be specified in the format jdbc infodomname e JNDI Name of the Data Sources that will be added to new JDBC Multi data source should be different from the JNDI name specified during Multi Data Source e Same steps needs to be followed to create a mandatory data source pointing to the configuration schema of infrastructure with jdbc FICMASTER as JNDI name for Data Source e JNDI Name provided in multi data source should be the same name that will be mentioned in the web xml file of OFSAAI Application e You can select the Algorithm Type as Load Balancing 4 Select the AdminServer check box and click Next Create a New JDGC Heiti Data Source Bact hert cance 5 In the Select Data Source Type window select the type of data source which will be added to new JDBC Multi Data Source Create a New JOC Holti Data Source Sek Net Cance Select Data Source Type Please select type XA oF Non KA of data source you would ike to add to your new JOSC Mut Data Source XA Driver 6 Map the required Data Source from the Available Data Sources Click Finish Post Installation Configuration 4 23 Create a New JDOC Heiti Data Source The new JDBC Multi Data Source is created with added data
178. le Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide File required to run Model Upload Utility Upload sh This is a shell script to run the utility Upload sh is present at the following location FIC_HOME ficapp common FICServer bin Run the Model Upload Utility Procedure 1 Open Upload sh and enter the following arguments in the file 1 lt infodom gt Refers to the DSN name 2 lt entire file path gt Refers to the ERwin File Path 3 lt username gt Refers to the username 4 lt uploadmode N R AM gt Refers to the Upload Choice Code e N Refers to the New Model Upload e AM Refers to the Incremental Model Upload e R Refers to the Complete Model Rebuild Upload e AP Refers to the Sliced Model Upload 5 lt runscriptsFlag gt Refers to the running of SQL Script e lt true gt Updates the database schema with the Model changes e lt false gt Does not update the database schema with Model changes Execute the script using the command upload sh Note Ensure that you are provided with the execute permission Logs are updated in regular Model Upload log in the following location ftpshare lt infodom gt logs lt infodom gt _LOG_ lt last data model version gt _ lt MM DD YYYY gt lt HH MM SS gt log Note During incremental model upload when the uploadmodel is set as AM some of mappings done in Data Integrator may get invalidated You Post In
179. le Tier Installation page 2 4 e Multi Tier Installation page 2 4 Single Tier Installation You can install all the Infrastructure components such as Application Web and Database components on a single machine This option further warrants the Servlet Engine to be installed on the same machine Single Tier Installation with Database Engine on Remote Machine You can choose an option in the single tier architecture where the database engine is pointed to a remote machine This particular architecture would be as follows e Infrastructure Application and Database components and Web components are installed on Machine A e Database Engine is pointed to Machine B Note Make sure that you have a TNS entry of Machine B in Machine A In such cases make sure that the database client of same version is installed in Machine A In all the single tier installations ensure that the EAR WAR files of the Infrastructure Web Application are deployed The creation and deployment of EAR files have to be done manually For more information refer EAR Files Creation and Deployment in Post Installation Configuration page 4 1 section Single Tier Installation with Web Server on Remote Machine You can choose this option in single tier architecture where the Servlet Engine is installed on a remote machine That is Infrastructure Application Database components and Web components for creation of Infrastructure Web Application lt Change to Archive
180. ler validates the database details provided during installation so ensure e Whether the oracle schema user has the required set of privileges for successful References 11 3 installation e Whether the oracle schema user has been created with quota privileges on tablespace to create database objects Refer to Pre requisites section in this document What when error message resembles java lang Exception TripleDES cpptripledes Library not loaded during OFSAA Infrastructure installation OFSAA Infrastructure Installer loads the libcpptripledes so file provided for installation so ensure the following e Libcpptripledes so file has execute permissions e Whether the JAVA version set in the PATH variable is same on which OFSAA Infrastructure was qualified Detailed instructions of the software environments on which OFSAA Infrastructure is qualified can be found in Environments page 2 2 Installation of OFSAA Infrastructure was completed successfully What next Post the successful completion of OFSAA Infrastructure one has to perform the Post Installation Steps Detailed instructions can be found in thePost Installation Configuration page 4 1 OFSAA Infrastructure Installation is unsuccessful OFSAA Infrastructure installer generates log files in the Infrastructure Installation Directory The installer generates logs namely OFSAAInfrastructure_Install log and configReveleus log The log OFSAAInfrastructure_Install log provides
181. lication 7 Specify options for installing enterprise applications and modules Specify the various options that are available to prepare and install your application m Precompile JavaServer Pages files p to install application C2 Distribute application C use Binary Configuration a Deploy enterprise beans lication name p9s73 j E create MBeans for resources C override class reloading settings for Web and EJB modules Reload interval in seconds o Deploy Web services Validate Input off warn fail wam v C Process embedded configuration File Permission Allow all files to be read but not written to Allow executables to execute Allow HTML and image files to be read by everyone dle SSe s087S5e 2e755e sle755 lication Build t0 O atow dispatching includes to remote resources Oo Allow servicing includes from remote resources Business level application name _ Create New BLA w Asynchronous Request Dispatch Type Disabled o Allow EJE reference targets to resolve automatically 8 The Map Modules to Servers window is displayed Select the Web Application and click Next 4 32 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Install New Application Specify options for installing enterprise applications and modules Step 1 Select installation options Specify targets such as application servers or clusters of applic
182. lity of RAM e Ensure Default and Temporary tablespace assigned to Oracle user is allocated with required space SIZE TRANSFORMI TOTAL MODEL JAVA SETTINGS JAVA OF NG TIME UPLOAD TIME INTHE SERVER SETTINGS XML IN CLIENT FILE PICK 50MB 10 min 14 min 200M to 400M FILE FROM 90MB 26 min 30 min 200M to 800M Dr 156MB 30min 34 min 200M to 1000M SERVER OPTION 185MB 31min 36 min 200M to 1200M 215MB 33min 40 min 200M to 1200M Post Installation Configuration 4 55 THROU 50MB 10min 14 min 200M to 400M GH UTILITY 90MB 26min 30 min 200M to 800M 156MB 30min 34 min 200M to 1000M 185MB 31min 36 min 200M to 1200M 215MB 33min 40 min 200M to 1200M BROWSI 50MB 10min 15 min 200M to 400M 200M to NG FILE XMx350M 90MB 26min 32 min 200M to 800M l l 200M to 156MB 30min 40 min 200M to 1000M ADAN 185MB 31min 45 min 200M to 1200M TTA 215MB 33min 48 min 200M to 1200M XMx600M 200M to XMx600M 200M to XMx800M Steps to change the Java Setting on Server 1 Edit the FIC_HOMF ficapp common FICServer bin reveleusstartup sh script X_ARGS prior to performing model upload The following is an example of what parameters to change from Xmx200m to Xmx1800m From X_ARGS Xms200m X_ARGS X_ARGS DELIM Xmx200m To X_ARGS Xms200m X_ARGS X_ARGS DELIM Xmx1800m 2 Re run reveleusstartup sh to restart the Infrastructure server Steps to Change the Java Setting on Client 1 Change the setting for Client PC where mod
183. lti select Hierarchies 1 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide e Modeling AAI Framework enhancements include new Transition Matrix Statistical Technique and Stress Testing in Sandbox Information Domain along with changes to Regression Technique Output history model deployment versioning of Variable Shocks Scenario changes and options to include Variable Shocks as tasks to add replace delete tasks and change their precedence in the Stress Run Features Not Available e Insight and Active Portal features along with the related links e Pass Number Maintenance feature link in Operations module e Erwin Option in Generate Source Model dialog box of Unified Metadata Manager gt Data Integrator gt Data Sources e Rule Shocks feature links from Unified Metadata Manager gt Stress Testing e Parameter Modification feature links from Advanced Analytics Infrastructure gt Modeling e ISMEMORYLOAD property in Properties dialog box of Database Extracts Table to File and File Extracts windows in Unified Metadata Manager gt Data Integrator gt Warehouse Designer e File Sort Property in Properties window of Database Extracts Table to File window in Unified Metadata Manager gt Data Integrator gt Warehouse Designer e Authentication Type LDAP Authentication and Authorization in System Configuration gt Configuration window e Export to pd
184. lytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1194 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution APP_USER_ID_SA value cannot be NULL or NA Error code OFSAAI 1195 Cause Invalid configuration in OFSAAI_PostInstallConfig xml file Resolution DB_SFTP value can take only 0 or 1 Error code OFSAAI 1196 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution DB_DRIVE_TM value cannot be NULL or NA Error code OFSAAI 1197 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution DB_PORT_NO_TM value cannot be NULL or NA Error code OFSAAI 1198 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file Resolution DB_USER_ID_TM value cannot be NULL or NA Error code OFSAAI 1199 Cause Invalid configuration in OFSAAI_ PostInstallConfig xml file References 11 51 Resolution DB_DRIVE_BM value cannot be NULL or NA Error code OFSAAI 1200 Cause Resolution Invalid configuration in OFSAAI_ PostInstallConfig xml file DB_PORT_NO_BM value cannot be NULL or NA Error code OFSAAI 1201 Cause Resolution Invalid configuration in OFSAAI_ PostInstallConfig xml file DB_USER_ID_BM value cannot be NULL or NA Error code OFSAAI 1202 Cause Resolution Invalid configuration in OFSAAI_ PostInstallConfig xml file
185. me should not exceed 10 Characters Solution Setup Specify the segment code maped to the above nosom OEVSEO TNS Narre for Appication Schema nfodom Database EPMD 7 This window displays all the pre installation summary Verify all details and proceed Click Install to proceed Applications Installation 8 19 T Solution Setup 8 This panel displays the installation process Please wait until it completes Installation is in progress This process may take several minutes Please Wait 9 The following window displays the completion of installation of the Oracle Financial Services Profitability Management Product Setup 8 20 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Solution Setup instaladon is complete Your installaton bog has been writen to ONERE bog Machine C Product Web Layer Procedure 1 To begin Oracle Financial Services Analytical Applications installation execute Setup sh ORACLE FINANCIAL SERVICES Copyright 1993 2012 Oracle andie ts affiliates All rights reserved 2 Upon invoking the installer the Introduction window will display the pre requisites for installation Ensure that the pre requisites are satisfied before you proceed Applications Installation 8 21 Solution Setup Tees user interface will guide you rough the sohGon setup Before proceeding with he installadon you mus
186. ment More if of Statement Cache LRU Type Statement Cache Size Advanced Save 3 Save the details Configuration of Resource Reference in Tomcat Application Server Copy the JDBC driver file depending on your Oracle database version As OFSAAI is certified on Oracle 11gR2 copy the Oracle JDBC driver file ojdbc6 jar from lt Oracle Home gt jdbc lib and place it in lt Tomcat Home gt lib Create Data Source To create data source for Infrastructure application navigate to lt Tomcat Home gt conf and edit the following block of text in server xml by replacing the actual values of the following text lt Context path lt context name gt docBase lt Tomcat Installation Directory gt webapps lt context name gt debug 0 reloadable true crossContext true gt lt Resource auth Container name jdbc FICMASTER type Javax sql DataSource driverClassName oracle jdbc driver OracleDriver username lt user id for the config schema database gt password lt password for the above user id gt url jdbc oracle thin lt DB engine IP address gt lt DB Port gt lt SID gt maxActive 100 maxIdle 30 maxWait 10000 gt lt Resource auth Container name jdbc lt INFORMATION DOMAIN NAME gt type Javax sql DataSource driverClassName oracle jdbc driver OracleDriver username lt user id for the database gt password lt password for the above user id gt url jdbc oracle thin lt DB en
187. mework required for Infrastructure System Administrators can define the Servers Database and Information Domain along with the other Configuration process such as segment and metadata mapping hierarchy security and designing the Infrastructure Menu functions System Configuration is mostly a one time activity which helps System administrator to make the Infrastructure system operational for usage System Configuration activities should be performed by the Infrastructure administrator using the admin credentials To access System Configuration you must be mapped to SYSADM function role within the Infrastructure system This guide explains about the System Configuration components namely Server Details Database Details OLAP Details and Information Domain For information about the remaining components see OFSAAI 7 3 User Guide Server Details Server Details in the System Configuration section facilitates you to define and configure the various server setup details maintained within the Infrastructure System You System Administrator need to have full access rights to ftpshare folder with appropriate User ID and password to add and modify the server details You can access Server Details window in left menu of System Configuration The options available under Server Details are 1 Database Server 2 Application Server System Configuration 6 1 3 Web Server Database Server Database server refers to a computer in netw
188. must be replaced with this echoed value In case of application server and web server started from different Machines The WINDIR value in the DynamicServices xml file present in lt OFSAAI Installation Directory gt conf folder should be replaced with the echo DISPLAY value taken from the machine on which Infrastructure application server is started The WINDIR value in the DynamicServices xml file should be replaced with the echo DISPLAY value taken from the machine on which web container is started For Weblogic and Websphere the DynamicServices xml file will be present in lt OFSAAI 4 54 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Application Deployment Area gt lt contextname gt ear lt contextname gt war conf folder Similarly for Tomcat the DynamicServices xml file will be present in lt OFSAAI Application Deployment Area gt lt contextname gt war conf folder Note This step is applicable only when Hummingbird Exceed 7 0 is running Model Upload Details A set of Java settings needs to configured while uploading the data model with various with various size of xml s This can be done by e Picking file from the server option e Model Upload Utility e Browsing the file in the local computer Note e The following table consists of the Java settings done on both client and server machines These Java settings will differ depending on the availabi
189. n Member UI from showing the code as an optional attribute since it already displays the alphanumeric and numeric codes based on the member table e Delete alphanumeric attribute metadata from ATTRIBUTE _B table Example Delete from Rev_DIM ATTRIBUTES B where Attribute _ID Select Attribute ID from REV _DIM ATTRIBUTES TL where Attribute Name COMMON COA CODE and dimension _id select dimension id from REV DIMENSIONS B where member b table name DIM COMMON COA B Post Installation Configuration 4 87 e Delete alphanumeric attribute metadata from ATTRIBUTE _TL table Example Delete from Rev DIM ATTRIBUTES TL where Attribute ID Select Attribute ID from REV_DIM ATTRIBUTES TL where Attribute Name COMMON COA CODE and dimension _ id select dimension _id from REV DIMENSIONS B where member b table name DIM COMMON _COA_B 3 Save your changes usingCommit Configure Numeric Dimensions If REV_DIMENSIONS_B Member_Code_Column is populated for a dimension any UI which displays an alphanumeric code will look in the specified column for the member s alphanumeric code If REV_DIMENSIONS_B Member_Code_Column is null the UI will assume no alphanumeric code column exists in the member table and will display the alphanumeric code with the same value as the numeric code Therefore for numeric dimensions you may want to update the metadata If you don t want to st
190. n Domain name Click Next 4 Select the option Select an Existing JDBC Provider and select the required JDBC provider from the list Post Installation Configuration 4 7 Click Next Create a data source Step 1 Enter basic dat rce Specify a JOBC provider to support the datasource If you choose to create a new IDEC provider it vill be created at the same scope as the datasource If you are selecting an existing JOBC provider only those providers at the current scope are available from the list O Create new JDBC provider properties for the data source Select an existing JOEC provider Step 4 Setup ice Oracle JOBC Oriver 5 Specify the URL of the database from which the data source obtains connections The connection URI is of the type jdbc oracle thin lt DB_SERVER_IP gt lt DB_SERVER_PORT gt lt SID gt 6 Select Data Store Helper Class Name from the drop down list and ensure that the checkbox Use this data source in container managed persistence CMP is selected Click Next Create a data source Create a data source Set these database specific properties which are required by the database vendor JDEC driver to support the connections that are managed through the datasource Name Value URL 20 284 108 92 1521 0rel2 2g f Data store helper class name Step 4 Setup Oracletig data store helper V security aliases Step 5 Summary i Use this data source in con
191. n Guide Valuations and Pricing Management Transfer Pricing component v6 0 product installer and will be installed as a part of the upcoming steps if required Do you want to perform Model upload T Yes gt No Ihave aingady done R Clicking No implies that model has been uploaded into information domain prior to this installation Clicking Yes will proceed with the EPM apps v6 0 model upload process as part of the installation If the user selects Yes Step 9 and 10 will be performed Upon selecting No Step 9 to 10 will be skipped Click Next to proceed The following window prompts you to select whether the released version of Datamodel or the customized Datamodel is to be uploaded Do you ward to uptosd Rsteased Dats Bodet of Custorrered Data Moet 7 Released Data Model D Customized Data Model Applications Installation 8 9 On selecting Released Data Model option installer uploads the v6 0 data model that is packaged as the part of the EPM apps v6 0 product On selecting Customized Data Model option installer allows you to select the data model Select the required option Click Next to proceed 10 If the option Customized Data Model is selected the following window will be displayed prompting you to select the customized data model located in the machine Solution Setup inbosucbon Pre install Corfigurabon Resicee Detaut F ne Chgose Select the customized Datamodel file
192. n and Configuration Guide OFSAA Datafiles Examples of the naming conventions for datafiles associated with each of the required tablespaces are provided in the following table Tablespace Name Naming Convention Example DATA_TS lt dbname gt _DATA_01 DBF lt dbname gt _DATA_02 DBF INDEX_TS lt dbname gt _INDEX_01 DBF lt dbname gt _INDEX_02 DBF Follow the numbering convention in this example for multiple datafiles within tablespaces The number of datafiles for a tablespace can vary from database to database Datafile Location The location of the datafiles for your tablespaces varies based on many factors including whether your database is on raw devices or file systems If the database is on raw devices the datafiles are defined by a logical volume management program such as Volume Manager and must be mapped into logical volumes If the database is on file systems the datafiles are located in directories that can use the following naming conventions db d02 oradata lt dbname gt db d03 oradata lt dbname gt db d04 oradata lt dbname gt and so forth The datafiles are located in the oradata lt dbname gt subdirectory Add Database Details for DB Server You can add database details by specifying the IP address User ID password and JDBC details Ensure that the Server Details are specified and the database is created before adding the database details System Configuration 6 15 OFSAA Infrastructure Win
193. nancial Services Analytical Applications Infrastructure context name APP_DEPLOYED_PATHS should be replaced by the Oracle Financial Services Analytical Applications Infrastructure application deployed path INFODOM_NAMES should be replaced by Infodom Name ATOMICSCHEMA_USERNAMES should be replaced by Atomic schema database user name ATOMICSCHEMA_PASSWORD6 should be replaced by Atomic schema database 4 28 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide password e JDBC_CONNECTION_URL should be replaced by JDBC connection string jdbc Oracle thin lt IP gt lt PORT gt lt SID gt For example jdbc oracle thin 10 80 50 53 1521 soluint Configure WebSphere Create WebSphere EAR File File Creation The Enterprise ARchive EAR files is required to assemble servlets jsp files web pages and other static content into a deployable unit This EAR file creation is required to reflect the changes made to the web xml file Following are the outlined steps 1 On the machine in which Infrastructure Web components have been installed navigate to the FIC_WEB_HOME directory At the prompt enter ant sh This triggers the creation of EAR file lt contextname gt ear Note The lt contextname gt is the context name given during installation 2 On completion of the EAR files creation the following message will be displayed and you will be returned to the promp
194. neperr Comrwrcared Asm Sedemealtdomotel 2 Geverstercet 1 Gese adeniniate soem ares B heses aso Owe secon Mebiphers Appie omen Saree VO GOT tree Selot nome IOA nora Sase S Provider Dermwten Cotepery Ocoto amans VI Can obrana the telhowing sermewer Bee p omom a Roden altdormeded Serversservert ameti Mev JOC Bun Oreos OetewOvtorewce Moderpeltdertoded Serversserrer Oerby DOC Owterowee B teores Casement oh ea Hee wabtenere Bienen ad oree Toi D irren etm morte otsa B vers ont derer Deneng es Teng E rretliostoveny B sereno ateg otses Drees 3 Select the Scope from the drop down list Scope specifies the level at which the resource definition is visible Click New The Create a Data Source window is displayed Create a data source Set the basic configuration values of a datasource for association with your JDBC provider A datasource supplies the physical connections between the application server and the database Requirement Use the Oatasources WebSphere R Application Server V4 console pages if your applications are based on the Enterprise JavaBeans TM EJB 1 0 specification or the Java TM Servlet 2 2 specification iZone2NodeOS servers serveri Step 5 Summary Osta source name iT INDI name DORYMOCK Specify the Data Source name and the JNDI name for the new Data Source the JNDI and Data Source name are case sensitive JNDI Name should be same as the Informatio
195. nfigured n the WebSphere Application Server repestory ADUASOOTL The application Dmeres are Saved A oresata7 wasTHEUieDSonere Aco Serveripro esnea Da sien OPTI ORE Mevertscece cole ond re Noe CeVis Iry moct eartrymoct 2 eor ADUASOOS The application Grymoca 2 configures n the WebSphere Appicaton Server repeatory SECILI SUCCESSA UPIS he BSsicetOn OrymOCKT2 WEP Me BDOConteRDOF orSecurty Nisrmetor ADUASOOS The appicaton crymoce a configures e me WebSomere Appicaton Server rencetory ADUASITY Actvaton pan creates syocesstety ADUASOIIL The cleanup of me temp Grectory for appicaten Srymock72 e complete ADUASOIN Applicaton srymoceT natales sccess uly Application drymeck 2 installed svccessty To start the apphcaton frat save changes to he masier configurator Changes Mave been mese te you Ocal centguraton You can Save directly to the master configuration Sauce changes before saving or discarding To won WEN nstsled sppications Cac Me Vereze ppicatons iat To start the application Expand Applications gt Application Type gt WebSphere Enterprise applications The Enterprise Applications window opens Select the application installed and click Start Enterprise Applications Use thus page to manage installed appicabons A single appicabon can be deployed onto multpie servers Preferences e lt profile name gt is the profile name given while creating the WebSphere profile Post Installation Configur
196. nfrastructure layer select Administrative Reports to configure the Administrative Reports application 8 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Note e Fora single tier Oracle Financial Services Analytical Applications Infrastructure 7 3 installation you must select Application Layer Database Layer and Web Layer For a multi tier Oracle Financial Services Analytical Applications Infrastructure 7 3 installation select the corresponding layer installed on the machine e If Admin BI is already configured through the previous product installation the subsequent product installation without Admin BI option may alter the existing Admin BI configuration settings e Inthe case of ALM BI solution the preceding screen would look as following lt Solution Setup troduction Please Choose the OF SAA Layers on which Soksion ts to be instabed Pre install Configuraton J Apptication Layer J Databee Layer lt ETE Note The option to configure Administrative reports is not there in Pricing Management Transfer Pricing Component Therefore the step 6 can be skipped For more information see the Installation manual for Pricing Management Transfer Pricing component at OTN 6 This panel seeks information on whether a new infodom has to be created or the existing infodom to be used for apps installation Select the desired option Click Next to continue Applic
197. ning successfully On the server start up parameters options please refer to Starting Infrastructure page 5 1 e Further details on the issue refer on to the Revappserver log in FIC_APP_HOME common FICServer logs directory or the Web Server log files Is it necessary to provide the specified grants to the Oracle schema user before installation if yes can it be revoked after completion of installation Oracle schema user requires the necessary grants specified before during and after the installation process Grants provided should never be revoked as the application makes use of these grants all the time Can we have distributed OFSAA Infrastructure Application Server for load balancing OFSAA Infrastructure Application server can be scaled out distributed across different JVM s machines based on the various services and information domains in other words Load balancing could be achieved with distribution of services Why do we need ftpshare Why on all the layers Can we have ftpshare on another machine other than the machines where OFSAAI is installed All the files used in Infrastructure are stored in the FTP folders The ftpshare folder is a metadata repository directory that contains folders for each information domain Each information domain folder holds a corresponding Erwin log and scripts folder For any operation the data needs to be transferred from the client to the database The entities such as Tables are generated in
198. ns Infrastructure OFSAAI Installation and Configuration Guide T Solution Setup Click Next to continue 8 This panel displays all the pre installation summary Please verify all details and proceed Click Install to proceed Solution Setup 9 This panel displays the installation process Please wait until it completes Applications Installation 8 25 Solution Setup Installation is in progress This process may take several minutes Please Wait 10 The following window displays the completion of installation of the EPM apps Product Setup Click Done to exit Solution Setup Instaliabon is complete Your installaton tog has been writen to AA serapkethogity hog Silent Installation Silent installation is achieved through a properties file Silent props that must be updated with proper values before attempting to install using the silent mode The following table lists all the properties that must be specified 8 26 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Property Name Description of Permissible values Comments Property LOG_MODE Mode for logging 0 Debug Optional 1 General Default 0 CUSTOMER _ID Customer id Not Applicable MANDATORY specified while installing OFSAAI INSTALL_WEB Install web tier 0 No Default 0 components 1 Yes INSTALL_DB Install database tier 0 No Default 0 components 1
199. ns with the wanted name e Save the application by clicking the Save icon that appears in the toolbar of the Define Applications block Defining Application Sources A 1 EP Data Sources Windows Internet Explorer Lok Financial Services Analytical Applications Infrastructure ORACLE amp Data Integrator Source Designer 8 Use the Define Applications block to create the data sources To create an RDBMS data source select the RDBMS option under Source type Note To create RDBMS Data Source e Enter the Atomic User for USER ID and Table Owner e Enter the Database Name for Database Name e Specify the TNS Name e Select the required Source Date Format e Select the required locale e Select Database as Oracle e Select JDBC drivers as Oracle Driver JDBC driver list will NOT appear unless using certified browser either version IE 7 or IE 8 e Enter Complete JDBC URL if using Real Application Clusters RAC ource type OfttFie Rosus Real Applic g 5 8 b elelela giggle Save the data source by clicking the Save icon that appears in the toolbar of the Define Sources block To create another data source click the add icon in the same toolbar and repeat the same process as above Map the data sources to the application A 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide e Choose the application from the A
200. nsole Welton Lagni to werk mth the WebLope Seewer deman ieman nazor Posswen eneencens 2 From the left hand menu under Domain Structure click Services gt JDBC gt Multi Data Sources The Summary of JDBC Multi Data Sources window is displayed Post Installation Configuration 4 21 ORACLE WebLogic Server Administration Console Change Center Home Log Out Preferences Record Help Q Welcome ofsaai72at Connected to ofsaai72qt View changes and restarts Home gt Summary of JDBC Multi Date Sources Summary of JDBC Dats Sources Summary of JDBC Multi Data Sources Configuration editing is enabled Future Summary of JDBC Multi Data Sources changes will automatically be activated as you modify add or delete items in this domain A JDBC multi data source is an abstraction around a group of data sources that provides load balancing and failover between data sources As with data sources multi data sources are also bound Domain Structure to the JNDI tree Applications can look up a multi data source on the JNDI tree and then reserve a database connection from a data source The multi data source determines from which data eon source to provide the connection B Environment Use this page to create or view multi data sources in your domain D customize this table Multi Data Sources Filtered More Columns Exist Data Source Factories wg sistent Stores Foreign JNDI Providers rk Contexts Showing
201. nstall Complete The Pre Installation Summary window displays the Product Name Version Installation Folder Required Space Available Space Selected Locale and Warnings if any Click Install The Installing OFSAAInfrastructure window is displayed Infrastructure Installation 3 9 OFSAAInfrastructure f for Installing OF SAAInfrastructure License Preinstall Setup Installation Install Complete O ORACLE Installation is in progress ao This process may take several minutes Please Wait FINANCIAL SERVICES Installing Execute Script Batch file AdminCont installAnyerhere The installation process is started Anytime during the installation you can click Cancel to stop the Installation Once complete the Installation Summary window is displayed 3 10 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 8 OF SAAInfrastructure License Preinstall Setup Installation install Complete CRANE FINANCIAL SERVICES installAnywhere EE INSTALLATION SUMMARY INSTALLATION SUMMARY FATAL ERRORS 0 ERRORS 0 DEBUG STATEMENTS 293 INFORMATIONS 149 Please see the installation log under fexporthome ssetupkivkivOF SAAI log for more details Click on Next to continue The Installation Summary window displays the number of Fatal Errors Errors Debug Statements Information and Warnings along with th
202. ntainer option of the application server under Custom properties add a new property com ibm ws webcontainer invokefilterscompatibility and set the value to true Save the new property Use the following figure for reference 9 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Application servers Application servers gt serveri gt Web container gt Custom properties Use this page to specify an arbitrary name and value pair The value that is specified for the name and value pair is a string that can set internal system configuration properties Preferences New Delete BP Select Name gt Value gt Description gt You can administer the following resources g com ibm ws webcontainer invokefilterscompatibility true Total 1 For more information on creation of JDBC Provider Data Source and connection pools see the corresponding Resource Reference configuration sections of WebSphere page 4 2 WebLogic page 4 13 and Tomcat page 4 27 All Oracle Financial Services Analytical Applications Infrastructure v7 3 Servers must be shut down e Oracle 11g service must be running e Deploy the EAR or WAR file Note If the installation is an upgrade from 5 x version and if there are multiple applications then be sure that all installed applications are upgraded before attempting the redeployment e If the Web Server is Tomcat then re create and re deploy the
203. ntnttnt tntan nntnntnnnt nn ennnne nenene 6 7 Web Server a aan eaa aaia e a a A aa araa aida erin eds a ea aa a aaa 6 9 Add Web Server Detail Saia a Aa eiaa a r ee ee 6 10 Modify Web Server Details Isin oinen nip ea aa ra aa Ta E E eee 6 13 Database Details nienia e n e a a a a e a a a nE R haat aA 6 13 Add Database Details for DB Servet c ccccceceeeeeeeeeneeceeeeeeeeeececcaneaeeeeeeeeeesesennueaaeeeees 6 15 Modify Database Details for DB Servel ccccccccsccsceteceneenecneecneeneceeeeeeeeeseeeseseeeenieenees 6 18 OLAP Details ET EE acne teak als ee itt od et he lin ao te ete a Statins te tas falco 6 18 Add O AP Detailoyis sds cv nin a a abide dee clin aly Satta tata inte 6 19 Modify OLAP Details ninenin enhn a ban ice a Catt Be 6 21 Information Domain ccccecceeeeececcee cence ee eeeeececeecaeceeeeeeeececneaaaaeeeeeeeeeesessncaeseeeeeeeeeeteee 6 22 Create Information Domain ccccccececeeeeceeceeceeeeeeeeeecseaaeceeeeeeeesesecaaaaeceeeeeeeesetensisaeeeeees 6 23 Modify Information DOmMain ccccccccce cet eceeeteensecnecnaecseeeseceeeeeesescaeeeeaeeneseseeaeenaenas 6 28 Delete Information Domlaitiisr lt iacccssciete eH ste aed ed este area anes eaee eaten 6 29 Configuring Password changes 0 ccccccecccse cence see ceee sees cess ese ceneeseesseseneesnessneeenesnaee 6 29 7 Pre Installation Applications Activities Checklist Pre Installation Applications Activities Checklist 0
204. o be made in the DynamicWSConfig xml template file Note The variable lt WebServer gt denotes any one of the application server that is WebSphere WebLogic or Tomcat The DynamicWSConfig xml file will be available in the lt OFSAAI Installation Directory gt EXEWebService lt WebServer gt ROOT conf directory This file can be placed in any directory that is accessible by the application and this location must be specified in the web xml file as WSCONFIGFILE parameter The DynamicWSConfig xml template file will be in lt WebServer Deployment Path gt EXEWeb6ervice ear EXEWebService war conf directory 4 80 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide This template is given below lt XML gt lt WEBSERVICES gt lt WEBSERVICE CODE CODE ENDPOINT SENDPOINT TARGETNAMESPACE TARGETNAMESPACE XMLNS_ XSD XMLNS_XSD ENCODINGSTYLE SENCODINGSTYLE SERVICENAME SSERVICENAME PORTTYPENAME PORTTYPENAME SESSION MAINTAIN PROPERTY SESSION MAINTAIN PROPERTY USERNAME SUSERNAME PASSWORD SPASSWORD STYLE SWEBSERVICESTYLE STUBIMPLEMENTATION STUBIMPLEMENTATION gt lt OPERATION CODE CODE NA 7 NAME SOAPACTION SSOAPACTION STYLE SSTYLE PACKAGENAME PACKAGE
205. ogic HTTPS Configuration cited ink We N ae a i aei N 4 45 Configure Tomcat sinana a tags vatadate sian tegast ean aaa Aaaa sate Aiai 4 45 Tomcat User Administration nse cniieratii e a a aE e a 4 46 Configure Tomcat to use JAVA 64 bit Executable nesnssnssnsennsrnsinerinsrnsensrnsrinsrnsensresens 4 46 Configure Servlet Poft oirie ii i a aie a aa E EEEE Ra 4 46 Create Tomea WAR PEE aa ide a aa A 4 47 Deploy Tomat WAR Filesi tcc icl cach a a e a ta a a a a i a N 4 48 None SSI Port Configuration siepe a pe ne ea ea el ae Gi eed die 4 51 SSL Port Configuration kiss ee RE ee eae Sit las AEEA 4 51 Additional Configurations 00 00 c aeaeaei annaa eaaa aa aeaa iia E a EARSTE EAEE EARE ERTA 4 52 Configure ET P SEUR aeh aaka ael E e e e A pe E E A EE 4 52 Configuration for Forms Framework cccccccccssecsecteecneenecneeeeeeeneceeeecnsecaeenseeeseeensaees 4 52 Configuration for Model Upload Utility cece cece cnseeneenieeneeeeenaecseerseceeneeniaees 4 52 Run the Model Upload Utility ieee ee eens a e e EN 4 53 Report Display Configuration 0 c cccceecsee cess eeeeeceeeceeeeeeeeceeeseesesaeseseseeeesaeeseeenees 4 54 Model Upload Detailsisiiscisssctestesssacssiastetesdaantadvacts tnsdivadeaeat saa a iaaa O a aE 4 55 SFTP Configuration for Excel Document Upl0ad ccccccccccceccseeeenteenseetecneeeeenseeeneeas 4 57 Configuration for Dimension and Hierarchy Management 0 ccccsseeeeeeeeseeeeeeeenees 4 58 IP Host
206. ollowing window check and verify all the details before proceeding to the next step Click Next to continue A new information domain will be created on clicking Next Applications Installation 8 7 Pirate fever the following before Contrnang Information Domain Name TRYINFCOOM Infactom Description Srpen Saa oer TOMC Mc onde ster 10 18474 54 1522 REVELEUS Infocom Schema Ontabase Name TRYINECOOM ee ae Server Log AR2 seupkntoshare TRYINFOOOMMogs Infocom Maintenance Database Server Log Path 2 If the option Existing Infodom is selected in the Step 6 the following window will be displayed It will prompt to select the infodom from the list of infodoms present in the setup Enter the segment code and the application schema s TNS name Note Segment name should not exceed 10 Characters Solution Setup Specify the segment Code maped to the above infodom DESEO TNS Name for App cation Schema infedom Database EPMDO 8 Oracle Financial Services Funds Transfer Pricing Asset Liability Management Profitability Management Data Model Hedge Management and IFRS Valuations and Pricing Management Transfer Pricing component data model is packaged as a part of the Oracle Financial Services Funds Transfer Pricing Asset Liability Management Profitability Management Data Model Hedge Management IFRS 8 8 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuratio
207. omain Select the required Information Domain by clicking on the Name drop down list You can edit only the specific information as indicated below e In Information Domain Details section you can update the Information Domain 6 23 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Description and change the option to specify if authorization is required for Business Metadata In Generate BI hierarchy section you can change the option re generate all the Business Intelligence Hierarchies either upon Data Load or upon Transformation or both By default None option is selected In Paths on the APP and DB Server you can update only the Log File Path The ERwin and Scripts file path is updated automatically by the system when there is a change in the Server Details The change in path of Log and MDB files has to be updated manually by moving the files to the new path Once you have updated the required information click Save to save the Information Details For more information refer Create Information Domain page 6 23 Delete Information Domain You can remove an Information Domain in the Infrastructure system only when there are no users mapped to it Select the required Information Domain by clicking on the Name drop down list and click Delete Configuring Password changes OFSAA Infrastructure Config Schema password modification in Post Installation To change the Conf
208. on 4 69 select v_patch_name from infodom_patches OLAP Data Server Configuration Note This section is applicable if you are using the OLAP feature of OFSAAI The following parameters must be set so as to ensure that the system limitations are not exceeded at any stage during the life of an instance of OLAP Data Server The values for these OS parameters should be specified based on the expected load at each implementation site Example Process Memory Limit Max Thread Stack Size Max Number of Threads per Process Sort Buffer Settings This must be set at the Essbase application level appropriate to the anticipated load Shutdown and Restart During shutdown of OFSAAI Server that has an instance of Data Services that is communicating with an OLAP Data Server it is imperative to ensure that the cleanup of the old instance is completed on the OLAP Data Server before restarting the OFSAAI Server Pause for a period of time based on the load the system was subjected to before restarting the Data Services subsystem Object Migration HttpsURLConnection configuration for WebLogic This section is applicable if you are using the Object Migration feature of OFSAAI with Weblogic as application server The Object Migration feature of Infrastructure allows you to transfer data from a source database along with the schema objects triggers and stored procedures to the required database in an integrated visual environment While making
209. on Wizard x Configure Administrator User Name and Password ORACLE Discard Changes User name manager User password Confirm user password 2 Description This user is the default administrator Exit Help Previous Next 6 The Configure Server Start Mode and JDK window is displayed Under WebLogic Domain Startup Mode select Development Mode Under JDK Selection select Other JDK option Click Browse and navigate to the JDK location Click Next 2 26 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide F Fusion Middleware Configuration Wizard Configure Server Start Mode and JDK Before putting your domain into production make sure that the production environment is secure For more information see the topic Securing a Production Environment in the WebLogic Server documentation To use WebLogic JRockit in production Oracle recommends developing and testing your applications with WebLogic JRockit early in the project cycle For information about WebLogic JRockit see the WebLogic JRockit documentation WebLogic Domain Startup Mode wk Selection o Development Mode Available JDKs Utilize boot properties for username and password and poll for applications to deploy Sun JDK recommended for better startup performance during iterativ
210. on of this manual About this Manual 1 5 2 Pre Installation Configuration The list of pre configurations required to install and run the OFSAAI V 7 3 Infrastructure is stated in this chapter Further the installation process requires certain environmental variables to be set prior to starting the installation Ensure the following requirements before installation You are requested to refer to the Release Notes for any updates on hardware or software requirements This chapter covers the following topics Guidelines to Unzip Infrastructure Installer Environment and Software Control Panel Settings Infrastructure Installation Options Pre Installation Activities Checklist WebServer Configuration for Infrastructure Application Populate installation configuration xml Guidelines to Unzip Infrastructure Installer Once you have downloaded the Infrastructure Installer from e delivery or support oracle com refer to the following instructions to Unzip the downloaded contents 1 Copy the downloaded OFSAAI Installer zip file contents to your server in Binary mode Download the Unzip utility with respect to specific OS from the location https updates oracle com unzips unzips html and transfer it to the UNIX machine in Binary mode where OFSAAI needs to be installed Copy the downloaded utility file into the directory that is included in your PATH variable typically HOME path or Directory in which you have copied OFSAAI
211. on this page To natal a new soplicaton o module for Geployment to targets n Sis doman cick the Install button P Customize this table Deployments Showing 1to lof 1 Previous Next orm poe vx eeaeee Shownrg 1 to lofi Prevous Next 6 Click Delete to delete the selected Deployment Click Yes in the confirmation dialog to remove the selected deployment from the domain configuration 10 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Messages P Al changes have been activated No restarts are necessary Y Selected Deployments were deleted Summary of Deployments Control Monitoring This page displays a ist of Java EE appiications and stand alone application modes that have been installed to this domain Installed applications and modules can be started stopped updated redeployed ce deleted from the domain by first selecting the application name and using the controls on this page To install a new application or module for deployment to targets in this domain cick the Install button Customize this table Deployments Fhsto Showing Oto 0 of 0 Previous Next SS CS SC Cn kostal Showing Oto Oof 0 Previous Next The deployment is deleted and a confirmation message is displayed Uninstall WAR Files in Tomcat On the machine that hosts Tomcat follow the steps outlined to uninstall any previously deployed application 1 Comment out Context path
212. ons Log to get file path Error code OFSAAI 1032 Cause Resolution Error while checking com ibm SOAP requestTimeout value Make sure the soap client props file in properties directory of Web Sphere profile is accessible and com ibm SOAP requestTimeout lt value gt is present in that file Error code OFSAAI 1033 Cause Resolution soap client props file not found in properties directory of WebSphere profile Make sure soap client props file in properties directory of WebSphere profile is accessible Error code OFSAAI 1034 Cause Resolution Exception while retrieving version of Oracle Make sure sqlplus v command is executable Note LD_LIBRARY_PATH needs to be set for the specific UNIX user Example LD_LIBRARY_PATH lt ORACLE_HOME gt lib export LD_LIBRARY_PATH References 11 17 Error code OFSAAI 1035 Cause ORACLE_HOME environment variable not set Resolution Make sure that the ORACLE HOME environment variable is set in profile Example ORACLE_HOME lt PATH gt gt export ORACLE_HOME Error code OFSAAI 1036 Cause Error while fetching ORACLE_HOME from PATH variable Resolution Make sure ORACLE_HOME environment variable is present in PATH variable Example PATH ORACLE_HOME bin PATH export PATH Error code OFSAAI 1037 Cause ORACLE_HOME bin not found in PATH variable Resolution Make sure that the ORACLE_HOME bin is present in PATH v
213. oper path in ABS_DRIVER_PATH in OFSAAI InstallConfig xml For ORACLE 11g ojdbc6 jar must be present in lt ORACLE_HOME gt jdbc lib Error code OFSAAI 1106 Cause JDBC Driver not loaded and class not found exception while connecting to configuration schema 11 32 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Resolution Check the exception message in InfrastructurePreValidations Log file Error code OFSAAI 1107 Cause Installation exception while connecting to configuration schema Exception while registering JDBC Driver Resolution Check the exception message in InfrastructurePre Validations Log file Error code OFSAAI 1108 Cause Error while checking configuration schema Resolution Check the exception message in InfrastructurePre Validations Log file to resolve the error Error code OFSAAI 1109 Cause Illegal Access exception while connecting to configuration schema Resolution Check the exception message in InfrastructurePre Validations Log file to resolve the error Error code OFSAAI 1110 Cause Connection failure to configuration schema Resolution Check the exception message in InfrastructurePre Validations Log file to resolve the error Error code OFSAAI 1111 Cause Could not connect to DB2 due to driver problem References 11 33 Resolution Check the exception message in Infr
214. operations s ssissississrnetiesintissirsrinrinrissinnrrnrintnsntnnrrnne neee 4 84 Configure Message Details in Forms Designet 00 cccccccceece eset eee teee tee eeeesneetnenenaes 4 85 Clearing Application Cache iivcacitcietarevietnstivnie vealed hte a eaaa iea ela a aa aeaa 4 85 Dimension Configuration Alphanumeric and Numeric Codes cccccsceesseeseeneeneees 4 86 Configure Alphanumeric Dimensions 0 0 ccccccceceeee tees eeee cesses seneetneeneeeneeenaee 4 86 Configure Numeric Dimensions 0ccccceccee eee eeeeeeee seer seer scene eeneeseeeseneesnneteneeetee 4 88 5 Start Stop Infrastructure Services Introduction aa eaaa A Ea aa a Eaa aE aa ia aaa Eaa a ETENE t 5 1 Starting the Infrastructure Server ss esiseineeisiisrintiistrsrinrinsrnstisrinrinsruntnsrreensrnntnnrrnren nenne 5 1 Stop Infrastructure S ryice Sishir netden aea ipe eieaa ea iep addant d air ieie 5 5 6 System Configuration InttOGuchOn epaia ee ee ned ee a ea Saa aeaa 6 1 Server Details stinen dei aeea ea ne en ee ee ee ee 6 1 Database Servers A cee tales eran ies ete Re caine sate ete aces ce oee cn ot TA 6 2 Add Database Server Detajl Sa ea n a aa a anaba 6 3 Modify Database Server Details 0 ccccccsccsecsecnecseenescneenecneceenecneeeseenieeaeeeeniaenees 6 6 Applicaton Servers aera aei eaea a Ee area eN EE OEST E TEESE E GEETE EEE 6 6 Modify Application Server Details snssnsnsenrtnttttttttttttttt
215. ore data in the alphanumeric column for a numeric dimension and if you have not backed up REV_DIMENSIONS _B already you can clear the Member Code Column entries for applicable dimensions Example e For specific numeric dimensions Update REV DIMENSIONS B Set Member Code Column null Where Dimension ID in values Commit e For all editable numeric dimensions Update REV DIMENSIONS B Set Member Code Column null Where Member Data_Type Code NUMBER and DIMENSION EDITABLE FLAG Y Commit Alternately if you want to store an equivalent alphanumeric code on numeric dimensions MEMBER_CODE_COLUMN should point to the alphanumeric code column on the member table For upgrades from 7 3 0 if data already exists for numeric dimension members copy the numeric code values to the alphanumeric code column Example e For the Common Chart of Accounts dimension Update DIM GENERAL LEDGER B set GL Account _ Code GL _Account_ID Commit You have to create a unique index on the alphanumeric code column if such an index is not present already And this index uniqueness should be case insensitive Example create unique index IDX1 DIM PRODUCTS B on DIM PRODUCTS B PRODUCT CODE For editable seeded and user defined simple dimensions where the alphanumeric 4 88 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration G
216. ore information SFTP Configuration Ensure that you have the required software installed in all the Infrastructure Server machines for SFTP configuration If not you can download and install the appropriate version from the following URL http www openssh com openbsd html You can choose the type of FTP configuration as either Secure FTP or FTP and based on the selection the installation of each Infrastructure component should be configured appropriately Configuration of Infrastructure Ports Pre Installation Configuration 2 17 Following are the recommended ports for the machine s in which OFSAAI needs to be installed Make sure that these ports are enabled on the machine before you start the installation Infrastructure Application components Infrastructure Server Java Port 9999 Infrastructure Server Native Port 6666 ICC Object Server Port 6507 ICC Native Server Port 6509 Infrastructure Database Components Agent Port 6510 Router Port 6500 Activation Manager Port 6505 Message Server Port 6501 OLAP Data Server Port 10101 Infrastructure Webserver Components Servlet Port 9080 7001 or 8080 to be enabled in the machine on which WebSphere WebLogic or Tomcat are installed Additional Information The ports mentioned earlier are the recommended ports During the installation process you are allowed to change the port numbers If you are changing the port numbers
217. ore proceeding with ihe installaton you must ensure the following The Oracle Financial Services Analyical Applications infrastructure OF SAAD must be installed and configured on the machine The FiCserver is running and all other OF SAAI servers are shut down price to start of Ne saluton installa don Please ensure he OF SAN version is 7 3 Node At any point you wish to edt previously entered information you may access De previous screens by clicking on the Previous buton 3 Select the log mode for this installer If Debug is selected the passwords will be printed in the Log File 8 16 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide T Solution Setup Please select the Log Mode required for this Installation Note you select Debug mode the passwords will be printed in the bog fe The log file will be weiten in the path specified in the log4j xmi Sle of the installer Click Next to proceed Enter the 9 digit Customer Identification number provided during the OFSAAI installation Solution Setup The Pre Setup Information window requests for setup information Select the appropriate Oracle Financial Services Analytical Applications Infrastructure layer that has been installed on the machine Example Database Layer Applications Installation 8 17 Solution Setup Invoducton Please choose the OF SAA Layers on which Solution is to
218. ork which is dedicated to support database storage and retrieval The database layer of Infrastructure system can be represented by a single database server The Database Server window within the System Configuration section of Infrastructure system facilitates you to add and modify the database server details on which the Infrastructure Database Application and Web components have been installed A database server can support multiple Information Domains but however one Information Domain can be mapped to only one database layer OFSAA Infrastructure Windows Internet Explorer BEE ORACLE Financial Services Analytical Applications Infrastructure User stuser In i eee Aboul gin Dat 7 PM Last F Connectedto ATON73sT m Server Master DataBase Server Details O Unified Metadata Manager SEY Rules Framework IP Address 10 184 134 147 x oi h Forms Framework Socket Server Port EA Operations OS type I System Configuration FTP C B Serer Details Database Server FTP Details Application Server Web Server Technical Metadata D Business Metadata Staging Area Database Details Drive OLAP Details Information Domain Configuration SegmentMetadata Mapping Password Segment Map Security Hierarchy Security Design OFSAAI Menu Rules Setup Configuration Administration E Advanced Analytics Infrastructure Modify i Next gt Cancel gA AMHM UMM Offline Population Financial Services Applications Port Number User
219. orrect Web layer IP address in OFSAAI_InstallConfig xml file Error code OFSAAI 1099 Cause The name of DB Component server is too big Resolution Provide the correct Database component IP address in OFSAAI InstallConfig xml file Error code OFSAAI 1100 Cause The name of Application or Web server is too big Resolution Provide the correct Application layer and Web layer IP address in OFSAAI InstallConfig xml file Error code OFSAAI 1101 Cause The name of Database or Web server is too big Resolution Provide correct Database layer and Web layer IP address in OFSAAI InstallConfig xml file References 11 31 Error code OFSAAI 1102 Cause Incompatible Operating System Resolution Make sure the Operating System given in the license key is same as that of actual OS Use uname command to check the Operating System Error code OFSAAI 1103 Cause Oracle Driver files not found Resolution Provide path up to lt ORACLE_HOME gt jdbc lib in ABS_DRIVER_PATH tag of OFSAAI _InstallConfig xml For ORACLE 11g ojdbc6 jar must be present in lt ORACLE_HOME gt jdbc lib Error code OFSAAI 1104 Cause The SqlServerDriver files not found Resolution Provide proper path in ABS_DRIVER_PATH in OFSAAI InstallConfig xml For ORACLE 11g ojdbc6 jar must be present in lt ORACLE_HOME gt jdbc lib Error code OFSAAI 1105 Cause The DB2 Driver files not found Resolution Provide pr
220. ort PATH View the details of the issues its cause and resolution specific to the error code Repeat the step to find an answer to any other errors that you notice during installation If you are not able to resolve the issue even after following the steps provided in resolution you can contact support oracle com along with log files and appropriate screenshots Error Code Dictionary Error code OFSAAI 1001 Cause Unix shell is not korn shell Resolution Change the shell type to korn Use chsh unix command to change SHELL type Shell type can also be changed by specifying shell path for the Unix user in etc passwd file Note chsh command is not available in Solaris OS Error code OFSAAI 1002 Cause No proper arguments are available 11 10 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Resolution Provide proper arguments Invoke Setup sh using either SILENT or GUI mode For example Setup sh SILENT or Setup sh GUI Error code OFSAAI 1003 Cause JAVA_HOME bin not found in PATH variable Resolution Import lt JAVA_HOME gt bin into PATH variable For example PATH JAVA_HOME bin PATH export PATH Error code OFSAAI 1004 Cause File profile is not present in HOME Resolution Create profile in HOME i e in the home directory of user Error code OFSAAI 1005 Cause File OFSAAInfrastructure bin is not pres
221. ort type name as mentioned in the wsdl file SESSION_MAINTAIN_PROPERTY This could be given as also USERNAME User name to access the web services Enter if no user name is required Post Installation Configuration 4 81 PASSWORD Password to access the web services Enter if no password is required SWEBSERVICESTYLE This can take either rpc in case of DII mode of invoking web services or stub in case of static mode This is a mandatory parameter STUBIMPLEMENTATION Fully qualified class name package name classname Attributes for OPERATION tag Ensure that the operation tag attributes are repeated for each of the operation tags CODE Should be unique within the Webservice tag NAME The name of the Function that is to be called by the wsdl file SOAPACTION The URL for the Operation to access This is associated with the Operation tag of the wsdl file STYLE This can take rpc if the web services invoking is in DII mode or stub if it is in static mode This is a mandatory parameter PACKAGENAME Represents the JAXB package of input object Attributes for INPUT tag ORDER The sequential number of the INPUT tag Should start from 0 This is in line with the input order of the arguments that the API accepts which is called by this operation PARAMNAME Input parameter name to be called by the wsd file ARGTYPE Input Parameter Data Type If the input argument type is complex object spe
222. p Configuration j 2 Administration j e amp Advanced Analytics Infrastructure gA AMHM UMM Offline Population Modify Cancel Financial Services Applications Password The Application Server window is displayed in the Add mode when accessed for the first time during the installation process to enter the application server setup details Subsequently the window is displayed in View mode providing option to only update the defined application server details Modify Application Server Details You can update the pre defined Application Server details and FTP SFTP details in the Server Master window To update the existing application server details 1 Select Modify button from the Server Master window The window is refreshed and enables you to edit the required data in the fields 2 Update the Application Server details as tabulated Note The data in some of the fields are auto populated with the pre defined Application Server details Ensure that you edit only the required fields System Configuration 6 7 Field Description IP Address Enter the new IP address of the application server Note the following If the IP Address of Application server is changed in any of the following two scenarios contact Infrastructure Support for help n Change in IP Address of the Application server machine in use Application server is physically moved from one machine to another FTP SFTP Select the op
223. plication Layer Pre install Summary C Databse Layer L Web Layer Please Choose the option to configure Administrative Reports Yes O No Along with appropriate Oracle Financial Services Analytical Applications Infrastructure layer select Administrative Reports to configure the Administrative Reports application Applications Installation 8 23 Note e For a single tier Oracle Financial Services Analytical Applications Infrastructure 7 3 installation you must select App Layer Web Layer and DB Layer For a multi tier Oracle Financial Services Analytical Applications Infrastructure 7 3 installation select the corresponding layer installed on the machine e Incase Admin BI is already configured through the previous product installation the subsequent product installation without Admin BI option may alter the existing Admin BI configuration settings 6 The following window will be displayed which will prompt to select the infodom from list of infodoms present in the setup enter segment code and enter the application schema s TNS name Segment code should not exceed 10 characters Solution Setup Specify the segment code maped to the above nfodom CEVSEO TNS Name for Appication Schema infedom Database EPMDEV Eross 7 The Pre Setup Information window requests for the Oracle Business Intelligence installed host machine IP port number and context name 8 24 Oracle Financial Services Analytical Applicatio
224. port changes to take effect a re start of all Infrastructure servers is required Note e Do not execute the PortC jar with CMD option in the nohup mode e These port changes are done only on the Infrastructure web components and not in the Web container installation directory Infrastructure Application deployed directory where EAR WAR files are deployed Thus after the port changes on the Infrastructure web components are done you will need to re create the EAR WAR files and re deploy these files Modify Web Server Port The Web Server Port is the same as the Servlet Port In the event you wish to change the servlet port after the installation process you must follow the same process as earlier in the Port Changes section This will change the servlet port in the Infrastructure application Follow the steps explained in the Starting Infrastructure page 5 1 to restart Infrastructure Servers Re start WebSphere Tomcat WebLogic After restarting check the connectivity from Servlet URL lt http lt IPaddress gt lt PortNumber gt lt context name gt servlet com iflex fic ficml FICMaster gt The status should be successful for all the services OFSAAI Setup Information Fetching Tool Executing the SetupInfo jar file available in the FIC_HOME path will help you retrieve the related information about the OFSAAI Set up such as Operating System Name and version Database Type and Version OFSAAI architecture Log file location
225. port would be configured during Profile creation For more details see WebSphere HTTPS Configuration section page 4 38 This needs to be given as the servlet port during Installation For Tomcat the HTTPS port would be configured in server xml file under lt Tomcat installed directory gt conf For more details see SSL Port Configuration page 4 51 This needs to be given as the servlet port during Installation If Infrastructure Application needs to be configured for HTTPS SSL note the HTTPS port that would be configured in Weblogic during Domain creation For more details see Weblogic HTTPS configuration page 4 45 This needs to given as the Servlet port during Installation The path in which the EAR WAR file would be deployed in Web Container The java Home Path on all machines The Infrastructure License Key and alphanumeric Customer Code that has been made available to you If not contact Support for more information Servlet Port Configuration 2 16 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Servlet Port refers to the port number on which the Servlet engine is running The default port for WebSphere WebLogic and Tomcat are 9080 7001 8080 respectively If you use a port number that is different from the default value you must configure the port immediately after installation Contact your Web Application Server Administrator for m
226. pplication list within the Map block e Map the two required sources from the Available Sources list by moving it to the Source Applications block e Click Save after mapping is completed Data Sources Windows Internet Explorer Woe Financial Services Analytical Applications Infrastructure User qtuser ORACLE amp amp Data Integrator Source Designer g Define Applications B Ao Application Name Descriptio BOTEA ratrie O RDBMS Real Application Custers Type Local ra 3 Map E amp Application oELAPe m Available Sources Source Applications Available Sources EM Mapped Sources F ogists B a Local intranet R10 Generate Source Model for the each Source created e Inthe Map block select the required source from the Source applications list and click the Generate source model icon Generate Source Model Webpage Dialog window appears e Select the Erwin or Catalog option e When Catalog option is selected the source model is generated by establishing a JDBC connection and reading the database metadata Optionally specify the required filters for table names e When Erwin option is selected specify the path of the Erwin data model e Generate the model by clicking the Generate icon Defining Application Sources A 3 Z Generate Source Model Webpage Dialog Generate Source Model amp Generate Source Model A Starts with Contains
227. pplications Infrastructure OFSAAI Installation and Configuration Guide e The User ID to be specified for data source with FICMASTER as JNDI name should be the Oracle user ID created for the config schema Select the new Data Source and click Targets tab Verify AdminServer option and click Save Create a New JDBC Data Source Create GridLink Data Source If you have selected the option New gt GridLink Data Source while creating the Data Source you can directly specify the JOBC URL as indicated You also have the option to select Generic Data Source or Multi Data Source while creating a Data Source For more information refer Create Data Source page 4 13 or Configure Multi Data Sources page 4 20 Post Installation Configuration 4 19 Create a New JDBC Gridlink Dasta Source Next Cance IDE GridUink Data Source Properties The following propertes be used to ent y your new OOC Gadlirk date soure het Catabese type would you lke to select Database Type ade Next Cance Ensure that the JNDI Name field is specified in the format jdbc infodomname and XA Driver checkbox is not selected Click Next Create a New JOSC Gr dLink Data Source Beck Next Cance Connection Properties Define Comnecton Propertes Enter Complete IOOC URL for Gricuink diptabone Complete JDOC URL hat database account user mame do you mant to use to Create Getabese comectors Database User Name hat s the database account password to use
228. pport Structure Oracle customers have access to electronic support through My Oracle Support For information visit http www oracle com pls topic lookup ctx acc amp id info or visit http www oracle com pls topic lookup ctx acc amp id trs if you are hearing impaired 1 About this Manual 2 Pre Installation Configuration The list of pre configurations required to install and run the OFSAAI V 7 3 Infrastructure is stated in this chapter Further the installation process requires certain environmental variables to be set prior to starting the installation Ensure the following requirements before installation You are requested to refer to the Release Notes for any updates on hardware or software requirements 3 Infrastructure Installation The following information helps you to install the Infrastructure Components xiii Note The OFSAAI 7 3 installation is supported only in US English 4 Post Installation Configuration Once the Infrastructure installation is completed successfully certain post installation steps are required to set configuration parameters These configuration parameters are distributed across the machines on which Infrastructure Web Application and Database components have been installed Note e Ensure to clear the application cache prior to the deployment of Infrastructure and Application Service Packs One off patches This is applicable to all Web Servers WebSphere WebLogic Tomcat and OS combination
229. ppserver log under FIC_APP_HOME common FICServer logs displays error message resembling java lang Exception TripleDES cpptripledes Library not loaded check whether JAVA_BIN path selected during installation is same as mentioned in this Oracle Financial Services Analytical Applications Infrastructure Installation and Configuration Guide When logging into OFSAA Infrastructure with valid user id and password pop up window displays message as cpptripledes could not be loaded Applicable if Websphere is chosen as web server libcpptripledes so file should be copied from FIC_WEB_HOME bin into lt WebSphere installation path gt AppServer bin Make sure the Websphere java version is same as mentioned in the Oracle Financial Services Analytical Applications Infrastructure Installation and Configuration Guide Applicable if Tomcat is chosen as web server LIBPATH LD_LIBRARY_PATH should be set to FIC_WEB_HOME bin on the terminal where the tomcat server will be started Make sure the Java version on which Tomcat server is pointing should be same as mentioned in the Oracle Financial Services Analytical Applications Infrastructure Installation and Configuration Guide References 11 5 are started and the application URL is accessed gives an error the page cannot be found or displayed or Could not retrieve list of languages from Server Please contact the system administrator e Ensure OFSAA Infrastructure servers are started and run
230. re Installation 3 3 OFSAAInfrastructure meN License Agreement Welcome to the installation Preinstall Setup Installation and Use of this product Requires Installation Acceptance of the Following License Agreement I install Complete Warning This Software System is protected by Intemational copyright laws Unauthorised reproduction or distribution of this Software System or any portion of it may result in severe civil and criminal penalties and will be prosecuted to the maximum extent possible under the Law ORACLE FINANCIAL SERVICES gooept the terms of the License Agreement C do NOT accept the terms of the License Agreement InstallAnyewhere a 2 The License Details window is displayed with the details such as the Operating System Relational Database and Licensed Locale 3 4 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 3 OF SAAInfrastructure f O X License Details Details of License Key Provided Prelnstall Setup Installation Install Complete Relational Database Oracle Operating System SunOS Licensed Locale en US ORACLE FINANCIAL SERVICES InstallAnywhere Note If there are any discrepancies in the displayed License details with your purchase order exit the installation and contact https support oracle com Click Next The Oracle Database Details window is displayed Infra
231. relevant action Continue with this step until the model upload is successful and the installer takes the user to next step Note Some of the common errors during model upload are Insufficient heap memory on the client machine Possible reason resolution The java memory settings in reveleusstartup sh located in FIC_APP_HOME common FICServer bin directory should be increased Error while getting the Erwin File path Possible reason resolution Restart the FICServer Error in Upload Operation FAILED WHILE SUPER CATEGORY SUB CATEGORY RELATIONS HANDLINGDELETING Possible reason resolution Incorrect Erwin xsl file version in FIC_APP_HOME common FICServer conf directory Incremental Sliced model upload might give errors in case there are NOT Applications Installation 8 11 NULL columns that are being added to a table that already has rows or if the columns that are being dropped have values Check the data model changes excel file for any such cases In such a case take a backup of the table and truncate the table Insert records back into the table with a default value for the NOT NULL column Navigate to the previous window and proceed with the steps mentioned earlier 12 The following window seeks input from the user on whether to create new ETL application source pair or use an existing one In case of upgrade if customer selects an existing application source pair then existing ETL definitions under the source
232. required to install Oracle Financial Service Analytical Infrastructure Control Panel Settings OFSAAT is an internationalized application and therefore if you require the display of the application in the local language the locale settings need to be specified on the client machine Contact your System Administrator for assistance in installing and configuring the language and regional settings Note The availability of local language support is governed by the application license issued Infrastructure Installation Options As explained in the earlier section OFSAAI supports multiple deployment architectures You must choose the architecture that best suits your business and technology needs It is mandatory that you select the scenario architecture before proceeding with the installation The OFSAA Infrastructure application consists of following three layers e The Application layer that hosts the application s business logic e The Database layer that hosts the application s back end components e The Web layer that hosts the applications General User Interface GUI components Each layer constitutes installing its corresponding components Also as mentioned in the following section the components can be installed on a single machine referred to single tier mode or on multiple machines referred to multi tier mode Pre Installation Configuration 2 3 Click the following links to view the section in detail e Sing
233. riate values If no values are required leave the lt param value gt blank lt context param gt lt description gt http Proxy Host lt description gt lt param name gt http proxyHost lt param name gt lt param value gt PROXYHOSTS lt param value gt lt Specify the IP Address or hostname of the http proxy server gt lt context param gt lt context param gt lt description gt http Proxy Port lt description gt lt param name gt http proxyPort lt param name gt lt param value gt PROXYPORTS lt param value gt lt Port Number for the Proxy Server gt lt context param gt lt context param gt lt description gt http proxy UserName lt description gt lt param name gt http proxyUserName lt param name gt lt param value gt PROXYUSERNAMES lt param value gt lt User ID To get authenticated by proxy server gt lt context param gt lt context param gt lt description gt http proxy Password lt description gt lt param name gt http proxyPassword lt param name gt lt param value gt PROXYPASSWORDS lt param value gt lt User Password To get authenticated by proxy server gt lt context param gt lt context param gt lt description gt http non ProxyHosts lt description gt lt param name gt http nonProxyHosts lt param name gt lt param value gt NONPROXYHOSTS lt param value gt lt Hosts for which the proxy settings should get by passed Note Separate them by symbol gt lt cont
234. ror code OFSAAI 1120 Cause Error in retrieving AM_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly Error code OFSAAI 1121 Cause Error in retrieving SERVELET_PORT value from database Resolution Ensure that the SETUP_PORTS table is updated properly Error code OFSAAI 1122 Cause Error in retrieving V_APPSERVERIP value from database References 11 35 Resolution Ensure that the SETUP_PORTS table is updated properly Error code OFSAAI 1123 Cause Error in retrieving SERVLETPROTOCOL and WEBCONTEXT value from database Resolution Ensure that the WEB_SERVER_INFO table is properly updated Error code OFSAAI 1124 Cause Unavailability of CREATE SESSION privilege to User Resolution Execute privileges_config_user sql and provide configuration schema name to give required privileges Error code OFSAAI 1125 Cause Unavailability of privilege to user Resolution Execute privileges_config_user sql and provide configuration schema name to give required privileges Error code OFSAAI 1126 Cause Unavailability of privilege to user Resolution Execute privileges_config_user sql and provide configuration schema name to give required privileges 11 36 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1127 Cause The schema is not granted wi
235. rs Infrastructure Web Server Infrastructure Application Server and Infrastructure Database Server components What are the different modes of OFSAA Infrastructure installation Infrastructure components can be installed on a single machine referred to as the single tier mode or on multiple machines referred to as the multi tier mode Is JDK required during installation of OFSAA Infrastructure and can it be uninstalled after OFSAA Infrastructure installation Yes JDK is required during installation of OFSAA Infrastructure as well after installation for the application to work What are the different files required to perform OFSAA Infrastructure Installation e Setup sh e OFSAAInfrastructure bin e CustReg DAT e validatedXMLinputs jar e MyResources_en_US properties e log4j xml e OFSAAI_PostInstallConfig xml e OFSAAI_InstallConfig xml e privileges_config_user sql e XML_Utility jar 11 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Is OFSAA Infrastructure license Application specific Yes OFSAA Infrastructure license is application specific How to get the license key Contact OFSAAI Customer Support at https support oracle com If the execution of Setup sh exits without proceeding with installation what needs to be done e If error message resembles Execute Permission denied then check whether all the files provided for OFSAA Infrastructur
236. ructure Web Application and Database components have been installed Note e Ensure to clear the application cache prior to the deployment of Infrastructure and Application Service Packs One off patches This is applicable to all Web Servers WebSphere WebLogic Tomcat and OS combinations For more information refer Clearing Application Cache page 4 85 section e Download and apply the one off patch 13644250_GENERIC available in the Bug 13644250 This facilitates to populate Sandbox Definitions in a multitier setup This chapter covers the following topics e Configure Resource Reference e Configure WebSphere e Configure WebLogic e Configure Tomcat e Additional Configurations Configure Resource Reference Refer to the required section depending on your WebServer configuration That is WebSphere WebLogic or Tomcat Post Installation Configuration 4 1 Configure Resource Reference in Infrastructure Web Application The web xml file has to be updated with the Information Domain name as the resource reference name An Information Domain refers to a specific area of analysis which consists of stored data models with the related Technical and Business data definitions for processing Configure web xml The web xml file has to be updated with the Information Domain name as the resource reference name Navigate to FIC_WEB_HOME webroot WEB INF Add the Information Domain name in the following block of tex
237. rver in the Infrastructure system maintains the application layer which in turn consists of shared services sub system services and the ICC server to manage the warehouse operations Application Sever within the System Configuration section of Infrastructure system facilitates you System Administrator to maintain the Application Server set up details 6 6 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide You can access Application Server window by selecting System Configuration in left menu and then selecting the Server Details section By default the Application Server Server Master window displays the pre configured application server details in the View mode OFSAA Infrastructure Windows Internet Explorer BEE Financial Services Analytical Applications Infrastructure User stuser ORACLE gin Date 7PM Connecteato ATou7asT Server Master 4A Home ZO Unified Metadata Manager Rules Framework Ef Forms Framework Operations system Configuration B Serer Details Database Server Application Server ee Web Server ne User Id Application Server Details IP Address 10 184 134 147 FTP SFTP FTP Details Technical Metadata Business Metadata Staging Area Database Details OLAP Details Information Domain Configuration SegmentiMetadata Mapping Segment Map Security Hierarchy Security Design OFSAAI Menu Rules Setu
238. s System Status a Health of Running Servers Failed 0 Critical 0 D overloaded 0 T Warning 0 E i Click New and select Generic Data Source option Create a New JDBC Data Source window is displayed You can also select GridLink Data Source or Multi Data Source while creating a Data Source For more information refer Create GridLink Data Source page 4 19 or Configure Multi Data Sources page 4 20 4 14 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Create a New JOOC Data Source Next Cance JDBC Data Source Properties The following propertes m be used to idensfy your new JOOC data source What would you ike to nane you mew JDC date source E ame ATOMSTSOL What POI name would you the to asagn to your mew JOSC Data Source 6 INDI Name jdbc ATCMSTSOL What Gatabese type waid you ike to select Database Type acis 4 Enter the JDBC Data Source name JNDI name Database type and the Database driver name in the respective fields Click Next e The data source name must be provided in the Name field e The JNDI Name field should be in the format jdbc informationdomain e Same steps must be followed to create a mandatory data source pointing to the configuration schema of infrastructure with jdbc FICMASTER as JNDI name e JNDI Name provided should be the same name that will be mentioned in the web xml file of OFSAAI Application
239. s For more information refer Clearing Application Cache page 4 85 section e Download and apply the one off patch 13644250_GENERIC available in the Bug 13644250 This facilitates to populate Sandbox Definitions in a multitier setup 5 Start Stop Infrastructure Services 6 System Configuration 7 Pre Installation Applications Activities Checklist 8 Applications Installation 9 Post Application Installation Activities 10 Uninstall Infrastructure Components 11 References A Defining Application Sources B Third Party Software Related Information Sources xiv e Oracle Financial Services Analytical Applications Infrastructure User Guide e Oracle Financial Services Asset Liability Management OFSALM User Guide e Oracle Financial Services Profitability Management OFSPM User Guide e Oracle Financial Services Funds Transfer Pricing OFSFTP User Guide 1 Introduction Scope About this Manual Oracle Financial Services Analytical Applications Infrastructure OFSAAI is a general purpose Analytics Applications infrastructure that provides the tooling platform necessary to rapidly configure and develop analytic applications for the financial services domain It is built with Open Systems Compliant architecture providing interfaces to support business definitions at various levels of granularity Applications are built using OFSAAI by assembling business definitions or business metadata starting from data model to lower
240. s and so on To execute SetupInfo jar in console 4 74 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 1 Navigate to the path FIC_HOME 2 Enter the command java jar SetupInfo jar After execution the output file location is displayed in the console Encryption Changer This utility helps you to regenerate the new AESCryptKey ext file and encrypt all the encrypted values of the OFSAAI setup according to the new key To execute EncryptC jar in console 1 Navigate to the path FIC_HOME 2 Enter the command java jar EncryptC jar A confirmation message is displayed after execution Once executed you need to create and deploy the EAR WAR file depending on the configured Web Application Server For more information refer Post Installation Configuration page 4 1 Configuring HTTPs Certificate information Update the following section from FlCWeb cfg file with the HTTPs certificate related details File path is lt OFSAAI DeploymentPath gt lt ContextName ear gt lt ContextName war gt conf FlICWeb cfg You need to change OFSAAI DeploymentPath in the staging area where you build the EAR file SFIC_WEB_HOME webroot conf FICWeb cfg When you deploy the EAR this will have the change The following properties are to be uncommented for a HTTPS setup and he provider for websphere setup com ibm jsse IBMJSSEProvider DD PROTOCOL PROTOCOL DD TR
241. s script Error code OFSAAI 1138 Cause Resolution Exception while taking input to copy AESCryptKey ext Check the message in InfrastructurePreValidations Log Error code OFSAAI 1139 Cause Resolution No License key Ensure that License key is saved in OFSAAI_InstallConfig xml in the LICENSEKEY tag References 11 39 Error code OFSAAI 1140 Cause No Customer Identification Number Resolution Make sure Customer code is saved in OFSAAI_InstallConfig xml in CUSTID tag Error code OFSAAI 1141 Cause Error occurred during license key validation Resolution Ensure that License key is present in OFSAAI_InstallConfig xml and license key provided during the shipment or license key downloaded from EDELIVERY are exactly the same Error code OFSAAI 1142 Cause Installation file missing Resolution Ensure that all the Installation files are intact The files are CustReg DAT log4j xml MyResources_en_US properties OFSAAI_ InstallConfig xml OFSAAInfrastructure bin Setup sh and validateXMLInputs jar Error code OFSAAI 1143 Cause Missing pre requisite Resolution Check the InfrastructurePreValidations log to properly set the pre requisites Error code OFSAAI 1144 Cause Unable to locate profile in the USER HOME area Resolution Make sure that profile is present in the HOME 11 40 Oracle Financial Services Analytical Applications Infrastructure OFSA
242. sassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing If this is software or related documentation that is delivered to the U S Government or anyone licensing it on behalf of the U S Government the following notice is applicable U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsi
243. save the server details e Ensure the input user id password and share name are correct e Ensure FTP SFTP services are enabled e Have atest FIP SFTP connection made and confirm if they are successful During Information Domain creation the message Please create a database and then create the information domain appears What has to be done Information Domain is mapped to only one Database and thus before the creation of Information Domain at least one database details would need to exist ConnectToDatabase FatalError could not connect to the DB server during startup of backend engine message server e Verify whether connection to the Config schema can be established through sqlplus e Verify Config schema password is modified post installation e Ensure oracle database alias name created for oracle instance and oracle service name are same e Ona multi tier Installation mode ensure TNSNAME and SID are the same in both the Application and Database Layers The message Fatal Error failed to get user ID from LibSmsConnect appears during the startup of backend engine message server What has to be done Ensure Reveleus sec file exists under the FIC_HOME conf directory where the Database components are installed Does OFSAA Infrastructure Application support LDAP authentication OFSAA Infrastructure supports LDAP configuration and authentication Further instructions refer to Oracle Financial Services Analytical Applica
244. sent and execute profile The following log files are generated in the Infrastructure Installation Directory e OFSAAInfrastructure_Install log provides the status of the installation of Infrastructure components e lt User defined gt log The log name specified in Log4j xml provides the status of execution of scripts creation of tables and port changes If the logs report a successful installation proceed with the post installation activities If you observe any Warnings Errors Exceptions reported in either of the logs do not proceed with the post installation and contact Oracle Support to address the reported issues GUI Mode Installation The GUI Mode Installation is supported both in Single and Multi tier architectures The following section explains the single tier GUI installation Process for multi tier 3 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide installation varies depending on your configured setup and some of the noted instances are indicated appropriately When you have executed the Setup sh GUI file in Hummingbird Exceed the following window is displayed ORACLE FINANCIAL SERVICES Copyright 1993 2012 Oracle and or its affiliates All rights reserved After initialization the License Agreement window is displayed 1 Select I Accept the terms of the License Agreement option and click Next to continue Infrastructu
245. setting for Java Heap to Xms512m Xmx1024m Example if z SLOGGING MANAGER then JAVA_OPTS S JAVA_OPTS Xms512m Xmx1024m Djava util logging manager org apache juli ClassLoaderLogManager else JAVA_OPTS JAVA_OPTS Xms512m Xmx1024m LOGGING MANAGER fi Note The settings are base minimum and will need to be incremented 4 64 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide taking the deployment metrics into account The increments are usually handled in multiples of 128mb for heap and 64mb for stack WebLogic Memory Settings Perform the WebLogic Memory Settings as follows 1 Folder lt DOMAIN_HOME gt bin File set DomainEnv sh This file can be edited for setting customized memory settings and garbage collector settings depending on the available hardware configuration Change the memory setting for Java Heap to Xms512m Xmx1024m Example if S JAVA_VENDOR Sun then WLS MEM ARGS 64BIT Xms512m Xmx1024m export WLS MEM ARGS 64BIT WLS MEM ARGS 32BIT Xms512m Xmx1024m export WLS MEM ARGS 32BIT else WLS MEM ARGS 64BIT Xms512m Xmx1024m export WLS MEM ARGS 64BIT WLS MEM ARGS 32BIT Xms512m Xmx1024m export WLS MEM ARGS 32BIT fi Folder common bin File CommEnv sh Example JAVA_VM MEM ARGS Xms256m Xmx1024m Note The set
246. solution Check the exception message to resolve the issue Error code OFSAAI 1061 Cause Database layer is not installed first Resolution Install the Database layer first Error code OFSAAI 1062 Cause Failed to load driver for JDBC connection Resolution Check the exception message to resolve the issue Driver used for ORACLE oracle jdbc driver OracleDriver References 11 23 Error code OFSAAI 1063 Cause Failed to connect to the Database Resolution Check the exception message to resolve the issue Error code OFSAAI 1064 Cause Error while executing command for disk space Resolution Ensure that the df k command is executable Error code OFSAAI 1065 Cause Not enough space in your installation mount Resolution Make sure you create space mentioned in the InfrastructurePreValidations Log file Error code OFSAAI 1066 Cause Failed to delete locales related files Resolution Check the exception message logged in InfrastructurePreValidations Log file Error code OFSAAI 1067 Cause Error occurred while trying to find the locale info Resolution Ensure that en_US UTF 8 or en_US ISO8859 1 locales are installed 11 24 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1068 Cause Error while getting locale installed in system Resolution Ensure that locale a command is
247. source pair into which ETL definitions will be deployed Click Next to proceed Applications Installation 8 13 Solution Setup ETL AppacatonsSource Mapping Select the target ETL Application Source into which the ETL Degnitions will be 14 This panel displays all the pre installation summary Please verify all details and proceed Click Install to proceed 15 This panel displays the installation process Please wait until it completes 8 14 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Solution Setup Installation is in progress This process may take several minutes Please Wait Extracting duplicates 16 The following window displays the completion of installation of the Oracle Financial Services Hedge Management Product Setup Click Done to exit Solution Setup instaladon 1s complete Your instataton log has been writen to AA DSRNA bog Machine B Product Database Layer Procedure 1 To begin Oracle Financial Services Analytical Applications installation execute Setup sh Applications Installation 8 15 Copyright 1993 2012 Oracle andie ts affiliates All rights reserved 2 Upon invoking the installer the Introduction window will display the pre requisites for installation Ensure that the pre requisites are satisfied before you proceed Teis user interface will guide you hrough the soktion setup Bef
248. sources Advanced Settings for Data Source 1 Select the new Data Source created The Settings for lt Data Source Name gt window is displayed Select Connection Pooling tab given under Configuration 2 Go to the Advanced option at the bottom of the page and select the Test Connection of Reserve checkbox Enables WebLogic Server to test a connection before giving it to a client To check whether the data source is valid select the Data Source name For example FICMASTER 4 24 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Summary of JDBC Data Sources A OBC cata source is an object bound to the JWI tee that provides database connectvity Prough a pool of IDEC comectons Applicators can look up a data source on the JOI tree and then borrow a database connecton from a data source Ths page summarizes the JDBC data source objects that have been created n ts donan P Customize this table Osta Sources filtered More Columns txist News p Showing 1to Sof Previous Next New y Delete Showing 1t090f9 Previous Next 3 Select the server and click Test Data Source Settings for FICMASTER Use this page to test database connections in tis DSC data source P Customize this table Test Data Source filtered More Columns Exist Test Date Source Showing ito 1of1 Previous Next Test Osta Source Showing ito Lof 1 Previous Next A m
249. ssing the Excel Upload functionality Therefore the Web server user Weblogic Websphere or Tomcat must have the read write permissions assigned to facilitate the creation of ExcelUpload folder and its sub directories in the App Layer gt ftpshare gt STAGE path You can also create the ExcelUpload folder manually in the App Layer gt ftpshare gt STAGE path and the read write permissions can manually be given for the Webserver user to access the Excel Upload functionality 1 Perform a manual SFTP through PuTTY from Application layer User profile to Web Server User profile which are present on different machines Example lt App Layer path gt scp nohup out lt user gt lt Web Server path gt export home lt user gt 2 Specify Yes when prompted for permission to add entry into known_host file with the options Yes No Always 3 A confirmation message is displayed Permanently added lt Web Server path gt RSA to the list of known hosts Post Installation Configuration 4 57 4 Repeat the same process and perform manual SFTP from Web Server User profile to Application Layer User profile Once the entries of OFSAAI Application and Web Server machine s host key has been populated in the known_host files on both the machines you can perform Excel Document upload successfully 1 Configuration for Dimension and Hierarchy Management These configuration changes are applicable when the Dimension Management
250. stallation Configuration 4 53 are required to save these mappings again Report Display Configuration The installation process automatically sets the configuration parameters for report display in DynamicServices xml Do the following to set the display variable 1 Log on to the machine where Hummingbird Exceed has been started 2 Set the DISPLAY variable to lt IP address where Hummingbird Exceed is started gt lt Passive communication Port set in Hummingbird Exceed gt 0 3 Execute the command echo DISPLAY from the command prompt The value returned must be replaced in the WINDIR parameter in DynamicServices xml The value returned must be replaced in the WINDIR parameter in DynamicServices xml The DynamicServices xml file is present in lt OFSAAI Installation Directory gt conf as shown below 1 Websphere Weblogic lt OFSAAI Application Deployment Area gt lt contextname gt ear lt contextname gt war conf in the web server 2 Tomcat lt OFSAAI Application Deployment Area gt lt contextname gt war conf in the web server There are two instances of WINDIR parameter in DynamicServices xml You must replace both the instances and then restart the servers for the changes to take effect Example export DISPLAY 10 80 193 34 2 0 home lt user gt echo DISPLAY 10 80 193 34 2 0 where 10 80 193 34 is the client machine from which you are starting all the servers The value of WINDIR in DynamicServices xml
251. stallation directory gt user_projects domains lt domain name gt bin and execute the command startWebLogic sh d64 Note If WebLogic is already running access the WebLogic Admin Console Stop amp start the application lt context name gt ear Starting Tomcat Application On the machine in which Tomcat is installed navigate to lt Tomcat_Install_ Directory gt bin and execute the command catalina sh run 3 Start ICC server On the machine in which Infrastructure default Application components have been installed navigate to FIC_HOME ficapp icc bin and execute the command iccserver sh Note Only Infrastructure Default Application Server would hold ICC component 5 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 4 Start Back end server On the machine on which Infrastructure Database components have been installed navigate to FIC_DB_HOME bin and execute the command agentstartup sh and start Agent server Optional You can also start Back end server using the command nohup agentstartup sh amp Note This agent internally starts the Router Message Server OLAP data server and AM servers 5 From a client workstation open the client browser and provide the URL as http or https lt IP address gt lt servlet port gt lt context name gt login jsp For example http 10 80 122 228 8888 ofsaai login jsp Note If https configur
252. stores TFM Database Model XML files and Table Creation scripts e Business Metadata tab which consists of path to the business logic XMLs such as Cube Configuration files and Hierarchy Parentage files e Staging Area tab which stores the path to FLAT files data files which can be loaded through Data Integrator This is the only path that is not tagged to any Information Domain Enter the FTP details in the technical Metadata Business Metadata and Staging Area tabs as tabulated The Technical Metadata tab is selected by default and the details specified here are replicated as default values to Business Metadata and Staging Area tabs Field Description Drive Specify the physical path of the FTP SFTP shared directory Drive For example e dbftp The FTP share directory path must have a at the end of the directory Port Number Specify the database FTP SFTP port number By default the SFTP port number is 22 and can be changed if the port is enabled User ID Specify the user ID that is used to perform an FTP SFTP in the machine where the database server is located It is mandatory to specify the FTP SFTP User ID Password Enter the password which is same as the specified password for FTP SFTP user ID by the administrator Note The password is represented by asterisk for security reasons Ensure that there are no special characters in the password specified 4 Click Next and enter the Security Details as
253. structure Installation 3 5 OFSAAInfrastructure TON Oracle Database Details License Preinstall Setup Installation B install Complete ORACLE FINANCIAL SERVICES InstallAnyerthere 1 Enter the Oracle Config schema password in the Oracle Password field 2 Select the locale installed on the OFSAAI Database Server from the list Note For a multi tier installation the Locale selection option will be available while installing the Database components click Next 4 The Default Infrastructure Administrator and Authorizer User Password window is displayed 3 6 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 5 OFSAAInfrastructure f for Default Infrastructure Administrator and Authorizer User Password License Enter requested information Preinstall Setup installation Install Complete Please enter password for default Infrastructure administrator user SYSADMIN Please re enter password for default Infrastructure administrator user SYSADMIN ORACLE reneeen FINANCIAL SERVICES Please enter password for default Infrastructure authorizer user SYSAUTH InstallAnyethere EE 1 Enter the password for SYSADMIN user 2 Enter the password for SYSAUTH user You will need to re enter the passwords again for confirmation Click Next to continue The Application Database Web Component Details window
254. t BUILD SUCCESSFUL Time taken 3 The EAR file lt contextname gt ear is created on the machine on which Infrastructure Web components are installed under FIC_WEB_HOME directory Note This process overwrites any existing version of EAR file that exists in the path Deploy WebSphere EAR Files Perform the following steps to deploy Infrastructure application in WebSphere Files Deployment 1 Start WebSphere profile by navigating to the path Post Installation Configuration 4 29 lt Websphere_Installation_Directory gt IBM WebSphere A ppServer profiles lt Profile _Name gt bin and execute the command startServer sh server1 2 Open the following URL in the browser window http lt ipaddress gt lt Administrative Console Port gt ibm console https if SSL is enabled The login window is displayed Login with the user id that has admin rights somes cra i Bo Log in to the console User 10 ME Mote Afar rome pens ot nedre the mrem will log po ot edom oty ond ath you te wgn ogon 3 From the left menu select Applications then New Application The New Applications window opens Select New Enterprise Application option miny ated Shom Comore View AM tasks i page uea Apelu atime E Gaded Actribes Ner Appii ation 8 Servers Ties page provides nls to Create new anchcabons of Offerert types B teokcaters i mall a Neve A Man ten beg 8 sophcabon Types B tervees BRetowrces Fs ra
255. t at the end of the web xml file lt resource ref gt lt res ref name gt jdbc lt INFORMATION DOMAIN NAME gt lt res ref name gt lt res type gt javax sql DataSource lt res type gt lt res auth gt Container lt res auth gt lt resource ref gt Here lt INFORMATION DOMAIN NAME gt is the name of the Information Domain you have created e This block of text must be repeated for each of the information domains that are created e The sample bundled with web xml has ORDEMO entered in the lt INFODOM NAME gt tag This needs to be replaced with the information domain created for the application installation Configure Resource Reference in WebSphere Application Server Create JDBC Provider 1 Open the following URL in the browser window http lt ipaddress gt lt administrative console port gt ibm console https if SSL is enabled The login window is displayed Login with the user id that has admin rights 2 Expand the Resources option in the left hand menu Click JDBC gt JDBC providers option The JDBC Providers page is displayed 4 2 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide ernest Vem A tener Clore pepe mekane me C B eted Actrvmer 300c providers Pabi heip Fee faig help thorn aten B seren Une this pope to edt properes of e OOC orovider The JORC provider sipot encapeulites the select o aid label o bet Tech IOC dwr erelemerteton d
256. t ensure the following The Oracle Financial Services AnalyOcal Appicatons infrastructure OF SAA must be installed and configured on the machine The FiCserver is runeing and all other OF SAA servers are shut down price to start of he saluton installason Please ensure he OF SAN version is 7 3 Node Al any poira you wish to edt previously entered information you may access Me previous screens by clicking on the Previous buton 3 Select the log mode for this installer In case the Debug is selected the Passwords will be printed in the Log File Click Next to proceed Solution Setup Please select the Log Mode required for this Installation Note E you select Debug mode the passwords will be printed in the bog fle Thee log file will be watten in the path spectiod in the log4 xr He of the installer 4 Enter the 9 digit Customer Identification number provided during the OFSAAI installation 8 22 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Solution Setup Click Next to continue The Pre Setup Information window requests for setup information Select the appropriate Oracle Financial Services Analytical Applications Infrastructure layer that has been installed on the machine Example Web Layer Solution Setup Introduction Please choose the OF SAMI Layers on which Solution is to be installed Pre install Configuration C Ap
257. t performed during the data load Once you have updated all the required information click Save to save the Database Details OLAP Details OLAP or Online Analytical Processing is an approach to swiftly answer multi dimensional analytical queries Any database configured for OLAP uses a multidimensional data model allowing for complex analytical and ad hoc queries with a rapid execution time OLAP Details in the System Configuration section facilitates you to define the OLAP details after you have configured the OLAP server within the Infrastructure System The Infrastructure design makes it mandatory for the System Administrators to define the OLAP details which is usually a onetime activity Once defined the details cannot be modified except for the user credentials 6 18 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide OFSAA Infrastructure Windows Internet Explorer Cle Financial Services Analytical Applications Infrastructure User stuser ORACLE Connectedto ATOw73sT W OLAP Details d Home G OLAP Details SQ Unified Metadata Manager SEY Rules Framework Server IP 10 184 108 74 Sf Forms Framework Type SQLOLAP Mm Operations B system Configuration E B Serer Details Userld rhelolap Database Server Password seeeeees Application Server Web Server Database Details OLAP Details Information Domain Configuration SegmentMetadata Mapping Segment Map S
258. t the following pre installation activities checklist is completed successfully y Tasks Pre Installation Configuration 2 7 General Ensure that the pre requisite base software as outlined in the Environment page 2 2 section have been installed and administered on each machine Regardless of the choice of Single Multi tier option each machine that is used should have the minimum configuration of two CPUs and 8 GB RAM Configuration Make sure that you have approximately 1 4 GB hard disk space in your tmp mount This is required for Infrastructure installation and will be released once the installation is complete You must have user accounts created on the environment machines on which Infrastructure components will be installed Note that the shell prompt set for these user accounts should be korn shell These user ids will be used to log on to the machines and initiate the installation process By default the home directory would have 755 UNIX permission Make sure that these newly created user accounts also have 755 UNIX permission This user should not be the same user used for Oracle database application installations Note This section is applicable if the OS is LINUX The total file descriptor for the user must be set to a minimum value of 9216 To check the total file descriptor use the following command ulimit n The number of processes value for the UNIX user account being used must be set to a minimum of
259. t the time localization set up 3 Specify the User ID and Password For Cube Creation based on the selected OLAP DB Type Ensure that there are no special characters and extra spaces e For SQLOLAP the User ID should be created in Microsoft Windows with appropriate privileges for cube creation e For EXPRESS the User ID should be created in EXPRESS with appropriate privileges for cube creation 4 Specify the User ID and Password For Cube Viewing based on the selected OLAP DB Type Ensure that there are no special characters and extra spaces Enter the FIV User ID to view the cube If ESSBASE is selected as the database type the cube can be viewed in OBIEE reporting server 5 Click Save to save the OLAP Details Modify OLAP Details By default the OLAP Details screen displays the OLAP details specified during the installation The defined OLAP details are not editable and you can only modify the user privileges for Cube Creation and Viewing based on the selected OLAP DB Type System Configuration 6 21 For more information see Add OLAP Details page 6 19 Once you have updated all the required information click Save to update the OLAP Details Information Domain Information Domain within the Infrastructure system refers to a specific area of analysis which consists of stored data models with the related Technical and Business data definitions for processing An Information Domain forms the backbone for all the dat
260. tainer managed persistence CMP Note For RAC configuration provide the RAC url specified during installation Example jdbc oracle thin DESCRIPTION ADDRESS_LIST ADDRESS PROTOCOL TC P HOST 10 184 108 91 port 1521 ADDRESS PROTOCOL TCP HOST 10 184 108 92 PORT 1521 LOAD_BALANCE no FAILOVER yes CONNECT_DATA 4 8 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide SERVICE_NAME pqadb Map the J2C authentication alias if already created You can create a new J2C authentication alias by accessing the link given Global J2C authentication alias or you can continue with the data source creation by clicking Next and then Finish Create a data source Create a cata source 1 Enter basic tion Step 2 Select JOBC Select the authentication values for this resource eoa Component managed authentication alias none s for Mapping configuration alias data source none Container managed authentication alias none Step 5 Summary Note You can create a new J2C authentication alias by accessing one of the following links Clicking on a link will cancel the wizard and your current wizard selections will be lost Global J2C authentication alias Security domains When you click Next the Summary window appears Click Finish Post Installation Configuration 4 9 Create a data source Create a cata source
261. tallation_Directory gt A ppServer profiles profile_name gt Execute the following commands Execute manageprofiles sh validateAndUpdateRegistry WebLogic Configuration for Infrastructure Application Deployment You can deploy multiple Infrastructure applications on different domains of a stand alone weblogic application server To create multiple WebLogic Domains in a stand alone server you can use the Domain Creation wizard A domain is the set of files that define the runtime environment At least one domain must exist to run Weblogic Application Server Creation of New Domain in WebLogic 2 22 To create a new domain using Configuration Wizard in WebLogic do the following 1 Navigate to the directory lt webLogic_ Home Directory gt wlserver_10 3 common bin Execute Config sh file The Oracle WebLogic Configuration Wizard is displayed This wizard will take you through the domain creation process Select the Create a new WebLogic domain option and click Next Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide F Fusion Middleware Configuration Wizard x Welcome ORACLE Create a new WebLogic domain Create a WebLogic domain in your projects directory O Extend an existing WebLogic domain Use this option to add new components to an existing domain and modify configuration settings 3 The Select Doma
262. te Tomcat WAR Files The WAR files is required to assemble servlets jsp files web pages and other static content into a deployable unit If Advanced Analytical Applications module has to be accessed using Tomcat as the Webserver you should 1 Delete cssparser 0 9 4 fs jar from FIC_WEB_HOME webroot WEB INF lib 2 Copy cssparser 0 9 5 jar file from FIC_WEB_HOME CSSPARSER to FIC_WEB_HOME webroot WEB INF lib Note If the OS is AIX you need to copy xerces jar file from FIC_WEB_HOME XERCES to FIC_WEB_HOME webroot WEB INF lib The following steps will guide you through the WAR files creation process 1 On the machine in which Infrastructure Web components have been installed navigate to the path FIC_WEB_HOME 2 At the prompt execute ant sh This will trigger the creation of WAR file lt contextname gt war The lt contextname gt is the name given during installation 3 On completion of the WAR files creation a confirmation message will be displayed and you will be returned to the prompt 4 The WAR file lt contextname gt war is created on the machine on which Infrastructure Web components are installed under FIC_WEB_HOME directory Additional Information Post Installation Configuration 4 47 1 This process will not overwrite any existing version of WAR file that exists in the path Rename delete any existing war file 2 Proceed with the following steps for Tomcat WAR Files Deployment page 4 4
263. th minimum 10 MB tablespace Resolution The schema must be granted at least 10 MB tablespace Check the tablespace issuing SELECT MAX_BYTES FROM USER_TS_QUOTAS 1 value stands for unlimited quota Any other value should be converted from BYTE Error code OFSAAI 1128 Cause Error while fetching MAX_BYTES Resolution Ensure that the following statement SELECT MAX_BYTES FROM USER_TS_QUOTAS is executable Error code OFSAAI 1129 Cause The default NLS_LENGTH_SEMANTICS of Oracle instance is not CHAR Resolution Oracle instance must be created with the default NLS_LENGTH_SEMANTICS as CHAR Use following SELECT FROM V NLS_PARAMETER WHERE PARAMETER NLS_LENGTH_SEMANTICS to check the status Also this value must be set in NLS_INSTANCE_PARAMETERS by modifying init ora and restarting the database Error code OFSAAI 1130 Cause Error while fetching NLS_LENGTH_SEMANTICS Resolution Ensure that SELECT FROM V NLS_PARAMETER WHERE PARAMETER NLS_LENGTH_SEMANTICS can be executed References 11 37 Error code OFSAAI 1131 Cause The default NLS NCHAR CHARACTERSET of Oracle instance is not AL16UTF16 Resolution Oracle instance must be created with the default NLS_NCHAR_CHARACTERSET as AL16UTF16 Use SELECT FROM V NLS_PARAMETER WHERE PARAMETER NLS_NCHAR_CHARACTERSET to check the status Error code OFSAAI 1132 Cause Error while fetching NLS_NCHAR_CHARACTERSET Resolution Ensure that SEL
264. the Config schema and Atomic schema in OFSAAI Configuration schema refers to the master schema which stores the Server Details and Configurations required for the Infrastructure to work The configuration schema also stores the Infrastructure security mapping and configurations along with Infrastructure and installed application s common Metadata Atomic schema is specific to an Information domain created which stores all the data and specific metadata for the application s being installed The database users Config and Atomic schema must be created prior to the Installation These database users used by OFSAAI require a set of privileges database permissions Login to the database as sys and connect as sysdba user Execute privileges_config_user sq shared with the Infrastructure install kit to grant all the privileges required for the Config database user Additional privileges for Atomic schema user should be granted post Infrastructure instalation See Post Installation Configuration page 4 1 for further steps for the Atomic schema Note Database cursors needs to be set to minimum 200 Default and Temporary tablespace assigned to Oracle users config and atomic should be allocated with a minimum of 10 MB space To check the OPEN_CURSORS value use the following command select from v parameter where NAME open_cursors To set the OPEN_CURSORS value use the following command ALTER SYSTEM SET OPEN_CURS
265. the lt context_name gt ear file using the command jar xvf lt context_name gt ear Delete the lt context gt ear and lt context gt war file recently created Create a directory lt context_name gt war under lt WEBLOGIC_INSTALL_DIR gt Bea user_projects domains lt DOMAIN_NAME gt ap plications lt context_name gt ear Copy lt FIC_WEB_HOME lt context_name gt war file to lt WEBLOGIC_INSTALL_DIR gt Bea user_projects domains lt DOMAIN_NAME gt ap plications lt context_name gt ear lt context_name gt war Explode the lt context_name gt war file using the command jar xvf lt context_name gt war to get the directory structure 4 40 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Install Application To Install Application open the Install Application Assistant Install Apphcation Assestant Next Cancel Locate deployment to install and prepare for deployment yy archive fle exploded archive drectory or application module Gesorptor that you want to instal You can aiso emer the path of Select the fle pam the appicadon drec tregresents Te applica yor fle n the Pam feld Mote Orvy vaid fie paths are Gsclayed Delon If you Carrot fre you deployment Mes oad your fiels ediy confirm Pat you sopicator comtans he requred Geployment Gesop ters Path oradata2 1035 Oracle Widclewareuser_propects domanns upg 273 apphcations Recently Used Paths ore
266. the Business Data Model Business Data model undergoes changes How does this incremental change get applied to the existing model Modified data model can be uploaded into the system and OFSAA Infrastructure has the ability to compare the changes within the data model with respect to the one already present in the system and enables propagation of incremental changes in a consistent manner 11 8 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide What are the different modes of uploading a business data model OFSAA Infrastructure supports uploading of business data model from client desktop and also by picking up the data model from the server location Can the OFSAAI Configuration Schema password be modified post installation The OFSAAI configuration schema password can be modified post installation OFSAAI application stores the password in the database and few configuration files thus any changes to the configuration schema password would necessitate updating in these Contact OFSAAI Support for more details Does upload of Business Data model depend on Java Memory Business data model upload through OFSAA Infrastructure depends on the Java memory settings on the client and server machines Java memory setting varies with the data model size and the available RAM Please contact OFSAA Infrastructure support for more details Please refer to Configuration for Model Upload Ut
267. the Database Layer The transfer of data among the three servers in Infrastructure takes place through FTP SFTP Hence it is required to have an ftpshare folder in each Infrastructure server Full permissions should be granted to this directory and its sub folders and files by executing the command chmod 777 and then inside the ftpshare execute the umask 0000 command Bind exception port binding issues Can the ports used by Infrastructure services changed after the installation process Port Change utility could be used to have the Port number modified which are currently being used by the Infrastructure application On Further instruction refer to Configuration of Infrastructure Ports page 4 71 Are there any in built system administration users within OFSAA Infrastructure Application The two in built system administration users within OFSAA Infrastructure are e SYSADMN has the administrative powers to configure OFSAAI 11 6 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide e SYSAUTH has the powers to authorize user profiles Does OFSAA Infrastructure Application support both FTP and SFTP OFSAA Infrastructure supports both FTP and SFTP configuration Is it necessary to enable the FTP SFTP services to use the OFSAAI Yes enabling of FTP SFTP services and its ports is a pre requisite step towards using the OFSAA Infrastructure OFSAAI Configuration Unable to
268. the directory where Setup sh has been copied Set the Display Infrastructure Installation 3 1 Environment Variable to point to the client which Hummingbird Exceed running For more information refer Report Display Configuration page 4 54 section e Setup sh SILENT The SILENT mode of installation does not require any simulator In SILENT mode of Infrastructure installation you need to enter the installation parameters in the command prompt Provide the required input data and proceed with the installation On completion of the installation execute the profile and check the installation logs For more information on Silent Mode of installation refer Silent Mode Installation page 3 12 Note Do not execute Setup sh with SILENT option in the nohup mode e Setup sh GUI The GUI Mode of installation requires Hummingbird Exceed to be running to bring up the installation Wizard Panel In GUI mode of installation you need to enter the Installation parameters through the wizard For more information on GUI mode of installation refer GUI Mode Installation page 3 2 In the GUI mode on successful installation of Infrastructure components a confirmation dialog box is displayed with the summary of the Errors Warnings if any during the installation Click Done and close the installer window 6 Navigate to the user path and run source profile for the specified variables to take effect Go to the directory where profile is pre
269. the extracted location of the installer kit e Select released model option in the Silent props file e Perform Silent mode installation 8 32 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 9 Post Application Installation Activities Post Application Installation Checklist e The term EPM apps mentioned in this chapter refers to Oracle Financial Services Funds Transfer Pricing Asset Liability Management Profitability Management Hedge Management and IFRS Valuations Pricing Management Transfer Pricing component e For more information on specific EPM apps v6 0 see their individual Installation Manuals available at http docs oracle com cd E28033_01 homepage htm Once the installation of EPM apps Products are completed you must perform the following steps Note The application cache must be cleared prior to the deployment of Infrastructure and Application Service Packs One off patches This is applicable to all Web Server WebSphere WebLogic and Tomcat and OS combinations e Check the Log file The path and file name specified in the log4j xml e Ignore the following errors in the log file e Error ORA 02260 table can have only one primary key e Error ORA 00955 name is already used by an existing object e Error ORA 00001 unique constraint lt lt UNIQUE KEY NAME gt gt violated Post Application Installation Activities 9 1
270. the files used in Infrastructure are stored in the FTP folders The ftpshare folder contains folders for each Information Domain Each Information Domain folders contains an erwin log and scripts folder For any operation the data needs to be transferred from the client to the database The entities such as Tables are generated in the Database Layer The transfer of data among the Web Application and Database servers in Infrastructure takes place through FTP SFTP Hence it is required to have an ftpshare folder in each Infrastructure server You need to configure FTP SFTP manually and enable communication between the servers by providing App server s FTP SFTP credentials to the Web server and DB server users Each new file that is created in the ftpshare folder of any installation layer should be granted specific explicit permission Configuration for Forms Framework If the webserver is Tomcat copy the jaxrpc jar from the lt OFSAAI Installation Directory gt axis 1_4 webapps axis WEB INF lib and place it in under lt Tomcat Installation Directory gt lib Configuration for Model Upload Utility The Model Upload Utility uploads the Data Model through the command line parameter by executing a shell script file It is used to upload Models that are huge in size The ERwin file that contains the Data Model information must be placed at the following location lt ftpshare gt lt infodom gt erwin erwinXML 4 52 Orac
271. ting the details of mail server in the NotificationConfig cfg file which resides in the path FIC_APP_HOME common FICServer conf Ensure that the authorized User details for whom you need to configure the Message details are included in Administration gt Security Management gt User Administrator gt User Maintenance window Update the following parameters in the NotificationConfig cfg file Parameter Description SMTP_SERVER_IP Specify the hostname or IP address of SMTP Server SMTP_DEBUG_MODE To run SMTP service in Debug mode set value to true otherwise set value to false SMTP_AUTHORIZATION Set to true if SMTP server requires the client to be authenticated otherwise set to false SMTP_USERNAME Username required for logging into SMTP server if authentication is not required use a dummy value SMTP_PASSWORD Password required for logging into SMTP server if authentication is not required use a dummy value SMTP_MAILID If the Messages has to go from a Particular ID that ID need to be added Exchange server forces you set a valid ID that is there in the exchange server Based on Security settings Ensure that the authorized User details are included in Administration gt Security Management gt User Administrator gt User Maintenance window Clearing Application Cache This is applicable to all Web Servers that is WebSphere WebLogic and Tomcat Prior to the deployment of Infrastructure or Application Servic
272. tings are base minimum and will need to be incremented taking the deployment metrics into account The increments are usually handled in multiples of 128mb for heap and 64mb for stack WebSphere Memory Settings Perform the WebSphere Memory Settings as follows Post Installation Configuration 4 65 IE Settings g View All tasks x Close page E Welcome Guided Activities Application servers gt server1 gt Process definition gt Java Virtual Machine atit Specifl E Servers Use this page to configure advanced Java TM virtual machine settings size aj in me B Server Types Configuration Runtime to use WebSphere application servers Pagel More i this of General Properties uee Additional Properties iG B Applications Classpath Custom properties B Services 5 E Resources E Security E E Environment Boot Classpath E System administration E Users and Groups Monitoring and Tuning E Troubleshooting verbose class loading B Service integration C verbose garbage collection upor C verbose aut Initial heap size sia MB Maximum heap size 1024 MI C Run HProf Navigate to Websphere applications server gt Application servers gt server1 gt Process definition gt Java Virtual Machine Change the memory setting for Java Heap as indicated below Initial heap size 512 Maximum heap size 1024 Note The settings are base minim
273. tion 4 39 ORACLE webtogie Server Ainnsrton Con Chaage Center Home Log Out Preferences Gj Record Help a Welcome upg7273 Conmected to View changes and restarts upg7273 tamary uf Dophrymoat s Corsig amon edtng 6 enabled Aare Farges mi SADa be achveted as you Summary of Deployments moaty acd or delete items n ts Goren Control Montoring Domes Structure 9727 i t vrorment Ths page Gaclays a ist of Java EE applicators and standalone applicator modes thet have beer retailed to the Deployments doman installed applicators and modes can be started stonced updated redeployed or deleted for the doman by frst selectins the acpicanon name and using the controls on thes page OTR Sear ty Reales To natal a new applicator o module ty degoters fo targets n tes doman cick the natal bution rteroperabalty Cragrosies P Customize thn table Deployments neal Showrg ito lofi Previous Nest Mow do L System Status Select the Exploded EAR directory after browsing to the directory where it is saved Click Next Explode EAR To Explode EAR perform the following steps 1 Create the applications folder under domain name Bea user_projects domains lt Domain _name gt applications Create lt context_name gt ear file under applications folder Copy the lt FIC_WEB_HOME lt context_name gt ear file to lt WEBLOGIC_INSTALL_DIR gt Bea user_projects domains lt DOMAIN_NAME gt ap plications lt context_name gt ear Explode
274. tion as either FTP or SFTP FTP refers to the transfer of files such as metadata and staging files from one server to another SFTP refers to secure FTP for transfer of files from one server to another Note the following The FTP SFTP option specified during setup is auto populated The FTP SFTP information should be created manually prior to entering the details The application validates the information ensuring that the value in FTP SFTP and Host DB is not blank When there is a change to the FTP SFTP path the old files should be physically moved to the new path The system ensures that all new files are generated transferred into the new path 3 Enter the FTP details in the Technical Metadata Business Metadata and Staging Area tabs as tabulated The Technical Metadata tab is selected by default and the details specified here are replicated as default values to Business Metadata and Staging Area tabs 6 8 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Web Server Field Description Drive Port Number User ID Password Specify the new physical path of the FTP SFTP shared directory Drive For example e dbftp The FTP share directory path must have a at the end of the directory Specify the database FTP SFTP port number By default the SFTP port number is 22 and can be changed if the port is enabled Specify the user ID t
275. tions Infrastructure References 11 7 Installation and Configuration Guide Does OFSAA Infrastructure support multiple languages Yes OFSAAI supports many languages Contact OFSAAI support for more details Does OFSAA Infrastructure provide for any data back up features OFSAA Infrastructure does not have built in back up facility It s recommended external storage infrastructure for backups What kind of security features does your OFSAA Infrastructure provide OFSAA Infrastructure provides security at e Segment Level Users can access only the segment they are mapped to e Application Level Users can perform an operation only if mapped to appropriate role and functions Does OFSAA Infrastructure have the ability to enforce periodic password change OFSAA Infrastructure provides configurable parameters to define number of days after which the user password would expire and then the user is forced to change the password after expiration period What is the password policy followed in OFSAA Infrastructure OFSAA Infrastructure enforces a minimum password length with a combination of Upper and Lower case characters and alpha numeric string Which version of Erwin Data Modeller does OFSAA Infrastructure support OFSAAI support Erwin Data Modeller version 7 1 7 3 Does OFSAA Infrastructure provide mechanism to upload Business Data model OFSAA Infrastructure provides easy to use GUI based Model upload mechanism to upload
276. tions Infrastructure OFSAAI Installation and Configuration Guide again for confirmation Note SYSADMN and SYSAUTH are the two default OFSAAI administrative users created by default Infrastructure Application Database Web component FTP SFTP password The option is displayed if you have specified the value of POST_INSTALL as 1 in OFSAAI _InstallConfig xml file Note For a multi tier installation when the Database component is not getting installed you are prompted to provide the Database Component Details User Name Password and Installation Directory After providing the Database component details you are prompted to provide the Application and Web component FTP SFTP passwords depending on the component being installed Once the Installation is complete there is a log file created in the path mentioned in Log4j xml which consists of the Installation Summary with the number of Fatal Errors Errors Debug Statements Information and Warnings Infrastructure Installation 3 13 EP 10 184 74 53 PuTTY MA structure admin aunchir ar 3 14 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide 4 Post Installation Configuration Once the Infrastructure installation is completed successfully certain post installation steps are required to set configuration parameters These configuration parameters are distributed across the machines on which Infrast
277. to Teste database connectors Password Confirm Password Specify Complete JDBC URL Database User Name and Password Click Finish The created Data Source is displayed in the list of Data Sources Configuring Multi Data Sources A JDBC multi data source is an abstraction around a group of data sources that provides load balancing and failover between data sources As with data sources multi data sources are also bound to the JNDI tree Applications can look up a multi data source on the JNDI tree and then reserve a database connection from a data source The 4 20 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide multi data source determines from which data source to provide the connection When database used is Oracle RAC Real Application Clusters which allows Oracle Database to run across a set of clustered servers then a group of data sources can be created for instances running on set of clustered servers and a JOBC multi data source can be created so that applications can look up a multi data source on the JNDI tree to reserve database connection If a clustered server fails Oracle continues running on the remaining servers 1 Open the following URL in the browser window http lt ipaddress gt lt administrative consoleport gt console The login window is displayed Login with the user id that has admin rights ORACLE WebLogic Server 11g Administration Co
278. ubsequently Under Set standard commands for invoking Java change JAVA_HOME bin to JAVA_BIN Example Edit the following block of text Set standard commands for invoking Java _RUNJAVA JAVA_HOME bin java if Sos400 true then _RUNJDB S JAVA_HOME bin jdb m Change it to RUNJAVA SJAVA_BIN java Sos400 true then RUNJDB SJAVA_BIN jdb H Hh If the Tomcat server is already running it requires a re start after the above configuration is done Configure Servlet Port The Servlet Port specified during the Infrastrcture installation process must be 4 46 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide configured in Tomcat if your web server is Tomcat If you are using the default port 8080 then you are not required to configure the same since it is already configured If you are using a different port number you must first configure the port in the server xml in the conf directory of Tomcat Installation directory The following steps guide you through the configuration process Navigate to CATALINA_HOME conf Open server xml and locate the tag Define a non SSL HTTP 1 1 Connector on port 8080 Against this tag a parameter is specified Connector port 8080 Edit this value to the new port number that was used during the Infrastructure installation process Save your changes in server xml Crea
279. ucture Installation Options 0 c0 cece eee eens e nese eee ee ne eeeeeseneeeneeseeeseneeeneeseeeeetees 2 3 Single Tern stallatoniec i2t tec 0i 2c ccunhiattocnetidccesterentieesl aides ubhduaaeciet hi cterell dt cated e e aaa aaa 2 4 Single Tier Installation with Database Engine on Remote Machine ccccseeeee 2 4 Single Tier Installation with Web Server on Remote Machine ccccccseeseesseeseenee 2 4 Multi Tier Installations cccccitnci adi eee a Sti eek Wie Maes a odd E helen tdinds 2 4 Multi Tier Installation Option Tissi aa aa a A a 2 5 Multi Tier Installation Option Miss aerians aa a a a Nai 2 6 Multi Tier Installation Option ITD cccccecccececsceeeeeenecneeenecneeceeeneceeeeeeaeeseeneeneeenees 2 6 Multi Tier Installation Option V ccccccccccscsseeeecetecneecteceeceeeaecseeneenseeneseseeaseeenas 2 7 Pre Installation Activities Checklist 000 00ccc ccc een rine eiee teens snes tee sneeneetneeeneeetaes 2 7 WebServer Configuration for Infrastructure Application 0 000c cee eect eee eee 2 19 WebSphere Configuration for Infrastructure Application Deployment cccccee 2 19 Creation of New Profile in WebSphere cccccccccccsccceeetseceeenectseenecneeneeeeetaeeseenes 2 19 Manage Applications in WebSphere ccccccccccesecseectecneeeeceteeceeenectaeenecnieeeeeeenaees 2 20 Deletion of WebSphere Profiles cccccccscsccecsteceeeesecnsecnecnseceeneceeeeeseeseseeeenieenees
280. uide code column is not currently present in the data model Leaf Registration procedure which is used to create simple dimension as of 7 3 1 doesn t support alphanumeric code column though alphanumeric columns can be created manually in backend Post Installation Configuration 4 89 5 Start Stop Infrastructure Services Introduction Once the installation of Infrastructure has been completed successfully and the post installation steps are completed the servers must be started Log on to each machine and run the profile file All servers mentioned must be started from the same shell encoding The servers mentioned below are dependent on each other It is mandatory to maintain the order in which the servers are started Allow each of the servers to initialize completely before starting the next server Starting the Infrastructure Server 1 On the machine in which Infrastructure Application components have been installed navigate to FIC_APP_HOME common FICServer bin and execute the following command to start the Infrastructure Server reveleusstartup sh Note e When starting the server the first time it must be done in the foreground to answer prompts Enter the password of the Oracle Configuration schema when it prompts for a system password This password is asked only the first time of starting Infrastructure server e If the Oracle Configuration schema password is changed delete the Reveleus SEC file under FIC_HOME
281. uild cubes Object Migration This module facilitates to migrate all the registered objects along with their dependencies across Information Domains within the same or different database or server SQL Rule This module facilitates to directly manipulate the database using SQL Statements and Procedures Data Quality Framework This module facilitates to define rules and execute them to query validate and correct the transformed data existing in an Information Domain AES Advanced Encryption Standard Encryption algorithm using JAVA has been implemented replacing the existing CPP implementation of the Triple DES algorithm Support of Microsoft Excel 2007 in Excel Upload View Log Enhancements in Operations module which include Search panel modifications and UI changes to display As of date column Log Information corresponding to selected log tables and Status amp User Information pertaining to a particular process User Group Authorization in Administration gt Security Management Sliced Model Upload feature in UMM gt Model Upload Optimizer and Pooling features from Advanced Analytics Infrastructure have been phased out and made available with appropriate Analytical Applications for Enterprise Risk Management Forms Framework module enhancements which include List Control Field Chooser Internationalization of History Table Action Support of Dynamic Breadcrumbs Pagination Hierarchy Browser and Audit History for Mu
282. um and will need to be incremented taking the deployment metrics into account The increments are usually handled in multiples of 128mb for heap and 64mb for stack The following browser settings have to be specified at every client machine prior to accessing the Infrastructure application Open Internet Explorer Select Tools gt Internet Options The Internet Options window is displayed Click the Settings button The Settings window is displayed Select the Everytime I Visit the webpage option Click OK 4 66 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Internet Options General Security Privacy Contert Connections Programs Advanced Home page oe To create home page tabs type each address on Rs own line se about blank Browsing history F 4 Delete temporary files history cookies saved passwords and web form information Search Tabs t belie alan eal Appearance Temporary Internet Files and History Settings Temporary Internet Files Internet Explorer stores copies of webpages images and media for faster viewing later Check for newer versions of stored pages Every time I visk the webpage Ob very time I start Internet Explorer O satomatically O Never Disk space to use 8 1024MB Recommended 50 250M6 Current location C Documents and Settings tusharBh Local Settings Temporary Internet Files History
283. uring Infrastructure Config Schema In the Infrastructure Configuration schema make sure that the following entries are present in Configuration Table PARAMNAME DESCRIPTION PARAMVALUE EXAMPLES AUTHENTICATION TYPE AUTHENTICATION TYPE 2 AUTHENTICATIONTYPE value must be 2 for LDAP ROOTCONTEXT The Root Context for the dc lt Reveleus gt dc lt com gt LDAP Directory ROOTDN The Root dn for LDAP cn lt Manager gt dc lt Reveleus gt directory dc lt com gt ROOTPASS Password for the Root lt secret gt LDAPURL LDAP URL lt Idap 10 80 193 35 389 gt 4 76 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide LDAP_SSL_MODE LDAP in SSL Mode N for non SSL and Y for SSL HASHPASS Should The User password be FALSE or TRUE Hashed When HASSPASS is set as FALSE We need to have the ROOTDN value as uid ORCLADMIN ou Users dc OFSAAI dc com ORCLADMIN is a dummy user it will be replaced dynamically with the logged in user When HASSPASS is set as TRUE We need to have the ROOTDN value as cn orcladmin cn Users dc i flex dc com and proper oracladmin LDAP password as ROOTPASS First OFSAAI connects to LDAP directory using orcladmin user and fetches the login user details and verifies the entered password Note ROOTCONTEXT ROOTDN and ROOTPASS entries should be same as Slapd conf file Configuration of OpenLDAP Files 1 Copy the reveleusS
284. ust have the following information about your Tomcat web server available and handy before you start the installation The Tomcat Installation directory on the machine in which Infrastructure Web components will be installed The path in which the Infrastructure Application files will be deployed in the machine that hosts Tomcat Example For example home revcat apache tomcat 7 0 19 WebLogic related WebLogic Application Server should be up and running Prerequisites A WebLogic Administration User ID having privileges to deploy an EAR file on the machine that hosts WebLogic must be created Uninstall any previously deployed applications hosted in WebLogic This must be done prior to the start of the installation Have the following information available and handy before you start the installation Pre Installation Configuration 2 15 Decide the architecture in which Infrastructure is to be deployed before you start the installation The architecture options are briefly outlined in the Infrastructure Installation Options page 2 3 Identify the machines on which Infrastructure Database Application and Web components will be installed The IP Addresses Hostnames of the machine s in which Infrastructure components will be installed The Full path where Infrastructure will be installed in each of the machines If Infrastructure Application needs to be configured for HTTPS SSL For WebSphere the HTTPS
285. values gt Rule Name Batch_Table_Class_Req Parameter List Null Execute the new Batch Navigate to Batch Monitoring to verify the Batch run was successful The Oracle Financial Services Funds Transfer Pricing Profitability Management Asset Liability Management Pricing Management Asset Liability Management Analytics Transfer Pricing Component and Hedge Management and IFRS Valuations are now ready to be used Oracle Financial Services Analytical Applications Infrastructure v7 3 OFSPA Look up Table Configuration e Erwin model to be extended with the required lookup tables e Columns to be registered as processing keys balance ranges e Post the model change a incremental model upload should be done for the Post Application Installation Activities 9 5 application to reflect the changes If you encounter any problems during setup kindly contact Oracle Financial Services Support OBIEE Installation and Configuration Guide Link Note Refer the following link to down load the OBIEE installation and configuration guide document http www oracle com technology documentation bi_ee html Configuration of FusionApps properties FusionApps properties file is used by Financial Services Applications It is located in WEB INF props under context root It contains the following properties populated by the Application Installers e Date_Format_Count There are a total of 19 supported date formats for the UI This list of
286. will be over written with the packaged definitions Customer can also choose to create a new application source pair and then merge the changes between the packaged definition and their existing definitions offline Please select the required option Click Next to continue Solution Setup ietroducton Do you want to create a new ETL application seurce pair or use the exdsting ane Pre install Comfiguration New applk scevsource par Ensing sppic abor source pair ORACLE FINANCIAL SERVICES If the option New application source pair is selected then the following window will be displayed seeking the application and source name for creation of the same specify all the details required for application and source creation Click Next to proceed Clicking Next will create application and source within OFSAAI This process will take some time depending on the number of entities attributes in the atomic schema This step cannot be rolled back 8 12 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Solution Setup Note ETL Source will be created pointing to the information domain atomic schema that is specified during the installation If the option Existing application source pair is selected then the following panel will be displayed prompting user to select app source pair from the list of pairs already present Select the required ETL application
287. with the new WEB Server IP Host Address Update the OLD IP Host Addresses with the new App Server or Reveleus Server IP Host Address Update the Old APP IP Host Address with the new APP Server IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the Old IP Host Addresses with new APP Server IP Host Address Post Installation Configuration 4 61 Related Files Place Holder Field Updated ficdb conf FICDB cfg ficdb conf am conf FIC_WEB_HOME webro ot conf ficweb cfg FIC_WEB_HOME webro ot conf dynamicservices xml FIC_WEB_HOME webro ot conf LookupServices xml FIC_WEB_HOME webro ot WEB INF web xml lt INSTALL_HOME_FOLD ER gt profile FIC_SERVER_IP AM_HOST ICC_SERVER_HOST DEFAULT_CONNECTION _URL ROUTER_HOST AM_HOST IP FIC_WEBSERVER_IP MESSAGE_SERVER_HOST FIC_ROUTER_HOST Update the Old IP Host Addresses with new APP Server IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the Old IP Host Addresses with new APP Server IP Host Address Update the Old DB IP Host Address with the new DB Server IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the Old DB IP Host Address with the new DB IP Host Address Update the
288. write permission to the user from which installer is executed Check the path mentioned in USER_INSTALL_DIR tag of OFSAAI InstallConfig xml Try to manually create the directory from the user Error code OFSAAI 1019 Cause Total file descriptors for the user are less than 3096 Resolution Check total file descriptor using ulimit n command Increase the total number of file descriptors by editing etc security limits conf num of open files Example username hard nofile 5000 username soft nofile 5000 11 14 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Error code OFSAAI 1020 Cause Exception while fetching total file descriptor value Resolution Check whether the command ulimit n is executable or not Error code OFSAAI 1021 Cause Tomcat web application server path contains space Resolution Make sure Tomcat web application server path does not contain spaces Check the path mentioned in WEBSERVERPATH tag of OFSAAI InstallConfig xml Error code OFSAAI 1022 Cause Error while fetching CATALINA_HOME Resolution Make sure that echo CATALINA_HOME is executable through the console Error code OFSAAI 1023 Cause Environment variable of CATALINA HOME is not set Resolution Make sure that echo CATALINA_HOME gives Apache Tomcat installation directory path If you do not see any value set the environment variable in th
289. xt fear Cancer Test Database Connection Test the database availabilty and the comecton propertes you provided What s the 44 package nane of JOEC Giver Cass used to Create datadase Comectors n the commecton pool aoe Driver Class Name oracle jdbc OracleDriver What the URL of the database to connect to The format of the URL varies by JOC diver Ura jdbc oracle thin 10 184 What Getabese account ter Name Go you meant to use to ceste Cotabase commectors Database User Rame ssatom What s the database account pasaword to use to create database commectors Seeeeereeeereeeees eeeeeereeeerereees What are the propertes to pass to The JOSC Giver when cestno database comectors Properties The set of driver oroper tes whose valves are denved at nite Son the named systen property System Properties Vihet table name or SQ statement would you line to use to test Cotabese commectons Test Table Name SQL SELECT i FROM DUAL Test Contgurates Seck Next fFmeh Cancel Verify the details displayed and ensure that they are correct Click Test Configuration and test the configuration settings A confirmation message will be displayed stating Connection test succeeded 9 Click Finish The newly created Data Source will be displayed under the list of Data Sources Note e The User ID to be specified is the Oracle user ID that is created for the respective infodom 4 18 Oracle Financial Services Analytical A
290. y Configure Node Limit for a Hierarchy Tree This property is required to display the Hierarchy as a small or a large hierarchy If the tree node limit exceeds the set limit Hierarchies are treated as large Hierarchy VALUE CODE EXAMPLE Tree node limit for the TREE_NODE_LIMIT VALU TREE NODE_LIMIT 30 hierarchy Values is Integer E number IP Host Address Related Changes If the IP Host Address of the machine on which OFSAATI is installed changes the following files and database column values need to be updated with the New Value for the uninterrupted performance of the application 4 60 Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Related Files Place Holder Field Updated FIC_HOME conf dynami cservices xml FIC_HOME conf Lookup Services xml ficapp common FICServe r conf FICWeb cfg ficapp icc conf server con f properties DEFAULT_CONNECTION _URL ROUTER_HOST AM_HOST WEBSERVER IP SERVLET_URL FIC_SERVER_IP ICC_SERVER_HOST ICC_ROUTER_HOST MESSAGE_SERVER_HOST REVELEUS_SERVER_HOS T Update the Old DB IP Host Address with the new DB Server IP Host Address Update the Old DB IP Host Address with the new DB IP Address Update the Old DB IP Host Address with the new DB IP Address Update the OLD IP Host Addresses with the new WEB Server IP Host Address Update the OLD IP Host Addresses
291. yment Ths may take a fen moments to complete Additional coefiguration In order to work successfully ths application may require additonal configuraton Do you went to review ths application s configuraton after completing this assistant Yes take me to the deployments configuration screen No 1 will review the configuration later Summary Deployment radara dni OIS Orde Mckdeware ser _projects Momans og 727 aooaa er Name vog72733 Staging mode Use the defaults defned by the dosen targets Security Hodek DOOniy Use only roles and polices tat are defined in the deployment descrotms Target Semmary 4 In the Settings for lt Deployment Name gt window review the general configuration details of the deployment You can update the configuration of the deployment in this window Click Save to save the updates if any Post Installation Configuration 4 43 Settings for upg7273 Overview Cecoymentrien Configuration Searity Targets Control Testng Monitoring Notes Seve Use this page to view the general configuration of an Enterprise application such as its name the physical pam to the soglicaton fes the essocated deployment pian anc so on The table at the end of the page ists he modes such as Web applications and EBs that are contained in the Enterprise application Cick on the mame of the module to vew and update its configuration Mame wnn The name of fis Enterprise Application More Info Path j aratata wi 1035

Download Pdf Manuals

Related Search

Related Contents

Guide de l`utilisateur    Everpure EV9273-69 User's Manual  V7 Replacement Battery for selected Hewlett-Packard Notebooks  guia admitir al usuario  PASCO Specialty & Mfg. EM-8090 User's Manual  Installation and User`s Manual  pab® Basic User Manual - Pressure Air Biofeedback  Boite combi pour traiter fruits et légumes  MANUEL D`INSTRUCTIONS ET D`UTILISATION Poêle à  

Copyright © All rights reserved. Failed to retrieve file