Home

Switch Interface Gateway User Manual

1. 2 8 2 4 41 Defining Currency for Currency Code Conversion 2 8 2 42 Maintaining Card Transaction Limits sssseenne 2 9 2 4 3 ATM Debit Card Mapping for Card Account Number Conversion 2 10 2 44 Maintaining Channel Details sse 2 13 2 45 Maintaining Process Code Mapping 2 13 2 4 6 Maintaining Network 021 2 01 2 2 000000000000 0000 2 14 2 4 7 Maintaining Merchant Details sss 2 15 2 4 8 Maintaining Terminal Details sse 2 16 2 4 9 Maintaining Utility Provider Details sss 2 18 2 4 10 Maintaining Product Types for Product Derivation 2 18 2 4 11 Showing Amount Block Transactions in Account Statements 2 20 2 4 12 Modifying a Product Preferences 2 21 2 4 13 Maintaining Charges for Non financial 2 21 2 4 14 ARC Maintenance Ne 2 22 2 4 15 Service Charges for Inter branch 2 23 2 4 16 Forwarding Institution ID Details sse 2 24 2 4 17 Viewing Forwarding Institution ID sse 2 25 2 4 18 Uploading Forwarding Institution D
2. 2 29 BASIDMTR 2 29 CADAMBLK 2 20 CODSORCE 2 4 CODUPLDM 2 7 CYDCDEFN 2 8 D DEDRTPRM 2 22 G GWDEXFUN 2 7 GWDEXSYS 2 5 IFDATMMN 2 22 4 Function ID Glossary 5 SWDCDMNT 2 11 SWDCDTLM 2 9 SWDCDUPL 2 30 SWDCHNID 2 13 SWDCSHDP 2 32 SWDFCLTL 2 14 SWDFIDUP 2 26 SWDFWhARID 2 24 SWDNWDET 2 15 SWDPRMAP 2 19 SWDTIDUP 2 32 SWDTRMID 2 16 SWDTXQRY 2 30 SWDUPDET 2 18 SWDUPLST 2 28 SWDUTLPR 2 18 SWSFRID 2 25 ORACLE
3. Description Transaction Type Description Currency Customer Group Account Class Group IB Transaction Offset Details Branch Account Account Description Transaction Details Branch Account Account Description Yes Transaction Code Offset Transaction Code Main Transaction Code _ Liquidation Product for Demand Draft Netting Charges Main Offset Accounting Entries Required Charge 2 Charge 3 Charge 4 Charge 5 Basis Charge Debit Account Charge Credit Account Account Description Transaction Code Charge Type Currency Rate Code Slab Type Charge Tracking Preference Rate Minimum Charge Maximum Charge Rate Type Amount Description MIS Head Netting None Their Charge Not Required Main Leg forthe transaction End Point Bank Float Days Description Customer Float Days Float Days Basis Transaction Leg Calendar Working Transaction Account Charge Debit Account Management Information System _ Generate Transaction Advice Generate MT101 Debit Account Exchange Rate Revaluation Profit Revaluation GL Loss Revaluation GL Fields Regulation Maker Checker Mod No Record Status Authorization Status Date Time Date Time The ARC maintenance is done for the product Cash Withdrawal CHWL You can maintain charges under charge tabs CHARGE 1 5 for both financial and non financial transactions CHARGE1 must be the Transacti
4. 12 Billing currency n3 Refer Amount derivation logic 13 Transaction 58 Used for Transaction matching Date Format YYYYMMDD 14 Transaction s6 M Time 15 STAN an M Used for Transaction matching 12 16 Original STAN 12 Used reversals 17 Acquirer ID asn Used for Transaction matching 6 3 9 ORACLE 3 8 Field Sequence Field Name Size Remarks Optional Number 18 Terminal ID ans M Used for Transaction matching 16 19 Card Acceptor ans ID 20 20 Merchant Id ans 20 21 Merchant ans M Information purpose Name 40 22 Merchant City ans M Information purpose 40 23 Merchant asn Country 10 24 Merchant Cate n4 M gory code 25 Retrieval refer an M ence numberof 12 transaction 26 Authorization ans M Used for Transaction matching Code 6 27 Authorization ans Some other reference for Reference 20 matching 28 Response n4 if sent only 00 is considered for code processing 29 Domestic flag 1 D Domestic International R regional Europe 30 Settlement Ans2 O Account 8 31 Pre Auth and Ans Applicable only in case of Rec Charge back 45 onciliation Data 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
5. CRP amp LGLTXN_PROCESS_FEE DRCUSTOMER A CFC_CHARGES converted to a c ccy CRP amp LGLFC_CHARGES Remote ON US DR CUSTOMER A CBILL AMT converted to a c ccy CRNETWORK SUSPENSE GLSETL_AMT DRCUSTOMER A CTXN_FEE converted to a c ccy oe ORACLE 3 4 2 CRNETWORK SUSPENSE GLTXN_FEE DRCUSTOMER A CTXN PROCESS FEE converted to a c CRNETWORK SUSPENSE GLTXN_PROCESS_FEE DRCUSTOMER A CFC_CHARGES converted to a c ccy CRP amp LGLFC_CHARGES During Network Settlement DRNETWORK SUSPENSE GL SETL_AMT CRNETWORK NOSTRO A CSETL_AMT converted to a c ccy DRNETWORK SUSPENSE GL TXN_FEE CRNETWORK NOSTRO A CTXN_FEE converted to a c ccy DRNETWORK SUSPENSE GL TXN_PROCESS_FEE CRNETWORK NOSTRO A CTXN PROCESS FEE converted to a c OFF US DR NETWORK SUSPENSE GLSETL AMT converted to a c ccy CRCASH GLTXN AMT DRNETWORK SUSPENSE GLTXN FEE converted to setl ccy CRP amp L GLTXN FEE DRNETWORK SUSPENSE GLTXN PROCESS FEE converted to a c ccy CRP amp L GLTXN PROCESS FEE During Network Settlement DRNETWORK NOSTRO A CSETL AMT converted to a c ccy CRNETWORK SUSPENSE GL SETL AMT DRNETWORK NOSTRO A CTXN FEE CRNETWORK SUSPENSE GLTXN FEE converted to a c ccy DRNETWORK NOSTRO A CTXN PROCESS FEE converted to a c ccy CRNETWORK SUSPENSE GL TXN PROCESS FEE Accounting Entries for Balance Enquiry ON US DRCUSTOMER A CTXN FEE converted to a c ccy CRP amp LGLTXN FEE 22 ORACLE 3 4 3 DRCUSTOMER A CTXN
6. 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 can specify the Reconciliation File Network file Merchant upload file s name and path Intra Day Batch You can run the following Functions in the Intra Day Batch Start screen SWSWRECN This is the batch for the reconciliation file SWNETSET This is the batch for the network file SWDPRCRT This batch removes the amount block e SWMERSET This is the batch for Merchant settlement SWDPURGE This is the batch for Adhoc purge of transaction data to history table SWDRETBT This is the batch for retry and suspense processing 268 ORACLE 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 button gt Login Page E Enter Query 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 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 an
7. Intelligent Deposit Maker Date Time Checker Date Time Mod No 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 Ifyou select the channel as IVR then you need to leave Intelligent Deposit option unchecked 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 either 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 217 ORACLE 2 4 9 2 4 10 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 Maintaining Utility P
8. Maintenance to maintain a Retail Teller product as shown below 2 21 ORACLE 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 Retail Teller Product Details EX New Enter Query Product Code Exchange Rate Variance Product Description Override Limit Report Module RT Stop Limit Retail Teller Rate Code Product Type Description Slogan Product Group Product Group Description Start Date End Date Remarks Rate Type Preferred Preferences MIS UDF Branch Currency Restriction Maker Date Time Checker Date Time Mod No 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 2 4 14 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 tool bar and clicking the adjoining arrow button 222 ORACLE ARC Maintenance Enter Query Branch Branch Name Product
9. ORACLE 2 4 3 Limit Details Currency Code Select the currency code from the adjoining option list ATM Daily Transaction Limit Specify the daily transaction limit of the ATM ATM Per Transaction Limit Specify the per transaction limit of the ATM If the transaction limit is zero then there is no limit validation ATM Daily Count Limit Specify the daily count limit of the ATM If the transaction limit is zero then there is no limit validation POS Daily Limit Specify the daily limit of POS If the transaction limit is zero then there is no limit validation POS Per Transaction Limit Specify the per transaction limit of POS If the transaction limit is zero then there is no limit validation POS Daily Count Limit Specify the daily count limit of POS If the transaction limit is zero then there is no limit validation 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 handoffs 219 ORACLE You can invoke the ATM Debit Card FCC Account Mapping screen by typing SWDCDMNT in the field a
10. Query Network Id Description Account Number Account Branch Acquirer Details Issuer Details 1 Acquirer BIN Acquirer Description IssuerBIN Issuer Description Input By Authorized By Modification Date Time Date Time Number Wi Authorized 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 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 the
11. different format installed as per your requirements ORACLE Mandatory Sequence Field Name Length y Description Optional 1 Merchant ID an 15 M To be used to derive mer chant a c 2 Transaction 2 M To be used to derive the code product 3 Processing 6 ISO type processing code code 6 Event date 8 Batch processing date 7 Amount 22 M Total amount settled to merchant Currency 3 M 8 Tax Amount 22 reserved for future use 9 DrCr Flag 1 incase switch sends use it 10 Commission 22 To be detected Amount 11 Commission 1 commission flag incase Flag sent 12 Commission 3 commission currency currency code code 13 Merchant cur 28 incase merchant ID is not rent a c having any maintenance at Oracle FLEXCUBE 14 Branch code 3 Merchant branch code 15 Bank code 10 Merchant bank code 16 User Info 30 Reserved for CSE 3 9 Maintaining SWTB PARAM Table 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 Y AMOUNT_BLOCK Y SETL_BEFORE_FILE Y LOG_TABLE_KEY MSG TYPE RRN 9 1 ORACLE CHG_ON_BALENQ N CHG_ON_ADSTMT N CHG_ON_MISTMT N CHG_ON_CHQBK N NO_TXN_MISTMT 10 ISO_VERSION 0 NO_CHK_LEAVES 25 ACC_STMT_PERIOD 1 UTIL_
12. 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 240 ORACLE 2 4 12 2 4 13 Remark Optionally you may add your remarks here 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 the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Preferences Product Code Product Description Transaction Limit 10000 Block Expiry Days RD payments allowed Cash GL Posting Allowed Track Receivable _ Reversal Includes Charges Partial Reversal Allowed Switch Product Retail Lending Product PC Transaction Redemption Allowed You may select the following check boxes if you wish to have them in a product s Preferences screen e Partial Reversals allowed e Reversal Includes charges Reversal should reverse charges e Switch product Maintaining Charges for Non financial Transactions You can have the following non financial transactions charged Balance Enquiry e Cheque Book request e Mini statement request Ad hoc statement request You can facilitate the above service by first using the Retail Teller Product
13. 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 oe ORACLE 2 2 1 7 2 2 1 8 2 2 2 2 2 2 1 2 2 2 2 2 2 2 3 2 2 2 4 Accounting entries are same as that of Fund Transfer Ad Hoc Statement Generation Request Here the customer requests a Statement through the ATM This request is reaches 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 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 Note ATM transaction data will be handed off to Mantas for the branch as per the Mantas main tenance Transactions whose value date is same as t
14. DN 2 26 2 55 Batch Processes seen e etd 2 27 2 5 1 Maintaining Batches for Batch 5 2 27 295 2 Settlement Upload Eee TRO ped e 2 27 2 28 2 5 4 Viewing Transaction 22 9 2 30 2 62 Uploading Cards eer eter Gert P reb eei 2 30 2 7 Uploading 2 32 2 8 Processing ATM Cash 2 32 Annexure A VEI NIE LE MEM LE E 3 1 3 1 Switch Software and Card Transactions 3 1 3 2 1508583 Protocol Overview Ne 3 1 3 3 Switch Transaction eene 3 2 3 4 X Accounting Entries ATM Transactions mem 3 2 3 4 4 Accounting Entries for Cash Withdrawal 3 2 3 4 2 Accounting Entries for Balance 9 3 3 3 4 3 Accounting Entries for 3 4 3 4 4 Accounting Entries for Funds Transfer 3 5 3 5 Accounting Entries POS Purchase sss eene nennen 3 5 3 6 Balance File 3 8 37 Network Settlement Message 3 8 3 8 Merchant Settlement File 3 10 3 9 Maintaining SWTB PARAM Table ener 3 11 Function ID
15. Glossary ee 4 1 1 1 Introduction 1 Preface 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 Role Function Back office data entry Clerks Input functions for maintenance related to the interface Back office Managers Officers Authorization functions 1 3 Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http www oracle com pls topic lookup ctx acc amp id docacc t1 ORACLE 1 4 Abbreviations Abbreviation Description System Unless specified it shall always refer to Oracle FLEXCUBE CCY Currency SWITCH Switch Software BIN Bank Identification Number IMD International Member Descriptor OLTP Online Transaction Processing ATM Automatic Teller Machine POS Point Of Sale ISO International Organization for Standardization CMS Card Management System STAN System Trace Audit Number RRN Retrieval Reference Number Acquirer Bank that deploys ATM POS for acquiring transactions Issuer Bank that issues Cards to fa
16. Limit to be spending Switch should included should be stand in based on this definable field Footer Field Field Name sequence 1 No of Accounts 2 Check Digits 3 Time Stamp 3 7 Network Settlement Message Format The following table gives the format 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 2s ORACLE Field Sequence Field Name Size Remarks Optional Number 1 Message type n4 If it is optional original or rever sal is identified based on Trans action code 2 Card number n19 3 Branch code n3 4 Bank account ans number 28 5 Transaction ans M 05 Sale 06 Refund 07 Code 10 Cash Wdl 25 Sale reversal 26 Refund reversal 27 Cash wdl reversal Refer Transaction service derivation logic in ear lier sections 6 processing ans This is used for information code 6 pose 7 Transaction n22 M Refer Amount derivation logic Amount 8 Transaction n3 M Refer Amount derivation logic ccy 9 Settlement n22 Refer Amount derivation logic Amount 10 Settlement n3 Refer Amount derivation logic Currency 11 Billing Amount 22 Refer Amount derivation logic
17. ORACLE Switch Interface Gateway User Guide Oracle FLEXCUBE Universal Banking Release 12 0 87 1 0 Part No 56600 01 August 2014 Switch Interface Gateway User Guide August 2014 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use i
18. PROCESS FEE converted to a c CRP amp LGLTXN PROCESS FEE DRCUSTOMER A CFC CHARGES converted to a c ccy CRP amp LGLFC CHARGES R ONUS DRCUSTOMER A CTXN FEE converted to a c ccy CRNETWORK SUSPENSE GLTXN FEE DRCUSTOMER A CTXN PROCESS FEE converted to a c ccy CRNETWORK SUSPENSE GLTXN PROCESS FEE DRCUSTOMER A CFC CHARGES converted to a c ccy CRP amp LGLFC CHARGES During Network Settlement DRNETWORK SUSPENSE GL TXN FEE CRNETWORK NOSTRO A CTXN FEE converted to a c ccy DRNETWORK SUSPENSE GL TXN PROCESS FEE CRNETWORK NOSTRO A CTXN PROCESS FEE converted to a c ccy OFF US DRNETWORK SUSPENSE GLTXN FEE converted to setl ccy CRP amp LGLTXN FEE DRNETWORK SUSPENSE GLTXN PROCESS FEE converted to a c ccy CRP amp L GLTXN PROCESS FEE During Network Settlement DRNETWORK NOSTRO A CTXN FEE CRNETWORK SUSPENSE GLTXN FEE converted to a c ccy DRNETWORK NOSTRO A CTXN PROCESS FEE converted to a c ccy CRNETWORK SUSPENSE GL TXN PROCESS FEE Accounting Entries for Deposit ON US DRCASH GLTXN AMT CR CUSTOMER A CBILL AMT converted to a c ccy ORACLE 3 4 4 3 5 DRCUSTOMER A CTXN_FEE converted to a c ccy CRP amp LGLTXN_FEE DRCUSTOMER A CTXN PROCESS FEE converted to a c CRP amp LGLTXN_PROCESS_FEE DRCUSTOMER A CFC_CHARGES converted to a c ccy CRP amp LGLFC_CHARGES Accounting Entries for Funds Transfer ON US DR FROM A CBILL AMT converted to a c ccy A CTXN AMT converted t
19. PROV_ACC_SEND Y BLOCK_EXP_DAYS 30 MAX_RETRY_COUNT 5 FCC_ACC_FROM_SWITCH ONLY_PAN_FROM_SWITCH N If FOLLOW Y then for 200 MSG TYPE Amount Block is done for 220 MSG TYPE Parent message will be checked If FOLLOW N then for 200 and 220 MSG TYPE it will check if AMOUNT Y then all 200 and 220 MSG will perform amount block If SETL BEFORE FILE Y then all remote on us and off us transaction will perform Retail Teller transaction and accounting entries 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 LOG TABLE KEY is for making the primary key for ATM transaction If CHG ON BALENQ Y then for balance enquiry transaction if charge is defined then it will be deducted from the customer account If CHG ON ADSTMT Y then for adhoc statement transaction if charge is defined then it will be deducted from customer account If CHG ON MISTMT Y then for mini statement transaction if charge is defined then it will be deducted from customer account If CHG ON CHQBKc 7 Y then for cheque book request transaction if charge is defined then it will be deducted from customer account NO TXN MISTMT defines the number of latest transactions that should appear in a mini statement E g If NO_TXN_MISTMT 10 then the mini st
20. SUSPENSE GL TXN AMT converted to a c ccy DRNETWORK SUSPENSE GLTXN FEE converted to setl ccy CRP amp LGLTXN FEE DRNETWORK SUSPENSE GLTXN PROCESS FEE a c ccy CRP amp L GLTXN PROCESS FEE During Network Settlement DRNETWORK NOSTRO A CSETL AMT CRNETWORK SUSPENSE GL SETL AMT DRNETWORK SUSPENSE GL TXN FEE CRNETWORK NOSTRO A CTXN FEE converted to a c ccy DRNETWORK NOSTRO A CTXN PROCESS FEE a c ccy ds ORACLE CRNETWORK SUSPENSE GL TXN_PROCESS_FEE During Merchant Settlement DRMERCHANT SUSPENSE GLTXN AMT COMMISSION CRMERCHANT A C TXN AMT COMMISSION DRMERCHANT SUSPENSE GL COMMISSION CRP amp LGLCOMMISSION ORACLE 3 66 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 Sequence Field Name 1 No of Accounts 2 Check Digits 3 Time Stamp Body Field Size Sequence Field Name Characters Description 1 Branch code 3 Oracle FLEXCUBE branch code 2 Customer Account num 28 Account number ber 3 Account Currency 3 Account currency code alpha 6 Available balance This 22 Available balance represents the amount from Oracle FLEX available for withdrawal CUBE
21. 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 check boxes cleared e Allow Deferred Processing e Allow EOD with Deferred e Allow Delete Switch Interface Maintenance You must perform the following maintenances for the Oracle FLEXCUBE Switch system interface 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 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 28 ORACLE 2 4 2 Currency Definition Enter Query m Currency Code Alternate Currency Code Currency Name Currency Type ISO Numeric Currency Code Country EH Position General Decimals Ledger per Position Equivalent Interest Method 30 360 General L
22. You can invoke this screen by typing SWDFIDUP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button E Forwarding Institution ID Details Upload E New Enter Query File Name File Path Sequence Number Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details File Name Specify the name of the file to be uploaded File Path Specify the path from where the file gets uploaded Sequence No The system displays the sequence number for the uploaded transaction 2 26 ORACLE 2 5 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 2 5 4 Maintaining Batches for Batch Operations You can maintain the following batches for Batch Operations in the Batch EOD Function Inputs screen SWSWRECN Switch Reconciliation Batch SWDPRCRT Process Transaction Batch 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 BADEODFFE in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Batch EOD Function Inputs E New E
23. appropriate error 2 18 ORACLE 2 4 4 2 4 5 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 Channel Details FX New Enter Query Channel Details Channel Description Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify 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 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 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 218 ORACLE 2 4 6 by typing SWDFCLTL in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Process Code Mapping Details E53 Enter Query Details Proce
24. atement the latest 10 transactions will be displayed ISO VERSION has only three type of value 0 1 and 2 This gives the ISO 8583 message version 1987 0 1993 1 2003 2 NO_CHK_LEAVES defines the number of pages that should be in one cheque book Tig ORACLE ACC_STMT_PERIOD defines the duration of account statement period e g If ACC_STMT_PERIOD 1 then duration is 1 month 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 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 transaction MAX RETRY COUNT defines the number of times for Retail Teller transactions to try for a single transaction if it fails If FCC ACC FROM SWITCH Y then transaction account is same as Oracle FLEXCUBE account If FCC FROM SWITCH N then transaction account is card account not Oracle FLEXCUBE account If ONLY PAN FROM SWITCH 7 Y then transaction account is not mandatory in ISO request i e No need to give card account or Oracle FLEXCUBE account in request If ONLY PAN FROM SWITCH 7 N then in request transaction account is mandatory 915 ORACLE B BADEODFE 2 27 BADIDBAT
25. cilitate the Transactions IC Interest and Charges Oracle FLEXCUBE module EOC End of Cycle EOD End of Day SAF Store and Forward Msg Message Message Type Indicator PAN Primary Account Number IVR Interactive Voice Response 1 5 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 Annexure A briefs the account of the Switch software domain and Chapter 3 the components in a Cards Transactions Business network Ve ORACLE 1 6 1 7 Function ID Glossary has alphabetical listing of Function Screen ID s Chapter 4 used in the module with page references for quick navigation 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 SO documentation 1508583 protocol This manual is not included in Oracle FLEXCUBE User Manuals Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function Exit Add row Delete row Option List Refer the Procedures User Manual for
26. d clicking the adjoining arrow button Product Type Maintenance E Enter Query FLEXCUBE Literal Category Customer Category Network Acquirer Country Channel Product Code Input By Authorized By Modification Date Time Date Time Number L Authorized 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 maintained in the system Note 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 Network Select the network from
27. d clicking the adjoining arrow button intra Day Batch Monitor E search Ct Advanced Search 9 Reset Case Sensitive Branch E Function Status All Records per page 15 1 Of 1 Branch Function Status Error Reason Start Time Endtime End of Cycle Operations Event Sequence Number 2529 ORACLE 2 5 4 Viewing Transaction Monitor You can view a summary of transaction status 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 Enter Query 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 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 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 2 90 ORACLE Deb
28. edger Spot Days Tolerance Limit Foreign Exchange Index Base Currency Netting Days Settlement Days Cutoff Time Minute E Generate 103 Index Currency J New Cover format CLS Currency Euro Conversion Required Validate Tag 50F Rounding Amount Format Mask Euro Type Truncate 9 99 999 999 999 Euro Currency 99 99 99 99 999 IN Currency Out Currency Euro Closed PC Currency Country Mapping Fields Input By Authorized By Modification Wi Authorized Date Time Date Time Number open Maintaining Card Transaction Limits You can maintain card and currency wise transaction limits here You can invoke this screen by typing SWDCDTLM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Card Transaction Limits Card Type Card Description Limit Details 1 0f 1 Go POS Daily Transaction L Currency Code Daily Transaction Limit ATM Per Transaction Limit Daily Count Limit Date Time Maker Checker Mod No Date Time Record Status Authorization Status Specify the following Card Type Specify the type of card Card Description Give a brief description about the type of card 259
29. further details about the icons ra ORACLE 2 1 2 2 2 2 1 2 2 1 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 MasterCard 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 SWITCH system interface Se Format Messages 150 Format Messages FLEXCUBE UBS titi ti Lt lt sio XML Format Messages 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 Cash Withdrawal During a Cas
30. ght corner of the Application tool bar and clicking the adjoining arrow button Forwarding Institution ID Details EX New E3 Enter Query Forwarding Institution ID Description International Forwarding Institution Transaction Type Allowed Disallowed 101 FLEXCUBE Literal Description Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Forwarding Institution ID Specify the forwarding institution ID This ID will be based on Field No 33 of ISO 8583 compliant message Description Specify the description of forwarding institution International Forwarding Institution If you check this box then the forwarding institution is identified as International else it will be identified as Domestic Transaction Type Select the type of transaction The available options are e Allowed The forwarding institution is allowed to perform the list of transactions e Disallowed The forwarding institution is not allowed to perform the list of transactions By default system will display Disallowed 2 25 ORACLE FLEXCUBE Literal The system displays the FLEXCUBE Literal available for the ATM POS Description The system displays the description of the FLEXCUBE Literal In this screen you can perform the following operations e New e Enter Query e Save e Authorize e Copy e Close e Unlock e Print e De
31. h 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 E ORACLE Refer the Annexure chapter for the corresponding accounting entries 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 Include 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
32. he 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 Point Of Sale Transactions The following are the facilities provided for Point Of Sale POS Transactions 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 Annexure chapter for the corresponding accounting entries 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 Refund Accounting entries are similar to those of Cash Deposit Adjustments The Adjustments facility corresponds to Partial Reversals in ATM the difference being that Cr Adjustments are also possible oe ORACLE Accounting entries are same as that of POS purchase 2 2 2 5 Pre auth Comple
33. ir own Merchant Details For facilitating POS transaction you must maintain the Merchant Details in the screen as shown below 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 218 ORACLE 2 4 8 Merchant Details Enter Query Merchant Id Account Branch Account Number Input By Authorized By Modification Date Time Date Time Number Wi Authorized 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 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 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 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 2 16 ORACLE Terminal Details E New amp Enter Query Terminal ID Channel Originating Branch Cash General Ledger Number Merchant ID Terminal Address
34. it Card FCC Account Upload E Enter Query File Name File Path Intraday Sequence Number Input By Authorized By Modification Date Time Date Time Number Wi Authorized W 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 Number The system generates a sequence number for the upload transaction and displays it here 91 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 Terminal ID Upload E Enter Query File Name File Path Intraday Sequence No Input By Authorized By Modification Date Time Date Time Number Wi Authorized W 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
35. lete 2 4 17 Viewing Forwarding Institution ID You can view the domestic and international forwarding institution Identification Code in the Forwarding Institution ID Details Summary screen You can invoke this screen by typing SWSFRID in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Forwarding Institution ID Details Summary E gt search Ct Advanced Search Reset K Clear All Case Sensitive Authorization Status Record Status 1 Forwarding Institution ID ds per page 15 1011 Authorization Status Record Status Forwarding Institution ID Description International Forwarding Institution Transaction Type In the above screen you can base your queries on any or all of the following parameters and fetch records e Authorization Status e Record Status is ORACLE e Forwarding Institution ID Select any or all of the above parameters for a query and click Search button The records meeting the selected criteria are displayed System displays the following details pertaining to the fetched records e Authorization Status Record Status e Forwarding Institution ID e Description e International Forwarding Institution e Transaction Type 2 4 18 Uploading Forwarding Institution ID You can upload the domestic and international forwarding institution Identification Code in the Forwarding Institution ID Details Upload screen
36. n any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Cor
37. nce 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 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 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 98 ORACLE 3 1 3 2 3 Annexure A Switch Software and Card Transactions Business The following is a brief account of the Switch soft
38. nition E Enter Query Source Code Description Base Data From FLEXCUBE System Authorization Required Input By Authorized By Modification Date Time Date Time Number Wi Authorized Open In the above screen the Source Code FLEXSWITCH and the brief description of the source are maintained 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 GWDEXSYS9Q in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button zs ORACLE External Systems Enter Query External System Correlation Pattern External System Request Messageld Description Message Exchange Pattern Queue RequestMessage InputOnly Default Response Queue e Response Message FullScreen Dead Letter Queue XSD Validation Required F Register Response Queue Message Id External System Queues In Queue Response Queue 4 Fields FTP Parameters Input By Authorized By Modification Date Time Date Time Numbe
39. nter Query Batch End Of Day Functions Branch Code Function Description End of Cycle Group Transaction Input Report Orientation Not Applicable End of Transaction Input Portrait End of Financial Input Landscape End of Day Beginning Of Day Function Inputs 1041 Parameter Data Value Date Format Hm Fields Maker Date Time Mod No Checker Record Status Date Time Authorization Status 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 2 21 ORACLE 2 5 3 SWDUPLST the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Settlement Details New Enter Query Channel Category Switch Network Merchant Network Id File Name File Path Input By Date Time Authorized By Date Time Modification Number Mi Authorized 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 IVR Based on the channel specified the system will pick up the appropriate Retail Teller product
40. o a c DRFROM A CTXN_FEE converted to a c ccy CRP amp LGLTXN_FEE DRFROM A CTXN PROCESS FEE converted to a c CRP amp LGLTXN_PROCESS_FEE DRCUSTOMER A CFC_CHARGES converted to a c ccy CRP amp LGLFC_CHARGES Accounting Entries POS Purchase ON US DR CUSTOMER A CBILL AMT converted to a c ccy CRMERCHANT SUSPENSE GLTXN AMT DRCUSTOMER A CTXN_FEE converted to a c ccy CRP amp LGLTXN_FEE DRCUSTOMER A CTXN_PROCESS FEE in a c ccy CRP amp LGLTXN_PROCESS_FEE DRCUSTOMER A CFC_CHARGES converted to a c ccy CRP amp LGLFC_CHARGES During Merchant Settlement DRMERCHANT SUSPENSE GL COMMISSION a c CRMERCHANT COMMISSION a c DRMERCHANT SUSPENSE GL COMMISSION 858 ORACLE CRP amp LGLCOMMISSION Remote ON US DR CUSTOMER A CBILL AMT converted to a c ccy CRNETWORK SUSPENSE GLSETL AMT DRCUSTOMER A CTXN_FEE converted to a c ccy CRNETWORK SUSPENSE GLTXN_FEE DRCUSTOMER A CTXN PROCESS FEE alc CRNETWORK SUSPENSE GLTXN PROCESS FEE DRCUSTOMER CHARGES CRP amp LGLFC CHARGES During Network Settlement DRNETWORK SUSPENSE GL SETL AMT CRNETWORK NOSTRO A CSETL AMT converted to a c ccy DRNETWORK SUSPENSE GL TXN FEE CRNETWORK NOSTRO A CTXN FEE converted to a c ccy DRNETWORK SUSPENSE GL TXN PROCESS FEE CRNETWORK NOSTRO A CTXN PROCESS FEE a c ccy OFF US DR NETWORK SUSPENSE GLSETL AMT converted to a c ccy CRMERCHANT
41. on Fee The Description under CHARGE tab should be given as TXN FEE CHARGE2 must be the Transaction Processing Fee The Description under the CHARGE 2 tab should be given as PROCESS FEE 2 4 15 Service Charges for Inter branch Transactions In a transaction if the account branch of the teller transaction is different from the transaction branch then charges maintained by inter branch product will be applied to the transaction If the IB check box is checked for a product then the system will pick up and process the charge entries maintained at the IB product level During a transaction If IB product is not maintained and if the transaction branch is different from account branch then charges maintained in non ib product will be applied to the transaction IB Transaction Check this box if you want the system to pick up the product for inter branch transactions You will notice the difference in the service charges processed for two transactions with same kind of product 228 ORACLE Refer the chapter Maintaining Account Rate and Charge Details in the FCC_Host_Clearing user manual for detailed explanation of the fields in this screen 2 4 16 Forwarding Institution ID Details You can maintain the domestic and international forwarding institution Identification Code in the Forwarding Institution ID Details screen You can invoke this screen by typing SWDFWRID in the field at the top ri
42. ool bar and clicking the adjoining arrow button External System Functions Detailed Enter Query External System Description Function Action Service Name Operation Code Input By Authorized By Modification Date Time Date Time Number Wi Authorized Open 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 e Operation Code 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 field at the top right corner of the Application tool bar and clicking the adjoining arrow button 2 1 ORACLE 2 4 2 4 1 Upload Source Preferences Maintenance E Enter Query Source Code Module Code Error Handling On Exception Reject On Override Ignore Post Upload Status Authorized X Purge Days Calendar Allow Deferred Processing Allow EOD with Deferred Allow Delete Input By Authorized By Modification Date Time Date Time Number Wi Authorized Open Source Code
43. poration and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Contents 1 1 We i a e Ho CP re et Peu AER A 1 1 1 2 Auden E ier eter et e e iet p db es 1 1 1 38 Documentation Accessibility nennen 1 1 7 4 AbbteviatlOris Rete eet n eee t Re te Peto 1 2 1 2 1 6 Related Documents 4 ni reme pcm etate 1 3 ss 1 3 Switch Interface Gateway ppp 2 1 2 Introduction ice genet ER ba de eas 2 1 2 2 Interface Functionalities eerte denen nter nnn ntes 2 1 2 2 1 AIM Transactions ice E a igiene ben iet bus 2 1 2 2 2 Point Of Sale Transactions sese 2 3 2 2 3 IVR Transactions poo A no 2 4 2 3 Gateway Maintenance for Switch 01 82880 2 4 2 3 1 Maintaining Upload Source 2 4 2 3 2 Maintaining FLEXSWITCH External 2 5 2 3 8 Specifying External System 5 2 7 2 3 4 Specifying Source Preferences 21 002000000000000000 2 7 2 4 Switch Interface
44. pplicability from the adjoining drop down list The values available are e Default On choosing Default the system defaults the daily limit for ATM POS maintained at Card Transaction limit level e Special On choosing Special system allows to enter the daily limits for ATM POS manually 2 ORACLE Limits ATM Daily Transaction Limit Specify the daily transaction limit of the ATM ATM Daily Count Limit Specify the daily count limit of the ATM POS Daily Transaction Limit Specify the daily transaction limit of the POS POS Daily Count Limit Specify the daily count limit of the POS Note CASA account closure is validated if any active card mapping exists in the card to account mapping screen Utilization ATM Utilized Limit The system defaults the utilized limit wnen ATM Cash withdrawal transaction is posted ATM Utilized Count The system displays the utilized count when the ATM cash withdrawal transaction is posted POS Utilized Limit The system displays the utilized count when the POS transaction is posted POS Utilized Count The system displays the utilized count when the POS transaction is posted The above limits are updated for both ON US and Remote ON US transactions When any of the ATM POS transaction is reversed respective utilized limit count will also be updated accordingly Note If Daily transaction limit is lesser than the per transaction limit for both ATM POS then the system throws an
45. r W Authorized Open You must specify the following in the above screen External System and Description Specify the External System as FLEXSWITCH You may optionally give 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 QUEUE Dead Letter Queue Specify the dead letter queue as QEUEU XSD Validation Required Select this checkbox if the request xml and response xml has to be validated against the XSD Register Response Queue Message 14 Select this checkbox to register the response queue message ld External System Queues Give the External IN QUEUE and RESPONSE QUEUE for Switch 26 ORACLE 2 3 3 2 3 4 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 t
46. rovider Details Maintain the details of a utility provider in the Utility Provider Details screen You can invoke the Utility Provider Details screen by typing SWDUTLPR in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Utility Provider Details E New E Enter Query Utility Provider Id Description Account Branch Account No Maker Date Time Mod No Checker Date Time Record Status Authorization Status Utility Provider Id Specify the Utility Provider Id here Description Specify a brief description of the utility provider 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 postings will be done 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 For every transaction request the Oracle FLEXCUBE product is derived based on the Category Oracle FLEXCUBE literal and the Customer Category 2 18 ORACLE You can invoke the Product Type Maintenance screen by typing SWDPRMAP in the field at the top right corner of the Application tool bar an
47. s the self servicing devices like ATM POS and may have a switch system software and Interchange connections 1 ORACLE 3 3 3 4 3 4 1 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 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 Cards ATM POS Terminal Category of Transaction YOUR BANK Cards YOUR BANK On Us YOUR BANK Cards HSBC Remote On Us HSBC Cards YOUR BANK Off Us Accounting Entries ATM Transactions The following are the various accounting entries for ATM Transactions Accounting Entries for Cash Withdrawal Transactions ON US DR CUSTOMER A CBILL AMT converted to a c ccy CRCASH GLTXN AMT DRCUSTOMER A CTXN_FEE converted to a c ccy CRP amp LGLTXN_FEE DRCUSTOMER A CTXN PROCESS FEE converted to a c
48. ss Code Type FLEXCUBE Literal External Transaction Code Description Channel Details 1 Of 1 Channel Maker Date Time Checker Date Time Mod No 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 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 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 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 ae ORACLE 2 4 7 Network Details Enter
49. 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 amounts of Tanked Deposit Transactions in the ATM Cash Deposit Details screen 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 2 92 ORACLE ATM Cash Deposit Details Enter Query j Details Transaction Account Transaction Currency Transaction Amount Local Currency Amount Transaction Date Transaction Reference Actual Amount Charges Charge Currency Charge Currency 1 Charge Currency 2 Charge Amount Charge Amount 1 Charge Amount 2 Charge Description Charge Description 1 Charge Description 2 Charge Currency3 Charge Currency 4 Charge Amount 3 Charge Amount 4 Charge Description 3 Charge Description 4 Input By Authorized By Modification 1 Authorized Date Time Date Time Number Open You must validate the tanked deposit by specifying the actual transaction amount in the Actual Amount field O
50. t the top right corner of the Application tool bar and clicking the adjoining arrow button Card To FCC Account Mapping E New ES Enter Query ATM Debit Card Number Card Account Number Account Branch Account Number Currency Code Customer Name Card Type Limit Applicability Default Limits Utilization ATM Daily Transaction Limit ATM Utilized Limit ATM Daily Count Limit ATM Utilized Count POS Daily Transaction Limit POS Utilized Limit POS Daily Count Limit POS Utilized Count Maker Date Time Checker Date Time Mod No Record Status Authorization Status You must maintain the following mandatory fields in the above screen Card Number and Card Account Number Specify the card number and 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 Customer Name The system displays the name of the customer Currency The system displays the currency of the account Card Type The system displays the card type based on the Account currency maintained in the Card Transaction Limits maintenance screen Limit Applicability Select the limit a
51. the list of options available alongside Acquirer Country Select the country of the acquirer from the list of options available alongside 2549 ORACLE 2 4 11 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 the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Click the new button on the Application toolbar Note The system performs the action level access rights validation only on Save operation Amount Block Input New 3 Enter Query Account Block Details Branch Amount Block Number Account Effective Date Amount Expiry Date Amount Block FLEXCUBE Reference No Hold Code Hold Description Remarks Fields Maker Date Time Checker Date Time Mod No Record Status Authorization Status Account Number Specify the Oracle FLEXCUBE account number for blocking the amount This field is mandatory Amount 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
52. tion Pre auth completion involves removing amount block Accounting entries are similar to those of POS purchase Note 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 Re versed 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 Note IVR transaction data will be handed off to Mantas for the branch as per the Mantas main tenance 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 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 ES ORACLE 2 3 2 Upload Source Defi
53. ware domain and the components in a Cards Transactions Business network The following diagram illustrates the components in the switch network Interchanges VISA MasterCard ISO 8583 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 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 1508583 Protocol Overview 1508583 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 deploy

Switch Interface Gateway User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents