Home

Switch Interface Gateway User Manual

1. 2 4 1 Defining Currency for Currency Code Conversion rrrrrrrnnnnnnnnnnnnrnnrnnnnnnnnrrrnnvnnnnnnnnrnrnrnnnnnneensrnnnnnnn 2 9 2 4 2 ATM Debit Card Mapping for Card Account Number Conversion rrrrrnnnnnnnnnnnnnnnnnnnnnnrnnnvnnnnnnnnnnnne 2 9 2 4 3 Maintaining Channel Details rrnnnnnnnnnnnnvrnnnnnnvvrnnnnnnnnnnnnnnnnrrrrnnnnnvvrnnnnnnnnnsnsnnsnnrsnnsnnnrsrnnnnnnnnnsssssssne 2 10 2 4 4 Maintaining Process Code Mapping Details rrrrrnnnnnnnnnnnnnnvnvnnvnvvvnnnnnnnnnnnnnnnnrrrnnvnnnrrrrnnnnnnnnnsssnsner 2 11 2 4 5 Maintaining Network Details rrrrrrrrrnrrnnnnnnnnrrnnrrnnnnnnrrrrrnrrnnnnnnnrrrnnrnnnnnennnrennnnnnnnenenernnnnnnnnessseennnnnnn 2 12 2 4 6 NNN 2 13 2 4 7 VTM 2 14 2 4 8 Manne Un Provider PICTOU S naresti ANE E ik eau tank ENEA 2 16 2 4 9 Maintaining Product Types for Product Derivation rrrrrrrnnnnrnnrrrnrrnnnnnnnnrrnnrnnnnnnrnrrrnnrnnnnnnnrrrnnnnnnnn 2 16 2 4 10 Showing Amount Block Transactions in Account Statements rrrrrnnnnrnrrrrnrrnnnnnrrnrrnnrrnnnnnrnrrrnnvnnnnnennr 2 18 2 4 11 Modifying a Product Preferences Screen uavmennsgsantdnd sarkasme saa 2 20 2 4 12 Maintaining Charges for Non financial Transactions srrrrrrrnrrnnnnnnnnrvrnrnnnnnnnnnrrnnrnnnnnnnnrrrnnvnnnnneeee 2 20 AGVAN NN 2 22 DOP 2 22 2 5 1 Maintaining Batches for Batch Operations rvrrrrnnnnnnnnnnnnnnnnrnvnnnvvvvnnnnnnnnnnnnnnnnrrrrnrnnnvrrrnnnnnnnnssssssnne 2 23 252 NNN 2 24 250 MD 2 25 2 5 4 VTS 2 27 2
2. Modification Number Authorized By Date Time Authorized Open The ARC maintenance is done for the product Cash Withdrawal CHWL You can maintain charges under charge tabs CHARGE1 5 for both financial and non financial transactions CHARGE1 must be the Transaction Fee The Description under CHARGE1 tab should be given as TXN_FEE CHARGE2 must be the Transaction Processing Fee The Description under the CHARGE tab should be given as TXN PROCESS FEE For more details on ARC Maintenance refer the relevant Oracle FLEXCUBE user manual Batch Processes The following batch processes are part of the Oracle FLEXCUBE Switch Interface For more information on Batch Processes refer the corresponding Oracle FLEXCUBE user manual ORACLE 2 22 2 5 1 Maintaining Batches for Batch Operations You can maintain the following batches for Batch Operations in the Batch EOD Function Inputs screen e SWSWRECN Switch Reconciliation Batch e SWDPRCRT Process Transaction Batch e SWNETSET Network Settlement Batch e SWMERSET Merchant Settlement Batch e SWDPURGE Adhoc Purge Batch e SWDRETBT Retry and Suspense Processing Batch You can invoke the Batch EOD Function Inputs screen by typing BADEODFN in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button E Function Inputs Batch End Of Day Functions Branch Kai Function Id az
3. Register Response Queue Message Id Select this checkbox to register the response queue message Id External System Queues Give the External IN QUEUE and RESPONSE QUEUE for Switch Specifying External System Functions You can specify the external system s functions in the External System Functions Detailed screen Here you can maintain Function ID Action Service name and Operation code for the Switch Interface Gateway External system You can invoke the External System Functions Detailed screen by typing GWDEXFUN in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button External System Functions Detailed f External System Description 3 f Function Action Service Name Operation Code Input By Authorized By Modification Authorized Date Time Date Time Number Open Exit External System Select the External system FLEXSWITCH from the list of options available Function Select the Function id from list Once you have entered the above details the following fields are filled automatically e Action e Service Name 2 7 ORACLE e Operation Code 2 3 4 Specifying Source Preferences You can set the preferences for the External system in the Upload Source Preferences Maintenance screen You can invoke the Upload Source Preferences Maintenance screen by typing CODUPLDM in the f
4. Category code 25 Retrieval an 12 reference number of transaction Used in reversals M Used for Transaction matching M Used for Transaction matching M Information purpose 10 11 12 13 14 15 16 17 18 19 20 21 22 Information purpose 24 M M D NO NO O O O O Field Field name Mandatory sequence M number Optional O 26 Authorization ans 6 Code 27 Authorization ans Reference 2 Used for Transaction matching Some other reference for matching if sent only 00 is considered for processing D Domestic International R regional Europe n4 S Applicable only in case of Reconciliation 0 Domestic flag 31 Pre Auth and Ans Charge back 45 Data Settlement Ans28 Account 3 8 Merchant Settlement File Format The following table gives the format of the file accepted by Oracle FLEXCUBE for Merchant Settlements Fields are separated by pipe symbols The following table gives the general format in Oracle FLEXCUBE You may have a different format installed as per your requirements Field Field name Length Mandatory Description sequence Optional 1 Merchant ID To be used to derive merchant a c To be used to derive the product Event date 0 oneness omme merchant s DrCr Flag Commission 22 Amount 2 22 s o 22 reserved for future use incase switch sends use it To be detected Om DE st ee Field Field name Length Mandatory Descript
5. DR NETWORK SUSPENSE GL TXN_FEE CR NETWORK NOSTRO A C TXN_FEE converted to a c ccy DR NETWORK SUSPENSE GL TXN PROCESS FEE CR NETWORK NOSTRO A C TXN PROGESS FEE converted to a c ccy OFF US DR NETWORK SUSPENSE GL SETL AMT converted to a c ccy CR CASH GL TXN AMT DR NETWORK SUSPENSE GL TXN_FEE converted to setl ccy CR P amp L GL TXN_FEE a ORACLE DR CR NETWORK SUSPENSE GL TXN_PROCESS FEE converted to a c ccy P amp L GL TXN_PROCESS_FEE During Network Settlement DR CR DR CR DR CR NETWORK NOSTRO A C SETL_AMT converted to a c ccy NETWORK SUSPENSE GL SETL_AMT NETWORK NOSTRO A C TXN_FEE NETWORK SUSPENSE GL TXN_FEE converted to a c ccy NETWORK NOSTRO A C TXN PROCESS FEE converted to a c ccy NETWORK SUSPENSE GL TXN_PROCESS_FEE 3 4 2 Accounting Entries for Balance Enquiry ON US DR CUSTOMER A C TXN_FEE converted to a c ccy CR P amp L GL TXN_FEE DR CUSTOMER A C TXN_PROCESS FEE converted to a c ccy CR P amp L GL TXN PROCESS FEE DR CUSTOMER A C FC CHARGES converted to a c ccy CR P amp L GL FC_CHARGES R ONUS DR CUSTOMER A C TXN_FEE converted to a c ccy CR NETWORK SUSPENSE GL TXN_FEE DR CUSTOMER A C TXN_PROCESS FEE converted to a c ccy CR NETWORK SUSPENSE GL TXN PROCESS FEE a4 ORACLE DR CR CUSTOMER A C FC CHARGES converted to a c ccy P amp L GL FC_CHARGES During Network Settlement DR NETWORK SUSPENSE GL TXN_FEE CR NETWORK NOSTRO A C TXN_FEE converted to a
6. Description End Of Cycle Group Function Inputs Ei Parameter Input By Date Time Transaction Input End Of Transaction Input End Of Financial Input End of Day Beginning Of Day Report Orientation Not Applicable Portrait Landscape Data Type Date Format VARCHAR2 Authorized By Modification Authorized Date Time Number Open 2 23 VEN ORACLE 2 5 2 Settlement Upload You can perform settlement uploads for the Switch Network and Merchant categories from the Settlement Upload screen You can invoke the Settlement Upload screen by typing SWDUPLST in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Settlement Upload Channel Category switch Network Merchant Network Id File Name File Path Authorized By Modification Authorized Date Time Date Time Number Open You need to specify the following details Channel Select the channel to be used while uploading settlement files into Oracle FLEXCUBE from the adjoining drop down list The following values are available e ALL e ATM e POS e IVR Based on the channel specified the system will pick up the appropriate Retail Teller product and ARC maintenance for settlement and reconciliation processing Category The categories for which you can perform settlement upload are e Switch e Network e Merchant In the above screen you
7. Reversal should reverse charges e Switch product 2 4 12 Maintaining Charges for Non financial Transactions You can have the following non financial transactions charged e Balance Enquiry e Cheque Book request e Mini statement request e Ad hoc statement request You can facilitate the above service by first using the Retail Teller Product Maintenance to maintain a Retail Teller product as shown below You can invoke the Retail Teller Product Maintenance screen by typing DEDRTPRM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 20 ORACLE Retail Teller Product Details Product Code Product Description Report Module RT Retail Teller Exchange Rate Variance in Override Limit Stop Limit Rate Code Product Type Description Slogan Product Group Product Group Description Start Date End Date Remarks Rate Type Preferred Ms UDF Branch Currency Restriction Maker Date Time Mod No Checker Date Time Record Status Authorization Status You must next do the ARC Maintenance for the above product in the ARC Maintenance screen as shown below In the ARC Maintenance you can maintain the charges for the various non financial transactions under the CHARGE 1 5 tabs The transaction amounts will be zero and so the accounting entries will have only the charges ARC Maintenance Offset Details Branch az Branch Main Le
8. TB PARAM T ABLE ses ccccacccsoucceedceucersiadyesusxencceeenanuaseadasieeiadyeaksnwedeacasensasestoeeaiesiadvenaes 3 13 A SCREEN CGE SARNY oE eI aD ea OT OED ore a er 4 1 4 1 CO i EE EE PE 4 1 ORACLE 1 About this Manual 1 1 Introduction This manual talks about the interface between Oracle FLEXCUBE and the Switch software system used in your bank The maintenances required for the proper functioning of this interface the interface workflow validations and processing for the interface have been documented in this manual 1 2 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 3 Abbreviations cor ome Issuer Bank that issues Cards to facilitate the Transactions Interest and Charges Oracle FLEXCUBE module 1 1 ORACLE 1 4 Organization This manual is organized into the following chapters Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Switch Interface Gateway helps in processing both Financial and Non Financial Transactions Chapter 3 Annexure A briefs the account of the Switch software domain and the components in a Cards Transactions Business network 1 4 1 1 Conventions Used in this Manual e Important information is preceded with
9. c ccy DR NETWORK SUSPENSE GL TXN PROCESS FEE CR NETWORK NOSTRO A C TXN PROCESS FEE converted to a c ccy OFF US DR NETWORK SUSPENSE GL TXN_FEE converted to setl ccy CR P amp L GL TXN_FEE DR NETWORK SUSPENSE GL TXN_PROCESS FEE converted to a c ccy CR P amp L GL TXN PROCESS FEE During Network Settlement DR CR DR CR NETWORK NOSTRO A C TXN_FEE NETWORK SUSPENSE GL TXN_FEE converted to a c ccy NETWORK NOSTRO A C TXN PROCESS FEE converted to a c ccy NETWORK SUSPENSE GL TXN_PROCESS_FEE as ORACLE 3 4 3 Accounting Entries for Deposit ON US DR CR DR CR DR CR DR CR CASH GL CUSTOMER A C CUSTOMER A C P amp L GL CUSTOMER A C P amp L GL CUSTOMER A G P amp L GL TXN AMT BILL AMT converted to a c ccy TXN_FEE converted to a c ccy TXN_FEE TXN_PROCESS FEE converted to a c ccy TXN_PROCESS_FEE FC CHARGES converted to a c ccy FC_CHARGES 3 4 4 Accounting Entries for Funds Transfer ON US DR CR DR CR DR CR DR CR FROM A C TO A C FROM A C P amp L GL FROM A C P amp L GL CUSTOMER A C P amp L GL BILL AMT converted to a c ccy TXN AMT converted to a c ccy TXN_FEE converted to a c ccy TXN_FEE TXN_PROCESS FEE converted to a c ccy TXN_PROCESS_FEE FC CHARGES converted to a c ccy FC_CHARGES 3 6 ORACLE 3 5 Accounting Entries POS Purchase ON US DR CUSTOMER A C CR MERCHANT SUSPENS
10. can specify the Reconciliation File Network file Merchant upload file s name and path 2 24 ORACLE 2 5 3 Intra Day Batch You can run the following Functions in the Intra Day Batch Start screen e SWSWRECN This is the batch for the reconciliation file e SWNETSET This is the batch for the network file e SWDPRCRT This batch removes the amount block e SWMERSET This is the batch for Merchant settlement e SWDPURGE This is the batch for Adhoc purge of transaction data to history table e SWDRETBT This is the batch for retry and suspense processing Once the batches are successfully run their corresponding accounting entries will be posted You can invoke the Intra Day Batch Start screen by typing BADIDBAT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow buiton t f Function Click Ok button to initiate the Intra Day Batch process You can monitor the status of successfully run SWSWRECN and SWNETSET functions in the Intra Day Batch Start Monitor screen 2 25 ORACLE You can invoke the Intra Day Batch Start Monitor screen by typing BASIDMTR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button pranch ag Funcion ag Status All v Search Advanced Search Reset Records per page 15 VILA 4 of 1 Llb ico E Branch Function Status fErrod Reason Start
11. enquiry transaction if charge is defined then it will be deducted from the customer account e If CHG ON ADSTMT Y then for adhoc statement transaction if charge is defined then it will be deducted from customer account e If CHG_ON MISTMT Y then for mini statement transaction if charge is defined then it will be deducted from customer account e If CHG ON CHQBK Y then for cheque book request transaction if charge is defined then it will be deducted from customer account e NO TXN MISTMT defines the number of latest transactions that should appear in a mini statement E g If NO_TXN_MISTMT 10 then in the mini statement the latest 10 transactions will be displayed e ISO VERSION has only three type of value 0 1 and 2 This gives the ISO 8583 message version gt 1987 0 gt 1993 1 gt 2003 2 e NO CHK LEAVES defines the number of pages that should be in one cheque book e ACC STMT PERIOD defines the duration of account statement period e g If ACC_STMT_PERIOD 1 then duration is 1 month e If UTIL PROV ACC SEND Y means for utility payment we have to send the account number in 102 field If UTIL PROV ACC SEND N then Oracle FLEXCUBE will send the provider id not an account number e BLOCK EXP DAYS defines the number of days for amount block E g If BLOCK EXP DAYS 30 then after 30 days the amount block on the account expires Block expiry days will also be used to calculate the purge date for switch trans
12. handoffs 2 9 ORACLE You can invoke the ATM Debit Card FCC Account Mapping screen by typing SWDATMCD in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button gt ATM Debit Card FCC Account Mapping ATM Debit Card Number 1 Card Account Number O Branch C Account Number fa Input BYDOCUMENT2 Authorized By Modification Authorized Date Time Date Time IE Open You must maintain the following mandatory fields in the above screen ATM Debit Card Number Specify the card number Card Account Number Specify the card account number here This must be a unique combination The Card Account Number is mandatory only when the transaction account is the Card Account and not the account maintained in Oracle FLEXCUBE Branch Specify the card issuer branch from the list of options available alongside Account Number From the list of options available alongside specify the Oracle FLEXCUBE account number for which the card has been issued 2 4 3 Maintaining Channel Details You can define channel names using Channel Details screen You can invoke this screen by typing SWDCHNID in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 10 ORACLE Channel Details Channel Details Channel Description Maker Date Time Mod No Checker Date Time Record Status Authorization Status Speci
13. maintained in the system ATM POS and IVR requests may come from the same port or from different ports based on the configuration done in the property file If they are configured to arrive from different ports then the channel is identified based on the port number If they are configured to arrive from the same port then the channel is identified as ALL It is also possible that some of the channels alone share a port Product Code From the list of options available alongside select the Oracle FLEXCUBE product code to be mapped to the specified literal 2 17 ORACLE Network select the network from the list of options available alongside Acquirer Country Select the country of the acquirer from the list of options available alongside 2 4 10 Showing Amount Block Transactions in Account Statements You can have any field from the transaction log included in the Customer Account statement generation Additionally you can also choose to include transactions that resulted in amount blocks You can invoke the Amount Block Input screen by typing CADAMBLK in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Select New from the Actions menu in the Application toolbar The system will display Transaction Branch screen Here you can select the transaction branch Transaction Branch Code Transaction Branch Code En a Here you are allowed
14. mandatory Account Number Specify the Merchant s account number here This is mandatory This will be the Oracle FLEXCUBE account to which postings will be done 2 4 7 Maintaining Terminal Details You must maintain Terminal Details such as the Originating branch Cash GL and Terminal ID for each ATM or POS Terminal This is done in the Terminal Details screen as shown below 2 14 ORACLE You can invoke the Terminal Details screen by typing SWDTRMID in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Terminal Details Terminal ID Channel Originating Branch Cash General Ledger Number Merchant ID Terminal Address Intelligent Deposit Maker Date Time Mod No Checker Date Time Record Status Authorization Status Terminal ID Specify the unique terminal ID of the ATM machine POS machine to uniquely identify then This is mandatory Channel Specify a channel that should be used The adjoining option list displays all valid channels maintained in the system You can choose the appropriate one Note the following e f you select the channel as IVR then you need to leave Intelligent Deposit option unchecked e If you select the channel as IVR then the options Cash General Ledger number and Merchant ID should be blank Originating Branch Specify the Originating Branch from the list of options given alongside It is e
15. post entries when the corresponding network is involved in the transaction It is a mandatory field Depending on the Account Number selected the corresponding Account Branch is displayed Issuer and Acquirer Details Acquirer is the Bank that owns the ATM and POS terminals and offer access to card holders from their own and also other banks Issuer is the Bank that issues the Card to account holders and authorizes posts transactions You must maintain the Issuer and Acquirer Banks for the network here Specify the BIN Bank Identification Number alias IMD International Member Descriptor to identify the Acquirer and Issuer You may also specify a description for each Maintaining Merchant Details You may have various POS machines at different locations each having their own Merchant Details For facilitating POS transaction you must maintain the Merchant Details in the screen as shown below 2 13 ORACLE You can invoke the Merchant Details screen by typing SWDMRCID in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Y Merchant Details Merchant Id Account Branch fail f Account Number Input By Authorized By Modification Authorized Date Time Date Time Number Open Merchant Id Specify the Merchant ID of the POS machine here This is mandatory Account Branch Specify the related branch of the Merchant s account here This is
16. the path from where the file should be picked up for uploading Intraday Sequence Number The system generates a sequence number for the upload transaction and displays it here 2 28 ORACLE 2 7 2 8 Uploading Terminal ID You can upload terminal ID maintenance through the Terminal ID Upload screen You can invoke this screen by typing SWDTIDUP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button File Name File Path Intraday Sequence No Input By Authorized By Modification Authorized Date Time Date Time Number Open You can specify the following details File Name Specify the name of the file that should be uploaded File Path Specify the path from where the file should be picked up for uploading Intraday Sequence No The system generates a sequence number for the upload transaction and displays it here Processing ATM Cash Deposits Cash deposits can happen at ATMs which don t have the Intelligent Deposits facility For such ATMs the Intelligent Deposits option also is not selected in Terminal Details maintenance In the case of such ATMs the cash deposit details are stored as a Tanked Deposit Transaction until you can validate the transaction amount For Tanked Deposit Transactions accounting entries are not passed until the transaction amount is validated and authorised You can validate the transaction amoun
17. the symbol e Switch Interface or Interface in this document refers the Oracle FLEXCUBE Switch Interface that processes the transactions from Switch Software e Switch and Switch Software are generic terms used to refer to any OLTP product which sends transactions to Oracle FLEXCUBE Switch Interface using 508583 1987 1993 2003 protocol 1 4 2 Related Documents You may refer the following manuals for more information e User Manual of the Switch System installed in your Bank This User manual is not included in Oracle FLEXCUBE Manuals e ISO documentation on I508583 protocol This manual is not included in Oracle FLEXCUBE User Manuals 1 2 ORACLE 1 5 Glossary of Icons This User Manual may refer to all or some of the following icons r am B oe Cu fom orm ORACLE Execute Query Refer the Procedures User Manual for further details about the icons 1 4 ORACLE 2 1 2 2 2 2 1 2 Switch Interface Gateway Introduction Oracle FLEXCUBE Switch Interface helps in processing both Financial and Non Financial Transactions The interface helps in first validating each transaction request against the Oracle FLEXCUBE database and then posting the transactions into the system The interface with Switch software system supports Automatic Teller Machine ATM and Point Of Sale POS transactions originating from bank terminals or from Interchanges such as VISA or Master
18. to a c ccy TXN FEE converted to setl ccy TXN FEE TXN PROCESS FEE a c ccy TXN PROGESS FEE SETL AMT SETL AMT p ORACLE 3 6 DR NETWORK SUSPENSE GL TXN_FEE CR NETWORK NOSTRO A C TXN_FEE converted to a c ccy DR NETWORK NOSTRO A C TXN_PROCESS_FEE a c ccy CR NETWORK SUSPENSE GL TXN PROCESS FEE During Merchant Settlement DR MERCHANT SUSPENSE GL TXN AMT COMMISSION CR MERCHANT A C TXN_AMT COMMISSION DR MERCHANT SUSPENSE GL COMMISSION CR P amp L GL COMMISSION Balance Handoff File Formats Oracle FLEXCUBE generates ASCII files separated with the balances of all the accounts that are linked with Cards The following table gives the general Balance Handoff File Format of Oracle FLEXCUBE You may have a different format installed as per your requirements Header Field Field Name sequence Field Name Size Description sequence Characters 1 Branch code 3 Oracle FLEXCUBE branch code 2 Customer Account 28 Account number number Account currency code alpha as ORACLE 3 7 Field Field Name Size Description sequence Characters Available balance This Available balance represents the amount from Oracle available for FLEXCUBE Limit withdrawal spending to be included Switch should stand in should be based on this field definable Footer Field Field Name sequence fem rms Network Settlement Message Format The following table gives the fo
19. to book other branch transactions from the logged in branch Also you can query other branch transactions from the logged in branch The system defaults the logged in branch by default as the transaction branch Transaction Branch Select the appropriate branch from the list of branches available in the option list This screen will be available only for those users who has Multi Branch Operational check box enabled at User Maintenance Screen While clicking Ok button the system validates the access rights of the selected branch and function for the user If you don t have appropriate rights on the selected branch and function the system would raise an error message If you select a valid branch the system updates the same as transaction branch and the transaction would be posted for this branch The system performs the action level access rights validation only on Save operation After selecting the Transaction Branch you can enter the remaining details in the Amount Block Input screen 2 18 ORACLE Amount Block Input Account Block Details Branch Amount Block Number Account Effective Date Amount Expiry Date Amount Block Type FLE BE Reference Number Hold Code Hold Description Remarks Maker Date Time Mod No Checker Date Time Record Status Authorization Status Account Number Specify the Oracle FLEXCUBE account number for blocking the amount This field is mandatory Amou
20. tool bar and clicking the adjoining arrow buiton ARC Maintenance Branch Account Class Product Transaction Type Currency Account Class Product Float Days Basis Description Branch Name Description Customer Group Jas la Account Class Product Type Calendar Working Offset Details Branch Account Transaction Details Branch Account Transaction Code Offset Transaction Code Main Transaction Code a C Liquidation Product for Demand Draft Main Leg for the transaction End Point Transaction Leg vi C Generate Transaction Advice Bank Float Days Description Customer Float Days Debit Account Charge From Account Transaction Account vi Transaction Account Management Information System C Generate MT101 2 5 C Netting Charges Exchange Rate Revaluation Profit Revaluation GL Loss Revaluation GL Charge 1 Charge2 Charge3 Charge4 Charge 5 Rate Minimum Charge Basis vi Charge Account az Transaction Code ag Charge Type vi Rate Type Currency laz Rate Code laz C Netting None w C Their Charge Feas Resuaton Input By Date Time Maximum Charge Amount Description MIS Head Interest Basis Delete Slab Type
21. Annexure chapter for the corresponding accounting entries 2 2 2 2 Cash Advance For cash advances the Oracle FLEXCUBE product is derived at and the preferences are checked for processing Depending upon the message class either amount blocking or account posting is done Amount blocking will include all the charge components The account balance is recorded after the amounts are posted Accounting entries are same as that of POS purchase 2 2 2 3 Refund Accounting entries are similar to those of Cash Deposit 2 3 ORACLE 2 2 2 4 Adjustments The Adjustments facility corresponds to Partial Reversals in ATM the difference being that Cr Adjustments are also possible Accounting entries are same as that of POS purchase 2 2 2 5 Pre auth Completion Pre auth completion involves removing amount block Accounting entries are similar to those of POS purchase STOP Point of Sale POS transaction data will be handed off to Mantas for the branch as per the Mantas maintenance Transactions whose value date is same as the branch EOD date is extracted for mantas hand off Transactions whose status is other than Success or Reversed will not be handed off to Mantas 2 2 3 IVR Transactions The following transactions are supported by IVR e Balance Enquiry e Mini Statement Enquiry e Ad Hoc Statement Generation Request e Cheque Book Issue e Funds Transfer e Utility Payments IVR transaction data will be handed off to Man
22. Card Switch Interface also supports Interactive Voice Response IVR transactions The interface functionality includes the following e Interface with support for ISO 1987 1993 2003 protocols e Authorization and posting of Switch IVR transactions into Oracle FLEXCUBE The following diagram illustrates the flow of messages via the Oracle FLEXCUBE Switch system interface SWITCH Proprietary Format Messages ia ISU Format Messages Vv FLEXCUBE UBS SWITCH Interface Interface Functionalities Following are the functionalities of the Oracle FLEXCUBE Switch system interface ATM Transactions The following functionalities are with respect to ATM transactions This section describes all Transactions required for Switch interface and expected accounting entries 2 2 1 1 Cash Withdrawal During a Cash Withdrawal transaction the product is determined and the preferences are checked for processing Amount blocking or account posting is done depending upon the class of the message Amount blocking will include all the charge components also for Online and Issuer The balance amount is recorded after amount posting is done Refer the Annexure chapter for the corresponding accounting entries A ORACLE 2 2 1 2 Balance Enquiry This facility produces a quote of the Account Balance for a given account The following balances are provided e Ledger balance e Available balance e Unclear balance You can select the Incl
23. E GL DR CUSTOMER A C CR P amp L GL DR CUSTOMER A C CR P amp L GL DR CUSTOMER A C CR P amp L GL During Merchant Settlement DR MERCHANT SUSPENSE GL CR MERCHANT A C DR MERCHANT SUSPENSE GL CR P amp L GL Remote ON US DR CUSTOMER A C CR NETWORK SUSPENSE GL DR CUSTOMER A C CR NETWORK SUSPENSE GL BILL AMT converted to a c ccy TXN AMT TXN_FEE converted to a c ccy TXN FEE TXN PROCESS FEE in a c ccy TXN_PROCESS_FEE FC CHARGES converted to a c ccy FC_CHARGES TXN AMT COMMISSION a c ccy TXN AMT COMMISSION a c ccy COMMISSION COMMISSION BILL AMT converted to a c ccy SETL AMT TXN_FEE converted to a c ccy TXN FEE 3 7 ORACLE DR CUSTOMER A C CR NETWORK SUSPENSE GL DR CUSTOMER A C CR P amp L GL During Network Settlement DR NETWORK SUSPENSE GL CR NETWORK NOSTRO A C DR NETWORK SUSPENSE GL CR NETWORK NOSTRO A C DR NETWORK SUSPENSE GL CR NETWORK NOSTRO A C OFF US DR NETWORK SUSPENSE GL CR MERCHANT SUSPENSE DR NETWORK SUSPENSE GL CR P amp L GL DR NETWORK SUSPENSE GL CR P amp L GL During Network Settlement DR NETWORK NOSTRO A C CR NETWORK SUSPENSE GL TXN_PROCESS FEE a c ccy TXN_PROCESS_FEE FC CHARGES a c ccy FC_CHARGES SETL_AMT SETL_AMT converted to a c ccy TXN FEE TXN FEE converted to a c ccy TXN PROCESS FEE TXN PROCESS FEE a c ccy SETL AMT converted to a c ccy GL TXN AMT converted
24. O EG SDI GN SJ EEE EE EEE 2 28 2 01216 ONDT STEND EE EEE EE EE 2 29 20 ROET 2 29 EMNET Ne 3 1 3 1 SWITCH SOFTWARE AND CARD TRANSACTIONS BUSINESS ccccccceccccecceeecececccccccececceeeececeeeeeeeeeeeeeeeeeeess 3 1 3A 1508583 PROTOCOL OVERVIEW eet egestas tee atest tae se ee ccc veep ease tee 3 1 3 3 SWITCH TRANSACTION Event 3 2 54 ACCOUNTING ENTRIES ATM TRANSACTIONS sipesesesevecaascaneensesapacagecasiesseoevteaawsaseeesevapandaveaiiuerevesraeeneioueees 3 2 3 4 1 Accounting Entries for Cash Withdrawal Transactions rrrrrrnrrnnnnnnnnrrnnnrnnnnnnnrrrnnvnnnnnnnnrnrnrrnnnnnnnnnnenn 3 2 3 4 2 Accounting Entries for Balance Enquiry rrrrrrnnnnnrnrrnnnnnnnnnnnrrrnnrnnnnnnnnrrrnnrnnnnnnnnrrnnnrnnnnennnernnsnnnnnssssenne 3 4 3 4 3 Accounting Entries for Deposit rrrrnnnrrrnnnnnnnnrvvrnnnnnrvnrnnnnnrrnrnnnnnrrnrnnnenrrnvnnnennrnvnnnesnnnrnnnensennnnneesnnnnneee 3 6 ORACLE 3 4 4 Accounting Entries for Funds Transfer rrrrrrrnnnnrnnrrnnrrnnnnnnnrrrnnrnnnnnnnrrrrnrrnnnnnnnnrennnnnnnneserssnnsnnnnssessnene 3 6 3 5 ACCOUNTING ENTRIES POS PURCHASE sina rinni iar aCA EENE AE EEIEIEE ENE S AE RN TANAAN EEREN EANAN 3 7 3 6 PENNEN 3 9 3 7 NETWORK SETTLEMENT MESSAGE FORMAT i sooenernvnnvnenevnvnennenennnnennenennnnennnnensnnensnnensnnenennenennnnennnnennnnennenene 3 10 3 8 MERCHANT SETTLEMENT FILE FORMAT wissccacccscuacsci couse rsiadvesnsxeuseacetsauacsedadaseveiadvenksnoedeacebecsaceadaeecnveiecveuaes 3 12 3 9 MAINTAINING SW
25. Switch Interface Gateway Oracle FLEXCUBE Universal Banking Release 11 3 1 0 0LA January 2012 Oracle Part Number E51536 01 ORACLE FINANCIAL SERVICES ORACLE Switch Interface Gateway Table of Contents L ABOUT THIS MANUA MD ip sisesssiscitscstivastcsscistacssasasctuasssiveataansieseesscacsiasass EEAO A aE Aa EEA aana ana Eare 1 1 1 1 INTRODUC HON errira ee err A E A E E eee ee ere ener eT eer l 1 L2 NE l 1 1 3 DRITT 1 1 LA ORGANIZA TON jr 1 2 1 4 2 MN 1 2 FE GEO SAR OFICON EE EE EE RE OE NE PETE 1 3 2 SWITCH INTERFACE GATEWAY sicssisssiccoscsscsisrssssesesesavascbesticivessbssseecseratanasivetcbuatisieesssusseeesesstoecsaiesiiesiiess 2 1 2 NINA 2 1 22 TREN 2 1 Zell MTT 2 1 LAM Fore GANG 2 3 225 VTM DANN NGNE GSA iaiia 2 4 25 GATEWAY MAINTENANCE FOR SWITCH INTERFACE orvovvvvvvvvvvvvvvvvnnnnnnnennnnnnnnennnnnnnnnnnnnnnnnnnnnennneneneenneneneeee 2 4 2 3 1 Maintaining Upload SOUurCe rronnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnrnrnnnnnnnnnnnnrnnnnnnnnnsnnsennrnnnnnnssssnnnnnnnnesessennnnnnnneene 2 5 252 Maintaining FLEXSWITCH External System rrrrrnnnnnnnnnnnnnnnnrrrvvvvvvvvvnnnnnnnnnnnnnnnsnrrrnnnnvrrrrnnnnnnnnnssnsnsne 2 6 2 53 Specifying External System Functions orrrrnrrnnnnnnnnrrrnnrnnnnnnnrrrnnrrnnnnnnnnrrnnnrnnnnnnnnrrnnnnnnnnennsnnnnnnnnnnesssnnne 2 7 20 4 Specifying Source Preferences msress ssessvnsrnnnnsvnrnasensvnsnnsvnsnnsnnnernvnennevnennnnasenenssnsevssenenesnsenssnsevesnanneneses 2 8 24 TINN 2 9
26. Time End time End of Cycie Operations Event Sequence Number 2 26 ORACLE 2 5 4 Viewing Transaction Monitor You can view a summary of transaction status in the Switch Transaction Monitor screen You can invoke this screen by typing SWDTXQRY in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Switch Transaction Monitor Transaction Log Total WIP Success Failed Retry Log Repair Unprocessed Success Suspense Reversed Total Here you can view the following details Transaction Log You can view the number of transactions in the following statuses e WIP e Success e Repair e Failed e Total Retry Log You can view the retry log of transactions in the following statuses e Unprocessed e Success e Suspense e Reversed e Total 2 27 ORACLE 2 6 Uploading Cards You can upload card account mapping maintenance through the Debit Card FCC Account Upload screen You can invoke this screen by typing SWDCDUPL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Debit Card FCC Account Upload File Name File Path Intraday Sequence Number Input By Authorized By Modification Authorized Number Date Time Date Time Open You can specify the following details File Name Specify the name of the file that should be uploaded File Path Specify
27. a local currency has been maintained then the transaction amount is converted to the local currency and displayed here Transaction Date This is the Deposit transaction date as sent in the ISO message Transaction Reference Number This is the Transaction Reference Number which is generated for the deposit transaction 2 30 ORACLE Charge Currency and Charge Currency 1 4 Charges may be levied as Transaction Fee Transaction Processing Fee and as other charges maintained in Oracle FLEXCUBE The currency that has been defined for the corresponding charge is displayed here Charge Amount and Charge Amount 1 4 The charge amount for the corresponding charge is displayed here Charge Description and Charge Description 1 4 The description for the charge is displayed here 2 31 ORACLE 3 1 3 2 3 Annexure A Switch Software and Card Transactions Business The following is a brief account of the Switch software domain and the components in a Cards Transactions Business network The following diagram illustrates the components in the switch network Interchanges VISA MasterCard FLEXCUBE SWITCH Merchant Dotted lines show Accounting relations ATMs and POS Terminals are connected with the Switch Software system using proprietary message protocol depending on the upon the terminal device type Switch software is also connected with Interchanges like VISA and MasterCard A switch software system provides
28. action e MAX RETRY COUNT defines the number of times for Retail Teller transactions to try for a single transaction if it fails e I FCC ACC FROM SWITCH Y then transaction account is same as Oracle FLEXCUBE account If FCC ACC FROM SWITCH N then transaction account is card account not Oracle FLEXCUBE account e IFONLY PAN FROM SWITCH Y then transaction account is not mandatory in ISO request i e No need to give card account or Oracle FLEXCUBE account in request e If ONLY_PAN FROM_SWITCH N then in request transaction account is mandatory 3 15 ORACLE 4 Screen Glossary 4 1 Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual Finen o punon oes 4 1 ORACLE ORACLE Switch Interface Gateway January 2012 Version 11 3 1 0 0LA 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 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 S
29. can invoke the Currency Definition screen by typing CYDCDEFN in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button m ET Currency Code Alternate Currency Code Currency Name Currency Type ISO Numeric Currency Code Country i le Position General ual Ledger Position Equivalent Tas General Ledger Tolerance Limit Spot Days Index Base Currency A Foreign Exchange Netting Days Settlement Days Decimals Interest Method Cutoff Time Days Hour Minute C Generate 103 index Flag C New COV format po Required CLS Currency C Euro Conversion Validate Tag 50F Rounding Amount Format Mask Euro Type Rule Truncate v 99 999 999 999 EURO Currency Unit ss 9999 99 99 999 In Leg Currency Out Currency EURO Closed Currency Country Mapping input By Authorized By Modification Authorized Date Time Date Time Number Open 2 4 2 ATM Debit Card Mapping for Card Account Number Conversion The interface facilitates conversion of ATM Card Number and Card Account Number to Oracle FLEXCUBE s alphanumeric account number For this facility you must map the card account numbers to Oracle FLEXCUBE account numbers This mapping can be done in the Debit Card Oracle FLEXCUBE Account Mapping screen Upload will be provided for this date tends to be in bulk and banks will prefer to maintain it using
30. characters from the ISO process code here It is a two digit unique number This is a mandatory field Channel Specify a channel that should be used The adjoining option list displays all valid channels maintained in the system You can choose the appropriate one External Transaction Code Specify the external transaction code here This is an optional field Description Optionally you can specify a brief description of your maintenance here 2 4 5 Maintaining Network Details For every network interacting with the SWITCH system you need to maintain the Network Issuers and Acquirer details This maintenance is done in the Network Details screen as shown below 2 12 ORACLE 2 4 6 You can invoke the Network Details screen by typing SWDNWDET in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Network Details Network Id Description Account Number Account Branch Acquirer Details Issuer Details E Acquirer BIN Acquirer Description Issuer BIN Issuer Description Authorized By Modification Authorized Date Time Date Time Number Open Network ID Specify the Network Id of the card issuing agency here This is a mandatory field Account Number and Account Branch Specify the Account Number from the list of options available alongside each field This account number a Nostro account belongs to the specify Network Id This is used to
31. fy the following details here Channel Specify the channels like ATM IVR POS and ALL These channels are factory shipped Description Enter a brief description about channels 2 4 4 Maintaining Process Code Mapping Details All transaction requests from the switch system are conveyed in ISO transaction codes These are resolved into corresponding specific transactions in Oracle FLEXCUBE For this you must maintain the ISO transaction code and its corresponding Oracle FLEXCUBE transaction literal in the Process Code Mapping Details maintenance screen 2 11 ORACLE Create and maintain process code types for all Oracle FLEXCUBE literals in the Process Code Mapping Details screen You can invoke the Process Code Mapping Details screen by typing SWDFCLITL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Process Code Mapping Details Details Process Code Type Flexcube Literal External Transaction Code Description Channel Details 10f1 a d Maker Date Time Mod No Checker Date Time Record Status Authorization Status Specify the following details here Oracle FLEXCUBE Literal Select the Oracle FLEXCUBE literal from the drop down list available alongside This is a mandatory field You can enter additional information in the editor that is displayed on clicking the adjoining icon Process Code Type Specify the first two
32. g forthe Transaction Leg v A transaction Branch Name Account i Ciass Product A Cle Management Information az Account Class Produc ccoun ss Transaction Details System O Product Type Branch Debit Account Transaction Account Account Class Product Account Charge From Account Transaction Account Description i End Point az Transaction Code i Offset Transaction Code az Description az Bank Float Days Customer Float Days Transaction Type Description Float Days Basis Calendar 8 Working Generate Transaction E Liquidation Product for O Ako Currency az Demand Draft _ Netting Charges Main Transaction Code C Generate MT101 Exchange Rate Revaluation Profit Revaluation GL az Loss Revaluation GL CHARGE1 CHARGE2 CHARGE3 CHARGE4 CHARGES Basis v Rate Charge Account az Minimum Charge Transaction Code az Maximum Charge Charge Type 8 Rate Type Currency az Amount Rate Code Description _ Netting MIS Head Interest Basis C Their Charge 2 Slab Type None input By DOC1 Date Time Modification Number I Authorized Authorized By Date Time v Open 2 21 ORACLE 2 4 13 ARC Maintenance You can maintain the charges for the product type in the ARC Maintenance screen You can invoke the ARC Maintenance screen by typing IFDATMMN in the field at the top right corner of the Application
33. hes the Switch interface at the bank where is passed to the Oracle FLEXCUBE system Oracle FLEXCUBE system will generate Book Dated statements by default The period for which the statement is required can be specified Accounting entries are same as that of Balance Enquiry 2 2 1 8 Cheque Book Issue The customer requests a Cheque Book via the ATM thereby informing the bank This request is sent to the Oracle FLEXCUBE system via the interface The number for cheque leaves can be specified The cheque numbers are automatically generated Accounting entries are same as those for Balance Enquiry ATM transaction data will be handed off to Mantas for the branch as per the Mantas maintenance Transactions whose value date is same as the branch EOD date is extracted for Mantas hand off Transactions whose status is other than Success or Reversed will not be handed off to Mantas 2 2 2 Point Of Sale Transactions The following are the facilities provided for Point Of Sale POS Transactions 2 2 2 1 POS Purchase The customer initiates a normal purchase at Merchants POS Terminal This purchase request reaches Oracle FLEXCUBE via the Switch interface Based on the purchase a product is identified and the preferences are considered Depending upon the message class either amount blocking or account posting is done Amount blocking will include all the charge components The account balance is recorded after the amounts are posted Refer the
34. ield at the top right corner of the Application tool bar and clicking the adjoining arrow button b Upload Source Preferences Maintenance Source Code Module Code J Error Handling On Exception d Reject On Override Ignore Post Upload Status Authorized v Purge Days Calendar C Allow Deferred Processing Allow EOD with Deferred Allow Delete Input By Authorized By Modification Authorized Date Time Date Time Number Open Source Code Select Source Code FLEXSWITCH from the list Module Code Select Module Code from the list of options On Override Select Ignore to ignore error handling overrides On Exception Select Reject to reject error handling exceptions Post Upload Status Select Authorized for the uploads to be automatically authorized on completion of the upload process Leave the following checkboxes cleared e Allow Deferred Processing e Allow EOD with Deferred e Allow Delete 2 8 ORACLE 2 4 Switch Interface Maintenance You must perform the following maintenances for the Oracle FLEXCUBE Switch system interface 2 4 1 Defining Currency for Currency Code Conversion ISO numeric currency codes are converted into Oracle FLEXCUBE s alpha numeric currency code The definition for the conversion is maintained against the ISO Numeric Currency Code field in the Currency Definition screen as shown below You
35. ion sequence Optional Commission 1 commission flag incase sent Flag Commission commission currency code currency code Merchant current 28 incase merchant ID is not having a c any maintenance at Oracle FLEXCUBE 3 9 Maintaining SWTB PARAM Table The SWTB_PARAM is the single record table for SWIG initial parameters The maintenances in this table are done during implementation of the Switch Interface Gateway system This is for your information only FOLLOW_ON AMOUNT BLOCK SETL_BEFORE_FILE LOG_TABLE_KEY MSG_TYPE RRN CHG_ON_BALENQ CHG ON ADSTMT CHG ON MISTMT CHG ON CHQBK NO TXN MISTMT ISO VERSION NO CHK LEAVES AGC STMT PERIOD UTIL PROV AGCC SEND BLOGK EXP DAYS MAX RETRY COUNT EOC AGG FROM SWITCH ONLY PAN FROM SWITCH e If FOLLOW_ON Y then gt for 200 MSG TYPE Amount Block is done gt for 220 MSG TYPE Parent message will be checked e If FOLLOW_ON N then for 200 and 220 MSG TYPE it will check if AMOUNT _BLOCK Y then all 200 and 220 MSG will perform amount block e If SETL_BEFORE_FILE Y then all remote on us and off us transaction will perform Retail Teller transaction and accounting entries e If SETL_BEFORE_FILE N then all remote on us and off us transaction will do the Amount block and Retail Teller transaction will completed at the time of settlement file e LOG_TABLE_KEY is for making the primary key for ATM transaction e If CHG ON BALENQ Y then for balance
36. ither the issuer branch of the POS or the ATM branch as the case may be Cash GL Account This field is enabled and is mandatory for ATM type terminals only Specify the Cash GL Account form the adjoining list of options Merchant ID This field is enabled and is mandatory for POS type terminals only Specify the Merchant ID here Terminal Address Specify the address of the terminal here 2 15 ORACLE Intelligent Deposits This checkbox is valid only for ATM terminals Select this checkbox to indicate the ATM provides Intelligent Deposits facility In the Intelligent Deposits facility accounting entries are done as soon as the customer makes the Deposit 2 4 8 Maintaining Utility Provider Details Maintain the details of a utility provider in the Utility Provider Details screen You can invoke the Utility Provider Details screen by typing SWDUPDET in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Utility Provider Details Utility Provider Id Description Account Branch Account Number Authorized By Modification Authorized r Number Date Time Date Time Open Utility Provider Id Specify the Utility Provider Id here Account Branch Specify the related branch of the Merchant s account here This is mandatory Account Number Specify the Merchant s account number here This is mandatory This will be the Oracle FLEXCUBE account to which
37. nt Block Number Amount block number is unique and Is created after the amount block creation Amount Specify the Amount blocked This field is mandatory Expiry Date Specify the expiry date of the Amount Block Effective Date Specify the date from which the Amount block is effective Amount Block This list shows Switch Oracle FLEXCUBE and Pre Auth If the amount block is done via Switch then it must be selected here Remark Optionally you may add your remarks here 2 19 ORACLE 2 4 11 Modifying a Product Preferences Screen During the implementation of the Switch interface system you can use the following facility to modify the Preferences screen for a product You can invoke the Retail Teller Product Preferences screen by typing DEDRTPRM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Retail Teller Product Maintenance Product Code Exchange Rate Variancelin Product Description lg Override Limit Report Module RT Stop Limit Retail Teller Rate Code Product Type ia Rate Type Preffered Description Product Group C H Product Group Description Start Date C H EndDate B Maker Date Time Mod No Checker Date Time Record Status Authorization Status You may select the following checkboxes if you wish to have them in a product s Preferences screen e Partial Reversals allowed e Reversal Includes charges
38. oftware 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 All company and product names are trademarks of the respective companies with which they are associated
39. ool bar and clicking the adjoining arrow button Externe Systems Detailed External System Correlation Pattern External System Request Message Id vi Description Message Exchange Pattern EE Queue Request Message Input Only vi Default Response Queue le Response Message Full Screen vi Dead Letter Queue iP C Register Response Queue Message Id XSD Validation Required External System Queues Cs RESPONSE Queue o 2 a Fields FTP Parameters Input By Authorized By Modification Authorized Exit Date Time Date Time Number Open You must specify the following in the above screen External System and Description Specify the External System as FLEXSWITCH You may optionally give a brief description of the External System too Correlation Pattern Request Select and set Correlation ID against this field Message Exchange Pattern Request Message Select Input only from the adjoining drop down list Message Exchange Pattern Request Message Select Full screen from the adjoining drop down list Default Response Queue Specify the default response queue as SW MDB QUEUE RESPONSE 2 6 ORACLE 2 3 3 Dead Letter Queue Specify the dead letter queue as MDB QEUEU DLQ XSD Validation Required Select this checkbox if the request xml and response xml has to be validated against the XSD
40. postings will be done Description Optionally you can give a brief description of the utility provider here 2 4 9 Maintaining Product Types for Product Derivation Every transaction request from the switch system is assigned under a particular product type This maintenance is done in the Product Type Maintenance screen Here you can map products to Oracle FLEXCUBE literals 2 16 ORACLE For every transaction request the Oracle FLEXCUBE product is derived based on the Category Oracle FLEXCUBE literal and the Customer Category You can invoke the Product Type Maintenance screen by typing SWDPRMAP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow buiton Product Type Maintenance Flexcube Literal Category Customer Category Network Acquirer Country Channel Product Code Authorized By Modification Authorize y 1 Authorized Date Time Date Time Number Open You can specify the following details here Oracle FLEXCUBE Literal Select a three digit literal from the list of options available alongside Category Select the category of the transaction On Us Off Us or Remote On Us from the list of options available alongside Customer Category Select a customer category from the list of options available alongside Channel Specify the channel that should be used for transaction The adjoining option list displays all the channels
41. rmat of the file accepted by Oracle FLEXCUBE for network settlements Fields are separated by pipe symbol and the amounts are with decimal included The following table gives the general format in Oracle FLEXCUBE You may have a different format installed as per your requirements Field Field name sequence number Message type Bank account ans number Mandatory M Optional O If it is optional original or reversal is identified based on Transaction code O0 O Refund reversal 27 Cash wdl reversal Refer Transaction service derivation logic in earlier sections This is used for information purpose Refer Amount derivation logic processing code ans 6 Transaction Amount Transaction ans 05 Sale 06 Refund 07 Cash Code Wal 25 Sale reversal 26 Mandatory M Optional O Field Field name sequence number Settlement n 22 Amount Settlement n3 Currency Billing Amount n 22 Billing currency n3 M Refer Amount derivation logic Refer Amount derivation logic Refer Amount derivation logic Refer Amount derivation logic Used for Transaction matching Refer Amount derivation logic Transaction Date s8 Format YYYYMMDD amc Ta fas M M Used for Transaction matching Original STAN Ani2 Acquirer ID asn 6 Terminal ID ans 16 Card Acceptor ID ans Merchant Id ans Merchant Name ans Merchant City ans M 40 23 Merchant asn Country Merchant n4
42. tas for the branch as per the Mantas maintenance Transactions whose value date is same as the branch EOD date is extracted for Mantas hand off Transactions whose status is other than Success or Reversed will not be handed off to Mantas 2 3 Gateway Maintenance for Switch Interface The following are the interface gateway maintenances done for setting up the Switch Interface Gateway 2 4 ORACLE 2 3 1 Maintaining Upload Source The Upload Source is maintained in the Upload Source Maintenance screen You can invoke the Upload Source Maintenance screen by typing CODSORCE in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button UpLoad Source Definition Source Code Description Base Data From FLEXCUBE C System Authorization Required Input By Authorized By Modification Date Time Date Time Number Authorized Open Ea In the above screen the Source Code FLEXSWITCH and the brief description of the source are maintained 2 5 ORACLE 2 3 2 Maintaining FLEXSWITCH External System The FLEXSWITCH external system is maintained in the External System Detailed screen Here you can maintain the Correlation pattern Message pattern and Queue names for the external system i e FLEXSWITCH You can invoke the External System Detailed screen by typing GWDEXSYS in the field at the top right corner of the Application t
43. the following functionalities e Maintaining all ATM POS Interchange information e Maintaining Card Number to Account Number Linkages e Receiving Card Transactions from ATM POS terminals and checking PIN and Card status e Forwarding the Transactions to Host Banking Systems like Oracle FLEXCUBE after converting proprietary protocol into 1508583 protocol e Performing stand in authorization incase of Link to Host systems are down e Refreshing Account balances from Banking Systems to use Stand in IS08583 Protocol Overview I508583 protocol is called the Financial Transaction Standard for Card originated messages and Interchange message specifications This protocol provides for the exchange of information between an Acquirer and an Issuer for card transactions The terms Acquirer and Issuer are explained below Acquirer An Acquirer is the Bank that deploys the self servicing devices like ATM POS and may have a switch system software and Interchange connections 3 1 ORACLE 3 3 3 4 Issuer An Issuer is the Bank that issues cards to its customers It has the database of accounts and is connected to the Switch system software In the course of transactions via the switch system Issuers respond to Acquirers with approval or rejection messages Switch Transaction Categories The Switch system transaction flows can happen in three different ways Each flow is termed as a Category of the
44. transaction The categories are from the Issuer bank s perspective The following example explains the categories Consider that Oracle FLEXCUBE system is installed at YOUR BANK Consider another bank say HSBC with which you can have card based transactions Then the following are the categories depending upon which bank s Card or Terminal is involved ATM POS Terminal Category of Transaction YOUR BANK Cards YOUR BANK HSBC Cards YOUR BANK Off Us Accounting Entries ATM Transactions The following are the various accounting entries for ATM Transactions 3 4 1 Accounting Entries for Cash Withdrawal Transactions ON US DR CUSTOMER A C BILL AMT converted to a c ccy CR CASH GL TXN AMT DR CUSTOMER A C TXN_FEE converted to a c ccy CR P amp L GL TXN_FEE DR CUSTOMER A C TXN PROCESS FEE converted to a c ccy CR P amp L GL TXN_PROCESS_FEE DR CUSTOMER A C FC_CHARGES converted to a c ccy CR P amp L GL FC_CHARGES 15 ORACLE Remote ON US DR CR DR CR DR CR DR CR CUSTOMER A C BILL AMT converted to a c ccy NETWORK SUSPENSE GL SETL_AMT CUSTOMER A C TXN_FEE converted to a c ccy NETWORK SUSPENSE GL TXN_FEE CUSTOMER A C TXN_PROCESS FEE converted to a c ccy NETWORK SUSPENSE GL TXN PROCESS FEE CUSTOMER A C FC CHARGES converted to a c ccy P amp L GL FC CHARGES During Network Settlement DR NETWORK SUSPENSE GL SETL AMT CR NETWORK NOSTRO A C SETL AMT converted to a c ccy
45. ts of Tanked Deposit Transactions in the ATM Cash Deposit Details screen 2 29 ORACLE You can invoke the ATM Cash Deposit Details screen by typing SWDCSHDP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button ATM Cash Deposit Details Details Transaction Account Transaction Currency Transaction Amount Local Currency Amount Transaction Date Transaction Reference Amount Charges Charge Currency Charge Currency 1 Charge Currency 2 Amount Charge Amount1 Charge Amount2 Charge Description Charge Description1 Charge Description2 Charge Currency 3 Charge Currency 4 Charge Amount3 Charge Amount4 Charge Description3 Charge Description4 Authorized By Modification Authorized Date Time Date Time Number Open You must validate the tanked deposit by specifying the actual transaction amount in the Actual Amount field Once done click Exit button to exit and save your validation The following details are displayed in the above screen The details give information regarding the cash deposit Transaction Account This displays the Oracle FLEXCUBE account which has been linked to the Card Account Number Transaction Currency This field displays the Oracle FLEXCUBE currency which has been linked to the numeric currency in the ISO message Transaction Amount This is the deposit amount sent through the ISO message Local Currency Amount If
46. ude OD limit option when showing balance Refer the Annexure chapter for the corresponding accounting entries 2 2 1 3 Mini Statement Enquiry The interface facilitates the enquiry for Mini Statements You can specify number of rows the period for which the statement is to be generated The statement can have the following columns e Originating Branch Code e Transaction Literal e Transaction Amount Sign e Transaction Amount e Flag Dr Cr e Value Date e Transmission Date e Transaction Reference Number The accounting entries are the same as those for Balance Enquiry 2 2 1 4 Deposit The system can automatically select the product based on the check or cash deposit In case of cash deposits the system checks whether immediate accounting or posting is required or whether it is to be only logged Refer the Annexure chapter for the corresponding accounting entries 2 2 1 5 Funds Transfer This facility is used when a customer initiates a Fund Transfer between his accounts or to another customer s account The Switch system will send both Account numbers in ISO messages Refer the Annexure chapter for the corresponding accounting entries 2 2 1 6 Utility Payments This facility helps in making payments into a Utility Provider s account Accounting entries are same as that of Fund Transfer a ORACLE 2 2 1 7 Ad Hoc Statement Generation Request Here the customer requests a Statement through the ATM This request is reac

Switch Interface Gateway User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents