Oracle Financial Services Regulatory Reporting Administration Guide
Contents
1. 11 12 13 14 15 Click on Arrow button next to Browse button Preview the data created under Preview section In Excel Entity Mappings section click Arrow button Select the table name same as name of the excel sheet Click Upload 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 Close the Excel upload page Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR 13 Mapping Users to User Group Chapter 1 Creating a User 17 18 19 20 21 22 Click FCCM Incase OFSRR is installed on top of OFSFCCM 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 FCCM 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 uset 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 op2. Administration Guide BS STR 21 Multiple Values Literal Chapter 4 Configuring Report Lock Period 22 Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR
3. N is a configurable number of days The N days filing time should exclude both holidays and weekends that 1s it refers specifically to business days Due date can be modified by any user based on the configurability as mentioned in the following table Table 3 Due Date Attribute Name Value Default Behavior SQL pre pack aged value Number of Days N 3 Whena RRdepont 22 APPLN PARAMETERS SET V ATTRIBUTE VALUE1 NUMBER OF Days is created manually DAYS ot via action from alert case WHERE N PARAM IDENTIFIER 19 automatically sets due date to action date N calendar commit days If parameter is blank then no date is set Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR 19 Multiple Values Literal Chapter 4 Configuring Report Lock Period Edit Due Date Flag YorN Y If Yes Due Date can be edited and check for roles to allow to edit Set Due Date Action to be available If No the Due Date once added by any means cannot be edited No Set Due Date Action UPDATE AP V ATTRIBU WHE CO Iq PLN PARAMETERS SET TE VAL RE N PARAM I UE2 Y OR N DENTIFIER 19 Due Date Required Flag Y or N Y If Yes then on Reopen action the due date is mandatory If
4. No then on Reopen action the due date is optional UPDATE APP V_ATTRIBUTE WHE CO IT N PARAMETERS SET _VAL UE3 Y OR N RE N PARAM I DENTIFIER 19 Multiple Values Literal This literal replaces the actual value when any of the following mentioned fields are reported with more than one value 1 Debit Credit 2 Transaction Date 3 Source 4 Currency The default value is VARIOUS This can be altered as per your requirement Execute the following SQL using OFSRR atomic schema user UPDATE APPLN PARAMETERS S WHERE N PARAM ID COMMIT ENTIFIE R 20 ET V ATTRIBUTE VALUE1 lt MULTIPLE VALU ES LIT ERAL gt 20 Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR Multiple Values Literal Chapter 4 Configuring Report Lock Period Default Currency This field holds the default ISO Currency code used in the application The default pre packaged value is BSD This can be altered as per your requirement Execute the following SQL using OFSRR atomic schema user UPDATE APPLN PARAMETERS SET V ATTRIBUTE VALUE2 lt DEFAULT CURRENCY gt WHERE N PARAM IDENTIFIER 20 COMMIT Oracle Financial Services Regulatory Reporting 2 4
5. DIM REPORTING ENTITY DTLS xlsx b DIM REPORTING PERSON xlsx c DIM USERS 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 b DIM REPORTING PERSON xlsx For more information refer section Reporting Person Information in Datamodel Reference Guide c DIM USERS xlsx For more information refer section User 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 Oracle Financial Services Reg
6. HAPTER 1 OFSRR User Sel p ua e t a pe bran 11 Creating UE A vedi tte tte eet cue ua uct Dra eet iced 11 Mapping Users to D SEC OG TOUD co er et epe mer dum uU ue eU eme 12 CHAPTER 2 Loading the Static Data into OFSRR Application 15 CHAPTER 3 Integrating OFSRR Application with OFSFCCM Oracle Mantas 5 x AppIICatIOn iR 17 CHAPTER 4 Configuring Parameters sss 19 Report Lock Produtos 19 Due RR 19 Multiple Values Literal ii dan 20 Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR iii Contents iv Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR List of Tables Table T Conventions Used inthis Guide ene Hand HIER viii Table 2 User Group Code and Properties iiir rere genen kin RE te iii laret psi 11 Tables Due Date nime uen RS EH EM NM A GLa rae M MEM SI 19 Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR List of Tables vi Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS 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
7. Information e Conventions Used in this Guide Who Should Use this Guide The Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR is designed for use by Oracle Financial Services administration 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 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 4 Administration Guide BS STR includes the following topics e Chapter 1 OFSRR User Setup 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 OFSFCCM Oracle Mantas 5 x Application explains the steps involved in integration of RR application with OFSFCCM Oracle Mantas 5 x application e Chapter 4 Configuring Parameters explains the steps to configure the report lock time period Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR About this Guide Where to Find More Information For more information on OFSRR refer to the following documents Oracle Financial Services Regulatory Reporting Inst
8. ORACLE Oracle Financial Services Regulatory Reporting Administration Guide BS STR Release 2 4 October 2013 ORACLE FINANCIAL SERVICES Oracle Financial Services Regulatory Reporting Administration Guide BS STR Release 2 4 October 2013 Document Control Number 9MN11 2 4 01 04 Document Number AG 13 RR 004 2 4 01 Oracle Financial Services Software Inc 1900 Oracle Way Reston VA 20190 Document Number AG 13 RR 004 2 4 01 First Edition October 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 TI L OF TODOS an TAR A E A E Aa v About This GUIAS tet oa Reit iii nel irai rend vii Who Should Use this Guide Rp Ree eR ERR p Rte n P d ede e phe rer o dede dri deed vii How this Guide is Organized any oinaren r e e nnno n A AAA Eh vii Whete toEtnd Motre InfOrmatiOn aan sooner RD DDR Ie e iia viii Conventions Usedun this Guida viii C
9. SFCCM application For 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 OFSFCCM 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 OFSFCCM 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 ate all available in OFSFCCM application Por more information refer section Security Attributed Static Information in Data Model Reference Guide e DIM DOMAIN5 xlsx is to be filled with Scenario Classes which are all available in OFSFCCM application For more information refer section Security Attributed Static Information in Data Model Reference Guide Login to OFSRR application as Admin user created in the previous step Navigate to Unified Metadata Manager 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 Click Browse button under Excel File to Upload section Select any one of the excel sheet 10
10. allation Guide Release 2 4 Oracle Financial Services Regulatory Reporting Data Model Reference Guide Release 2 4 Oracle Financial Services Regulatory Reporting Bahamas Suspicious Transaction Report User Guide Release 2 4 Oracle Financial Services Regulatory Reporting Web Services Guide Release 2 4 Oracle Financial Services Regulatory Reporting Release Notes Release 2 4 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 e Names of books chapters and sections as references e Emphasis Bold 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 4 Administration Guide BS STR CHAPTER 1 OFSRR User Setup There are some predefined user groups for accessing OFSRR applications This chapter discusses about the steps to provide access to the users i
11. antas 5 x then execute the following SQL using OFSRR atomic schema user UPDATE APPLN PARAMETE RS S FLAG COMMIT 2 For OFSFCCM ET V ATTRIBUTE VALU E1 2 N a Login to the OFSFCCM application as Administration User WHE RE V ATTRIBUTE NAME ECM b Navigate to FCCM gt Administration gt 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 OFSRR web service URL by setting Attribute 3 Value lt OFSRR URL gt services InitiateRequest g Click Save h To update OFSRR Webservice password in OFSFCCM Navigate to FCCM gt Administration gt Web Service Configuration gt Common Web Service Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR 17 Chapter 3 Integrating OFSRR Application with OFSECM Oracle Mantas 5 x Application i Enter the same password set in OFSRR side in Enter Password for Regulatory Report Web Service text box and click Encrypt j Logout from the application 3 For Oracle Mantas 5 x a Update the variables in lt Oracle Mantas Home alert management alert mgmt WEB INF classes conf mantas cfg install cfg as below RRS Web Service parameters r
12. en 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 OFSFCCM 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 42 4 Administration Guide BS STR CHAPTER 2 Loading the Static Data into OFSRR Application OFSRR application uses the following client provided data as per their business requirements e Reporting Entity Details e Reporting Person Information e User 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
13. n the application This chapter includes the following topics e Creating Users e Mapping Users to User Group Creating Users This section explains how to create users and provide access to OFSRR applications OFSRR application has predefined user groups to access the application To set up a user and provide the user access to OFSRR application follow these steps 1 For creating users refer to Oracle Financial Services Analytical Applications Infrastructure User Manual Release 7 3 2 Once the users are created map the users to the predefined user groups which in turn map to a user role Note For mote information about the above sections refer to Oracle Financial Services Analytical Applications Infrastructure User Manual Release 7 3 The following table describes the predefined user groups and their roles Table 2 User Group Code and Properties User Group Name User Group Code User Group Functions Analyst1 user RRANALYST1 Analyst1 user will be able to do the following e can work on the Open Reopened reports e can submit the Report to Supervisors for Approval e Post approval can mark the report as Submitted and Acknowledged Analyst2 user RRANALYST2 Analyst2 user will be able to do the following e can do all that Analyst1 can do e can cancel Report Filling e can reopen Cancelled Reports Supervisor1 user RRSUPERVISOR1 Supervisor1 user will be able to do the following e can edit the reports Pending fo
14. oups m RRSupervisor2 user group m Access to Bahamas STR user group e To create RR Administrator user map to the following group RR Administrator user group Note If you are Integrating OFSRR with OFSFCCM then do not create OFSRR administration user The OFSFCCM administration user to be used for OFSRR administration as well For more information about User to User Group mapping refer to Oracle Financial Services Analytical Applications Infrastructure User Manual Release 7 3 3 To add client specific security attributes to OFSRR system navigate to lt ftpshare path gt STAGE Excelupload Templates the ftpshare path 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 4 Download the following Excel sheets to Windows machine from the path given in the previous step 12 Oracle Financial Services Regulatory Reporting 2 42 4 Administration Guide BS STR Mapping Users to User Group Chapter 1 Creating a User DIM DOMAIN1 xlsx o mw DIM DOMAIN2 xlsx c DIM DOMAIN3 xlsx d DIM DOMAIN4 xlsx e DIM DOMAINS xlsx 5 Add data in each excel sheet as per your report requirement by referring to Oracle Financial Services Regulatory 16 Reporting Data Model Reference Guide a DIM DOMAIN1 xlsx is to be filled with Jurisdictions which are all available in OF
15. r Approval e can Approve or Reject reports Supervisor2 user RRSUPERVISOR2 Supervisor2 user will be able to do the following e can do all that Supervisor1 can do e can open reports e can mark the report as Submitted and Acknowledged Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR 11 Mapping Users to User Group Chapter 1 Creating a User User Group Name User Group Code User Group Functions Administrator RRADMINISTRATOR Administrator user will be able to do the following s r e Security attribute mapping to users e Uploading client specific metadata e User ID Password setting for Webservices Access to RRBAHAMASACC Access to Bahamas STR user is required to provide access to BS STR Bahamas STR user Note For more information about the above sections refer to Oracle Financial Services Analytical Applications Infrastructure User Manual Release 7 3 Mapping Users to User Group This section discusses about mapping the users to user groups e To create RR Analystl user map to the following groups m RR Analysti user group m Access to Bahamas STR user group e Io create RR Analyst2 user map to the following groups m RR Analyst2 user group m Access to Bahamas STR user group e To create RR Supervisor user map to the following groups m RR Supervisor user group m Access to Bahamas STR user group e To create RR Supervisor2 user map to the following gr
16. rs userid rruser rrs password 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 b By default OFSRR Web Service is configured to capture data coming from OFSFCCM 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 18 Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR CHAPTER 4 Configuring Parameters 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 NAMEI OCK PERIOD IN MINUTES COMMIT Due Date The due date is set to N days from the date the request is sent from Alert Management Case Management to RR where
17. ulatory Reporting 2 4 Administration Guide BS STR 15 Chapter 2 Loading the Static Data into OFSRR Application 16 Oracle Financial Services Regulatory Reporting 2 4 Administration Guide BS STR CHAPTER 3 Application Integrating OFSRR Application with OFSFCCM Oracle Mantas 5 x OFSFCCM 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 OFSFCCM 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 OFSFCCM 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 OFSFCCM 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 Web Service Configuration 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 OFSFCCM If OFSRR is to be configured to accept data from Oracle M
Download Pdf Manuals
Related Search