Safe Deposit Box Reports Manual
Contents
1. 24 ORACLE SB007 SDB Past Due 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 code of the branch for which the report needs to be viewed 5 Enter the appropriate parameters in the SB007 SDB Past Due Report screen 6 Click the View button to view the report 7 The system displays the SDB Past Due Report screen 25 ORACLE SDB Past Due Repor BankName Bank Page Number Page 1 of1 Branch Code 9999 Report SDB07 Branch Name Head Office Date 20 Mar 20 OperatorlD TDARSINI Safe BoxID Allotment No Account Ti Customer Mobile Pho Office Pho Home Phone Product Tv Due Since Rent Due Past Due D Provider provider 1001 000000026955 502155 1002 000000032383 601552 1003 000000032417 501552 1005 000000032524 501538 1006 000000032540 601538 1008 000000032599 601532 1010 000000032706 601532 1011 000000032714 601532 1012 000000032730 601532 1013 000000036475 602423 1014 000000038794 600170 1015 000000039446 602501 1004 000000046656 602270 1007 000000046904 601665 1009 000000046920 600415 2001 000000047555 602772 1017 000000057208 601576 2001 000000025502 601431 2002 000000025544 601526 2003 000000026708 602155 2004 000000026807 602155 2005 000000026922 602155 SDB L SDB L SDB L SDB L SDB L SDB L SDB L SDB L SDB L2. SDB L SDB L SDB L SDB L 8DB L SDB L SDB L SDB L SDB M SDB M SDB M SDB M SDB M 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 0 00 000000026955 000000032383 000000032417 000000032524 000000032540 000000032599 000000032706 000000032714 000000032730 000000036475 000000038794 000000039446 000000046656 000000046904 000000046920 000000047555 000000057208 000000025502 000000025544 000000026708 000000026807 000000026922 CASA Casa account afc sta 26 SB007 SDB Past Due Report ORACLE 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 27 ORACLE
3. and Customer Name To generate the Safe Box User Report 1 Access the Report Request Fast Path 7775 screen Ensure that the Adhoc Reports button is selected Navigate through Safe Deposit Box gt Safe Box Reports gt SB002 Safe Box User Report 4 The system displays the SB002 Safe Box User Report screen SB002 Safe Box User Report x Input Parameters Enter the safe box type Waived Service Charge v Enter the branch code Generate Field Description Field Name Description Enter the safe box type Mandatory Alphanumeric Six Type the valid Safe Box category to generate the report Enter the branch code Mandatory Numeric Five Type the branch code to generate the report 9 ORACLE SB002 Safe Box User Report Field Name Description Waived Service Charge Optional Check Box Select the check box to waive the service charge Enter the appropriate parameters in the SB002 Safe Box User Report screen Click the Generate button The system displays the message Report Request Submitted Click the OK button ONO The system generates the Safe Box User Report For reference a specimen of the report generated is given below 10 ORACLE SB002 Safe Box User Report Bank 335 DEMO BANK Flexcube Run Date 02 Jan 2009 Branch 9999 DEMO Safe Box User Report Run Time 3 28PM Op ID TNEHA Safe Box Type 77 Report No SB002 1 For 15 Dec 2007 Safe Box ID Product Name llotment N
4. button 7 The system displays the message Report Request Submitted Click the OK button 8 The system generates the Master Box Listing Report For reference a specimen of the report generated is given below 16 ORACLE SB010 Master Box Listing Report Master Box Listing Report Bank Code 335 Page Number Page 1 of 1 Bank N DENO BANK Report SDBO10 cux Date 15 Mar 2008 Branch Code 9993 Operator ID TNEHA Branch Name DEMO Safe Product Allotment Customer ID Account Title DB Status Date Open Date Due Provider Rent Amount Taz Total due Key deposit Box ID Type Number Casa Due due amount 6 77 6000000037444 603958 SIGITA Open Regula 11 30 2007 02 29 2008 600000003744 0 00 0 00 0 00 0 00 r 77 6000000037544 603958 SIGITA pen Regula 11 30 2007 11 30 2007 600000003754 0 00 0 00 0 00 0 00 r 1 77 000000027544 603969 PARAGDEKAL Open Regula 11 30 2007 01 15 2008 600000002754 0 00 0 00 0 00 1000 00 r 2 77 6000000028244 603971 PAPAGDEKAL Open Regula 11 30 2007 01 15 2008 600000002824 0 00 0 00 0 00 0 00 r 33 7T 6000000092344 604527 ARVINDKUMAR Open Regula 11 30 2007 02 29 2008 600000009234 0 00 0 00 0 00 0 00 r 57 77 6000000118844 604532 GeorgePaul Forced 12 15 2007 02 29 2008 600000011884 0 00 0 00 0 00 0 00 Reneved 61 7 6000000122944 604532 CeorgePaul Forced 11 30 2007 02 29 2008 600000012284 0 00 0 00 0 00 15000 00 17 ORACLE Batch Reports 2 2 Batch Reports Batch reports are automatically generated at the end of day E
5. button Take POSTBOD Backup after executing the BOD 22 ORACLE Safe Deposit Reports 2 2 1 Safe Deposit Reports The Safe Box Reports include reports of safe deposit box past due List of Safe Deposit Reports e SB007 SDB Past Due Report 23 ORACLE SB007 SDB Past Due Report SB007 SDB Past Due Report Rent is charged by bank for maintenance of the Safe Deposit Boxes SDBs allotted to the customers The amount of rent is defined through the Service Charges maintenance Rent is recovered by debit to the provider CASA Account or by any other mode as specified during SBD opening At the end of day a batch report enlists the SDBs for which the rent is past due and thus enables the branches for effective follow up This is the report for SDB Past Due Each column of this report provides details on Safe Box ID Allotment Number Account Title Customer ID Mobile Phone Office Phone Home Phone Product Type Due Since Rent Due Past Due Days Provider CASA Account Number and Provider CASA Account Status Frequency e Daily EOD To view and print SDB Past Due Report 1 Access the Report Request Fast Path 7775 screen Select the Batch Reports button Navigate through Safe Deposit Box gt Safe Box Reports gt SB007 SDB Past Due Report 4 The system displays the SB007 SDB Past Due Report screen SB007 SDB Past Due Report Process Date DD MM YYYY 31 07 2008 Branch Code Malang v Yiew
6. screen 2 Ensure that the Adhoc Reports button is selected 3 Navigate through Safe Deposit Box gt Safe Box Reports gt SB007 SDB Past Due Report 4 The system displays the SB007 SDB Past Due Report screen SBOO SDB Past Due Report 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 Click the Generate button The system displays the message Report Request Submitted Click the OK button The system generates the SDB Past Due Report o 09 12 ORACLE SB007 SDB Past Due Report To view and print the SDB Past Due Report 1 Access the Advice Report Status Enquiry Fast Path 7778 screen 2 Select the check box corresponding to SB007 SDB Past Due Report 3 Click the View button to view the report 4 The system displays the SDB Past Due Report screen 13 ORACLE SB007 SDB Past Due Report SDB Past Due Report Bank Name Bank Danamon Page Number Page 1of1 Branch Code 9999 Report SDBOF Branch Name Head Office Date 30 Apr 2008 Operator ID SAMOL Bafe Box Allotment No Account Til Customer Mobile Office Home Product Due Since Rent PastDue Provider provider frag Phone Phone Phone Type Due Days CASA account casa afc sta 1013 000000036475 602423 SDB L 0 00 D00000036475 14 ORACLE SB007 SDB Past Due Report
7. 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 SB010 Master Box Listing Report SB010 Master Box Listing Report Safe Deposit Boxes SDBs are allotted to eligible customers using the Safe Box Allotment Fast Path 8057 option Using the Safe Box Usage Log Fast Path SB001 option usage of the SDBs during the day are maintained To keep track of the total SDBs for the branch an adhoc report can be generated This report gives the complete overview of the SDB allotments on the branch This is the report for Master Box Listing Each column of this report provides details on Safe Box ID Product Type Allotment Number Customer ID Account Title Safe Deposit Box Status Date Open Date Due Provider Current and Savings Account Rent Amount Due Tax Due Total Due and Key Deposit Amount To generate the Master Box Listing Report 1 Access the Report Request Fast Path 7775 screen Ensure that the Adhoc Reports button is selected Navigate through Safe Deposit Box gt Safe Box Reports gt SB010 Master Box Listing Report 4 The system displays the SB010 Master Box Listing Report screen SBO10 Master Box Listing Report Waived Service Charge 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
8. D10 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 Boom 18 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 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 is done during the EOD processing 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 Maturity 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 19 ORACLE Batch Re
9. OD 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 Relationship 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 Safe Box Reports Access e Fast Path EO
10. ORACLE Oracle FLEXCUBE Core Banking Safe Deposit Box Reports Manual Release 11 5 0 0 0 Part No E52876 01 July 2014 Safe Deposit Box 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 inherently dan
11. 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 Safe Box Reports 7 ORACLE Safe Deposit Box Reports 2 1 1 Safe Box Reports The Safe Box Reports include reports of safe deposit box rental and allotment due List of Safe Box Reports e SB002 Safe Box User Report e SB007 SDB Past Due Report e SB010 Master Box Listing Report 8 ORACLE SB002 Safe Box User Report SB002 Safe Box User Report Safe Deposit Boxes SDB are allotted to eligible customers using the Safe Box Allotment Fast Path 8057 option Using the Safe Box Usage Log Fast Path SB001 option the usage of the SDBs during the day are maintained To keep track of the total SDBs for the branch an adhoc report can be generated This report gives listing of the SDB allotments on the branch This is the Safe Box User Report generated for the branch Each column of this report provides details on Safe Box ID Product Name Allotment Number
12. 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 Safe Deposit Box Reports Manual Table of Contents jM 4 2 Safe Deposit Box Heports ueeeisesisieessc GG autc a nee U AA SE anniina aiina 6 CNET i 7 2 1 1 58 8 BOX CIOS t rice AA 8 Bes Sae Box User ROO nna an kA R 9 SB007 SDB Past DUS Repol C 12 BAONG Master Box Lising REDON arisini paha ara a Eaa 16 Bie BOI RODO censon aaO A OS EA R OR A 18 2 2 1 8s Deposit BOOK G eniinn aa esca pde dic ipe E EERE 23 BANO SDB Fast Due oj er 24 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 Program 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 indi
13. gerous 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 Corporation and its
14. hen 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 Click the OK button Select End of Day from the Process Category drop down list Click the Start button to start the EOD process 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 14 15 16 17 18 Take POSTEOD Backup for that process date before processing the BOD Select Beginning of Day from the Process Category drop down list Click the Start button to start the EOD process 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 Click the OK
15. ing 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 e 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 Display This column displays a different colour for different process state The different colour displayed are e 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 24 ORACLE Batch Reports Column Name Description Module Code Display This column displays the code of the module on which the process is performed Status Display This column displays the status of the process performed The status can be as follows e Yet to Start e Started e Aborted e Completed Duration Display ONO 10 11 12 This column displays the duration for which the process was running or w
16. o Customer Name 83 SAFE DEPOSIT BOX prod type correct 99000000001440 JOHN H DCOST 84 SAFE DEPOSIT BOX prod type correct 99000000002 440 TERRY 85 SAFE DEPOSIT BOX prod type correct 99000000003 440 TERRY 86 SAFE DEPOSIT BOX prod type correct 99000000004440 TERRY 87 SAFE DEPOSIT BOX prod type correct 99000000005440 TERRY 88 SAFE DEPOSIT BOX prod type correct 99000000006440 TERRY 89 SAFE DEPOSIT BOX prod type correct 99000000007440 TERRY 90 SAFE DEPOSIT BOX prod type correct 99000000008440 TERRY 91 SAFE DEPOSIT BOX prod type correct 99000000009440 TERRY 11 ORACLE SB007 SDB Past Due Report SB007 SDB Past Due Report Rent is charged by bank for maintenance of the Safe Deposit Boxes SDBs allotted to the customers The amount of rent is defined through the Service Charges maintenance Rent is recovered by debit to the provider from the CASA Account or by any other mode as specified during SBD opening At the end of day a batch report enlists the SDBs for which the rent is past due and thus enables the branches for effective follow up This is the report for SDB Past Due Each column of this report provides details on Safe Box ID Allotment Number Account Title Customer ID Mobile Phone Office Phone Home Phone Product Type Due Since Rent Due Past Due Days Provider CASA Account Number and Provider CASA Account Status To generate the SDB Past Due Report 1 Access the Report Request Fast Path 7775
17. ports Field Name Description the previous day BOD should be completed 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 e 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 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 automa
18. tic 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 20 ORACLE Field Name Category Status Process Date Next Process Date Column Name Batch Reports Description process Accounts manually marked for write off will be fully written off irrespective of the present Credit Risk 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 includ
19. vidual 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 Safe Deposit Box Reports 2 Safe Deposit Box 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 report 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
Download Pdf Manuals
Related Search