Oracle Financial Services Regulatory Reporting 2.5.2.0.0 Upgrade Readme.txt file, First Edition October 2014 Release: 2.5.2.0.0 This document provides information to upgrade the Regulatory Reporting version 2.2.2.0.3 or higher to the latest version 2.5.2.0.0 For more information about Oracle Financial Services Software, Inc., visit http://www.oracle.com/industries/financial_services/index.html. ------------------------------------------------------- HOW TO USE THIS DOCUMENT ------------------------------------------------------- To view the readme.txt on-screen in Notepad, maximize the Notepad window. To print the readme.txt, open it in Notepad or another word processor, and then, on the File menu, click Print. ------------------------------------------------------------------------------------------------------------------------------------------ CONTENTS ------------------------------------------------------------------------------------------------------------------------------------------ 1.0 Overview 2.0 Prerequisites 3.0 Oracle Financial Services Regulatory Reporting Resolved Issues and enhancements (addressed in this patch) 4.0 Oracle Financial Services Analytical Applications Infrastructure Known Issues 5.0 Oracle Financial Services Regulatory Reporting Known Issues 6.0 Oracle Financial Services Behavior Detection Platform 6.2.4 Closed Issues 7.0 Registering the RR product with patch_installer 8.0 Steps to apply Oracle Financial Services Regulatory Reporting 2.5.2.0.0 9.0 Uninstalling and re-applying the 2.5.2.0.0 patch ------------------ 1.0 Overview ------------------ 1.1 This patch upgrades OFSRR version 2.2.2.0.3 or higher to the latest version 2.5.2.0.0 1.2 This patch also contains fixes for defects and enhancements. For more details, see section 3.0. --------------------- 2.0 Prerequisites --------------------- 2.1 Before applying Oracle Financial Services Regulatory Reporting 2.5.2.0.0 upgrade, it is required to install or upgrade to OFSRR 2.2.2.0.3 or higher version 2.2 Before applying Oracle Financial Services Regulatory Reporting 2.5.2.0.0 upgrade, it is required to apply OFSAA 7.3.5.0.0 2.3 This patch requires the prior installation of Patch Installer Utility 1.0.2.0.1 (PIU 1.0.2.0.1) 2.4 This patch requires the prior installation of FCCM 6.2.4.0.0 BD, FCCM 6.2.4.0.0 UI and FCCM 6.2.4.0.1 upgrades if it is to be integrated with OFSRR ----------------------------------------------------------------------------------------------------------------------------------------- 3.0 Oracle Financial Services Regulatory Reporting Resolved Issues and enhancements (addressed in this patch) ----------------------------------------------------------------------------------------------------------------------------------------- 3.1 This patch upgrades OFSRR to 2.5.2.0.0 ---------------------------------------------------------------------------------------------------------------- 4.0 Oracle Financial Services Analytical Applications Infrastructure Known Issues Note: For more information on the following Known Issues you may contact the Oracle support team. ------------------------------------------------------------------------------------------------------------------ --------------------------------------------------- 5.0 Oracle Financial Services Regulatory Reporting Known Issues Note: For more information on the following Known Issues you may contact the Oracle support team. --------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- 6.0 Oracle Financial Services Behavior Detection Platform 6.2.1 Closed Issues Note: For more information on the following Closed Issues you may contact the Oracle support team. ------------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------- 7.0 Registering the RR product with patch_installer --------------------------------------------------- Refer to Patch Installer Guide provided along the Patch Installer Utility 1.0 for registering the RR application ------------------------------------------------------------------------------------------------------------------------------------------ 8.0 Steps to apply Oracle Financial Services Regulatory Reporting 2.5.2.0.0 ------------------------------------------------------------------------------------------------------------------------------------------ a. PATCH CONTENTS ------------------ The following files and folders are included with this patch/hotfix: 2.5.2.0.0.tar.gz Readme_2.5.2.0.0.txt (this readme file) 2.5.2.0.0_Fct_Reg_Rep_Backup.sql ProductSuppliedMetadata b. The following subsystems are affected by this patch/hotfix: --------------------------------------------------------------- ficdb ficweb ftpshare c. Patch installation directory references ------------------------------------------- Name Description --------------------------- -------------------------------- <USER_INSTALL_DIR> Directory containing installed patch_installer <USER_PATCH_DIR> Directory containing the patch tar.gz file <PRODUCT_HOME> Directory where Stage 3 (FCCM + RRS) was installed with the Patch Installer Utility. <DBUTILITY_INSTALL_DIR> Directory where Behavior Detection Stage 1 is installed with DB_utility. -------------------------------------------------------------------------------------------------------------- d. Instructions to apply the upgrade patch -------------------------------------------- 1. Take the backup of the files both in Application and Web layers before proceeding. 2. Take the backup of Atomic and Config database schemas 3. Execute "2.5.2.0.0_Fct_Reg_Rep_Backup.sql" file from path <USER_PATCH_DIR>/2.5.2.0.0 under RR Atomic Schema. Note: Ignore ORA-02289 errors while execution of the above script. 4. Make sure the App and Web Servers are up and running 5. Change to the <USER_INSTALL_DIR>/patch_installer/mantas_cfg directory. Open the "install.cfg" and check the "patch.execute.sql" parameter should be set to 'Y' as below. patch.execute.sql=Y 6. Change to the .<USER_INSTALL_DIR>/patch_installer directory. 7. Type "./patchUtil.sh install" to install the patch. 8. When prompted, provide the complete directory path where the hotfix tar.gz file is located: <USER_PATCH_DIR>/2.5.2.0.0.tar.gz 9. When prompted as below, Enter 'Y' and proceed Install Patch: Applying this patch will override any customizations/changes done on the existing functionalities offered in the default product release. Also the database updates performed by this patch cannot be uninstalled by the Patch Installer. The Patch Installer will only uninstall the file system files and thus a backup is recommended before this installation. confirm by entering 'Y' (N to stop execution) : 10. When prompted for the properties file, press Enter to continue the installation without this file 11. When prompted, provide the installation comments 12. When prompted, enter the infodom folder name for 'RRS' 13. When prompted as below, press Enter to run the database scripts and proceed Do you want to execute script '2.5.2.0.0_Execution_Order.cfg' press Enter {N not to run particular script} : 14. When prompted, enter the username and password for config schema user 15. When prompted, enter the username and password for rrs schema user 16. When prompted, enter replacement tokens for RRSINFODOM, RRSSEGMENT, rev_user(config user) and CONTEXT_NAME 17. At the end of the patch installation successful message should be displayed as below, Patch '<USER_PATCH_DIR>/2.5.2.0.0.tar.gz ' installed successfully !! 18. Check the PatchUtil.log under <USER_INSTALL_DIR>/patch_installer/logs and data model upload log under ftpshare folder which is provided at the time of registering the patch for any errors. Note: The following is applicable for existing customers of USSAR for style sheet changes Edit the CustomLHSMenu.xml located at <PRODUCT_HOME>/ficapp/common/FICServer/conf as below: 1. Search for the tag <PARAMETERS> 2. Add the line <PARAM NAME="cssFileName" VALUE="CSS_OFSAAI"/> under above tag 3. Save the file 19. Recreate and deploy the Oracle Financial Services Analytical Applications Infrastructure war in Web application server. Note: For more information on rebuilding and deploying Oracle Financial Services Analytical Applications Infrastructure war, refer to the Oracle Financial Services Analytical Applications Infrastructure Installation and Configuration guide. 20. Delete the contents of Temp folders of web application server. For example, for Websphere navigate to "profiles/<profile name>/temp" folder, for Tomcat, navigate to "work" folder, and for Weblogic, navigate to domains/<Domain Name>/servers/AdminServer/tmp. folder. 21. Start both the application and web application servers. 22. After successful deployment, follow OFSRR Administration Guide, Release 2.5.2 to complete the setup ------------------------------------------------------------------------------------------------------------------------------------------------------ Note: From RR 2.5.1.0.0 release onwards there is a change in the OFSRR Web service configuration for the customers who are using Mantas 5.x versions. This is a mandatory configuration which should be performed. Refer to Chapter 3, OFSRR Administration Guide, Release 2.5.2 for configuration of OFSRR Web service URL ------------------------------------------------------------------------------------------------------------------------- 9.0 Uninstalling and re-applying the 2.5.2.0.0 patch ------------------------------------------------------------------------------------------------------------------------- a. Uninstalling the patch. 1. All the post installation steps performed manually after the successfull application of patch needs to be revertrd back. For any check sum error for any file while uninstalling the patch, take the original files from 2.5.2.0.0.tar.gz patch manually and put it at the required location. 2. To uninstall the patch , run the below command in the putty from <USER_INSTALL_DIR>/patch_installer Directory, provide the patch name and comments that need to be uninstalled . ./patchUtil.sh uninstall Patch Uninstallation: Enter the Patch Name to be UnInstalled : 2.5.2.0.0 Patch Uninstallation: Enter the Comments for the Patch to be Uninstalled : <Comments_optional> b. Re-apply the 2.5.2.0.0 patch as per section 8.0.d ============================================================================================================================================================================================================================================================================================================ (c) 2014 by Oracle Financial Services Software, Inc. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise without the prior written permission of Oracle Financial Services Software, Inc.