[January] [2010] Oracle Part Number E51573-01
Contents
1. 1 3 1 1 Local system folder structure You should maintain the following folder structure on the local Windows machine 1 2 ORACLE The sub folders for the media MAIL and SWIFT exist under the parent folder EMS FTP In the UNIX box create a folder with two sub folders named IN and OUT In the IN folder create two sub folders READY and FINAL QUEUE Create four queues named according to the following convention e In Queue Name Queue Name e Backup Queue Name Queue Name b e Final queue name Queue Name f Example D In Queue Name InQueue Backup Queue Name InQueueb o Final queue name InQueuef 1 3 1 2 Folder having the binaries dll and exe files Create a folder in the local machine for storing all the executable files Copy all the dll files files with the dll extension in their names and exe files from the bin folders of all projects and paste them into the exe folder For example you could have a folder named C emsexes You should also maintain this path in the ini file through the ini file writer 1 3 1 3 INI files Save the ini file in a local machine folder 1 3 2 Configuring EMS NET Configuration details for EMS NET are explained below 1 3 2 1 Maintaining of the ini file You have to maintain the ini file through the ini file writer You can locate the necessary executable in the binaries folder named EMSIniWritter The ini file is a Read Only file Y2. Control Panel e Inthe Control Panel browser double click on Administrative Tools e Inthe Administrative Tools browser double click the Services icon e Inthe Windows services console that opens up right click on the service that you wish to Start The name of the In service is EMSInSrv and the name of the Out service is EMSOutSrv In the side menu that opens up click on Properties e Inthe dialog form that opens up navigate to the tab General In Start Parameters enter the ini file path e Click on the Start button 1 4 2 Stopping the EMS NET In service and Out service For stopping EMS NET service you need to perform the following actions 1 8 ORACLE 1 4 3 e Follow the navigation path Start Menu gt Settings gt Control Panel e Inthe Control panel browser double click on Administrative Tools e Inthe Administrative Tools browser double click on the Services icon e Right click on the particular service name in the services console e Inthe side menu that opens click on Properties e Inthe Service Property window click on the Stop button Alternatively you can click on the particular service name in the Services console and click on the Stop button in the main menu screen in the Services console Finding debug files The debug files are created in the debug path that you specify in the ini file The name of the In service debug file is EMS txt Debug files are generated in append mode The num
3. Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated EMS Interface Version 11 0 INT1316 ORACLE FCUBSV UM 11 0 0 0 0 0 0 January 2010 ORACLE FINANCIAL SERVICES ORACLE Document Control Author Documentation Team Group UBPG DS Created on October 01 2008 Revision No Final MNS Updated by Documentation Team Reviewed by Approved by Software Quality Development Testing teams Assurance Team Updated on January 04 2010 Reviewed on January 04 Approved on January 04 2010 2010 ORACLE EMS Interface Table of Contents LABU TIN MA ND II A aa 1 1 1 1 A GC VON genset ativan np ia satus AU E EEE a A Ai 1 1 1 1 1 A ANN pola A AAA A so wy E way A ee a l 1 1 2 PICTON IIS CG ADD a nn AS E E AAA AAA E A AN 1 1 1 1 3 Pa T A A E A E AA A Aa 1 1 1 1 4 OSS AN E E A E E An a 1 1 2 MAINTAINING INTERFACE SPECIFIC DETAILS ssssssssccccccccsccccccccccccccccccccsccscccccccsccccccssccessessessssecceee 2 1 2 1 MINEO DU O EE nas ain E E E E E N 2 1 2 1 1 Maintaining Account statement handolff se eseseeeceeeeaeeeeseceeeeeaaaeeseeeeeesaaaasseeeeeeeeeuaaasseees 2 1 212 Maintaining the EMS message filter nennen aran a nan ana anna nana aan 2 3 ORACLE 1 About this Manual 1 1 Introduction This manual is designed to help acquaint yo
4. which the account statement has to be generated 2 2 ORACLE 2 1 2 Maintaining the EMS message filter You can maintain the EMS message filter details through the EMS Message Filter screen invoked from the Application Browser ZA EMS Message Filter Ems Message Filter Module OB Ql External System Ems Queue Name BREE_G Ql Swift Message Type fi 30 In this screen you can capture the following attributes for EMS messaging e Module a valid module code maintained in the system e External system the external system is displayed e Queue Name the name of the queue to which the message has to be sent e Swift Message Type the swift code that needs to be sent to the queue specified in the previous field For detailed information on interface between Oracle FLEXCUBE and the relevant clearing networks refer to the Clearing interface user manual 2 3 ORACLE ORACLE EMS Interface January 2010 Version 11 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_ services Copyright 2008 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any languag
5. 2 Stopping the EMS NET In service and Out service ena nana naaa naaa aaa 1 8 1 4 3 TAO GC A A AAA A AA A A A 1 9 2 JAVA ENABLED MESSAGING SYSTEM ccccccssccssscccssccccsccccsscccssccccsccccssccccsccccsscccccccccscccsscccceccseees 2 1 2 1 MO BC A A E AREA AE AET 2 1 2 1 1 Processing for TEMS ne ren aaa ena aaa ena nana nenen a ena nan nana nana aaaaan 2 1 ORACLE 1 1 1 2 1 2 1 1 The Oracle FLEXCUBE EMS NET Interface Introduction The EMS or the Electronic Messaging Service is a messaging interface between external systems and Oracle FLEXCUBE This interface is implemented with the help of two windows services one each for In and Out processing This interface enables a connection to be established between Oracle FLEXCUBE and the external systems network resource for sending and receiving information The in service connects to the external system resource Windows machine UNIX machine or MSMQ server and transfers the data to the local windows machine where the message is processed and uploaded to Oracle FLEXCUBE The out service polls on an Oracle FLEXCUBE out table As soon as a message is generated in the out table it is picked up formatted if required for example as a MS Word document and delivered to the external system through one of the delivery modes FTP MSMQ etc Brief description of the process For incoming messages For the delivery modes NT and FTP The mess
6. EMS NET Interface Version 11 0 INT1316 ORACLE FCUBSV UM 11 0 0 0 0 0 0 January 2010 Oracle Part Number E51573 01 ORACLE FINANCIAL SERVICES ORACLE Document Control Author Documentation Team Group UBPG DS Created on October 01 2008 Revision No Final MNS Updated by Documentation Team Reviewed by Approved by Software Quality Development Testing teams Assurance Team Updated on January 04 2010 Reviewed on January 04 Approved on January 04 2010 2010 ORACLE EMS NET Interface Table of Contents 1 THE ORACLE FLEXCUBE EMS NET INTEREA CE 2 0 2 ccccccccccccccccccccccccccccccccccccccccccccccccccccccsees 1 1 1 1 PARODU ON oar ras ances ents Secs ci nee dence sects neat E de sate A i ace ean see 1 1 1 1 1 Brie daa DENAI A Aa in ali iii 1 1 1 2 INSTALLING AND UNINSTALLING THE EMS NET SERVICES ccccccseccesececscccesecceneceeecseeecceeneeeeeceeeeceees 1 1 Za ln serce and OS CFV esa sta sists ssa adie cas ets AGN Sas wee eA toasts sees acess 1 1 1 3 MAINTENANCES REQUIRED FOR THE INTERFACE cccceseccesecccscecesecceneceesecceescceeneceeecseueceeeceeeneceeeseeeceees 1 2 1 3 1 POMS IN ET SUA GION COCCI AIS nn AAA E a Aan E Ai 1 2 1 3 2 CO NN P AA A vs as ves gos eee E gs ne 1 3 1 4 RECEIVING AND SENDING MESSAGES USING EMS NET ae ee ren ena ena ann nan nana naaa anna 1 8 1 4 1 Starting EMS NET In service and Out service ena ena aa nana naaa naaa 1 8 1 4
7. O Manager Hame m emn o oo WSMO Manager pott rumbes fics WSMO Server Channel Mame fs o WSMO Dua Mecsage Encodng SERVICE PARAMETERS in Serace Delay Out Senne Delay Max DB Record No in Semice Max Thread Court Out Senace Mar Thread Lount 1 3 2 2 Media maintenance and Media Control System maintenance in Oracle FLEXCUBE For this interface you need to maintain certain messaging parameters in Oracle FLEXCUBE Invoke the MCS DETAILED screen for performing maintenances for Media Control Systems 1 6 ORACLE Mes IMCS O Delievery Type Node NODE g Folder S Queue C Media EDA ss Delivery_by DELVERY_BY aj Status status In Dir INDIR Out Dir fOUTDIR File Prefix FILE_PREFIX Unix In Dir UNIK INDR O0 Unix Out Dir JUNIXLOUTDIR In Queue INLQUEVENAME Z Out Queue OUT GUEUENAME Semer IP BERYERIP Pot PORT A If Unix Swift Server MSMO CWSMa C Input By Date ath By Date Time Time Mod He MAKER ID DIA CHECKER_IO CHECKER DT STAMP MODI Open 7 Authorised hl You have to enter the File Prefix that you wish to be prefixed to the filename or message label which is handed off to the external system This enables the System to know the source branch of the file You can specify either SWIFT or MAIL as the medium name Remember you specification in this field has to be in the proper case Specify whether the media for which maintenance is being car
8. age files are to be placed in the EMS SWIFT In Ready in the EMS server The incoming message service In service copies the file to the folder EMS SWIFT IN WIP and performs further processes like formatting etc Once the processes are completed the file is moved to the folder EMS SWIFT IN PROCESSED Though all the folders are maintained in the EMS server they can be mapped to any system For the QUEUE delivery mode The messages are placed by the external system in the in queue They are moved from there to the backup queue and sent for processing Once processing is successful the message is moved to the final queue For outgoing messages For delivery modes NT and FTP The messages are selected from the Oracle FLEXCUBE out table formatted if required and moved to the folder EMS SWIFT OUT WIP From here the file is picked up and moved to EMS SWIFT OUT For the QUEUE delivery mode The messages are sent to the out queue Installing and Uninstalling the EMS NET services Details in regard to installing and uninstalling EMS NET services are explained below In service and Out service You need to perform the set of actions as described below for installing the EMS NET services 1 Open the windows command prompt Go to C WINNT Microsoft NET Framework v1 0 3705 2 Type the following command line Installutil lt path of service exe gt For example for In service your command line can be 1 1 ORACLE 1 3 1 3 1 Installutil
9. ber of debug files created for the In Service depends upon the number of Delivery_by modes maintained for each media The naming convention is EMS_IN_DeliveryModeProcessID log Example If a Delivery by supports Queue the name of the log file will look like EMS IN QUEUE2432 log where 2432 is the process id If a Delivery by supports Folder the name of the log file will look like EMS_IN_NT1756 log where 1756 is the process id A debug file with the name EMSInSrv log containing information about the spawning of these processes is also created The name of the Out service debug file is a combination of EMSOut and the Process ID of the out process spawned 1 9 ORACLE 2 1 2 Java Enabled Messaging System Introduction The Java Enabled Messaging System JEMS that interfaces with the SWIFT Alliance facilitates the processing of messages advices that are received incoming by and transmitted outgoing from Oracle FLEXCUBE Examples of such messages include Credit Advices Debit Advices etc Messages are processed depending on the media maintained for a customer The media may be SWIFT Mail Telex or Fax Data can be transmitted using a File System or the MSMQ MQ Series of queues Processing for JEMS The Java Enabled Messaging System invoked from the Application Browser lets you control the processing of both the incoming and the outgoing messages a Java Enabled Messaging System Background Proce
10. c emsexes EMSInSrv exe For Out service your command line can be Installutil c emsexes EMSOutSrv exe These will install the incoming and outgoing services as Windows services Navigate to Start Menu gt Settings gt Control Panel In the Control panel browser double click on Administrative Tools In the Administrative Tools browser double click on the Services icon In the Windows services console that opens right click on the service that you wish to start The name of the In service is EMSInSrv and the name of the Out service is EMSOutSrv In the side menu that comes click on Properties In the dialog form that opens go to the LogOn tab Enter the NT user name and password and click Apply Before uninstalling the service make sure you stop the service and also that the service console is closed To uninstall the service Open the windows command prompt Go to C WINNT Microsoft NET Framework v1 0 3705 Type the following command line Installutil u lt path of service exe gt For example for In service your command line can be Installutil u c emsexes EMSInSrv exe For Out service your command line can be Installutil u c emsexes EMSOutSrv exe These will uninstall the incoming and outgoing window services Maintenances required for the interface Details of maintenances required for the interface are explained below EMS NET installation check list The check list for EMS NET installation is detailed below
11. cument outlines the specifications of the interface between Oracle FLEXCUBE and the external systems The interface handles hands off data pertaining to the following functions e Account Statement hand off the account statement hand off is performed based on the account statement cycle maintained in the customer account maintenance whereby the details of all account statements are generated Features of the interface The salient features of the interface are as follows e Data is transferred to the external system s through ASCII files in predefined file formats e Data is handed off at the end of the business day as a Batch file to the external system If Handoff fails you will need to trigger it once again Maintaining account statement handoff In Oracle FLEXCUBE you can trigger the account statement generation online System generates one file for each account ZA Account Statement Handoff DETAILED SUMMARY Account Number BNKNOF EUR 123 457 Ql Branch 200 From Date 03 DEC 1998 To Date 03 DEC 1999 ourth Party Details Mame TEST Street HARRIS ROAD PO Box NO 40 City BAN GALORE State Aea In this screen you can capture the following attributes for generating the account statement 2 1 ORACLE Specifying the account number This is a valid account number maintained in the system The branch where the account is held will be displayed upon selecting the account Specifying the date rang
12. e Transfer Protocol FTP In the queue based system the messages are moved to the outgoing queues maintained for the purpose For information on maintaining a queue refer to the section titled Maintaining Queue Details in this document After a message is processed and the hand off is successful the message status gets updated to H Handed off in the table In the case of unsuccessful processing the message status is displayed as R Rejected Incoming Message processing As in the case of the Outgoing process so also Incoming messages received from the SWIFT network alliance are processed using a e File based system or e Queue based system MSMQ MQ If the file based system is used the file consisting of the messages from the SWIFT network are moved to the Ready folder in Oracle FLEXCUBE The messages are then extracted from the file and stored individually in the MSTB DLY MSG IN table 2 2 ORACLE In the queue based system the messages are processed from the incoming queues maintained for the purpose For information on maintaining a queue refer to the section titled Maintaining Queue Details In this document Message Recovery In the event the Incoming process stops abruptly or encounters an error during processing the message details get logged in the Recovery table This ensures that messages are not lost during processing Every time you initiate the Incoming process it will first c
13. e for account statement The From and To date represent the date range for generating the account statement for the account Enter the dates in date month year format Linking a Location Code with an Account Number Account statement can be generated for various locations You can choose the location for which the statement needs to be generated Maintaining multiple locations for the customer facilitates the sending of account statements to more than one address of the customer Indicating the message to be sent to a fourth party You have the option to send the account statement to a fourth party In case you opt for this facility you need to enter the details for the fourth party Indicate the name and address for the party for whom you want to send the account statement You are allowed to enter fourth party details only if you have checked Fourth Party option box If you want to generate account statement for all the accounts of the customer select the Summary option In the Summary screen you can choose the customer for whom you want to generate the account statement summary ZA Account Statement Handoff DETAILED SUMMARY Customer No HO GG01 To Date j03 DEC 1 444 In this section you can capture the following attributes for generating consolidated account statement for the customer having many accounts e Customer Number a valid customer number maintained in the system e To Date the date till
14. e or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes
15. e processing All outgoing messages after being generated in Oracle FLEXCUBE are stored in the MSTB DLY MSG OUT table The status of these messages is G implying that the messages are generated and ready for transmission On initiating the Outgoing process the messages generated in Oracle FLEXCUBE with status G are picked up for processing The process will extract the messages from the MSTB_DLY MSG OUT table in the form of text files and store the message files in the appropriate directories A separate directory is created for each media type and the directory is addressed by the corresponding media name For instance the directory that stores fax messages will be called Fax To recall messages are transmitted via the media that is specified for the customer In case of mail messages the process will check for the e mail address of the customer maintained through the Customer Information Maintenance screen and subsequently sends the text file of the message as an attachment to the concerned customer The messages to be sent via Fax and Telex are stored in their respective directories to be processed manually For processing SWIFT messages depending on the customer s choice you can use a e File based system or e Queue based system MSMQ MQ In the file based system the message is converted to the SWIFT standard and stored in a folder All the files in the folder are then transferred to the SWIFT server via the Fil
16. heck the Recovery table for the presence of unprocessed messages Only after processing the messages in the Recovery table it will proceed to process the messages from the Queue or the SWIFT server as the case may be 2 3 ORACLE ORACLE EMS NET Interface January 2010 Version 11 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial services Copyright 2008 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle
17. ou have to remove this property before you run the EMSIniWritter exe Double click on the Windows form executable EMSIniWritter In this form you can edit the ini file 1 3 ORACLE EMS INI FILE WRITTER Ini Fide Path _ OF In this screen enter the path where the ini file has been saved Press OK to confirm On your confirmation the database connection string data is displayed if the number of database instances that you have entered matches the number of database instances stored in the ini file Otherwise empty text boxes are displayed Click on the NEXT button after editing the data or after entering fresh data EMS INI FILE WRITTER Ind File Path enc OF Comedii Stig Parameters 1 Database indais 1 TEST WORLD DE Usai FLESTUBE MA DG Pasar 1 Ini file data are displayed as shown in the following five figures You can edit the data according to your requirements Click on FINISH after you are done 1 4 ORACLE Mensa Tomma FUP Serea P pimsi FUP Server ssi FCCINT Logo FINISH 1 5 EMS INI FILE WRITTER Mad Server Mame Imai serer Mal Server Port i 6 60rti lt i i SOSCS NT User Id Hiroa i itt NT Pacsword O From Mal Id Iromribankthebank com WEBSPHERE Mi Faris i EAs WSMO Manager Nama OM FLMC WSMO Manager post raibe fics WSMO Server Channel Name cheer WAMO Queue Mestage Encoding lu not ams CE Form EMS INI FILE WRITTER ERS E MUF z WSM
18. ried out is Queue based or File based and if Queue based specify the In Queue and Out Queue You can also specify the queuing software being used in your bank Invoke the screen for performing maintenances relevant to each message medium You can invoke the Message Media Control Maintenance screen by typing MSDMCS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button You can invoke the Message Media Maintenance screen by typing MSDMEDIA in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 1 7 ORACLE 5 Mirviags bodia Micinignanee Wc bpage Dialog You can choose to suppress a particular medium by enabling the Stop Processing option In that case messages supposed to be sent by this medium will not be picked up by the System You can enter select either SWIFT or MAIL as the medium Remember you specification in this field has to be in the proper case For further information on the fields in this screen refer to the chapter Maintaining Media Control System s in the Messaging System User Manual 1 4 Receiving and sending messages using EMS NET Details for receiving and sending messages using EMS NET are explained below 1 4 1 Starting EMS NET In service and Out service For starting EMS NET service you need to perform the following actions e Follow the navigation path Start Menu gt Settings gt
19. ssing Start Incoming Process Stop Outgoing Process Incoming Process Outgoing Process Halted Running Change DB Password Change FTP Password Ir ee Using this interface you can Start or Stop either or both the processes When you initiate a process the status of the Incoming Outgoing process will be displayed as Running A process will continue to pool for messages until you decide to stop the process On stopping a process the status gets displayed as Halted You can click on the Change DB Password Button to capture the user name and the password required to start the JEMS service The password will be encrypted in accordance with the Oracle FLEXCUBE password encryption logic written in the JEMS property file Click on the Change FTP Password Button to capture the UNIX machine user name and the password required to start the JEMS service The UNIX machine password will be encrypted in accordance with the Oracle FLEXCUBE password encryption logic written in the JEMS property file This is required to be done when the delivery type is Folder and the mode being used is FTP 2 1 ORACLE 2 1 1 1 2 1 1 2 The Java Enabled Messaging System is designed to be compatible with IBM s MQSA MQ Series Interface for SWIFT Alliance If for any reason a process Incoming or Outgoing stops abruptly click on Refresh to view the current status of the process Outgoing Messag
20. u with the interface between Oracle FLEXCUBE and the other systems within your bank This manual provides you extensive explanations about the various maintenances required for the smooth exchange of data between Oracle FLEXCUBE and the applicable systems through the interface It also gives you an insight into the processes involved in the actual exchange of data 1 1 1 Audience This manual is intended for the following User User Roles Back office data entry Clerks Input functions for maintenance related to the interface Back office Managers Officers Authorization functions 1 1 2 Acronyms and Abbreviations Unless and otherwise specified it shall always refer to Oracle FLEXCUBE system 1 1 3 Related Documents You can refer to the XML Interface document which outlines the details of the interface mechanism between Oracle FLEXCUBE and a system external to it 1 1 4 Glossary of Icons This User Manual may refer to all or some of the following icons sme i ORACLE Function Refer the Procedures User Manual for further details about the icons 1 2 ORACLE 2 1 2 1 1 2 Maintaining Interface specific Details Introduction Oracle FLEXCUBE is an international universal banking solution catering to the treasury back office functions among other modules The details of all customer account transactions can be handed off to the external systems existing within your bank through an interface This do
Download Pdf Manuals
Related Search