Oracle Financial Services Regulatory Reporting Administration Guide
Contents
1. 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 e Names of books chapters and sections as references e Emphasis Bold e Object of an action menu names field names options button names in a step by step procedure Commands 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 lt Variable gt Substitute input value viii Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR CHAPTER 1 Cr eating a User Users must be created with appropriate roles to access the OFSRR application For more information on roles refer Oracle Financial Services Regulatory Reporting User Guide For more information on creating users refer Oracle Financial Services Analytical Application Infrastructure User Manual To create users follow these steps 1 Create a User by logging into the OFSRR application as SYSADMN For more information refer section User Maintenance in OFSAAI User Mannal Note If you are Integrating OFSRR with OFSECM then do not create OFSRR administration user The OFSECM administration user to be used for OFSRR administration2. 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 Regulatory Reporting 2 3 Administration Guide NZ STR includes the following topics e Chapter 1 Creating a User describes the steps involved in user creation e Chapter 2 Loading the Static Data into OFSRR Application explains the steps involved in loading static data e Chapter 3 Integrating OFSRR Application with OFSECM Oracle Mantas 5 x Application explains the steps involved in integration of RR application with OFSECM application e Chapter 4 Configuring Report Lock Period explains the steps to configure the report lock time period Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR About this Guide Where to Find More Information For more information on OFSRR refer to the following documents Oracle Financial Services Regulatory Reporting Installation Guide Release 2 3 Oracle Financial Services Regulatory Reporting Data Model Reference Guide Release 2 3 Oracle Financial Services Regulatory Reporting User Guide Release 2 3 Oracle Financial Services Regulatory Reporting Web Services Guide Release 2 3 Oracle Financial Services Regulatory Reporting Release Notes Release 2 3 To find additional information about how Oracle Financial Services solves real business problems see our website at
3. CM then on the new page navigate to Administration menu gt User Administration gt Regulatory Report User s Attribute Administration This will take you to a drop down list with all the OFSRR users created Assign attributes to each user from each drop down Close the Regulatory Report User s Attribute Administration screen Logout from the OFSRR application Login with each created user in the OFSRR application the application will open password reset page when the user login for the first time immediate after creation or every time SYSADMN user reset the password for various reasons Example forgot password Password locked etc Reset the password The OFSRR application Login page displays You must log into the application using the new password Click Regulatory Reporting link in case of standalone installation The OFSRR application page displays Click FCCM link in case OFSRR is installed on top of OFSECM the Regulatory Reporting tab will be available in one of the tabs in the new page Note Follow the steps mentioned above whenever a new user is added or modified for User Details User Group mapping Roles mapping Security Attribute mapping and Password Change in the OFSRR application 14 Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR CHAPTER 2 Loading the Static Data into OFSRR Application OFSRR application uses the following client provided data as per their business require
4. ORACLE Oracle Financial Services Regulatory Reporting Administration Guide NZ STR Release 2 3 April 2013 ORACLE FINANCIAL SERVICES Oracle Financial Services Regulatory Reporting Administration Guide NZ STR Release 2 3 April 2013 Document Control Number 9MN11 2 3 01 04 Document Number AG 13 RR 004 2 3 01 Oracle Financial Services Software Inc 1900 Oracle Way Reston VA 20190 Document Number AG 13 RR 004 2 3 01 First Edition April 2013 Copyright 1996 2013 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 List A A I nn titin inaii inia v About THIS GUIde A A A AA a A AS vii Who Should Usethis Guide iaa vii Flow this Guide is Diada iaa vii Where to Pind More Informaticas arias dde viii Conventions Used in this Guide ninia cc iartaiicaaia viii CHAPTER 1 Creating a User nu un ain enn Cana Naa Anal en 11 CHAPTER 2 Loading the Static Dat
5. a into OFSRR Application 15 CHAPTER 3 Integrating OFSRR Application with OFSECM Oracle Mantas 5 x APPHCAUON 2 u 2 2 een 17 CHAPTER 4 Configuring Report Lock Period 444 4444 44 19 Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR iii Contents iv Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR List of Tables Table 1 Gonventions Usedin this Guides 3 820K 2 aa Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR List of Tables vi Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR About This Guide This guide provides comprehensive instructions to perform administration activities to configure the Oracle Financial Services Regulatory Reporting herein referred to as OFSRR 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 Regulatory Reporting Administration Guide NZ STR is designed for use by Oracle Financial Services application users Their roles and responsibilities as they operate within the OFSRR application include the following e System Administrator This user configures maintains and adjusts the system and is usually an employee of a
6. as well Authorize the User by logging into the application as SYSAUTH For more information refer section User Authorization in OFSAAI User Manual Create a User Group by logging into the OFSRR application as SYSADMN For more information refer section User Group Maintenance in OFSAAI User Manual Map the User Group to the OFSRR Information Domain For more information refer section User Group Domain Map in OFSAAI User Manual Map the User Group to the appropriate Role For more information refer section User Group Role Map in OFSAAI User Manual a For creating a Supervisor user map Reg Report Supervisor Rol and Access to New Zealand STR roles b For creating an Analyst user map Reg Report Analyst Role and Access to New Zealand STR roles c For creating an Admin user map Reg Report Admin Role role Note You can add more than one user in one User Group who is mapped to one type of role of the same application for example you can create more than one Analyst user in OFSRR Mapping different roles of same application to a User Group for example Analyst and Supervisor role of OFSRR and assigning user is not supported But mapping different roles of different applications for example Executive role of OFSECM and Analyst role of OFSRR is supported Authorize the mapping of User Group to Information Domain and Roles by logging into the application as SYSAUTH For more information refer section User Group Autho
7. be configured to accept data from Oracle Mantas 5 x then execute the following SQL using OFSRR atomic schema user UPDATE APPLN_PARAMETERS SET V_ATTRIBUTE_VALUE1 N WHERE V_ATTRIBUTE_NAME1 ECM FLAG COMMIT 18 Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR CHAPTER 4 Configuring Report Lock Period If any user forgets to logoff from the OFSRR application or if the OFSRR screen is closed while accessing a report the report gets locked for a pre configured duration By default the duration is sixty minutes This duration can be altered as per your requirement Execute the following SQL using OFSRR atomic schema user UPDATE APPLN PARAMETERS SET V_ATTRIBUTE_VALUE1 lt DURATION IN MINUTES gt WHERE V_ATTRIBUTE_NAME1 LOCK PERIOD IN MINUTES COMMIT Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR 19 Chapter 4 Configuring Report Lock Period 20 Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR ORACLE
8. ger gt Data Entry Forms and Queries gt Excel Upload anew screen pops up with an Excel Upload page Note After logging into the application make sure the OFSRR application Information Domain is selected from the drop down list at the left hand corner of the page 14 Click Browse button under Excel File to Upload section 15 Select any one of the excel sheet 16 Click on Arrow button next to Browse button 17 Preview the data created under Preview section 18 In Excel Entity Mappings section click Arrow button 19 Select the table name same as name of the excel sheet 20 Click Upload 12 Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR Chapter 1 Creating a User 21 Click OK on the popup window displaying the message Successfully uploaded data Note Scan the Webapplication Server logs for any errors after uploading each excel sheet For example for Oracle Weblogic it is wls out for Websphere it is Systemout log and Systemerr log 22 Close the Excel upload page Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR 13 Chapter 1 Creating a User 23 24 25 26 27 28 Click FCCM Incase OFSRR is installed on top of OFSECM or Regulatory Reporting In case of Stand alone If it is stand alone installation then a new page with a drop down list displays having all the OFSRR users created in the previous steps If OFSRR is installed on top of E
9. gt Administration gt Manage Installation 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 Param Value text box Y f Click Save g Select Used for Design in the parameter category h Select Application Server in the parameter name Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR 17 Chapter 3 Integrating OFSRR Application with OFSECM Oracle Mantas 5 x Application m Update the OFSRR web service URL by setting Attribute 4 Value lt OFSRR URL gt services InitiateRequest Click Save To update OFSRR Webservice password in OFSECM Navigate to FCCM gt Administration gt RRS Password Encryption Enter the same password set in OFSRR side and Click OK Logout from the application 3 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 below 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 OFSRR URL gt services InitiateRequest rrs version 2 3 then recreate the war file and deploy in the web application server By default OFSRR Web Service is configured to capture data coming from OFSECM If OFSRR is to
10. ments Reporting Entity Details Reporting Entity Location Reporting Person Information Reporting Institution User Information Holiday Details Branch information Follow these steps to load the above data into OFSRR application 1 Download following excel sheets to Windows machine for the templates from lt ftpshare path gt STAGE Excelupload Templates The path for lt ftpshare path gt is the same path as given in variable placeholder FTPSHARE_PATH in GRC_InstallConfig xml a DIM_REPORTING_ENTITY_DTLS xlsx b DIM_REPORTING_ENTITY_LOC xlsx c DIM_REPORTING_PERSON x1sx d DIM_INSTITUTION xlsx e DIM_USERS x1sx f DIM_HOLIDAY_MAINTENANCE xlsx g FCT_BRANCH_INFO xlsx Add data in each excel sheet as per your installation requirement by referring to the Oracle Financial Services Regulatory Reporting Data Model Reference Guide a DIM_REPORTING_ENTITY_DTLS xlsx For more information refer section Reporting Entity Details in Datamodel Reference Guide Datamodel Reference Guide b DIM_REPORTING_ENTITY_LOC x1sx For more information refer section Reporting Entity Location in c DIM_REPORTING_PERSON xlsx For more information refer section Reporting Person Information in Datamodel Reference Guide d DIM_INSTITUTION x1sx For more information refer section Reporting Institution Information in Datamodel Refere
11. nce Guide DIM_USERS x1sx For more information refer section User information in Datamodel Reference Guide f DIM_HOLIDAY_MAINTENANCE x1sx For more information refer section Holiday Maintenance in Datamodel Reference Guide Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR 15 Chapter 2 Loading the Static Data into OFSRR Application g FCT_BRANCH_INFO x1sx For more information refer section Branch Information in Datamodel Reference Guide Login to the OFSRR application as Admin user created in the previous step Note After logging into the application make sure the OFSRR application Information Domain is selected from the drop down list at the left hand corner of the page Navigate to Unified Metadata Manager gt Data Entry Forms and Queries gt Excel Upload anew screen pops up with an Excel Upload page Click Browse button under Excel File to Upload section upload all excel sheets created in the previous step Note The data must be loaded in the same order as given in step 1 Note Scan the Webapplicaiton Server logs for any errors after uploading each excel sheet For example for Oracle Weblogic it is wls out and for Websphere it is Systemout log and Systemerr log Close the Excel upload page 16 Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR CHAPTER 3 Integrating OFSRR Application with OFSECM Oracle Man
12. rization in OFSAAI User Manual Map User to created User Group For more information refer User to User Group section in OFS AAT User Manual Note a Map OFSECM administration User to OFSRR admin group created to get OFSRR administration privileges b If you are integrating OFSRR with OFSECM then additionally map the corresponding OFSECM users to appropriate OFSRR User Group For example map OFSECM Analyst user to OFSRR Analyst User Group or OFSECM Supervisor user to OFSRR Supervisor User Group By doing this the OFSRR application can be accessed directly from the Regulatory Reporting main menu of the OFSECM application by logging in as OFSECM user The standalone OFSRR application can be accessed by both OFSRR and OFSECM users Oracle Financial Services Regulatory Reporting 2 3 Administration Guide NZ STR 11 Chapter 1 Creating a User 8 Authorize the mapping of User to User Group by logging into the application as SYSAUTH For more information refer section User Group Authorization in OFSAAI User Manual 9 To add client specific security attributes to OFSRR 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 10 Download the following Excel sheets to Window
13. s machine from the path given in the previous step a DIM_DOMAIN1 x1sx b DIM_DOMAIN2 xlsx c DIM_DOMAIN3 x1sx d DIM_DOMAIN4 xlsx e DIM_DOMAIN5 x1sx 11 Add data in each excel sheet as per your report requirement by referring to Oracle Financial Services Regulatory Reporting Data Model Reference Guide a DIM_DOMAIN1 x1sx is to be filled with Jurisdictions which are all available in OFSECM application Por more information refer section Security Attribute Static Information in Data Model Reference Guide b DIM_DOMAIN2 x1sx is to be filled with Business Domains which are all available in OFSECM application For more information refer section Security Attribute2 Static Information in Data Model Reference Guide c DIM_DOMAIN3 x1sx is to be filled with Case Type and Case SubType which are all available in OFSECM application For more information refer section Security Attribute3 Static Information in Data Model Reference Guide d DIM_DOMAIN4 x1sx is to be filled with Organizations which are all available in OFSECM application For more information refer section Security Attributed Static Information in Data Model Reference Guide e DIM_DOMAIN5 x1sx is to be filled with Scenario Classes which are all available in OFSECM application For more information refer section Security Attributed Static Information in Data Model Reference Guide 12 Login to OFSRR application as Admin user created in the previous step 13 Navigate to Unified Metadata Mana
14. tas 5 x Application OFSECM Oracle Mantas 5 x applications can be integrated with OFSRR to post alerts cases to generate reports with Webservice Calls To know more about Webservices refer Oracle Financial Services Regulatory Reporting Webservices Guide Both OFSECM Oracle Mantas 5 x and OFSRR application must be configured to use this webservice This is an optional configuration and is required only when you want to integrate OFSRR with OFSECM Oracle Mantas 5 x 1 For OFSRR The OFSRR application s Webservice is already configured with a default user name and password This default password must be reset before performing the OFSRR and OFSECM Oracle Mantas 5 x integration This step is mandatory from security aspect a To update password perform the following steps i Log in as Administrator user ii Navigate to Administration gt Regulatory Report Web Service iii Enter the User ID as rruser Do not add any other user name iv Enter any desired password v Click Save b By default OFSRR Web Service is configured to capture the data coming from OFSECM If OFSRR is to be configured to accept data from Oracle Mantas 5 x then execute the following SQL using OFSRR atomic schema user UPDATE APPLN_PARAMETERS SET V_ATTRIBUTE_VALUE1 N WHERE V_ATTRIBUTE_NAME1 ECM FLAG COMMIT 2 For OFSECM a Login to the OFSECM application as Administration User b Navigate to FCCM
Download Pdf Manuals
Related Search