Home

System Operations User Manual

1. Run FX Auto Revaluation for each branch eae Mark End Of Financial Input EOFI for all the branches Run FCC EOFI Backup Oo N D F F E F F F F F F F E F F E E F Spool the necessary reports such as balance sheet and trial balance for each branch Generate GL consolidated balance sheet for Head Office Run End Of Day for each branch 20 Run the BOD batches viewing the pending programs would be F helpful for each branch 21 Take SOTI backup 57 ORACLE o CR CC CC CC CR CR CC CC CR CR CR CR CR CC CC CC CC CC CC C Interfacing with FLEXCUBE Corporate 22 Start Transaction Input for each branch FCC 23 Run FCR BOD FCR 25 Run Apply CIF program FCR 26 Take FCR Post BOD Backup FCR 4 4 1 EOD Flow of Events for FCR Run Generate CIF program FCR Following is the screen for EOD Flow of Events for FCR EOD Flow of Events Sas lt Soues Grr aana Se A RA TS Se STARS Ge_F ENS a im_post_dates_auth Smeroetme D C GtexnPocting_ pest gt Fig 22 EOD Flow of Events FCR Screen 58 ORACLE Interfacing with FLEXCUBE Corporate Checklist for the EOD operator for FCR Sr Description No 1 Closing of all teller vault and branch batches 2 FCR Branch Backup of the branch before running EOD 3 Eligibility Evaluation Category if required 4
2. Stop Install Uninstall Update Export Export DDL Tt a a a j Fig 24 EOD Services for Retail Application Screen 61 ORACLE Login for EOD Operations 4 5 2 Bringing Up the Operator Menu The Beginning of Day BOD is run from an operator s login on FLEXCUBE Retail To open the operator menu e Logon to FLEXCUBE with a valid System Operator Login ID Login Screen 3 1 ITR1 ORACLE FLEXCUBE Login Fig 25 Login Screen 4 5 3 Invoking the EOD Console All the batch processing operations mentioned above have to be run from the EOD Processing Fast Path EOD10 option To invoke the EOD console 1 Logon to FLEXCUBE with a valid System Operator Login ID 2 Enter the Fast Path EOD10 OR From the EOD BOD Operations menu select EOD Processing 4 FLEXCUBE displays the screen as shown in the following figure 62 ORACLE Login for EOD Operations EOD Client Screen Fig 26 EOD Client Screen As can be seen from the screen above there are two frames in this window The top frame is called the General frame and the bottom frame is called the Status frame Both the frames are disabled when no category is selected The General frame displays the status of the process category which will run once it is selected and also the current and next process date for which the category will be run From the General frame the operator has to select the process category
3. Troubleshooting Diagnostic Trace Service Screen Application Servers gt FCBST1 gt Logging and Tracing gt Diagnostic Trace Service Use this page to view and modify the properties of the diagnostic trace service fi Configuration General Properties Enable Trace FZ Enable trace wih the folowing specification p e this box to enable the selected trace Trace Specification foom iflex allzenabled i Use these options to specify tracing details Modify C GlUse these options to specify the type of output Memory Gutter generated by the trace Maximum Buffer Size 3 thousand entries Fie Maximum File Size s MB Maximum Number of Historical Files fi File Name home wasadminitchstiflexcubednstalliog Ser Trace Output Fig 36 Diagnostic Trace Service Screen 4 11 2 Process Abort Procedures If any of the process in the Category Cutoff End of Day or Beginning of Day shows aborted and the process cannot move ahead the operator has to follow the instructions mentioned below e Note down the sub process name of the category that has aborted e Contact support and follow the instructions given by the support staff Also by the time contact is established the operator can ensure that the trace file has been generated in the location mentioned in the diagnostic trace file path 94 ORACLE Troubleshooting 4 11 3 Common Script to Update Non Operator Login Status When the opera
4. Category successfully completed is displayed Clear this box using the space bar or by clicking on the Ok button After this click the Close button e After the Elig process is over exit out of the menu and before starting Cutoff login afresh into the system 4 9 2 Cut off Processing Overview Cut off is the process that operator must run at the end of every day before starting the EOD for that day to ensure that all transactions done through the on line delivery channels including branch ATMS POS and Tele banking 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 OLTP CUT OFF The following transactions are carried out during OLTP cut off e Change of business day e Close current logs e Initiate a new log file while the cutoff process is running e System is not available for external transactions like ATM Internet Banking etc ATM CUT OFF The following transactions are carried out during ATM cut off e Change of business day for ATM network e ATM available only in off line mode The ATM CUT OFF is automatically done by the system as soon as the normal cut off is complete EOD can start after last
5. Click the View button a F oN 99 ORACLE Reports Monthly Statements The monthly statement is generated in the backup database The post EOD data is loaded in the backup database The date of the last statement generated is updated and then the monthly statements are generated Process Category MONTHLY STATEMENTS x Category Status Completed Process Date 31 12 2004 State Process Name GN POST STATMENTS STREAM 1 POST STATMENTS STREAM 10 GN POST STATMENTS STREAM 2 NN POST STATMENTS STREAM 3 GN POST STATMENTS STREAM 4 NN POST STATMENTS STREAM 5 NN POST STATMENTS STREAM 6 MN POST STATMENTS STREAM 7 GN POST STATMENTS STREAM 8 POST STATMENTS STREAM 9 D STATEMENT SHELL STREAM 1 NN STATEMENT SHELL STREAM 10 NE STATEMENT SHELL STREAM 2 MN STATEMENT SHELL STREAM 3 QO STATEMENT SHELL STREAM 4 QO STATEMENT SHELL STREAM 5 MN STATEMENT SHELL STREAM 6 MN STATEMENT SHELL STREAM 7 QO STATEMENT SHELL STREAM 8 MN STATEMENT SHELL STREAM 9 Fig 41 EOD Client Screen Next Process Date 100 Module Code Status Duration IMS _ s COMPLETE 00 00 01 IMS COMPLETE 00 00 00 IMS s COMPLETE 00 00 00 IMS ss COMPLETE 00 00 01 IMs COMPLETE 00 00 00 IMS COmPLETE 00 00 01 ws cowpLeT00 00 00 Se 00 00 00 IMs COMPLETE 00 00 00 me CoMPLETE 00 COMPLETE 00 00 00 Ee eee 00 00 LETE 00 00 01 COMPLETE 00 00 00 MS COMPLETE 00 00 00 Ims s dCOMPLETE 00
6. s posting date are purged In the second year the ledger transactions earlier than two years from today s posting date are purged The records for which interest has been paid by the system and are two years earlier from today s posting date are purged by the system In the second year the transaction entries earlier than one year from today s posting date are purged After the outward clearing process is run for a posting date the records of the instrument that are processed in OWC are purged ORACLE Data Purging Table Name Purpose Recommended Recommended Purge Purge Frequency Handling Months CASA Account None No system Master purge set up on this table TD Account None No system Master purge set up on this table Loans Account None No system Master purge set up on this table In_acct_ledg Ledger for None No system transactions on purge set up on Loan accounts this table Stores the None At the CASA account beginning of balances to be financial year used for ADB the balances computation from this table get initialized by the system When ever CASA account is closed corresponding record from this table is deleted by the system Stores the Monthly Records information of pertaining to Standing the standing Instructions on instructions for CASA which execution accounts to be period has executed expired three months before the today s posting date are purged by
7. then the operator can proceed and run BOD by selecting from the drop down list If the category runs smoothly and gets completed the message box Category completed successfully is displayed After this the user has to clear this box and close the EOD Console Then log out of the application Go to the Application Server and the Services under Control Panel Check whether all the services mentioned below show status as Started in the Panel If not start the services 88 ORACLE Steps for EOD on a Normal Processing Day C Take POSTBOD Backup for that Process Date Beginning of Day Activities The broad set of activities which are undertaken by the system during the Start of Day Beginning of Day are Time Deposits Interest Processing Time Deposits Maturity Processing Time Deposits Unclaimed Deposits Processing Standing Instructions Execution Value Date Processing of cheques Expiry of Overdraft Limits Maturity processing for Recurring Deposit RD accounts Release of hold funds which have expired the previous day Resetting of the average daily balance statistics BOD of the New Year Updating the Unclaimed Status for the instruments SC package change 89 ORACLE System Maintenance 4 10 System Maintenance System Maintenance allows the user to up keep different activities It also allows the smooth functioning of various activities 4 10 1 Release Area Maintenance The Release area is the main s
8. 00 011 ORACLE
9. 7 Maintenance Maintenance allows the user to up keep different activities It also allows the user for the smooth functioning of various activities 3 7 1 Release Area Maintenance The Release area is the main section where FLEXCUBE is installed This area contains all the executable and supporting files All the reports are also generated here This makes the area very critical and should have strict controlling and restraining access The access to this area should be controlled It should not be available to everyone It should be monitored as users can go in that area and modify data which could lead to disastrous effects 3 7 2 Branch Server Maintenance Following are the options which can enhance the productivity of the branch server e Routine cleanup of C temp e Regular backup and cleanup of event viewer eventvwr e Regular clean up of WinDir System32 LogFiles IIS log e Regular space check and monitoring memory usage to enhance the server productivity e Anti virus schedule set up to ensure that scanning time does not coincide with branch working hours e Restarting server frequency restarting services frequency ready batch files on desktop for restart etc e Check growth of branch tables fast growing tables e Regular check on date time synchronization on all branch servers in line with application database server e Auto download scheduler set up frequency set up and monitoring for any failures 39 ORA
10. Browse button There is a utility available to convert the text file into an XML format Utility Name InwdFloopyUpld exe The data can then be loaded onto the screen using the Load button Once the data is successfully loaded the operator can save and validate the batch The rest of the processes would be the same as that for the batch data entry The records uploaded and authorised using the above would be processed in the next Inward Clearing batch run 22 ORACLE Branch Tables Purging 3 3 2 Load Central Bank Floppy File The Load Central Bank File Fast Path ST042 option enables the user to upload the inward clearing flat file received from the central bank FLEXCUBE Retail reads the input file and creates another flat file which is used in the Load Inward MICR File Fast Path ST031 option Load Central Bank File Screen Load Central Bank File Criteria INWARD CLEARING wal Clearin g House 2001 Java Clearing Clearin g Type RegulartdayFloat File Name Bea Ststi C 7 3 SS Currency INR M or e e Fig 3 Load Central Bank File Screen There is a pre specified format that can be used to directly load the data provided by the central bank The file needs to be present in the FLEXCUBE branch data base area in the Host rjsin area The system will convert the small clearing account numbers to the account numbers used by the FLEXCUBE system and use the same for further processing Note down the batc
11. FCR Pre Cutoff Backup host 5 Check if the Batch Application is running in Host Start if not running 6 Start the cutoff 7 Run the EOD 8 Take Post EOD backup 9 Run BOD 10 Take Post BOD Backup 11 Run statement category to generate statements on Month ends 59 ORACLE Login for EOD Operations 4 5 Login for EOD Operations 4 5 1 Control of EOD Services for Retail Application For FLEXCUBE Retail there are a number of services that are running and that can be viewed To view them login to the IBM WAS Admin Console This will invoke a window which will appear as follows Enterprise Applications Screen Welcome gnh Logout Support Help Welcome Close page E E Servers Enterprise Applications 2 Brel Application servers Enterprise Applications Generic servers JMS Servers Lists installed applications A single application can be deployed onto multiple servers Web servers Preferences Clusters Start Stop Install Uninstall Update Rollout Update Remove File Export Export DDL Cluster topology nE Te Core groups calea E Applications Select Name Status Enterprise Applications r FCBUSARel1Batch gt Install New Application m FCBUSARel1Channel Resources ae FOBUSAReltFileTransfer ecurity NA m FCBUSARel1Gefu System administration m FCBUSARel1GefuProcessor EiMenitonngandituning m FCBUSARel1GefuScheduler Troubleshooting
12. Local Service Siy Application Manage Processes i Manual Local System Ky Automatic Updates Enablesth Started Automatic Local System Background Intelig Transfers f Manual Local System a sebranch Service 9999 Started Manual Local System Ky ClipBook Enables Cli Disabled Local System a COM Event System Supports 5 Started Automatic Local System Ry COM System Appl Managest Started Manual Local System Ky Computer Browser Maintains 4 Started Automatic Local System a Cryptographic Serv Provides th Started Automatic Local System Fig 1 Branch Server Start Operations Screen To prepare the bank for the day s operation 1 Switch on the UPS and Branch Server in that order 2 After the Branch Server comes up click the Services shortcut icon on the Branch Server desktop IT staff to ensure that the shortcut is created Start the Branch Service Data Center will then download the previous day s EOD Current day s BOD reports from the Data Center 5 Double click the Download icon on the desktop to start the automatic download operations 6 Now the Branch server is ready for the branch to start the day s operations 14 ORACLE Branch Operations 3 2 2 Cash and Transfer Operations This section deals with the workflow related to the cash and transfer operations in a typical business day in chronological order with respect to FLEXCUBE Start of Business Day Open Branch Batch The Br
13. System Log On As Local System Local System Local System Local System Local System Fig 11 FLEXCUBE Retail Services Screen Note The GEFU service can be shut down once the upload is over and then restarted once the new files have to be uploaded Only ensure that when the file is uploaded the service is up for it to get processed 33 ORACLE GEFU File Upload 3 6 1 Upload Process For the file to upload use the File Upload GEFU Fast Path BA452 option Depending on the set up done in the application the system code is selected from the pick list File Upload GEFU Screen File Upload GEFU External System Code ADDF CHAN E EEE hang File Type adrFiler LE Upload File Handoff File Details Input File Name regs03051 1007incorrec taccoun stat a Process Date 15 02 2008 SE i ea RO Fig 12 File Upload GEFU Screen The file to be uploaded is kept in the rjsin directory of the Branch server The file name is entered in the Input File Name field It is case sensitive so the name has to be entered accurately A proper description of the file which is uploaded is mentioned in the Narration field After adding the file details before the actual upload the user has the option of viewing enquiry of the file being uploaded The user can view the summary of all records in the file and also on double clicking each record
14. Updates e FLEXCUBE installation area maintenance like updating new releases regularly and registry updates for new branch additions 90 ORACLE Troubleshooting 4 11 Troubleshooting 4 11 1 Path for Logging the Trace File To locate the path where the trace file will be logged log into the Web Sphere Application server Under Services click the application server to view it The application server will be displayed as shown below in the screen Application Servers Screen User ID Application Servers ferdb Network E Servers Anpication Servers MS Servers Totat 4 Fitered tote 1 Clusters Fite Custer Topo Preferences B Aplealins ow Ole tat Stp E Resources E Securty B Envirme r est fet E System Administration E Troubleshooting An application server is a server which provides services required to run enterprise applications i Fig 33 Application Servers Screen After double clicking the service name under the Name column the Configuration screen will appear as shown below 91 ORACLE Troubleshooting Configuration Tab Screen An application server is a server which provides services required to run enterprise applications i Apply OK Reset Cancel Additional Properties Transaction Service Specify settings for the Transaction Service as well as manage active transaction hocks iWeb Container Specify thread pool and dynamic cache settings for the container Also specify session manag
15. all details records with status Authorised or Reversed br_salary_chqs_ data Data for salary Daily Delete all cheques data entry records with batches status Authorised or Reversed ba_download_log Stores information Daily 15 about the downloaded tables rec_txnxmllog XML log of daily Daily 120 transaction details The Recommended Purge Handling days data cannot be changed 21 ORACLE Branch Tables Purging Clearing File Uploads 3 3 1 Inward Clearing batch Upload If an inward clearing file format is different to that accepted by the system in the central bank file screens or the clearing file format is available with the account number rather than the small clearing number then this method may be used The Batch Inward Clearing Cheque Data Entry Fast Path 5521 option can be used for directly adding the inward clearing cheques to form a batch or to upload a file containing the records to be processed in inward clearing Branch Inward Clearing Cheque Data Entry Screen Batch Type Action Batch Number Batch Status End Point Currency yi No of Instrs 2 IC Type Total Amount Save vai 1 C Populate Account Numbers J Fig 2 Batch Inward Clearing Cheque Data Entry Screen The teller data entry operator would use the Branch screen to directly upload the inward clearing file in XML format This file can be present anywhere and can be selected using the
16. batch is closed successfully the branch system administrator should proceed to shutdown the branch server as per the steps explained in the section below e Take the branch database backup Also transfer the data to a DAT drive A standard naming convention of dumps is to be maintained e For example BRNCODE_date e Shutdown the Branch Server and power off the Branch Server and UPS e By default the back up for Key Data tables master tables transaction log tables etc is taken Full database backup should be taken at periodic intervals 42 ORACLE Security Management System Related Activities 3 8 5 Dos and Don ts on the Branch Server Don ts Do not remove any folders files on the branch server without the explicit approval from the Datacenter Do not create any new files and folders on the branch server hard disk Do not power off the branch server when it is up and running Do not change the system parameters or Oracle parameters without the explicit approval from Datacenter Do not unplug the cables when the server is up and running Do not connect the printers to the branch server as it will reduce the server performance in case of continuous printing Startup and shutdown the branch server as per the procedure explained above Keep updating the branch server and clients with the latest anti virus software Change the power on and administrator passwords of the branch server as per the password policy 43
17. check for any differences in the transactions posted in branch and transactions updated in Data Center host If there is a difference between these transactions the system will give a warning stating that branch batch confirmation is not successful and will not allow the supervisor to close the branch batch In such cases the supervisor should inform the data center about the difference immediately and seek guidance If the branch batch confirmation is successful the supervisor should close the branch batch using Branch Batch Close Fast Path 6002 option If the branch batch confirmation is not successful the supervisor should invoke the Force Close Branch Batch Fast Path 6009 option for closing the branch batch on the advice of the data center The differences displayed in the branch batch confirmation should be accounted in the next business day and suitable remedial action should be undertaken 19 ORACLE Branch Tables Purging 3 3 Branch Tables Purging All the temporary tables and the transaction history tables in the branch database need to be purged at periodic intervals through the option provided in the software Before purging take a full dump of the database on to a separate DAT with appropriate label The suggested purge tables and their retention frequency are mentioned below Additional tables can be set up for purge whenever required and the purge retention period is set up depending on the data requirements of the ba
18. cut off ATM and OLTP is done 84 ORACLE Steps for EOD on a Normal Processing Day Steps for A Take Pre Cutoff Backup for that Process Date B Checking Whether the Service is Running e Check whether the service Batch shows status as Started e f the service shows the status Started restart the service e lf the service is not running start it C Starting with the Category e Login into the application using a valid user ID and password e Select EOD Processing from the menu e When the EOD Console is displayed select the process category CUTOFF from the drop down list e Check the current process date and next process date and ensure that they are correct e Click on the Start button The processes that should be run will be displayed and the processes will start running automatically The Refresh button can be used to refresh the process status Even if this is not done it has an auto refresh mechanism which will update the status after the refresh poll time interval e Once the process is over the message box Category successfully completed is displayed Clear this box by using the space bar or by clicking the Ok button After this click the Close button e After the Cutoff process is over exit out of the menu and before starting End of Day login again into the system 4 9 3 End of day EOD Processing Overview EOD refers to the processing required to be done for each functional module of FLEXCUBE Retai
19. end of each business day using the Report Request Fast Path 7775 and Advice Report Status Enquiry Fast Path 7778 options e TP5021 Cash Position e TP5023 Teller Transaction Report e TP5028 Inter Branch Accounts Opened Today e TP5029 Teller Inter Branch Transactions Report e TP5049 Cash Transactions Position e TP5050 Batch Journal Report e TP5051 EOD Cash Position Report e TP5052 Authentication Report e TP5070 Overage Shortage Report e TP5033 Instrument Details Report e TP5080 Travelers Cheque Sold Report e TP5081 Travelers Cheque Purchase Report 18 ORACLE Branch Operations All reports generated through the Adhoc Report Advice Request option are present in the following default area dictionary on the branch server lt FLEXCUBE INSTALLATION PATH gt branch brn reports After the above reports have been taken the branch supervisor manager should ensure the following 1 Supervisors should ensure that all the batches have been authorised and there is no batch pending for authorisation 2 Alltellers have tallied their cash and successfully closed their respective batches The branch batch can be closed only after all the tellers belonging to that branch have successfully closed their batches 3 The vault custodian has tallied the vault cash and successfully closed the vault batch 4 The Branch Batch Confirm Fast Path 6005 option is executed successfully The supervisor should
20. for correctness with actual vouchers slips This is a must so that if any entry has been posted wrongly it can be reversed through the Search Electronic Journal Fast Path 6006 option End of Day Cash Balancing amp Transfer of Cash to Vault At the end of the day the teller should tally the physical cash with the system cash If there is any shortage or overage the teller should try to resolve the difference by verifying the actual slips and details of denominations with the e TP5050 Teller Transaction Report e TP5021 Cash Position Report If the difference remains even after verification a Shortage or Overage needs to be booked accordingly After the teller has tallied his physical cash with the system count the cash can be retained in the tellers till box to the extent of the teller drawer lower limit However if the entire cash has to be turned over to the vault overnight the teller can use the Sell Cash to Vault Fast Path 9008 option Similarly for TCs the Sell TCs to Vault Fast Path 9019 option needs to be used The teller should also print and verify the following reports to verify transactions posted through GL Voucher Data Entry GLM01 e GL210 GL Voucher TX s Summary e GL211 GL Voucher batches not closed report End of Day Teller Batch Closure The teller should close the teller batch at the end of the day after the following has been done 1 All data entry batches have been Authorised and Closed 2 All t
21. for the regular data backups there should be a schema backup of the Oracle database taken at a fixed interval 4 1 2 Reports Backups The reports are generated daily during the process of EOD and BOD These reports should be backed up on a monthly bases The ATM transactions occupy significant space on the server The user can take backup of the ATM trace files at regular intervals and can delete them 45 ORACLE Data Purging 4 2 Data Purging The Purge shell which runs as part of the FLEXCUBE BOD process enables a frequency based data purge from internal host tables that are used by the system for temporary storage In addition to the above daily purge process financial and non financial data needs to be purged at specific frequency The purge for financial tables like ch_acct_ledg gl_txnhist etc can be set up such that it is aligned with the financial year end of the bank Before running the purge process a database backup would be taken which can be retained and retrieved for any future reference to the purged data 4 2 1 Host Tables Purging During the batch processing there is a shell called as purge shell which is run as part of BOD processing This process purges data from transaction tables and temporary tables created for report generation based on the pre defined set up in purge control table 4 2 2 Log Files Purging Depending on the logging configuration done in Host the log files need to be purged In case L
22. it builds a reference and pre requisite list which determines the order in which the processes have to be run Once the process is started it may resemble as follows 68 ORACLE Login for EOD Operations EOD Client Screen Process Category Category Status Process Date f Next Process Date 30 11 2007 15 12 2007 Last Refresh Time Fri Nov 21 20 32 45 UTC 0530 2008 Processes Detaits Cutoff Combine Logs Cutoff Epllogue Cutoff Move ATM Tans CO Cutoff Move BROP Txns CO Cutoff Move Event Txns Cutoff Move IB Txns Cutoff Move POS Txns Cutoff Move Prologue Shell Cutoff Move REQST Log Cutoff Move TB Txns Cutoff Move ZENGIN Txns Cutoff Proc ATM Txns Cutoff Proc BROP Tns Cutoff Proc Event Txns Cutoff Proc IB Txns Cutoff Proc POS Txns Cutoff Proc REQST Toons Cutoff Proc SC Txns Cutoff Proc TB Txns Cutoff Proc ZENGIN Txns Cutoff Prologue 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 Fig 28 EOD Client Screen The block next to the Process Name field indicates the status of the process in addition to the Status field which it displays as STARTED Also the duration for which the process is running is displayed The time till which the process is not completed the auto refresh will update the individual process status and duration of the process run in this category Once the process is over the screen will be refr
23. process is aborted and if all the remaining processes depend on this process the EOD will stop Sometimes this will not lead to the stopping of the entire EOD Processes which are independent of the aborted process will continue The operator will have to look in the status log to check for the error that has occurred Some of the reasons for which a process may abort are e Setup error e System error e The operating system resources such as shared resources and memory or disk space are exhausted e Database error e Application error e Incorrect or Inconsistent Data To view the log file please refer to the Troubleshooting section Based on the error reported in the status log corrective action will have to be taken Once the action has been taken it is possible to restart the aborted process es by pressing the F2 key without waiting for the remaining processes to finish All processes have restart logic built into them For example the CASA EOD has aborted in the middle of the processing it will restart from the point where it stopped and not from the beginning If all the processes are in the completed state or stopped the operator will have to restart the EOD In such a case the system will start only those processes which were not completed in the previous run Also the system will display the message This is not a Fresh Start on the screen BOD as a process category depends on EOD This means that if the EOD is not com
24. status after the refresh poll time interval e Once the process is over the message box Category successfully completed will appear e Clear this box using the space bar or by clicking on the Ok button After this press the Close button Note Once this is done the operator 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 C Take POSTEOD backup for that process date FCC Note Please ensure that the post eofi backup for Flexcube corporate and post EOD backup for Flexcube retail are taken at the same time So even if one process is over do not start the backup unless the other system has reached the stage for backup 75 ORACLE Normal Processing Day End of Day Activities e Transactions Posting e Interest Processing e Service Charges change of cycle depending on the e Capitalisation frequency e Interest Rate Changes e Sweep Out transactions e Account and customer Dormancy e Account classification e Reports Generation e GL Handoff to FLEXCUBE Corporate e Account status change e Account provisioning 76 ORACLE Normal Processing Day 4 6 3 Beginning of day BOD processing Note The BOD Category Should Be Run As Soon As The Post EOD Backup Has Been Completed A Chec
25. status for a particular download Request ID is a unique ID generated when the download starts To view the download status Open the Download Upload Status Inquiry Fast Path 5504 option The Download Upload Status Inquiry screen is displayed 27 ORACLE Data Downloads Download Upload Status Inquiry Request ID D324FDO00 ADC8 4410 BEA8 2B5D1 1031357 Fig 6 Download Upload Status Inquiry Screen e Type the request ID in the Request ID field e Click the Status button Full Download Full download deletes all existing records and the new records are inserted in the table The procedure for a Full Automatic download is same as Incremental Automatic download except for a full download the Delete Old Record check box is selected 3 5 2 Manual Download Manual download can be used to download data in adhoc mode In case of manual download the user uses download service to download data at a particular time There are two types of Manual downloads 28 ORACLE Data Downloads Incremental Download Incremental download downloads only the records which are added or updated after the sync point This sync point is defined in the XML TBL file for a particular table In the incremental download it will check for the latest records and download only the new records Manual Incremental download is similar to Automatic Incremental download except a Manual download has to be triggered by a user Full Download Full
26. the day The basic order of activities is as listed below The order of the transactions need not be strictly followed and the same can be modified to suit the bank workflow e TC Balancing Fast Path 6203 If the teller is authorised to deal in foreign currency TC s the teller can balance the TC s in his custody at the start of the day to ensure that the physical TC count matches the system count e Buy Cash from Vault Fast Path 9007 The teller would be required to buy cash if the entire cash has been returned to the vault at the end of the previous business day Alternatively the teller can retain a certain amount of cash in his cash till which is equal to or less than the teller limit e The teller can also buy sell cash from the vault anytime through the day whenever the teller cash falls below above the drawer lower limit e Buy TCs from Vault Fast Path 9017 If the teller is authorized to deal in foreign currency TC s he can buy sell the TC s from the vault according to his requirement e General transactions 15 ORACLE Branch Operations After completion of the activities mentioned above the tellers can proceed with their respective operations like e Cash Withdrawals Withdrawal slips and Cheque withdrawals e Cash Deposits e Cheque Deposits e CASA related operations e Remittance transactions like issuance of Bankers Cheques Demand Drafts and Telegraphic Transfers e Term deposit related opera
27. used at a particular site In such a scenario the related brief operations pertaining to FLEXCUBE Corporate should be disregarded As this manual refers to operations pertaining to FLEXCUBE Core Banking the operations in other systems such as FLEXCUBE Corporate would not be mentioned in detail 8 ORACLE Audience 2 2 Audience The audience of this manual would be e Branch personnel who are responsible for operations on branch server e Data center personnel who are responsible for operations on Application and Database server e EOD EOM and batch operators 9 ORACLE Overview 2 3 Overview The first task of the day for the System Operator is to prepare the bank for the day s operation This Beginning of Day BOD operation is carried out by the System Operator at the Host server Next the designated supervisor at the branch carries out the Branch batch opening This opens the branch for transactions Then the vault operator opens the Vault batch for currency vault operations and the teller opens the Teller Batch for the teller counter transactions The teller then gets cash for transactions from the Cash Officer using the Buy Cash from Vault option The designated Supervisor checks transactions executed in EOD BOD viz Standing Instructions Sweepin Sweepout Maturity Processing and Interest compounding payout using the EOD BOD Reports After all the above basic operations the bank begins transactions for the day The transa
28. which has to be run for that process or system date in FLEXCUBE Retail The other details are automatically populated There is also a drop down list of the various categories that can be run from FLEXCUBE Retail It can be best explained with an example For e g Suppose the process category cutoff has to be run for 28th Nov 2004 Once the console is obtained the operator just has to press the Down Arrow next to the Process Category field and select Cutoff from the options available as follows 63 ORACLE EOD Client Screen Login for EOD Operations Process Category X Process Date Category Status Next Process Date Fig 27 EOD Client Screen FLEXCUBE Process Categories Eligibility Shell The eligibility shell is related with RVT Relationship Value Tagging Eligibility criteria can be defined under the tag of an Eligibility Plan in the Relationship Pricing Project This Plan determines which set of customers will get benefits defined under a scheme and thus helps identify the target customers for a scheme The benefits available under a scheme can be reduction in Service Charges or positive variance in Credit Interest Rates 64 ORACLE Category Name Cut off Processing End of Day EOD Processing Beginning of Day BOD Processing Process CIF Handoff Schedule Extracts MONTHLY STATEMENTS Handoff After EOD Login for EOD Operations 3 1 2 Cut o
29. 6 A Processes Details Proreindaits Aborted 01 07 15 Prerequisite Aborted 01 07 15 Prevequisite Aborted 01 07 15 Prerequste Aborted 01 07 15 Prerequisite Aborted 11 12 30 Complete 00 00 00 Aborted 11 12 30 Prerequisite Aborted 01 07 15 Prevequiske Aborted 01 07 15 Joi o7 15 369 07 23 01 07 15 11 12 30 01 07 15 BA Reports Branch Account Xfer Branch Acct Xfer Epilogue Branch Acct Xfer Prologue 00 00 00 01 07 15 00 00 00 11 12 30 01 07 15 00 00 00 00 00 09 01 07 15 01 07 15 00 00 00 01 07 15 11 12 30 00 00 00 01 07 15 Sav Transaction Posting Epilogue 2 i fonaa Savings Daily Accrual Handoff 01 07 15 ee cmene ooon manae eroy onvaoea QPS S SBS SS SSS SSS esr Rs Fig 31 EOD Client Screen This indicates that the process that has been aborted has to be corrected or looked into by the support personnel and the category has to be restarted after the problem has been resolved Once the category is completely run and all the processes have run the message Category successfully completed is displayed 72 ORACLE Login for EOD Operations 4 5 6 Exception Processing Once an EOD category is started it will continue till one of the following conditions occurs e All the processes of that category are completed successfully e Some of the processes are aborted In case some
30. A accounts 49 Recommended Purge Frequency Monthly Data Purging Recommended Purge Handling Months In the third year the transaction entries that are printed by the system of two years earlier than today s posting date are purged For e g If Bank has data for 2000 2001 amp 2002 starting from 15th June 2000 Then on 15th June 2002 all transactions belonging to the period 15th June 2000 to 14th June 2001 are purged by the system For the transactions that are yet not printed by the system and that are to be purged will be converted in to one entry after the consolidation In the second year the transaction entries earlier than one year from today s posting date are purged Records are purged on the value date of check from this table ORACLE Table Name st_float_extension td_acct_ledg td_int_payment_history td_renewal_history xf_ol_st_chq_deposits Recommended Purge Frequency Purpose Stores the details of float extensions performed The data from this table is primarily used for report generation Ledger of transactions on TD accounts Stores interest payment history for TD accounts Stores the log of automatic on line renewal done for TD accounts Stores details of cheque details 50 Data Purging Recommended Purge Handling Months The records pertaining to float extensions done seven days earlier than today
31. Bank Master Maintenance and Bank Calendar Maintenance 3 1 1 Bank Master Maintenance The user can maintain the general information of the bank operating FLEXCUBEusing Bank Master Maintenance The Bank Master is a single record table set up at installation A user cannot add or delete data in it The Bank Master contains all the bank level parameters such as the bank code module wise processing date next process date local currency of the bank suspense GL and Inter Branch IB GL codes that are used by all branches and modules It also enables the bank to maintain the name and address of the Head Office along with separate process date for each of the modules The various GLs such as the suspense GL Inter branch GL With Holding Tax GL Cash Overage Cash Shortage Bank Cash GL and Branch Vault GL can also be specified in this maintenance 12 ORACLE Bank Maintenance ORACLE Branch Operations 3 2 Branch Operations 3 2 1 Branch Server Start Operations The activities mentioned in this section constitute the Beginning of Day operations for the Branch Systems The Branch system administrator can perform these tasks From a FLEXCUBE perspective the following services should be running on the branch server for effective operations co eee Order of Start Description Purpose of Service Web Service for publishing the branch URL Branch Server Start Operations Screen uy Application Layer G Provides S Manual
32. CLE Security Management System Related Activities 3 8 Security Management System Related Activities 3 8 1 Transferring Users from One Branch to Another An existing user belonging to one branch can be transferred to the other branch of the bank That user has to be modified in the user profile maintenance using the modify option The cost center i e the branch to which the existing user has been transferred will have to select from the available pick list which is the listing of the branches of the bank The User Profile Maintenance Fast Path SMMO02 option should be used for transferring users from one branch to another User Profile Maintenance Screen User Profile Maintenance UserId fooc User Code Modify User Details OnLine Branch database only User Details Branch Template Details Host Template Details User Name First teller Employee ID 11111 ri Access Domain Code 123 J amp J Language Code Cost Center HO Host Template E G Branch Template 4s ba Primary Passwor d ZE Password Reset Flag Passwor d Chg Flg Email Id AAGFF Previous Passwor dcount gt Profile Start Date EEE Profile End Date 01 01 2049 A Vacation Start Date so04 2008 E Vacation End Date 30 04 2008 EE Organization Code oot n Division Code oo1 ka Department Code oor _ ea TI B Current Status ENABLE v Permanent tly Disabled Record Details seve By Authorized By Las
33. Day A complete list of the execution steps that the operator has to perform for the End of Day operations is Note In case any sub processes in the categories mentioned below abort then please follow the instructions in the section Process abort procedures mentioned at the end of the document 4 9 1 Eligibility Shell Overview The eligibility shell is related with RVT Eligibility criteria can be defined under the tag of an Eligibility Plan in the Relationship Pricing Project This plan determines the set of customers who will get benefits defined under a scheme and thus helps identify the target customers for a scheme The benefits available under a scheme can be reduction in service charges or positive variance in credit interest rates In addition customers who will be excluded from getting the benefits defined under the scheme can also be set up as an Exclusion Plan Once the Eligbility plans are defined they can be linked to various schemes for the eligible customers as per the eligibility plans To link the schemes to customers eligibility needs to be evaluated first Eligibility plans are stand alone entities and can be evaluated at any time of the day The following will be executed in the eligibility shell e List out all plans from rp_elig_plan_mast which need to be evaluated and pick up eligibility plans based on the active flag the maintenance status and eligibility frequency e Pull out the exclusion plan
34. E E ues 25 2o Bala ITER cacsaceas se aawoseecascavadelategnessecuei ce aieusnccotaees ccalemecie data ylomecspaedase iemeeeeeam tee alee 26 a Fed nL ON FEC a A E ne waa cect dt E ten 26 res NNA DONO lt aaceas itachi sci ieguedetn E 28 a GEFU File UPO ienie te cccbsaden bs euleaneensacuas acpigsuemoada te wesseabivamawaemcatiaaneenie 31 okup ETOO a N 34 Romei e Ila AE E A A E A E A E E aete ae 36 RO an N 37 SF e a E E T 39 Bite 1 Release Area MaimtenaritO isi csscccctsisetceveuddecatenver ces sastecetsivercediadeecosineraatimercctenereatinnd 39 3ra Banh Serner MaihtenangE sirsa anasa aiaa aa 39 3 8 Security Management System Related Activities ccccccseeeecseeeeeeeneeeessaeeeesenaeeeeseaas 40 3 8 1 Transferring Users from One Branch to Another cccccceeseeeeececeeeeeeeaeeeeeeeeneeeeeaes 40 39 2 Logging Out orf User ID canissa a a aiaia 40 Bad Enable Disable of user ID sisarta a aaa a Eae 42 DOA ANOO ROPO siaaa a aG a Ea 42 38 5 Dos and Don ts on the Branch Servel isisisi 43 OE E a E E ic ee race eer E ENE E ee E E E A E E E 44 4 1 Database Backups and Reports Backups 1 isccscccncveccsereeconmveninitrcesinventinirentiniventenes 45 khk Dap A E U pean ene er Cee AEA 45 be Rp Ba a E AA 45 A Data PU E EA 46 Ta tb PROST oS F aa A 46 Tee OOTO FUI i na T TLE eT 46 Ae oo RODOS POI eiia AA 46 dh Host OPSION E aiana A TET a pte cat a 55 4 4 Interfacing with FLEXCUBE COmaotatE sinnsirean A TAa 56 4 4 1 BOD Fowo Evene d
35. Fiocow of Events OIF R ela ted Dmoow sn los d Rela ted Loan Account Opening Settlement E OCD T DO ESD Fhaze 27 w Loan EOD haze 2 gt Other non dependent processes Cark Loan EOD AFFRE S amp L gt SL ESDU ploaad aF GL UPI a S amp L Ha na orrf O Se meee Sa ze Genera tion Other non dependent 3S roce z e Reports Reports Ea E OFI E SOrD Date han ze wCark of STI Fig 21 EOD Flow of Events Screen 56 ORACLE Interfacing with FLEXCUBE Corporate Checklist for the EOD operator when there is an interface with the FCC e Closing of all teller vault and branch batches e To authorise unauthorised transactions for all the branches There should not be any pending authorised transaction Mark End of Transaction Input EOTI for all branches FCC EOTI Backup FCR Branch Backup of the branch before running EOD oo Fee FoR FCR Pre Cutoff Backup host from corporate to retail FCR O Run EOTI batches for each branch other than IFPREGL C IFCASAEOD IFGLUPD ACCREVAL and FX Auto revaluation Run Loans Hands off i e IFPREGL for all branches Fec O cick ie Baren eating in Host Saami FOR ww O A Pws dR e SSSSC dR Vake re CASA EOD cone sss ress bench FOO Prane LOO Run Account Revaluation for each branch F
36. OG4J logging is used no purging is required If RAS logging is being used it is recommended to purge the diagnostic trace log file once a week preferably on the Saturday before the host server is brought down In addition the host startup shutdown log files can be purged after taking backup 4 2 3 Reports Purging The EOD reports occupy significant space on the hard disk of the host server In case a separate report server is not being used after taking backup on a DAT or on another machine the reports can be purged from the main host server at monthly intervals Host Data Purge Financial Tables Table Name Purpose Recommended Recommended Purge Purge Frequency Handling Months ba_billing_ details Used in ASP Monthly mode for billing transactions ol_td_aux_table Stores Monthly information of online TD transactions st_clrreg_mmdd Stores details Monthly of cheques sent for clearing ol_sweepin_log_mmdd History of Monthly online sweepins 46 ORACLE Data Purging Table Name Purpose Recommended Recommended Purge Purge Frequency Handling Months xf_ol_ch_ib_req_logs Stores history Monthly of adhoc requests done through NetBanking xf_ol_ch_requestlog_ mmdd Stores history Monthly of adhoc requests statements cheque book etc done across channels xf_ol_st_txnlog_mmdd Stores Monthly transactions from branch xf_stcap_gl_txns_mmdd Stores GL Monthly handoff transactions xf_st_cap_input_txn_te
37. ORACLE Oracle FLEXCUBE Core Banking System Operations User Manual Release 11 5 0 0 0 Part No E52876 01 July 2014 System Operations User 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 dang
38. ORACLE Data Center 4 Data Center 44 ORACLE Database Backups and Reports Backups 4 1 Database Backups and Reports Backups 4 1 1 Database Backup Backups are an essential part of the EOD and BOD processing in FLEXCUBE Retail It is a very important activity which has to be performed as a part of the batch processing activities In FLEXCUBE Retail backups have to be taken at the following stages e PRECUTOFF e POSTEOD e POSTBOD The stage names themselves clearly indicate the stage at which the FLEXCUBE Retail system will be when the backup is taken For PRECUTOFF backup it has to be taken before the operator initiates the cutoff process The POSTEOD backup has to be initiated once the entire End of Day category is over in FLEXCUBE Retail and End of Financial Input or EOF has been marked in FLEXCUBE Corporate This backup has to be taken before starting the Beginning of Day for the next process date The POSTBOD backup has to taken after the operator runs the BOD process It is suggested that the backups follow a naming convention as follows lt FCR gt lt Stagename gt lt Date gt For example Post BOD backup for 20 02 2006 can be named as FCRPOSTBOD20062002 After the backup is over the backups should be moved to the tape drive which can be used later for any data restorations if required Note Once in a while the backups should be restored in the support database to verify for the data consistency Apart
39. Processing Overview Beginning of the Day 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 The days are always business days as specified in Branch Calendars So even if one branch is functioning on a particular day BOD will have to be run for that day e Apart from starting a new day BOD does some processing that typically includes e Time Deposit processing related to interest and maturity e Standing instructions execution e Value date processing of cheques Based on the set up e Salary Processing e Expiry of Overdraft Limits Note The BOD Category should be run as soon as the post EOD backup has been completed Steps for A Check Whether Service is Running e Ensure that the status of on line services is started If one of them or a few are not running then start the services Note If during any of these stages the operator faces a problem then support should be contacted immediately B Start BOD Category e Login into the application using a valid user ID and password e Select EOD Processing from the menu e When the EOD Console is displayed select the process category Beginning of Day from the drop down list Note This date should be the process date for which BOD has to be run If it is the Correct Process Date
40. Recurring Deposit RD accounts e Release of hold funds which have expired the previous day e Resetting of the average daily balance statistics on the e BOD of the New Year e Updating the Unclaimed Status for the instruments e SC package change 77 ORACLE Normal Processing Day 4 6 4 Adhoc processing GENERATE CIFS HANDOFF Note THE Generate CIFS Handoff CATEGORY SHOULD BE RUN AS SOON AS THE POSTBOD BACKUP HAS BEEN COMPLETED A Check Whether Service Is Running e Go to the Web sphere application server Ensure that the status of the following services is started on the Web sphere application server Adhoc Processing screen Install Uninstall Update Export Export DDL Status v 0 M ECBSTI Batch LY FCBST1FileTransfer 4 FCBST1Gefu 4 FCBST Mont 4 FCBST1OK oa T P STS F FCBSTIReports lt If all of these services are not running follow the procedure mentioned under the section Start Services below If one of them or a few are not running then follow the procedure mentioned under the Section Startup of On Line Services If during any of these stages the operator faces a problem then I flex Support should be contacted immediately APPLY CIFS HANDOFF Note the apply cifs handoff category should be run after generate cifs handoff process has been completed 78 ORACLE Other Activities Done During EOD Process
41. ST1Gefu FCBST Mnt m EcBstioty E FCBSTIReports Fig 20 Services Running at Application Server Screen From a FLEXCUBE perspective the following services should be running on the application server for effective operations Service Name Order of Description Purpose of Service Start IBM WAS or Oracle Host Application Server hosting i FLEXCUBE Http Server Sa For providing reports over http server 55 ORACLE Interfacing with FLEXCUBE Corporate 4 4 Interfacing with FLEXCUBE Corporate This section is applicable only for sites where FLEXCUBE Corporate is also installed There are some interdependencies between FLEXCUBE Core Banking and FLEXCUBE Corporate Though the End of Day Month batch operations are commenced simultaneously in both the systems there are some dependencies for commencement of Loans shell in FLEXCUBE Core Banking and GL processing in FLEXCUBE Corporate Regarding the EOD processing the Retail EOD process category contains a sub process called FLEXCUBE Loans Shell When the EOD runs this process keeps on polling till the Allow retail to run flag is marked from FLEXCUBE Corporate module EOD This flag will be marked when the IFPREGL shell is completed for all branches as a part of the corporate module EOD Also the GL upload operation in FLEXCUBE Corporate should be performed only after the EOD process is completed in FLEXCUBE Retail Following is EOD Flow of Events Screen EOD
42. anch Manager Operations Manager opens the branch batch for a particular posting day in FLEXCUBE using the Open Branch Batch Fast Path 6001 option Only after the branch batch has been opened will the vault teller and the other tellers be able to open their respective batches for that posting day In case of split day processing the Operations Incharge or the branch manager can open a branch batch for the next working day At any point in time a maximum of 2 days including the current one can be opened Open Vault Batch The vault custodian should open the vault batch immediately after the branch batch has been opened Execution of the Open Vault Batch Fast Path 9003 option also signifies the opening of the physical cash vault of the branch While opening the vault batch the system prompts the vault custodian to enter the physical count for the vault cash This process also verifies whether the vault cash tallies at the start of the day The related tellers can buy cash for their individual transactions for the day only after this process Open Teller Batch The Teller can start posting transactions for the day after the teller batch has been opened Open Teller Batch Fast Path 9001 option for the day If the teller is a cash teller then the system prompts the teller to enter the physical cash position at the start of the day This also ensures that the physical count matches the system count i e the cash position is tallied at the end of
43. anch table are deleted and the full data is downloaded 30 ORACLE GEFU File Upload 3 6 GEFU File Upload Generic file upload can be used for any bulk transactions like salary credits utility payments inward direct debit inward direct credit etc The GEFU functionality enables the user to define the file format in XML as per the utility requirement It also continues to support the earlier GEFU functions A Global set up is required which will capture the vital details for a specific file like the file format required GL s scheduler details etc Following are the tabs for the External File Setup Fast Path BAM54 option Common Parameters External System Code Casa Account Open JacctOpensystem File Type DETAIL J Processor Type UPLOAD CommonParameti GefuSetup GlSetup GefxSetup Output Template Resp_acct_opening txt_ Deferred Auth Required Relative Path ij AFF Fle Name ap_ext_resp_acct_opel Output File Helper Class Output Folder Helper Class r Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized TsupP2 ssupp2 01 03 2006 00 00 00 Authorize Oa end Authorize O Inquiry ok J close Fig 9 File Upload Setup GEFU 31 ORACLE GL Setup GEFU File Upload External File Setup External Sys
44. ase the cut off EOD BOD process gets aborted A error message is logged in the trace file indicating that there is a table space problem or that the redo log is full Contact the database administrator for the same or call support for help 95 ORACLE Host and Branch Report 5 Host and Branch Report 96 ORACLE Reports 5 1 Reports The reports get generated as part of EOD and BOD processing They are generated depending on the frequency defined for them The reports are first generated in the Reports folder in the FLEXCUBE folder and then finally are moved to the rjsout folder The data is stored with respect to the month with a sub folder for each working day under the month folder The branch reports are generated in lt FLEXCUBE INSTALLATION PATH gt branch brn reports The host reports are generated in lt FLEXCUBE Installation Path gt rjsout lt mm gt lt dd gt where mm is the month of the posting date and dd is the day of posting a dump j File Folder 14 02 2006 1 44 PM EOD O fast_backup_restore O fe 3 O Flexcube O branch a exe E host dat rptdefn Runarea advices reports a Ge risin E O rjsout H G03 aO aA aO 06 a aO 08 aH a10 O th a C web Fig 39 Report Request Screen The reports can be generated at different frequencies The frequencies are Daily The reports which are of daily frequency are generated daily They can also be viewed from the ap
45. can view the further details of that particular record item To do the upload the screen requires online authorisation from an online Supervisor 34 ORACLE GEFU File Upload Generic External File Upload Details Screen Generic External File Upload Details System Code CB_68 External Stock Media Company File Type s sDividend payment from stock company for Account Input File Name 8C Upload Date f Process Date Batch No 9 No of Records 4 File Size Record Record String Header 20060201 9 Detail 03307031002 588 000101010200602010200602010010100000000050000000000000500 Detail 0100011010000277 00010830220060201C2006020100101000000000S0000000000000500 Footer 0000000010000000000S0000000000001000000000050000 49 A gt gt Back Fig 13 Generic External File Upload Details Screen 35 ORACLE GEFU File Upload Gefu Record Details Screen Gefu Record Details Summary System Code External Stock Media Company File Type Dividend payment from stock company for Account Input File Name BC7 Process Date 01 FEB 2006 Record Details Branch Name HO Branch Account Number 99992010000012 Txn Code 1076 Txn Date 01 02 2006 Dr Cr Debit Value Date 01 02 2006 Amount 300 00 Currency Code USD Full Name Chulawan2 IC2 Customer Address1 98 11 Customer Address2 Flora Ville Park City Customer Address3 Phase 5 City Bangkok State Bangkok Country TH Zip 10530 Reference Numbe
46. ctions include clearing operations customer module transactions CASA RD Term Deposit Loans and GL Clearing Operations such as inward clearing authorizing data entry batches are done with the help of GEFU Upload At the end of the day s transactions a sequence of steps is followed before the bank is closed for the day The first operation is to balance the cash This is done by the teller Next the teller hands over cash to the Cash Officer with the Sell Cash to Vault option Then the teller closes its day s operations through the Close Teller Batch option After this the vault operator closes the vault for the day If for any reason the branch is cut off from host for some time the transactions will be transferred from branch server to host server after the restoration of network The Branch Batch Confirm option will show whether both are in sync Finally the supervisor will close the branch for the day After all the branches are closed a pre cutoff backup is taken Next transactions done after the previous cutoff till current cut off are taken up for processing in the EOD Further transactions posted through TBS POS ATM and INB will be taken up on the next day The System Operator then starts the EOD operation and takes a post EOD backup 10 ORACLE Branch Server 3 Branch Server 11 ORACLE Bank Maintenance 3 1 Bank Maintenance Bank maintenance is a key operation The two important bank maintenance operations are
47. download deletes all existing records and the new records are inserted in the table Use the following steps for a manual full download e The FLEXCUBE download service runs on the branch server It has to be invoked by double clicking the shortcut to download on the branch server The Download icon will appear on the bottom right on the status bar next to the date and time slot e Double click the icon and in the Flexcube Download screen type the appropriate information in the Entity From and To fields e The Flexcube Dowload Screen is displayed Par Download ba_ccy_rates Eney ts Suspend From LO Resume To BRNS Stop Download Fig 7 Flexcube Download Screen e Click the Start button The system checks the entered data and displays the Flexcube Downloadscreen 29 ORACLE Data Downloads Flexcube Download Manual Download Start ba_ccy_rates Entity Suspend From L01 Resume To PPNS Stop Download Fig 8 Flexcube Download Screen Note On the centralized branch server the download service should be running only on one of the branch server e Click the Download button to start the download service If the trace file is viewed it will display the contents of the data extraction and then the successful completion of the download If there is a failure then the error message can be viewed in the trace file By downloading this the existing records in the br
48. e POS Txns Cutoff Move Prologue S A catCompSuccess Category is completed successfully Cutoff Move REQST Log Cutoff Move SC Tans Cutoff Move TB Txns Cutoff Move ZENGIN Txns CO Cutoff Proc ATM Txns CO Cutoff Proc BROP Txns CO Cutoff Proc Event Txns CO EE 100 00 00 11 Cutoff Proc IB Txns co Cutoff Proc POS Tans CO Cutoff Proc REQST Txns CO Fig 30 EOD Client Screen The operator can clear this window by either clicking the Ok button or pressing the Space Bar After this click the Close button on the EOD Console which should take the user back to his Access menu If a particular process does not complete successfully the status is indicated as ABORTED The colour bar indicating the process status is marked Red and the field for Status shows ABORTED which means that the process has stopped running for this processing date After this if there are dependent processes on this process they will be marked on the EOD Console as PREREQ_ABORTED Once the category reaches a stage where the aborted process has to be restarted without which the category will not be completed a messages box will appear as follows 71 ORACLE Login for EOD Operations EOD Client Screen Batch Processing Client Process Category si Category Status ProcessDate 30 11 2007 a Next Process Date 16 13 2007 Last Refresh Time Fi Nov 21 23 59 35 UTC oss0 200
49. ection where FLEXCUBE is installed This area contains all the executable and supporting files All the reports are also generated here This makes the area very critical and should have strict controlling and restraining access The access to this area should be controlled It should not be available to everyone It should be monitored as users can go in that area and modify data which could lead to disastrous effects 4 10 2 Host Maintenance Following are the options which can enhance the productivity at the host server General Checks e Routine check on date and time synchronization on database Application server and branch server e Monitoring the link utilization between Data Center and branches and Data Center and DR site only if applicable Memory Checks e Monitoring memory utilization on the Application server Database Checks e Daily check on invalid objects in the database disabled triggers e Regular check on database like analyze table index rebuild indexes monitoring tables with rapid growth e Setting up the adhoc purging processes to make sure that it does not affect the database performance Server Maintenance e Anti virus schedule set up It helps the user to ensure that scanning does not coincide with the EOD process e Routine space check on the apps server e Checking the disk space on the report server if reports are getting spooled on independent server instead of apps server System Software
50. er settings such as persistence and tuning parameters and HTTP transport settings Specify cache and datasource information for the container Specify settings tor the Dynamic Cache service of this server Specify Logging and Trace settings for this server Configuration for the Message Listener Service This service provides the Message Driven Bean MDB istening process whereby MDB are deployed against ListenerPorts that define the JMS destination to listen upon These Listener Ports are debes d ihis ihis oom idee lowe idl 2 ollie we desde Th eed Meat Fig 34 Configuration Tab Screen Then double click the logging and tracking under Additional Properties as shown below in the screen 92 ORACLE Troubleshooting Additional Properties Screen Adcitional re ee as wel as manage active transaction ___ ___ Also specity Session manager setings such as persistence and turing parameters and HTTP transport setings Loo rbecrtne rh nC oi oo Configuration forthe Message Listener Service This service provides the Message Driven Bean MDB isteniny process whereby MOBS are deployed against ListenerPovts that define the JMS destination to Isten upon These Listener Ports are defined within this service along wth settings forts Thread Pool Fig 35 Additional Properties Screen The trace file name and its associated path will be displayed when the user selects the Logging and Tracing link 93 ORACLE
51. erous 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 a
52. eshed and will be displayed as follows 69 ORACLE Login for EOD Operations EOD Client Screen Batch Processing Clieni Re PE x Process Category Category Status Process Date 30 11 2007 Next Process Date 15 12 2007 Last Refresh Time Fri Nov 21 22 40 18 UTC 0530 2008 o eee Processes Details RP Eligibility Evaluation Epilogue Shel RP RP Eligbility Evaluation Prologue Shell RP RP Eligibility Evaluation Shell IRP Microsoft Internet Explorer A catCompSuccess Category is completed successfully Cx Fig 29 EOD Client Screen Once the individual process is over the status bar for that process will be like the one above Note The color bar indicating the status has now become grayed and the Status field shows COMPLETE which indicates that the process has run for that day under this process category Once the entire process category is over the window indicating the status of the category appears as follows 70 ORACLE Login for EOD Operations EOD Client Screen Process Category Category Status Process Date 30 11 2007 Next Process Date 15 12 2007 Last Refresh Time Fri Nov 21 22 28 45 UTC 0530 2008 te Processes Detals Cutoff Combine Logs CO C 11007 00 01 21 Cutoff Epilogue co SSD 100 00 00 00 Cutoff Move ATM Txns CO gt Sz 100 Cutoff Move BROP Tans CO Cutoff Move Event Txns CO Cutoff Move IB Txns S Cutoff Mov
53. ess 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 This process is used to generate tax certificate of all the customers of the bank and stored in a spool file The report is generated customer wise with page break and print can be taken whenever required 66 ORACLE Login for EOD Operations 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 CRR status or the DPD 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 Once the process category is selected the other details in the General frame will be populated This can change dependi
54. ff is the process that operator must run at the end of every day before starting the EOD for that day to ensure that all transactions done through the on line delivery channels including branch ATMS POS and Tele banking 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 LO s Beginning of the Day 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 The days are always business days as specified in Branch Calendars So even if one branch is functioning on a particular day BOD will have to be run for that day 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 It is a process to extract specific schedule and to
55. ffiliates 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 System Operations User Manual Table of Contents T PICIACG iisct ict atest mice nied ed nied neice Nikiodsace biediylien na ia 5 2 INMPOQUCUON sues nein nme ncin hein ee he Reimer ei near 7 PA a ae AT PN NE aaa ash waters E aaa bisa DE E bela catalan N 8 Be PUM NM Ss a star dust va dade samuaek saa das dau A sa tasd souuaurhtvolduts mauauyeaouedes eames 9 BE a ssi Sal sara naa a satay cas Sans aed aa Sieh te bea ag sun ase aan ta aes Ooete 10 2 Branch Seen cuinnicincme nindie denied ieee ele rea mein 11 Bs Ui A EEE I E E TE saduuay A E O A E E A TE 12 21 1 Bank Master MAMENANG sc aire Seiad ASxnssee Senta aaa a EES NEEE 12 ERME eA ICE Aer AUG aac anna A E hunt ni A aes abn ala ENTO T 14 3 2 1 Branch Server Stark Operations nenosia ene Ammen een ce reenter Cty errr 14 32A Gaeh ahd TASTE CN AUIS ING arenai tai aaaea baaa AEE A a 15 sec Ern Taes P a aaa a Aaa aia E ER 20 3a L Inward Cleaning batoh Upon rininis a aaia 22 3432 Load Central Bank Floppy File caieiciasesseviecsestsxasesacpiccneessaasstacaiecnecsiiesese view iiia 23 3a Load ihe iar MICR ME siroce henen a ar N E AOE Aiia 24 3 4 Database Backups and Reports BaCU Pe ncsiecccsstceesseniecarsesadudesylecseceitemaseplomeciiidmesvion 25 k DATO 1206 61 1 nna rete Ry eer ner eee ren per tere her eernet 25 ie is Reve Ic cv a E E A
56. h number so generated The system creates a MICR file and generates a file name for the same which requires to be noted down 23 ORACLE Branch Tables Purging 3 3 3 Load the Inward MICR file The Load Inward MICR File Fast Path ST031 option enables the user to complete the inward clearing data file upload process Once the central floppy file is uploaded the system generates a file name which has to be selected from this screen to complete the file upload You can also load data directly for inward clearing of cheques from a flat file using this option The file should be present in the appropriate area and in the correct format Each flat file should have all cheques in the same currency and should be from the same endpoint When the upload from the central bank file upload screens is successful the system generates a file number Note down this file name The file number which was generated will be available as part of the pick list under the file name Load Inward MICR File Screen Load Inward MICR File File Name cf2001999900042 Fig 4 Load Inward MICR File Screen In the MICR Upload screen enter the File Number and the system will generate the host batch number Note down this number for further processing 24 ORACLE Database Backups and Reports Backups 3 4 Database Backups and Reports Backups 3 4 1 Database Backup Backup should be taken on the hard disk and DAT media provided on all the branch
57. have a proper handoff to the interface 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 It is a process to extract specific schedule and to have a proper handoff to the interface 65 ORACLE Login for EOD Operations Elig Evaluation File Handoff Automatic EFS for Converted Loan Mark for Write Off Bulk Tax Certificate It is a process to evaluate the eligibility of the RVT schemes For more information on RVT schemes refer to Relationship Pricing user manual It is a process to extract specific schedule and to have a proper handoff to the interface 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 In this proc
58. ile is rejected the reason for the same will be displayed The file should have matching credits and debits if the format demands else the file will be rejected The related suspense will be generated only if the total details of the file are ok but there are specific exceptions at the account or GL level like account status balance issues incorrect account numbers etc Based on the functionality the financial debits or credits occur online after the successful processing of the file The non financial data files like customer creation or account opening also occur online 3 6 3 Reports After a file is uploaded and if the auto report generation is set up the reports are automatically generated in the reports folder of the FLEXCUBE in the application server Else the adhoc reports can be generated as shown below under File upload reports 37 ORACLE GEFU File Upload Report Request Screen adhoc Reports O Batch Reports Safi Term Customer Security Relationship Limit General atori Loans Billing 5oposit Information Management Settlement Origination Branch Ping Management 9 iNG5 eager Others Bares Loan EOD Reports Loans deviations Report Loans Interest and Arrears Report Loans Daily Exception Reports Loans Advices and Statements Loans NPA Report Loans Daily Transaction Reports Fig 16 Report Request Screen 38 ORACLE Maintenance 3
59. in a comma separated format which can be created and directly kept in the rjsin folder of the Branch Server Before uploading the file ensure that the GEFU service is up and running If it is not start the service as mentioned in the Branch Server Start Operations section of the document under the startup of online services 32 ORACLE FLEXCUBE Retail Services Screen GEFU File Upload Name 7 SRA FCR CIFS Server 1 SRA FCR COMM Server SRA FCR EODController SRA FCR FEPI Server 1 WECR GEFU Server 1 Description Status Started Started Started Startup Type Manual Manual Manual Manual Manual Sy FCR GENOLTP Serv Started Manual Local System SRaFCR HSFTS Server 1 Started Manual Local System By FCR HSSCS Server 1 Started Manual Local System Sa FCR POS Server 1 Manual Local System Sa FCR RIS Server 1 Manual Local System SRA FCR TBS Server 1 Manual Local System By File Replication Allows Files Manual Local System Sy FTP Publishing Service Enables thi Started Automatic Local System By Help and Support Enables He Started Automatic Local System 4 HTTP SSL This servic Started Manual Local System Sa Human Interface D Enables ge Disabled Local System Sy 115 Admin Service Enables thi Started Automatic Local System By IMAPI CD Burning C Manages C Disabled Local System 4 Indexing Service Indexes co Disabled Local System Sa Internet Connectio Provides n Disabled Local
60. ing 4 7 Other Activities Done During EOD Processing When the EOD is in progress the branches can continue doing the online transaction But the users will not be able to do any maintenance as it is not allowed when EOD is in progress If the user tries doing it the system will give an error indicating that the EOD BOD is in progress The ATM POS and Tele banking transactions can be done during the EOD processing 79 ORACLE Pre requisites Required for EOD Processing 4 8 Pre requisites Required for EOD Processing 4 8 1 FLEXCUBE Retail Services The services that are in use for the FLEXCUBE Retail application running on the Application Server are listed below These services start at the same time Controller of all the EOD shells running within the system File transfer Server for the TCP IP communication of files from branch communication server to the host application server Service for handling transactions coming through the GEFU route Supports the various back office maintenances Server for servicing all monetary branch transactions Reports Server for servicing all the advice report requests from the branch FCR ATMS SERVER 1 Server for servicing the ATM related transactions FCR FepiSCS Server 1 Communication service for Front end processing FCR POS Server 1 Server for servicing the POS related transactions FCR FEPI Server 1 Front end processing service for ATM POS transactions 80 ORACLE Pre requis
61. ites Required for EOD Processing 4 8 2 Data Area When the EOD or BOD is in progress the reports are generated in the area called as Reports in the data area in the FLEXCUBE folder It has to be ensured that there is enough space for the reports to be generated In addition the user can also do the routine space check on the Oracle database 4 8 3 Branch Batch Close All the branches should close their respective branch batch for the day Incase there are branches which work 24 X 7 they should also close the branch batch for that day and open the branch batch for the next working day depending on the bank s policy rules and regulations The EOD operator can view the list of branches which have not yet closed the branch batch for the day by using the Branch Batch Status Inquiry Fast Path BAM95 option Branch Batch Status Inquiry Screen Branch Code Branch Status First Previous 1 jfi Next Last 9999 HO 20 05 2008 12 08 12 31 12 2007 BATCH OPEN 9999 HO 20 05 2008 14 28 40 15 12 2007 BATCH CLOSE 9999 HO 14 05 2008 15 17 52 15 12 2007 BATCH OPEN Fig 32 Branch Batch Status Inquiry Screen From the drop down of the Branch Status field on the screen depending on the selected status the details will be listed The latest date will be displayed on the top 81 ORACLE Pre requisites Required for EOD Processing 82 ORACLE Steps for EOD on a Normal Processing Day 4 9 Steps for EOD on a Normal Processing
62. k whether service is running e Ensure that the status of on line services is started If one of them or a few are not running then start the services Note If during any of these stages the operator faces a problem then I flex Support should be contacted immediately B Start BOD category e Login into the application using a valid user id and password e Select EOD Processing from the Menu e When the EOD Console comes up Select the process category Beginning of Day from the drop down list Note This date should be the process date for which BOD has to be run If it is the correct process date then the operator can proceed and run BOD by selecting from the drop down list If the category runs smoothly and gets completed the message box Category completed successfully is displayed After this the user has to clear this box and close the EOD Console Then log out of the application Go to the Application Server and the Services under Control Panel Check whether all the services mentioned below Show status as Started in the Panel If not then start the services C Take POSTBOD backup for that process date Beginning of Day Activities e Time Deposits Interest Processing e Time Deposits Maturity Processing e Time Deposits Unclaimed Deposits Processing e Standing Instructions Execution e Value Date Processing of cheques e Expiry of Overdraft Limits e Maturity processing for
63. l as well as some files that are generated for updating data in other LO s While the processing is specific to each module the typical activities that are performed are e Transactions Posting e Interest Processing e Reports Generation e GL Handoff e Generating files for Inter LO updates e Loans Account opening in batch 85 ORACLE Steps for EOD on a Normal Processing Day Steps for A Checking Whether the Batch Service is Running e Check whether the service Batch shows status as started e lf the service shows the status Started restart the service e lf the service is not running start it B Start EOD Category Login into the application using a valid user ID and password Select EOD Processing from the menu When the EOD Console is displayed select the process category End of Day from the drop down list Click the Start button Note Check the current process date and next process date and ensure that they are correct The processes that should be run will be displayed and the processes will start running automatically The Refresh button can be used to refresh the process status Even if this is not done it has an auto refresh mechanism which will update the status after the refresh poll time interval e Once the process is over the message box Category successfully completed is displayed e Clear this box using the space bar or by clicking the Ok button After this click the Close but
64. mp History of Monthly transactions processed by CASA Loans and TD modules xf_ol_st_txnlog_stl_mmdd Stores details Monthly of transaction details processed by STL EOD st_inward_temp_bkup Stores details Monthly of records processed by Inward Clearing Stores details Monthly of records passed by Inward Clearing 47 ORACLE Data Purging Table Name Purpose Recommended Recommended Purge Purge Frequency Handling Months st_inwtxn_rej_bkup Stores records Daily rejected by Inward Clearing process Stores records Monthly rejected by Inward Clearing process fct_all_fcr_txns_mmdd Stores log of Monthly all transactions on GL accounts ba_cheque_issue Stores the Bi monthly The MC DD TT details of which are MC DD TT issued to the Issued customer and for which issue date is 7 days earlier from today s posting date are purged ch_acct_ledg Ledger for the Monthly The data in transactions on CASA account CASA ledger is accounts retained for the period specified at the product level All records in the ledger which are older than the data retention period specified at the product level from today s posting date are purged 48 ORACLE Table Name ch_nobook st_bp_availed Purpose Stores the transaction details of CASA accounts to print passbook amp statements Stores log of transactions on GL accounts Stores the details of BP availed by CAS
65. n 6 The reports are generated As mentioned above the reports are available branch wise and are generated in the folders with respect to the working dates The report is saved as lt Report ID gt out For e g in the screen below the generated report will be saved as CH118 out Find below the screen on how to view an EOD report Change the process date to view a backdated report 98 ORACLE Reports Report Request adhoc Reports O Batch Reports Security be Billing LET Sustomer Settlement Origination Brandl ous oeut ates Deposit Information Management Pi Box Loan EOD Reports Loans deviations Report Loans Advices an d Statements Losns NPA Report Loans Daily Transaction Reports ok _ _cancet_ The other option is the required EOD reports are transferred to respective branches by using FTP In such cases the branches generate the reports and take the printouts at the respective branches Adhoc Reports If there are some important reports which have to be generated before EOD the operator can generate the required report by using the Adhoc option of the report generation and save the report The procedure to generate a adhoc report is 1 Open the Report Request Fast Path 7775 option In the Report Request screen click the Adhoc Reports button Select the group from the Report Group section Type the date in the Process Date DD MM YYYY field
66. ng on the status of the category If the entire category is complete the status will be displayed as Completed or if the category has aborted or fallen over the status is Aborted Note Whenever any process category is chosen before the category is started the operator must look at the process and next process date and confirm that these are the current and next working dates of the bank After the dates have been confirmed the process category can be started by clicking the Start button As soon as this is done the processing will begin and control will be taken over by the EOD Console The first event to take place is that the Status frame will be enabled and the list of processes within that category or the jobs in that category will be thrown up on the console Once this is done the initiation of the different processes will be controlled by the EOD Service that will be running on the Application Server for FLEXCUBE Retail and will not involve any intervention by the user in the sense of selection of processes and running them individually 67 ORACLE Login for EOD Operations 4 5 4 Other Buttons on the EOD Console There are two more buttons at the bottom right hand corner of the console next to the Start button These are Refresh and Close button Refresh Button The Refresh button can be used by the operator to get the latest status of the various processes running for a particular category Alternatively the s
67. nin iind ain aeaa a N aana aa 80 e E got ey E E E A T reer E E T A E heer nett 81 A93 Branch Baen COSE iaia aaa iiaa aa a a aA anaa ne an nit aana A 81 4 9 Steps for EOD on a Normal Processing Day c cceccceceeeeeeeeeeeeeeeeeeeeseaeeeeaaeseeneeeseeeee 83 dok CSM NL ann anzcuavat dean spun cptamnaieuts a aieonseanasnodaauatena Gunes ake teea ee aeEs 83 ADEA E AINE E E EA A E E teRreneneiaes 84 doa ERG Ol Bae EOD Processi asrnane eSEE 85 4 0 4 Beginning of day BOD Processing sscccesicarsniasescpsireesencsadaceciaiupennesdsarbsiatoosnacvesancoalees 88 410 oaen PRANTL ENA carcass asses cavoateaics sna Tea 90 4 10 1 Preise Area aI MAGS sonsenerennnia 90 R y e OU A VG Dt elt cca sve ese E E E E E unit 90 cir OS O O ea NA 91 411 Pahor Logaing We TAC File cacenaronakienn a 91 DTe FOCO S ATOT I Mince GUS at sna soiiaueteninemnseraantenmial 94 4 11 3 Common Script to Update Non Operator Login Status ccceeeeeeeseeeeeeeteeeeeeees 95 4 11 4 Database Access Problem or Space Problem ccccsesceceeeceeeeeeeeeaeeeeneeeseneeeees 95 s HOSE and Branch ROGGE sassi 96 Bis La RODOS orcarina ae AEEA A E saventeecatcanmmsetenmmenccate 97 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 ht
68. nk Purge Mechanism for Dynamic Tables Branch Table Name Purpose Recommended Recommended Purge Purge Frequency Handling Days retained sm_br_event_log Login Logout Daily information for tellers Stores control Daily information for Teller Supervisor Vault Teller Batch Opening Reopening and closing Log of daily Daily transaction details rec_txnlog_rejects Log of rejected Daily online branch transactions Stores information Daily of local remote authorisation granted in a branch for teller transactions br_document_store Log of all spooled Daily documents br_instr_issued Log of instruments Daily BC DD issued from the branch 20 ORACLE Stores information Daily 120 of tellers cash position with the denomination details Branch Tables Purging Table Name Purpose Recommended Recommended Purge Purge Frequency Handling br_batch_details Log of all batches Daily batch data entry option br_consolidated_cheques Data for Daily consolidated cheque batches inputted in the branch br_consol_chqs_data Data for Daily consolidated cheque batches inputted in the branch Days retained br_inward_chqs_data Data for inward Daily cheque batches inputted in the branch br_outward_chqs_ data Data for outward Daily cheque batches inputted in the branch rjs_ requests Stores log of adhoc Daily report advice requests processed br_salary_details Data for salary Daily Delete
69. o FCBUSAReliMnt gt Service integration Tar m FCBUSARel1Oltp gt FOBUSAReliReports gt FeBtestaspecthint m USGSTR1Batch gt USGSTRIFileUploadEAR 8 r r USGSTR1Gefu x USGSTR1GefuProcessor 8 m USGSTR1Gefuscheduler gt m USGSTRiMnt gt usasTRioute gt Es Fig 23 Enterprise Applications Screen When these services are running the status should be shown with a green arrow Started while if the service is not running then the status is a blank It indicates that the service is not running any more For the EOD BOD processing the most important service Batch is required to be up and running Before starting off cutoff this service should be stopped and started again This is an ideal sequence before starting the batch processing activities of the bank For this the operator has to follow these steps e Goto Applications on the Web server application server e Select the Batch service e If the status for this shows Blank select the check box and then start the service e Once this is completed then the operator can start the EOD Processing 60 ORACLE Login for EOD Operations e Before running any operation under the EOD Processing the operator has to ensure that the service Batch is started using the Services window as follows Note The service to check is the one which has been highlighted in the screen below EOD Services for Retail Application Screen Start
70. omatic download is enabled the system automatically downloads the entity entities at the pre configured time provided the link to the branch server is working at that time In case the link is not working at the time of download the download process creates an output file in a pre designated directory in the FLEXCUBE Application Server The type of Automatic download is defined in the TBL file There are two types of Automatic download Incremental Download Incremental download only downloads the records which are added or updated after the sync point This sync point is defined in the XML TBL file for a particular table In the incremental download it will check for the latest records and download only the new records Use the following steps for a automatic incremental download e Open the Download Service Fast Path 8892 option e The Download Service screen is displayed 26 ORACLE Data Downloads Download Service Entity From L01 Delete Old Record T To Path Start _ DownLoad Load File Stop Cancel Fig 5 Download Service Screen Type the appropriate information in the Entity From and To fields Clear the Delete Old Record check box Select the path in the Path field using the Browse button Click the Start button The system checks the entered data Click the Download button A request ID is generated This ID should be noted down The Request ID is used to enquire the download
71. or FOr dens ituenissir eA AS a NEA SAA E 58 A5 GIN TOP EOD oer ANN seas snc eats ATA AS NTA 60 4 5 1 Control of EOD Services for Retail Application ccecceesseeeeneeeeeeeeeeaeeeeaeeeseeeeeees 60 45 2 Bringing Up the Operator Wt sca iss cteiecauerengsanmetaiartaesdevens spread aeeetiantend seas 62 4 5 3 Invoking the EOD Console snrnid nonya aeae aaa aaa 62 4 5 4 Other Buttons on the EOD Console cceccccsssceeseceeeeeseaeeeeeaeseeneeseaeeeeaaeseenaeeeeneeeaas 68 4 5 5 Process RUN and Status UpCate u c acisscoscensestuiaserecannaadsuanennnetaceniniaasenncaanrecanne 68 4 5 6 Exception Processing ney eerie ee tee eee rey ene eer tit meri a erent aeaa NEE a 73 4 6 Normal Processing Day scsi ca ctiecs ducts daca unsasuadel eeraa uak kananan aai nEaN aaa 74 BEM AMAT processing anaana aa aaa iR aaa aa E aE aaa E ARA aaa G 74 ORACLE System Operations User Manual 4 6 2 End of day EOD processing oi sis ce cs suites ucicadeies innoirea nia aaen a a aaa aaa 75 4 6 3 Beginning of day BOD processing cc ccccsceesceceeeeeeeeeeeeaaeeeeneeceaeeeeaaeseenaeeseeeeeaas 77 4GA AdoC Process eee eee ie eer eet te meen eet een rena erent ty ere nearer eer aE 78 4 7 Other Activities Done During EOD Processing ccccccceeeeeeeeeeeeeeeseeeeeseaeeesaeeteaeeseeeeees 79 4 8 Pre requisites Required for EOD Processing ccsccceceeeeeeeeeeeeeeeeeeeeseaeeeeaaesteneeseeeeees 80 4 6 1 FLEXCUBE Retail Ser viGeS anne
72. pleted for a day system will not allow the BOD for the next day to start A successful completion of the EOD sets the processing date to the next working day 73 ORACLE Normal Processing Day 4 6 Normal Processing Day Normal processing day includes the following Cut off processing End of day EOD processing Beginning of day BOD processing Adhoc processing 4 6 1 Cut off processing A Take pre cutoff backup for that process date B Checking whether the service is running Check whether the service Batch shows status as Started If the service shows the status Started just stop the service and start it again If the service is not running then simply start it C Starting with the category Login into the application using a valid user id and password Select EOD Processing from the Menu When the EOD Console comes up Select the process category CUTOFF from the drop down list Check the current process date and next process date and ensure that they are correct Click on the Start button The processes that should be run will be displayed and the processes will start running automatically The Refresh button can be used to refresh the process status Even if this is not done it has an auto refresh mechanism which will update the status after the refresh poll time interval Once the process is over the message box Category successfully completed will appear Clea
73. plication and are generated for the respective branches The operator can view reports for any branch by selecting it from the head office whereas only individual reports can be viewed from the respective branches 97 ORACLE Reports Monthly The reports which are of monthly frequency are generated on the month end These are the additional reports which are generated along with the daily reports The reports can also be viewed from the application The reports are generated for the respective branches The operator can view reports for any branch by selecting it from the head office whereas only individual reports can be viewed from the respective branches Half Yearly and Yearly The reports which are of half yearly and yearly frequency are generated on half yearly month end and financial year end respectively These are additional reports which are generated along with the daily reports The reports can also be viewed from the application The reports are generated for the respective branches The operator can view reports for any branch by selecting it from the head office whereas only individual reports can be viewed from the respective branches The procedure to generate a EOD report 1 Open the Report Request Fast Path 7775 option 2 Inthe Report Request screen click the Batch Reports button 3 Select the group from the Report Group section 4 Type the date in the Process Date DD MM YYYY field 5 Click the View butto
74. r 123456789012345678901234567890123456789 Transaction Desciption UTILITY COMPANY UPLOAD Future Dated No Fig 14 Gefu Record Details Screen 3 6 2 Inquiry After the online authorisation if the GEFU service is started the file is processed After the processing the operator can inquire on the status of the file in the File Upload Inquiry GEFU Fast Path BAM96 option 36 ORACLE GEFU File Upload File Upload Inquiry GEFU Screen File Upload Inquiry GEFU External System Code AC u Address Change File Type rFilel Ss User Id TOs IG Status an x Upload Date 01 01 1800 ES Process Date 01 01 1800 agod Branch Code HO File Name j File List 06 05 2008 4 96 05 2008 06 05 2008 ALOGAT 3999 tqs030511007incorrectaccount stxet TDOcs anas inanar a o g Test FAILED UPL 06 05 2008 06 05 2008 06 05 2008 2339 D i 2 2 a pl EAILED UPL SARRE DSROO1 2 tut arit A ppr Ln a or a o o 1 Upload FAILED UPL CL i Fig 15 External File Processing Upload File Status Inquiry Screen The details and the status of the file can be selected by the File Name which is case sensitive the Status Processed unprocessed all the Branch Code from which the file was uploaded Upload Date and the User Id fields The processing of the file is done and the status of success and failure along with the reasons will be given If the f
75. r this box using the space bar or by clicking on the Ok button After this press the Close button After the Cutoff process is over exit out of the menu and before starting End of Day login afresh into the system During OLTP CUT OFF Change of business day Close current logs and Initiate a new log file System not available Typically less than few minutes 74 ORACLE Normal Processing Day During ATM CUT OFF e Change of business day for ATM network e ATM available only in off line mode EOD can start after last cut off ATM and OLTP is done 4 6 2 End of day EOD processing A Checking whether the batch service is running e Check whether the service Batch shows status as started e lf the service shows the status Started Stop it and Start it again e f the service is not running then Start it again B Start EOD category e Login into the application using a valid user id and password e Select EOD Processing from the Menu e When the EOD Console comes up Select the process category End of Day from the drop down list Note Check the current process date and next process date and ensure that they are correct e Click on the Start button The processes that should be run will be displayed and the processes will start running automatically The Refresh button can be used to refresh the process status Even if this is not done it has an auto refresh mechanism which will update the
76. r_ext_hoff Stores details of files uploaded through GEFU ol_bots_bcl Stores log of Branch Batch status for each posting date ol_batch_info Stores log of Branch Batch status for each posting date mu_unauth_logtable Stores details of unauthorised maintenances rjs_requests Stores log of adhoc report requested by the branch Stores the activity of maintenances xf_cap_cifs handoff_temp Stores history of balance change of accounts 53 ORACLE Table Name ba_download_log ch_stop_chq_hist ch_acct_activate_details_hist Data Purging Recommended Purge Handling Months Recommended Purge Frequency Purpose Stores information about the downloaded tables Details of IC and Voucher Entry batches Monthly Monthly History of Stopped cheques Stores the account activation history The Recommended Purge Handling Days Retained for a particular table can be changed by updating the retention period or frequency in re table For adhoc purges the frequency of running the purge needs to be changed 54 ORACLE Host Operations 4 3 Host Operations Note For more information to start the host server please refer to the Installation Guide A detailed description to install and start the server is provided in the guide Services Running at Application Server Start Stop Install Uninstall Update Export Export DDL E FCBST1 Batch FCBST FileTranster FCB
77. ransactions have been submitted 3 Physical cash has tallied with the system count 4 Entire Excess cash has been transferred to the vault Note The teller should not leave the branch while the teller batch is still open 17 ORACLE Branch Operations Close Teller Batch Fast Path 9005 option needs to be used for closing teller batches for a particular posting date In case the teller does not close batch cannot be contacted or password is not known the password needs to be reset and the teller batch needs to be closed by the System Administrator Batch Status Verification Before the tellers leave for the day the Supervisors should verify if the batches for the respective tellers are closed for the day The supervisor can use the Batch Status Enquiry Fast Path 7017 option to inquire the batch status End of Day Vault Teller Batch Closure The vault custodian should close the vault teller batch at the end of the day after the following has been done 1 All the tellers have closed their respective batches and successfully tallied their cash 2 All transactions have been submitted 3 The physical cash in the vault has tallied with the system count The vault custodian should not leave the branch while the vault teller batch is still open End of Day Branch Batch Closure The Branch Manager Supervisor Operator should ensure that all the branch reports listed below have been printed for the branch at the
78. s of all these eligibility plans their revision frequency is the same as the eligibility plans to which they are attached Select all customers from ci_custmast For each customer check eligibility plan and exclusion plan e f eligibility is true and exclusions is also true the customer will not be marked as eligible for the benefits e f eligibility is true and exclusions is false the customer will be marked as eligible for the benefits Steps for running the category Steps for A Checking whether the service is running e Check whether the service Batch shows status as Started e If the service shows the status Started restart the service e f the service is not running then start it 83 ORACLE Steps for EOD on a Normal Processing Day B Starting with the category e Login into the application using a valid user id and password e Select EOD Processing from the Menu e When the EOD Console is displayed select the process category Elig from the drop down list e Check the current process date and next process date and ensure that they are correct e Click on the Start button The processes that should be run will be displayed and the processes will start running automatically The Refresh button can be used to refresh the process status Even if this is not done it has an auto refresh mechanism which will update the status after the refresh poll time interval e Once the process is over the message box
79. servers There should be 6 DATs one for each day of the week Data backup should be taken daily through oracle export dump using fastbackup bat provided to the branches on the hard disk of a designated client machine The same dump should also be taken to the appropriate DAT DAT labeled for that day of the week The media backup should be kept offsite Backup of the branch database schema should be taken every week on Saturday to a separate DAT with appropriate label This ensures that at any point of time branches can have the database schema with all updates till the previous week for restoration in case of need Backups for the successive weeks can be appended to the same tape 3 4 2 Reports Backups Backup of all the reports downloaded from the data center should be taken once in a month to a separate DAT with appropriate label Backups for the successive months can be appended to the same tape 25 ORACLE Data Downloads 3 5 Data Downloads Once an entity is defined in the FLEXCUBE Retail you need to download the entity to the respective branch using the Data Download option The user with specific access rights can download the product There are two different types of downloads e Automatic Download e Manual Download 3 5 1 Automatic Download Automatic download is done using a download scheduler Once the schedule is defined download starts automatically This schedule can later be changed or removed When the aut
80. st Fast Path 7775 option and selecting the relevant report This activity should form a part of the supervisors daily branch operations The daily BOD reports also include important details like the SI success failure the TD maturity processing the OD maturity processing related reports etc Intermediate Cash Balancing and Verification The teller should balance his physical cash with the system count at an intermediate interval e g before going for lunch The teller should also verify at frequent intervals whether he has submitted all the transactions which had been sent for remote authorisation and which have been subsequently authorised 16 ORACLE Branch Operations Closure of Business Day After Business Hours The teller should ensure that all the transactions including batch data entry for the day have been authorised The teller should use the Search Electronic Journal Fast Path 6006 option to verify if there are any authorised transactions which are pending for submission If there are any transactions pending they should be completed by clicking the Submit button To verify whether all the batches have been authorised the teller should use the List Batch Status Fast Path 5515 option If any batches are pending for authorisation then the system will not allow the user to close the batch for the day Before the teller closes his teller batch he should print TP5050 Batch Journal Report and verify the entries
81. t Mnt Date Last Mnt Action Authorized modify Delete O cancel O amend O Authorize O tnquiry Fig 17 User Profile Maintenance Screen After the branch code has been changed to the new branch the download option for the user profile has to be done for both the previous branch as well as the new branch 3 8 2 Logging Out of User ID Using the Modify Login Status Fast Path 755 option the operator can log out the user at the branch level This option is used when the teller has killed his FLEXCUBE session without a formal signoff 40 ORACLE Security Management System Related Activities Modify Login Status Screen Microsoft Internet Explorer EA A User already logged in do you want to log out the user Fig 18 Modify Login Status Screen The pick list will give the listing of the users logged in The operator can select the user and log the user out 41 ORACLE Security Management System Related Activities 3 8 3 Enable Disable of user ID Using the Enable Disable User Fast Path 753 option the operator can enable or disable the user at the branch level Enable Disable User Screen User ID TSHWETA x Siue ENABLE Permanent tly Disable Loggedin fy Fig 19 Enable Disable User Screen 3 8 4 Adhoc Reports Please refer to Host amp Branch Reports section for details on generation of Adhoc Reports Branch Server Shutdown Operations After the branch
82. tem Cade Casa Account Open AcctOpensystem File Type DETAIL Processor Type ri CommonParameters GefuSetup GLSetup GefxSetup Generate Bridge GL Flag Bridge System Cash Debit GL lo Bridge System Cash Credit GL o Internal Transfer Debit GL fo Internal Transfer Credit GL o Balance Bridge Flag Generate InterBranch GL Flag DesignatedBranch X Suspense Debit GL 150130400 m Suspense Credit GL 150130400 pr Record Details Input By Authorized By Last Mnt Date Last Mnt Action Authorized Tsupp2 SSUPP2 01 03 2006 00 00 00 Authorize Fig 10 File Upload Setup GEFU GL Setup The required data can be maintained in an XML file format and the different functions which can be performed through the GEFU file upload can be pre defined Only these functions can be done through the File Upload process The set up is also done if the user requires that the output of this processing should go for another interface or for another processing in FLEXCUBE itself The data which is to be uploaded into the system is entered into the Excel file as per the format mentioned in the file The flat file is generated which will be in the file format required for it to be uploaded in the application The generated file by running the macro in the Excel sheet will have to be kept in the rjsin folder of the Branch server This is as per the earlier GEFU file format Alternately the GEFU also supports the file
83. the system 51 ORACLE Table Name ch_chqbk_issue xf_ol_st_late_clg td_audit_trail td_temp_ren_red Purpose Stores cheque book issuance details for CASA accounts The log of periodic account statements generated by the system Stores details of late cheque marking Stores details of transactions performed on TD accounts Stores information of online TD transactions Host Data Purge Non Financial Tables Table Name Purpose Recommended Purge Frequency Monthly Monthly Yearly Recommended Purge Frequency Data Purging Recommended Purge Handling Months The records of check books that are fully utilized paid and for which cheque book issuance date is earlier than posting date by six months are purged The statement that are generated six months earlier than today s posting date are purged Records pertaining to late clearing markings done one month earlier than today s posting date are purged In the second year the transactions on TD account earlier than two years from today s posting date are purged Recommended Purge Handling Months 52 ORACLE Data Purging Table Name Purpose Recommended Recommended Purge Purge Frequency Handling Months ba_log_cube_txn Stores log of i transactions that happened to and from FCC ba_report_restart Stores details of reports generated during EOD BOD along with the status ba_tmp_
84. tions e Loan related operations EOD and BOD Report Verification The reports pertaining to the branch for previous day s EOD and the same day s BOD are available in a designated area on the host server to a designated area on the branch server The default designated area is lt FLEXCUBE Installation Path gt rjsout lt mm gt lt dd gt where mm month of the posting date and dd day of posting For example reports for 15th June will be available in lt FLEXCUBE Installation Path gt rjsout 06 15 area The default designated area is rjsout area of the application server This default area can be configured during FLEXCUBE installation Then after the day is complete and the next set of reports are generated the earlier reports move into the mmdd folder in the same area For the specific reports to be downloaded to the branches there are three methods They are e Manually transfer the same to the respective branch servers rjsout area and the branches at their end will check the reports e Through the report download utilities external utility and not part of FC can be configured for the download of the reports to the respective branch servers e The reports are kept in an Intranet set up of the Bank and the branches will be authorised to view their reports The supervisors in the branch can refer to these reports and verify the transactions mainly the GL postings for the previous day s transactions using the Report Reque
85. ton 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 C Take POSTEOD Backup for that Process Date FCC Note Please ensure that the post EOFI backup for FLEXCUBE Corporate and post EOD backup for FLEXCUBE Retail are taken at the same time So even if one process is over do not start the backup unless the other system has reached the stage for backup 86 ORACLE End of Day End of Month Activities There is no separate process or category for End of Day or End of Month Depending upon the process date for which the End of Day category is run the system runs certain special categories which fall under the End of Month domain Steps for EOD on a Normal Processing Day The broad set of activities which are undertaken by the system during the End of Day or End of Month are Transactions Posting Interest Processing Service Charges change of cycle Capitalization frequency Interest Rate Changes Sweep Out transactions Account and customer Dormancy Account classification Reports Generation GL Handoff to FLEXCUBE Corporate Account status change Account provisioning 87 ORACLE Steps for EOD on a Normal Processing Day 4 9 4 Beginning of day BOD
86. tor starts End of Day category in FLEXCUBE Retail and he clicks Start then sometimes the error message Non operators logged in Cannot start Category is displayed This may happen when there are other users still logged into the system or when the client side at the workstation has a problem and the login state has not been reset When this problem is encountered the operator has to follow the following steps Double click the Folder sqlplus at the Desktop of the EOD workstation Double click the Retail Live icon which will take the user to the retail database Type D lexsup db upd and press Enter at the prompt The output should say n rows updated where n can be any number greater than 0 If the output is zero then support should be contacted immediately else the operator has to type exit followed by a semi colon and press Enter This will take the user back to the Desktop Once this is done the operator can proceed with the EOD processing in FLEXCUBE Retail 4 11 4 Database Access Problem or Space Problem Sometimes due to network problem the access to the Oracle database is lost There is a message which is logged into the trace file indicating that the system is not able to access the Oracle database Try to ping using the ping IP address command in the command prompt to the Oracle server and if it is not able to access contact the system administrator immediately When there is a space problem in the datab
87. tp 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 User Manual Introduction provides brief information on the overall functionality covered in the User Manual Chapters are dedicated to individual transactions and its details covered in the User Manual 5 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 e Oracle FLEXCUBE Core Banking Licensing Guide 6 ORACLE Introduction 2 Introduction 7 ORACLE Purpose of the Manual 2 1 Purpose of the Manual The purpose of this manual is to provide details into all the operations which would be required to be undertaken at the branch as well as the Data Center level Banks can prepare an exhaustive operations manual using the contents of this manual as the base This manual is not expected to provide an exhaustive checklist of all operations tasks which are required to be done in particular operations Depending upon the configuration of FLEXCUBE it is possible that some operations need not be undertaken or some additional steps would be needed to be undertaken to complete a task For e g FLEXCUBE Corporate as an external system may not be
88. ystem also has an auto refresh feature which automatically updates the status of a particular process after a certain period of time After refreshing the particular process it regularly refreshes the status of the different processes Close Button The Close button is used for closing the EOD Console This can be done in a number of scenarios For example e The process category is completed successfully and the user wants to logout OR e The process category has aborted but the user wants to check some other or invoke another application and can use the Close button to close the EOD Console Note Closing of the EOD Console when a process category has finished or aborted is acceptable When the process is restarted in case of an abort then the status would have changed to Aborted so the operator will know exactly what the status of the category is once the console is brought up or invoked again 4 5 5 Process Run and Status Update When individual processes in a category are run each process goes through various stages The order in which these processes are run is pre defined and will not change unless new processes jobs have to be added to a category The various stages for a particular process that will be displayed in the status window are as follows e COMPLETE e NOT STARTED e STARTED e ABORTED e PREREQ_ABORTED and e PREREQ_ABSENT These are the stages that a process can be in When the category is started

System Operations User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents