Reports Batch User Manual
Contents
1. Retrieve Latest Status Rerun All Failed Process Specify the following Batch Process Date Specify the date for which you want to monitor the status of the FRS batch process Alternatively you can also select the date from the calendar button Press F8 to see the updated status on the screen FRS automated batch monitor can be used to monitor the status of each of the processes System displays the following process details e Process ID e Process name e Start Time e End Time e Status of the process If the FRS batch process fails it can be re run by clicking the Re Run button The failed process and the processes that are dependent on the current process can be re run by clicking the Re Run the Failed Process alone button The latest status of each process can be known by clicking the Retrieve Latest Status button To re run the failed processes click the Re Run All Failed Process button on the screen 3 6 ORACLE 4 1 4 Screen Glossary Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual ton o resonon 4 1 ORACLE Reports May 2012 Version 12 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_ services Copyright 2012 Oracle Fi2. Specify the following Batch Process Date Specify the date from which the FRS batch process has to be executed Alternatively you can also select the date from the calendar button When you click the P Populate button system populates Batch Processing Branch Code and Batch Processing Status By default system displays the Batch Processing Branch Code as ALL Click the start button to trigger the batch Once the batch begins to execute system displays the following message Batch Submitted Successfully Please check monitor for Status Note the following e Inthe beginning of the batch process the Start and Cancel buttons are enabled Once the batch begins to execute Abort and Cancel buttons are enabled and Start button is disabled on the screen e To abort the batch process click the Abort button on the screen To close the screen click Close button 3 5 ORACLE 3 2 5 Monitoring the FRS Batch Status The status of the FRS batch which is triggered from the FRS Batch Run screen can be seen in the FRS Batch Monitor screen You can invoke this screen by typing FRDBRMTR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button FRS Batch Monitor Batch Process Date Batch Processing Branch Code Batch Processing Status 10f1 7 Id Process Type Process Description Started At Ended At o
3. FRS architecture which is based on data warehousing principles ensures high performance by basing the application on warehouse architecture by using Oracle database as highly optimized and tunes in memory processes The ETL processes are defined and designed to perform as multi threaded processes thus allowing for a separation on processing Each process is independently scalable to utilize the underlying multi threading design and multi processor capability The high level architecture of FRS is given below 2 5 ORACLE FLEXCUBE a ia silo _ FLEXCUBE Reporting Services ORACLE 2 4 1 Maintaining FRS parameter details There are several pre defined parameters that are used in different operations in FRS You can create new parameters or modify existing parameters in the FRS Parameter List screen You can invoke this screen by typing FRDPARAM in the top right corner of the Application tool bar and clicking on the adjoining arrow button The screen is given below FRS Parameter List Keyld FRS Factory Setup Description Parameters It is advisable to modify the FRS parameters after consulting with OFSS consultants To view the parameters press F7 and F8 The existing values are displayed on the screen 2 ORACLE To add new parameters press F7 and F8 The existing values are displayed on the screen Select the parameter that has to be modified and click the Parameter bu
4. Reports Oracle FLEXCUBE Universal Banking Release 12 0 May 2012 Oracle Part Number E51465 01 ORACLE FINANCIAL SERVICES ORACLE Reports Table of Contents I ABOUC THS IAIN aU mmmmmmmmmmmmmmmmmmmmm m m mmmmm mmmmmrmrmmmmmmmmmrmrmrmrmmmmmmmammrmmmmmmmmmmrmmrmrmrmmammmmmmmamimamm 1 1 1 1 Re OTS TION aac cn eigen neste ee a stn ves accede ce bn cn E ede Gn as tad wen tect eID haat neat namie 1 1 1 2 ADEC seamen ter er E A OE A ere ere eee Teer E eam tee eer ame errr ee am eT rnc 1 1 1 3 ORGANE A TO ommmmmmm mm mmkmrmmrrmrmrmrmrmrmmrmm r vr rr ba pe ud Ga op tgs ww ue E E A E 1 1 1 4 GLO EVO OIG raS a E E ANANE NEA E ENEE E A EA 1 1 2 RETRIEVING INFORMATION IN ORACLE FLEXCUBE seossssocsssecsssocsssocsssocoseocsssossssesossessssesosseo 2 1 2l D ODUCT aaa E AA E EE 2 1 2 1 1 Ea Ea E E E EE TE AEA 2 1 2 1 2 Specifying the Output Of a RepoTt iieeeeeessseeeeeessssseesecsssseeececcsssseeseccssseeecccccsseescccecseeesscecseeeesecennes 2 1 2 1 3 Oe PAO Ee pO mmmmmmmmmmmm mmmmmmmm mmrmmmrm rm mmmmrmmmmmmmmmmrmrmrmrmmmmmmmmmmmmmmmmmm mmrmrmrmrmmmmmmkaHH 2 2 22 MAINTAINING PRINTER mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmka 2 3 Zaad Maintaining Report Spool Path iiseeeeeereesssseecerersssesesecssssseescccssssessceccssseeseeccsseeesseccneeeeseccneeeesees 2 4 23 VIEWING MESSAGES FOR UNAUTHORIZED CONTRACTS ccccssssccccceeesscecceeseceeeaeeeecceeseeesceseeeeeseeeseaeesee
5. Rs and staff in charge of retrieving information for the various transactions processed in your bank Organization This manual is organized into the following chapters Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Retrieving Information in Oracle FLEXCUBE explains how reports can be generated for different modules Chapter 3 Reports Batch explains the maintenance of reports pertaining to a particular branch Conventions Used in this Manual Important information is preceded with the symbol Glossary of Icons This User Manual may refer to all or some of the following icons e Option List 2 1 2 1 1 2 1 2 2 Retrieving Information in Oracle FLEXCUBE Introduction During the day or at the end of the day you may want to retrieve information on any of the several operations that were performed during the day in your bank You can generate this information in the form of reports in Oracle FLEXCUBE For every module you can generate reports which give you data about the various events in the life of a specific contract or across contracts at a specific point in time You can have analysis reports daily reports exception reports reports on events that ought to have taken place on the contract but have not due to various reasons history reports and so on A set of report formats is pre defined for every mod
6. a unique printer ID This ID will be used to identify the printer Printer Name Specify the name of the printer Branch The system defaults the current branch code However you cannot modify this Printer Roles Identify the user who can use the printer You can add more rows to the list of roles using Add icon Select appropriate role from the option list Printer Users Identify the users who can use the printer You can add more rows to the list of roles using Add icon Select the user from the option list Once you have captured the details click Save icon to save the maintenance The system makes the printer available for the selected roles to the users maintained Further if you choose to print a report the system will send the reports for print as per the options specified 2 3 ORACLE 2 2 1 Maintaining Report Spool Path You can maintain a location to spool the reports for a specific branch using Reporting System Parameters screen You can invoke this screen by typing RPDPAHRAM in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Reporting Parameters Maintenance Spool Path Spool History Path Time Out Server ReportPath Input By Authorized By Modification Date Time Date Time Number Authorized Open Here you need to specify the following details Branch The system displays the branch for which you are maint
7. ach option to indicate your preference Printer Select the printer using which you need to print the reports Select the appropriate printer form the option list 3 3 ORACLE Once you have set your preferences click Ok button The system prints the reports as per the preferences you have set 3 2 3 Initiating FRS Batch Processing You can initiate FRS batch processing from the FRS Batch screen You can invoke this screen by typing FRDEXTNS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button The screen is given below FRS Batch Run Extraction Date Specify the following Extraction Date Specify the date from which you want to process the FRS batch and click the Start button If the batch is submitted successfully system displays the following message Batch submitted successfully for processing Refer the log for the status of the process 3 4 ORACLE 3 2 4 Processing the FRS Batch The FRS batch is designed to populate the Dimension amp Fact data stores by reading the data from the extracted tables from Oracle FLEXCUBE You can capture the FRS batch details in the FRS Batch Run screen You can invoke this screen by typing FRDDTLDR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Batch Process Date Batch Processing Branch Code Batch Processing Status Abort
8. aining the spool path However you cannot modify it Spool Path Specify the location to which the reports should be spooled The system stores the generated reports into this location if you have selected Spool in the Printing Preferences screen Spool History Path Specify the spool history path This is the generation where the system saves the generated report It is usually the same as the spool path Time Out Specify the time span within which you wish to complete the process The system reports if it takes longer time to generate it Server Report Path This is the location where the system stores the report if you have selected the option View in the Printing Preferences screen 2 4 ORACLE 23 Viewing Messages for Unauthorized Contracts You can view all messages to be generated for unauthorized contracts You can invoke this screen by typing MSDMPREV on the field at the top right corner of the Application tool bar and click on the adjoining arrow button Message Preview Window C New 7 Enter Query Module Contract Reference Print Options DCN Preview O Server Spool Message Preview o O First of all specify the Module from which you would like to view messages You can opt to view messages for one or several unauthorized contracts To view messages for an unauthorized contract specify the Contract Reference Number 2 4 Oracle FLEXCUBE Reporting Services FRS Architecture
9. d on the screen e Spool The details of the report will be stored in a spool file and can be printed later Print At If you choose the Print option indicate the location of printing by choosing one of the following values e Client e Server Printer Specify the printer details Printer From the option list select the name of a printer defined in the Printer Maintenance table The report will be printed on this printer Contents of the report The contents of the report are discussed under the following heads Header The Header section of the report carries the title of the Report information on the User who generated the report the branch code the date and time and the page number of the report Body of the report The actual contents of the report are displayed in this section It is detailed for each report in the subsequent sections of this document 2 2 2 2 Maintaining Printer In Oracle FLEXCUBE you can maintain the printers for the reports using Printer Maintenance screen You can invoke this screen by typing RPDRNMNI in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Printer Maintenance 31 New Printer Printer Id Printer Name Branch Input By Authorized By Modification Date Time Date Time Number Authorized Open Here you need to specify the following details Printer ID Specify
10. nancial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated
11. port Id Description Maker Date Time Checker Date Time Record Status Authorization Status Specify the following details Batch Code Specify the code to identify the report batch Batch Description Provide description for the batch code specified Report Format Specify the format in which you want to generate the reports Report ID and Description Specify the report IDs to be maintained You can select one or more report IDs for execution at a time The system displays the description based on the report ID selected 3 1 ORACLE 3 2 To add more rows to the list of report IDs click Add icon Select the report ID from the option list You can remove the unwanted rows using Delete icon Use the check box adjacent to each function ID to indicate that it has to be maintained Once you have specified all the details save the maintenance Report Batch Execution In Oracle FLEXCUBE you can execute a batch for a set of reports maintained for a branch You can invoke this screen by typing BAREODFN on the field at the top right corner of the Application tool bar and click on the adjoining arrow button Report Batch Execution Branch Code Jaz Description View Report Function Id Format PDF v Function Id Function Description Output ate Output Print Spool Printer Printer Using this screen you can view print or spool the reports maintained fo
12. r each branch You need to specify the branch code to initiate the process Branch Code and Description Specify the code that identifies the branch The option list displays all valid branch codes maintained in the system Based on the branch code selected the system displays the description 3 2 ORACLE 3 2 1 Viewing Reports On this screen you can view the reports function IDs and description maintained for the selected branch Once you have specified the branch code click View button The system displays a list of reports maintained for the branch Report Batch Execution Branch Code Description View Report Function Id Format PDF w I Function Id Function Description Output SS Output Print Spool Printer Printer Report Function ID This is the list of report function IDs that you have maintained in the Report Batch Maintenance screen Use the checkbox adjacent to each function ID to select the same for execution 3 2 2 Printing Spooling the Reports In the list of report function IDs use the checkbox adjacent to each ID to select the reports that you want to print or spool Before you print set the following preferences Format Select the format of the output The system allows you to print the reports in any of the following formats e HTML e RIF e PDF e Excel Output Indicate whether you need to print or spool the reports Use the radio button adjacent to e
13. seaees 2 5 2 4 ORACLE FLEXCUBE REPORTING SERVICES FRS ARCHITECTURE cccccseccescceescessccscsesscesesesceuseseees 2 5 2 4 1 Maintaining FRS parameter details ccccccccccccsseecccccceeee a eeeeeeeeeeee aa eeeeeeeeeeeaaaeeseeeceeeeaaaesseseeeeeaaaaeneeeess 2 7 3 RN COIR LS eC H iiin aN EEEN ININE ENO NENANA ERENTO SENKET Oa TiS 3 1 Al REPORT BATCH MAINTENANCE m mmmmwwvvvvvvmwwvwvvvwwwvevvvwvvwevwvvwvvvvvvvvvv 3 1 oW REPORTE ESEC U ON rara A E T E EE A T ase neimneetocaanennest 3 2 l WW ER mmmmmmmmmmmmmmmmmmmmmmmmmmmmm mmm mmmrmmrmmmmmmmmmmm mmmm mkmmmi 3 3 3 2 2 Printing Spooling the RepOT S iiieeeesseseeeeeesssesssesessssssseecssssseseeccsseeseeeecsssessseecsneeeeseeccseeesseeessnse 3 3 3 2 3 Initiating FRS Batch ProceSsing ccccccccccccscscccccccccecneesceecceeeeeeeeseeeeeeeee eae eeeeeeeeeeeeaaeneeeeeeeeaaaaeseeeeeesaaaaaees 3 4 3 2 4 Procesne 1e F RS DOC mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmrmmmmmmi5 3 5 JAI Monitoring the FRS Batch Status cccccccessssessscssevesssvsseccccocssesessesccsccoseusseccceocsssesssessseccssessesscasevesssssses 3 6 d SCREEN GLOSSARY prace E N E 4 1 4 1 In bi COIN UDSET onen E A EEA EA E EA AEE 4 1 ORACLE 1 1 1 2 1 3 1 4 1 About this Manual Introduction This manual lists the details of various reports that you can generate for all the modules of Oracle FLEXCUBE Audience This manual is intended for the Customer Service Representatives CS
14. tton The Folder name of FRSHOME screen is invoked Parameter Name Value Factory Setup Description New Modit In this screen you can specify the following parameter details e Name Name of the parameter e Value Value assigned to the parameter e Factory Setup The factory shipped value e Description A brief description of the parameter To add a new parameter click the New button on the screen After specifying the values click the Ok button To save the record click the Save button on the Application tool bar To modify an existing parameter follow the same procedure involved in adding a new parameter Then click the Modify button on the screen to modify the following values e Value e Factory setup e Description Click the Ok button on the screen and then click the Save button on the Application tool bar to save the modified record 2 8 ORACLE 3 1 3 Reports Batch Report Batch Maintenance In Oracle FLEXCUBE you can maintain a list of reports in a branch for batch execution using the Report Batch Maintenance screen The report function IDs maintained can be retrieved and executed at a later stage You can invoke the Report Batch Maintenance screen by typing RPDBATCH on the field at the top right corner of the Application tool bar and click on the adjoining arrow button Report Batch Batch Code ReportFormat PDF Batch Description 10f10 Re
15. ule Generating reports From the Application Browser select the Report option The system displays a list of all the modules to which you have access rights Each module contains a list of all reports that you can access Select the report that you want to generate The system displays a screen where you can set the filters for the reports to be generated Set the filters and click OK button to generate the report To cancel the operation click Exit button Specifying the Output of a Report When you select a report that you want to generate the Report Options screen is displayed In this screen you can set your preferences for the output of a report Report Options Format Output Output Print O View Spool PrintAt Client Server Printer Printer In Oracle FLEXCUBE you may generate a report in three formats e HTML 2 1 ORACLE e RTF e PDF e Excel Output You can direct a report to one of the following destinations e The printer e On line e Stored as spool files and printed later using the spool The reports that have been spooled can be printed or viewed through the Reports Browser screen The Reports Browser is detailed in the Common Procedures manual You can specify the destination of the report you want to generate The options available are e Print The report will be printed directly on to a printer of your choice e View The details of the report will be displaye
Download Pdf Manuals
Related Search