Oracle Financial Services Compliance Regulatory Reporting
Contents
1. c Execute the following command OFSBDF HOME database db tools bin run dbbuilder utility sh the appropriate cfg file from step a d Enter the password of OFS CRR atomic schema user password when it prompts e Check the lt OFSBDF_HOME gt database db_tools logs db_builder log for any error in execution 6 Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR CHAPTER 3 Multiple AML Systems Prerequisites This section explains about the prerequisites to be added in the web xml if its a standalone application The following screenshot shows the web xml files before entering axis servelet lt serviet mapping xmins http java sun com xml ns javaee 6 xmins web http java sun com xml ns javaee web app 2 5 xsd lt servlet name gt QuestionreAnalyse lt servlet name gt lt url pattern gt QuestionreAnalyse lt url pattern gt lt servlet mapping gt servlet mapping xmins http java sun com xml ns javaee_6 xmins web http java sun com xml ns javaee web app 2 5 xsd gt lt servlet name gt QustnnaireAnlyse0ptions lt servlet name gt lt url pattern gt QustnnaireAnlyseOptions lt url pattern gt lt servlet mapping gt lt servlet gt lt servlet name gt RREServlet lt servlet name gt lt servlet class gt com ofs reveleus rrs servlets RREServlet lt servlet class gt lt servlet gt I lt servler gt lt servlet name gt RRDownloadServlet lt ser2. For mote information refer section Security Attribute2 Static Information in the Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide DIM_DOMAIN3 xlsx must be filled with Case Type and Case SubType which are available in OFSFCCM For more information refer section Security Attribute3 Static Information in the Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide DIM_DOMAIN4 xlsx must be filled with Organizations which are available in OFSFCCM For more information refer section Security Attribute4 Static Information in the Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide DIM DOMAINSS xlsx must be filled with Scenario Classes which are available in OFSFCCM For more information refer section Security Attribute5 Static Information in the Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR 3 Configuring Security Attributes for Users Chapter 2 Loading the Static Data and Product Supplied Metadata into OFSRR 12 13 14 15 e fct_transmitter_info For more information refer sectionTransmitter Information in Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide f dim filing inst For more information refer section Filing Institution Information in Oracle Financ
3. configured to capture data coming from OFSFCCM If OFS CRR is to be configured to accept data from Oracle Mantas 5 x then execute the following SQL using OFS CRR atomic schema user UPDATE SETUP_WEBSERVICE_CONFIG SET V_WEB_SERIVICE_URL lt Mantas 5 x URL gt services RRSUpdateService WHERE V_SOURCE_NAME MANTAS COMMIT Note The above highlighted placeholder needs to be updated with the mantas URL c For disabling or enabling the feedback to Mantas execute the following SQL using OFS CRR atomic schema user UPDATE SETUP_WEBSERVICE_CONFIG T SET T F_ENABLE_FLAG lt N or Y gt WHERE T V SOURCE NAME MANTAS COMMIT To enable feedback value must be Y and for disabling feedback it should be N Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR 11 Integrating OFS CRR Application with Oracle Manatas 5 x Chapter 3 Multiple AML Systemes 12 Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR CHAPTER 4 Configuring Parameters Report Lock Period If any user forgets to logoff from the OFS CRR application or if the OFS CRR screen is closed while accessing a report the report gets locked for a pre configured duration By default the duration is 60 minutes This duration can be altered as per your requirement Execute the following SQL using OFS CRR atomic schema user I UPDATE APPLN PARAME
4. typed at a prompt User input Monospace Directories and subdirectories File names and extensions Process names Code sample including keywords and variables within text and as separate paragraphs and user defined program elements within text Variable Substitute input value vi Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR CHAPTER 1 OFS CRR User Setup This chapter describes how to provide access to users in the OFS CRR applications through the user groups This chapter includes the following topics e Creating Users and User Groups e Mapping User to Infodom e Mapping Users To User Groups Creating Users and User Groups 1 For creating users and user groups refer to Oracle Financial Services Analytical Applications Infrastructure User Manual Release 7 3 Note If you are integrating OFS CRR with OFSFCCM then do not create OFS CRR administration user The OFSFCCM administration user to be used for OFS CRR administration as well 2 Once the users groups ate created map the roles to the user groups as per the following list Note While creating user groups manually using SMS AAI interface use the precedence range values between 3001 to 4000 e For RR Analyst group map the following roles m Access to US SARDI Report m Reg Report Analyst role e For RR Supervisor group map the following roles m Access to US SARDI Report m Reg Report Supervisor
5. Manage Parameters gt Manage Common Parameters c Select Deployment Based in the Parameter Category drop down list d Select Regulatory Report Solution Web Service from the Parameter Name drop down list e Set Parameter Value text box Y f Update the OFS CRR web service URL by setting Attribute 3 Value lt OFS CRR URL gt services InitiateRequest g Click Save h To update OFS CRR Webservice password in OFSFCCM Navigate to FCCM gt Administration gt Web Service Configuration gt Common Web Service 1 Enter the same password set in OFS CRR side in Enter Password for Compliance Regulatory Reporting Web Service text box and click Encrypt j Logout from the application 10 Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR Integrating OFS CRR Application with Oracle Manatas 5 x Chapter 3 Multiple AML Systemes Integrating OFS CRR Application with Oracle Manatas 5 x 1 For Oracle Mantas 5 x a Update the variables in lt Oracle Mantas Home gt alert_management alert_mgmt WEB INF classes conf mantas_cfg install cfg as follows RRS Web Service parameters rrs userid rruser rrs password lt Encrypt the same password given in step 1 using Change Password Utility of Oracle Mantas 5 x gt rrs service url lt OFS CRR URL gt services InitiateRequest rrs version 2 5 then recreate the war file and deploy in the web application server b By default OFS CRR Web Service is
6. ORACLE Oracle Financial Services Compliance Regulatory Reporting Administration Guide US SAR Release 8 0 Jannary 2015 ORACLE FINANCIAL SERVICES Oracle Financial Services Compliance Regulatory Reporting Administration Guide US SAR Release 8 0 January 2015 Document Control Number 9MN11 2 5 1 01 04 Document Number AG 15 RR 004 2 5 2 01 Oracle Financial Services Software Inc 1900 Oracle Way Reston VA 20190 Document Number AG 15 RR 004 2 5 2 01 First Edition January 2015 Copyright 1996 2015 Oracle and or its affiliates All rights reserved Printed in U S A 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 Trademarks Oracle is a registered trademark of Oracle Corporation and or its affiliates Other names may be trademarks of their respective owners Oracle Financial Services Software Inc 1900 Oracle Way Reston VA 20190 Phone 703 478 9000 Fax 703 318 6340 Internet www oracle com financialservices Contents UU R v Who Should Use this Guide erret reete tee intet xa ei sp Biss sn else v How this Guide is Organized bietet tii redtetiteerdie at ahnen cete obe Ria a deisi don v Where to Find More Information vercion can S SEE EEr dice diia vi Conventions Usedin this G
7. Oracle Financial Services Compliance Regulatory Reporting 2 5 1 Administration Guide US SAR About This Guide This guide provides comprehensive instructions to perform administration activities to configure the Oracle Financial Services Compliance Regulatory Reporting herein referred to as OFS CRR This chapter focuses on the following topics e Who Should Use this Guide e How this Guide is Organized e Where to Find More Information e Conventions Used in this Guide Who Should Use this Guide The Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR is designed for use by Oracle Financial Services administration users Their roles and responsibilities as they operate within the OFS CRR application include the following e System Administrator This user configures maintains and adjusts the system and is usually an employee of a specific Oracle Financial Services client The System Administrator maintains user accounts and roles archives data and loads data feeds How this Guide is Organized The Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR includes the following topics e Chapter 1 OFS CRR User Setup describes the steps involved in creation of users and user groups e Chapter 2 Loading the Static Data and Product Supplied Metadata into OFS CRR explains the steps involved in loading static and product supplied meta data e Chapter 3 Multip
8. Rol m RR Supervisor with Edit e For RR Super User group map the following roles m Access to US SARDI Report m Reg Report Supervisor Rol m RR Supervisor with Edit m Reg Report Analyst role m RR Admin with Edit m Reg Report Admin Role e For RR Auditor group map the following roles m Access to US SARDI Report m Auditor e For RR Administrator group map the following roles Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR 1 Mapping User to Infodom Chapter 1 OFSRR User Setup m Access to US SARDI Report RR Admin with Edit m Reg Report Admin Role e Io View the Due Date map the following role to the required user group m RR Due Date with View e To View and Edit the Due Date map the following role to the required user group E RR Due Date with Edit Mapping User to Infodom Map all RR user groups to RR Infodom For mapping user groups to infodom refer to Oracle Financial Services Analytical Applications Infrastructure User Manual Release 7 3 Mapping Users To User Groups Map all RR users to respective user groups For information on User to User Group mapping refer to Oracle Financial Services Analytical Applications Infrastructure User Manual Release 7 3 Configuring US SAR Template 1 Execute the following script in the Oracle Financial Services Analytical Applications Infrastructure configuration schema update cssms_role_function_map m set m v_function_code RRSEDIT w
9. TERS SET V ATTRIBUTE VALUE1 DURATION IN MINUTES gt WHERE V ATTRIBUTE NAME1 LOCK PERIOD IN MINUTES COMMIT Activity Information This parameter is set to Y if activity dates amount needs to be imported from AML Else the parameter is set to N UPDATE APPLN PARAMETERS SET V ATTRIBUTE VALUEl Y or N gt WHERE V ATTRIBUTE NAME1 ACTIVITY AMOUNT AND DATES FLAG COMMIT Default Domain 1 This parameter identifies the default jurisdiction assignment while creating a report manually in OFS CRR Execute the following query in OFS CRR atomic schema as required UPDATE APPLN PARAMETERS SET V ATTRIBUTE VALUE2 VALUE OF DEFAULT DOMAIN 1 WHERE V ATTRIBUTE NAME1 ENABLE DEFAULT DOMAIN1 COMMIT By default the flag to enable default domain 1 on Ul is set to Y OFS CRR can be configured not to display any default value for domain 1 in UI while creating new report by setting the flag to N Execute the following query in OFS CRR atomic schema as required UPDATE APPLN PARAMETERS SET V ATTRIBUTE VALUEl Y or N WHERE V ATTRIBUTE NAMEI ENABLE DEFAULT DOMAINI COMMIT I Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR 13 Default Domain 1 Chapter 4 Configuring Parameters 14 Oracle Financial Services Compliance Regulatory Reporting 8 0 Adm
10. et gt lt servlet name gt AdminServlet lt servlet name gt lt lt display name gt Axis Admin Servler lt display name gt gt lt servlet class gt org apache axis transport http AdminServlet lt servlet class gt lt servlet gt lt servlet gt lt servlet name gt AxisServlet lt servlet name gt lt display name gt Apache Axis Seryler lt display name gt gt lt servlet class gt org apache axis transport http AxisServlet lt servlet class gt lt servlet gt lt servlet mapping gt lt servlet name gt AxisServlet lt servlet name gt lt url pattern gt servlet AxisServlet lt url pattern gt lt servlet mapping gt lt servlet mapping gt lt servlet name gt AxisServlet lt servlet name gt lt url pattern gt jws lt url pattern gt lt servlet mapping gt lt servlet mapping gt lt servlet name gt AxisServlet lt servlet name gt lt url pattern gt services lt url pattern gt lt servlet mapping gt lt servlet mapping gt lt servlet mapping gt lt servlet name gt AxisServlet lt servlet name gt lt url pattern gt serylet AxisServlet lt url pattern gt lt servlet mapping gt N lt servlet mapping gt lt servlet name gt AxisServlet lt servlet name gt url pattern jws url pattern F servlet mapping d serviet mapping lt servlet name gt AxisServlet lt servlet name gt url pattern services url pattern lt servlet mapping gt The
11. following screenshots shows the web xml files after entering the axis servelet entries 8 Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR Integrating OFS CRR Application with OFSFCCM Chapter 3 Multiple AML Systemes lt servlet mapping xmins http java sun com xml ns javaee 6 xmlns web http java sun com xml ns javaee web app 2 5 xsd lt servlet name gt QuestionreAnalyse lt servlet name gt lt url pattern gt QuestionreAnalyse lt url pattern gt lt servlet mapping gt lt servlet mapping xmlns http java sun com xml ns javaee 6 xmlns web http java sun com xml ns javaee web app 2 5 xsd gt lt servlet name gt QustnnaireAnlyseOptions lt servlet name gt lt url pattern gt QustnnaireAnlyseOptions lt url pattern gt lt servlet mapping gt lt servlet gt lt servlet name gt RREServlet lt servlet name gt servlet class gom ofs reyeleus rrs serylets RREServletc servlet class lt servlet gt lt servlet gt lt servlet name gt RRDownloadServlet lt servlet name gt servlet class oom ofs reyeleus rrs serylets RRDownloadServletc servlet class lt servlet gt serviet lt servlet name gt AdminServlet lt servlet name gt lt lt display name gt Axis Admin Sexvler lt display name gt gt lt servlet class gt erg apache axis transport http AdminServlet lt servlet class gt lt servlet gt lt servlet gt lt servlet name gt AxisServlet lt
12. here m v_function_code RRSACC and m v_role_code RRANA 2 Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR CHAPTER 2 Loading the Static Data and Product Supplied Metadata into OFS CRR Loading Client Specific Data 1 To add client specific security attributes to OFS CRR system navigate to lt ftpshare path gt STAGE Excelupload Templates The lt ftpshare path gt is the same path given in variable APP_DRIVE_TM while installing OFSAAI For more information refer Oracle Financial Services Analytical Applications Infrastructure Installation and Configuration Guide 2 Download the following Excel sheets to the Windows machine from the path given in the previous step H j gt Q noon oT m DIM_DOMAIN1 x1sx DIM_DOMAIN2 x1sx DIM DOMAIN3 xlsx DIM DOMAINA4 xlsx DIM DOMAIN5 xlsx fct transmitter info dim filing inst dim users fct branch info fct fininst info 3 Add data in each Excel sheet as per your report requirement by referring to Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide 4 DIM DOMAIN1 xlsx must be filled with Jurisdictions which are available in OFSFCCM For more information refer section Security Attributet Static Information in the Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide a DIM_DOMAIN2 xlsx must be filled with Business Domains which are available in OFSFCCM
13. ial Services Compliance Regulatory Reporting Data Model Reference Guide g dim_users For more information refer section User information in Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide h fct_branch_info For more information refer section Branch Information in Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide i fet_fininst_info For more information refer section Financial Institution Information in Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide Login to OFS CRR as Admin user created in the previous step Navigate to Unified Metadata Manager gt Data Entry Forms and Queries gt Excel Upload The Excel Upload page is displayed Note After logging into the application make sure the OFS CRR application Information Domain is selected from the drop down list at the left hand corner of the page Click Browse under Excel File to Upload Select the Excel sheet Click Arrow button next to Browse 10 11 Preview the data created under the Preview section In the Excel Entity Mappings section click Arrow Select the table name with the same name as that of the Excel sheet Click Upload The following message is displayed Successfully uploaded data Click OK Note Scan the web application server log for any errors after uploading each Excel sheet For example for Oracle Weblogic the web application
14. ilde su eter orte terr ne a nts rae p een vi CHAPTER 1 OFS CRR User SetUP ooooooooooccoconicccccconnnccccccancnncnnnnann cnn nn nn nana nn cnn 1 Creating Users and Uset Groups ep 1 Mapping User drelbetoito rue E 2 Mapping Users To User Groups nun sinne testetusncnssderbesstessaenbedes 2 Contig rino US SAR Template cta tato 2 CHAPTER 2 Loading the Static Data and Product Supplied Metadata into OFS A A Measham Mahe aeeal 3 Loading Client voz uPiMPPic E 3 Contiguring Security Attributes for Users svisisisscscisscssssvcsscvssvovecssvavarsosensavarvavensavarvataesivonstosesussuotinsbvenseusdsevensevensovonsnneoes 4 Loading Product Supplied Metadata s ee cope ie entree perta nsi e R 5 CHAPTER 3 Multiple AML Systems sss 7 Pret QUIS 7 Integrating OFS CRR Application with OFSFCCM ecicconinnnnincnnoncononcnnoncncnncnrnnonconon canon concn con arnn canon canon can an canon nennen 9 Integrating OFS CRR Application with Oracle Manatas 5 x uensnnsnennenennenennenennenenennenennenennenenenenemennnnennenennn 11 CHAPTER 4 Configuring ParamMeterS ooooooononiinccnnnnnnnncccccccccnnnnnnncnn cnn nnnnnncnccnn 13 Report Lock Period aiii AA AA AAA A 13 Activity Informationen ecete ted AAA BnRERkellein 13 Default Doa Dunn AA Bun 13 Oracle Financial Services Compliance Regulatory Reporting Administration Guide US SAR iii Contents iv
15. inistration Guide US SAR ORACLE
16. le AML Systems explains the steps involved in integrating RR application with OFSFCCM Oracle Mantas 5 x application e Chapter 4 Configuring Parameters explains the steps to configure the report lock time period activity information and the default jurisdiction Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR About this Guide Where to Find More Information For more information on OFS CRR refer to the following documents Oracle Financial Services Compliance Regulatory Reporting Installation Guide Release 8 0 Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide Release 8 0 Oracle Financial Services Compliance Regulatory Reporting United States Suspicious Activity Report User Guide Release 8 0 Oracle Financial Services Compliance Regulatory Reporting Web Services Guide Release 8 0 Oracle Financial Services Compliance Regulatory Reporting ReadMe Release 8 0 To find additional information about how Oracle Financial Services solves real business problems see our website at www oracle com financialservices Conventions Used in this Guide Table 1 lists the conventions used in this guide Table 1 Conventions Used in this Guide Convention Meaning Italics Bold e Names of books chapters and sections as references e Emphasis e Object of an action menu names field names options button names in a step by step procedure Commands
17. ll applications Profile name ear deployments Profile name Profile name war WEB INF web xml Integrating OFS CRR Application with OFSFCCM OFSFCCM or Oracle Mantas 5 x can be integrated with OFS CRR to post alerts or cases to generate reports with Webservice Calls To know more about Webservices refer Oracle Financial Services Compliance Regulatory Reporting Webservices Guide Both OFSFCCM Oracle Mantas 5 x and OFS CRR application must be configured to use this webservice This is an optional configuration and is required only when you want to integrate OFS CRR with OFSFCCM Oracle Mantas 5 x 1 For OFS CRR The OFS CRR application s Webservice is already configured with a default user name and password This default password must be reset before performing the OFS CRR and OFSFCCM Oracle Mantas 5 x integra tion This step is mandatory from security aspect Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR 9 Integrating OFS CRR Application with OFSFCCM Chapter 3 Multiple AML Systemes a To update password follow these steps 1 Log in as Administrator user ii Navigate to Administration gt Web Service Configuration gt Regulatory Report Web Service iii Enter the User ID as rruser Do not add any other user name iv Enter the desired password v Click Save 2 For OFSFCCM a Login to the OFSFCCM application as Administration User b Navigate to FCCM gt Administration gt
18. lled on top of OFSFCCM click FCCM then select the Compliance Regulatory Reporting tab The OFS CRR application page displays OR 9 If OFS CRR is installed as a standalone application click Compliance Regulatory Reporting The OFS CRR application page displays Note Follow these steps whenever a new user is added or modified for User Details User Group mapping Roles mapping Security Attribute mapping and Password Change in the OFS CRR application Loading Product Supplied Metadata Follow these steps to configure database Note The following steps are not required if you already have the OFSFCCM application 1 Execute the following SQL after updating lt RR Admin User Group gt with the User Group name created for the RR admin user UPDATE CONFIGURATION SET PARAMVALUE lt RR Admin User Group gt WHERE PARAM NAME UCM_GROUP_NAME COMMIT 2 Create a directory TempDocument in parallel to where UPLOAD_AREA_CM directory is created while installing OFSAAL Refer to the Oracle Financial Services Analytical Applications Infrastructure Installation and Configuration Guide for more details 3 Add the meta data in database by following these steps Note The following steps can be followed if OFSBDF is installed If OFSBDF is not installed or OFS CRR is installed as a standalone then run these sql s manually in RR Atomic schema 4 Copy following files from ProductSuppliedMetadata folder under Installer Ki
19. server log is wls out for Websphere the web application server log is Systemout log and Systemerr 10g Close the Excel Upload page Configuring Security Attributes for Users If OFS CRR is installed on top of OFSFCCM click FCCM Navigate to Administration menu gt User Administration gt Regulatory Report User s Attribute Administration A new page displays a drop down list containing the OFS CRR users created in the previous step OR If OFS CRR is installed as a standalone application click Compliance Regulatory Reporting A new page displays a drop down list containing the OFS CRR users created in the previous step Assign attributes to each user from the drop down list Close the Regulatory Report User s Attribute Administration screen Logout from the OFS CRR application Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR Loading Product Supplied Metadata Chapter 2 Loading the Static Data and Product Supplied Metadata into OFSRR 6 Login with each created user in the OFS CRR The Password Reset page opens when the user logs in for the first time immediately after the creation or every time SYSADMN user resets the password for various reasons such as when the user forgets the password or when the password is locked 7 Reset the password The OFS CRR application login page displays Note You must log into the application using the new password 8 If OFS CRR is insta
20. servlet name gt lt lt display name gt Apache Axis Seryler lt display name gt gt lt servlet class gt 0rg apache axis transport http AxisServlet lt servlet class gt lt servlet gt lt servlet mapping gt lt servlet name gt RREServlet lt servlet name gt lt url pattern gt RREServlet lt url pattern gt lt servlet mapping gt lt servlet mapping gt lt servlet name gt RRDownloadServlet lt servlet name gt lt url pattern gt RRDownloadServlet lt url pattern gt lt servlet mapping gt lt servlet mapping gt lt servlet name gt AxisServlet lt servlet name gt lt url pattern gt serylet AxisServlet lt url pattern gt lt servlet mapping gt lt servlet mapping gt lt servlet name gt AxisServlet lt servlet name gt lt url pattern gt jys lt url partern gt lt servlet mapping gt lt servlet mapping gt lt servlet name gt AxisServlet lt servlet name gt lt url pattern gt services lt url pattern gt J servlet mapping gt The entries need to be made in the following locations FIC WEB HOME webroot WEB INF web xml lt Deployed Area profile ear profile war WEB INF web xml If the server is Websphere then the same entries need to be added in the following location FIC WEB HOME webroot WEB INF web xml lt Deployed Area profile ear profile war WEB INF web xml e Deployed Area profiles Profile name config cells server Node2Ce
21. t to lt OFSBDF_HOME gt database db_tools bin For Egypt STR tomicEgyptSTR sql and AtomicEgyptSTR cfg ot Bahamas STR tomicBahamasSTR sql and AtomicBahamasSTR cfg A F A For Pakistan STR A F A tomicPakistanSTR sql and AtomicPakistanSTR cfg ot New Zealand STR tomicNewZealandSTR sql and AtomicNewZealandSTR cfg For Kenyan STR Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR 5 Loading Product Supplied Metadata Chapter 2 Loading the Static Data and Product Supplied Metadata into OFSRR AtomicKenyaSTR sql and AtomicKenyaSTR cfg For US SAR Copy the below files from the ProductSuppliedMetadata folder under patch 2 5 1 0 0 SAR_Productsupplied_data cfg and SAR_Productsupplied_data sql a Add rts to variable dbscript execution users available in lt OFSBDF_HOME gt database db_tools mantas_cfg install cfg For example dbscript execution users system business mantas market miner ingest report kdd_alt io kdd algorithms case rrs b Add the following variables in lt OFSBDF_HOME gt database db_tools mantas_cfg db_variables cfg rrs lt OFS CRR Atomic Schema User Name gt Refer place holder RRS_ATOMIC_USER in GRC_InstallConfig xml RRSINFODOM lt OFS CRR Information Domain Name gt Refer place holder INFODOM_1 in GRC_InstallConfig xml RRSEGMENT lt OFS CRR Segment Name gt Refer place holder SEGMENT_1 in GRC_InstallConfig xml
22. vlet name gt lt servlet class gt com ofs reveleus rrs serylets RRDownloadServlet lt servlet class gt lt servlet gt servlet mapping lt servler name gt RREServlet lt servlet name gt lt url pattern gt RREServlet lt url pattern gt lt servlet mapping gt J lt servlet mapping gt lt servlet name gt RRDownloadServlet lt servlet name gt lt url pattern gt RRDownloadServlet lt url pattern gt lt servlet mapping gt Sresource ref gt lt description gt DB Connection RRINFO4 lt description gt lt res ref name gt jdhg RRINFO4A lt res ref name gt lt res type gt jayax sgl DataSource lt res type gt lt res auth gt Container lt res auth gt lt resource ref gt lt web app gt Add the following entries lt servlet gt lt servlet name gt AdminServlet lt servlet name gt lt lt display name gt Axis Admin Servlet lt display name gt gt lt servlet class gt org apache axis transport http AdminServlet lt servlet class gt lt servlet gt lt servlet gt lt servlet name gt AxisServlet lt servlet name gt lt lt display name gt Apache Axis Servlet lt display name gt gt lt servlet class gt org apache axis transport http AxisServlet lt servlet class gt lt servlet gt Oracle Financial Services Compliance Regulatory Reporting 8 0 Administration Guide US SAR Prerequisites Chapter 3 Multiple AML Systemes lt servlet gt lt servl
Download Pdf Manuals
Related Search