Oracle® Financial Services Model Risk Management
Contents
1. MODEL_UPLOAD_ FLAG 1 This variable is used to identify whether Data Model Upload for OFSMRM is to be done through Installer Allowable values for this placeholder are 0 and 1 Replace this placeholder with 1 If Data Model Upload for OFSMRM is to be done through Installer 0 If Data Model Upload for OFSMRM is already completed DM_TYPE_1 This variable is used to identify type of Data Model Upload for OFSMRM that is to be done through Installer This value is required only if MODEL_UPLOAD_FLAG_1 and PRE_ INSTALL has been replaced by 1 Replace this placeholder with the type of DataModel upload to be performed Allowable value is 0 0 SLICED Model Upload For Example lt Variable name DATAMODEL_TYPE gt 0 lt Variable gt NOTE For first time Data Model upload in an Infodom by default the type of Data Model upload chosen is NEW Model Upload For subsequent Model Uploads on same Infodom value of this variable is used for Data Model Upload Type HLOGICAL_UPLOAD_1 H This variable is used to identify if Data Model Upload for OFSMRM is to be Logical or not This value is required only if MODEL_UPLOAD_FLAG_1 and PRE_INSTALL has been replaced by 1 Replace this placeholder with the type of DataModel upload to be performed Allowable value is 0 For Example lt Variable name LOGICAL_ UPLOAD gt 0 lt Variable gt This variable is used to identify Data Model file path used for OFSMRM data Mo2. ii tacto 4 15 Start Stop Services pi da aan ail 4 16 Deploying OFSMRM Dashboards Analytics Installing OBIEE Serveri a cine aan 5 17 Installing OBIEE Windows Administration Client cesesesescscseeseeceesesnseseeeseees 5 17 Disabling the Cache Feature in OBIEE Server ere 5 17 Deploying Model Risk Management Report Analytics serene 5 18 Post Installation St ps scins iras aia laare ia a aa e aaa a Aaa 5 27 6 Reference Pre installation Configuration iii Creating Information Domain and Segment Uploading Data Model Preface The Oracle Financial Services Model Risk Management OFSMRM enables financial institutions to record all activities related to Model Development Customization and Implementation Process and identifying and regularize validation s in order to evaluate and assess performance and risk associated with the Models About this Guide This guide provides comprehensive instructions for installing and configuring the OFSMRM application This chapter discusses the following topics About this Guide Who Should Use this Guide Scope of this Guide How this Guide is Organized Where to Find More Information Who Should Use this Guide The Oracle Financial Services Model Risk Management Installation Guide Release 2 0 0 0 0 is designed for use by OFSM
3. The OFSMRM Data Model is available in Data_Model folder For more information on Data Model upload refer to Unified Metadata Manager section of OFSAAI User Manual Reference 6 29 Uploading Data Model 6 30 Oracle Financial Services Model Risk Management
4. Single Tier mode NOTE In case of OFSAAI was installed in Multi Tier mode this value needs to be set according to OFSAAI Application layer installed on this machine a Replace the placeholder with 1 for the machine hosting OSFAAI application layer b Replace the placeholder with 0 for the machine NOT hosting OSFAAI application layer DB_USER_1 This variable is used to identify the OFSMRM Atomic Schema Replace the placeholder with OFSMRM Atomic Schema Name For Example lt VariableGroup name MRM_ATOMIC_USER gt lt Variable name ATOMIC_SCHEMA_USER_ NAME gt MRMATOMIC lt V ariable gt lt VariableGroup gt NOTE This value should be same as entered against OFSMRM Atomic User name while running prerequisites sq APP_LOG_PATH This variable is used to identify Application Layer Log path to store logs for all front end and back end components that will be created by OFSAAT in Application Layer Replace this placeholder with an absolute path For Example lt Variable name APP_LAYER_LOG_PATH gt home ftpshare APP_ logs lt Variable gt This variable is used to identify Database Layer Log path to store logs for all front end and back end components that will be created by OFSAAI in Database Layer For Example lt Variable name DB_LAYER_LOG_ PATH gt home ftpshare DB_logs lt V ariable gt INFODOM_FLAG_1 This variable is used to identify the OFSMRM Information Domain to be created by installer Al
5. Display Errors 0 IV Warnings 20 T Messages Message 3 obici toe obet eroe crorossobtie Warning Logical Table Sourc AD41 Model Effecti 39008 Logical dimension table AD41 Model Effectiveness Rating has a source AD41 Model Effectiveness Rating that does not join to any i i fact source n i Warning Logical Table Sourc AKO2 Issue Source 39020 Logical table source Operational Risk AK02 Issue Source Map AKD2 Issue Source Map No path has been found to link all tables i There is no link between the set AK12 Auto Create Issue and the set AKO2 Issue i i i Source Map a Warning Logical Table Sourc AKO2 Issue Source 39057 There are physical tables mapped in Logical i Table Source Operational Risk AK02 Issue Source Map AKO2 Issue Source Map that are not used in any column mappings or i i E Pressione sl Warning Logical Table Sourc AK12 Arto Create I 39008 Logical dimension table AK12 Auto Create Issue has a source AK12 Auto Create Issue x that danae nat inin ta anu Fart enurra TF Show Qualified Name Save as Check All Objects Go To Copy Close Help A Global Consistency Check was performed 0 Er or s 0 shown 20 Warning s 20 shown and 0 Best Practice violations s 0 she For Help press F1 Num 2 9 Copy MRM20 tar file from FIC_HOME OBIEE of Web layer and place it under lt OBIEE Installed Directory gt instances instancel bifoun
6. MRM20 rpd 3 DAFCCM MRM20 rpd 4 DAFCCM MRM20rpd Exit Save the active repository 7 Click Yes on the pop up message Do you want to check global consistency 5 22 Oracle Financial Services Model Risk Management Deploying Model Risk Management Report Analytics E Oracle Bl Administration Tool MRM20 pd Jolx Fils Edit Y lanana T amy File Edi E Manage Tools Diag Dess0ga Xee amar nasa asa Business Model and Mapping m 3 Model Promt Dummy Not Using For Reports ig Model Risk Management m Model Risk Management g Operational Risk 2 Connecion Pool Operational Risk Issue amp Actions a MAMITATM 2B oR A 0R123 2 Authorization Hd gemblam2 ow Help e Do you wish to check global consistency No Cancel For Help press F1 8 Click OK on the pop up message Consistency check didn t find any errors warning or best practices violations Note Warnings on consistency check can be ignored Deploying OFSMRM Dashboards Analytics 5 23 Deploying Model Risk Management Report Analytics lol Oracle Bl Administration Tool MRM20 rpd JD x File Edit View Manage T Help agral indov Ocee GA S XGG E Sah 00955 1 Presentation Business Model and Mapping Physical Model Promt Dummy Not Using For Reports E Model Risk Management 5 A MRM20 E Model Risk Management El Operational Risk Connection Pool iene AE
7. Oracle Financial Services Model Risk Management 1 Navigate to Home directory of Unix user under which OFSAAI is installed and execute the profile file using following command profile 2 Navigate to the directory where OFSMRM installer has been copied and provide execute permission for Setup sh 3 Execute the Setup sh file using following command Setup sh SILENT 3 12 Oracle Financial Services Model Risk Management Installation Process Note Do not execute Setup sh with SILENT option in the nohup mode In case of Multi tier architecture that is where OFSAAI APPLICATION DATABASE and WEB Layer are installed on more than one server the following order must be followed for installation APPLICATION Layer DATABASE Layer WEB Layer The SILENT mode of installation does not require any simulator The user will be prompted to input following users and passwords through console Enter MRM Atomic Schema Password Re enter MRM Atomic Schema Password Enter the password corresponding to the user entered against DB_USER_1 If web layer is installed separately then user will be prompted to input following users and passwords through console a Enter MRM Config Schema Password Re enter MRM Config Schema Password Installation Log Files On completion of installation check the installation logs Following is a list of logs created by installer a MRM_LOG log This log is cre
8. DER Name gt wherever user input is required Replace these placeholders with the corresponding values as mentioned below GENERAL Layer The Layer APPLICATION lt Layer name APPLICATION gt consist of the following placeholders which must be replaced for installation of Application Layer as one of its component The variables under the GENERAL tag needs to be configured mandatorily for all the types of installations All the placeholders for this layer are tabulated below Table 3 1 Description CUSTID This variable is used to store the Customer ID Replace this placeholder with Customer Code used during OFSAAI Installation For Example lt VariableGroup name OFSAA_ INFRASTRUCTURE_CUSTOMER_CODE gt lt Variable name CUSTID gt EDELIVERY lt Variable gt lt VariableGroup gt 3 8 Oracle Financial Services Model Risk Management Installation Process Table 3 1 Description PRE_INSTALL This variable is used to identify whether installer will perform the following Pre Installation activities a Infodom and Segment Creation for OFSMRM atomicschema b Data Model Upload for OFSMRM atomic schema Replace this placeholder with either of below values Allowable values are 0 and 1 1 If user wants one or more of the above Pre Installation steps to be performed by installer 0 If the user has performed all the above steps through OFSAAI front end For more information refer to Pre ins
9. ER Oracle Financial Services Model Risk Management MAILUTILITY_PDFPATH This should be the full path of the profile report that is generated in the PDF format The path is WebServer EDPATH OFSAAI WNI EB INF TempReports MAILUTILITY_SLEEPINTERVAL 40000 in Micro Seconds MAILUTILITY_STATUS Yes REV MAIL FROM MRMAdmin oracle com REV SMTP HOST internal mail router oracle com REV SMTP PORT 25 3 Update the following entries in dim ror configuration table in atomic schema APP URL lt OFSMRM application URL gt Post Installation Activities 4 15 Start Stop Services Start Stop Services Once the installation of OFSMRM has been completed successfully and the post installation steps are completed the servers must be restarted For more information refer to the Start Stop Infrastructure Services section of Oracle Financial Services Analytical Applications Infrastructure Installation Guide The OFSMRM 2 0 0 0 0 is now ready for use Login to the Application with MRM admin user and Resave all Hierarchies Note For more information refer OFSAAI 7 3 User Manual Administration gt Save Metadata section 4 16 Oracle Financial Services Model Risk Management 9 Deploying OFSMRM Dashboards Analytics This chapter explains how to deploy Model Risk Management Report Analytics on Oracle Business Intelligence Enterprise Edition OBIEE This chapter includes the followin
10. INDEXES_TBS lt Variabl e gt NOTE This value should be same as the value provided for the Index Table space name while running prerequisites sql WEB Layer The Layer WEB lt Layer name WEB gt contains following placeholders which must be configured for installations of the WEB layer as one of its component Table 3 4 Description WEB_LAYER This flag is used to Identify if OFSMRM Web Layer component are to be installed on this machine Allowable values for this placeholder are 0 and 1 Replace this placeholder with 1 if WEB Layer component is to be installed 0 if WEB Layer component is not to be installed Replace the place holder with 1 in case of OFSAAI was installed as Single Tier mode NOTE In case of OFSAAI was installed as Multi Tier mode this value needs to be set according to OFSAAI WEB layer installed on this machine 1 Replace the placeholder with 1 for the machine hosting OSFAAI web layer 2 Replace the placeholder with 0 for the machine NOT hosting OSFAAI web layer OBIEE This variable is used to identify whether Oracle Business Intelligence Enterprise Edition OBIEE needs to be integrated in the setup Allowable values for this placeholder are 0 and 1 Replace this placeholder with 0 if OBIEE reports related files are not be installed 1 if OBIEE reports related files are to be installed For Example lt Variable name OBIEE_ REPORTS gt 1 lt Variable gt Installation of
11. Oracle Financial Services Model Risk Management Installation Guide Release 2 0 0 0 0 April 2015 ORACLE Installation Guide Release 2 0 0 0 0 Copyright 2014 Oracle and or its affiliates All rights reserved Primary Author Snigdha Thakuria 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 disassembly 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 supple
12. RM Installers and System Administrators Their roles and responsibilities include the following FSMRM System Administrator This user installs configures maintains and adjusts the system and is usually an employee of a specific Model Risk Management client The System Administrator maintains user accounts and maps roles to user OFSMRM Installer This user installs configures and maintains MRM application at the deployment site Scope of this Guide This guide provides step by step instructions for installing the OFSMRM on an existing OFSAAI platform hosted on a suitable environment How this Guide is Organized The Oracle Financial Services Model Risk Management Installation Guide Release 2 0 0 0 0 includes the following chapters Overview provides a brief overview of the application Preparing to Install details the prerequisites environment and installation checklist that are necessary for installing the OFSMRM Installation Activities describes the step by step installation activities for installing OFSMRM application Post Installation Activities details the steps that are to be performed after successful installation of OFSMRM application Pre installation Configuration details the pre installation activities Where to Find More Information For more information on the OFSMRM refer to the following documents vi Oracle Financial Services Model Risk Management Release Notes This guide details t
13. Table 2 2 Task Done Y N 12 Ensure that OFSAAI servers are running during APP layer Installation 13 Ensure that Application Server and Web Application Server have the FODN signature of each other in the known_ hosts file located under lt USER_HOME gt ssh folder 2 6 Oracle Financial Services Model Risk Management 3 Installation Activities The OFSMRM comprises of components that are installed in the OFSAAI Web Application and Database layers OFSMRM installer is required to be invoked only once on the machine that hosts all the OFSAAI tiers If OFSAAT has been installed in multi tier architecture the OFSMRM installer must be invoked on each machine that hosts an OFSAAI Platform tier Installation Process Following are the step by step instructions for installing OFSMRM on a single tier mode Copy the required files to installation directory Login with the Unix user s on the server s which hosts OFSAAI APP DB and WEB layers and copy the following files from the eDelivery into any directory Setup sh a Setup bin a GRC InstallConfig xml a validateXMLInputs jar a log4j xml prerequisites sql a Data Model folder containing the datamodel file Note m If OFSAAI APP layer DB layer and WEB layer are installed on different servers users files must be copied under all servers users Copy Setup sh log4j xml Data_Model folder prerequisites sql and GRC_ Instal
14. This chapter covers the following topics a Environment m Prerequisites a Pre Installation Activities Note Refer to the Oracle Financial Services Model Risk Management Release Notes for the latest updates on the hardware or software requirements Environment The OFSMRM is installed using the hardware and software environment as described in the following table Table 2 1 Operating System Hardware Software Oracle Enterprise Linux a SUN FIRE X4170M2 Oracle Database Server Release 5 8 SERVER 64 bit Enterprise Edition Release Carthage 64 bit Desktop machinewith rea e bit with or 4GB RAM for front end access Sun JDK Standard Edition 1 6 0 25 64 bit WebLogic 10 3 5 0 64 bit Websphere 7 0 0 17 64 bit a Tomcat 7 0 19 64 bit m Oracle Business Intelligence Enterprise Edition v 11 1 1 7 0 a OFSAA 7 3 2 2 0 The following explains the Front End Access a Microsoft Internet Explorer 8 9 Microsoft Office 2003 2007 Preparing to Install 2 3 Prerequisites a Client Machines Windows XP SP3 Windows 7 a Screen resolution 10247768 and 12801024 a Adobe Reader 8 0 Java plug in 1 6 0 21 Note a Ensure that Java Plug in is enabled in the browser settings Enable caching of static content static files images CSS and so on for browser client Ensure cookies are disabled Refer to Deploying OFSMRM Dashboards Analytics to configure M
15. To be created by Installer For Example lt Variable name SEGMENT_CODE gt MRMSEGMENT lt Variable gt NOTE Make sure to follow below convention while giving a new Segment Code a Enter a unique segment code b Ensure that there are no special characters and extra spaces in the code entered c Ensure that maximum length of Segment Code should less than or equal to of 10 characters d Ensure that the Segment name is in Uppercase FTPSHARE PATH Replace this placeholder with the same path as configured during OFSAAI Installation For Example lt VariableGroup name LOCAL_FTPSHARE_PATH gt lt Variable name FTPSHARE_ PATH gt home ftpshare lt Variable gt lt VariableGroup gt NOTE For more information on FTPSHARE refer FAQs in OFSAAI Installation and Configuration Guide Installation Activities 3 9 Installation Process APPLICATION Layer The Layer GENERAL lt Layer name GENERAL gt contains the following placeholders to provide the parameter values specific to Users system Table 3 2 Description APP_LAYER This flag is used to Identify if OFSMRM Application Layer component are to be installed on this machine Allowable values for this placeholder are 0 and 1 Replace this placeholder with 1 If APPLICATION Layer component is to be installed 0 If APPLICATION Layer component is not to be installed Replace the place holder with 1 in case of OFSAAI was installed in
16. anagement provides model information vide a single instance thereby breaking silos within an organization and enables effective management of model risks through periodic validations and provides a control framework to manage Issues and Actions Components Following are the components of OFSMRM Home The Home window is the landing screen of OFSMRM This window provides you an option to view few major reports latest announcements and notifications and tasks assigned to you a Inbox All tasks and notifications received are available in the Inbox Model Management Model Management module manages Models and their Usages a Issues and Actions Issues and Actions module manages Issues and associated Actions Admin Admin module facilitates system administrators to set application preferences manage reference data determine the access rights upload documents manage User Interface language and manage Questions and Questionnaire library Overview 1 1 Components Dashboard Dashboard integrates the results generated by the OFSMRM application with Oracle Business Intelligence OBI giving users the ability to perform queries on OFSMRM components 1 2 Oracle Financial Services Model Risk Management 2 Preparing to Install This chapter provides information on prerequisites environment hardware and software requirements and installation checklist that are necessary for installing OFSMRM application
17. ated in the directory where OFSMRM installer has been copied SolutionSetup_InstallLog log This log is created in FIC HOME area of the machine where Installer was triggered SolutionsLOG log This log is created in FIC HOME area If the logs contain any Fatal Non Fatal errors then bring them to the notice of Oracle Support DO NOT proceed with the installation until all the concerns have been adequately addressed Installation Activities 3 13 Installation Process 3 14 Oracle Financial Services Model Risk Management 4 Post Installation Activities This chapter describes the post installation activities This chapter covers the following topics m Resource Reference Configuration m Email Configuration m Start Stop Services Resource Reference Configuration Once the installation of OFSMRM is completed you must Configure Resource Reference and redeploy the EAR file For more information on Configuring Resource Reference and deploying EAR files refer Oracle Financial Services Analytical Applications Infrastructure Installation Guide Email Configuration Perform the following steps to configure the email utility 1 The web application server should have access to the SMTP server at the designated port 2 The web application server should have access to the SMTP server at the designated port Examples for available entries are the following D EPLOY MAILUTILITY_PDFHEAD
18. dation OracleBIPresentationService sComponent coreapplic ation_obips1 catalog 10 Extract the contents of MRM20 tar file using the following command tar xvf MRM20 tar 11 Login to Enterprise Manager Click Business Intelligence folder at left hand side Select coreapplication and then click Deployment tab 12 Click Repository tab 5 24 Oracle Financial Services Model Risk Management Deploying Model Risk Management Report Analytics 13 Click Lock and Edit Configuration The Lock and Edit Configuration Confirmation window displays Deploying OFSMRM Dashboards Analytics 5 25 Deploying Model Risk Management Report Analytics 14 15 16 17 18 19 20 21 Click Close In Upload BI Server Repository section browse the MRM20 rpd file from windows machine Enter the new repository password in the text boxes repository password and confirm password In BI Presentation Catalog section provide the Catalog Location as ORACLE INSTANCE bifoundation OracleBIPresentationServicesComponent COMPONENT_ NAME catalog MRM20 Click Apply Click Activate Changes An Activate Changes Confirmation window displays Click Close Modify lt OBIEE Installer Directory gt instances instancel config OracleBIPresentationServicesComponent corea pplication_obipsl inst anceconfig xml as shown below From lt Security gt lt This Configuration setting is managed by Oracle Enterprise Manag
19. del Upload This value is required only if MODEL_UPLOAD_FLAG_1 and PRE_INSTALL has been replaced by 1 Replace this placeholder with the absolute path of DataModel file For Example lt Variable name DATAMODEL_FILE_ PATH gt home OFSMRMKkit Data_ Model DataModel_MRM_20 xml lt Variable gt DATABASE Layer The Layer DATABASE lt Layer name DATABASE gt contains the following placeholders which must be configured for installation of Database Layer as one of its component Installation Activities 3 11 Installation Process Table 3 3 Description DB_LAYER This flag is used to Identify if OFSMRM Database Layer component are to be installed on this machine Allowable values for this placeholder are 0 and 1 Replace this placeholder with 1 If DATABASE Layer component is to be installed 0 If DATABASE Layer component is not to be installed Replace the place holder with 1 in case if OFSAAI was installed in Single Tier mode NOTE In case OFSAAI was installed as Multi Tier mode this value needs to be set according to OFSAAI Database layer installed on this machine a Replace the placeholder with 1 for the machine hosting OSFAAI database layer b Replace the placeholder with 0 for the machine NOT hosting OSFAAI database layer INDEX_TABLESPACE _ 1H Replace this placeholder with OFSMRM INDEX Table space Name For Example lt Variable name INDEX_TABLE_ SPACE gt OR_
20. er Fusion Middleware Control gt lt ClientSessionExpireMinutes gt 210 lt ClientSessionExpireMinutes gt lt Security gt To 5 26 Oracle Financial Services Model Risk Management Post Installation Steps lt Security gt lt This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control gt lt ClientSessionExpireMinutes gt 210 lt ClientSessionExpireMinutes gt lt InIFrameRenderingMode gt allow lt InIFrameRenderingMode gt lt Security gt 22 Modify the lt OBIEE Installed Directory gt OracleBI1 bifoundation web app WEB INF web xml From lt servlet mapping gt lt servlet name gt RelatedContent lt servlet name gt lt url pattern gt RelatedContent lt url pattern gt lt servlet mapping gt lt login config gt lt auth method gt CLIENT CERT lt auth method gt lt login config gt To lt servlet mapping gt lt servlet name gt RelatedContent lt servlet name gt lt url pattern gt RelatedContent lt url pattern gt lt servlet mapping gt lt context param gt lt param name gt oracle adf view rich security FRAME_BUSTING lt param name gt lt param value gt never lt param value gt lt context param gt cc lt login config gt lt auth method gt CLIENT CERT lt auth method gt lt login config gt 23 Restart Weblogic server Start Oracle Process Manager and Notification Server OPMN services by executing
21. g sections a Installing OBIEE Server a Installing OBIEE Windows Administration Client a Disabling the Cache Feature in OBIEE Server a Deploying Model Risk Management Report Analytics a Post Installation Steps Installing OBIEE Server To install Oracle Business Intelligence Enterprise Edition OBIEE server refer to Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence11g Release 1 11 1 1 After installing Oracle Business Intelligence Enterprise Edition OBIEE server get the Enterprise Manager URL username password and OBIEE installed directory from the System Administrator Note Once the OBIEE server is installed it should be upgraded to the version as mentioned in the Environment section Installing OBIEE Windows Administration Client To install OBIEE repository administration client for Windows machine refer to Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence11g Release 1 11 1 1 Disabling the Cache Feature in OBIEE Server Login to Enterprise Manager and perform the following steps Deploying OFSMRM Dashboards Analytics 5 17 Deploying Model Risk Management Report Analytics 1 Click Business Intelligence folder from left hand side menu and select coreapplicaiton 2 Click Capacity Management tab Select Performance tab 3 Click Lock and Edit Configuration tab 4 Uncheck the Cache Enabled option to disable the cache Deploying Model Risk Ma
22. he latest updates on hardware and software requirements Oracle Financial Services Model Risk Management User Guide This guide provides information about all the modules in the OFSMRM application To find additional information about how Oracle Financial Services solves real business problems visit our website at http www oracle com us industries financial services overview index html 1 Overview This chapter provides a brief overview of the Model Risk Management application m Introduction m Components Introduction Financial institutions rely heavily on financial and economic models for a wide range of applications such as risk management valuation and financial regulatory reporting The level of sophistication of models used for such applications varies widely from relatively simple spreadsheet tools to complex statistical models applied to millions of transactions Regardless of the level of sophistication model use exposes the financial institutions to model risks which leads to the possibility of a financial loss incorrect business decisions misstatement of external financial disclosures or damage to the company s reputation arising from possible errors in the model design and development process including the design and development of changes to existing models such as errors in the data theory statistical analysis assumptions or the code of underlying model Oracle Financial Services Model Risk M
23. klist on readiness with required information 2 4 Oracle Financial Services Model Risk Management Pre Installation Activities Table 2 2 Task Done Y N Ensure that the Oracle Database instance is up and running Ensure that the FTP share path as configured in OFSAAI platform is available Ensure that the IP address or host name is available Ensure that the servlet port is available Ensure that the OFSAAI configuration schema user ID and password is available Ensure that the Oracle SID is available Ensure to have Recursive Write permission on ftpshare paths of APP DB and WEB layers Ensure that the 9 digit customer identification number is available Items 9 13 contain completeness check on pre installa tion activities 9 Ensure to take a backup of the following before the application installation process starts Configuration Schema OFSAAI Installation Directory For more information refer to Pre Installation Activities section 10 Ensure that the Table space and Database user are created For more information refer to Pre Installation Activities section 11 Verify that tnsnames ora file which is updated with the OFSMRM atomic schema has been created For more information refer to Pre Installation Activities section Preparing to Install 2 5 Pre Installation Activities
24. lConfig xml in text mode Copy Setup bin and validateXMLInputs jar in binary mode to avoid control character Grant 750 permission to all the files Creating Atomic Schema User and Table Spaces To create atomic schema user and table spaces follow these steps Installation Activities 3 7 Installation Process Login to database hosting OFSAAI Configuration Schema with user having DBA privileges and execute prerequisites sql Provide the following parameters you are prompted to input a Enter a path where spool file will be created a Enter a name for MRM Data Table space a Enter absolute path with file name of data file for Data Table space a Enter a name for MRM Index Table space a Enter absolute path with file name of data file for Index Table space a Enter a name for MRM Atomic Schema User Enter a password for MRM Atomic Schema User Note If the atomic schema and table spaces data and index table spaces were created previously ensure that you have provided necessary grants permissions as mentioned in prerequisites sql Also make sure that the data table space is the default table space for the atomic user and you have an index table space present Populate the GRC_InstallConfig xml file This file contains the following four layers GENERAL Layer APPLICATION Layer DATABASE Layer WEB Layer GRC_InstallConfig xml contains placeholders in the format lt PLACEHOL
25. lowable values for this placeholder are 0 and 1 Replace this placeholder with 1 If you want the installer to create the Infodom for OFSMRM 0 If the Infodom was previously created INFODOM_DESC_1 This variable is used to identify the OFSMRM Information Domain Description This value is required only if INFODOM_FLAG_1 and PRE_INSTALL has been replaced by 1 Replace this placeholder with a description for OFSMRM Information Domain by following below rules a Ensure the description field is not empty b Ensure that the description field has not exceeded 100 characters For Example lt Variable name INFODOM_DESCRIPTION gt Model Risk Management Infodom lt Variable gt 3 10 Oracle Financial Services Model Risk Management Installation Process Table 3 2 Description DB_NAME_1 This variable is used to identify the Database Name for OFSMRM Information Domain This value is required only if INFODOM_FLAG_1 and PRE_INSTALL has been replaced by 1 Replace this placeholder with a name for the OFSMRM Database by following below conventions a Ensure that there are no special characters and extra spaces in the name b Ensure the length of database Name has not exceeded 20 characters For Example lt Variable name DATABASE _ NAME gt OFSMRMDB lt Variable gt NOTE A TNS entry should be made in tnsnames ora file with tnsname same as that of the value provided for OFSMRM Database Name
26. mental 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 responsible 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 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 or ha
27. nagement Report Analytics To deploy Analytic Reports follow these steps 1 Stop Oracle Process Manager and Notification Server OPMN services by executing the following command lt OBIEE Installed Directory gt instances instance1 bin opmnctl stopall 2 Copy MRM20 rpd from FIC_HOME OBIEE Repository of Web layer to windows machine where the OBIEE windows administration client is installed 3 To change the default password for the repository follow these steps Open the repository using OBIEE Windows administration client gt Oracle BI A dministr ation Tool Tools Paes Aep sitara Er IQ gt 1 Im Gp ern r Tuiltivuse r Help 1 OD TR EI Oracle Mantas BI0o000s DOD 1y oracle MmMamktas BI000 SS Exit 5 18 Oracle Financial Services Model Risk Management Deploying Model Risk Management Report Analytics E Oracle Administration Tool E i lolx File Tools Help NTE EIDE ERE REESE Lookin Ji Resto sc G RE dL_ ____ File ricas MRM20 1pu x Files of type Repository Files pd x ForHelp press F1 NM a Enter default repository password as Admin123 E orst Adrian Ted i A lola File Tools Help isssedajrab auar var 458 X For Help press F1 TN 4 Deploying OFSMRM Dashboards Analytics 5 19 Deploying Model Risk Management Report Analytics Click File menu and select Change Password a En
28. odel Risk Management Dashboards Prerequisites Once OFSAAI is installed it must be configured with Application Server Database Server and Web Server detail For more information on configuring the OFSAAI refer to the Oracle Financial Services Analytical Applications Infrastructure System Configuration and Administration User Guide Pre Installation Activities This section explains the pre installation activities to be performed by the System Administrator before starting the installation of OFSMRM application 1 Take a backup of the following before the application installation process starts The backup should be kept until the application runs successfully OFSAAI Configuration schema a OFSAAI Installation directory 2 Create Table spaces and database user for OFSAAI Atomic Schema Make the TNS entry for the atomic schema user in the TNSNAMES ORA file in the system where OFSAAI database components are installed For more information on creating atomic schema users and table spaces refer section Creating Atomic Schema User and Table spaces 3 Database parameters should be set as Processes 2000 and Sessions 3000 4 Provide the following grant o the config schema user grant unlimited tablespace to lt config_user gt Pre Installation Checklist The following table lists the pre installation checklist to be completed before starting the installation of OFSMRM Table 2 2 Task Done Y N Items 1 8 contains chec
29. perational Rsk Issue amp 4 Connection Pool MFM20 Conr General Connection Scripts KM Write Back Miscellaneous Name fem ection Poc Permissions Call interface Default OCI 109 119 x Maximum connections 10 T Require fully qualified table names Data source name DESCRIPTION ADDRESS_LIST ADDRESS PROTI Shared logon User name mrmalom Password eseese IV Enable connection pooling Timeout 5 minutes v 4 Use multithreaded connections IV Parameters supported Isolation level Default v Description DESCRIPTION ADDRESS IST ADDRESS PROTOCOL TCP al HOST 10 184 135 31 PORT 1521 ADDRESS PROTOCOL TCP HOST 10 184 135 32 PORT 1521 I L04D_BALANCE or CONNECT_DATA SERVICE_NAME perforcl OK Cancel Help Physical E B MRM20 E Connection Pool e MAMITATM OR R 0R123 R Authorization A gem51atm2 NUM a Enter the following in Data Source Name text box of Connection Pool Properties window after modifying lt Database Server Host Name gt and lt Database Name gt DESCRIPTION ADDRESS PROTOCOL TCP HOST lt Database Server Host Name gt PORT 1521 CONNECT_ DATA SERVER DEDICATED SERVICE_NAME lt Database Name gt a Enter atomic schema user in User name text box a Enter atomic schema user password in Password text box a Click OK a Re enter the atomic schema password Deploying OFSMRM Da
30. rdware 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 Preface 0 GRIGIA e RIA RAR RI v Aboutthis GUlde 2 543 seiersen snert eoo dele aa E o E Te anolita V Who Should Use this Giidi eante a e a a a a E E eee V Scope ofthis Guide 25524 iride eE ants ia E Ea iii V How this Guide is Organized nsns apiet a aeee E a a EEs eee a eE ea Aa E eaaa EER e a e V Where to Find More Information u i vi Overview TONO dUCHON id idilliaca 1 1 Components ic ii IDE dd AA atop Mea A ir AA A ASADAS 1 1 Preparing to Install A A a i 2 3 Prerequisites O A E O NN 2 4 Pre Installation Activities A A ROS 2 4 Rre Installation Check sirena i pila ar 2 4 Installation Activities Tnstallation Process aura iii iii a denaro agent es dun rien 3 7 Installation of Oracle Financial Services Model Risk Management n 3 12 Installation Log FileSend iie ti eesis i o a E aee iia NEE 3 13 Post Installation Activities Resource Reference Configuration i 4 15 Email Configurationi
31. shboards Analytics 5 21 Deploying Model Risk Management Report Analytics Oracle BI Administratio Connection Pool Connection Pool a 2 General Connection Scripts XML Wie Back Miscellaneous Name Connection Pool Permissions Physical z E MRM20 H Model Risk Managed Callinterface Default OC 109 119 y 2 Comecion Pool E Operational Risk Is Maximum connections 10 2 i g MRMITATM IT Require fully qualified table names i ont Data source name DESCRIPTION ADDRESS_LST ADDRESS PROT 2 Autorization Fd gom5tatm2 IV Shared logon User name mm123 Password eeeeee able x DESCRIP ADDRESS LI HOST 10 184 135 31 PORT 1521 XAD HOST 10 184 135 32PORT 1521 XLOAD_BALANCE 0n CONNECT_DATA SERVICE_NAME perforc ima imp 5 Expand the OR folder and repeat step 4 to configure connection pool for OR123 and Authorization 6 Click File menu and then click Save IES Edit View Manage Tools Diagram Window Help New Repository aia 945 Open Multiuser Business Model and Mapping MAM114TM Source Control amp Model Risk Management Close Operational Risk IE LE Save As A 08123 CopyAs Authorization Change Password E gem5latm2 Print Preview Print Print Import Metadata Compare Turn off Compare Mode Merge Check Global Consistency Ctrl K 1MRM20 rpd 2 DAFCCM
32. tallation Configuration section under References For Example lt VariableGroup name PRE_INSTALLATION gt lt Variable name PRE_INSTALL gt 1 lt Variable gt lt VariableGroup gt NOTE Oracle recommends Installer to perform all these steps In case OFSMRM installation has been performed second time after successful Un installation then will keep this parameter as 0 since it is a onetime activity INFODOM_1 INFODOM_2 INFODOM_3 These variables are used to specify the OFSMRM Information Domain name Replace these three placeholders with the same Infodom name in either of the below cases a If already created from OFSAAI front end b To be created by Installer For Example lt Variable name INFODOM_NAME gt MRMINFODOM lt Variable gt NOTE Make sure to follow below convention while giving a new Information Domain Name a Ensure that the Information Domain name specified is of minimum 6 characters long b Ensure that the Information Domain name does not contain any special characters or extra spaces c Ensure that the maximum length of Information Domain name should be less than or equal to 20 characters d Ensure that the Information Domain name is in Uppercase HSEGMENT_1 HSEGMENT_2 H HSEGMENT _3 H These variables are used to specify the OFSMRM Segment Code Replace these three placeholders with the same Segment Code in either of the below cases a If already created from OFSAAI front end b
33. ter the new password Click OK Edit View Manage Tools Diagram Window Help New Repository GN haltarnaa asa Open Multiuser ie lapping Source Control o Model Risk Management MRM20 Close Operational Risk Connection Pool Save Ctrl S dy MAMTATM Save A a OR bai A 08123 Copy As Authorization IT RR gini Print Preview Print Import Metadata Compare Turn off Cornpare Mode Merge Check Global Consistency Ctrl K Check Models Check Out All Check In Changes Undo All Changes 1MRM20 rpd 2 DAFCCM AMRM20 tpd 3 DAFCCM AMRM20 tpd 4 DAFCCM MRM20 tpd Exit Change repository password 4 To configure connection pool of repository follow these steps a Inthe physical section expand MRM20 folder File Edit View Manage Tools Diagram Window Help CDs 4 B8 D BKK BE e Model PromtDummy Not Using For Reports Model Risk Management Model Risk Management Operational Risk Operational Risk Issue amp Actions Hh MAMITATM a8 a OR123 Authorization AB gem51atm2 Connection Pool MRM20 Connection Pool la NUM WA 5 20 Oracle Financial Services Model Risk Management Deploying Model Risk Management Report Analytics a Double click Connection Pool to open the Connection Pool Properties window E Oracle BI Administration Tool E Presentation d Model Promt Dummy Not U lo Model Risk Management O
34. the following command from lt OBIEE Installed Directory gt instances instancel bin directory opmnctl startall Post Installation Steps In the OFSAAI Application config schema the following entries are required CONFIGURATION Table Deploying OFSMRM Dashboards Analytics 5 27 Post Installation Steps Table 5 1 Table Name Parameter Name Values Configuration OBI URL lt lt INFODOM gt gt For example OBI_URL_MRMINFO http lt ip address or host name gt lt port gt analytics s aw dll Configuration lt lt INFODOM_SEGMENT gt gt _OBI_URL For example MRMINFO_MRMSEG_ OBI_URL http lt ip address or host name gt lt port gt 5 28 Oracle Financial Services Model Risk Management 6 Reference This section of the document consists of the optional steps required as part of the Pre Installation Configuration Pre installation Configuration This section describes the pre installation steps It includes the following topics Creating Information Domain and Segment Uploading Data Model Creating Information Domain and Segment Create information domain and segment to proceed with the installation of solution Refer to OFSAAI System Configuration and Administration Manual for manually creating Information Domain and Segment Uploading Data Model Data Model should be uploaded to the Atomic Schema created as a part of Pre Installation Activity
Download Pdf Manuals
Related Search