Security Management Reports Manual
Contents
1. Bank 7240 DEMO BANK FLEXCUBE Bun Date 02 FEB 2011 Branch 534 DEMO CLEABI LIST OF DISABLED USERS Run Time 10 58 AM Op Id ISYSADMS534 As on 01 2010 Report No 5 112 1 User No User Id Center End of Report 25 ORACLE Batch Reports 2 2 Batch Reports Batch reports are automatically generated at the end of day EOD or beginning of day BOD Reports and advices can be requested from the Report Request Fast Path 7775 screen Batch reports can only be generated using the system operator login The operator must run the cut off process at the end of every day before starting the end of the day for that day This is to ensure that all transactions done through the on line delivery channels are handed over to a log for batch processing A fresh log is created for the next day s transactions Here it is important to note that while the processing date from the point of view of EOD processing is still today the on line processing date has moved to the next processing date and the online transactions done after cut off will be processed in the next day s EOD EOD refers to the processing required to be done for each functional module of FLEXCUBE Retail as well as some files that are generated for updating data in other local offices The EOD Client option is used to take care of the system related batch processes of cutoff BOD EOD monthly report generation and printing file hand off eligibility of the Relati2. Expiry Report 4 The system displays the SM105 Password Expiry Report screen 5 105 Password Expiry Report Process Date DD MM YYYY 31 10 2010 Branch TULSIANI MUN 40 ORACLE SM105 Password Expiry Report Field Description Field Name Description Process Mandatory dd mm yyyy Date DD MM YYYY Type the date for which the report is processed By default the system displays the current process date Branch Code Mandatory Drop Down Select the branch for which the report needs to be viewed from the drop down list 5 Enter the appropriate parameters in the SM105 Password Expiry Report screen 6 Click the View button to view the report 7 The system displays the Password Expiry Report screen 41 ORACLE SM105 Password Expiry Report Bank 240 DEMO BANK LTD FLEXCUBE Run Date 16 FEB 2011 Password Expiry Report Run Time 13 45 AM As on 30 May 2010 Report No 5105 1 Template Emp Code Last Pwd Chg Date Inputter Next Pwd Chg Date Dept code Primary Authoriser Primary secondary Secondary C08621001 CHARU BHATIA INP RET INDERPURI C0862 03 Aug 2009 5 25 SYSADMIl1001 02 Sep 2009 5 25 12 Ej ie SYSADMIT1OOL e s OPERLOOL OPERATOR RET INDERPUR 10010 gt 26261240 15 Oct 2008 12 00 12 v2180240 E P39801001 PAWAN KUMAR BAJPAI INQ RET SAL INDERPURI 27 P3980 12 aug 2009 1 27 SYSADMIl00l 11 Sep 2009 1 27 3 gt SYSADMIIl001 VTELLERIOOl VAULT TELLER RET INDERPUR gt 26261
3. TKUMUD 240 TMADHU 240 TMALA 240 240 TMUDIT 240 TNEW 240 240 TRIAZ 240 TSAGAR 240 TSAISH 560 5 5 560 240 5 240 TSHAILEN 240 TSHANKAR 240 TSHIVANI 240 TSHYAM 240 560 TTESTKUMUD 240 TVIJAY Second system Administrator First System Administrator First supervisor First system Administrator First teller SYSTEM vault teller SUPER TABHIJIT TBHUPEN TBS USER First Teller TELANGO TGANESH THARI THARIKA TIGONRE TJAGAN TJYOTI Kiran TKUMUD Madhusudhanan M TMALA TMANISHA TMUDIT TNEW Raj TRIAZ TSAGAR TSAISH SAISH 560 TSAMEER TSHAILEN TSHANKAR TSHIVANI TSHYAM TTANMAY ttestkumud First teller Bank 240 Demo BANK LTD FLEXCUBE Run Date 25 NOV 2010 Branch 240 WORLI SANDOZ HOUSE User Inactivity Report 100 or more days Run Time 3 35 PM Id THERRICK For 30 Sep 2010 Report No SM104 2 04 09 2008 12 09 2008 06 06 2008 05 09 2008 25 07 2008 25 07 2008 13 12 2007 13 12 2007 31 12 1799 31 12 1799 07 06 2008 16 05 2008 31 12 1799 16 05 2008 31 12 1799 16 05 2008 31 12 1799 31 12 1799 16 05 2008 31 12 1799 31 12 1799 16 05 2008 16 05 2008 31 12 1799 16 05 2008 31 12 1799 31 12 1799 16 05 2008 16 05 2008 16 05 2008 31 12 1799 16 05 2008 31 12 1799 31 12 1799 31 12 1799 16 05 2008 31 12 1799 31 12 1799 13 09 2008 www End of Report www Profile Expired Primary Password Expired Pr
4. list of users created deleted by maker and authorised by checker This is a list of users created or deleted for the given period Each column of the report provides information about User Number User ID User Name Action Action Date Maker ID and Checker ID To generate the Users Created Deleted Report 1 Access the Report Request Fast Path 7775 screen Ensure that the Adhoc Reports button is selected Navigate through Security Management gt SMS DAILY REPORTS gt SM125 Users Created Deleted 4 The system displays the SM125 Users Created Deleted screen SM125 Users Created Deleted Input Parameters From Date DD MM YYYY Waived Service Charge To Date DD MM YYYY Generate Field Description Field Name Description From Date DD MM YYYY dd mm yyyy Type the valid start date for the report This date should not be greater than To Date 16 ORACLE SM125 Users Created Deleted Field Name Description To Date DD MM YYYY Mandatory dd mm yyyy Type the valid end date for the report Waived Service Charge Optional Check Box Select the check box to waive the service charge Enter the appropriate parameters in the SM125 Users Created Deleted screen Click the Generate button The system displays the message Report Request Submitted Click the OK button The system generates the Users Created Deleted Report To vi
5. 06 2010 Branch TULSIANI MUD ve Field Description Field Name Description Process Mandatory dd mm yyyy Date DD MM YY Y Y Type the date for which the report is processed By default the system displays the current process date Branch Code Mandatory Drop Down Select the code of the branch for which the report needs to be viewed from the drop down list 5 Enter the appropriate parameters in the SM108a SECURITY MANAGER DAILY ACTIVITY REPORT screen 6 Click the View button to view the report 7 The system displays the SECURITY MANAGER DAILY ACTIVITY REPORT screen 45 ORACLE SM108a SECURITY MANAGER DAILY ACTIVITY REPORT Bank 1240 DEMO BANK Branch 560 DEMO Cp Id SYSOPER FLEXCUBE Security Manager Daily Activity Report For 31 Mar 2010 Run Date 09 FEB 2011 Run Time 7 02 Report No 1 User Id Key Field User No Task Code User Name Task Description TSYSADMS34 114 TSYSADMS34 115 TSYSADMS34 THDFC11 SMS TSYSADMS34 THDFC10 SMS TSYSADMS34 113 First Teller Template Profile Add First Teller Template Profile Add First Teller User Cless Access Rights Add First Teller User Class Access Rights Add First Teller Templete Profile Add 11111 11111 22212 212111 09 09 09 FEB 2011 FEB 2011 00 00 FEB 2011 00 00 FEB 2011 00 00 FEB 2011 00 00 End of Report 46 ORACLE 8 Select the Pri
6. 240 15 Oct 2008 12 00 v2180240 End Report 42 ORACLE SM105 Password Expiry Report 8 Select the Print option from the File menu 9 The system displays the Print dialog box 10 Select the appropriate parameters and click the OK button 43 ORAC SM108a SECURITY MANAGER DAILY ACTIVITY REPORT SM108a SECURITY MANAGER DAILY ACTIVITY REPORT The systems administrator needs to access certain system logs to track transactions performed across branches for compliance and related activities This report is a log of the following activities 1 Template Profile Add Amend Cancel Delete Authorise 2 User Profile Add Modify Delete Amend Cancel Authorize 3 Template Access Rights Selected Delete SM063 4 Template Access Rights Add 5 User Class Access Rights Add This report provides details on User ID User No User Name Emp Code Department Code Date Key Field Task Code Task Description Frequency e Daily EOD To view and print SECURITY MANAGER DAILY ACTIVITY REPORT 1 Access the Report Request Fast Path 7775 screen Select the Batch Reports button Navigate through Security Management gt SMS DAILY REPORTS gt SM108a SECURITY MANAGER DAILY ACTIVITY REPORT 4 The system displays the SM108a SECURITY MANAGER DAILY ACTIVITY REPORT screen 44 ORACLE SM108a SECURITY MANAGER DAILY ACTIVITY REPORT SM108a SECURITY MANAGER DAILY ACTIVITY REPORT Process Date DD MM YYYY 30
7. 3 User Access Rights Report SM103 User Access Rights Report Access rights are provided to various FLEXCUBE users depending on the business requirement and control mechanism Branch users carry out various activities which depend on the user level rights and category assigned to them This report is a list of user access rights for the given range of User IDs Each column in this report provides information about the Task ID Task Description Parent Code Parent Description Category User ID User Level Name and Branch Details are grouped User ID wise To generate the User Access Rights Report 1 Access the Report Request Fast Path 7775 screen Ensure that the Adhoc Reports button is selected Navigate through Security Management SMS Daily Reports SM103 User Access Rights Report 4 The system displays the SM103 User Access Rights Report screen SM103 User Access Rights Report Input Parameters From User Id Waived Service Charge To User Id Generate Field Description Field Name Description From User ID Mandatory Alphanumeric Nine Type the valid From User Id which the report needs to be generated This Id should not be greater than the To User Id 9 ORACLE SM103 User Access Rights Report Field Name Description To User ID Mandatory Alphanumeric Nine Type the valid To User Id till which the report needs to be generated Waived Service Charge Optiona
8. 8 ORACLE Field Name Category Status Process Date Next Process Date Column Name Batch Reports Description Rating CRR status or the days past due If the accounts are marked for write off FLEXCUBE will write off the accounts if the accounts meet the eligibility criteria as on the date of write off Accounting entries including off balance sheet entries will be passed by the system pertaining to written off accounts The system displays the message SUCCESS MESSAGE after the process is completed Mandatory Drop Down This field displays the status of the selected category The status can be as follows Yet to Start e Started e Aborted e Completed Mandatory Pick List dd mm yyyy Select the process date from the calendar By default this field displays the current process date for the selected process Mandatory Pick List dd mm yyyy Select the next process date from the calendar By default this field displays the next logical working day on which the process has to be run Description State Process Name Module Code Display This column displays a different colour for different process state The different colour displayed are Green Run e Red Aborted e Default Other Status Complete Yet to Start Display This column displays the name of different processes which are performed Display This column displays the code of the module on which the process is
9. ORACLE Oracle FLEXCUBE Core Banking Security Management Reports Manual Release 11 5 0 0 0 Part No E52876 01 July 2014 Security Management Reports Reports Manual July 2014 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any
10. ation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services ORACLE Security Management Reports Manual Table of Contents jM e 4 2 Security Management Reports l U ul uu u U AQ 6 eed sxc 7 Bla Ths Daily Repo Cac m 8 GMTO User Recess Rights REDOT 9 dn ies 12 SMS Users Created 7 Delete siiis sieastendiectueescetmnaddelateeasmonvadcecane 16 GMTO User Inactivity Repo siomia peaa 20 RAN i 7 A ieii 24 2 2 eaer noinine EO R A 26 sa L GMS DAILY REFOR mtm 31 User Profile ine que SNH2U Event GG M 36 SM10858 Password Expiry LLL eric a a roc rabo e UO 40 SM108a SECURITY MANAGER DAILY ACTIVITY 44 ORACLE Preface 1 Preface 1 1 Intended Audience This document is intended for the following audience e Customers Partners 1 2 Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Prog
11. aturity Standing Instruction SI Execution etc Cutoff It is a process where the process date of the system is changed to the next working day as maintained in the bank calendar All the transactions entered in the system till the point of cutoff are picked up for EOD processing The validation for cutoff is that the previous day BOD should be completed 27 ORACLE Batch Reports Field Name Description e Transfer DB Scripts This process was used earlier e Apply DB Scripts This process was used earlier e Process CIF Handoff This process is used to download the customers and related tables which are opened in other branch to the base branch of the customer The validation for CIF handoff is that the previous day BOD should be completed e Schedule Extracts It is a processed to extract specific schedule and to have a proper handoff to the interface e MONTHLY STATEMENTS This process is used to generate the customer monthly statement in order to stream line the time during the actual EOM process This process is run separately This process can be run even after the BOD process next day Handoff After EOD It is a processed to extract specific schedule and to have a proper handoff to the interface e Elig Evaluation It is a processed to evaluate the eligibility of the RVT schemes e File Handoff It is a processed to extract specific schedule and to have a proper handoff to the interface e Automatic EFS
12. eds to be generated Waived Service Charge Optional Check Box Select the check box to waive the service charge Enter the appropriate parameters in the SM120 SMS Event Logs screen Click the Generate button The system displays the message Report Request Submitted Click the OK button The system generates the SMS Event Logs Report To view print the SMS Event Logs Report k Access the Advice Report Status Enquiry Fast Path 7778 screen 2 Select the check box corresponding to SM120 SMS Event Logs 3 Click the View button to view the report 4 The system displays the SMS Event Logs Report screen 13 ORACLE SM120 SMS Event Logs 9199 DEMO FLEXCUBE Run Time 08 44 2009 SYSOPER AUDIT TRAIL REPORT Report No 8M120 1 For 31 Dec 2007 User Id Event Date and Time Machine Name Task Code Task Description Action No data for this Report 14 ORACLE SM120 SMS Event Logs 5 On the File menu click Print 6 The system displays the Print dialog box 7 Select the appropriate parameters and click the OK button 15 ORACLE SM125 Users Created Deleted SM125 Users Created Deleted Users are created in the system to perform various financial and non financial activities According to the business requirement and control mechanism user profiles are assigned to the tellers Branches also delete users from the system in case of retirement etc This report is a
13. eport generation in PDF HTML and Excel formats Based on the system configuration the reports can be generated in any of the above mentioned format Note 1 Reports can be generated by using the Report Request Fast Path 7775 option Reports can be viewed printed using the Advice Report Status Inquiry Fast Path 7778 option The above screens can be accessed by navigating through the following path Transaction Processing gt Internal Transactions gt Reports Note 2 Report Codes precede the Report Names Unlike the User Manual where the Fast Path preceding the Topic Title indicates the access for the screen the Report Code is simply a unique code for the report Reports are categorized under e Adhoc Reports e Batch Report 6 ORACLE Adhoc Reports 2 1 Adhoc Reports Adhoc reports are generated on demand or on request Reports and advices can be requested from the Report Request screen Adhoc reports can be viewed and generated using the teller login or the system operator login List of Adhoc Reports e SMS DAILY REPORTS 7 ORACLE SMS Daily Reports 2 1 1 SMS Daily Reports The SMS Daily Reports includes reports specific to the user profiles that are maintained daily List of Customer Information Reports SM103 User Access Rights Report e SM106 User List SM120 SMS Event Logs SM125 Users Created Deleted e SM104 User Inactivity Report e 5 112 List Of Disabled Users 8 ORACLE SM10
14. ew and print the Users Created Deleted Report k Access the Advice Report Status Enquiry Fast Path 7778 screen 2 Select the check box corresponding to SM125 Users Created Deleted 3 Click the View button to view the report 4 The system displays the Users Created Deleted Report screen 17 ORACLE SM125 Users Created Deleted DEMO BANK FLEXCUBE Run Date 27 03 2009 9999 DEMO USERS CREATED DELETED Tia Tine 04 17 pm SYSADMOZ From 01 2009 to 31 Dec 2009 Report No SM1Z25 Page l of 1 First Supervisor 10 03 200 SYSADMOZ SYSNEHA sys adm neha 12 03 200 SYSADMOZ TPROFILE Profile Date 16 03 200 SYSADHMOZ First Teller 10 03 200 SYSADMOZ End of Report 18 ORACLE SM125 Users Created Deleted 5 On the File menu click Print 6 The system displays the Print dialog box 7 Select the appropriate parameters and click the OK button 19 ORACLE SM104 User Inactivity Report SM104 User Inactivity Report This report is a list of users who are inactivate for a period of time Each column in this report provides information about the Branch User ID User Name Last Sign On and Remarks To generate the User Inactivity Report 1 Access the Report Request Fast Path 7775 screen 2 Ensure that the Adhoc Reports button is selected 3 Navigate through Security Management gt SMS Daily Reports gt SM104 User I
15. for Converted Loan This process is used to close the loan accounts with Automatic EFS Date falling on running day If running of this process is skipped on a particular day such accounts falling due for automatic closure on that day will be picked on next working day process Future dated closure or back dated closure is not be supported If the automatic closure date falls on a holiday then such accounts will be picked up on the next working days process All accounts attempted for such system initiated closure will be marked as Tried for both successful and failure cases The accounts which are marked as Tried will not be picked up for further retries when the process is attempted at the later dates e Mark for Write Off In this process system displays the Accounts marked for write off are pending processing Cannot proceed message for the account which are marked for write off for which the write off process has not been executed If there are no accounts marked for write off FLEXCUBE will start the process of marking accounts for write off based on the parameters defined The system displays the message SUCCESS MESSAGE after the process is completed e Automatic Write Off In this process system displays the No accounts marked for write off Cannot Proceed message if no account is write off for which the write off process Accounts manually marked for write off will be fully written off irrespective of the present Credit Risk 2
16. he code of the branch for which the report needs to be viewed from the drop down list 5 Enter the appropriate parameters in the SM120 SMS Event Logs screen 6 Click the View button to view the report 7 The system displays the SMS Event Logs Report screen 37 ORACLE SM120 SMS Event Logs 9199 DEMO FLEXCUBE Bun Time 08 44PM2009 SYSOPER AUDIT TRAIL REPORT Report No SM120 1 For 31 Dec 2007 User Id Event Date and Time Machine Name Task Code Task Description Action No data for this Report 38 ORACLE SM120 SMS Event Logs 8 On the File menu click Print 9 The system displays the Print dialog box 10 Select the appropriate parameters and click the OK button 39 ORACLE SM105 Password Expiry Report SM105 Password Expiry Report This report displays the list of users whose primary or secondary password has expired This will be used by the system administrator to alert the respective users and to keep a log of updates Each column in this report provides information about User Number User ID User Name Template Employee Code Last Password Change Date Primary Secondary Inputter Next Password Change Date Primary Secondary Department Code and Authoriser Frequency e Daily EOD To view and print Password Expiry Report 1 Access the Report Request Fast Path 7775 screen Select the Batch Reports button Navigate through Security Management gt SMS DAILY REPORTS gt SM105 Password
17. imary Password Expired Primary Password Expired Primary Password Expired Primary Password Expired 22 ORACLE SM104 User Inactivity Report 4 Onthe File menu click Print 5 The system displays the Print dialog box 6 Select the appropriate parameters and click the OK button 23 ORACLE SM112 List Of Disabled Users SM112 List Of Disabled Users The system may disable certain user ID s due to wrong entry of password This report is used by the systems administrator to keep track of such occurrences Each column in this report provides information about the User Number User ID User Name and Cost Center To generate the List Of Disabled Users 1 Access the Report Request Fast Path 7775 screen 2 Ensure that the Adhoc Reports button is selected 3 Navigate through Security Management SMS Daily Reports SM112 List Of Disabled Users 4 The system displays the SM112 List Of Disabled Users screen SM112 List Of Disabled Users Waived Service Charge V Generate 5 By default the Waived Service Charge check box is selected Clear the check box if you want to apply the service charge for the report 6 Click the Generate button 7 The system displays the message Report Request Submitted Click the OK button 8 The system generates the List Of Disabled Users For reference a specimen of the report generated is given below 24 ORACLE SM112 List Of Disabled Users
18. inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corpor
19. l Check Box Select the check box to waive the service charge Enter the appropriate parameters in the SM103 User Access Rights Report screen Click the Generate button The system displays the message Report Request Submitted Click the OK button The system generates the User Access Rights Listing Report For reference a specimen of the report generated is given below 10 ORACLE SM103 User Access Rights Report Bank 335 DEMO BANK Branch 9999 DEMO Op Id SYSADMOl FLEXCUBE Run Date 21 12 2009 Task Id For 31 Dec 2007 Task Description Parent Code USER ACCESS RIGHTS LISTING Run Time 6 17 Report No SMl03 1 Parent Description Branch User Id SYSADMOlI Name First System Administrator Category SM Event Log Inquiry Reset primary password Reset secondary password Change primary password Change secondary password Report Request Advice Report Status Enquiry Advice Report Cancel Request All Tellers Security Reports Security Currently logged in User list Reports Access Maintenance Access Codes Maintenance Access Domain Maintenance Transaction Group Code Maintenance Template Transaction Field Xref Internal Transactions End of Report 11 Level 50 Inquiries Security Security Security Security Reports Reports Reports Global Definitions Internal Transactions Internal Transactions Security Security Security Security Security Securit
20. nactivity Report 4 system displays the SM104 User Inactivity Report screen SM104 User Inactivity Report x Input Parameters Enter No of Days Waived Service Charge __Generate Field Description Field Name Description Enter No of Days Optional Numeric Nine Type the number of days to generate the user inactivity report Waived Service Charge Optional Check Box Select the check box to waive the service charge 20 ORACLE SM104 User Inactivity Report Enter the appropriate parameters in the SM104 User Inactivity Report screen Click the Generate button The system displays the message Report Request Submitted Click the OK button Click the OK button The system generates the SMS Event Logs Report MONDO To view and print the User Inactivity Report 1 Access the Advice Report Status Enquiry Fast Path 7778 screen 2 Select the check box corresponding to SM104 User Inactivity Report 3 Click the View button to view the report The system displays the User Inactivity Report screen 21 ORACLE SM104 User Inactivity Report Branch User Id 560 SYSSMSO2 560 SYSSTL 560 SYSSUPER 240 SYSTD 560 SYSTELLER 560 SYSTEM 560 SYSVTELLER 240 SYSVTELLERL 240 TABHIJIT 240 560 TBS USER 240 TDEVCASA2 240 TELANGO 240 240 THARI 240 THARIKA 240 240 240 240 TKIRAN 240
21. nt option from the File menu 9 The system displays the Print dialog box 8 Select the appropriate parameters and click the OK button 47 ORACLE
22. onship Pricing RP etc Beginning of the Day BOD process opens a new transaction day for the Bank BOD as a process depends on EOD process for the previous working day This means if the EOD is not completed for a day system will not allow the BOD for the next day to start List of Batch Reports e SMS DAILY REPORTS Access e Fast Path EOD10 e Operator Process gt EOD BOD Operations gt EOD Processing To generate batch reports 1 Take Pre Cutoff Backup before processing the EOD Log in to the FLEXCUBE Retail application with a valid System Operator Login ID The FLEXCUBE Retail window appears Access the EOD Client Fast Path EOD10 screen 26 ORACLE Batch Reports Field Description Field Name Description Process Category Mandatory Drop Down Select the category of the process to be performed The options are e End of Day It is a process where a fixed set of shell or functionality are processed A proper handoff of GL s to FLEXCUBE Corporate Consolidation etc is done in the EOD process Interest related processing GL Updations Draw Down Sweep Outs TD part redemption due to Sweep In instructions report related processing are done during the EOD processing e Beginning Of Day It is process where in some predefined functions are processed The user can login in the system after the BOD is completed The validation for BOD is that the previous day EOD should be completed For e g TD M
23. performed 29 ORACLE Batch Reports Column Name Description Status Display This column displays the status of the process performed The status can be as follows Yet to Start e Started e Aborted e Completed Duration Display This column displays the duration for which the process was running or when was the process completed Select Cutoff from the Process Category drop down list Select the appropriate parameters in the EOD Client screen Click the Start button to start the cutoff process On successful completion of cutoff process the system displays the message Category Successfully Completed 9 Click the OK button 10 Select End of Day from the Process Category drop down list 11 Click the Start button to start the EOD process 12 On successful completion of EOD process the system displays the message Category Successfully Completed and saves the reports in a folder in an appropriate location For e g home wasadmin USGapsSTR1 flexcube host runarea rjsout Note Once this is done the operator should logout completely out of the system and login again After the EOD Console is brought up again the operator must check the process date displayed at the bottom right hand corner of the status bar below The date should have moved to the next process date 13 Take POSTEOD Backup for that process date before processing the BOD 14 Select Beginning of Day from the Proce
24. ram website at http www oracle com pls topic lookup ctx acc amp id docacc 1 3 Access to OFSS Support https support us oracle com 1 4 Structure This manual is organized into the following categories Preface gives information on the intended audience It also describes the overall structure of the Reports Manual Introduction provides brief information on the overall functionality covered in the Reports Manual Chapters are dedicated to individual reports and its details covered in the Reports Manual 4 ORACLE Preface 1 5 Related Information Sources For more information on Oracle FLEXCUBE Core Banking Release11 5 0 0 0 refer to the following documents Oracle FLEXCUBE Core Banking Licensing Guide 5 ORACLE Security Management Reports 2 Security Management Reports A report is a document that is illustrated with the help of information and tailored to a given situation and audience The primary purpose of a report is to provide information However reports may also include additional information such as suggestions or conclusions that indicate possible future actions which the report reader might take Reports can be public or private Advice is generally a written proof of a service performed funds transferred or a payment that is received or made It can also be a recommendation that advises a customer about specific investment asset allocations based on age and circumstances Oracle Flexcube supports r
25. rts button Navigate through Security Management gt SMS DAILY REPORTS gt SM117 User Profile Maintained Today 4 The system displays the SM117 User Profile Maintained Today screen SM117 User Profile Maintained Toady Process Date DD MM YYYY 15 02 2008 Branch Code Malang 32 ORACLE SM117 User Profile Maintained Today Field Description Field Name Description Process Mandatory dd mm yyyy Date DD MM YYYY Type the date for which the report is processed By default the system displays the current process date Branch Code Mandatory Drop Down Select the code of the branch for which the report needs to be viewed from the drop down list 5 Enter the appropriate parameters in the SM117 User Profile Maintained Today screen 6 Click the View button to view the report 7 The system displays the User Profile Maintained Today Report screen 33 ORACLE Bank Demo bank Branch 9999 Demo SYSOPER User ID TR2 90 5 117 9999 SM117 User Profile Maintained Today UE Run Date 16 04 09 USER PROFILE MAINTAINED TODAY Run Time 80235 31 Jan 2009 Repot No SM117 1 User Name Action Action Date Maker ID REPORTS TESTING Added Reports Testing Added Checker ID 16 04 09 SYSCASA SYSADMOT 16 04 09 SYSCASA SYSADMO1 End of Report 34 ORACLE SM117 User Profile Maintained Today 8 Select the Print option from the File menu 9 The
26. ss Category drop down list 15 Click the Start button to start the EOD process 16 On successful completion of BOD process the system displays the message Category Successfully Completed and saves the reports in a folder in an appropriate location For e g home wasadmin USGapsSTR1 flexcube host runarea rjsout 17 Click the OK button 18 Take POSTBOD Backup after executing the BOD 30 ORACLE SMS DAILY REPORTS 2 2 1 SMS DAILY REPORTS The SMS Daily Reports includes reports specific to the user profiles that are maintained daily List of SMS Daily Reports SM117 User Profile Maintained Today SM120 SMS Event Logs 31 ORACLE SM117 User Profile Maintained Today SM117 User Profile Maintained Today To carry out various activities in the system users are added by the bank Similarly user profile modification deletion is also performed according to the defined roles and business requirement Any changes performed to the user profiles are logged and are reported end of the day This report is a list of user profiles maintained for the day The lists of users along with the actions performed are listed in this report Each column in this report provides information about User Number User ID User Name Action Action Date Maker ID and Checker ID Frequency e Daily EOD To view and print User Profile Maintained Today Report 1 Access the Report Request Fast Path 7775 screen Select the Batch Repo
27. system displays the Print dialog box 10 Select the appropriate parameters and click the OK button 35 ORACLE SM120 SMS Event Logs SM120 SMS Event Logs Bank required to have very strict control and vigilance in terms of access to the system It is imperative for a bank to ensure that access to various modules transactions in is well controlled To facilitate this control an Audit trail can be maintained for any task transaction accessed by the user along with the terminal machine where it has been performed A log is then recorded and can be accessed by the bank at any future date Each column of the report provides information on User Id Event Date and Time Machine Name Task Code Task Description and Action Details are grouped branch wise Frequency Daily EOD To view and print SMS Event Logs Report 1 Access the Report Request Fast Path 7775 screen Select the Batch Reports button Navigate through Security Management gt SMS DAILY REPORTS gt SM120 SMS Event Logs 4 The system displays the SM120 SMS Event Logs screen 5 120 SMS Event Logs Process Date DD MM YYYY 31 12 2007 Branch Code Malang 36 ORACLE SM120 SMS Event Logs Field Description Field Name Description Process Mandatory dd mm yyyy Date DD MM YYYY Type the date for which the report is processed By default the system displays the current process date Branch Code Mandatory Drop Down Select t
28. y Transaction Processing ORACLE SM120 SMS Event Logs SM120 SMS Event Logs Bank required to have very strict control and vigilance in terms of access to the system It is imperative for a bank to ensure that access to various modules transactions in is well controlled To facilitate this control an Audit trail can be maintained for any task transaction accessed by the user along with the terminal machine where it has been performed A log is then recorded and can be accessed by the bank at any future date Each column of the report provides information on User Id Event Date and Time Machine Name Task Code Task Description and Action Details are grouped branch wise To generate the SMS Event Logs Report 1 Access the Report Request Fast Path 7775 screen 2 Ensure that the Adhoc Reports button is selected 3 Navigate through Security Management gt SMS DAILY REPORTS gt SM120 SMS Event Logs 4 The system displays the SM120 SMS Event Logs screen SM120 SMS Event Logs Input Parameters From User Id Waived Service Charge To User Id Generate 12 ORACLE SM120 SMS Event Logs Field Description Field Name Description From User ID Mandatory Alphanumeric Nine Type the valid From User Id which the report needs to be generated This Id should not be greater than the To User Id To User ID Mandatory Alphanumeric Nine Type the valid To User Id till which the report ne
Download Pdf Manuals
Related Search