Oracle Financial Services Patch Installer 1.0 Patch/Hotfix Readme File June 2014 Release: 1.0.2.0.0 This document provides information to upgrade the Oracle Financial Services Patch Installer version 1.0 to latest release 1.0.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 Patch Installer Resolved Issues and enhancements (addressed in this patch) 4.0 Oracle Financial Services Patch Installer Known Issues 5.0 Steps to apply Oracle Financial Services Patch Installer 1.0.2.0.0 6.0 Documents impacted in this release 7.0 Files Included in This Patch ------------------ 1.0 Overview ------------------ 1.1 This patch upgrades Patch Installer version 1.0 to the latest release 1.0.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 Patch Installer version 1.0.2.0.0, it is required to install Patch Installer 1.0. 2.2 For Product registration (if not done), please refer "chapter 4 Using the Patch Installer" section "Instance Registration" Document "Patch Installer Guide or pig_1 0_1ed.pdf" from below link, http://docs.oracle.com/cd/E41197_01/homepage.htm (Note: Product Registration is a onetime activity, ignore if already done) ----------------------------------------------------------------------------------------------------------------------------------------- 3.0 Oracle Financial Services Patch Installer Resolved Issues and enhancements (addressed in this patch) ----------------------------------------------------------------------------------------------------------------------------------------- 3.1 Issue 17073106: Patch Installer should have a configurable option of loading the scenario or executing the SQL's. Patch Installer should have a configurable option of loading the scenario or executing the SQL's. The Patch Installer will execute the SQL's or load the scenario without any manual intervention of the user. 3.2 Issue 16882253: Patch Installer Utility should replace the INFODOM place holder in the xml files for KYC. 3.3 Issue 18088981: Patch Installer should have a warning message to let the client know to re-apply customizations when applying the patch. 3.4 Issue 18482163: Patch Installer should take care of copying files inside FTPSHARE to support different FCCM Application's. --------------------------------------------------------------------------------------------- 4.0 Oracle Financial Services Patch Installer Known Issues Note: For more information on the following Known Issues you may contact the Oracle support team. ---------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------- 5.0 Steps to apply Oracle Financial Services Patch Installer 1.0.2.0.0 ------------------------------------------------------------------------------------------------- a. PATCH CONTENTS ------------------ The following files are included with this patch/hotfix: mantas_patchutil_message_lib_en.dat dbutil.jar patchUtility.jar PatchManifest.xsd Readme_1.0.2.0.0.txt b. The following subsystems are affected by this patch/hotfix: --------------------------------------------------------------- Patch Installer c. The upgrade instructions refer to the following directories: -------------------------------------------------------------- Name Description --------------------------- -------------------------------- Directory containing patch installer components Directory containing the patch / hotfix components To apply the Patch Installer 1.0 patch (1.0.2.0.0) on each patch_installer server ------------------------------------------------------------------------------------------- 1. Change to the /patch_installer directory. 2. Take a backup of the patchUtility.jar located at /patch_installer which will be replaced in step 6. 3. Take a backup of the mantas_patchutil_message_lib_en.dat located at /patch_installer/mantas_cfg/etc which will be replaced in step 6. 4. Take a backup of the PatchManifest.xsd located at /patch_installer/mantas_cfg/etc/dtd which will be replaced in step 6. 5. Take a backup of the dbutil.jar located at /patch_installer/lib directory which will be replaced in step 6. 6. Copying the Hotfix files. a. Copy the patchUtility.jar file enclosed in to /patch_installer directory. b. Copy the mantas_patchutil_message_lib_en.dat file enclosed in to /patch_installer/mantas_cfg/etc directory. c. Copy the PatchManifest.xsd file enclosed in to /patch_installer/mantas_cfg/etc/dtd directory. d. Copy the dbutil.jar file enclosed in to /patch_installer/lib directory. 7. Edit the install.cfg located at /patch_installer/mantas_cfg directory and add the following list of parameters if they are not present: a. ############################## # Added For Patch_1.0.2.0.0 # ############################## # etl repository File Path where is the path etl.repositoryFile.path=etlapphome patch.execute.sql=Y patch.scenario.load=Y Note: The property for patch.execute.sql should set to Y if the user expects the patch installer to do an automatic execution of the database sql scripts when a patch is installed. Note: The property for patch.execute.sql should set to N if the user will execute the database scripts manually later using the DB builder utility of Database subsystem. Note: The property for patch.scenario.load should set to Y if the user expects the patch installer to do an automatic load of the scenario XML file when a patch is installed. Note: The property for patch.scenario.load should be set to N if the user will load the scenario manually later using the sm_load.sh from database subsystem. # Tokens which are need to replaced by Patch Utility tokenType=@, ##, # # Specify whether score can be updated load.score.update=Y Note: You can set the above property as Y or N. If the property load.score.update is set to Y, then the scenario load utility will load the scoring rules from the scenario xml file. If load.score.update = N then the scenario load utility(sm_load) will not update either the binding name or the value_tx columns but if score is deactivated then sm_load will deactivate the score and respective entry will be made in KDD_score_hist. b. Edit the install.cfg located at /patch_installer/mantas_cfg directory. locate and update the following line if it is not updated yet: dbscript.execution.users=(system|business|mantas|market|miner|ingest|report|kdd|algorithms|case|config|fatca|ctr|kyc|fsdf) Replace it with: dbscript.execution.users=(system|business|mantas|market|miner|ingest|report|kdd|algorithms|case|config|fatca|ctr|kyc|fsdf|rrs) locate and update the following line if it is not updated yet: subsystem.infodom.FTPSHARE=RRS,KYC,OR,AM,CM,FSDF,CTR,FATCA Replace it with: subsystem.infodom.FTPSHARE=RRS,KYC,OR,AM,CM,FSDF,CTR,FATCA,PTA c. Edit the install.cfg located at /patch_installer/mantas_cfg directory. locate and update the following line if it is not updated yet: patch.tokenreplace.fileformat=.properties,.sh,.xml,.cfg,.template Replace it with: patch.tokenreplace.fileformat=.properties,.xml,.cfg,.template 8. Keep a record of the builds and patches applied to each application server, and the date/time they were applied. 9. Send an email message to mantas_support_us_grp@oracle.com indicating that the patch/hotfix has been applied. ----------------------------------------- 6.0 Documents impacted in this release ----------------------------------------- ------------------------------------------------------------- 7.0 Files Included in This Patch ------------------------------------------------------------- mantas_patchutil_message_lib_en.dat dbutil.jar patchUtility.jar PatchManifest.xsd ================================================================================== (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.