EMS Interface User Manual
Contents
1. Media Control System Es media a Status Delivery Type Gen Folder Queue File Prefix Unixin Directoy T C Unix Swift Server Microsoft Message Queue nQueue WebSphere Messaging Specify the following details Node Specify the DB instance name Media Select the media from the adjoining option list The option list displays all the valid media maintained in the system ORACLE Status Select the status The following are the options available e Active e Passive Delivery Type Indicate the Mode of delivery The following are the options available e Folder e Queue In Directory Specify the directory in which the message files are to be placed by external system Only for EMS_IN if delivery type is Folder Out Directory Specify the directory in which the message files are sends to external system Only for EMS OUT In Queue Specify the queue in which the message files are to be placed by external system Only for EMS_IN if Delivery type is Queue Out Queue Specify the queue in which the message files are sends to external system Only for EMS OUT Message Queue Select the queuing software being used in bank 2 2 3 Maintaining Folder Structure Maintain the following folder structure ORACLE 2 2 3 1 Folder Structure for Delivery Mode Folder You should maintain the following folder structure on the Application server machine Ee mail 4 in LH process2. Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_ services Copyright 2012 Oracle 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 Financial Services Software Limited to notify any person of such revision or changes
3. 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 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 lf Handoff fails you will need to trigger it once again ORACLE 3 1 1 Maintaining Account Statement Handoff In Oracle FLEXCUBE you can trigger the account statement generation online System generates one file for each account Account Statement Report Account Selection Type One Account Statement Type Brief Multiple Account Detailed Range Date Range From Date To Date Single Account Account Account Currency Charge Book Date Booking Dated D Show Linked Account Value Date Details Multiple Account Print Options View 10f715 Server Spool C Account Number Currency Print Range From Account Number From Account Currency To Account Number To Account Currency In this screen you can capture the following attributes for generating the account statement Specifying the account number This is a valid account number maintained in the system The branch where the account is held will be display
4. EMS Interface Oracle FLEXCUBE Universal Banking Release 12 0 June 2012 Oracle Part Number E51527 01 ORACLE FINANCIAL SERVICES ORACLE EMS Interface Table of Contents L OE A NN dE BE 1 1 1 1 P TODO O seratacresinsc ve seipave cen atge A R E E eet l 1 be AUDEN e E E E E E E E E E E l 1 1 3 ACRONYMS EE EN E KE 1 1 1 4 RELATED DOCUMENTS ENEE l 1 1 5 EEN l 1 2 THE ORACLE FLEXCUBE EMS INTERFACE scssssessccesecceccecccccococcccccseccecececccosessececcccceceeecoccssessecesecceeee 2 2 Zad ENERO DUCTION RE 2 2 2 1 1 Brief QESCTIP MONO LIVE DIOCESS eebe Eed 2 2 22 MANTAINING GK hn 2 2 Zad M intaining Message EE 2 3 22 2 Message Medid EEN 2 4 PASAS Maintaining Folder TEE 2 5 2 2 4 Specifying Parameters and Values for fcubs properties File 2 6 A MAINTAINING INTERFACE SPECIFIC DETAILS eesscscccscccccccccccccceccccccccccccccccccccocccscccccccccsccececscccsceceee 3 1 3 1 eg OID OC AON e E E E E E E A E A A 3 1 3 1 1 Maintaining Account Statement Houdoft 3 2 ORACLE 1 1 1 2 1 3 1 4 1 5 1 About this Manual Introduction This manual is designed to help acquaint you 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
5. actual exchange of data 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 Acronyms and Abbreviations Unless and otherwise specified it shall always refer to Oracle FLEXCUBE system Related Documents e XML Interface document outlines the details of the interface mechanism between Oracle FLEXCUBE and a system external to it e The Procedure User Manual Glossary of Icons This User Manual may refer to all or some of the following icons a fe Delete row Option List ORACLE 2 The Oracle FLEXCUBE EMS Interface 2 1 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 u
6. ed LH ready LH wip out EH wip O log Ee swift E in LH processed LH ready C wip out Ee wip G log The sub folders for the media MAIL and SWIFT exist under the parent folder EMS 2 2 3 2 Folder Structure for Delivery Mode Queue You should maintain the following folder structure on the Application server machine ems sett Fe out lag Ee wip G log The sub folders for the media SWIFT exist under the parent folder EMS 2 2 4 Specifying Parameters and Values for fcubs properties File You should be specify the following parameter values in fcubs properties file 2 2 4 1 For Delivery Mode Folder EMS_INT_QCF Internal Queue Connection Factory Example EmsQcf EMS OUT JMS DO Out messages dead letter queue Example NOTIFY_QUEUE_DLQ EMS_IN_JMS_DLQ In messages dead letter queue Example NOTIFY_QUEUE_DLQ EMS _FILE_TRANSFER_MODE Mode of file transfer Example FTP etc ORACLE FTP_SRVR FTP Server IP Address Example 169 165 98 11 if file Transfer Mode is ftp FTP_ID FTP Server userld if file Transfer Mode is ftp FTP_PWD FTP Server Password Example 2fo0x66QSug FTP Server Password in encrypt format FILE TYPE file type Example txt xlsx etc SWIFT FORMAT MSG_TERMINATOR MEDIA 2 2 4 2 For Delivery Mode Queue EMS EXT QCF Out Queue Connection Factory External System EMS_INT_QCF Internal Queue Connection Factory Examples EmsQcf EMS OUT JMS DO Out messa
7. ed upon selecting the account Specifying the date range 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 Specifying the account currency This is a valid currency of the account for which the statement needs to be generated ORACLE After the fields have been entered the following screen with the account details will be displayed f Message Details Web Page Dialog tlle fi Reference Number 100001010 Satine DCN CHO2654649 Yersion Number Sender BANK FUTURA HEAD OFFICE BANK FUTURA addr1 BANK FUTURA addr2 BANK FUTURA addr3 STATEMENT OF ACCOUNT FOR 100001010 PERIOD OF STATEMENT 01 NOV 07 30 NOV 07 PAGE COPY AS OF 30 NOV 07 CASH IN HAND DESCRIPTION REFERENCE Date AMOUNT Opening Balance 01 NOV 07 CLOSING CREDIT BALANCE 0 00 AVAILABLE BALANCE 0 00 0 DEBITS 0 00 0 CREDITS 0 00 Remarks Reject Reason Message Trailer Selecting multiple account numbers 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 which the account statement has to be generated ORACLE ORACLE EMS Interface June 2012 Version 12 0 Oracle Corporation World Headquarters 500 Oracle Parkway
8. g Message Media 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 The below given screen displays Media Maintenance MediaCode sd Media Number sd Description Message Suffix C Message Terminator Gemeen Number of Characters Media Priority Test Word Required C Stop Processing C Padding Required Compatible Media z a Compatible Media Specify the following details Media Code Specify the media used for message propagation For instance SWIFT MAIL etc Media Description Describe the media code Message Suffix Specify the suffix to be added in the message Message Terminator Specify the terminator to be used for terminating the message ORACLE Number of Characters Specify the total length of the message Media Priority Specify the media priority Based on the priority the messages are processed with the media concerned Padding Required Check this option if padding is required Padding letters will be added at the end of each message 2 2 2 Message Media Control 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 The below given screen displays Media Control Systems Heger I
9. ges dead letter queue Examples NOTIFY QUEUE DO EMG IN JMS DO in messages dead letter queue Examples NOTIFY QUEUE DO EMS_INIT CTX FACT Application server context factory class in which server external queue create examples weblogic jndi WLInitialContextFactory EMS PRVDR_URL Application server ip address in which server external queue create example weblogic server t3 127 0 0 1 7001 EMS QUEUE PRINCIPAL Application server User Id in which external queue create EMS QUEUE CREDENTIALS Application server Password in which external queue create EMS EILE TRANSFER _MODE Mode of file transfer Examples FTP etc FTP_SRVR FTP Server IP Address Examples 169 165 98 11 if file Transfer Mode is ftp ORACLE FIR ID FTP Server userld if file Transfer Mode is ftp FTP_PWD FTP Server Password Examples 2fo0x66QSug FTP Server Password in encrypt format FILE TYPE file type examples txt xlsx etc MSG_DELIMITER YES MSG_TERMINATOR YES MEDIA SWIFT ORACLE 3 1 3 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 document outlines the specifications of the interface between Oracle FLEXCUBE and the external systems The interface handles
10. p 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 2 1 1 Brief description of the process 2 1 1 1 For incoming messages For the delivery modes NT and FTP The message 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 2 1 1 2 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 2 2 Maintaining EMS Details The following maintenances are required for the EMS e Message Media Maintenance e Message Media Control Maintenance ORACLE 2 2 1 e Maintaining Folder structure e Specifying Parameters and Values Maintainin
Download Pdf Manuals
Related Search