Oracle Financial Services Compliance Regulatory Reporting
Contents
1. Regulatory Reporting Installation Guide e Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide e Oracle Financial Services Compliance Regulatory Reporting User Guide e Oracle Financial Services Compliance Regulatory Reporting Web Services Guide e Oracle Financial Services Compliance Regulatory Reporting Release Notes 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 Names of books chapters and sections as references 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 Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR CHAPTER 1 OFSCHH User Setup Creating Users Users must be created with appropriate roles to access the OFSCRR For more information on creating users refer Oracle Financial S2. GUlde aote ertet en ii viii CHAPTER 1 OFSCRR User Setup ooooooocooccoconiccccccnnncccccccancnncnnnnnnnccnnnnnnnnnn nn ncnnno 1 Creating Users innnan iii taa 1 CHAPTER 2 Loading the Static Data into OFSCRR Application 5 CHAPTER 3 Integrating OFSCRR with OFSFCCM Oracle Mantas 5 x 7 For OFSRR PET EM D CEDE 7 bor OESEQGM unte eret ort petiit iia 8 Por Oracle Matas 5 3 eer E REFER EE RU REIR IMEEM a 8 Generation 11 CSV or PDF Format uas e Eee e Ete H UU e oot taste Re 9 CHAPTER 4 Configuring Parameters sssssssssssseeen 11 Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR iii Contents iv Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR List of Tables Table 1 Conventions Usd this Guides 3 820K 2 aa Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR List of Tables vi Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR 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 OFSCRR 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 Conventio
3. ORACLE Oracle Financial Services Regulatory Reporting Administration Guide Pakistan STR Release 8 0 1 July 2015 ORACLE FINANCIAL SERVICES Oracle Financial Services Regulatory Reporting Administration Guide Pakistan STR Release 8 0 1 July 2015 Document Control Number 9MN11 2 5 1 01 06 Document Number PKSTRAG 15 RR 006 2 5 1 02 Oracle Financial Services Software Inc 1900 Oracle Way Reston VA 20190 Document Number PKSTRAG 15 RR 006 2 5 1 02 First Edition July 2015 Copyright 1996 2014 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 wsww oracle com financialservices Contents Abo t this Gulden aeo dol i ipi td A ES AIDA vii Who Should Use this Gu ldesa rn annanenenesses seen ana an A biete else dedi diei eee vii How this Guide is Orpanized iieebie beider in oiv ie tiet oir re HER SEM BER E AERE S isina vii Where to Rind More Information 52min ete diia viii Conventions Used 1 this
4. c DIM DOMAIN3 xlsx d DIM DOMAINA xlsx e DIM DOMAIN5 xlsx 11 Add data in each Excel sheet as per your report requirement by referring to Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide a DIM_DOMAIN1 x1sx must be filled with Jurisdictions which are available in OFSFCCM For more information refer section Security Attribute Static Information in Data Model Reference Guide b DIM DOMAIN2 xlsx must be filled with Business Domains which are available in OFSFCCM For more information refer section Security Attribute2 Static Information in Data Model Reference Guide c DIM DOMAIN3 xlsx must be filled with Case Type and Case SubType which are available in OFSFCCM For mote information refer section Security Attribute3 Static Information in Data Model Reference Guide d DIM_DOMAIN4 x1sx must be filled with Organizations which are available in OFSFCCM For more information refer section Security Attributed Static Information in Data Model Reference Guide e DIM_DOMAIN5 x1sx must be filled with Scenario Classes which are available in OFSFCCM For more information refer section Security Attributes Static Information in Data Model Reference Guide 12 Login to OFSCRR as Admin user created in the previous step 13 Navigate to Unified Metadata Manager Data Entry Forms and Queries Excel Upload The Excel Upload page is displayed Note After logging into the application make sure the OFSCRR application I
5. e is required to incorporate in the report You can contact Oracle Support for more details 6 Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR CHAPTER 3 Integrating OFSCRR with OFSFCCMv 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 Compliance 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 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 OFSF CCM Oracle Mantas 5 x integration This step is mandatory from security aspect 1 To update password perform the following steps a b Log in as Administrator user Navigate to Administration gt Web Service Configuration gt Regulatory Report Web Service Enter the User ID as rruser Do not add any other user name Enter any desired password Click Save 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 Mantas 5 x then execute the followi
6. ence Guide Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR 5 Chapter 2 Loading OFSRR Application Static Data 3 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 4 Navigate to Unified Metadata Manager gt Data Entry Forms and Queries gt Excel Upload The Excel Upload page is displayed 5 Click Browse under Excel File to Upload and upload all Excel sheets created in the previous step Note The data must be loaded in the same order as given in step 1 Scan the Webapplicaiton Server logs for any errors after uploading each Excel sheet For example for Oracle Weblogic the webapplication server log is wls out and for Websphere the webapplication server log is Systemout log and Systemerr log 6 Close the Excel upload page 7 In addition to above static data there are few more common static data to be loaded in OFSRR application on which the application is developed To load those data execute Product Supplied Data sql available in OFSRR installer using OFSRR atomic schema user For more details about atomic schema user refer Creating Atomic Schema User section in Oracle Financial Services Compliance Regulatory Reporting Installation Guide This static data is also configurable but code chang
7. ervices Analytical Application Infrastructure User Manual For more information on roles refer Oracle Financial Services Compliance Regulatory Reporting User Guide To create users follow these steps 1 Create a Uset by logging into the OFSCRR as SYSADMN For more information tefer section User Maintenance in OFSAAI User Manual Authorize the User by logging into the OFSCRR as SYSAUTH For more information refer section User Authorization in OFSAAI User Manual Create a User Group by logging into the OFSCRR as SYSADMN For more information refer section User Group Maintenance in OFSAAI User Manual Map the User Group to the OFSCRR Information Domain For more information refer section User Group Domain Map in OFSAAI User Manual Note If you want to integrate OFSCRR with OFSFCCM then you must map OFSFCCM information domain as well 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 PK STR Report roles 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 OFSCRR Mapping different roles of same application to a User Group for example Analyst and Supervisor role of OFSCRR and assigning users is not supported But mapping different roles of differe
8. nformation Domain is selected from the drop down list at the left hand corner of the page 14 Click Browse under Excel File to Upload 15 Select any one of the Excel sheet 16 Click on Arrow button next to Browse 17 Preview the data created under Preview section 18 In Excel Entity Mappings click Arrow 19 Select the table name same as name of the Excel sheet 20 Click Upload The following message is displayed Successfully uploaded data 21 Click OK Note Scan the Webapplication Server logs for any errors after uploading each Excel sheet For example for Oracle Weblogic the webapplication server log is w1s out for Websphere the webapplication server log is Systemout log and Systemerr log 2 Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR Creating Users Chapter 1 OFSRR User Setup 22 Close the Excel upload page Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR 3 Creating Users Chapter 1 OFSRR User Setup 4 Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR CHAPTER 2 Loading the Static Data into OFSCHR Application OFSRR application uses the following client provided data as per their business requirements Financial Institution Information State Information Branch Information User information Reporting Person Information Contact Person Information Follo
9. ng SQL using OFSRR atomic schema user UPDATE APPLN PARAMETERS SET V ATTRIBUTE VALUE1 N WHERE V ATTRIBUTE NAME1 ECM FLAG COMMIT Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR 7 For OFSFCCM Chapter 3 Integrating OFSRR with OFSFCCM Oracle Mantas 5 x For OFSFCCM 10 Login to the OFSFCCM application as Administration User Navigate to FCCM gt Administration gt Manage Parameters gt Manage Common Parameters Select Deployment Based in the Parameter Category drop down list Select Regulatory Report Solution Web Service from the Parameter Name drop down list Set Parameter Value text box Y Update the OFSRR web service URL by setting Attribute 3 Value as OFSRR URL gt services InitiateRequest Click Save To update OFSRR Webservice password in OFSFCCM Navigate to FCCM gt Administration gt Web Service Configuration gt Common Web Service Enter the same password set in OFSRR side in Enter Password for Compliance Regulatory Reporting Web Service text box and click Encrypt Logout from the application For Oracle Mantas 5 x jl 2 Update the vatiables in Oracle Mantas Home alert management alert mgmt WEB INF classes conf mantas cfg install cfg as follows RRS Web Service parameters rrs userid rruser rrs password Encrypt the same password given in step 1 using Change Password U
10. ns Used in this Guide Who Should Use this Guide The Oracle Financial Services Compliance Regulatory Reporting Administration Guide PK STR is designed for use by Oracle Financial Services application users Their roles and responsibilities as they operate within the OFSCRR 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 1 Administration Guide PK STR includes the following topics e Chapter 1 OFSCRR User Setup describes the steps involved in creating users e Chapter 2 Loading the Static Data into OFSCRR Application explains the steps involved in loading static data e Chapter 3 Integrating OFSCRR with OFSFCCM Oracle Mantas 5 x explains the steps involved in integration of OFSCRR application with OFSFCCM application e Chapter 4 Configuring Parameters explains the steps to configure the report lock time period Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR vii Where to Find More Information About this Guide Where to Find More Information For more information on OFSCRR refer to the following documents e Oracle Financial Services Compliance
11. nt applications for example Executive role of OFSFCCM and Analyst role of OFSCRR is supported Map User to created User Group For more information refer section User to User Group section in OFSSAI User Manual Repeat steps 1 to 6 for the following users and map the roles a To create an Analyst user map Reg Report Analyst Role and Access to PK STR Report roles b To create an Admin user map Reg Report Admin Role role Note If you are integrating OFSCRR with OFSFCCM then map the OFSCRR Information Domain and Reg Report Admin Role to existing OFSFCCM Administration User Authorize the new User Groups Information Domain mapping and Role mapping by logging into the application as SYSAUTH For more information refer section User Group Authorization in OFSAAI User Manual Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR 1 Creating Users Chapter 1 OFSRR User Setup 10 To add client specific security attributes to OFSCRR system navigate to lt ftpshare path STAGE Excelupload Templates the lt ftpshare path is the same path given in variable STORE AS while installing OFSAAI For more information refer Oracle Financial Services Analytical Applications Infrastructure Installation and Configuration Guide Download the following Excel sheets to Windows machine from the path given in the previous step a DIM DOMAIN1 xlsx b DIM DOMAIN2 xlsx
12. tility of Oracle Mantas 5 x gt rrs service url OFSRR URL gt services InitiateRequest rrs version 2 2 then recreate the war file and deploy in the web application server 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 Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR Generation in CSV or PDF Format Chapter 3 Integrating OFSRR with OFSFCCM Oracle Mantas 5 x Generation in CSV or PDF Format The PK STR can be generated either in CSV or PDF format To specify which format to be configured follow these steps Log into the OFSRR as atomic schema user For more information refer section Creating Atomic Schema User in Oracle Financial Services Compliance Regulatory Reporting Installation Guide Execute following SQLs as per the required format e For CSV By default the OFSRR application will generate PKSTR in CSV format e For PDF Execute the following SQL statements UPDATE APPLN PARAMETERS SET V ATTRIBUTE VALUE1 N WHERE V ATTRIBUTE NAME1 GEN CSV FLAG COMMIT ERATE Oracle Financial Services Compliance Regulatory Repor
13. ting 8 0 1 Administration Guide PK STR Generation in CSV or PDF Format Chapter 3 Integrating OFSRR with OFSFCCM Oracle Mantas 5 x 10 Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR CHAPTER 4 Configuring Parameters 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 60 minutes This duration can be altered as per your requirement Execute the following SOL using OFSRR atomic schema uset UPDATE APPLN PARAMETERS SET V ATTRIBUTE VALUE1 DURATION IN MINUTES gt WHERE V ATTRIBUTE NAME1 LOCK PERIOD IN MINUTES COMMIT Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR 11 Chapter 4 Configuring Parameters 12 Oracle Financial Services Compliance Regulatory Reporting 8 0 1 Administration Guide PK STR ORACLE
14. w these steps to load the above data into OFSRR application 1 Download following Excel sheets to Windows machine for the templates from tpshare path gt STAGE Excelupload Templates The path for ftpshare path is the same path as given in variable STORE AS while installing OFSAAI For more information refer Oracle Financial Services Analytical Applications Infrastructure Installation and Configuration Guide mh 0 amp A vo sp FCT FININST INFO xlsx DIM STATES xlsx FCT BRANCH INFO xlsx DIM USERS xls DIM REPORTING PERSON xlsx DIM CONTACT PERSON xls Add data in each Excel sheet as per your installation requirement by referring to the Oracle Financial Services Compliance Regulatory Reporting Data Model Reference Guide a FCT FININST INFO xlsx For more information refer section Financial Institution Information in Datamodel Reference Guide DIM STATES xlsx For more information refer section Financial Institution Information in Datamodel Reference Guide FCT BRANCH INFO xlsx For more information refer section Branch Information in Datamodel Reference Guide DIM USERS xls For more information refer section User information in Datamodel Reference Guide DIM REPORTING PERSON xlsx For more information refer section Reporting Person Information in Datamodel Reference Guide DIM CONTACT PERSON xls For more information refer section Contact Person Information in Datamodel Refer
Download Pdf Manuals
Related Search