Home

Messaging System User Manual

1. 99B Number see qualifier descrip Alc 3 n O Count tion 19A Amount see qualifier descrip 4 c O tion N 3 a15d 70C Narrative Second Leg Narrative Alc 4 35x 16S End of Block REPO Mandatory Sequence E Settlement Details Field Field PEO Mandatory Tag Nam Field Description Format Optional 16R Start of Block SETDET M 22F Indicator see qualifier descrip 4 c 8c 4 c M tion 95a Party see qualifier descrip C P Q R orS M tion Repetitive Optional Subsequence E2 Cash Parties Field Field A ae Mandatory Tag Nain Field Description Format Optional 16R Start of Block CSHPRTY IM 95a Party see qualifier descrip P R QorS M tion 97A Account see qualifier descrip 4c 35x O tion 70a Narrative see qualifier descrip E DorC O tion 16S End of Block CSHPRTY M Mandatory Repetitive Subsequence E3 Amount Field Field n eer Mandatory Tag Name Field Description Format Optional 16R Start of Block AMT M 19A Amount see qualifier descrip Alc M tion N 3 a15d 16S End of Block AMT M 16S End of Block SETDET M 1399 ORACLE 13 6 7 13 6 7 1 13 6 8 Repetitive Optional Sequence F Other Parties Field Field r er Mandatory Tag Name Field Description Format Optional 16R Start of Block OTHRPRTY M 95a Party see qualifier descrip C P R QorS M tion 97A Account see qualifier descrip 4c 35x O tion 70a Nar
2. 19796 ORACLE Mandatory Sequence G Payment Instructions for Interest Payable by Party A Field Field Name Format Mannatory Tag Optional 15G New Sequence Empty M field 53a Delivery Agent AorD 56a Intermediary AorD 86a Second Intermedi AorD ary 57a Receiving Agent AorD M Optional Sequence H Amortizing Schedule for Party B Field Field Name Format Mandatory Tag Optional 15H New Sequence Empty M field 18A Number of Repetitions 5n M 30G Variable Notional Start and End Date 8 n 8 n 32U Outstanding Notional Currency and 3 a15d Amount 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M Optional Sequence Amortizing Schedule for Party A Field Field Name Format Mandatory Tag Optional 15l New Sequence Empty M field 18A Number of Repetitions 5n 30G Variable Notional Start and End Date 8 n 8 n 32U Outstanding Notional Currency and 3 a15d Amount 14A Business Day Convention 9a 18A Number of Repetitions 5n 22B Financial Centre Alc 13 57 ORACLE Optional Sequence J Exchanges of Principal Payable by Party B a Field Name Format oa 15J New Sequence Empty M field 18A Number of Repetitions 5n M 22X Type of Exchange Alc M 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 53a Delivery Age
3. a Field Name aa a 18A Number of Repetitions 5n M 30F Payment Date 8 n M 32M Currency Payment Amount 3lai5d O 17F Period End Date Adjustment Indicator 1 a O 14D Day Count Fraction 7X O 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M Optional Sequence F Floating Interest Payable by Party A o Field Name Format o e 15F New Sequence Empty M field 14F Floating Rate Option 24x M 37J Cap Rate 12d O 37L Floor Rate 12d O 37N Details of Interest 6 35x O Rate Optional Subsequence F1 Interest Details 13 55 ORACLE Field Field Name Format Mandatory Tag Optional 14J Reset Date Specification 5a M 14G Averaging Frequency and Method 1 a 8 a O 38E Designated Maturity 2n1 a M 18A Number of Repetitions 5n M 30F Payment Date 8 n M 17F Period End Date Adjustment Indicator 1 a M 14D Day Count Fraction 7X M 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M 37R Spread N 12d O Optional Subsequence F2 Compounding Details 7 Field Name oe Ked 22D Compounding Type Alc M 18A Number of Repeti 5n M tions 30X Compounding Date 8 n M Optional Subsequence F3 Interpolation for Stub Periods Er Field Name Format eee 38G First Stub Period Interpolation Period 2n1 a O 2n1 a 38H Last Stub Period Interpolation Period 2n1 a O 2n1 a
4. 138 ORACLE Mandatory Repetitive Sequence C Financial Instrument Account rieg Field Name Field Description Format Mandatory Tag Optional 16R Start of Block FIAC M 36B Quantity of Finan Quantity of Financial 4 c 4 c M cial Instrument Instrument to be settled 15d 95a Party Account Owner PorR 97a Account see qualifier description A or B 16S End of Block FIAC Optional Sequence D Two Leg Transaction Details Field Field aia Mandatory Tag Name Field Description Format Optional 16R Start of Block REPO M 98a Date Time see qualifier descrip A B orC O tion 22F Indicator see qualifier descrip 4 c 8c 4 c O tion 20C Reference see qualifier descrip 4 c 16x O tion 92a Rate see qualifier descrip A C or F O tion 19A Amount see qualifier descrip Alc O tion N 3 a15d 70C Narrative Second Leg Narrative 4 c 4 35x 16S End of Block REPO Mandatory Sequence E Settlement Details Field Field er Mandatory Tag Name Field Description Format Optional 16R Start of Block SETDET M 22F Indicator see qualifier descrip Alc 8c M tion Alc 13 88 ORACLE Mandatory Repetitive Subsequence E1 Settlement Parties ra Fid Field Description Format PE y 16R Start of Block SETPRTY M 95a Party see qualifier descrip C P Q R orS M tion 97a Account Safekeeping
5. MT 416 Advice of Non Payment Non Acceptance This message type is sent by the collecting bank to the remitting bank It may also be sent e tothe remitting bank via another financial institution e bya presenting bank to a collecting bank It is used to advise of non payment or non acceptance under a previously received collection or part thereof Maximum Length 10000 let ORACLE 13 5 4 1 Format Specifications 13 5 5 Mandatory Sequence A General Information Pied Field Name Format Mandatory Tag Optional 20 Sender s Reference 16x M 21 Related Reference 16x M 23E Advice Type Alc 30x O 51A Sending Institution 1 a 34x O Ala2 a2 c 3 c 53a Sender s Correspondent AorB O 71F Sender s Charges 3 a15d TTA Reason for Non Payment 20 35x Non Acceptance Mandatory Repetitive Sequence B Non Payment Non Acceptance Details Plg Field Name Format Mandatory Tag Optional 21A Related Sequence Reference 16x M 23E Advice Type Alc 30x O 21C Principal s Reference 35x O 32a Face Amount of Document s A B orK M 50D Principal 1 a f O 34x 4 35x 59 Drawee 34x O 4 35x 71F Sender s Charges 3 a15d TTA Reason for Non Payment Non 20 35x Acceptance MT 420 Tracer This message type is sent by the remitting bank to the collecting bank It may also be sent by a collecting bank to another collecting bank It is used to
6. TA ORACLE 14 3 1 14 3 1 1 14 3 1 2 14 4 14 4 1 14 4 1 1 Contents of Report The contents of the Unsuccessful Messages Report have been discussed under the following heads Header The Header carries the title of the Report information on the branch code the branch date the user id the module name the date and time at which the report was generated and the page number of the report Body Reference Number This is the reference number of the repair Repair Reason This is the reason for the repair Successful Messages Report You can generate Successful Messages report using Successful Messages Report screen To invoke the screen type MSRPLSUX in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The screen is displayed below Successful Messages Report ReportFormat PDF PrinterAt Client v Report Output Print Printer Contents of Report The contents of the Successful Messages Report have been discussed under the following heads Header The Header carries the title of the report information on the branch code the branch date the user id the module name the date and time at which the report was generated and the page number of the report ORACLE 14 4 1 2 Body 14 5 External Reference This is the external reference number of the contract FLEXCUBE Reference Number This is the Oracle FLEXC
7. Optional Sequence B Fixed Interest Payable by Party B Field Field Name Format Mangatory Tag Optional 15B New Sequence Empty M field 37U Current Fixed 12d M Rate 37P New Fixed Rate 12d O Optional Sequence E Fixed Interest Payable by Party A Fiela Field Name Format Mandatory Tag Optional 15E New Sequence Empty M field 37U Current Fixed 12d M Rate 37P New Fixed Rate 12d O Optional Sequence J Re exchange of Principal Payable by Party B To Field Name Format nA 15J New Sequence Empty M field 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD M 13 69 ORACLE Optional Sequence K Re exchange of Principal Payable by Party A a Field Name Format oea 15K New Sequence Empty M field 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD M Optional Sequence L Fee Payable by Party B se Field Name Format sea 15L New Sequence Empty M field 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary Aor
8. ssssssnsnnnnnnnnnnnnnnnnnnnnnnnnnunnnnnnnnnnnnnnnn nnana 13 1 TSM MOC CON EEEE L E AA syst tadece ates 13 1 13 2 Customer Payments and Cheques ccceccccecceeceeeeeeceeeeeeticieeeeeeeaeeeeeetieeeerenea 13 1 13 2 1 MT 103 Single Customer Credit Transfer ccccccccccesseeeteeenteeeeteeenneees 13 3 13 2 2 MT 103 Single Customer Credit Transfer eccecccccccsseeeeeentteeeeeeenaees 13 5 13 2 3 MT 110 Advice Of ChHOQue S cccccceeeceeeeeeteeeeeeeenteeeeeeeenaeeeeeeenaeeeeeseaaaes 13 7 13 2 4 MT 111 Request for Stop Payment of a CH qQUE 2 eccerceeeeeteeettes 13 7 13 2 5 MT 191 Request for Payment of Charges Interest and Other Expenses 13 8 13 3 Financial Institution Transfers sores amea A ETE TEE EE 13 8 13 3 1 MT 200 Financial Institution Transfer for its Own Account ccce 13 8 13 3 2 MT 202 General Financial Institution Transfer 0 cccccccseeecsenseeeeeeentaes 13 9 13 3 3 MT 203 Multiple General Financial Institution Transfer 1 0cccccccc0 13 10 13 3 4 MT 204 Financial Markets Direct Debit MeSSage cccceeeeeteeteee 13 11 13 3 5 MT 205 Financial Institution Transfer Execution 0 ssecceeneeeeeeeeteee 13 12 13 3 6 MT 210 Notice 0 Retov aes EE EEE 13 13 13 4 Treasury Markets Foreign Exchange Money Markets and Derivatives 13 14 13 4 1 MT 300 Foreign Exchange Contirmation ccccccccssseeeeeessteeeeeeeennaeees 13 14 13 4 2 MT 305 Foreign Currency Option C
9. When you initiate a short term loan involving the product an Initiation Advice will be triggered for generation Similarly if you make a repayment on the loan the liquidation advice defined for the event will be triggered for generation Note In this context advices and messages are commonly referred to as messages Depending on the product message customer details that you have set up Oracle FLEXCUBE determines the address and the media through which the message should be transmitted If a message is to be transmitted through mail it has to be printed If the message is to be transmitted through Telex you will have to enter the testword if it is required for the message The messages that are to be transmitted through media like Telex and SWIFT will be sent by the Media Control System MCS which is connected to the node in which the database of your branch is installed A message that is triggered for generation can be sent in the background or can be generated on line An outgoing message will be processed based on the preference that you state a ORACLE 8 2 Note The messages that are triggered by an automatic event like the generation of a tracer for an LC billing notice and delinquency notice for a loan etc will be put in the Outgoing Browser by the automatic function itself This is because events triggered by an automatic function do not require authorization Manual Generation of Outgoing Me
10. 13 52 ORACLE 14G Averaging Frequency and 1la 8 a O Method 38E Designated Maturity 2n1 a M 18A Number of Repetitions 5n M 30F Payment Date 8 n M 17F Period End Date Adjustment 1la M Indicator 14D Day Count Fraction 7X M 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M 37R Spread N 12d O 13 53 ORACLE Optional Subsequence C2 Compounding Details ae Field Name Ta a 22D Compounding Type Alc M 18A Number of Repetitions 5n M 30X Compounding Date 8 n M Optional Subsequence C3 Interpolation for Stub Periods Fielg Field Name Format Mandatory Tag Optional 38G First Stub Period Interpolation Period 2n1 a O 2nila 38H Last Stub Period Interpolation Period 2n1 a O 2nila Mandatory Sequence D Payment Instructions for Interest Payable by Party B Eels Field Name Format Mandatory Tag Optional 15D New Sequence Empty M field 53a Delivery Agent AorD 56a Intermediary AorD 86a Second Intermedi AorD ary 57a Receiving Agent AorD M Optional Sequence E Fixed Interest Payable by Party A i Field Name Format aaa 15E New Sequence Empty field M 37U Fixed Rate 12d O 37N Details of Interest Rate 6 35x O Optional Subsequence E1 Interest Details Taas ORACLE
11. 3 5 Select Add from the Actions menu in the Application tool bar or click add icon to add a message to the queue being defined To remove a message from the queue Select Delete from the Actions menu in the Application tool bar or click delete icon Refer to CN Module for more details on Collection Queue Maintaining Message Types You can maintain message types in Oracle FLEXCUBE through the Message Type Maintenance screen To invoke Message Type Maintenance screen type MSDMSTYP in the field at the top right corner of the Application tool bar and click the adjoining arrow button Message Type Maintenance E New E3 Enter Query Module Message Type Description Priority Normal Maximum Message Count Purge Message Acknowledgment Nak Processing Swift Messages For Product Setup SWIFT Message Type Generate at input Consolidated Message Type 7 Show in product Input By Authorized By Modification Date Time Date Time Number Wi Authorized E Open You will need to capture the following information in this screen Module Specify the module for which you are maintaining message types The adjoining option list displays all module codes available in Oracle FLEXCUBE You can select the appropriate one Message Type Specify the message type for which SWIFT codes can be maintained Description Enter a brief description of the message type Priority Specify the priority i
12. Maximum Length 2000 13 5 7 1 Format Specifications 13 6 13 6 1 Mandatory Repetitive Sequence A i Field Name Ries o 20 Sending Bank s TRN 16x M 21 Related Reference 16x M 32a Existing Maturity Date Currency Code Amount AorK O 33a Amended Maturity Date Currency Code Amount AorK O Optional Sequence B Field r Forma Mandatory Tag Piek Name t Optional 59 Drawee 34x O 4 35x 72 Sender to Receiver Informa 6 35x O tion 74 Amendments 6 35x O Securities Markets MT 517 Trade Confirmation Affirmation This message is sent by an instructing party e g client or its authorized representative to a financial institution which had previously sent a trade confirmation contract note This message is used to positively affirm the details of a previously received confirmation contract note This message binds the Sender and the Receiver of the message to the trade details contained in the confirmation being affirmed This message may be sent directly between the parties to the trade or via an ETC service provider Maximum Length 10000 13 75 ORACLE 13 6 1 1 Format Specifications Mandatory Sequence A General Information Pied Field Name Field Description Format Mandatory Tag Optional 16R Start of Block GENL M 20C Reference Sender s Message
13. 0 ccccccesseeeeessteeeeeeenaes 6 6 6 2 3 Viewing Customer Address cccccceeecteceeenteeteceenneeeeeeeeaeeeeesenaaeteeeneaaes 6 13 Maintaining Advice Formats ccccccecceeeeeeeeeeeeeeeeeneeeneeeeeeeeeeeeeeeeeeeeeeenens 7 1 fA WntrOductiOn a2 eee a Mie inhaled Moved ean as 7 1 7 2 Advice Format Maintenance Screen 0 0 0 eeeceeeeeeeeceeeeeeeeeeeeeeeeeeeeeeeeeseeeaaeeeeeeenanees 7 1 7 2 1 Indicating Messages that should Use Format ccccccsseeeeeestieeeeeeenaes 7 4 7 3 Automatic Printing of Advices Generated during EOD Processing 00ceeeee 7 5 7 3 1 Starting the Background PYLOCESS ccccececeeeeeteeeeeeeeeteeeeeeeetenaaeeeeeteenatees 7 5 03 2 PARNO OF AQVICES oea ea A E AS 7 6 Processing Outgoing Messages ssssssssssnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 8 1 8 1 Introduction mesiiuiininke e eii ait a i a aa a a A A 8 1 8 2 Manual Generation of Outgoing Messages 0 eee eeeeeeceeeeeeeeeeeeeeeeeeeeeteeenaeeeetennaeees 8 2 8 2 1 Performing Operations on an Outgoing Message cceieteeeentteeeeeeenee 8 4 8 2 2 Maintaining BIP Advice File Format 0 c cccsccccsceesseeeceeentteeeeeeentaeeeeeeeaas 8 8 8 2 3 Processing Outgoing Messages with PDE Trailes ccccscccecssseeeeeeneee 8 9 Retrieving an Archived Message s eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeneeeeeees 9 1 gT UNthOGUCtION Annaa a r a E uci acetate tii 9 1 9 2 Invoking Message History Retrieval Summary Sc
14. NO9 actions at NEFT Service Station to Bank Branches CREDIT_ACK Credit Acknowledgement Message for N10 NO02 and NO6 ACK_MSG_SFMS Acknowledgement message from SFMS F20 NEG_ACK_MSG Negative acknowledge message from F25 SFMS NEG_ACK_SUSR Negative acknowledge message from F26 SFMS User ACK_MSG_BKAPI Acknowledgement message from Bank F27 API Generate at input Check this box to indicate that this message is to be generated at the time of input of the contract and not after authorization ORACLE 3 5 1 Show in product Check this box to indicate that this message will be available in the product to be maintained against a particular event Querying for SWIFT Message Tag Description You can query for tag descriptions for SWIFT messages using the screen Swift Tag Maintenance screen You can invoke the screen by typing MSDMSGTM in the field at the top right corner of the Application tool bar and click the adjoining arrow button The screen is as shown below Swift Tag Maintenance E New Enter Query Swift Tag Maintenance Swift Message Type Description Tag Description 1 Of 1 E TagName Description TagOption Lines Sequence Repeatable All Options Sequence Name Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following fields Swift Tag Maintenance Swift Message Type Specify the swift message type The adj
15. 13 8 Documentary Credits and Guarantees 13 8 1 MT 700 Issue of a Documentary Credit This message is sent by the issuing bank to the advising bank It is used to indicate the terms and conditions of a documentary credit which has been originated by the Sender issuing bank The system follows the below STP process for incoming MT700 message 1 When the Advising Bank receives this message the system compares tag value of 20 in MT700 against the field Source Reference and checks for the existence of the Pre advice contract e Ifa contract does not exist then the system creates a new Export LC contract e If an inactive or unauthorized contract exists then the system moves MT700 message to a Repair status e Ifan active and authorized contract exists then the system amends the operation of the contract from PAD to ADV advice or ANC advice amp confirm Ifthe change is from PAD to ADV then the system triggers APAD event Ifthe change is from PAD to ANC then the system triggers APAC event 2 The system compares the common fields available in MT705 and MT700 Swift messages if the check box Pre advice Fields Validation on STP of 700 Required is checked e If the any of the fields in both the messages are different then the system moves the contract in Repair status which can be resolved and processed manually The system updates Mismatch between Pre advice and Operative LC as the
16. 3 5 4 Maintaining RTGS Messages The system will support the following RTGS payment messages Sr Message Product Transfer Network T Type Type Messa ype Message N Crom Outgoing rom Crom ge Description o Product incoming Product Product Name Category Category 1 RTGS Outgoing Outgoing Customer R41 This message will Payment be generated for outgoing pay ment contract to customer using RTGS product aie ORACLE RTGS Incoming Incoming Payment Customer R41 This is a Incom ing RTGS Pay ment to customer RTGS Outgoing Outgoing Payment Bank R42 This message will be generated for outgoing pay ment contract to bank using RTGS product RTGS Incoming Incoming Payment Bank R42 This is a Incom ing RTGS Pay ment to Bank RTGS Incoming Reject of Outgoing Payment Customer R42 This Message is for a return of our Outgoing Pay ment If the tag 7495 contains RETURN and outgoing pay ment reference number contains eg 7495 RETURN 012COPB112730 001 then itis a Reject of Outgo ing Payment oth erwise it is a Incoming Pay ment and prod uct can be resolved based on the network and Transfer type as Customer ORACLE RTGS Incoming Reject of Outgoing Payment Bank R42 This Message is for a return of our Outgoing Pay ment If the tag 7495 conta
17. Changing the Branch of the message 1 Select the message for which Branch has to be changed Change 2 Click on Change Branch button Branch The details of the message will be displayed with only the Branch field enabled Choose the new branch from the list of values provided and save the message Authorizing a Testword A telex message for which you entered a testword should be author ized before it can be routed to a user queue if you have specified so in the Branch Preferences screen TW Auth To authorize a test word that was entered for a telex message click the TW Auth button from the Browser on this screen During the authorization of a testword the authorizer will be required to re enter the testword 10 ORACLE Routing a message to a queue After you have made the checks that are necessary for the media through which a message is transmitted you can route the message to a user queue To change the queue in which an incoming message should be stored 1 Select the message 2 Click the Move to Queue button 3 Select a queue from the adjoining option list Move To Queue The message will be automatically moved to the queue that you spec ify The final destination of an incoming message is the end user queue These queues represent departments or printers responsible for acting on the received messages Once a message is lodged into an end user queue it can be viewed on scre
18. Inco Term APPLICABLE_RULE Applicable Rule BENEFICIARY Beneficiary APPLICANT Applicant REIMB_BANK Reimbursing Bank OLD_BEN Old Beneficiary before the amendment OLD_REM Old Reimbursing bank before the amendment OLD_ADV Old Advising bank before the amend ment APP_BANK Applicant Bank CLAIM_BANK Claiming Bank CNF_BANK Confirming Bank ADV_BANK Advising Bank ADV_THRU_BANK Advice Thru Bank LATEST_SHIPMENT_DA TE Latest Shipment Date SHIPMENT_PERIOD Shipment Period 11 15 ORACLE Message Substitution Variables Description CONFIRMED_AMT Confirmed LC Amount UNCONFIRMED_AMT Unconfirmed LC Amount AVAILED_AMOUNT Availed Amount REB_UT_AMOUNT Reimbursement Amount undertaken REB_NUT_AMOUNT Reimbursement Amount not undertaken DRAWER Drawer DRAWEE Drawee FORFAIT_HOUSE Forfaiting house bank REMIT_BANK Remitting Bank COL_BANK Collecting Bank DISC_BANK Discounting Bank NEGO_BANK Negotiating Bank TRF_BANK Transferee Bank BILL_AMT Bill Amount BILL_CCY Bill Currency OS_AMOUNT Bill Outstanding amount VALUE_DATE Bill Value date TRANSACTION_DATE Bill transactions date TRANSIT_DAYS Transit days BILL_TENOR Bill Tenor BILL_MATURITY Bill Maturity date LIQUIDATION_DATE Bill Liquidation date INCO_TERM Inco Term OUR_L
19. Maintaining Media Control Systems discusses details pertaining to Chapter 5 Media Control Systems Maintaining Addresses for a Customer discusses the procedure for Chapter 6 ee a maintaining addresses for the customers Chapter 7 Maintaining Advice Formats explains the procedure for maintaining advice formats Processing Outgoing Messages explains the procedure involved in Chapter 8 generating an outgoing message Chapter 9 Retrieving an Archived Message deals with the process of retriev ing archived messages Chapter 10 Processing Incoming Messages explains processing all incoming messages Chapter 11 Defining Free Format Messages explains process of defining free format messages Chapter 12 MakingQuery explains the query process Chapter 13 Processing SWIFT Messages explains about the SWIFT mes P sages and the categories supported in Oracle FLEXCUBE Chapter 14 P provides a list of reports that can be generated in this mod Function ID Glossary has alphabetical listing of Function Screen Chapter 15 i ae ID s used in the module with page references for quick navigation 1 5 Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function J Exit Add row E Delete row a Option List 1 6 Related Documents You may need to refer to any or all of the User Manuals while working on the Messaging module e Core Services ha ORACLE Core Entities Procedures Sett
20. O 57a Account With Bank AorD O 58a Beneficiary Bank A B o DJO 71B Details of Charges 6 35x O 72 Sender to Receiver Informa 6 35x O tion 73 Details of Amounts Added 6 35x O 13 5 2 MT 410 Acknowledgement This message type is sent by a collecting bank to a remitting bank to acknowledge the receipt of a collection It may also be sent by a collecting bank to another collecting bank 14 ORACLE 13 5 2 1 13 5 3 13 5 3 1 13 5 4 Unless otherwise expressly stated this message type states that the collecting bank intends to act in accordance with the collection instruction Maximum Length 2000 Format Specifications Field Field Name Format Mandatory Tag Optional 20 Sending Bank s TRN 16x M 21 Related Reference 16x M 32a Amount Acknowledged A B or M K 72 Sender to Receiver Informa 6 35x O tion MT 412 Advice of Acceptance This message type is sent by the collecting bank to the remitting bank It may also be sent by a collecting bank to another collecting bank It is used to inform the Receiver of the acceptance of one or more drafts under one collection instruction Maximum Length 2000 Format Specifications Field Field Name Format Mandatory Tag Optional 20 Sending Bank s TRN 16x M 21 Related Reference 16x M 32A Maturity Date Currency Code Amount 6 n3 a15d M Accepted 72 Sender to Receiver Information 6 35x O
21. Repair reason e If any field values are missing in a contract created out of MT705 message the system updates these values with those available in MT700 13 104 ORACLE 3 The system overwrites all the values of the contract with those available in MT700 message if the check box Pre advice Fields Validation on STP of 700 Required is unchecked Maximum Length 10000 13 105 ORACLE 13 8 1 1 Format Specifications Si Field Name Format n y 27 Sequence of Total 1 n 1 n M 40A Form of Documentary Credit 24x M 20 Documentary Credit Number 16x M 23 Reference to Pre Advice 16x O 31C Date of Issue 6 n O 40E Applicable Rules 30x 35x M 31D Date and Place of Expiry 6 n29x M 51a Applicant Bank AorD O 50 Applicant 4 35x M 59 Beneficiary 34x M 4 35x 32B Currency Code Amount 3 a15d M 39A Percentage Credit Amount Tolerance 2n 2n O 39B Maximum Credit Amount 13x O 39C Additional Amounts Covered 4 35x O 41a Available With By AorD M 42C Drafts at 3 35x O 42a Drawee AorD O 42M Mixed Payment Details 4 35x O 42P Deferred Payment Details 4 35x O 43P Partial Shipments 1 35x O 43T Transshipment 1 35x O 44A Place of Taking in Charge Dispatch from 1 65x O Place of Receipt 44E Port of Loading Airport of Departure 1 65x O 44F Port of Discharge Airport of Destination 1 65x 44B Place of Final Destination For Transporta 1 65x t
22. Step 2 Click the And button Repeat step one with criteria Field as Branch Operator being Equal To and London under Value Click the Accept and Add buttons in the sequence described in Step 1 Step 3 Click the And button Repeat step one for Field with the criteria value as Message Type Then select Debit message under Value clicking the Accept and Add buttons in the sequence described for the first criterion Step 4 To cull out details of the debit advices involving these three customers click the And button Repeat Step 1 with the Field as Name Select say Ms Keturah Smith under Value Then click the accept button To select another customer click the Or button and then click Name in the Fields list specify the Operator as Equal To and pick out the customer name Mr Silas Reed from the Value option list then click the Accept button Repeat the process for the third customer Ms Wendy Klien Step 5 The query that you have made is displayed on the Query screen MODULE LC AND BRANCH LONDON AND MSG_TYPE DR_ADV AND NAME SILAS REED OR NAME KETURAH SMITH OR NAME WENDY KLIEN Check it for correctness and click Ok button to see the query through The Outgoing Message Browser will display details of all the debit advices generated for the LC module from your branch at London to the three customers that you specified 28 ORACLE 12 5 12 6 Ordering Det
23. Swift Message Type Hold Release Status Acknowledgement Status Authorization Status Delivered Status Click Search button The system identifies all outgoing messages satisfying the specified criteria and displays the following details for each outgoing message Branch Document Number Reference Number Module Message Type Receiver Currency Amount Media Swift Message Type Node Priority Customer Name Address Address2 Address3 Address4 Location Message Status Testword Exception Running number Hold Release Status Test Amount Test date Test Currency Test word Narrative Acknowledgement Status Hold Mail External Reference Delivery By RTGS Network Entry By Maker Date Stamp Authorized By ORACLE e Checker Date Stamp e Authorization Status e Once Authorized e Modification Number e DCNLIST e Bulk e Selected e Testing Status e Any or Original e Original DCN e Delivered Status RTGS Network will be defaulted for the following message types CUST_TSFR_RTGS BANK_TSFR_RTGS COVER_RTGS DIRDR_RTGS RTGS Message type and its description are shown in the table below SWIFT Message Description g P Message CUST_TSFR_RTGS Used when a Pay message generation is MT 103 for a corporate and sent through the RTGS Network BANK_TSFR_RTGS Used when a message belongs to an MT 202 interbank deal and sent through the RTGS Network DIRDR_RTGS Used when a direct debit me
24. e if the reference in the Tag20 of the incoming MT760 message is same as the reference captured against the applicant bank in the guarantee contract e value in the Tag 23 of the incoming MT760 message linked to the contract is Request for the contracts where the product type is G e value in the Tag 23 of the incoming MT760 message linked to the contract is Issue when the product type of the Guarantee contract is A An error message is displayed if the above validations fail during linking of an incoming MT760 message to guarantee contract After linking the incoming MT760 message will be displayed in the All Messages sub system of the linked Guarantee contract 12 ORACLE 10 2 5 Operations that you can perform on an Incoming Message Viewing and deleting the contents of a message 1 To view the contents of an incoming message View Delete 2 Highlight the message you want to view and 3 Click the View Message button on the Browser 4 The contents of the message will be displayed in a separate screen Printing a message You can choose to print the details of an incoming message To print the details of an incoming message Print 1 Highlight the message you want to print and 2 Click the Print button on the Browser When you select the print option you will be prompted to indicate whether you want to spool or directly print the message You can also view the SWIFT tag description
25. 16S End of Block SETDET Repetitive Optional Sequence F Other Parties a Tad Field Description Format P 16R Start of Block OTHRPRTY M 95a Party see qualifier descrip C P R QorS M tion 97A Account see qualifier descrip 4c 35x O tion 13 92 ORACLE 13 6 6 13 6 6 1 70a Narrative see qualifier descrip E DorC O tion 20C Refer Reference 4c 16x O ence 16S End of Block OTHRPRTY M MT 543 Deliver Against Payment This message is sent by an account owner to an account servicer account servicing institution The account owner may be a global custodian which has an account with its local agent sub custodian or an investment management institution or a broker dealer which has an account with their custodian This message is used to instruct a delivery of financial instruments against payment It may also be used to request a cancellation or pre advise an instruction Maximum Length 10000 Format Specifications Mandatory Sequence A General Information Field Field Name Field Description Format Mandatory Tag Optional 16R Start of Block GENL M 20C Reference Sender s Message Refer Alc 16x M ence 23G Function of the Message Alc 4 c 98a Date Time Preparation Date Time A C or E 99B Number see qualifier description Alc 3 n O Count Optional Repetitive Subsequence A1 Field Field Field Forma Man
26. 32M Currency Payment Amount 3 a15d M 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD O 13 59 ORACLE Optional Sequence N Optional General Information Field Field Name Format Mandatory Tag Optional 15N New Sequence Empty M field 29A Contact Information 4 35x O 24D Dealing Method Alc 35x O 88a Broker Identification AorD O 71F Broker s Commis 3 a15d O sion 21G Broker s Reference 16x O 13 4 11 MT 362 Interest Rate Reset Advice of Payment This message is exchanged by or on behalf of the financial institutions Party A and Party B who have agreed to a single or cross currency interest rate derivative transaction including caps collars and floors This message may be used to e advise the details of the determination of the floating interest rate s e advise the details of the payment of interest at the end of an interest period e cancel a previously sent reset advice e correct errors in a previously sent reset advice Maximum Length 2000 13 60 ORACLE 13 4 11 1 Format Specifications Mandatory Sequence A General Information a Field Name Format Bonn 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Typ
27. Advanced Search x Fields s Query Authorization Status Operator value To Record Status Branch Code Account Account Description Customer No Currency Query Account Class i sane O Fields Operator Value No Credits Stop Payments Dormant Account Open Date Alternate Account Number Cheque Book Passbook ATM Account Number Order By Account Type ii Frozen Ascending MT110 Reconciliation Required Order By Project Account Query O Fields Value Clear Query A v Eel idl Procedure The Query screen will display all the fields that appear in the messaging module These fields form the criteria based on which you can make a query If you do not wish to carry the query through click Clear Query button The query screen is cleared and you can proceed to make a new query 12 1 ORACLE 12 3 12 4 Making Query based on more than one criterion Suppose you want to obtain information based on more than one criterion For example you may want to view the details of all the guarantees generated for the Letters of Credit module from your branch located at London Procedure The procedure to make such a query involves the following steps Accept The Accept button And The And button Step 1 Select Module under Fields and then from the Operator drop down list choose Equal To and LC under Value Then click the Accept button Step 2 Click the And but
28. Category 2 MT pay ments Tre ORACLE 11 5 INVS Investigation Used when charges are being assessed for investigation or request for information required to complete payment pro cessing NSTP Non STP Charge for a payment that required an intervention during charge processing OURC OUR charg Claim is being submitted in response to receiving a cus ing option tomer payment Category 1 MT payment with OUR in field used 71A Details of Charges Template ID Select template id from the option list On clicking P button the template details are defaulted into field 79 by resolving the substitution variables You can modify the fields under Tag 79 While modifying the message you have to specify the values directly and not the substitution variables again Click Import button to import the file and display the format of the message on the screen Save the record after specifying the mandatory details and click Exit or Cancel button to return to the Application Browser Maintaining SWIFT FFT Template System has the facility to create SWIFT templates for free format messages with the help of resolver for predefined variable fields for example amount applicant beneficiary name tenor maturity etc This helps avoiding predation of message which are repetitive in nature for example bill acceptance message availment confirmation or payment tracers etc A dictionar
29. Operation Select valid mode of operation for which you want to generate the report from the adjoining drop down list 1e ORACLE 14 2 1 14 2 1 1 14 3 Operation Date Select operation date of the selected operation for which you want to generate the report from the adjoining calendar Contents of Report The parameters specified while generating the report are printed at the beginning of the report The contents of the SMS Log Report have been discussed under the following heads Header The Header carries the title of the Report information on the branch code the branch date the user id the module name the date and time at which the report was generated and the page number of the report Body Branch This is the branch code Document Refer This is the document control number generated by the system ence User ID This is the user ID Date This is the date of the log Operation This is the type of operation Receiver This is the name of the receiver Currency This is the currency Amount This is the amount Terminal ID This is the terminal ID Unsuccessful Messages Report To invoke the Upload Exception screen type MSRPLEXP in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The screen is displayed below Upload Exception ReportFormat PDF PrinterAt Client w Report Output Print Printer
30. be Reschedule If it is a Reschedule mes sage then system will update only the mes sage status of the contract as Resched uled RS This reschedule message normally will be com ing in during the day Our scheduler will pick up this message and resend it to net work for next sched ule ou ORACLE NEFT Incoming Reject of Customer NO9 This Message is from Outgoing SFMS for a return of Payment our Outgoing Pay ment There are two Possibilities of this Message it can be a Reject of the Outgo ing Payment or a Reschedule Message to Find out whether itis a Reject mes sage Check the Related Reference Number and Reject Codes if the Reject code doesn t fall into the Reschedule list then it is a reject of Outgoing Payment and message status will be updated as Processing Failed XE other wise it will be a Reschedule Message and message status will be updated as Rescheduled RS NEFT Incoming Workflow NO9 This Message is from SFMS for a resched Resched ule of our Outgoing ule Payment The reject code type of this message will be Reschedule If it is a Reschedule mes sage then system will update the message status as Resched uled RS and system will resend the mes sage to the network on next working day NEFT Incoming Workflow F20 This is an acknowl edgement message from SFMS If this message is received then the message stat
31. button to authorize the message All the amendments made to a SWIFT payment message have to be authorized by a user with appropriate authorization rights At the time of authorizing Oracle FLEXCUBE will display the earlier version of the SWIFT payment mes sage along with the amended version in the same window A list of all the errors due to which the message was marked for repair is also displayed The authorizer can view all the errors and also verify the changes that were made to correct them After verification if all the Authorize details are found to be appropriate the message is authorized Oracle FLEXCUBE maintains a detailed audit log of all amended SWIFT Payment Messages The following details are captured for each authorized message e User ID of the person who authorized the amendments e Date and time of authorization At any point during the verification and authorization process the authorizer can choose to cancel the entire operation without changing the status of the message Force Releasing Messages Use Force Release button to forcibly release all Payment Message Transactions with Funding Exception status and insufficient funds In Force other words the system will post the required accounting entries for such transactions regardless of insufficient funds in the accounts How ever an override will be displayed The system will also maintain a detailed audit trail for such transactions A user wi
32. e BC e MS e LI e B R ORACLE 3 5 2 1 Contract Reference Specify the contract reference number The adjoining list displays a list of reference numbers maintained in the system Choose the appropriate one Once you have set the search parameters click Execute Query button The system displays the messages that satisfy the search criteria Viewing Message Advice Select a message advice and click View button to view the complete message advice The system will display the following details in a new window Message enter Query Reference Number OOOELAT110040017 ReceiverSender 006005877 DCN 00074266621 Message Type LC_ACK_AMND Version Number SWIFT Message Type 730 10f 1 Message _NON OPERATIVE COPY __ Instance Type and Transmission Original Received from Application Outgoing Draft Priority Delivery Normal Message Header Swift Input FIN 730 Acknowledgement Sender Swift address APACGB61001 Receiver Swift address CITI BANK CITIGB87 User Header Message User Reference 00074266621 Message Tex 20 Senders Reference O00ELAT110040017 21 Receivers Reference FHFHFH 30 Date of Message Being Acknowledged 110104 Remarks Reject Reason Message Trailers You can view the following details e Reference number of the message advice e Document number generated for the message advice e Version number of the mes
33. e The number of days for which outgoing messages should be kept in the browser e Whether a test word is required for telex messages e The activities on a message that require authorization e The PDE Functional Validation archive period e The Text for hold mail and duplicate check Note You can specify preferences only for the branch from which you logged onto Oracle FLEX CUBE Capturing Messaging Branch Parameters Mainte nance screen To invoke the Messaging Branch Parameters Maintenance screen type MSDPREF in the field at the top right corner of the Application tool bar and click the adjoining arrow button If you are maintaining preferences for a new branch of your bank click the New button on the Application toolbar The Messaging Branch Parameters Maintenance screen is displayed without any details If you are calling a branch preference record that has already been defined double click a record of your choice from the summary screen In the Summary screen all the branch preference records that you have entered will be displayed in a tabular form s ORACLE 3 3 The screen is shown below Messaging Branch Parameters Maintenance E New E Enter Query Branch Preference Branch TestWord check Yes Message Archive Period No PDE Archive Period Text for Duplicate Hold Mail Text SK Arrangement No Validation M PDE Functional Validation Authorization jy
34. 12d M 37P New Fixed Rate 12d Optional Sequence E Fixed Interest Payable by Party A Fee Field Name Format Mandatory Tag Optional 15E New Sequence Empty M field 37U Current Fixed Rate 12d 37P New Fixed Rate 12d Optional Sequence L Fee Payable by Party B ried Field Name Format Mahdatoly Tag Optional 15L New Sequence Empty M field 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD M Optional Sequence M Fee Payable by Party A ried Field Name Format mandatary Tag Optional 15M New Sequence Empty M field 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 13 66 ORACLE 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD M 13 4 13 MT 365 Cross Currency Interest Rate Swap Termination Recouponing Confirmation This message is exchanged by or on behalf of the institutions or corporates party A and party B which have agreed to the termination partial termination or recouponing of a cross currency interest rate swap The terminated recouponed transaction is covered by a BBAIRS ISDA or another bilateral agreement The message may be used to confirm the details of the partial or full ter
35. 32A Original Facility Amount 6 n3 a15d M 13 99 ORACLE Mandatory Repetitive Sequence B Specification of the Drawing and Related Data ra Field Name Format Sa 26a Drawing Identification NorP M 31F Interest Period 6 n 6 n 35x M 33B Receiver s Participation 3 a15d O 36 Exchange Rate 12d O 37G Basis Rate N 12d M 37M Interest Margin N 12d O 37R Reserve Interest N 12d O 37a Total Interest Rate A B C D E orF O 34a Differential Amount PorR O 57a Account With Institution A B or D O 72 Sender to Receiver Information 6 35x O 13 7 3 MT 645 Notice of Fee Due This message type is sent by the agent of the facility to the signatories thereto or to the parties to the offer It specifies flat and variable fees payable on the same date which are due to the Receiver Maximum Length 2000 13 100 ORACLE 13 7 3 1 Format Specifications Mandatory Sequence A Identification of the Facility and Flat Fees a Field Name Format ahaa 20 Transaction Reference Num 16x M ber 21 Related Reference 16x O 29A From 4 35x O 29B To the Attention of 4 35x O 88D Borrower s 1 a M 34x 4 35x 32A Original Facility Amount 6 n3 a15d M 71B Flat Fees 6 35x Optional Repetitive Sequence B Variable Fees i Field Name Format sahis 23 Type of Fee 16x M 31F Fee Period 6 n
36. 6 In a distributed environment the database of a branch is located in a node or server The MCS of the messages are also installed in a node Thus while defining an MCS you need to also indicate the node in which it is installed Features Provided for Processing of Incoming Mes sages In case of incoming messages you can set up of various message queues and direct incoming messages to them You can further grant selective access to the queues to personnel at your bank who are authorized to handle incoming messages Archival and Retrieval of Information Archival is the process of storing old messages for future retrieval While defining messaging preferences for your branch you can specify the number of days for which an outgoing message should be kept in the Outgoing Message Browser Messages will be automatically archived after the number of days specified for your branch You can retrieve the messages that have been archived at anytime and process them just as you would any other message Set up Messaging Preferences You can specify messaging preferences that will govern the workflow aspects of the messaging system module at your branch You can indicate the following preferences e The number of days for which outgoing messages should be kept in the Browser for every branch e Whether a testword is required for Telex messages e The activities on a message that require authorization e The PDE Possible Duplication E
37. 6 n 35x M 33B Computation Base Amount 3 a15d O 34B Fee Amount 3 a15d M 37a Fee Rate A B C D E or F O 72 Sender to Receiver Informa 6 35x O tion Mandatory Sequence C Summation of Fees a Field Name Format ea 71C Summary of Variable Fees 6 35x O 33A Total Fees 6 n3 a15d M 34A Amount to be Transferred 6 n3 a15d O 57a Account With Institution A B or D O 72 Sender to Receiver Informa 6 35x O tion 13 101 ORACLE 13 7 4 MT 646 Payment of Principal and or of Interest 13 7 4 1 This message type is sent by the agent of a facility to the providers of funds It provides advice of payments and or prepayments of principal and or payment of interest on the same value date which are not related to any subsequent drawing or renewal It specifies to the Receiver the amount with respect to principal and or interest Maximum Length 2000 Format Specifications Mandatory Sequence A Identification of the Facility Field Name Format e 20 Transaction Reference Num 16x M ber 21 Related Reference 16x O 23 Further Identification 16x M 29A From 4 35x O 29B To the Attention of 4 35x O 88D Borrower s 1 a 34x M 4 35x 32A Original Facility Amount 6 n3 a15d M 26P Drawing Identification 3 a 4x O Mandatory Repetitive Sequence B Interest Calculation Si Field Name Format a 31F Interest Period 6 n 6 n 35x O 33B Computation Base Amou
38. Account AorB 16S End of Block SETPRTY Optional Repetitive Subsequence E3 Amount na Faad Field Description Format e 16R Start of Block AMT M 19A Amount see qualifier descrip 4 c M tion N 3 a15d 16S End of Block AMT 16S End of Block SETDET Repetitive Optional Sequence F Other Parties Field Field et Mandatory Tag Name Field Description Format Optional 16R Start of Block OTHRPRTY M 95a Party see qualifier descrip C P R QorS M tion 97A Account see qualifier descrip 4c 35x O tion 70a Narrative see qualifier descrip E DDorC O tion 20C Reference Reference 4c 16x 16S End of Block OTHRPRTY 13 6 5 MT 542 Deliver Free This message is sent by an account owner to an account servicer account servicing institution The account owner may be a global custodian which has an account with its local agent sub custodian or an investment management institution or a broker dealer which has an account with their custodian This message is used to instruct a delivery of financial instruments free of payment It may also be used to request a cancellation or pre advise an instruction 1389 ORACLE Maximum Length 10000 13 6 5 1 Format Specifications Mandatory Sequence A General Information i Field Name
39. Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD O 13 48 ORACLE Optional Sequence M Additional Amounts Payable by Party A Ta Field Name Format an 15M New Sequence Empty M field 18A Number of Repetitions 5n M 22E Type of Payment Alc M 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M 53a Delivery Agent Aor D O 56a Intermediary AorD O 86a Second Intermediary Aor D O 57a Receiving Agent AorD O Optional Sequence N Optional General Information i Field Name Format Sen 15N New Sequence Empty M field 29A Contact Information 4 35x O 24D Dealing Method Alc 35x O 88a Broker Identification AorD O 71F Broker s Commission 3 a15d O 21G Broker s Reference 16x O 13 4 10 MT 361 Cross Currency Interest Rate Swap Confirmation This message is exchanged by or on behalf of the institutions or corporates party A and party B which have agreed to a cross currency interest rate swap covered by a BBAIRS British Bankers Association Interest Rate Swap Deutscher Rahmenvertrag f r Finanztermingesch fte or an ISDA International Swaps and Derivatives Association Master Agreement The message also
40. Correspondent AorB O 54A Receiver s Correspondent 1 a 34x Ala2 a2 c 3 c 55A Third Reimbursement Institu 1 a 34x O tion Ala2 a2 c 3 c 56A Intermediary Institution 1 a 34x O Ala2 a2 c 3 c 57A Account With Institution 1 a 34x O 4 a2 a2 c 3 c 59a Beneficiary Customer No letter option or M A 70 Remittance Information 4 35x O T1A Details of Charges 3la M T1F Sender s Charges 3 a15d O 71G Receiver s Charges 3 a15d O 72 Sender to Receiver Information 6 35x O 77B Regulatory Reporting 3 35x O The differences between MT 103 and MT 103 messages are as follows e Appropriate MT 103 format validation is triggered by the code STP in the validation flag field 119 3 119 STP of the user header of the message block 3 e In MT 103 message fields 52 54 55 56 and 57 may only be used with letter option A 13 6 ORACLE e In MT 103 message field 53 may only be used with letter options A and B e Field 51A is not used in MT 103 This message may only be used on the FIN SWIFT network since it requires special validation e Field 23E may only contain codes CORT INTC SDVA and REPA in MT 103 e If field 53a is used with option B in MT 103 message then the Party Identifier must be used e For MT 103 message subfield 1 Account of either field 59 or 59A is always mandatory e In MT 103 message code INS must be followed by a valid BIC for Field 72 e In MT 103 message codes REJT RET
41. Date Time Checker Date Time Mod No Record Status Authorization Status In this screen you can specify the following details Branch Code Specify the branch code for which the task creation has to be made This adjoining option list displays all valid branches maintained in the system You can choose the appropriate one Branch Name On selecting the branch code the system defaults the branch name of the bank 19 13 ORACLE SWIFT Msg Type Specify the type of the SWIFT Message here This adjoining option list displays all the SWIFT messages that are maintained in the system You can choose the appropriate one Direct Check this option to indicate that a MT task business task should be created for the SWIFT message without subjecting it to the STP process This is applicable for STP messages If this option is checked for Non STP messages then a MT task will be created for the Non STP messages STP Error Flag Check this option to indicate that a MT task business task should be created when the STP process fails This is applicable only for the STP Messages STP Hold Flag Check this box to indicate that a MT task business task should be created for a contract that is put on hold during successful STP processing This option is applicable only for the STP messages UnAuthorized Check this box to indicate that a MT task business task should be created for a contract that is unauthorised during successful STP pro
42. Date Time see qualifier A B or C O description 22F Indicator see qualifier 4 c 8c 4 c O description 20C Reference see qualifier 4 c 16x O description 92a Rate see qualifier A C orF O description 99B Number see qualifier 4 c 3 n O Count description 19A Amount see qualifier 4 c O description N 3 a15d 70C Narrative Second Leg Narra 4 c 4 35x O tive 16S End of Block REPO M MT 540 Receive Free This message is sent by an account owner to an account servicer account servicing institution The account owner may be a global custodian which has an account with its local agent sub custodian or an investment management institution or a broker dealer which has an account with their custodian 13 82 ORACLE This message is used to instruct a receipt of financial instruments free of payment It may also be used to request a cancellation or pre advise an instruction Maximum Length 10000 13 6 3 1 Format Specifications Mandatory Sequence A General Information Field Field a ay Mandatory Tag N me Field Description Format Optional 16R Start of Block GENL M 20C Reference Sender s Message Refer 4 c M ence 16x 23G Function of the Message Alc 4 c 98a Date Time Preparation Date Time A C or E Optional Repetitive Subsequence A1 Field Field Name Field Description Format Mandatory Tag Optional 16R Start of Bloc
43. Field er Mandatory Tag Name Field Description Format Optional 16R Start of Block CONFPRTY M 95a Party see qualifier descrip P Q R orS M tion 97a Account see qualifier descrip AorB O tion 98a Date Time Processing Date Time AorC 20C Reference Processing Reference 4 c 16x 70a Narrative see qualifier descrip CorE tion 22F Indicator see qualifier descrip Alc 8c 4 c O tion s16S End of Block CONFPRTY M 118 ORACLE End of Subsequence B1 Confirmation Parties Field Field Name Field Description Format Mandatory Tag Optional 36B Quantity of Finan Quantity of Financial A4 c 4lc 15d M cial Instrument Instrument Confirmed 35B Identification of the ISIN1 e12 c M Financial Instrument 4 35x Optional Subsequence B2 Financial Instrument Attributes Field Field Name Field Description Format Wandararyi Tag Optional 16R Start of Block FIA M 94B Place Place of Listing 4 c 8c 4 c O 30x 22F Indicator see qualifier descrip 4 c 8c 4 c O tion 12a Type of Finan see qualifier descrip A B or C O cial Instrument tion 11A Currency Currency of Denomi 4 c 3 a O nation 98A Date Time see qualifier descrip 4 c 8 n O tion 92A Rate see qualifier descrip 4 c N 15d O tion 13a Number Identifi see qualifier descrip AorB O cation tion 17B Flag see qualifier descrip 4 c 1 a O ti
44. LC_CCY LC Currency LC_LIABILITY LC Outstanding Amount ISSUE DATE LC Issue Date LC_TENOR LC Tenor EXPIRY_DATE LC Expiry Date EXPIRY_PLACE LC Expiry Place CLOSURE_DATE LC Closure Date LC_CONTRACT_REF LC Contract Reference Number LC_USER_REF LC User Reference Number SHIPMENT_FROM Shipment From SHIPMENT_TO Shipment To PORT_LOADING Port of Loading PORT_DISCHARGE Port of Discharge CREDIT_AVL_WITH Credit Available with INCO_TERM Inco Term APPLICABLE_RULE Applicable Rule BENEFICIARY Beneficiary APPLICANT Applicant REIMB_BANK Reimbursing Bank OLD_BEN Old Beneficiary before the amendment OLD_REM Old Reimbursing bank before the amendment 11 12 ORACLE Message Substitution Variables Description MT499 OLD_ADV Old Advising bank before the amend ment APP_BANK Applicant Bank CLAIM_BANK Claiming Bank CNF_BANK Confirming Bank ADV_BANK Advising Bank ADV_THRU_BANK Advice Thru Bank LATEST_SHIPMENT_DA TE Latest Shipment Date SHIPMENT_PERIOD Shipment Period CONFIRMED_AMT Confirmed LC Amount UNCONFIRMED_AMT Unconfirmed LC Amount AVAILED_AMOUNT Availed Amount REB_UT_AMOUNT Reimbursement Amount undertaken REB_NUT_AMOUNT Reimbursement Amount not undertaken DRAWER Drawer DRAWEE Drawee FORFAIT_HOUSE Forfaiting h
45. MT 707 Amendment to a Documentary Credit This message informs the Receiver of amendments to the terms and conditions of a documentary credit Maximum Length 10000 13 109 ORACLE 13 8 4 1 Format Specifications i Field Name Format Soa 20 Sender s Reference 16x M 21 Receiver s Reference 16x M 23 Issuing Bank s Reference 16x O 52a Issuing Bank AorD O 31C Date of Issue 6 n O 30 Date of Amendment 6 n O 26E Number of Amendment 2n O 59 Beneficiary before this amendment 34x M 4 35x 31E New Date of Expiry 6 n O 32B Increase of Documentary Credit Amount 3 a15d O 33B Decrease of Documentary Credit 3 a15d Amount 34B New Documentary Credit Amount After 3 a15d O Amendment 39A Percentage Credit Amount Tolerance 2n 2n O 39B Maximum Credit Amount 13x O 39C Additional Amounts Covered 4 35x O 44A Place of Taking in Charge Dispatch 65x O from Place of Receipt 44E Port of Loading Airport of Departure 65x O 44F Port of Discharge Airport of Destination 65x O 44B Place of Final Destination For Transpor 65x O tation to Place of Delivery 44C Latest Date of Shipment 6 n O 44D Shipment Period 6 65x O 79 Narrative 35 50x O 72 Sender to Receiver Information 6 35x O Note Field 72 will be split into two if the total length of the field exceeds 1750 characters 13 110 ORACLE 13 8 5 MT 710 Advice of a Third Bank s or a Non Bank
46. NL Indicates the number of lines that should be contained in a page when the message is printed NC Indicates the number of columns that should be contained in a page when the message is printed RH Indicates the start of the Report Header section PH Indicates the beginning of the Header for a page EH Indicates both the end of the Header section of the report or the end of Header section of a page RF Indicates the start of the Report Footer section PF Indicates the start of the Footer of a page EF Indicates both the end of the Footer of a report or page B Indicates the start of the body of the message EB Indicates the end of the body of the message CL Indicates that you can collapse a line EC Indicates the end of a line that you have collapsed LOOP Indicates the beginning of a loop END Indicates the end of a loop LOOP IF Indicates a Conditional section ANDIF Indicates a Conditional section ORIF Indicates a Conditional section ENDIF Indicates the end of a Conditional section 11 3 3 Importing Advice Format from an ASCII File on the Server The server indicates the machine on which the database of your bank is installed To import a format from an ASCII file on the server e Select the radio button against Server e Specify the full path to the file on the server which contains the format you want to import e Thereafter click Import button is ORACLE 11 3 4 11 3 5
47. Number Party A 16x O 82a Party A A D or J M 87a Party B A D or J M 83a Fund or Instructing Party A D or J O 72 Sender to Receiver Informa 6 35x O tion Mandatory Sequence B Interest Information ar Field Name Format ar 15B New Sequence Empty field M 30G Interest Period 8 n 8 n M 32B Currency and Principal Amount 3 a15d M 30V Value Date of Interest Payment 8 n M 34B Currency and Interest Amount 3 a15d M 37J Interest Rate 12d M 14D Day Count Fraction 7X M 30F Next Interest Payment Date 8 n O 13 38 ORACLE Mandatory Sequence C Settlement Instructions faa Field Name Format o 15C New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O Optional Sequence D Tax Information and Broker s Commission reg Field Name Format Mandatory Tag Optional 15D New Sequence Empty field M 34B Transaction Currency and Interest 3 a15d M Amount 33B Transaction Currency and Net 3 a15d M Interest Amount 36 Exchange Rate 12d O Optional Subsequence D1 Tax Details ried Field Name Format Mandatory Tag Optional 37L Tax Rate 12d M 33E Reporting Currency and Tax Amount 3 a15d M Optional Subsequence D2 Broker s Commission Information Field Field Name Format Mandatory Tag Opti
48. ORACLE 13 4 6 Optional Sequence G Tax Information no Field Name Format oun 15G New Sequence Empty field M 37L Tax Rate 12d M 33B Transaction Currency and Net 3 a15d M Interest Amount 36 Exchange Rate 12d O 33E Reporting Currency and Tax 3 a15d O Amount Optional Sequence H Additional Information zo Field Name Format er a 15H New Sequence Empty field M 29A Contact Information 4 35x O 24D Dealing Method Alc 35x O 84a Dealing Branch Party A A B D or J O 85a Dealing Branch Party B A B D or J O 26H Counterparty s Reference 16x O 72 Sender to Receiver Information 6 35x O MT 340 Forward Rate Agreement Confirmation This message is exchanged by or on behalf of the institutions or corporates party A and party B who have agreed to a forward rate agreement FRA The confirmed transaction is covered by an ISDA International Swaps and Derivatives Association Deutscher Rahmenvertrag f r Finanztermingesch fte FRABBA British Bankers Association or AFB Association Fran aise de Banques Master Agreement These agreements are either signed or under negotiation A money broker may also send this message to the two parties party A and party B for which he arranged the deal If there are two money brokers involved in arranging a deal between party A and party B this message is also exchanged between these money brokers The message is used to con
49. Receiving Agent A D or J M MT 341 Forward Rate Agreement Settlement Confirmation This message is exchanged by or on behalf of the institutions or corporates party A and party B who have agreed to a forward rate agreement FRA It is used to confirm the settlement details of the forward rate agreement when the settlement rate has been fixed on the fixing date The message is also used for e anamendment to a previously agreed settlement message e the cancellation of a settlement message Maximum Length 10000 1325 ORACLE 13 4 7 1 Format Specifications Mandatory Sequence A General Information a Field Name Format saai 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22C Common Reference 4la2 c4 n4 a2 c M 23D Type of FRA 10a M 21N Contract Number Party A 16x O 21B Contract Number Party B 16x O 82a Party A AorD M 87a Party B AorD M 29A Contact Information 4 35x O 72 Sender to Receiver Infor 6 35x O mation Mandatory Sequence B Transaction Details SN Field Name Format a 15B New Sequence Empty field M 30T Trade Date 8 n M 32B Currency Notional Amount 3 la15d M 30F Effective Date 8 n M 30P Termination Date 8 n M 37M Fixed Rate N 12d M Optional Subsequence B1 AFB and FRABBA Details a Field Name
50. Refer 4 c 16x M ence 23G Function of the Message Alc 4 c M 98a Date Time Preparation Date Time A C orE O 95a Party see qualifier description P Q or R M 25D Status Affirmation Status 4 c 8c O Code Alc Mandatory Repetitive Subsequence A1 Linkages FIBI Field Name Field Description Format Mandator Tag ylOptional 16R Start of Block LINK M 13a Number Identifi Linked Message AorB O cation 20C Reference see qualifier descrip 4 c M tion 16x 16S End of Block LINK M End of Subsequence A1 Linkages Field Field Field Forma Mandatory Tag Name Description t Optional 16S End of Block GENL M 13 6 2 MT 518 Market Side Securities Trade Confirmation This message is sent by an executing party to its trade counterparty It is used to confirm the details of a trade It may also be used to e request the cancellation of a previously sent confirmation e re send a confirmation previously sent e provide a third party with a copy of the message be it the confirmation or request for cancellation being sent This message may include where necessary the settlement details of the trade 1376 ORACLE The market confirmation may be e exchanged directly or via an ETC service provider between two trade counterparties for mutual comparison of the trade details e sent by one trade party to allege the trade against its counterparty either directly or via an ETC service provider Maximum Length 100
51. Rules 30x 35x M 31D Date and Place of Expiry 6 n29x M 52a Issuing Bank of the Original Documentary A or D O Credit 50B Non Bank Issuer of the Original Docu 4 35x O mentary Credit 50 First Beneficiary 4 35x 59 Second Beneficiary 34x M 4 35x 32B Currency Code Amount 3 a15d M 39A Percentage Credit Amount Tolerance 2n 2n O 39B Maximum Credit Amount 13x O 39C Additional Amounts Covered 4 35x O 41a Available With By AorD M 42C Drafts at 3 35x O 42a Drawee AorD O 42M Mixed Payment Details 4 35x O 42P Deferred Payment Details 4 35x O 43P Partial Shipments 1 35x O 43T Transshipment 1 35x O 44A Place of Taking in Charge Dispatch from 1 65x O Place of Receipt 44E Port of Loading Airport of Departure 1 65x O 44F Port of Discharge Airport of Destination 1 65x 13 114 ORACLE 13 8 7 44B Place of Final Destination For Transporta 1 65x O tion to Place of Delivery 44C Latest Date of Shipment 6 n O 44D Shipment Period 6 65x O 45A Description of Goods and or Services 100 65x O 46A Documents Required 100 65x O 4TA Additional Conditions 100 65x O 71B Charges 6 35x O 48 Period for Presentation 4 35x O 49 Confirmation Instructions 7x M 78 Instructions to the Paying Accepting 12 65x O Negotiating Bank 57a Advise Through Bank A B or D O 72 Sender to Receiver Information 6 35x MT 730 Acknowledgement This message is used to acknowledge
52. Search t Advanced Search Reset Case Sensitive Reference Number User Reference Document Number Branch Code Remark Records per page 15 Reference Number User Reference Document Number Running Number ESN Branch Code Remark Status In the above screen you can query for a record based on any of the following parameters e Reference Number e User Reference e Document Number e Branch Code e Remark Based on the query the following details of the record which match the query parameter are displayed e Reference Number e User Reference e Document Number e Running Number e ESN e Branch Code e Remarks e Status In order to view the details of each record select the record and click Detail button The details of the selected record are displayed in the PDE Detail screen For more details on PDE validations on outgoing messages refer section Performing PDE Validations on SWIFT Messages in Maintaining Messaging Branch Preferences chapter of this User Manual a ORACLE 9 Retrieving an Archived Message 9 1 Introduction Archival is the process of storing old messages for future retrieval To recall while defining messaging preferences for your branch you have also specified the number of days for which an outgoing message should be kept in the Outgoing Message Browser A message will be automatically archived after the n
53. Text If this option is checked then all the mail advice generated for this customer and location would have the hold mail text displayed on top of the message As a consequence these mail advices would not be dispatched to the customer unless required Check this box to indicate you want the hold mail text to be displayed on top of the message To recall you maintain a hold mail text through the Messaging Branch Parameter Maintenance screen Note This field is applicable only if the media is MAIL Send by E Mail If your customer has an e mail address you can opt to capture it by clicking on the box adjacent to the Send by E Mail option Enter the e mail address for the selected customer account media and location combination in the first line of the Address field You can capture addresses such as fax mail etc for different media and location combinations Name Here you specify the name of the customer for whom you are maintaining the address details This address maintenance is for a particular customer account based on a unique media and location combination Address Enter the detailed address to which messages and advices generated should be sent to for a particular customer account under the selected media and location combination The format of the address depends on the media through which the message is transmitted If the address is for the media type Mail you can enter the customers add
54. The following table contains a comprehensive list of the key words that can be used in the format editor Keyword Significance RH Indicates the start of the report header section PH Indicates the beginning of the header for a page EH Indicates both the end of the header section of the report or the end header of a page RF Indicates the start of the report footer section PF Indicates the start of the footer of a page EF Indicates both the end of the footer of a report or page B Indicates the start of the body of the message EB Indicates the end of the body of the message CL Indicates that you can collapse a line EC Indicates the end of a line that you have collapsed LOOP Indicates the beginning of a loop END Indicates the end of a loop LOOP IF Indicates a conditional section ANDIF Indicates a conditional section ORIF Indicates a conditional section ENDIF Indicates the end of a conditional Importing an advice format from an ASCII file on the server The server indicates the machine on which the database of your bank is installed To import a format from an ASCII file on the server 1 Click against the field marked Server 2 Specify the full path to the file on the server which contains the format you want to import is ORACLE 7 2 1 3 Thereafter click Import button The file containing the format of the messa
55. a brief advice of a documentary credit the full details of which will follow 13 107 ORACLE The pre advice is not an operative credit instrument Unless otherwise stated the issuing bank must forward the operative credit instrument i e MT 700 Issue of a Documentary credit without delay Maximum Length 2000 When an Advising Bank receives this message the system creates a Pre advice Export LC contract automatically through STP processing Tarog ORACLE 13 8 3 1 Format Specifications a Field Name Format nna 40A Form of Documentary Credit 24x M 20 Documentary Credit Number 16x M 31D Date and Place of Expiry 6 n29x M 50 Applicant 4 35x M 59 Beneficiary 34x M 4 35x 32B Currency Code Amount 3 a15d M 39A Percentage Credit Amount Tolerance 2n 2n O 39B Maximum Credit Amount 13x O 39C Additional Amounts Covered 4 35x O 41a Available With By AorD O 44A Place of Taking in Charge Dispatch 1 65x O from Place of Receipt 44E Port of Loading Airport of Departure 1 65x O 44F Port of Discharge Airport of Destina 1 65x tion 44B Place of Final Destination For Trans 1 65x O portation to Place of Delivery 44C Latest Date of Shipment 6 n O 44D Shipment Period 6 65x O 45A Description of Goods and or Services 100 65x O 57a Advise Through Bank A B or D O 79 Narrative 35 50x O 72 Sender to Receiver Information 6 35x O 13 8 4
56. as the Primary Address of the counterparty Refer the Continuous Linked Settlements chapter of the Foreign Exchange User Manual for details on processing CLS deals in Oracle FLEXCUBE To add additional modules to the list you can click on the add icon To delete a row click on the delete icon Saving Record After you have made the mandatory entries save the record A customer address record that you have created should be authorized by a user bearing a different Login Id before the End of Day EOD process can begin Click Exit or Cancel to return to the Application Browser Address Maintenance at Customer CIF Level You also have the provision to maintain customer addresses at the customer CIF level You can invoke the Customer Address Maintenance screen by typing MSDCUSAD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button i ORACLE The screen is shown below Customer Address Maintenance E New E Enter Query Customer Address Media Customer No Language Location Test Keyword Country Delivery By Answerback C Send by Email _ Add Hold Mail Text Name Address 1 Address 2 Address 3 Address 4 50F Party Details Line 1 Line2 Line 3 Line 4 Line 5 i101 H Message Type Module Branch NoofCopies Format AccountNo Primary Address Fields ChangeLo
57. bar and clicking on the adjoining arrow button Customer Address Summary 3 Search Advanced Search D Reset 4 Clear All Case Sensitive Authorization Status Record Status Customer No FPE Location Media Records per page 15 Authorization Status Record Status Customer No Location In the above screen you can base your queries on any or all of the following parameters and fetch records e Authorization Status e Customer Number e Media e Record Status e Location Select any or all of the above parameters for a query and click Search button The records meeting the selected criteria are displayed Note You can query or modify the customer details whose accounts are permitted to you for the query modification in the Group Code Restriction screen If you are allowed to query customer information system displays the following details pertaining to the fetched records e Authorization Status e Record Status e Customer Number e Location e Media ole ORACLE 7 Maintaining Advice Formats 7 1 Introduction The advices that are generated from your bank will have a definite format In the Advice Format Maintenance screen you can specify formats and indicate the messages and advices that should use the formats you have defined By maintaining message formats you can ensure consistency across the branches of your bank You can maintain advice formats either by e Using the
58. checked In the Edit Message screen check Remove Trailer option to remove the PDE trailer message contains the text PDE and save the message Viewing SWIFT Notification Messages SWIFT provides the following two types of notification messages to Oracle FLEXCUBE e ACK NACK acknowledgement messages indicating whether the message has been successfully delivered to SWIFTNet FIN service from where it gets forwarded to the receiving system e Delivery notification messages indicating whether the message was successfully delivered to the receiving system 10 11 ORACLE You can access these notifications messages using SWIFT Message Notification Browser screen You can invoke this screen by screen by typing MSSNOTIF in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The screen is as shown below swirtt Message Notification Browser E Search Advanced Search 4D Reset Case Sensitive Document Number Sender SWIFT Message Type i Process Status Auth Status User Reference Reference Number Records per page 15 7 E Branch Document Numbe WIFT Message Typel Branch Date Maker Id maker Date Repair Reason Running Number Details View Message In the above screen you can base your queries on any or all of the following parameters and fetch records e Document Nu
59. eae 15C New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O 19 21 ORACLE Optional Sequence D Vanilla Block na Field Name Format oon 15D New Sequence Empty field M 30P Earliest Exercise Date 8 n O 30Q Intermediate Exercise Date 8 n O 26F Settlement Type 9a M 32B Put Currency and Amount 3 a15d M 36 Strike Price 12d M 33B Call Currency and Amount 3 a15d M Optional Sequence E Payout Amount a Field Name Format E E 15E New Sequence Empty field M 33E Currency Amount 3 a15d M 30H Touch Payment Date 8 n O 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D orJ M 58a Beneficiary Institution A D orJ O Optional Sequence F Barrier Block TN Field Name Format oa 15F New Sequence Empty field M 22G Type of Barrier Alc M 37J Barrier Level 12d M 37L Lower Barrier Level 12d O Optional Subsequence F1 Barrier Window Block o Field Name Format na 13 22 ORACLE 30G Barrier Window Start Date and 8 n 8 n End Date 29J Location and Time for Start Date 4 c 4 n 29K Location and Time for End Date Alc 4 n 13 23 ORACLE Optional Sequence G Tr
60. for Mr Andrew Scott a non resident customer you want to personalize the account statement rather than send him the standard one defined in the Advice Format screen To make this possible you can indicate the code of a format that you defined specific to Mr Scott Whenever an account statement is sent to Mr Scott from your bank it will be in the format that you have defined in this screen Please note that the special format should first be defined in the advice format screen before it can be associated with Mr Scott s address Primary Address When defining addresses for a message type you have to identify an address as the primary address This option will be available only if the message type is FX_CONFIRMN If you maintain multiple FX Confirmation Message types for the SWIFT Media for a customer across different locations the T Copy will be generated only for the address that is marked as the Primary Address of the counterparty Refer the Continuous Linked Settlements chapter of the Foreign Exchange User Manual for details on processing CLS deals in Oracle FLEXCUBE Note If addresses at both the customer account level and the customer CIF level are main tained Oracle FLEXCUBE picks up the maintenances done at the customer account level to generate messages and advices However if the addresses at an account level are not maintained Oracle FLEXCUBE picks up the maintenances done at the customer CIF
61. for which messages should be kept in the queue for PDE Possible Duplicate Emission identification System does not consider messages for PDE identification post the PDE archive period maintained here a2 ORACLE Note The PDE archive period should be less than or equal to message archival days Text for Duplicate Every message is maintained in the Outgoing Browser as an un generated copy of the original When the copy is generated it will contain along with the contents of the original message any additional text that you have maintained in the Text for Duplicate field Hold Mail Text All the mail advices generated for a customer for whom Add Hold Mail Text is checked at the Customer Address Maintenance would have the hold mail text maintained in this field This text will be displayed on top of the message Test Word Check You can indicate whether a testword needs to be entered before a telex message is generated from and received at your branch You can state your preference from the Yes No option that is available PDE Functional Validation Check this box to indicate that system should identify an outgoing message as PDE Possible Duplicate Emission using functional key or not The PDE validation is done either using the hash value of the SWIFT message or using the tag field value of the message If this option is checked Oracle FLEXCUBE identifies duplicate messages by performing PDE functional validation
62. is stored in a distinct record in the outgoing message data store A message is marked as PDE if ALL the split messages are found to be duplicates Note All the messages in the PDE queue Incoming and Outgoing are completely processed by EMS prior to initiating EOD operations For more details on outgoing messages in PDE queue refer section Processing Outgoing Messages with PDE Trailer in Processing Outgoing Messages chapter of this User Manual Maintaining Agreements with Sender Receiver BIC You can maintain agreement with the sender receiver BIC through the Agreements with Sender Receiver BIC Maintenance screen You can invoke the Agreements with Sender See ORACLE Receiver BIC Maintenance screen by typing ISDCCYRS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button E New E Enter Query Bank Id Code M7101 Message Type x Product for Consolidation Direction Incoming Debit t No of Transactions per oigani Message Both Cutoff Incoming Cutoff Outgoing Hour Minute Transaction Currency Limit Details C Currency Input By Authorized By Modification Date Time Date Time Number E Authorized E Open You need to capture the following information in this screen BIC Code Specify the BIC code The value entered here must be a valid BIC code in the system with the options Generate MT102 Generate MT102
63. language code from the option list available against this field The language code that you specify is taken to be the default language in which all messages sent to the address are expressed Note Remember that to send a message to a customer in a particular language you should have also maintained a message format for the chosen language through the Advice Format Maintenance screen Country Here you select the relevant country code where your customer resides All countries maintained through the Country Name Maintenance screen are made available here oe ORACLE Answerback Specify the answerback code for the customer This field is applicable only if a message is transmitted through Telex It cannot be more than 20 characters in length It is a free format text Test Keyword Enter the test word allotted to a customer This field is applicable only if the message is transmitted through Telex i e media is TELEX Deliver By Select how statements sent to the customer by mail should be delivered from the adjoining option list All the values maintained through the Message Location Maintenance screen will be displayed in the option list Send by E mail If your customer has an e mail address you can opt to capture it by clicking on the box adjacent to the Send by E Mail option Enter the e mail address for the customer media and location combination in the first Address field You can
64. n 4 n 12a M 31E Final Settlement Date 6 n M 26F Settlement Type 9a M 32B Underlying Currency and 3 a15d M Amount 36 Strike Price 12d M 33B Counter Currency and Amount 3 a15d M 37K Premium Price 3 a12d M 34a Premium Payment PorR M 53a Sender s Correspondent A B or D O 56a Intermediary AorD O 57a Account With Institution AorD M 77D Terms and Conditions 6 35x O 72 Sender to Receiver Informa 6 35x O tion 13 4 3 MT 306 Foreign Currency Option Confirmation This message is exchanged to confirm a foreign currency option contract by or on behalf of 13 18 ORACLE the institutions or corporate party A and party B which have agreed to it A money broker may also send this message to the two parties party A and party B for which he arranged the deal If there are two money brokers involved in arranging a deal between party A and party B this message can also be exchanged between these money brokers The message is used to confirm notify the details of a new contract between the parties an amendment to a previously agreed contract the cancellation of a confirmation a trigger event knock in knock out of an option hitting of a trigger level the close out of an option Maximum Length 10000 1219 ORACLE 13 4 3 1 Format Specifications Mandatory Sequence A General Information a Field Name Format Suan 12G Option
65. on the SWIFT system Maximum Length 10000 Format Specifications ee Field Name Format Mandatory Tag Optional 20 Transaction Reference Num 16x M ber 12 Sub Message Type 3 n M 77E Proprietary Message 120 78 M x Treasury Markets Metals MT 643 Notice of Drawdown Renewal This message type is sent by the agent of the facility to the providers of funds It gives notice of the borrower s request for drawdown s renewal s on a given date This request may require the provision of new funds or the re borrowing of previously disbursed funds The MT 643 allows for the handling of drawdown s renewal s with differing characteristics It specifies the currency ies amount s period s and interest rate origin s Maximum Length 2000 13 97 ORACLE 13 7 1 1 Format Specifications Mandatory Sequence A Identification of the Facility Bible Field Name Format Mandatory Tag Optional 20 Transaction Reference Num 16x M ber 21 Related Reference 16x O 23 Further Identification 16x M 27 Sequence of Total 1 n 1 n O 29A From 4 35x O 29B To the Attention of 4 35x O 88D Borrower s 1 a M 34x 4 35x 32A Original Facility Amount 6 n3 a15d M Optional Repetitive Sequence B Existing Drawings PEI Field Name Format Mandatory Tag Optional 26P Drawing Identification 3 a 4x M 31F Drawdown
66. orS M tion 13 80 ORACLE 97A Account see qualifier descrip 4 c 35x O tion 98a Date Time Processing Date Time AorC O 20C Reference Processing Reference 4 c 16x O 70C Narrative Party Narrative 4 c 4 35x O 16S End of Block CSHPRTY M Optional Repetitive Subsequence C3 Amounts a fa Field Description Format aot 16R Start of Block AMT M 17B Flag see qualifier descrip 4 c 1 a O tion 19A Amount see qualifier descrip Alc N 3 a15d M tion 98a Date Time Value Date Time Aorc 92B Rate Exchange Rate Alc 3 a 3 a 15d 16S End of Block AMT M End of Subsequence C3 Amounts Field Field Field Ea Format Mandatory Tag Name Description Optional 16S End of Block SETDET M 13 81 ORACLE 13 6 3 Optional Repetitive Sequence D Other Parties Field Field Par Mandatory Tag Name Field Description Format Optional 16R Start of Block OTHRPRTY M 95a Party see qualifier descrip P Q R orS M tion 97a Account see qualifier descrip AorB O tion 70C Narrative Party Narrative 4 c 4 35x 20C Reference Processing Reference 4 c 16x 16S End of Block OTHRPRTY Optional Sequence E Two Leg Transaction Details reld Field Name Field Description Format Mandatory Tag Optional 16R Start of Block REPO M 98a
67. should be se lected Repeating a Set of Padding Characters If you opted to suffix an outgoing message with a set of padding characters indicate in the Number of Characters field the number of times the set should be repeated The padding characters will be suffixed to every outgoing message in the media as many times as you specify Halting the Processing of Messages At any time you can opt to halt the processing of messages in a specific media To halt the processing of incoming and outgoing messages in a media invoke this screen and navigate to the maintenance record for the media and choose the Stop Processing option When you save your changes to the record Oracle FLEXCUBE will stop processing messages in the media Indicating the Compatible Media for a Media Type For each media type that you maintain you can also indicate other media that are compatible The format of compatible media should be similar For example you are maintaining details for the media type mail You have indicated media type Fax as compatible media In this case whenever a message is faxed it will be in the mail format defined for the message in the Advice Format File Maintenance screen You can indicate compatible media by selecting the relevant media codes from the picklist available To add compatible media for a media type select the code that identifies the compatible media and click add icon To delete compatib
68. specific location with an account number Maintaining multiple locations for the customer facilitates the sending of interest and account statements to more than one address of the customer If an address is maintained at the Customer Account Definition level all statements pertaining to the particular account will be sent only to the address specified at the account level irrespective of the message and location maintenance for the Customer G2 ORACLE Media Select the media code for which you want to set up addresses Choose a code from the option list of valid media codes maintained in the Media Maintenance screen A customer of your bank can have several addresses for a particular media The media supported include e Mail e E Mail e Telex e SWIFT e FAX e FILEACT this is an interface to the TIPA network Each media type is identified by a 15 character Media Code Location As discussed earlier a customer of your bank can have several addresses for the same media To differentiate between one address of a customer account and another for a given media it is mandatory for you to select a unique location for each address The location that you specify for an address is used as a unique identifier for the customer account address The values made available against the option list here are maintained through the Account Address Location Maintenance screen Refer to the section Location Maintenance in
69. the chapter titled Maintaining Customer Accounts in the Core Entities CE User Manual for relevant information Language In this screen you can specify the language in which the messages sent to the address should be expressed You can choose a language code from the factory shipped option list available for this field The language code that you specify is taken to be the default language in which all messages sent to the address will be expressed Note To send a message to a customer in a particular language you should have also main tained a message format for the language in the Advice File Maintenance screen Country Here you select the relevant country code where your customer resides All countries maintained through the Country Name Maintenance screen are made available here Test Keyword Specify the test word allotted to a customer This field is applicable only if the message is transmitted through Telex ie media is TELEX Answerback Specify the answerback code for the customer This field is applicable only if a message is transmitted through Telex It cannot be more than 20 characters in length It is a free format text oe ORACLE Deliver By Select how statements sent to the customer by mail should be delivered from the adjoining option list All the values maintained through the Message Location Maintenance screen will be displayed in the option list Add Hold Mail
70. the format editor on the screen or e Importing the format from an ASCII file This can be located either on the server or the client Template ID Select template id from the option list Click P button to populate the template details into field 79 by resolving the substitution variables You can modify the fields under Tag 79 However the substitution variables are already resolved and defaulted While modifying the message you should specify the values Ths ORACLE directly and not the substitution variables again System formats the amount and date based on default format at the application level Free Format Message Maintenance Fle Bete Dat Copes Etema Reference Nh H Testleri Reud Ruming Numbar Contact Reference W InpatFle cnt Toye i hy aoe nical Distucet Dee Tne Dae Tin uny Dos 114 ORACLE 11 3 2 Entering an Advice Format using Format Editor To enter a format using the format editor click free format text icon positioned next to the text of the message In the note pad that is invoked you can actually tailor an advice to suit your requirements Keywords to format the advice similar to what is used in the Advice Format Maintenance can be used here too in order to get the desired format The following table contains a comprehensive list of the key words that can be used in the format editor Keyword Significance
71. the sub branch Maintaining Queues All Incoming SWIFT and Non Swift Messages are routed through a messaging queue You need to maintain different user queues to which incoming messages are directed Users with appropriate rights are allowed to access a particular queue You can invoke the Message Queue Maintenance screen by typing MSDQUEUE in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Message Queue Maintenance E new E3 Enter Query Queue Queue Description Collection Queue Swift Message Queue Message Code Input By Authorized By Modification Date Time Date Time Number Wi Authorized Open In this screen you can capture the following details for a queue e A name to identify the queue uniquely throughout the system e A short description of the queue e The codes of various SWIFT and Non SWIFT messages that would be routed to this queue e Select collection queue flag if the unique queue you are maintaining here is a collection Queue Note The codes of various SWIFT and Non SWIFT messages list in the grid is not applicable for the collection queue You can assign a message to more than one messaging queue At the time of maintaining rules for a message discussed in the subsequent sections of this document you can select the appropriate queue for each rule from the list of queues to which the message is linked 20 ORACLE
72. the trailer of the message is appended to reflect this information Note This is applicable only for MT103 and MT202 messages For incoming SWIFT messages which have a PDE trailer system interprets the trailer information and sets aside those messages marking its process status as Exception However Oracle FLEXCUBE allows you to either accept or reject the message identified as a PDE from the Incoming message browser For outgoing SWIFT messages system performs certain PDE validations to identify duplicate messages Following are the two types of PDE validations that the system performs e Hash Value Based PDE Validation e Message field Tags Based PDE Validation Hash Value Based PDE Validation System calculates the hash value of a message when the message is generated and stores itin a data store System then compares this value with the hash values in the message log to identify duplicates Note System performs hash value validation on messages as a mandatory check Message field Tags Based PDE Validation Tag based PDE validation is performed only for Customer Transfer MT103 and Bank Transfer MT202 messages You can decide the tag value based on which system needs to perform the validation Note Tag value validation is done only if you have selected the PDE Functional Validation op tion in the Messaging Branch Parameters Maintenance screen System uses the following fields t
73. validity if you have specified so in the messaging branch preferences screen This is done by entering a testword The test word that you enter depends on the testword arrangement with the counterparty the important aspects of the message like customer date and currency ie ORACLE If the testword you enter does not match the telex testword the message is registered as a defective message and put into the repair status External Reference Number This is a unique message identification number that will be used to identify an incoming message coming from an external system This is defined as the ICN number On upload of an incoming message into Oracle FLEXCUBE this number given by the external system will be stored in Oracle FLEXCUBE and passed on to the contract generated as a result of the incoming message If the incoming message results in an outgoing message the ICN number will be linked to the outgoing message also This number will help you in creating a relationship between the incoming message the resultant contract in Oracle FLEXCUBE and the outgoing message if any For instance if an incoming MT103 results in an FT transaction then ICN number of the incoming MT103 will be linked to the FT contract generated due to the upload of the incoming payment message If an Incoming message results in an outgoing contract outgoing message Oracle FLEXCUBE will store the External reference number ICN Number at the following le
74. wc cece enteeeceentteeeeceentaeeeeeeenaeteeeseaaes 13 100 13 7 4 MT 646 Payment of Principal and or of Interest c ccceceeeeeeeeneee 13 102 13 7 5 MT 649 General Syndicated Facility Message eeeeeeeeeeeenneeteeeeeeeee 13 103 13 8 Documentary Credits and Guarantees cceeseeeeeeeeneeeeeeeenteeeeseenaeeeeeeeeaaes 13 104 13 8 1 MT 700 Issue of a Documentary Credit ccccccccceeeceetteeeeeeenteeteeeeeaes 13 104 13 8 2 MT 707 Issue of a Documentary Credit cccccceccccccenteeeeeeenteeeeeeneaes 13 107 13 8 3 MT 705 Pre Advice of a Documentary Credit 0 cccccccscccectntteteeeentaes 13 107 13 8 4 MT 707 Amendment to a Documentary Credit cccccececttteeeeeeenee 13 109 13 8 5 MT 710 Advice of a Third Bank s or a Non Bank s Documentary Credit 13 111 13 8 6 MT 720 Transfer of a Documentary Credit 00 ceeccccccettteeeceennteeeeeeeees 13 113 13 8 7 MT 730 ACKNOWlEAGOMEN 0 eeceeteeeceentneeeeeeeeneeeeeeeeaeeeeeetaaeeeeeneaas 13 115 13 8 8 MT 732 Advice Of Discharge 0 0 ceeeeceeeeeeeetneeeeceetnneeeeeeetneeeeetetnaeeeeenenaa 13 116 13 8 9 MT 734 Advice Of Refusal sssseeerrreenrernrsrerrrreerrrrnnnnrerrrenrrrnnnnererrene 13 116 13 8 10 MT 740 Authorization to REIMDUISC 1ccccceceeteeecteenteeeeeeeenaeteeteenas 13 117 13 8 11 MT 742 Reimbursement Claiin ccccccccccecceceeeetteeeeeeeenteeeeceeenaeeeeeneaaes 13 118 13 8 12 MT 747 Amendment to an Authorization to REIMbUISE ce 13 119 13 8 13 M
75. 00 13 6 2 1 Format Specifications Mandatory Sequence A General Information Field Field aa Mandatory Tag Name Field Description Format Optional 16R Start of Block GENL 20C Reference Sender s Message Refer 4 c 16x ence 23G Function of the Message 4 c 4 c 98a Date Time Preparation Date Time A C orE 22F Indicator Trade Transaction Type 4 c 8c Alc Optional Repetitive Subsequence A1 Linkages Bible Field Name Field Description Format Mandatory Tag Optional 16R Start of Block LINK 13a Number Identifi Linked Message AorB cation 20C Reference see qualifier Alc description 16x 16S End of Block LINK 16S End of Block GENL TEGE ORACLE Mandatory Sequence B Confirmation Details ried Field Name Field Description Format Mandatory Tag Optional 16R Start of Block CONFDET M 98a Date Time see qualifier descrip A B C or E M tion 90a Price Deal Price AorB M 92A Rate see qualifier descrip 4 c N 1 5d O tion 99A Number see qualifier descrip 4 c N 3 n O Count tion 94a Place see qualifier descrip B C or F O tion 19A Amount Settlement Amount Alc O N 3 a15d 22a Indicator see qualifier descrip ForH M tion 11A Currency see qualifier descrip 4 c 3 a O tion Mandatory Repetitive Subsequence B1 Confirmation Parties Field
76. 11 3 6 The file containing the format of the message will be displayed on the screen Importing Advice Format from ASCII File on Client Client refers to your own machine To import a format from an ASCII file on the client e Click against the field marked Client e Specify the full path to the file on the client which contains the format you want to import and e Thereafter click Import button The file containing the format of the message will be displayed on the screen Sending Free Format Message A Free Format Message will be sent depending on your specifications in the Background Process screen e If the background process is running a free format text that you define will be immediately sent at the time you save the record e If the background process is not running the Free Format Message that you have defined will be displayed in the Outgoing Message browser from where you can process as you would any other outgoing message Saving Record After you have made the mandatory entries save the record A free format record that you have defined should be authorized by a user bearing a different login ID before the End of Day EOD process is run Click Exit or Cancel to return to the Application Browser 11 ORACLE 11 3 7 Viewing SWIFT Messages You can view the SWIFT messages by clicking the SWIFT Messages tab The screen will be displayed as follows Free Format M
77. 14A Business Day Convention 9a O 32B Party B Currency and Notional 3 a15d M Amount 33B Party A Currency and Notional 3 a15d M Amount 82a Party A AorD M 87a Party B AorD M 83a Fund or Beneficiary Customer A D or J O 17A Collateral Agreement Indicator 1la O 77H Type Date Version of the 6a 8 n 4 n M Agreement 77D Additional Conditions 6 35x O 14C Year of Definitions Aln M 72 Sender to Receiver Information 6 35x Optional Sequence B Fixed Interest Payable by Party B 13 51 ORACLE Field Name Format Saar 15B New Sequence Empty M field 37U Fixed Rate 12d 37N Details of Interest 6 35x Rate Optional Subsequence B1 Interest Details a Field Name oo moa aa 18A Number of Repetitions 5n M 30F Payment Date 8 n M 32M Currency Payment Amount 3lai5d O 17F Period End Date Adjustment Indicator 1 a O 14D Day Count Fraction 7X O 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M Optional Sequence C Floating Interest Payable by Party B Field Field Name Format Mandatory Tag Optional 15C New Sequence Empty M field 14F Floating Rate Option 24x M 37J Cap Rate 12d O 37L Floor Rate 12d O 37N Details of Interest 6 35x O Rate Optional Subsequence C1 Interest Details Field Forma Mandatory Tag Piela Name t Optional 14J Reset Date Specification 5a M
78. 15d O 71G Receiver s Charges 3 a15d O 72 Sender to Receiver Information 6 35x O 77B Regulatory Reporting 3 35x O 77T Envelope Contents 9000z O 13 4 ORACLE 13 2 2 MT 103 Single Customer Credit Transfer This message type is sent by or on behalf of the financial institution of the ordering customer directly or through a correspondent s to the financial institution of the beneficiary customer It is used to convey a funds transfer instruction in which the ordering customer or the beneficiary customer or both are non financial institutions from the perspective of the Sender This message may only be used for clean payment instructions It must not be used to advise the remitting bank of a payment for a clean e g cheque collection nor to provide the cover for a transaction whose completion was advised separately e g via an MT 400 Maximum Length 10000 ie ORACLE 13 2 2 1 Format Specifications Field Name Format eae a 20 Sender s Reference 16x M 13C Time Indication 8c 4 n1 x4 n O 23B Bank Operation Code Alc M 23E Instruction Code Alc 30x O 26T Transaction Type Code 3 c O 32A Value Date Currency Interbank 6 n3 a15d M Settled Amount 33B Currency Instructed Amount 3 a15d O 36 Exchange Rate 12d O 50a Ordering Customer A F or K M 52A Ordering Institution 1 a 34x O Ala2 a2 c 3 c 53a Sender s
79. 3 Bank Operation Code 16x M 51A Sending Institution 1 a 34x O 4 a2 a2 c 3 c 50a Ordering Customer A F or K O 52a Ordering Institution A B orC O 26T Transaction Type Code 3 c O 77B Regulatory Reporting 3 35x O 71A Details of Charges 3la O 36 Exchange Rate 12d O Mandatory Repetitive Sequence B Transaction Details a Field Name Format sra 21 Transaction Reference 16x M 32B Transaction Amount 3 a15d M 50a Ordering Customer A F or K O ORACLE 13 2 1 52a Ordering Institution A B or C 57a Account With Institution Aorc 59a Beneficiary Customer No letter option or M A 70 Remittance Information 4 35x O 26T Transaction Type Code 3 c O 77B Regulatory Reporting 3 35x O 33B Currency Instructed 3 a15d O Amount T1A Details of Charges 3la O 71F Sender s Charges 3 a15d O 71G Receiver s Charges 3 a15d O 36 Exchange Rate 12d O Mandatory Sequence C Settlement Details a Field Name Format aaa 32A Value Date Currency Code 6 n3 a15d M Amount 19 Sum of Amounts 17d O 71G Sum of Receiver s Charges 3 a15d O 13C Time Indication 8c 4 n1 x4 n O 53a Sender s Correspondent AorC O 54A Receiver s Correspondent 1 a 34x O Ala2 a2 c 3 c 72 Sender to Receiver Information 6 35x O MT 103 Single Customer Credit Transfer This message type is sent by or on behalf of the financial institution of the ordering customer directly or thro
80. 6a Intermediary Aor D O 86a Second Intermediary AorD O 57a Receiving Agent AorD M Optional Sequence E Fixed Interest Payable by Party A a Field Name Format Sac 15E New Sequence Empty field M 37U Fixed Rate 12d O 37N Details of Interest Rate 6 35x O Optional Subsequence E1 Interest Details riag Field Name Format Mandatory Tag Optional 18A Number of Repetitions 5n M 30F Payment Date 8 n M 1345 ORACLE 32M Currency Payment 3 a15d O Amount 17F Period End Date Adjust 1la O ment Indicator 14D Day Count Fraction 7X O 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M Optional Sequence F Floating Interest Payable by Party A sh Field Name Format Sac 15F New Sequence Empty field M 14F Floating Rate Option 24x M 37J Cap Rate 12d O 37L Floor Rate 12d O 37N Details of Interest Rate 6 35x O Optional Subsequence F1 Interest Details Fo Field Name Format a 14J Reset Date Specification 5a M 14G Averaging Frequency and Method 1 a 8 a O 38E Designated Maturity 2n1 a M 18A Number of Repetitions 5n M 30F Payment Date 8 n M 17F Period End Date Adjustment Indi 1 a M cator 14D Day Count Fraction 7X M 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M 37R Spread N 12d
81. 91 Request for Payment of Charges Interest and Other Expenses This message type is sent by a financial institution to another financial institution It is used to request the payment of charges interest and or other expenses which are previously unknown to the Receiver Maximum Length 2000 13 2 5 1 Format Specifications ta Field Name Format oona 20 Transaction Reference Num 16x M ber 21 Related Reference 16x M 32B Currency Code Amount 3 a15d M 52a Ordering Institution AorD O 57a Account With Institution A BorD O 71B Details of Charges 6 35x M 72 Sender to Receiver Information 6 35x O 13 3 Financial Institution Transfers 13 3 1 MT 200 Financial Institution Transfer for its Own Account This message type is sent by an account owner to one of its account servicing institutions It is used for single funds transfer between two accounts of the beneficiary bank maintained with two different financial institutions lee ORACLE It is used to request the movement of funds from an account that the Receiver services for the Sender to an account that the Sender has in the same currency with another financial institution Maximum Length 2000 13 3 1 1 Format Specifications rieg Field Name Format Mandatory Tag Optional 20 Transaction Reference Number 16x M 32A Value Date Currency Code Amount 6 n3 a15d M 53B Sender s Corresponde
82. B Financial Centre Alc M Nagdatory Sequence C Settlement Instructions for Settlement Amount Payable by Par Tei Field Name Format oa 15C New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O Naqdatory Sequence D Settlement Instructions for Settlement Amount Payable by Par m Field Name Format srad 15D New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 13 34 ORACLE 13 4 7 58a Beneficiary Institution A D or J O Optional Sequence E Additional Information E Field Name Format oam g 15E New Sequence Empty field M 29A Contact Information 4 35x O 24D Dealing Method Alc 35x O 88a Broker Identification AorD O TIF Broker s Commission 3 a15d O 21G Broker s Reference 16x O 72 Sender to Receiver Information 6 35x O c3Optional Sequence F Additional Amounts E Field Name Format ad 15F New Sequence Empty field M 18A Number of Repetitions 5n M 30F Payment Date 8 n M 32H Currency Payment Amount N 3 a15d M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a
83. BEAR REES PERAE E ENAREN 2 3 2 6 2 INCOMING EMS PrOCOS Se ooer airan enrii rE EE EAE ARLE EE N Er E ALE ERE 2 5 Maintaining Messaging Branch Preferences ssssssssseeenennnnnssnnnnnnnnnnnnns 3 1 Sil ATOCIA EE E T AA ae eh eats 3 1 3 2 Capturing Messaging Branch Parameters Maintenance screen eseese 3 1 3 3 Features of Messaging Branch Preferences screen ccccceeeeeeeeteteeeeeeeenteeeeeeees 3 2 3 4 Determining Message QUEUES ssesscssssriesissrssisrnnsesnnranddinnneaiinnnendannnnaaaanaddanann 3 5 3 4 1 Maintaining QUEUOS errer A EEEE 3 6 3 5 Maintaining Message Types sssseesssseeseesrressrsrnnesrtrnnesssinnnastntnnnstnnnnnedtnnananenennaennnnn 3 7 3 5 1 Querying for SWIFT Message Tag Description 0 ceeeeteeente eee teeenneeees 3 9 3 5 2 Viewing SWIFT Message Tags e sseesrinrneserrnnerrrrinrerrrnnnnrrnnnnnrrnnnnnnna 3 10 3 5 3 Maintaining Message Type for Account OPening cccceesseeeteeenneees 3 11 3 5 4 Maintaining RTGS Messag eS eeseeesernnnnreerrenrrrrrrrreerrrnnnrrnrnnneeinnnnnnna 3 12 3 6 Maintaining NEFT Messages ssseessssressserreessrsrnesrtrnneaetennadetnnnnaastnnnnetnannennenaae 3 16 3 7 Performing PDE Validations on SWIFT Messages cceeeseseteeeeeeettiteeeeeenaees 3 19 3 7 1 Processing PDE Messages oucennocrarriaronrearir riir iiini 3 21 3 8 Maintaining Agreements with Sender Receiver BIC cccceeeeeeeeeeeeeetteeeeeeeenaees 3 22 3 8 1 Transaction Currency
84. CLE 44B Place of Final Destination For Transporta 1 65x O tion to Place of Delivery 44C Latest Date of Shipment 6 n O 44D Shipment Period 6 65x O 45A Description of Goods and or Services 100 65x O 46A Documents Required 100 65x O 4TA Additional Conditions 100 65x O 71B Charges 6 35x O 48 Period for Presentation 4 35x O 49 Confirmation Instructions 7 x M 53a Reimbursing Bank Aor D O 78 Instructions to the Paying Accepting Nego 12 65x O tiating Bank 57a Advise Through Bank A B or D O 72 Sender to Receiver Information 6 35x 13 8 6 MT 720 Transfer of a Documentary Credit When a beneficiary has requested the transfer of a documentary credit originally issued by a bank or a non bank to a second beneficiary this message is sent by the bank authorized to advise the transfer of the documentary credit to the bank advising the second beneficiary It is used to advise the Receiver about the terms and conditions of the transferred documentary credit or part thereof Maximum Length 10000 13 113 ORACLE 13 8 6 1 Format Specifications Field Mandator Tag Field Name Format yl Optional 27 Sequence of Total 1 n 1 n M 40B Form of Documentary Credit 24x M 24x 20 Transferring Bank s Reference 16x M 21 Documentary Credit Number 16x M 31C Date of Issue 6 n O 40E Applicable
85. C_REF Our LC Ref No THEIR_LC_REF Their LC Ref No BC_CONTRACT_REF BC Contract Reference Number BC_USER_REF BC User Reference Number BROK_DETAILS Broker Brokerage and Brokerage Cur rency SHIPMENT_FROM Shipment From SHIPMENT_TO Shipment To 11 16 ORACLE In case of a Bill contract under an LC the system resolves all tags applicable to MT799 and MT499 In such cases the tags related to Bills are resolved based on the corresponding Bill contract Similarly the tags related to LC are resolved based on the LC contract which is linked to the Bill contract 11 17 ORACLE 12 1 12 2 12 Making Query Introduction When you are in the Outgoing or Incoming Message Browser all the messages that were transmitted from and received at your branch are displayed This may amount to hundreds of messages To avoid wading through this mass of data you can make a query to obtain information that is relevant to you at a particular time For example you may want to obtain information on the messages that were sent to just two customers on a specific date Or you may want to see all outgoing messages across modules sent during a specific period The Advanced Search function makes this possible for you To make an advanced search click Advanced Search button either from the Outgoing or Incoming Browser as the case may be The Advanced Summary screen is displayed
86. Cancel F Regenerate 7 Hold 7 Change Address 7 Change Node 7 Reinstate F Test Word jy Release Auth Repair Incoming 7 Branch Move 7 Carry Forward yl Test Word Check Date Time Checker Date Time Mod No Record Status Authorization Status Features of Messaging Branch Preferences screen In the Messaging Branch Parameters Maintenance screen you can only maintain create or modify the preferences for the current logged in branch However you can view the preferences maintained for other branches Following are the details captured here Branch Specify the branch for which you are maintaining the preferences Message Archive Period Archival is the process of storing old messages for future retrieval You can specify the number of days for which an outgoing message should be kept in the Outgoing Message Browser A message will be automatically archived after the number of days that you specify You can un archive the details of outgoing message that has been archived by invoking the Message History Retrieval screen After you un archive an outgoing message you can process it just as you would any other outgoing message Note It is recommended that you indicate a value of one in this field In this case only those messages that have been triggered for generation today will be displayed in the Outgoing Message Browser PDE Archive Period Specify the number of days
87. D O 57a Receiving Agent AorD M Optional Sequence M Fee Payable by Party A e Field Name Format Sd 15M New Sequence Empty M field 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 13 70 ORACLE 13 5 13 5 1 57a Receiving Agent AorD M Collections and Cash Letters MT 400 Advice of Payment This message type is typically sent by the collecting bank to the remitting bank It may also be sent e on behalf of the collecting bank by its branch affiliate bank to the remitting bank or branch affiliate of that bank e bya collecting bank to another collecting bank It is used to advise a payment under a collection or a part thereof and may also be used for the settlement of proceeds The account relationship between the Sender and the Receiver is used unless expressly stated otherwise in the message This message must never be sent to a bank acting solely as a reimbursement bank In this case the appropriate message type is an MT 202 Financial Institution Transfer Maximum Length 2000 13 5 1 1 Format Specifications i Field Name Format Baie 20 Sending Bank s TRN 16x M 21 Related Reference 16x M 32a Amount Collected A B orK M 33A Proceeds Remitted 6 n3 a15 M d 52a Ordering Bank AorD O 53a Sender s Correspondent A B orD O 54a Receiver s Correspondent A B orD
88. Field Description Format moran 16R Start of Block GENL M 20C Reference Sender s Message Refer 4 c 16x M ence 23G Function of the Message Alc 4 c M 98a Date Time Preparation Date Time A Cor O E 99B Number see qualifier description Alc 3 n O Count Optional Repetitive Subsequence A1 a Faa Field Description Format oa 16R Start of Block LINK M 20C Reference see qualifier descrip 4 c M tion 16x 16S End of Block LINK 16S End of Block GENL Mandatory Sequence B Trade Details a ieee Field Description Format nahin 16R Start of Block TRADDET M 94B Place Place of Trade Alc 8c 4 c O 30x 98a Date Time see qualifier description A B C or E 90a Price Deal Price AorB 35B Identification of the Finan ISIN1 e12 c cial Instrument 16S End of Block TRADDET M 13 20 ORACLE Mandatory Repetitive Sequence C Financial Instrument Account reld Field Name Field Description Format Mandatory Tag Optional 16R Start of Block FIAC M 36B Quantity of Finan Quantity of Financial 4 c 4 c M cial Instrument Instrument to be Settled 15d 95a Party Account Owner PorR O 97a Account see qualifier description A or B M 94a Place Place of Safekeeping B C orF O 16S End of Block FIAC M Optional Sequence D Two Leg Transaction Details Field Field Name Field Description Format Mandatory Tag Optional 16R Start of Block REPO M 98
89. Format Boo 30V Fixing Date 8 n O 13 36 ORACLE 13 4 8 38D Contract Period 4n Mandatory Sequence C Settlement Instructions for the Settlement Amount o Field Name Format Buea 15C New Sequence Empty field M 37R Settlement Rate N 12d M 34E Settlement Currency and N 3 a15d M Amount 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O MT 350 Advice of Loan Deposit Interest Payment It is used to inform that an interest amount has been paid to the account of the beneficiary with the receiving agent mentioned in the message The message may also be used to notify the details of e anamendment to a previously sent advice e the cancellation of an advice This message is sent by or on behalf of the institution or corporate party A who has borrowed cash from the institution or corporate party B Maximum Length 10000 13 37 ORACLE 13 4 8 1 Format Specifications Mandatory Sequence A General Information a Field Name Format naar 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22C Common Reference 4la2 c4 n4 a2 c M 21N Contract
90. Funds 64 Closing Available Bal 1 a6 n3 a15d O ance Available Funds 1123 ORACLE 14 1 14 2 14 Reports Introduction All activities that are performed in the Messaging System MS module are recorded The inputs you have made at different stages are pieced together and can be extracted in the form of meaningful reports as and when you may require them The various report programs and reporting features available under the Messaging System module are explained in this chapter You can generate the following reports for the Messaging System module e SMS Log Report e Successful Messages Report e Unsuccessful Messages Report SMS Log Report You can select the following options based on which the report can be generated e You can specify the operation date for which the report has to be generated e You can generate the report for specific User ID e You can also generate the report based on the operation To invoke the screen Security Management System Log Report type MSRMSRPT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The screen Security Management System Log Report is displayed below Security Management System Log Report User ld Operation Authorize Operation Date You can specify the following parameters User ID Specify valid User ID for which you want to generate the report from the adjoining option list
91. Limit Detalls ccccccccceceee testes eee teeeeeeeeteneneeees 3 24 Maintaining Media Types ccesseeeeeeeeeeeeeeeeeneeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeees 4 1 AT Introduction initia aii aati eae ate head aia i aaas 4 1 4 2 Maintaining Message Media Details eeceeceeeeeeeeeeeeeeenneeeeeeeenaeeeeeeenaeeeeeeeaaas 4 1 4 3 Features of the Media Maintenance screen cccceceeeeeeeceeeeeeeetteeeeeeettaeeeeeeeeaaes 4 2 Maintaining Media Control Systems cccccccccceeeeeeeeeeeeeeeeeseeeeeeeneeeeees 5 1 Sill dntroductlon 25 sasha aes es ent ee ec as ane eg teeta ete 5 1 5 2 Maintaining Message Media Control c cccceccceceeeeeeeceeeeeeeeeeneeeeeeetnieeeeeeeeiaeeeeeee 5 1 5 3 Features on MCS Detailed Screen o oo ccceeceeeee cere een eee eee eines eeeeteeeeeeeteeeeene 5 2 9 3 1 SWIFT Server On UNIX seietara ianiai eana AEAEE AE AA AERE EA 5 4 5 3 2 Specifying File Previx es enirdi iarrtas easi iea EAA i eA A aR EER 5 4 5 3 3 Saving Details you have Maintained cccccccccenteeeeeentteeeeeeenteeeeeeeaaes 5 4 10 11 12 Maintaining Addresses for Customer s eeeeeeeneeeeeeeeeeeeeeeeeeneenees 6 1 Gillis ImtrOGUCtON a2 ae snes ae T etl Sea he etek apes ated An ee et 6 1 6 2 Customer Account Address Maintenance Screen eceeeeeeeeeeeeeeeeseeeeeeeeeeeeeaeeees 6 1 62T SAVING ROCONI ii2 2 tsetse Ath Baap tee ide lee ie 6 6 6 2 2 Address Maintenance at Customer CIF Level
92. M ber 21 Related Reference 16x O 32B Transaction Amount 3 a15d M 53a Debit Institution A BorD M 72 Sender to Receiver Information 6 35x O Note TSU Trade Services Utility transaction is supported for field 72 in this particular mes sage MT 205 Financial Institution Transfer Execution This message is sent by the Receiver of a category 2 transfer message ie MT 200 201 202 203 or 205 directly or through correspondent s to another financial institution located in the same country as the Sender It is used to further transmit a funds transfer instruction domestically Maximum Length 2000 13 12 ORACLE 13 3 5 1 Format Specifications 13 3 6 Field Name Format Soir 20 Transaction Reference Number 16x M 21 Related Reference 16x M 13C Time Indication 8c O 4 n1 x4 n 32A Value Date Currency Code Amount 6 n3 a15d M 52a Ordering Institution AorD M 53a Sender s Correspondent A B or D O 56a Intermediary AorD O 57a Account With Institution A B or D O 58a Beneficiary Institution AorD M 72 Sender to Receiver Information 6 35x O MT 210 Notice to Receive This message type is sent by an account owner to one of its account servicing institutions It is an advance notice to the account servicing institution that it will receive funds to be credited to the Sender s account Maximum Length 2000 13 13 ORACLE 13 3 6 1 Format Specifica
93. MT type from the Incoming Outgoing Browser depending on the value of Response To Hold Check this box to indicate that you want to keep the generation of the message on hold Messages that are put on hold are temporarily stopped from being generated The message will have to be released before it can be generated Import File Specify the full path of the file on the server which contains the format you want to import Server Select this option to import a format from an ASCII file on the server The server indicates the machine on which the database of your bank is installed The following fields are displayed on this screen Reference number This is the system generated unique reference number for the message called DCN Date The Date defaulted will be the system date 71B Details of Charges Specify charge details for the specified message type from the adjoining option list The following options are available for MT n90 and MT n91 messages if you have selected Category 1 or Category 2 message types Code Description Reason AMND Amendment Payment order was changed based on a request to do so from the original sending bank or as a result of receiving amended information from the original sending bank CANF Cancellation Used when fees are assessed for cancellation of a pay Fee ment CLEF Clearing Fee Used when fees are assessed for standard processing of financial institution type transfers
94. N must not be used for Field 72 e Field 72 must not include ERI information in MT 103 13 2 3 MT 110 Advice of Cheque s This multiple message is sent by a drawer bank or a bank acting on behalf of the drawer bank to the bank on which a several cheque s has have been drawn the drawee bank It is used to advise the drawee bank or confirm to an enquiring bank the details concerning the cheque s referred to in the message Maximum Length 2000 13 2 3 1 Format Specifications te Field Name Format pista 20 Sender s Reference 16x M 53a Sender s Correspondent A B or D O 54a Receiver s Correspondent A B orD O 72 Sender to Receiver Informa 6 35x O tion 21 Cheque Number 16x M 30 Date of Issue 6 n M 32a Amount AorB M 52a Drawer Bank A B or D O 59 Payee 34x M 4 35x 13 2 4 MT 111 Request for Stop Payment of a Cheque This single message type is sent by a drawer bank or a bank acting on behalf of the drawer bank to the bank on which a cheque has been drawn the drawee bank It is used to request stop payment of the cheque referred to in the message Maximum Length 2000 Veet ORACLE 13 2 4 1 Format Specifications a Field Name Format Se 20 Sender s Reference 16x M 21 Cheque Number 16x M 30 Date of Issue 6 n M 32a Amount AorB M 52a Drawer Bank A B or D O 59 Payee 34x O 4 35x 75 Queries 6 35x O 13 2 5 MT 1
95. O 13 46 ORACLE Optional Subsequence F2 Compounding Details a Field Name Format Ser 22D Compounding Type Alc M 18A Number of Repetitions 5n M 30X Compounding Date 8 n M Optional Subsequence F3 Interpolation for Stub Periods Piala Field Name Format Mandatory Tag Optional 38G First Stub Period Interpolation Period 2n1 a O 2n1la 38H Last Stub Period Interpolation Period 2n1 a O 2n1la Mandatory Sequence G Payment Instructions for Interest Payable by Party A a Field Name Format a 15G New Sequence Empty M field 53a Delivery Agent AorD O 56a Intermediary Aor D O 86a Second Intermediary AorD O 57a Receiving Agent AorD M Optional Sequence H Amortising Schedule Se Field Name Format paneer 15H New Sequence Empty M field 18A Number of Repetitions 5n M 30G Variable Notional Start and End Date 8 n 8 n 32U Outstanding Notional Currency and 3 a15d M Amount 14A Business Day Convention 9a 18A Number of Repetitions 5n 13 47 ORACLE 22B Financial Centre Alc Optional Sequence L Additional Amounts Payable by Party B Field Name Format neal 15L New Sequence Empty M field 18A Number of Repetitions 5n M 22E Type of Payment Alc M 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 14A
96. ORACLE Messaging System User Guide Oracle FLEXCUBE Universal Banking Release 12 0 2 0 0 Part No E49740 01 September 2013 Messaging System User Guide September 2013 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 2013 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherent
97. Period 6 n 6 n O 35x 32P Repayment of Principal 6 n3 a15d O 33a Interest Amount PorR M 71C Details of Adjustments 6 35x O 34a Net Interest Amount PorR O 57a Account With Institution A B or D O 72 Sender to Receiver Informa 6 35x O tion Mandatory Repetitive Sequence C New Drawing s e Field Name Format Mandatory Tag Optional 26N Drawing Identification New 3 a 4x M 32E Selected Currency 3la O 13 98 ORACLE 31F Drawdown Period 6 n 6 n M 35x 31R Rate Fixing Date 6 n 6 n O 32B Amount of Drawdown 3 a15d M 33B Receiver s Participation 3 a15d M 57a Account With Institution A B or D O 72 Sender to Receiver Informa 6 35x O tion 13 7 2 MT 644 Advice of Rate and Amount Fixing 13 7 2 1 This message type is sent by the agent of the facility to the providers of funds It specifies the interest rate applicable for a drawdown renewal for a specified interest period whether the end date of that period is set or not When applicable this message type will also set the exchange rate Maximum Length 2000 Format Specifications Mandatory Sequence A Identification of the Facility Field Field Name Format Mandatory Tag Optional 20 Transaction Reference Num 16x M ber 21 Related Reference 16x O 27 Sequence of Total 1 n 1 n O 29A From 4 35x O 29B To the Attention of 4 35x O 88D Borrower s 1 a M 34x 4 35x
98. Reimburse This message is sent by the bank which has issued an authorization to reimburse issuing bank to the reimbursing bank It is used to inform the Receiver about amendments to the terms and conditions of the credit relevant to the authorization to reimburse The amendment is to be considered as part of the authorization to reimburse Maximum Length 2000 13 119 ORACLE 13 8 12 1 Format Specifications a Field Name Tii a 20 Documentary Credit Number 16x M 21 Reimbursing Bank s Reference 16x O 30 Date of the Original Authorisation to 6 n M Reimburse 31E New Date of Expiry 6 n O 32B Increase of Documentary Credit Amount 3 lai5d O 33B Decrease of Documentary Credit Amount 3 a15d O 34B New Documentary Credit Amount After 3lai5d O Amendment 39A Percentage Credit Amount Tolerance 2n 2n O 39B Maximum Credit Amount 13x O 39C Additional Amounts Covered 4 35x O 72 Sender to Receiver Information 6 35x O TTA Narrative 20 35x O 13 8 13 MT 750 Advice of Discrepancy Advises of discrepancies and requests authorization to honour documents presented that are not in accordance with the terms and conditions of the documentary credit Maximum Length 10000 13 120 ORACLE 13 8 13 1 Format Specifications Field Name Format Se 20 Presenting Bank s Reference 16x M 21 Related Reference 16x M 32B Principal Am
99. S out job is available as factory shipped The Outgoing EMS Process as part of jobs scheduler is as follows e Once the job is triggered it polls outgoing messages table for generated and unsent messages e Each message is then sent to an internal JMS queue e The job is then rescheduled to fire next time The Outgoing EMS Process in MDB is as follows e An MDB listens on the internal EMS outgoing queue and it builds the final message sent to intended destinations e Incase of any exception while processing message is sent to a deferred queue aa ORACLE The following diagram illustrates outgoing EMS process in scheduler Polling outgoing messages table for generated messages Lock the record with its primary key Simple message xml is prepared with primary details for the current record locked Send the xml to internal EMS Out service JMS Set the record as processed Exception Occurred No record to lock Exception Or Transaction Limit Rollback Transaction Transaction Limit Commit Transaction Set next fire time for the job ORACLE The following diagram illustrates outgoing EMS process in MDB EMS Out service MDB listening on internal EMS queue On message Call backend Ems Out service package to build the outgoing message Select the media for the message Copy the message into YIP folder ls Proper Email and move the Addre
100. Sequence C Settlement Instructions for Amounts Payable by Party A a Field Name Format aa 15C New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O Mandatory Sequence D Settlement Instructions for Amounts Payable by Party B field Field Name Format Mandatotys Tag Optional 15D New Sequence Empty field M 53a Delivery Agent A D or J O 13 26 ORACLE 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D orJ M 58a Beneficiary Institution A D or J O Optional Sequence E Settlement Instructions for Interests Payable by Party A a Field Name Format sa aia 15E New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O Optional Sequence F Settlement Instructions for Interests Payable by Party B ag Field Name Format Soi 15F New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O 13 27 ORACLE Optional Sequence G Ta
101. T 750 Advice Of DiSCFED Any ccccceicececeeettteeeeceenteeeeceeeneteeeesenaes 13 120 13 8 14 MT 752 Authorization to Pay Accept or Negotiate 0 csceee 13 121 13 8 15 MT 754 Advice of Payment Acceptance Negotiation ccceee 13 122 13 8 16 MT 756 Advice of Reimbursement or PayiMent uu eeececeeeettteeeeeeeeee 13 123 13 8 17 MT 760 Guarantee Standby Letter Of Credit 0 ececcecssseeeeeenees 13 124 13 8 18 MT 767 Guarantee Standby Letter of Credit Amendment 4 13 125 13 8 19 MT 768 Acknowledgement of a Guarantee Standby Message 13 125 13 9 Cash Management and Customer Status 20 0 0 ceeeeeceeeeeeeeeeeeeeeeeentaeeeeeeenaaes 13 126 13 9 1 MT 900 Confirmation Of D Dit cccccccccectececeeentteeeceetneeeeeeesneeteeeennaes 13 126 13 9 2 MT 910 Confirmation Of Credlit ere esiiecsesnreneriie iioi 13 126 13 9 3 MT 920 Request Message 0 eeseseeceeeeeentee eee eeennteteeeeeaaeteeeeeaaeeeeeenaaes 13 127 13 9 4 MT 940 Customer Statement Message scecceeenteeeceeenteeteeeeeaees 13 127 13 9 5 MT 950 Statement Message 00 cece eeeceecnnteeeeceeenteeeeeeeeaeeeeeeenaeeeeeeneaas 13 128 Eolo m eo os EEEE A A AE EE E AE A emiveindeaesdecententeeess 14 1 V4 A miroduc jo anea E A E E NE E EEE 14 1 TZ SMS LOG Reporoa a Aa A E T 14 1 14 2 1 gt Contents Of Re pOT e at a tie Wah ios So E a ae a ys a E 14 2 14 3 Unsuccessful Messages Report seseesssessrisseserrrssttirrsstirrns
102. The following SWIFT message types are generated for the various transfers that are initiated through Oracle FLEXCUBE Customer Payments and Cheques Category 1 consists of the following types of customer related payment messages e customer credit transfers e customer debit transfers 13 1 ORACLE 13 2 0 1 13 2 0 2 e cheque payments The messages in this category deal with payments or information about payments in which the ordering party or the beneficiary or both are not financial institutions MT 102 Multiple Customer Credit Transfer This message is sent by or on behalf of the financial institution of the ordering customer s to another financial institution for payment to the beneficiary customer It requests the Receiver to credit the beneficiary customer s directly or indirectly through a clearing mechanism or another financial institution or to issue a cheque to the beneficiary This message is used to convey multiple payment instructions between financial institutions for clean payments Its use is subject to bilateral multilateral agreements between Sender and Receiver Amongst other things these bilateral agreements cover the transaction amount limits the currencies accepted and their settlement Maximum Length 10000 Format Specifications Mandatory Sequence A General Information i Field Name Format ae 20 File Reference 16x M 2
103. Type Alc O 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22C Common Reference 4 la2 c4 n4 a2 c M 21N Contract Number Party A 16x M 21B Contract Number Party B 16x O 12F Option Style Alc M 12E Expiration Style Alc M 17A Barrier Indicator 1la M 17F Non Deliverable Indicator 1la M 22K Type of Event Alc 35x M 30U Date of Trigger Hit 8 n O 29H Location of Trigger Hit Alc O 82a Party A A D or J M 87a Party B A D or J M 83a Fund or Beneficiary Cus A D or J O tomer 77H Type Date Version of the 6a 8 n 4 n M Agreement 77D Additional Conditions 6 35x O 14C Year of Definitions Aln O Mandatory Sequence B Transaction Details i Field Name Format eset y 15B New Sequence Empty field M 13 20 ORACLE 17V Buy Sell Indicator 1la M 30T Trade Date 8 n M 30X Expiration Date 8 n M 29E Expiration Location and Time Alc 4 n M 30a Final Settlement Date ForJ M Optional Subsequence B1 Premium Details i Field Name Format Sear 37K Premium Price 3 a12d O 30V Premium Payment Date 8 n M 34B Premium Currency and Amount 3 a15d M Optional Subsequence B2 Calculation Agent Toti Field Name Format econ 84a Calculation Agent A B D or J O Optional Sequence C Settlement Instructions for Payment of Premium a Field Name Format se
104. UBE number Contract Status This is the contract status of the contract Auth Status This is the authorization status of the contract Maker ID This is the ID of the maker Maker Date Stamp This is the date on which the maker created the contract Checker ID This is the ID of the checker Checker Date Stamp This is the date on which the checker verified the contract Daily Swift Message Status Report You can invoke Daily Swift Message Status Report screen by typing MSRDSWFT in the field at the top right corner of the Application tool bar and click the adjoining arrow button The system will display Print Options screen Set your preferences as to printing the report and click OK button Daily Swift Message Status Report Branch All Single Branch Report Date Branch Code You can generate this report for all the branches or a single branch alone You can indicate the branch for which the report is being generated using the following options e All If you choose this the system will generate the report for all the branches am ORACLE e Single If you choose this you need to specify the branch code for which the report should be generated The option list displays all valid branch codes maintained in the system Choose the appropriate one Report Date Specify the report date from the adjoining calendar list 14 5 1 Contents of the Report The parameters specifie
105. a Date Time Closing Date Time A B or C O 22F Indicator see qualifier descrip 4 c 8c 4 c O tion 20C Reference see qualifier descrip 4 c 16x O tion 92a Rate see qualifier descrip A C orF O tion 99B Number see qualifier descrip 4 c 3 n O Count tion 19A Amount see qualifier descrip 4 c O tion N 3 a15d 70C Narrative Second Leg Narrative 4 c 4 35x 16S End of Block REPO Mandatory Sequence E Settlement Details Field Field er Mandatory Tag Name Field Description Format Optional 16R Start of Block SETDET M 22F Indicator see qualifier descrip 4 c 8c M tion Alc Mandatory Repetitive Subsequence E1 Settlement Parties 13 91 ORACLE s Fad Field Description Format Baie 16R Start of Block SETPRTY M 95a Party see qualifier descrip C P Q R orS M tion 16S End of Block SETPRTY M Repetitive Optional Subsequence E2 Cash Parties i sists Field Description Format cea 16R Start of Block CSHPRTY M 95a Party see qualifier descrip P R QorS M tion 97A Account see qualifier descrip 4c 35x O tion 70a Narrative see qualifier descrip E DDorC O tion 16S End of Block CSHPRTY M Optional Repetitive Subsequence E3 Amount i T Field Description Format S 16R Start of Block AMT M 19A Amount see qualifier descrip 4 c M tion N 3 a15d 16S End of Block AMT
106. a process in the Jobs Browser screen You can invoke the Jobs Browser screen by typing CSSJOBBR in the field at the top right corner of the Application tool bar and click on the adjoining arrow button The screen is as shown below Jobs Browser amp Search Advanced Search 49 Reset Case Sensitive Job Module om Process lt itsSCid Status 45 Records per page a Job Module ocess Process Sequence Number Status In the above screen you can base your queries on any or all of the following parameters and fetch records e Job Module e Process e Status 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 Job Module e Process e Process Sequence Number ra ORACLE e Status Check the required process in the search results table and click Start button to start the process Click Stop button to stop the process at any point 7 3 2 Printing of Advices In Oracle FLEXCUBE advices are generated during batch processing If you have started the background process system will search for the messages that are not generated The advices may be of two kinds e Advices that are not generated during contract authorization If you had not opted for message generation at the time of contract authorization e Advices tha
107. ages will be routed to the relevant queues as and when they come in without manual intervention You can configure the background process to begin when the Beginning of Day process is run or you can invoke it at any time in the day This screen CSSJOBBR CSSJMNTR can also be used to check whether the background process is running for outgoing and incoming messages Messages that are transmitted by mail will have to be handled manually Messages transmitted through media like Telex and S W I F T will be automatically routed to the relevant queues A unique reference number DCN is assigned to each incoming message Incoming messages which have an error will be moved to the error queue Manual Processing of Incoming Messages You will have to manually process incoming messages if e the background message process is not running e to route messages that cannot be routed to a user queue automatically If the background process is not running the messages that have come in to your bank will be stored in the incoming directory located on the node at which the database of your branch is installed To recall you have specified this directory in the MCS maintenance screen On invoking the Incoming Message Browser you should upload all the messages from the directory on the node All the incoming messages will be displayed in the Incoming Browser From the Incoming Message Browser screen you can receive messages that have come
108. ails of Query Oracle FLEXCUBE also provides you the option to order the information that you have made a query on You can further specify that the ordered information should be arranged in ascending or descending order Advanced Search Advanced Search Fields Operator Value Branch v DCN a ss Reference Number Query And Or Accept Clear Query Sender x Media Swift Message Type Test Word Authorization Status Status Suppress Options Process Status Order By Ascending v Accept Clear Quen Ok Cancel Suppose you have made a query to obtain details of the debit messages that were generated by the Data Entry module of Oracle FLEXCUBE and you wish to order the information in the ascending order of the customer to whom the message was sent Make the query following the procedure detailed under the head making a Query after you have specified the entire criterion for the query select the required ordering option from the Order By drop down list The list contains the following options e Ascending e Descending Click the option of your choice say Descending Click the Accept button and click Ok The details of the query that you have made will be displayed on the Outgoing Browser ordered on the basis of the customer to whom the message was sent The details will further be sorted in the alphabetic order If you decide to cancel the ordering you have sp
109. and Generate 101 selected Message Type Select the message type from the option list e MT101 e MT102 e MT102 Direction Indicate whether the BIC currencies amount maintenance is for incoming or outgoing or both type of messages You have the following options here e Incoming e Outgoing e Both Product for Consol Debt Specify the product for consolidated debit entry to ordering customer This can be specified for incoming MT101 No of Transactions per Message Specify the total number of transactions for each message MT101 ay ORACLE 3 8 1 Cutoff Incoming Specify the cutoff time in hours and minutes for the incoming messages Cutoff Outing Specify the cutoff time in hours and minutes for the outgoing messages Transaction Currency Limit Details The details displayed here depend on the direction specified They are used for MT101 MT102 and MT102 e If the direction is Incoming these fields indicate the transaction limit for individual transactions in the incoming message e If the direction is Outgoing these fields indicate the transaction limit for individual transactions in the outgoing message e Ifthe direction is Both these fields indicate the transaction limit for individual transactions in the outgoing and incoming message Incoming MT101 If the message is an incoming MT101 on receiving the message the following checks will be made before uploading the transactions e If the Sender has an a
110. andatory Sequence A General Information a Field Name Format einai 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22C Common Reference Ala2 c4 n4 a2 M c 23A Identification of the Swap 10a 5a M 21N Contract Number Party A 16x M 21B Contract Number Party B 16x O 30T Trade Date 8 n M 30V Effective Date 8 n M 30P Termination Date 8 n M 14A Business Day Convention 9a O 32B Currency Notional Amount 3 a15d M 82a Party A Aor D M 87a Party B AorD M 83a Fund or Beneficiary Cus A D or J O tomer 17A Collateral Agreement Indica 1 a O tor 77H Type Date Version of the 6a 8 n 4 n M Agreement 77D Additional Conditions 6 35x 14C Year of Definitions Aln 72 Sender to Receiver Informa 6 35x tion Optional Sequence B Fixed Interest Payable by Party B a Field Name Format a 13 41 ORACLE 15B New Sequence Empty field 37U Fixed Rate 12d 37N Details of Interest Rate 6 35x 13 42 ORACLE Optional Subsequence B1 Interest Details a Field Name Format a 18A Number of Repetitions 5n M 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d O 17F Period End Date Adjustment Indi 1la O cator 14D D
111. ay Count Fraction TX O 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M Optional Sequence C Floating Interest Payable by Party B i Field Name Format meaty 15C New Sequence Empty field M 14F Floating Rate Option 24x M 37J Cap Rate 12d O 37L Floor Rate 12d O 37N Details of Interest Rate 6 35x O Optional Subsequence C1 Interest Details E Field Name Format Ai 14J Reset Date Specification 5a M 14G Averaging Frequency and Method 1 a 8 a O 38E Designated Maturity 2n1 a M 18A Number of Repetitions 5n M 30F Payment Date 8 n M 17F Period End Date Adjustment Indica 1 a M tor 14D Day Count Fraction 7X M aa ORACLE 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M 37R Spread N 12d O 13 44 ORACLE Optional Subsequence C2 Compounding Details ae Field Name Format a 22D Compounding Type Alc M 18A Number of Repetitions 5n M 30X Compounding Date 8 n M Optional Subsequence C3 Interpolation for Stub Periods Fielg Field Name Format Mandarcry Tag Optional 38G First Stub Period Interpolation Period 2n1 a 2n1 a O 38H Last Stub Period Interpolation Period 2n1 a 2n1 a O Mandatory Sequence D Payment Instructions for Interest Payable by Party B S Field Name Format ean 15D New Sequence Empty field M 53a Delivery Agent AorD O 5
112. be performed on the message based on the Swift Key arrangement with the receiver The options available for choosing are Validate If you choose this option the system validates if a SK arrangement exists between your bank and the receiver If Yes then the original SWIFT message is generated otherwise the message will go to repair Generate FFT If you choose this option the system validates if a SK arrangement exists between your bank and the receiver If Yes then the original SWIFT message is generated otherwise MT 999 Free Format Messages will be generated instead of the SWIFT message No Validation If you choose this option you are instructing the system not to Validate but send the original SWIFT message always Processing SWIFT Messages if SK arrangement is Validate in the static messaging table Oracle FLEXCUBE checks for the value in the branch s SK arrangement Field If the field value is No validate Oracle FLEXCUBE will generate messages the normal way If the SWIFT keys have been exchanged then the swift message will be generated If SWIFT keys have not been exchanged with the receiver and the value of SK arrangement for the branch is Validate then the following messages will go to repair MT420 MT754 and MT756 For all other messages the original SWIFT message gets generated whether swift key exists or not If SWIFT keys have not been exchanged with the receiver and the value of SK arrangeme
113. capture addresses such as fax mail etc for the combination in the remaining address fields Name Specify the name of the customer here Address Enter the detailed address to which messages and advices generated should be sent to for a particular customer account under the selected media and location combination The format of the address depends on the media through which the message is transmitted If the address is for the media type mail you can enter the customers address in the four rows under this field Each line that you enter can contain a maximum of 35 characters If the media of transmission is Telex the address should be expressed numerically If you are defining a SWIFT address the address should be of eight or eleven characters alphanumeric Note The valid address e mail or Telex or SWIFT must be entered in the first line of the Ad dress field only for it to be used Add Hold Mail Text If this option is checked then all the mail advice generated for this customer and location would have the hold mail text displayed on top of the message As a consequence these mail advices would not be dispatched to the customer unless required Check this box to indicate you want the hold mail text to be displayed on top of the message indicating the branch 50F Party Details Specify the party details related to the ordering customer as a 5 line input here Line 1 indicates the party identifier and lines 2 to 5 in
114. cessing This option is applicable only for the STP messages Effective Date Specify the date from which the STP message maintenance becomes effective Effective date should be equal to or greater than the application date Task Type Select the task type from the adjoining drop down list This list displays the following values e MT Task e Business Task 19 14 ORACLE 11 1 11 2 11 3 11 Defining Free Format Messages Introduction In the course of your daily banking operations you may want to generate messages that are not automatically generated by the system or you may have to communicate a message that is very specific to a customer You can enter the details of such messages in the form of a free format message The details of a Free Format Message can be entered in the Free Format Message Maintenance screen In this screen some of the details you can indicate are e The format of the message e The recipient of the message e The media through which the message should be transmitted e The address and location to which the Free Format Message should be sent Invoking Free Format Message Maintenance Screen You can also invoke the Free Format Message screen by typing MSDFFT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The screen is shown below Free Format Message Maintenance E new E3 Enter query Document Numb
115. counts for the Sender and the funds are to be transferred between these accounts In addition it can be sent to a financial institution to debit an account of the Sender serviced by the Receiver and to credit an account owned by the Sender at an institution specified in field 57a Maximum Length 2000 1910 ORACLE 13 3 3 1 Format Specifications Field Name Format reset 19 Sum of Amounts 17d M 30 Value Date 6 n M 52a Ordering Institution AorD O 53a Sender s Correspondent A B or D O 54a Receiver s Correspondent A B or D O 72 Sender to Receiver Information 6 35x O 20 Transaction Reference Num 16x M ber 21 Related Reference 16x M 32B Currency Code Amount 3 a15d M 56a Intermediary AorD O 57a Account With Institution A B or D O 58a Beneficiary Institution AorD M 72 Sender to Receiver Information 6 35x O 13 3 4 MT 204 Financial Markets Direct Debit Message Claims funds from SWIFT member banks Maximum Length 2000 13 3 4 1 Format Specifications Sequence A S Field Name Format s 20 Transaction Reference Num 16x M ber 19 Sum of Amounts 17d M 30 Value Date 6 n M 57a Account with Institution A Bor D O 58a Beneficiary Institution AorD O 72 Sender to Receiver Information 6 35x O 13 11 ORACLE 13 3 5 Sequence B a Field Name Format ae 20 Transaction Reference Num 16x
116. covers deals which are not part of an ISDA Deutscher Rahmenvertrag f r Finanztermingesch fte or BBAIRS Master In this case party A and party B must have another bilateral agreement in place except under AFB Association Fran aise de Banques 1949 ORACLE Master until the AFB does define the interbank confirmation for cross currency swaps the MT 361 cannot be used to confirm such transactions This message may also be sent by a money broker to the two parties party A and party B for which the broker arranged the deal If there are two money brokers involved in arranging a deal between party A and party B this message is also exchanged between these money brokers The message may be used to e confirm the details of a new transaction between the parties e correct a previously sent confirmation e cancel a previously sent confirmation Maximum Length 10000 330 ORACLE 13 4 10 1 Format Specifications Mandatory Sequence A General Information a Field Name Format meetin 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22C Common Reference Ala2 c4 n4 a2 M c 23A Identification of the Swap 10a 5a M 21N Contract Number Party A 16x M 21B Contract Number Party B 16x O 30T Trade Date 8 n M 30V Effective Date 8 n M 30P Termination Date 8 n M
117. d to the format The details of the format will automatically become applicable to the message After you assign a code to a format you can indicate e The number of lines that should be contained in a page when the advice is printed e The number of columns that should be contained in a page when the advice is printed e The language of the message e The form type attached to the format Language A message can be sent to a customer in different languages To make this possible you need to maintain a format in different languages While maintaining addresses for a customer in the Customer Address Maintenance screen you can indicate the format and language in which a message should be sent ma ORACLE Note You should maintain Advice format in the languages maintained in Language field in Main tab of Customer Maintenance web page dialogue fast path STDCIF for customers of the Bank in addition to advice format maintained in ENG English Form Type Specify the form type that applies to the message Select a form type from the adjoining option list Entering an advice format using the format editor To enter a format using the format editor click free format text icon positioned next to Format Text In the note pad that is invoked you can actually tailor an advice to suit your requirements The format editor has certain keywords which signify different options which you can use to create a format
118. d while generating the report are printed at the beginning of the report Other content displayed in the report is as follows Header The Header carries the title of the report branch code branch date user ID module from which the report has been generated date and time at which the report has been generated and the page number of the report Body You can find the following details in the body of the report Date of Receiving Indicates the date of receiving Value Date Indicates the value date Remitting Bank Indicates the name of remitting bank Branch Name Indicates the name of the branch Amount of Remittance Indicates the amount of remittance Currency of Remittance Serial Numbers Indicates the currency of remittance Indicates the serial numbers Contract Reference Indicates the contract reference Sender Indicates the name of the sender 14 6 Statement Message Status Report You can invoke Statement Message Status Report screen by typing MSRSTMSG in the field at the top right corner of the Application tool bar and click the adjoining arrow button The 14 5 ORACLE 14 6 1 system will display Print Options screen Set your preferences as to printing the report and click OK button Statement Message Status Report Branch All Single Branch dae Report Date Branch Code You can generate this re
119. datory Tag Name Description t Optional 16R Start of Block LINK M 16S End of Block LINK M 16S End of Block GENL IM 13 93 ORACLE Mandatory Sequence B Trade Details Field Field x aii Mandatory Tag Name Field Description Format Optional 16R Start of Block TRADDET M 94B Place Place of Trade 4 c 8c 4 c O 30x 98a Date Time see qualifier description A B C or E M 90a Price Deal Price AorB 35B Identification of the Finan ISIN1 e12 c M cial Instrument 16S End of Block TRADDET M Mandatory Repetitive Sequence C Financial Instrument Account Field Field Name Field Description Format Mandatory Tag Optional 16R Start of Block FIAC M 36B Quantity of Quantity of Finan 4 c 4 c M Financial cial Instrument to 15d Instrument be Settled 95a Party Account Owner PorR 97a Account see qualifier AorB description 16S End of Block FIAC M Optional Sequence D Two Leg Transaction Details Field Field Name Field Description Format Mandatory Tag Optional 16R Start of Block REPO M 98a Date Time see qualifier descrip A B or C O tion 22F Indicator see qualifier descrip 4 c 8c 4 c O tion 20C Reference see qualifier descrip 4 c 16x O tion 92a Rate see qualifier descrip A C orF O tion 13 94 ORACLE
120. dicate the name and address details of the party You can use either of the following line formats with option F e Line 1 Party Identifier 34x Account oe ORACLE 6 2 2 1 e Lines 2 5 Name amp Address 1 n 33x Number Details Or e Line 1 Party Identifier 4 a 2 a 27x4 a 30x Code Country Code Identifier e Lines 2 5 Name amp Address 1 n 33x Number Details The details specified here are used for a stricter validation of the details related to the ordering customer The validations are carried out according to the rules indicated below e Validations for line1 party identifier applicable for the second format listed above Line 1 has to comply with Code Country Code Identifier format where the country code should be a valid ISO country code The first 4 characters specified should be a valid party identifier code supported by SWIFT e Validations for lines 2 to 5 name and address details of the party The first line must start with number 1 Line numbers must appear in numerical order Line number 2 cannot be used without line number 3 and vice versa Line number 4 cannot be used without line number 5 and vice versa Line number 4 should have the format YYYYMMDD and this date must not be greater than the date on which the message was sent to SWIFT Line numbers 3 5 6 and 7 should be followed by a valid ISO country code Line numbers 3 4 5 6 7 and 8 should not rep
121. directly arriving to JMS queue instead of a folder the same MDB is configured to listen on specific queue The following diagram illustrates incoming EMS process in Job Scheduler Polling incoming messages folder for messages Read the message from Ready folder No file to read Send the message to an internal JMS queue Move the message file from ready folder to processed folder Transaction Limit Exception Or Transaction Limit Exception Occurred Commit Transaction Rollback Transaction Set next fire time for the job 26 ORACLE The following diagram illustrates incoming EMS process in MDB EMS MDM listens on in incoming messages JMS queue On message Identify the message terminator and split the messages Select messages one by one All messages processed Call the backend package to process messages incoming If response is routing required Route the request to corresponding branch specific schema If any exception Yes Rollback the transaction 2 7 Commit Transaction ORACLE 3 1 3 2 3 Maintaining Messaging Branch Preferences Introduction The messaging preferences that you indicate for your branch will govern the workflow aspects of the messaging system module You can specify messaging preferences for your branch in the Messaging Branch Preferences screen In this screen you can indicate
122. e Principal Payable by Party A na Field Name Format Ha aid 15D New Sequence Empty M field 33F Calculation Notional Currency and 3 a15d M Amount 30X Period Start Date 8 n M 30Q Period End Date 8 n O 37G Reset Rate N 12d M 37J Cap Rate 12d O 37L Floor Rate 12d O 37R Spread N 12d M 37M Total Rate N 12d M 30F Payment Date 8 n M 32H Currency Interest Amount N 3 a15d O 33E Currency Principal Exchange 3 a15d O Amount 37N Details of Interest Rate 6 35x O Optional Sequence E Net Amount s Payable by Party A i Field Name Format usa 15E New Sequence Empty M field 18A Number of Repetitions 5n M 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD M 13 4 12 MT 364 Single Currency Interest Rate Derivative Termination Recoupon ing Confirmation This message is exchanged by or on behalf of the institutions or corporates party A and party 13 63 ORACLE B which have agreed to the termination partial termination or recouponing of a single currency interest rate swap a cap a collar or a floor The terminated recouponed transaction is covered by a BBAIRS ISDA or AFB or another bilateral agreement This message may be used to e confirm the details of the partial or full termination of an existi
123. e of Operation Alc M 94A Scope of Operation Alc O 22C Common Reference Ala2 c4 n4 a2 M c 23A Identification of the Swap 10a 5a M 21N Contract Number Party A 16x M 21B Contract Number Party B 16x O 30V Effective Date 8 n M 30P Termination Date 8 n M 82a Party A Aor D M 87a Party B AorD M 83a Fund or Beneficiary Customer A D or J O 29A Contact Information 4 35x O 72 Sender to Receiver Informa 6 35x O tion Optional Sequence B Interest Rate Principal Payable by Party B rieg Field Name Format Mandatory Tag Optional 15B New Sequence Empty M field 33F Calculation Notional Currency and 3 a15d M Amount 30X Period Start Date 8 n M 30Q Period End Date 8 n O 37G Reset Rate N 12d M 37J Cap Rate 12d O 13 61 ORACLE 37L Floor Rate 12d O 37R Spread N 12d M 37M Total Rate N 12d M 30F Payment Date 8 n M 32H Currency Interest Amount N 3 a15d O 33E Currency Principal Exchange Amount 3 a15d O 37N Details of Interest Rate 6 35x O Optional Sequence C Net Amount s Payable by Party B T Field Name Format AE 15C New Sequence Empty M field 18A Number of Repetitions 5n M 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD M 13 62 ORACLE Optional Sequence D Interest Rat
124. e should be unique as it is used to identify the media When you need to indicate that a message should be transmitted through a particular media type you just need to specify the code assigned to the media type The message will be routed automatically through the media You can enter a short description of the media type that you are maintaining The description will help you identify the code that it represents Opting for Message Markers You can opt to append end message markers to outgoing messages generated in a media These markers are referred to as Padding Characters in Oracle FLEXCUBE Padding characters would typically be a standard set of characters probably repeated The padding characters that you specify will be inserted automatically at the end of every outgoing 2 ORACLE message in the media You can indicate the padding characters that mark the end of an outgoing message in a specific media in the Message Suffix field When defining a media you can also capture the padding characters that mark the end of incoming messages in the media The system identifies the end of an incoming message in a file containing several messages when it encounters the padding characters you have captured for a media type Enter the padded characters that mark the end of incoming messages in a media in the Message Terminator field Note For Message suffix to be used for Outgoing messages the Padding Required option
125. earlier a customer of your bank can have several addresses for the same media To differentiate between one address of a customer and another for a given media it is mandatory for you to specify a unique location for each address The location that you specify for an address is used as a unique identifier for the customer address A single customer can have any number of accounts You can choose to link a specific location with an Account Number Maintaining multiple locations for the customer facilitates the sending of interest and account statements to more than one address of the customer If an address is maintained at the Customer Account Definition level all statements pertaining to the particular account will be sent only to the address specified at the account level irrespective of the message and location maintenance for the Customer You can choose from the available list and indicate the Account Number which should be linked with the respective address Note You are allowed to link a customer address with an account only for a specific branch which means that the branch should be a valid branch code in the system If you use the wildcard All indicating that the customer address and account linkage is valid in all the branches of your bank you will not be able to exercise this option Language In this field you can specify the language in which the messages sent to the address should be expressed You can choose a
126. eat Line numbers 1 and 2 can repeat Line 8 is used as additional information When the account identifier format is used then in the case of Line 8 being used either line 6 or line 7 should be used When the party code identifier format is used then Line 8 can be the continuation of line 1 line 6 or line 7 Line 6 or 7 need not be mandatorily be used During contract input the ordering customer record is searched in the customer addresses maintained and if found the corresponding 50F details are defaulted to the contract If not found the address details default from customer maintenance These validations are carried out for the following outgoing message types and appropriate error messages are displayed incase of any mismatches e MT101 e MT102 e MT102 e MT103 e MT103 e MT210 e MT910 Specifying Message Address For a customer address message type combination you can indicate the branch es from which the message can be sent to the address With Oracle FLEXCUBE you can offer your customers the facility to effect a transaction from any of the branches of your bank Hence you Can indicate the branches from where a message should be generated You can select a branch code from the option list that is available pai ORACLE Note You can use the wildcard All indicating that the message can be sent to the address in the defined format from all the branches of your bank For example if you indicate Al
127. ecified click Clear Query The screen clears and you can specify a new order Using Wildcards to make Query You need not always specify the criteria for a query You can use wild cards such as Wild Card Description Implication z Underscore To match a single character Percent To match any string of multiple characters i ORACLE Using For instance if you have to check the messages relating to one particular Loans product LD01 you can query for records with Reference Number like LD0O1 since all the contract reference numbers with that product will invariably contain that string Once you click the Accept button and make a query the Outgoing Message Browser screen displays all the Free Format Texts Using And When you are searching for strings of specific length which vary in only one character for instance all branches like 001 002 003 can be represented as 00_ Searching for 00_ will fetch all the messages for all these three branches 125 ORACLE 13 1 13 2 13 Processing SWIFT Messages Introduction SWIFT is the Society for Worldwide Interbank Financial Telecommunication a member owned cooperative through which the financial world conducts its business operations with speed certainty and confidence SWIFT enables its customers to automate and standardise financial transactions thereby lowering costs reducing operational risk and eliminati
128. ectory and the Unix Out Directory For a Windows Server the In Directory and Out Directory must be maintained e Queue If you select Queue as the delivery type you must specify In Queue Out Queue and the type of queue i e Microsoft Message Queue or WebSphere Messaging Queue Media Control System In Oracle FLEXCUBE each media control system that you maintain is identified by a 15 character code called an MCS code You can follow your own convention for devising this code The code that you assign an MCS should be unique as it is used to identify the external source Node A node is the Database instance on which Oracle FLEXCUBE is installed On assigning a code to an MCS you can indicate the node or server at which the MCS is located A branch s database is located in a node and an MCS is also installed in a node Thus while defining an MCS you need to indicate the node at which it has been installed a2 ORACLE Media You need to also specify the media for which your bank is using the MCS For example if you set up an MCS say MCSSWIFT and indicate the media type as SWIFT it indicates that Oracle FLEXCUBE can receive and transmit SWIFT messages through the MCS MCSSWIFT The following diagram illustrates a typical MCS setup Status You need to indicate the status of an MCS The status options available are e Active and e Passive It is only when an MCS is active that message
129. eeeeeceeeeeeeneeeeeeeeaes 11 1 11 3 1 Entering Details of a Free Format MeSSaQe ccccccseseeeeenteeeeeeeennees 11 3 11 3 2 Entering an Advice Format using Format Editor 0 ccccccscceesseeeeeeenees 11 5 11 3 3 Importing Advice Format from an ASCII File on the Server uu 11 5 11 3 4 Importing Advice Format from ASCII File On CliONt cccccccceeeeeeneees 11 6 11 3 5 Sending Free Format Message cccccseeeeeeeenteeteeeeeneeeeeeeenaeeeeeseaaaes 11 6 FIs 3 62 SAVING RO COU aiisizics seis cai AAE A stag tnelas 11 6 11 3 7 Viewing SWIFT Messages 00 ececeeeeeeetete eee teeeeeeeeeteeeaaeeeetenaaeeeetneenaeeees 11 7 11 4 Maintaining Common Group Messages eeceeeeeeeeeeeeee eee tenaeeeeeeteeeeeeeetneeeeeetaa 11 7 11 5 Maintaining SWIFT FFT Template 20 00 00 cceeceeeeeeeeeeceeeeseeeeeeeeeeeeeneeeeeeeeeneeeees 11 10 Making QUI Y cccise secs cece ca cecac cca vee tcos sia acai sesasusasecacasaceccesecusdtceicasacdesees 12 1 42 4 sIMtrOUUCTON section eee vercs A EA E EA EO A 12 1 1222 IPPOCEO URE Seite EEA ck oe eed O cate E EEEN EEE OAE A 8 teresa 12 1 12 3 Making Query based on more than one Criterion eeeeceeeeeeeeeeeeeeenteeeeeeeeaes 12 2 12 4 Selecting Same Criterion to Apply One or More Conditions 12 2 12 5 Ordering Details Of QUOLY serrian a i T TE T E T a 12 4 12 6 Using Wildcards to make Query ssssseesseserireseerrrsstrrrsssetrrsssttrrrsssttnnsssttnnssseenn 12 4 13 Processing SWIFT Messages
130. efore the End of Day process EOD is run a ORACLE 6 1 6 2 6 Maintaining Addresses for Customer Introduction The messages and advices that are sent to the customers of your bank can be transmitted to various addresses through the media types that you maintain in the Media Maintenance screen In this Address Maintenance screen some of the details that can be maintained are e the media through which messages to a customer should be transmitted e the address es of a customer for each media type e the answer back code for a telex advice e a Test Word for the customer e the messages that should be sent to an address e the language in which messages should be sent to a customer address e specifying the Delivery By as FILEFACT while maintaining the Customer Address Information for MT 102 Type of messages A customer of your bank can have several addresses for a given media To distinguish between one address and another for the same media you can capture an address for every Location Note The addresses that you maintain for a customer in this screen are in addition to the ones maintained in the Customer Information File CIF of the Core module Customer Account Address Maintenance Screen You can invoke the Account Address Maintenance screen by typing MSDCACAD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow bu
131. elp Menu of the software You can further obtain information about to a particular field by placing the cursor on the relevant field and striking the lt F1 gt key on the keyboard Audience This manual is intended for the following User User Roles Role Function Back office data entry clerk Input functions for contracts Back office managers officers Authorization functions Product Managers Product definition and authorization End of Day operators Processing during End of Day Beginning of Day Financial Controller Product Manag Generation of reports ers Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http Awww oracle com pls topic lookup ctx acc amp id docacc Organization This manual is organized into the following chapters Chapter 1 About this Manual gives information on the intended audience It P also lists the various chapters covered in this User Manual Chapter 2 Messaging System An Overview is a snapshot of the features that the module provides Maintaining Messaging Branch Preferences specifies the messag Chapter 3 ing branch preferences t1 ORACLE Maintaining Media Types discusses the procedure to maintain Chapter 4 details of the media through which messages can be transmitted from and to your bank
132. en or printed by the users who have access to the queue You can move messages from one end user queue to another as well For a message that was transmitted through Telex you should enter the testword and have it authorized before you can route it to the rele vant end user queue Linking the message to a contract In the browser select the message with which you want to associate a Link contract and click on the Link Contract button The Reference Num Contract ber option list is enabled for the selected message You can select the appropriate contract from the list The message will be subsequently associated with the contract selected here Uploading incoming messages If the background process for incoming messages is not running you will have to upload the messages that have come into your bank from the incoming directory on the node to which your branch is connected Upload To upload messages from the incoming directory specified in the MCS maintenance screen click the Upload button All messages that were stored in the Incoming Directory will be uploaded to Oracle FLEXCUBE and displayed in the Incoming Message Browser Editing the Incoming Message Edit Click Edit Message button if you wish to make changes to the SWIFT message especially the messages marked for repair This is explained in the next Section it ORACLE Authorizing the Incoming Message Use Authorize
133. enquire about the fate of documents sent for collection Maximum Length 2000 13 73 ORACLE 13 5 5 1 Format Specifications Pieid Field Name Format Mandatory Tag Optional 20 Sending Bank s TRN 16x M 21 Related Reference 16x M 32a Amount Traced A B or M K 30 Date of Collection Instruction 6 n 59 Drawee 34x 4 35x 72 Sender to Receiver Informa 6 35x O tion 13 5 6 MT 422 Advice of Fate and Request for Instructions This message type is sent by the collecting bank to the remitting bank It may also be sent by a collecting bank to another collecting bank It is used to advise the Receiver of the status of collection documents received by the collecting bank Since an advice of fate generally includes one or more questions or requests the two functions are included in this one message type Maximum Length 2000 13 5 6 1 Format Specifications ie Field Name Format Mandatory Tag Optional 20 Sending Bank s TRN 16x M 21 Related Reference 16x M 32a Amount of Collection A B or O K 72 Sender to Receiver Informa 6 35x O tion 75 Queries 6 35x 76 Answers 6 35x 13 5 7 MT 430 Amendment of Instructions This message type is sent by the remitting bank to the collecting bank It may also be sent by a collecting bank to another collecting bank This message is used to amend instructions contained in the collection eas ORACLE
134. ent Customer NO7 This message will be generated for the return of incoming payment This mes sage will be gener ated when authorizer rejects the incoming payment from the incoming authoriza tion queue or repair queue The product category for this return of incoming payment transaction will be picked up from the product category of incoming payment NEFT Incoming Incoming Payment Customer N02 This is a Incoming NEFT Payment NEFT Incoming Reject of Outgoing Payment Customer N02 This Message is for a return of our Outgo ing Payment Check the Related Refer ence Number tag in the message If the field is there then it is a Return of Outgoing Payment ORACLE NEFT Incoming Reject of NO3 This Message is from Outgoing RBI for a return of our Payment Outgoing Payment There are two Possi bilities of this Mes sage it can be a Reject of the Outgo ing Payment or a Reschedule Message to Find out whether it is a Reject mes sage Check the Related Reference Number and Reject Codes if the Reject code doesn t fall into the Reschedule list then it is a reject of Outgoing Payment otherwise Resched ule Message and the message status will be updated as Rescheduled RS NEFT Incoming Work NO3 This Message is from flow Resch RBI for a reschedule edule of our Outgoing Pay ment The reject code type of this message will
135. ent Non Acceptane ccccceesseeeenteees 13 72 13 95 90 MT 420 TOCO arepa asi essen aati ee GN eae deg eed 13 73 13 5 6 MT 422 Advice of Fate and Request for Instructions ccccccceceeees 13 74 13 5 7 MT 430 Amendment Of INStrUCtIONS ccccccctetseeeetettteeeeteeneaeeeetnenatees 13 74 13 6 Se CuUritioS MArKOts iora r tac sdeadee E Seecaes eb agenerachane 13 75 13 6 1 MT 517 Trade Confirmation Affirmation ccccccccseccceentieeeeeenteeeeeeeeaes 13 75 13 6 2 MT 518 Market Side Securities Trade Confirmation ccccceseeeeeees 13 76 13 6 3 MT 540 ReCCIVG FTO mircarreiirisriii estiidi neng erii aE iA EEA EEEE 13 82 13 6 4 MT 541 Receive Against Payment ccccccccceeteeeteeenteeeeteneaeeeeeeenanees 13 85 13 6 5 MT 542 Deliver Free a a p e e a E oa e a a E EEEa 13 89 14 13 6 6 MT 543 Deliver Against Payment cccccccecceeeeenteeeeeeeentieeeeeennaeeeeeeeenaes 13 93 13 6 7 MT 592 Request for Cancellation 221 scccccccceceeceeeeteetecsennsseeeeseeseeens 13 96 13 6 8 MT 598 Proprietary Message ccceccenteeeeceenteeeeteseneeeetseenaeeeeeeeeaaes 13 96 13 7 Treasury Markets Metals cccceceseeeeeeeeeseeeeeeeeeeeeeeeeeeeseeeeeeeeseeeaeeeseeeenaneees 13 97 13 7 1 MT 643 Notice of Drawdown Renewall cccccccssceeeeesteeeeteenteeteeseenaees 13 97 13 7 2 MT 644 Advice of Rate and Amount FIXING ccceeeseeteteeeetteeeteeeneeees 13 99 13 7 3 MT 645 Notice Of Fee DUC
136. er Customer Name Module Address Customer Media Location Node Form ADV Date Copies External Reference No Hold Test Word Required Running Number Contract Reference TAGS Import File imor Message Swift Message Free Format Text Server Fields Input By Authorized By Modification Wi Authorized Date Time Date Time Number Open Features of Free Format Message Screen You can specify the following details on this screen Document Number System generates the document number on save Module Select the module from the drop down menu for which you are entering the details in this screen i ORACLE Customer Select the code of the customer to whom the message is addressed from the option list If the recipient is not a customer of your bank then specify his her name in this field Media You can indicate the media through which the Free Format Message should be transmitted The media through which you can channel a Free Format Message depends on the media types that you have maintained for your branch in the Media Maintenance screen You can choose a media code from the option list that is available Location You should also specify the location of the address To recall the location that you specify for an address is the unique identifier between the other addresses of the customer for a given media The address of the customer will be automatically displayed based on the customer locat
137. er to Receiver Informa 6 35x O tion 13 16 ORACLE 13 4 2 Optional Sequence D Split Settlement DetailsMT 305 Foreign Currency Option oa Field Name Format noha 15D New Sequence Empty field M 17A Buy Sell Indicator 1la M 32B Currency Amount 3 a15d M 53a Delivery Agent A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O 16A Number of Settlements 5n M Confirmations This message type is exchanged between the financial institutions which have agreed to a foreign currency option contract It is used to confirm the details of e anew contract between the parties e an amendment to a previously agreed contract e the cancellation of a confirmation the surrender of an option by the buyer holder to the seller grantor for compensation Maximum Length 2000 oa ORACLE 13 4 2 1 Format Specifications it Field Name Format ar 15A New Sequence M 20 Transaction Reference Num 16x M ber 21 Related Reference 16x M 22 Code Common Reference 8a M Ala2 c4 n4la2 c 23 Further Identification 16x M 94A Scope of Operation Alc O 82a Party A A D or J M 87a Party B A D or J M 83a Fund or Beneficiary Customer A D or J O 30 Date Contract Agreed 6 n M Amended 31C Earliest Exercise Date 6 n O 31G Expiry Details 6
138. erence see qualifier descrip 4 c 16x O tion 92a Rate see qualifier descrip A C orF O tion 1394 ORACLE 13 6 4 19A Amount see qualifier descrip Alc O tion N 3 a15d 70C Narrative Second Leg Narrative 4 c 4 35x 16S End of Block REPO Mandatory Sequence E Settlement Details Field Field bead Mandatory Tag Name Field Description Format Optional 16R Start of Block SETDET M 22F Indicator see qualifier descrip 4 c 8c M tion Alc Mandatory Repetitive Subsequence E1 Settlement Parties Field Field er Mandatory Tag Name Field Description Format Optional 16R Start of Block SETPRTY M 95a Party see qualifier descrip C P Q R orS M tion 97a Account Safekeeping Account AorB 16S End of Block SETPRTY Optional Repetitive Subsequence E3 Amount Field Field sgi Mandatory Tag Nam Field Description Format Optional 16R Start of Block AMT M 19A Amount see qualifier descrip Alc M tion N 3 a15d 16S End of Block AMT M 16S End of Block SETDET M MT 541 Receive Against Payment This message is sent by an account owner to an account servicer account servicing institution The account owner may be a global custodian which has an account with its local agent sub custodian or an investment management institution or a broker dealer which has an account w
139. erest 8 n O Period 38J Number of Days 1la3 n O Mandatory Sequence C Settlement Instructions for Amounts Payable by Party A i Field Name Format sae 15C New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O Mandatory Sequence D Settlement Instructions for Amounts Payable by Party B zA Field Name Format aoe 15D New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O oo ORACLE 56a Intermediary A D or J 57a Receiving Agent A D or J 58a Beneficiary Institution A D or J O Optional Sequence E Settlement Instructions for Interests Payable by Party A ig Field Name Format aa 15E New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O Optional Sequence F Settlement Instructions for Interests Payable by Party B Zor Field Name Format a 15F New Sequence Empty field M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 56a Intermediary A D orJ O 57a Receiving Agent A D orJ M 58a Beneficiary Institution A D or J O Taal
140. esent in the incoming message then the message upload will continue as normal In the case of incoming messages with a PDE trailer the PDE Flag check box in the Incoming Message Browser screen will be checked For more details on the PDE indication of an incoming message in the Incoming Message Browser refer section Viewing the details of an Incoming Message in Processing Incoming Messages chapter of this User Manual 3 21 ORACLE 3 7 1 2 Outgoing PDE Messages 3 8 In the case of outgoing messages you can decide to do any of the following if the system detects a message as a duplicate based on the PDE validations e Auto release the message with the PDE trailer e Release the message without the PDE trailer e Reject the message System displays an override when it finds a message to be a duplicate one In this case the message is parked in the PDE queue and you can either opt to release the message without the PDE trailer or else release it with the PDE trailer If you opt to release the message with the PDE trailer then the message is appended with PDE else the message is released without PDE You can also choose to reject the message In this case the message status will be changed to E Exception and this will not be picked up by EMS Electronic Messaging System Due to message size restrictions in Oracle FLEXCUBE sometimes a single message is physically split into multiple parts and each one
141. ess Indicates the address Currency Indicates the currency of the transaction Amount Indicates the amount 14 7 ORACLE 15 Function ID Glossary c MSDMPREV cssssssseseesee 3 10 CSSJOBBR oosccssssssessssssessees 7 5 MSDMSGTM 2 eeceeeeseeeeees 3 9 MSDMSTYP c seseseseesseeeee 3 7 MSDPREF sustcnsseatius 3 1 IMAGE saesssssssesessseeeeereseseeees 5 3 MSDQUEUE sssseeesseeee 3 6 ISDCCYRS on esscessssssseensssee 3 23 MSDSTPSC esssscssseeesee 10 13 MSRDSWFT o ssssssssseeeesee 14 4 M MSRMSRPT vv ss 1111111111 14 1 MSDADVFT sesssseseseesseeees 7 1 MSRPLEXP 44 2 VRAC ACA E soria o MSRPLSUX s s s1 s111 111111111 14 3 MEDE OMME siea ue MSRSTMSG ssns s111 111111122 14 5 MSDCUSAD sssssseesseeee 6 6 MSSCUSAD 6 14 ODE DE arteries os MSSETPDE ssssseeeseseee 8 10 MSDFFT eee eee ee eee eee rere eee 11 1 MSSINBRS EEE E EA 10 2 MSD PIMP eee eterna met MSSNOTIF csccceeeeee 10 12 MSDINRUT eee eee eee eee es 3 5 MSSOUBRS ete Sent E Sea 8 2 MSDMCS eee eee eer eee eee reer 5 1 MSSUNARC PESA EEA 9 1 MSDMEDIA ccsssssseseesseeee 4 1 1321 ORACLE
142. essage Maintenance R New 9 Enter Query Customer Media Location Node Date External Reference No Import File Message Swift Message Free Format Text SWIFT Message Type 199 20 21 Form ADV Copies Hold _ Test Word Required Running Number Contract Reference TAGS Input By Authorized By Date Time Date Time Modification Number Wi Authorized H Open 11 4 Maintaining Common Group Messages You can maintain common messages that need to be sent to a group in the Common Group Message Maintenance screen You can invoke the Common Group Message Maintenance ORACLE screen by typing MSDCOMMS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Common Group Message Maintenance E New E3 Enter query Customer Name Reference Number Address Media Address 2 Location Address 3 Node Address 4 Date Form Swift Message Type Number Of Copies Response To Incoming Hold Reference Number For ery Import File Serer Template Id e Fields Input By Authorized By Modification Mi Authorized est Date Time Date Time Number Ml Open You can specify the following details in this screen Customer Select the code of the customer to whom the message is addressed from the option list Media The media through which the common group message is transmitted is displayed here SWIFT is displayed by default Location Specify
143. etails button Incoming Message Browser amp Enter Query Document Number Reference Number Sender Media SWIFT Message Type Queue Operation Customer Name Address Address 2 Address 3 Address 4 Location Process Status PDE Flag Checker Date Stamp Checker Id Mod Number The following details regarding the incoming message are displayed in the above screen e DCN Status Branch Currency Media Control System Amount Node Value Date Test Word External Reference Repair Reason Multi Credit Reference Required Execution Date Suppress Details Remarks Suppress Options Entry By Suppress Status Maker Date Stamp Funding Exception Cover Match Status Status Authorization Status 10 9 m ORACLE Reference Number Sender Media Swift Message Type Queue Operation Status Currency Amount Value Date External Reference Number Multi Credit Reference Number Branch Media Control System Node Test Word Repair Reason Name Address Location Process PDE Flag Suppress Options Remarks Auth By Entry By Mod No Checker Date Stamp Maker Date Stamp Suppress Status Funding Exception Status Cover Match Status Authorization Status 10 2 7 Editing Incoming Message An incoming message can be edited by invoking the Edit function in the Incoming Messages Browser On pressing the Edit Message button the message is displayed in edit mode Only a user with requisite ri
144. firm notify the details of e anew contract between the parties e an amendment to a previously agreed contract e the cancellation of a confirmation 13 82 ORACLE Maximum Length 10000 13 4 6 1 Format Specifications Mandatory Sequence A General Information a Field Name Format i 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22C Common Reference 4 a2 c4 n4 a2 M c 23D Type of FRA 10a M 21N Contract Number Party A 16x O 21B Contract Number Party B 16x O 82a Party A Aor D M 87a Party B Aor D M 77H Type Date Version of the 6al 8 n 4 n M Agreement 14C Year of Definitions Aln O Mandatory Sequence B Transaction Details iy Field Name Format an 15B New Sequence Empty field M 30T Trade Date 8 n M 32B Currency Notional Amount 3 a15d M 30F Effective Date 8 n M 30P Termination Date 8 n M 37M Fixed Rate N 12d M 14F Floating Rate Option 24x M 13 33 ORACLE Optional Subsequence B1 AFB and FRABBA Details a Field Name Format Sea 30V Fixing Date 8 n M 38D Contract Period 4n M Mandatory Subsequence B2 Other Details B Field Name Format sarad 38G Designated Maturity 2n1 a 2n1 a M 14D Floating Rate Day Count Fraction 7X M 17F FRA Discounting 1la M 18A Number of Repetitions 5n M 22
145. format editor on the screen to enter the format or e Importing the format from an ASCII file which can be located either on the Server Client Note Message formats are maintained at the bank level and will be applicable to all the branch es of your bank 7 2 Advice Format Maintenance Screen You can invoke the Advice Format Maintenance screen by typing MSDADVFT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button fal ORACLE If you are maintaining a new advice format click the New button on the Application tool bar The Advice Format Maintenance screen is displayed without any details Advice Format Maintenance E New amp Enter Query Format Lines Language Columns Form Type Import File Format Text Message Format of SEES 1 co Et Input By Authorized By Modification Date Time Date Time Number Wi Authorized E Open You can specify the following details pertaining to a format Format In Oracle FLEXCUBE each format that you define is identified by a fifteen character code called a Format code You can follow your own convention for devising this code The code that you assign to a format should be unique as it is used to identify the format You can compare simple conditions while defining message formats When you need to use a format that you have defined you need to just specify the code assigne
146. g ELCs Date Time Checker Date Time Mod No Record Status Authorization Status Note You can query or modify the customer details whose accounts are permitted to you for the query modification in the Group Code Restriction screen If you are maintaining a new address for a customer select New from the Actions Menu or click new icon on the toolbar The screen is displayed without any details If you are calling a customer address record that has already been defined double click ona record from the summary screen In the Summary screen all the customer address records that you have entered are displayed in a tabular form Note Oracle FLEXCUBE generates a notification message when a new customer address is created and authorized This notification message can be sent to any external system if required oF ORACLE Customer No Specify the customer CIF number assigned to a customer in the Customer Information Maintenance screen before you capture the different addresses of the customer The name of the customer whose address you are maintaining is automatically displayed when you indicate the customer s identifier Media The types of media for which you can capture addresses include Mail E Mail Telex SWIFT FAX and FILEACT interface to TIPA network The Media details maintained in Media Maintenance screen will appear in the list of values Location As discussed
147. ge will be displayed on the screen Importing an advice format from an ASCII file on the client Client refers to your own machine To import a format from an ASCII file on the client 1 Click against the field marked Client 2 Specify the full path to the file on the client which contains the format you want to import 3 Thereafter click Import button The file containing the format of the message will be displayed on the screen Indicating Messages that should Use Format After you have defined a format and assigned it a code you can indicate the list of messages that should use the format The format that you define for a message in this screen is taken to be the default format that will be used whenever the message is generated from your bank For each message that you specify you can also indicate the specific details of the following for which the format should be used e Module e Branch e Currency e Product e Media Thus you can specify a different format for the various combinations of the above To add a message to the list of messages that can use the format enter the details of the message and click add icon To delete a message from the list select the message and click delete icon Note For all the five combinations you can use the wildcard ALL indicating that the format is applicable for records in that category For example if you indicate ALL in the branch field for the message
148. gh which a message is transmitted before it would be generated Media of transmission of a message is changed if there is a failure of the medium at the recipient s end Note The selected media through which a message is transmitted should be available to the re cipient Change Branch Click if you need to send an outgoing message from another branch Select the branch to which the message needs to be moved from the adjoining option list You change the branch of a message for the following reasons e If there is a failure of a medium at the bank s or the counterparty s end e If the branch is located closer to the location of the customer s address ee ORACLE View Click if you need to view the contents of a generated outgoing message Viewing multiple messages is not supported Authorize Click to authorize if you are provided authorization rights for an operation at the Messaging Branch Preferences level Messages should be authorized before sending them HandOff Click if you need to hand off a generated message to MCS to save the date in an ASCII format Details Click if you need to view the details of a generated outgoing message Viewing details of multiple messages is not supported On line Auth Click to authorize online if you are provided online authorization rights for an operation at the Messaging Branch Preferences level Messages should be authorized before sending them Copy Click if you need
149. ghts for editing can edit an incoming message 10 10 ORACLE 10 3 The screen is as shown below Edit Message Reference No Current Version Sender Previous Version SWIFT Message Type New Message Old Message 1010 1010 E Fields Tag Field Name Field V Fields Tag Field Value Om it w la m Message Trailer Old Message Trailer Remarks Remarks Reject Reason Reject Reason Repair Reason 1010 m Status Message Status LatestVersion Number Repair Parameters o Remove Trailer Mod Number De Oo Reject Save If editing is possible for the user the message is displayed and is available for amendment The list of fields which can be modified are maintained through back end database tables appropriately during implementation of Oracle FLEXCUBE Most typically fields like amount currency would be maintained as non modifiable whereas fields such as value date could be maintained as modifiable Based on the maintenance in these tables the appropriate fields are enabled for amendment On saving the amendment of the message a new version is created and must be authorized The screen shown above displays two versions of an incoming message If the verifier needs to reject the change for any reason the same can be mentioned in the Reject Reason field Note In the case of incoming messages with a PDE trailer the PDE Flag check box in the In coming Message Browser screen will be
150. greement for Incoming MT101 e Ifthe Cut off time for Incoming MT101 for the receiver has not passed e Check for the Transaction currency amp Transaction amount limit e Check for the debit authority of the Instructing party in case the instructing party is different than the ordering customer oat ORACLE 4 1 4 2 4 Maintaining Media Types Introduction Advices and messages are generated at the specified events in the lifecycle of contracts involving the front end modules of Oracle FLEXCUBE In the Media Maintenance screen you should maintain the different media through which these advices and messages would be generated from and to your bank At your bank you can only receive or route messages through a media that you have maintained in this screen These specifications can be made only at the main branch and will be applicable to all the branches of your bank The Messaging System MS Module supports various types of media Besides standard media modes like Mail Telex and SWIFT you can also maintain other media like CHIPS Email or any other country or customer specific media Maintaining Message Media Details You can invoke the Message Media Maintenance screen by typing MSDMEDIA in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button If you are maintaining details of a new media type select New from the Actions Menu or click
151. hrough the Advice Format Maintenance screen If you leave this field blank the default format specified for a message type in the Advice format screen will be used However if you want to personalize a message to make it specific to a customer you can indicate the code of the format that should be used for the advice customer combination For example you have maintained a standard format for the account statements that are sent from your bank in the Advice Format Maintenance screen oS ORACLE 6 2 1 6 2 2 However for Mr Andrew Scott a non resident customer you want to personalize the account statement rather than send him the standard one defined in the advice format screen To make this possible you can indicate the code of a format that you defined specific to Mr Scott Whenever an account statement is sent to Mr Scott from your bank it will be in the format that you have defined in this screen Please note that the special format should first be defined in the advice format screen before it can be associated with Mr Scott s address Primary Address When defining addresses for a message type you have to identify an address as the primary address This option will be available only if the message type is FX_CONFIRMN If you maintain multiple FX Confirmation Message types for the SWIFT Media for a customer across different locations the T Copy will be generated only for the address that is marked
152. if the SWIFT server is on UNIX check this option Subsequently in this screen you should specify the default In and Out Directories for the SWIFT message hand off files To continue with your normal banking operations you can connect to another node and indicate the directory on that node from which Oracle FLEXCUBE should read from and write into SWIFT Server on UNIX If the SWIFT server at your bank is on UNIX you should indicate it in this screen Subsequently you should specify the default In and Out Directories for the SWIFT message hand off files Specifying the UNIX In Directory You can specify the full path of the directory on the SWIFT server where you would like to store incoming SWIFT message files Oracle FLEXCUBE will pickup and process all incoming SWIFT message files from this directory Specifying the UNIX Out Directory In this screen you can also specify the directory on the SWIFT server where you would like to store outgoing SWIFT message hand off files Specifying File Prefix For the MCS you are maintaining you should identify outgoing message files generated in the media with unique prefixes Oracle FLEXCUBE will automatically prefix outgoing message hand off files for the MCS with the prefix that you specify Saving Details you have Maintained After you have made the mandatory entries save the record An MCS record that you have created should be authorized by a user bearing a different Login ID b
153. igger Block aa Field Name Format eat 15G New Sequence Empty field M 22J Type of Trigger Alc M 37U Trigger Level 12d M 37P Lower Trigger Level 12d O 32Q Currency Pair 3 a 3 a M Optional Sequence H Non Deliverable Option Block Fo Field Name Format e 15H New Sequence Empty field M 14S Settlement Rate Source 3 a2 n M 32E Settlement Currency 3la M Optional Sequence Additional Information es Field Name Format mieten 151 New Sequence Empty field M 29A Contact Information 4 35x O 24D Dealing Method Alc 35x O 88a Broker Identification AorD O 71F Broker s Commission 3 a15d O 21G Broker s Reference 16x O 72 Sender to Receiver Information 6 35x O Optional Sequence J Additional Amounts a Field Name Format a 15J New Sequence Empty field M 18A Number of Repetitions 5n M 30F Payment Date 8 n M 32H Currency Payment Amount N 3 a15d M 53a Delivery Agent A D or J O 13 24 ORACLE 86a Intermediary 2 A D or J 56a Intermediary A D or J 57a Receiving Agent A D or J 13 4 4 MT 320 Fixed Loan Deposit Confirmation 13 4 4 1 This message is exchanged to confirm a fixed term loan deposit contract in order to confirm notify the details of e anew contract between the parties e an amendment to a previously agreed contract e the cancellation of a confirmation e arolled o
154. in through the MCS connected to the node in which the database of your branch is installed You 10 1 ORACLE can invoke the Incoming Message Browser screen by typing MSSINBRW in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button incoming Message Browser Summary S Search Advanced Search 9 Reset 4 Clear All Case Sensitive Branch Reference No Media Testword Status Process Status Records per page 45 10f1 Branch Document Number Reference No Sender m Document Number SWIFT Message Type Sender Authorized Suppress Message SWIFT Message Type Address 1 Addr View Change Branch TW Auth Link Contract Edit Force Print Change Address Move To Queue Details 10 2 3 Features on Incoming Message Browser From the Incoming Message Browser you can upload incoming messages from the incoming directory on the node check Testwords for Telex messages authorize the Testword check for messages link an incoming message to a contract route the incoming messages to appropriate queues You can query for the records based on any or all of the following Branch Document Number Reference No Sender Media Swift Message Type Testword Auth Status Status Suppress Message Process Status 10 2 ORACLE The following details of an incoming message will be displayed e Branch e Document N
155. ins RETURW and outgoing pay ment reference number contains eg 7495 RETURN 012COPB112730 001 thenit is a Reject of Outgo ing Payment oth erwise itis a Incoming Pay ment and prod uct can be resolved based on the network and Transfer type as Bank RTGS Outgoing Reject of Incoming Payment Bank R42 This message and transaction will be generated when authorizer rejects the incom ing payment of bank RTGS Incoming Incoming Payment Bank R44 Credit Notifica tion Refer the Debit Credit Notification section for detail of this message RTGS Incoming Outgoing Payment Bank R43 Debit Notification Refer the Debit Credit Notification section for detail of this message ORACLE 10 RTGS Incoming Workflow R09 This is a return message for our outgoing pay ment received from the RBI This is only the Ack NAck mes sage for outgo ing payments If it is Ack message then system will update message status as Fully Completed PD If it is NAck mes sage then system will reverse the corresponding outgoing pay ment contract and the message status will be updated as Pro cess Reversed PR 11 RTGS Incoming Workflow R90 This is a return message for our outgoing pay ment received from the PI Par ticipant Inter face This is only the Ack NAck message f
156. ion media combination that you indicate if it has already been maintained in the system Node You can indicate the node from where this Free Format Message has to be generated Name In the case of a walk in customer enter the name of the customer to whom the message is to be addressed If the recipient of the message is a customer of your bank the customer s name will be automatically displayed when you indicate the customer s CIF number in the Customer field Address If the recipient of the message is a customer of your bank the customer s address will be automatically displayed based on the Customer Media Location combination that you have specified You will be required to enter the address in the case of a Walk in customer The format of the address depends on the media through which the Free Format Message is transmitted If the address is for the media type Mail you can enter the customer s address in the four rows under this field Each line that you enter can contain a maximum of 35 characters If the media of transmission is Telex the address should be expressed numerically If you are defining a SWIFT address the address should be of eight or eleven alphanumeric characters Contract Reference You can indicate the code assigned to the customer who is the recipient of the message This is the code that you assigned to the customer in the Customer Information File CIF This option list displays all the cont
157. ion to Place of Delivery 44C Latest Date of Shipment 6 n O 44D Shipment Period 6 65x O 13 106 ORACLE 45A Description of Goods and or Services 100 65x O 46A Documents Required 100 65x O 47A Additional Conditions 100 65x O 71B Charges 6 35x O 48 Period for Presentation 4 35x O 49 Confirmation Instructions T X M 53a Reimbursing Bank AorD O 78 Instructions to the Paying Accepting Nego 12 65x O tiating Bank 57a Advise Through Bank A B or O D 72 Sender to Receiver Information 6 35x O 13 8 2 MT 701 Issue of a Documentary Credit This message is sent by the issuing bank to the advising bank It is used to indicate the terms and conditions of a documentary credit which has been originated by the Sender issuing bank This message is sent in addition to an MT 700 Issue of a Documentary Credit when the information in the documentary credit exceeds the maximum input message length of the MT 700 Maximum Length 10000 13 8 2 1 Format Specifications reld Field Name Format Mandatory Tag Optional 27 Sequence of Total 1 n 1 n M 20 Documentary Credit Number 16x M 45B Description of Goods and or Services 100 65 O x 46B Documents Required 100 65 O x 47B Additional Conditions 100 65 O x 13 8 3 MT 705 Pre Advice of a Documentary Credit This message is sent by the issuing bank to the advising bank It is
158. ion toolbar The Message Media Control Maintenance screen is displayed without any details If you are calling an MCS record that has already been defined double click a record of your choice from the summary screen In the Summary screen all the media control system records that you have entered will be displayed in a tabular form gt ORACLE 5 3 The screen is as shown below Message Media Control Maintenance E New amp Enter Query Node Media Control System Media Status Active Delivery Type Folder Queue In Directory Out Directory File Prefix Unix In Directory _ Unix Swift Server Unix Out Directory In Queue Out Queue Microsoft Message Queue WebSphere Messaging Queue Fields Input By Authorized By Modification Date Time Date Time Number E Authorized E Open Features on MCS Detailed Screen You can capture the following details on this screen Delivery Type You can specify the delivery type here Oracle FLEXCUBE gives you two options viz Folder and Queue Depending on the selection you make you must specify the details in the corresponding fields as follows e Folder If you choose Folder as the delivery type you must specify the In Directory and the Out Directory Further after selecting Folder if you check the option Unix Swift Server for a UNIX SWIFT server then you must specify the Unix In Dir
159. ith their custodian This message is used to instruct a receipt of financial instruments against payment It may also be used to request a cancellation or pre advise an instruction 1385 ORACLE Maximum Length 10000 Se ORACLE 13 6 4 1 Format Specifications Mandatory Sequence A General Information i aged Field Description Format eee 16R Start of Block GENL M 20C Reference Sender s Message Refer Alc M ence 16x 23G Function of the Message Alc 4 c M 98a Date Time Preparation Date Time A C or E Optional Repetitive Subsequence A1 Field Field Name Field Description Format Mandatory Tag Optional 16R Start of Block LINK M 20C Reference see qualifier description 4 c 16x M 36B Quantity of Finan Quantity of Financial 4 c 4 c O cial Instrument Instrument to be Paired 15d off 16S End of Block LINK M 16S End of Block GENL M Mandatory Sequence B Trade Details Fietd Field Name Field Description Format Mandatory Tag Optional 16R Start of Block TRADDET M 94B Place Place of Trade Alc 8c 4 c O 30x 98a Date Time see qualifier description A B C or E 90a Deal Deal Price AorB 99A Number Number of Days Accrued 4 c N 3 n Count 35B Identification of the Finan ISIN1 e12 c M cial Instrument 70E Narrative see qualifier description 4 c 10 35x 16S End of Block TRADDET
160. itution which has been authorized by the account owner to receive it It is used to transmit detailed information about all entries booked to the account Maximum Length 2000 13 127 ORACLE 13 9 4 1 Format Specifications Field Field Name Format Mandatory Tag Optional 20 Transaction Reference Num 16x ber 21 Related Reference 16x 25 Account Identification 35x 28C Statement Number Sequence 5n 5n Number 60a Opening Balance ForM 61 Statement Line 6 n 4 n 2a 1 a 15d 1 a3 c16x 16x 34x 86 Information to Account Owner 6 65x 62a Closing Balance Booked F or M Funds 64 Closing Available Balance 1 a6 n3 a15d Available Funds 65 Forward Available Balance 1 a6 n3 a15d 86 Information to Account Owner 6 65x 13 9 5 MT 950 Statement Message This message type is sent by an account servicing institution to an account owner It is used to transmit detailed information about all entries whether or not caused by a SWIFT message booked to the account Maximum Length 2000 13 128 ORACLE 13 9 5 1 Format Specifications Field Field Name Format mahdatory Tag Optional 20 Transaction Reference 16x M Number 25 Account Identification 35x M 28C Statement Number 5n 5n M Sequence Number 60a Opening Balance F or M 61 Statement Line 6 n 4 n 2a 1 a 15d1 a3 c16x 16x 34x 62a Closing Balance Booked F or M M
161. k LINK M 20C Reference see qualifier description 4 c 16x M 36B Quantity of Finan Quantity of Financial 4 c 4 c O cial Instrument Instrument to be Paired 15d off 16S End of Block LINK 16S End of Block GENL 1382 ORACLE Mandatory Sequence B Trade Details ried Field Name Field Description Format Mandatory Tag Optional 16R Start of Block TRADDET M 94B Place Place of Trade 4 c 8c 4 c O 30x 98a Date Time see qualifier description A B C or E M 90a Deal Deal Price AorB 99A Number Number of Days Accrued Alc N 3 n Count 35B Identification of the Finan ISIN1 e12 c M cial Instrument 70E Narrative see qualifier description 4 c 10 35x 16S End of Block TRADDET Mandatory Repetitive Sequence C Financial Instrument Account Rigid Field Name Field Description Format Mandatory Tag Optional 16R Start of Block FIAC M 36B Quantity of Finan Quantity of Financial 4 c 4 c M cial Instrument Instrument to be settled 15d 95a Party Account Owner PorR 97a Account see qualifier description A or B 16S End of Block FIAC Optional Sequence D Two Leg Transaction Details Field Field ae Mandatory Tag Name Field Description Format Optional 16R Start of Block REPO M 98a Date Time see qualifier descrip A B or C O tion 22F Indicator see qualifier descrip 4 c 8c 4 c O tion 20C Ref
162. l in the branch field for the message type payment message it would mean that the address is applicable whenever a payment message is generated from any of the branches of your bank Message Type A message type is always associated with a module You should indicate the messages to be sent to the address you have defined for the customer by picking up the message types for the respective module Note You can use the wildcard All indicating that all messages for the customer should be sent to the address being defined For example Ms Keturah Smith has five accounts with Kuber s bank Three of the accounts were opened at Kuber s bank London and two at Kuber s bank Surrey Ms Smith had requested that an account statement be sent to her every month by mail with the following instructions e the account statements for the accounts at London should be sent by mail to her residential address at London and e the statements for the accounts at Surrey should be sent to her office address In this screen you should indicate e Module Message Type Accounting AC Account Statement e Branch London e Module All e Copies 1 You should also maintain a new customer address record for Ms Smith s office address and a unique location for that address Under that maintenance a similar record to the one indicated above Module AC Message Type Account Statement needs to be saved for
163. le media select the codes that identify the media and click delete icon Note The compatible media that you indicate for a media type should have already been main tained as a media type Setting the Priority While maintaining media types you can set the usage priority for each media type that you maintain Consequently when dispatching messages to customers the media type used for sending the message will be the one that is higher on the priority rating For instance let us assume that the following are the types of media that you bank uses to send advices to customers e SWIFT Ta ORACLE e Mail e Telex e Fax You have assigned the following priority to each of these media types Media Media Type Priority SWIFT 2 Mail 1 Telex 4 Fax 3 When dispatching messages to customers the system will by default select the media type in the ascending order of the priority that you have specified Note The rating that you specify can be anything between 1 and 99 A rating of one would indi cate that the usage of the particular media type is highest on the priority list whereas a rating of 99 indicates that the usage or the particular media type is of lowest priority Saving the Record After you have made mandatory entries save the record A media maintenance record that you have created should be authorized by a user bearing a different Login ID before the End of Day proce
164. lements Interest i ORACLE 2 1 2 2 2 Messaging System An Overview Introduction The Messaging module of Oracle FLEXCUBE is designed to handle your outgoing and incoming messages The module supports various types of media Besides standard media modes like Mail Telex and SWIFT you can also use other media types supported by the Media Control System MCS installed at the node at which the database of your branch is installed Oracle FLEXCUBE gives native support for media like Mail Telex and SWIFT using EMS as the MCS While defining a product you can indicate the messages that should be generated for the events that take place during the lifecycle of contracts involving the product When the events for which a message should be generated occur the message will be automatically generated and sent to the concerned party The message will be transmitted to the customer s address through the media that you have specified and in the format and language that you maintain for the customer message combination While entering the details of a contract you can choose to generate or suppress the message You also have the option to prioritize the urgency with which a SWIFT message should be generated Features Provided for Processing Outgoing Messag es In the case of outgoing messages the module provides for the generation of messages using formats that you can define By maintaining message formats you can ensure co
165. level to generated messages and advices Viewing Previous Addresses You can view the customer s previous addresses and changes made to the address using the View screen You can also determine the number of changes made to the address till date who made the changes when was the change made and whether the change has been B lag ORACLE authorized or not To invoke this screen click Change Log button within the Customer Address Maintenance screen Records 10f1 Authorization Status Unauthorized Modification Number Modification Status First Authorization Status 1 N A lt Maker ID DOCUMEN2 Maker Date S 2012 11 07 1 Remarks First Checker Remarks Checker Remarks Maker Remarks Maker Override Remarks Warnings 10f1 CO Warning Code Warning Description Fields 10f1 O Field Name Old Value New Value To view the changes made on a particular date double click the View Changes button corresponding to the desired date under Maker Date Stamp A detailed screen appears containing changes made on the given date Viewing Customer Address You can view the address details maintained in the Customer Address Maintenance screen using the Customer Address Summary screen You can invoke this screen by typing 6 13 ORACLE MSSCUSAD in the field at the top right corner of the Application tool
166. licable Rules 30x M 31D Date and Place of Expiry 6 n29x O 58a Negotiating Bank AorD O 59 Beneficiary 34x O 4 35x 32B Credit Amount 3 a15d M 39A Percentage Credit Amount Tolerance 2n 2n O 39B Maximum Credit Amount 13x O 39C Additional Amounts Covered 4 35x O 41a Available With By AorD M 42C Drafts at 3 35x O 42a Drawee AorD O 42M Mixed Payment Details 4 35x O 42P Deferred Payment Details 4 35x O T1A Reimbursing Bank s Charges 3la O 71B Other Charges 6 35x O 72 Sender to Receiver Information 6 35x O 13 8 11 MT 742 Reimbursement Claim This message is sent by the paying negotiating bank to the bank authorized to reimburse the Sender for its payments negotiations Itis used to claim reimbursement of payment s or negotiation s under a documentary credit as relevant to the reimbursing bank Maximum Length 2000 13 118 ORACLE 13 8 11 1 Format Specifications Field Field Name Format Mandatory Tag Optional 20 Claiming Bank s Reference 16x M 21 Documentary Credit Number 16x M 31C Date of Issue 6 n O 52a Issuing Bank Aor D M 32B Principal Amount Claimed 3 a15d M 33B Additional Amount Claimed as 3 a15d O Allowed for in Excess of Principal Amount 71B Charges 6 35x 34a Total Amount Claimed AorB 57a Account With Bank A B or O D 58a Beneficiary Bank Aor D 72 Sender to Receiver Information 6 35x 13 8 12 MT 747 Amendment to an Authorization to
167. ly 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 Corporation and i
168. mber e Sender e Swift Message Type e Process Status e Auth Status e User Reference e Reference Number 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 Branch e Document Number e Sender e Swift Message Type e Branch Date e Maker ID e Maker Date e Repair Reason 10 12 ORACLE 10 4 e Running Number e Process Status e Auth Status e Checker DT Stamp e Checker ID e Message Reference e Receiver e User Reference e Mod Number e reference Number A back ground job running on this browser updates the outgoing browser with the ACK NAK and the delivery status of the message The sender MUR from SWIFT is used to match the corresponding outgoing browser record Maintaining MT Task Details Using the STP Message Maintenance Details screen you can maintain the basis for creation of MT tasks for SWIFT message You can invoke this screen by typing MSDSTPSC in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button sip Message Maintenance Details E New amp Enter Query Branch Details Branch Code Branch Name SWIFT Message Details 1 Of 1 SWIFT Message Type Direct STP ErrorFlag STPHoldFlag Unauthorized Effective Date Task Type Maker
169. mination of an existing transaction between the parties confirm the details of the recouponing of an existing transaction correct a previously sent termination recouponing Cancel a previously sent termination recouponing Maximum Length 10000 13 67 ORACLE 13 4 13 1 Format Specifications Mandatory Sequence A General Information i Field Name Format a 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22B Type of Event Alc M 22C Common Reference 4la2 c4 n4 a2 M c 23A Identification of the Swap 10a 5a M 21N Contract Number Party A 16x M 21B Contract Number Party B 16x O 30T Termination Recouponing Trade 8 n M Date 30Q Termination Recouponing Effective 8 n M Date 30P Original Termination Date 8 n 30V Original Effective Date 8 n 32B Party B Current Currency Notional 3 a15d Amount 33B Party A Current Currency Notional 3 a15d M Amount 82a Party A AorD M 87a Party B AorD M 83a Fund or Beneficiary Customer A D or J O 22D Accrual of Interest Specification Alc O 32G Party B New Currency Notional 3 a15d O Amount 33E Party A New Currency Notional 3 a15d O Amount 37N Details of Interest Rate 6 35x 29A Contact Information 4 35x 13 68 ORACLE 72 Sender to Receiver Information 6 35x
170. mission Archival period e The text for duplication check e The Hold Mail text to be displayed e The Swift Key arrangement values e Whether Authorization is required for the actions like Cancel Hold Change Node Test Word etc on a Generated Message Message Notification Process The Electronic Messaging Process is for both incoming and outgoing messages in Oracle FLEXCUBE In Incoming EMS Process a job is scheduled to poll the incoming folder on timely basis Once a message is received in the folder the job picks the message and sends it to an internal JMS queue An MDB listening on the queue reads the message and identifies the media and processes the message In Outgoing EMS Process a job is scheduled to poll the outgoing messages that are generated but not handed off Each messages polled is sent to an internal JMS queue An MDB acting upon the internal JMS queue picks the message from queue and sends the message to appropriate destination Folder or e mail or JMS queue ee ORACLE 2 6 1 Outgoing EMS Process The Outgoing EMS Process is in two layers The EMS process as part of jobs in FCJ scheduler polls the outgoing message table of FLEXCUBE for generated and un send messages The job then sends minimal data about the message to be handed off to an internal JMS queue The EMS process as part of an MDB that listens on internal JMS queue builds final message and sends to their intended destinations The EM
171. n which a message is to be sent is displayed You have the option to change the priority To change the priority specified for a message click the button marked Change Priority Thereafter select an option from the option list that is available for this field SWIFT Message Type Indicate the SWIFT message type in which the free format message should expressed For the following message types in BC module you need to indicate the SWIFT message type as MT999 a ORACLE DISCREPANCY_REQ ACCEPT_REFUSAL DISCREPANCY_AUT Note NEFT and RTGS message types will be factory shipped which are available as Swift mes sage type These messages will be available only for PC module Following are the NEFT and RTGS message types generated Message Type Description HEFT ERIC ge tyP p Message Type CUST_PYMT_RIND RTGS Customer Payment Request R41 BANK_PYMT_RIND RTGS Interbank Payment Request R42 DR_NOTIFICATION RTGS debit notification R43 CR_NOTIFICATION RTGS credit notification R44 STLMNT_NFTN_RBI RTGS sender settlement notification R09 STLMNT_NFTN_PI RTGS PI Response R90 CUST_PYMT_NIND NEFT Incoming Payment Message N02 RETURN_TRN_RBI NEFT Message for transmitting return N03 transaction details DR_MSGS_NIND Outward Debit Messages from NEFT NOG Branches RETURN_TRN_NBR Return Transaction from NEFT N07 N Branches REJECT_TRN_NIND NEFT Transmission of Rejected Trans
172. ncrease or decrease in the balance of the account in an already agreed contract e achange in the interest rate e achange in the period of notice e the closing of a contract i e final redemption of the loan deposit balance to zero and all interest paid This message is sent by or on behalf of the institution or corporate party A and party B who have agreed to a call notice loan deposit contract Maximum Length 10000 13 4 5 1 Format Specifications Mandatory Sequence A General Information i Field Name Format Boa 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22B Type of Event Alc M 22C Common Reference Ala2 c4 n4 a2 M c 21N Contract Number Party A 16x O 82a Party A A D or J M 87a Party B A D or J M 83a Fund or Instructing Party A D or J O 77D Terms and Conditions 6 35x O 13 29 ORACLE Mandatory Sequence B Transaction Details ia Field Name Format Be on 15B New Sequence Empty field M 17R Party A s Role 1la M 30T Trade Date 8 n M 30V Value Date 8 n M 38A Period of Notice 3n M 32B Currency and Balance 3 la15d O 32H Principal Amount to be Settled N 3 a15d O 30X Interest Due Date 8 n O 34E Currency and Interest Amount N 3 a15d O 37G Interest Rate N 12d M 14D Day Count Fraction 7X M 30F Last Day of the Next Int
173. nder s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22C Common Reference 4 a2 c4 n4 a2 c M 17T Block Trade Indicator 1la O 17U Split Settlement Indicator ila O 82a Party A A D or J M 87a Party B A D or J M 83a Fund or Beneficiary Cus A D or J O tomer 77D Terms and Conditions 6 35x O Mandatory Sequence B Transaction Details a Field Name Format Seni 15B New Sequence Empty field M 30T Trade Date 8 n M 30V Value Date 8 n M 36 Exchange Rate 12d M Mandatory Subsequence B1 Amount Bought a Field Name Format eet 32B Currency Amount 3 a15d M 53a Delivery Agent A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 13 15 ORACLE Mandatory Subsequence B2 Amount Sold Toi Field Name Format ae 33B Currency Amount 3 a15d M 53a Delivery Agent A D or J O 56a Intermediary A D or J O 57a Receiving Agent A D or J M 58a Beneficiary Institution A D or J O Optional Sequence C Optional General Information S Field Name Format Sd 15C New Sequence Empty field M 29A Contact Information 4 35x O 24D Dealing Method Alc 35x O 84a Dealing Branch Party A A B D or O J 85a Dealing Branch Party B A B D or O J 88a Broker Identification A D or J O 71F Broker s Commission 3 a15d O 26H Counterparty s Reference 16x O 21G Broker s Reference 16x O 72 Send
174. new icon on the toolbar The Message Media Maintenance screen is displayed without any details If you are calling a Message Media Maintenance record that has already been defined double click a record from the summary screen In the Summary screen all the media maintenance records that you have entered will be displayed in a tabular form 4 ORACLE 4 3 The screen is as shown below Message Media Maintenance Etnew E3 Enter Query Media Code F Media Number Description Message Suffix Message Terminator Number of Characters Media Priority Test Word Required Stop Processing Padding Required Compatible Media a HEE __ Compatible Media a 4 b Fields Input By Authorized By Modification Date Time Date Time Number Wi Authorized Open In this screen you can maintain the following e The media types that can be used to transmit messages from and to your bank and e The compatible media for the media type you are maintaining Features of the Media Maintenance screen For each media type that you maintain you should indicate the following parameters Indicating a Code to Identify a Media Type In Oracle FLEXCUBE each media type that you maintain is identified with a fifteen character code called Media Code You can follow your own convention for devising this code A Media Type could be SWIFT Mail Telex etc The code that you assign a media typ
175. ng inefficiencies from their operations SWIFT is solely a carrier of messages It does not hold funds nor does it manage accounts on behalf of customers nor does it store financial information on an on going basis As a data carrier SWIFT transports messages between two financial institutions This activity involves the secure exchange of proprietary data while ensuring its confidentiality and integrity There are four key areas that SWIFT services fall under within the financial marketplace They are Securities Treasury and Derivatives Trade Services and Payments amp Cash Management SWIFT messages consist of five blocks of data including three headers message content and a trailer They are identified in a consistent manner They all start with the literal MT which denotes Message Type This is followed by a 3 digit number that denotes the message type category and group The following are the categories of a message Category Description Category 1 Customer Payments and Cheques Category 2 Financial Institution Transfers Category 3 Treasury Markets Foreign Exchange Money Markets and Deriv atives Category 4 Collections and Cash Letters Category 5 Securities Markets Category 6 Treasury Markets Metals Category 7 Documentary Credits and Guarantees Category 8 Travellers Cheques Category 9 Cash Management and Customer Status Category n Common Group Messages
176. ng transaction between the parties e confirm the details of the recouponing of an existing transaction e correct a previously sent termination recouponing e cancela previously sent termination recouponing Maximum Length 10000 1904 ORACLE 13 4 12 1 Format Specifications Mandatory Sequence A General Information a Field Name Format Se 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22B Type of Event Alc M 22C Common Reference Ala2 c4 n4 a2 M c 23A Identification of the Swap 10a 5a M 21N Contract Number Party A 16x M 21B Contract Number Party B 16x O 30T Termination Recouponing 8 n M Trade Date 30Q Termination Recouponing 8 n M Effective Date 30P Original Termination Date 8 n M 30V Original Effective Date 8 n M 32B Current Currency Notional 3 a15d M Amount 82a Party A Aor D M 87a Party B Aor D M 83a Fund or Beneficiary Customer A D or J O 22D Accrual of Interest Specifica Alc O tion 32G New Currency Notional 3 a15d O Amount 37N Details of Interest Rate 6 35x O 29A Contact Information 4 35x O 72 Sender to Receiver Informa 6 35x O tion 13 65 ORACLE Optional Sequence B Fixed Interest Payable by Party B Piald Field Name Format Mandatory Tag Optional 15B New Sequence Empty M field 37U Current Fixed Rate
177. nsistency across the branches of your bank The module provides a host of features to enter or authorize testwords and to interface with media control systems to actually generate the message Several customer addresses for a given media With Oracle FLEXCUBE s multi branch set up the customers of your bank can operate their accounts from several locations Based on the convenience of your customers you can send messages to locations of their choice Oracle FLEXCUBE provides for the setting up of several addresses for a given customer media combination In addition you can also associate a language with an address All messages sent to the address will be expressed in the language that you indicate Free format messages In the course of your daily banking operations you may want to generate messages that are not automatically generated by the system or you may have to communicate a message that is very specific to a customer In Oracle FLEXCUBE you can personalize a message by defining a free format message and linking it to a customer address combination Whenever the message is to be generated it will bear the personalized format that you have defined MCS maintenance The messages that are sent from and delivered to your bank are transmitted and received from sources that are external to Oracle FLEXCUBE In Oracle FLEXCUBE these external sources are called Media Control Systems MCS a ORACLE 2 3 2 4 2 5 2
178. nt 1 a O 34x 35x 56a Intermediary Aor D 57a Account With Institution A B or D 72 Sender to Receiver Information 6 35x 13 3 2 MT 202 General Financial Institution Transfer Requests the movement of funds between financial institutions Maximum Length 2000 13 9 ORACLE 13 3 2 1 Format Specifications 13 3 3 a Field Name Format Sa 20 Transaction Reference Number 16x M 21 Related Reference 16x M 13C Time Indicator 8c O 4 n1 s4 n 32A Value Date Currency Code Amount 6 n3 a15d M 52a Ordering Institution AorD O 53a Sender s Correspondent A BorD O 54a Receiver s Correspondent A BorD O 56a Intermediary Aor D O 57a Account With Institution A BorD O 58a Beneficiary Institution AorD M 72 Sender to Receiver Information 6 35x O Note TSU Trade Services Utility transaction is supported for field 72 in this particular mes sage MT 203 Multiple General Financial Institution Transfer This multiple message is sent by or on behalf of the ordering institution directly or through correspondent s to the financial institution s of several beneficiary institution s The message contains several transactions It is used to order the movement of funds to each beneficiary institution This message may also contain order s for the movement of the Sender s own funds in favour of itself This is the case when the Receiver services multiple ac
179. nt 3 a15d O 34N Interest Amount N 6 n3 a15d O 37a Interest Rate A B C D E or F O 72 Sender to Receiver Informa 6 35x O tion 13 102 ORACLE Mandatory Sequence C Principal Payment Sum of Interest Due a Field Name Format Ooni 32A Total Principal Amount Repaid Prepaid 6 n3 a15d M 32N Principal Amount Due to Receiver N 6 n3 a15d O 33N Gross Interest Amount Due to Receiver N 6 n3 a15d O 34N Net Interest Amount Due to Receiver N 6 n3 a15d O 34a Total Amount Transferred PorR O 57a Account With Institution A B orD O 71C Details of Adjustments 6 35x O 72 Sender to Receiver Information 6 35x O 13 7 5 MT 649 General Syndicated Facility Message This message type may be sent by any financial institution involved in a facility to another financial institution in the facility It is used for any communications related to syndicated facilities for which specific message types have not been defined This message type may be used throughout the life of the facility Maximum Length 2000 os ORACLE 13 7 5 1 Format Specifications fey Field Name Format Mandatory Tag Optional 20 Transaction Reference Num 16x M ber 21 Related Reference 16x O 27 Sequence of Total 1 n 1 n O 29A From 4 35x O 29B To the Attention of 4 35x O 88D Borrower s 1 a M 34x 4 35x 32a Facility Amount AorB 79 Narrative 35 50x
180. nt AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD M 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M Optional Sequence K Exchanges of Principal Payable by Party A i Field Name Format utara 15K New Sequence Empty M field 18A Number of Repetitions 5n M 22X Type of Exchange Alc M 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD M 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M 13 58 ORACLE Optional Sequence L Additional Amounts Payable by Party B a Field Name Format oea 15L New Sequence Empty M field 18A Number of Repetitions 5n M 22E Type of Payment Alc M 30F Payment Date 8 n M 32M Currency Payment Amount 3 a15d M 14A Business Day Convention 9a M 18A Number of Repetitions 5n M 22B Financial Centre Alc M 53a Delivery Agent AorD O 56a Intermediary AorD O 86a Second Intermediary AorD O 57a Receiving Agent AorD O Optional Sequence M Additional Amounts Payable by Party A a Field Name Format utara 15M New Sequence Empty M field 18A Number of Repetitions 5n M 22E Type of Payment Alc M 30F Payment Date 8 n M
181. nt by an account servicing institution to an account owner It is used to notify the account owner of an entry which has been credited to its account The entry will be further confirmed by statement iep ORACLE 13 9 2 1 13 9 3 13 9 3 1 13 9 4 Maximum Length 2000 Format Specifications a Field Name Format eran 20 Transaction Reference Number 16x M 21 Related Reference 16x M 25 Account Identification 35x M 32A Value Date Currency Code Amount 6 n3 a15 M d 50a Ordering Customer A F orK O 52a Ordering Institution AorD O 56a Intermediary AorD O 72 Sender to Receiver Information 6 35x O MT 920 Request Message An account owner or a party acting on the account owner s behalf to one of the account owner s account servicing institutions sends this message It is used to request the account servicing institution to transmit one or more reports for example a statement containing the requested information for the account s identified in the message Maximum Length 2000 Format Specifications i Field Name Format pcan 20 Transaction Reference Number 16x M 12 Message Requested 3 n M 25 Account Identification 35x M 34F Floor Limit Indicator 3la 1aJi5 O d MT 940 Customer Statement Message This message type is sent by an account servicing institution reporting institution to a financial institution concentrating inst
182. nt for the branch is Generate FFT then the message MT999 would be generated instead of original SWIFT message Generation of MT999 Message header is changed from the original header to MT999 That portion of the message after tag 21 will be prefixed with tag 79 followed by the original SWIFT message The message will be populated with the same contents as the original SWIFT message with the respective SWIFT tags The system will generate MT999 even if the SWIFT Key Arrangement does not exist with the receiver MT999 will be generated for the following SWIFT messages MT750 Advice of Discrepancy MT734 Advice of Refusal MT752 Authorization to pay accept or Negotiate Saving the record After you have made the mandatory entries save the record This record should be authorized before the End of Day process EOD is run ORACLE Click Exit or Cancel button to return to the Application Browser 3 4 Determining Message Queues For a combination of the following you can specify the branch queue to which the message is to be routed Media represents the delivery media Typically your entry would be SWIFT BIC Code represents the receiver s BIC for which a message is to be routed to a specific queue in a particular branch You can choose to specify the wildcard ALL entry in this field Message Type indicates the message type for which routing procedure is required You can ch
183. nts were opened at Kuber s bank London and two at Kuber s bank Surrey Ms Smith had requested that an account statement be sent to her every month by mail with the following instructions e the account statements for the accounts at London should be sent by mail to her residential address at London e the statements for the accounts at Surrey should be sent to her office address In this screen you should indicate e Module Message Type Accounting AC Account Statement e Module All e Copies 1 You should also maintain a new customer address record for Ms Smith s Surrey address and a unique location for that address Copies You can indicate the number of copies of the message that should be sent to this location each time it is generated The number you specify here will be the default number of copies of the message that will be generated each time a message is sent to this location through the media you have specified If you indicate that more than one copy should be sent to a location the first message will be the original and the others will be marked as copy Note For payment messages Oracle FLEXCUBE will default one indicating that only one pay ment message will be generated You will not have an option to change it Format You can specify the format in which a message should be sent to a customer s address To recall you have defined the default format for a message type in t
184. o compare and identify whether a message is a PDE or not This data is factory shipped Sao ORACLE 3 7 1 3 7 1 1 Customer Transfer MT103 ao Option Tag Description 50 A K F Ordering Customer 32 A Interbank Settlement Amount 32 A Currency 32 A Value Date 57 A B C D Account With Institution 59 A or No let Ultimate Beneficiary ter Bank Transfer MT202 ea D Field Position 32 A Interbank Settlement Amount 32 A Currency 32 A Value Date 58 AorD Beneficiary Institution Note You can also choose not to use any of the above tags for comparison Along with the above fields the Sender and Receiver BIC are also used for procedural validation Processing PDE Messages The system detects the messages Incoming Outgoing as PDE messages by performing the validations discussed in the above section The Incoming and Outgoing PDE messages are processed by the system in the following manner Incoming PDE Messages In the case of incoming messages EMS picks up the incoming messages and inserts it into a data store If the incoming message has a PDE trailer message contains the text PDE then the system will mark the process status as Stopped due to PDE After due validations you can release the message from the incoming PDE message queue Once these messages are accepted it will continue to get uploaded as a normal message If the PDE trailer is NOT pr
185. o which the message should be sent and click OK to save Note Change of address can be done only before a message is generated eS ORACLE Print Spool Click if you need to print an outgoing message When you click Print option will be provided to select spool or print on line Messages that are transmitted through mail and those cancelled should be printed You can also choose to print the details of messages transmitted through other media types The system provides an option to spool the advices in PDF format When you click the Print Spool button you can view the selected advice in PDF file You can also view the SWIFT tag description Undo Click if you need to reverse the last action you performed on an outgoing message at Outgoing Messages Browser level Change Priority Click if you need to change the priority for sending a payment message which is yet to be generated Note In the Background Oracle FLEXCUBE generates messages on the priority basis Resend Click if you need to regenerate and resend a message which was generated and sent Release Click if you need to release a message which is on hold Reinstate Click if you need to reinstate cancelled outgoing messages TW Auth Click if you are provided rights to authorize testword entered for a Telex message While authorizing you have to reenter the testword Change Media Click if you need to change the media throu
186. oining list displays a list of message types maintained in the system Choose the appropriate one Description The system displays the message description Tag Description Tag Name The system displays the tag name Description The system displays the description Tag Option Lines The system displays the number of lines required for the tag 3 9 ORACLE 3 5 2 Sequence The system displays the tag sequence number Repeatable Indicates whether the tag is repeatable or not All Options Indicates all options Sequence Name Specify the sequence number Note Swift message tag descriptions are factory shipped However it can also be maintained using this screen Viewing SWIFT Message Tags You can view the SWIFT messages and tag descriptions using the Message Preview Browser screen You can invoke this screen by typing MSDMSPRvV in the field at the top right corner of the Application tool bar and click the adjoining arrow button Message Preview amp enter Query Module Contract Reference 1 Of 1 F Document Number Message Type Receiver Name Media SWIFTMessageType Message Status i You can search for the messages based on the following parameters Module Specify the module The adjoining list displays a list of module names maintained in the system Choose the appropriate one This is applicable only for the following modules e LC
187. on 90a Price see qualifier descrip A or B O tion 36B Quantity of see qualifier descrip 4 c 4 c 15d O Financial Instru tion ment 35B Identification of the ISIN1 e12 c O Financial Instrument 4 35x 70E Narrative Financial Instrument 41c 10 35x O Attribute Narrative 16S End of Block FIA M 13 79 ORACLE End of Subsequence B2 Financial Instrument Attributes ra Field Name Field Description Format paras 13B Number Identifica Certificate Number Alc 8c O tion 30x 70E Narrative see qualifier descrip 4 c O tion 10 35x 16S End of Block CONFDET M Optional Sequence C Settlement Details Sai Final Field Description Format Sa 16R Start of Block SETDET M 22F Indicator see qualifier descrip Alc 8c M tion Alc 11A Currency see qualifier descrip Alc 3 la O tion Optional Repetitive Subsequence C1 Settlement Parties Tof tas Field Description Format Seer 16R Start of Block SETPRTY M 95a Party see qualifier descrip C P Q R orS M tion 97a Account Safekeeping Account AorB O 98a Date Time Processing Date Time AorC O 20C Reference Processing Reference 4 c 16x O 70a Narrative see qualifier descrip CorD O tion 16S End of Block SETPRTY M Optional Repetitive Subsequence C2 Cash Parties Zai Tad Field Description Format ei 16R Start of Block CSHPRTY M 95a Party i qualifier descrip P Q R
188. onal 71F Broker s Commission 3 a15d M 37L Tax Rate on Broker s Commission 12d O 33E Reporting Currency and Tax Amount 3 a15d O on Broker s Commission 13 4 9 MT 360 Single Currency Interest Rate Derivative Confirmation This message is exchanged by or on behalf of the institutions or corporates party A and party B which have agreed to a single currency interest rate swap a cap a collar or a floor The 1382 ORACLE confirmed transaction is covered by a BBAIRS British Bankers Association Interest Rate Swap ISDA International Swaps and Derivatives Association Deutscher Rahmenvertrag f r Finanztermingeschafte or AFB Association Fran aise de Banques Master Agreement The message also covers deals which are not part of an ISDA AFB Deutscher Rahmenvertrag f r Finanztermingeschafte or BBAIRS Master In this case party A and party B must have another bilateral agreement in place This message may also be sent by a money broker to the two parties party A and party B for which the broker arranged the deal If there are two money brokers involved in arranging a deal between party A and party B this message is also exchanged between these money brokers The MT 360 may be used to e confirm the details of a new transaction between the parties e correct a previously sent confirmation e cancel a previously sent confirmation Maximum Length 10000 1940 ORACLE 13 4 9 1 Format Specifications M
189. onfirmations cccccceeseeeeenneees 13 17 13 4 3 MT 306 Foreign Currency Option Confirmation cccccccceeseeeeeeenneees 13 18 13 4 4 MT 320 Fixed Loan Deposit Confirmation ccccccccseeseteeteeeeetetettees 13 25 13 4 5 MT 330 Call Notice Loan Deposit Confirmation 2 sscscceeeeeeeeeeettees 13 29 13 4 6 MT 340 Forward Rate Agreement Confirmation cccccecseeeneeees 13 32 13 4 7 MT 341 Forward Rate Agreement Settlement Confirmation 00 13 35 13 4 8 MT 350 Advice of Loan Deposit Interest Payment c ccc 13 37 13 4 9 MT 360 Single Currency Interest Rate Derivative Confirmation 13 39 13 4 10 MT 361 Cross Currency Interest Rate Swap Confirmation 00 13 49 13 4 11 MT 362 Interest Rate Reset Advice of Payment ccccceeseeeeenteees 13 60 13 4 12 MT 364 Single Currency Interest Rate Derivative Termination Recouponing Con firmation 13 63 13 4 13 MT 365 Cross Currency Interest Rate Swap Termination Recouponing Confirma tion 13 67 13 5 Collections and Cash Letters ec cccececeeeeeeeeeeeeeeeeeeeeeeeeeseeeaeeeeseeeaaeeeseeeneeeees 13 71 13 5 1 MT 400 Advice Of Payment 0 ccecccceeteee cette eee eeentieeeeteenaeeeteeensaeeeeeeeaaes 13 71 13 5 2 MT 410 Acknowledgement uu eecee eee ceentte eee eeeeneeeetesenaeeeeeeeneeteeeeeaees 13 71 13 5 3 MT 412 Advice of ACCEDtannCe 2 ccccceecsecseceeeeeeeeeeeetetsenteieaneeseeeneess 13 72 13 5 4 MT 416 Advice of Non Paym
190. oose to specify the wildcard ALL option as well Currency indicates the currency of the incoming message For example in an MT103 it would be from tag 32A This is an additional parameter to determine the booking branch and queue You can also choose to maintain the wildcard ALL entry Booking Branch indicates the branch in which incoming messages are routed A set of all the branches having the same SWIFT BIC as that mentioned in the BIC code field is displayed in the option list This maintenance can be performed through the Message Queue Mapping Maintenance screen To invoke this screen type MSDINRUT in the field at the top right corner of the Application tool bar and click the adjoining arrow button amp Message Queue Mapping Maintenance E new E Enter query Media Message Type BIC Code Queue Currency Booking Branch Branch Name Input By Authorized By Modification Date Time Date Time Number Wi Authorized Wi Open While processing MT700 and MT701 messages the System ensures the following MT700 and MT701 are routed to the branch using the Incoming Routing specifications maintained in this screen For MT700 in case the branch of the corresponding MT701 is different from that of the MT700 it is re aligned to the branch of the MT700 MT701 messages are processed only after the receipt of MT 700 ORACLE 3 4 1 Note You can maintain the same BIC for the main branch as well as
191. or out going payments If it is Ack mes sage then system will update mes sage status as Partially Com pleted HD If it is NAck message then system will reverse the corre sponding outgo ing payment contract and the message status will be updated as Process Reversed PR RTGS Debit and Credit Notifications Debit Notifications are incoming messages from RBI generated to indicate that a debit has been applied to a participants settlement account by the transaction initiated by RBI The ORACLE 3 6 message format is R43 This notification will consist of debits in the settlement account initiated by RBI only Credit Notifications are incoming messages from RBI generated to indicate that a credit has been applied to a participants settlement account by the transaction initiated by RBI The message format is R44 This notification will consist of credits in the settlement account initiated by RBI only Maintaining NEFT Messages The system will support the following NEFT payment messages N o Sr Networ k from Produc t Message Type Outgoing Incoming Product Type from Product Category Transfer Type from Product Category Mes sag e Nam e Message Description NEFT Outgoing Outgoing Payment Customer NO6 This message will be generated for outgo ing payment contract to customer using NEFT product NEFT Outgoing Reject of Incoming Paym
192. ount 3 a15d M 33B Additional Amount 3 a15d O 71B Charges to be Deducted 6 35x O 73 Charges to be Added 6 35x O 34B Total Amount to be Paid 3 a15d O 57a Account With Bank A B or O D 72 Sender to Receiver Informa 6 35x O tion 77J Discrepancies 70 50x M 13 8 14 MT 752 Authorization to Pay Accept or Negotiate This message is sent by the issuing bank or the nominated bank if so authorized by the issuing bank to a paying accepting negotiating bank in response to a request for authorization to pay accept negotiate incur a deferred payment undertaking previously requested via an MT 750 Advice of Discrepancy or otherwise It is used to advise the Receiver that documents may be taken up notwithstanding the discrepancies provided they are otherwise in order Maximum Length 2000 13 121 ORACLE 13 8 14 1 Format Specifications it Field Name Format aea 20 Documentary Credit Number 16x M 21 Presenting Bank s Reference 16x M 23 Further Identification 16x M 30 Date of Advice of Discrepancy or 6 n M Mailing 32B Total Amount Advised 3 a15d O 71B Charges Deducted 6 35x O 33a Net Amount AorB O 53a Sender s Correspondent A B orD O 54a Receiver s Correspondent A B orD O 72 Sender to Receiver Information 6 35x O 13 8 15 MT 754 Advice of Payment Acceptance Negotiation This message is sent by the paying accepting or negotiating bank or the bank incurring a deferred paymen
193. ouse bank REMIT_BANK Remitting Bank COL_BANK Collecting Bank DISC_BANK Discounting Bank NEGO_BANK Negotiating Bank TRF_BANK Transferee Bank BILL_AMT Bill Amount BILL_CCY Bill Currency OS_AMOUNT Bill Outstanding amount VALUE_DATE Bill Value date TRANSACTION_DATE Bill transactions date TRANSIT_DAYS Transit days BILL_TENOR Bill Tenor BILL_MATURITY Bill Maturity date 11 13 ORACLE Message Substitution Variables Description LIQUIDATION_DATE Bill Liquidation date INCO_TERM Inco Term OUR_LC_REF Our LC Ref No THEIR_LC_REF Their LC Ref No BC_CONTRACT_REF BC Contract Reference Number BC_USER_REF BC User Reference Number BROK_DETAILS Broker Brokerage and Brokerage Cur rency SHIPMENT_FROM Shipment From SHIPMENT_TO Shipment To 1414 ORACLE Message Substitution Variables Description MT999 LC_CCY LC Currency LC_LIABILITY LC Outstanding Amount ISSUE DATE LC Issue Date LC_TENOR LC Tenor EXPIRY_DATE LC Expiry Date EXPIRY_PLACE LC Expiry Place CLOSURE_DATE LC Closure Date LC_CONTRACT_REF LC Contract Reference Number LC_USER_REF LC User Reference Number SHIPMENT_FROM Shipment From SHIPMENT_TO Shipment To PORT_LOADING Port of Loading PORT_DISCHARGE Port of Discharge CREDIT_AVL_WITH Credit Available with INCO_TERM
194. outgoing message Authorizing Supervisor can view details and then release the messages or change their status to Carry Forward which in turn can be released on further authorization Note Messages with Hold status must either be carried forward or released before you execute the EOD processes at the branch else the system displays an error message However if the message is cancelled then the system will not display error message though the status is Hold Cancel Click if you need to cancel an outgoing message You can cancel messages with Un generated and Hold status TW Input Click if you need to input testword for Telex messages which were moved to Repair status Change Node Click if you need to change the node from which an outgoing message is generated In a distributed environment the database of one or more branches of your bank will be located at a node or a server Hence a Media Control System will be installed and defined specifying the node at which it is installed When you click Node the system displays the details of the individual message providing an option to change the Node Select the node you need to change from the adjoining option list Note MCS status at the node in which the database of your bank is installed should be passive Change Address Click if you need to change the address to which an outgoing message has to be sent Enter the new address t
195. port for all the branches or a single branch alone You can indicate the branch for which the report is being generated using the following options e All If you choose this the system will generate the report for all the branches e Single If you choose this you need to specify the branch code for which the report should be generated The option list displays all valid branch codes maintained in the system Choose the appropriate one Date Specify the date from the adjoining calendar list Contents of the Report The parameters specified while generating the report are printed at the beginning of the report The contents of Counterparty Confirmation Pending report have been discussed under the following heads Header The Header carries the title of the report branch code branch date user ID module from which the report has been generated date and time at which the report has been generated and the page number of the report Body of the Report You can find the following details in the body of the report Branch Indicates the branch code Branch Date Indicates the branch date Status Indicates the status Module Indicates the module code Document Reference Indicates the document reference number Reference Number Indicates the reference number as ORACLE Message Type Indicates the type of message Swift Message Type Indicates the swift message type Addr
196. ract reference number for those branches for which you have access right External Reference Number The system displays external reference number on save Form If the message to be sent is in the form of a template you can choose the template from the option list 112 ORACLE 11 3 1 Hold Messages that are put on hold are temporarily stopped from being generated If you have indicated that messages should be generated in the background the Free Format Message that you have defined will be immediately sent when you save the record If for some reason you do not want to immediately send the message you can place it on hold In this case the message will appear in the Outgoing Message Browser but will be in the hold status You will have to release the message before you generate it from the Outgoing Browser Copies Enter the number of copies of the Free Format Message that should be sent to the customer at the time it is generated If you indicate that more than one copy should be sent to a location the first message will be the original and the others will be marked as copy Testword Required Indicate whether a test word needs to be inserted the telex message manually before it is generated from your branch The following details are displayed on the screen e Reference Number e Date e Tags Entering Details of a Free Format Message You can enter the details of a Free Format Message either by e Using
197. rative see qualifier descrip E DorC O tion 20C Reference Reference 4c 16x 16S End of Block OTHRPRTY MT 592 Request for Cancellation This message type is sent by a financial institution to request a second financial institution to consider cancellation of the SWIFT message identified in the request If the Receiver of the request for cancellation has already acted on the message for which cancellation is requested the MT n92 asks for a retransfer ie reversal with the beneficiary s consent Maximum Length 2000 Format Specifications Field Field Name Format Mandatory Tag Optional 20 Transaction Reference Number 16x M 21 Related Reference 16x M 11S MT and Date of the Original Message 3 n M 6 n 4 n6 n 79 Narrative Description of the Original 35 50x O Message Copy of at least the Mandatory Fields of Copy of O the Original Message fields MT 598 Proprietary Message This message type is used by financial institutions with their own offices and or with other financial institutions with which they have established bilateral agreements It is used as an envelope for a specified message included in it 1996 ORACLE 13 6 8 1 13 7 13 7 1 It allows for the definition of a unique format for which another message type is not available or applicable It also allows financial institutions to use message types which are awaiting live implementation
198. receipt of any documentary credit message When applicable it may also explicitly indicate that the message has been forwarded according to instructions This message type may also be used to account for bank charges Maximum Length 2000 13 115 to advise of acceptance or rejection of an amendment of a credit ORACLE 13 8 7 1 Format Specifications S Field Name Ti a 20 Sender s Reference 16x M 21 Receiver s Reference 16x M 25 Account Identification 35x O 30 Date of Message Being Acknowledged 6 n M 32a Amount of Charges BorD O 57a Account With Bank AorD O 71B Charges 6 35x O 72 Sender to Receiver Information 6 35x O 13 8 8 MT 732 Advice of Discharge 13 8 8 1 13 8 9 This message is typically sent by the issuing bank to the paying negotiating or accepting bank It may also be sent by the paying accepting negotiating bank to the bank from which it has received documents It is used to advise the Receiver that the documents received with discrepancies have been taken up Maximum Length 2000 Format Specifications Field Forma Mandatory Tag PIEI Namig t Optional 20 Sender s TRN 16x M 21 Presenting Bank s Reference 16x M 30 Date of Advice of Payment Accept 6 n M ance Negotiation 32B Amount of Utilization 3 a15d 72 Sender to Receiver Information 6 35x MT 734 Advice of Refusal Advises the refusal of documents
199. reen ceceeeceeeeeeeeeeeeeeneeeeees 9 1 Processing Incoming Messages sseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeenenenees 10 1 1024 Mroductioinss nanena a T eee ee eae 10 1 10 2 Viewing Incoming Messages ssssssssisscessiriserennesisinnaestinnnnsenenasstninnnaatannanntannnna 10 1 10 2 1 Background Processing of INCOMING MessageSs sseeeeiinseeeeennneeee 10 1 10 2 2 Manual Processing of INCOMING Messages ssseeseisnseerennneeererneeeen 10 1 10 2 3 Features on Incoming Message BrOWS6f u cccssseeeeeeesteeeeeeeenteeteeeeeaees 10 2 10 2 4 Linking Guarantee Issuance Contract to an Incoming Message 10 5 10 2 5 Operations that you can perform on an Incoming Message 10 6 10 2 6 Viewing Details of INCOMING Message ssseesiinsesrinnnneernnnneeerenneeena 10 9 10 2 7 Editing INCOMING Message s sesneerrrnnneeerrnnnnrirernrrrrnnnerrnnnnreennnnnnnana 10 10 10 3 Viewing SWIFT Notification Messages eeeesssseerseeeerirssrrrrrsssrrrrsssrrrrrsssreens 10 11 10 4 Maintaining MT Task Details 2 0 0 0 ceceeeeeeeeeeeeee eee eeeeeeeeeeeeeeaeeeeseeeaaeeeeeeenaeeees 10 13 Defining Free Format Messages sseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeenenees 11 1 Thi Introduction vacinh Ga nehen adie E E AAI AA he aa 11 1 11 2 Invoking Free Format Message Maintenance Screen 11 1 11 3 Features of Free Format Message Screen cecccsceeeeseceeee
200. ress in the four rows under this field Each line that you enter can contain a maximum of 35 characters If the media of transmission is Telex the address should be expressed numerically If you are defining a SWIFT address the address should be of eight or eleven characters alphanumeric Default Address If you check against this option the address specified against the chosen Location and Media combination becomes the default or the primary address of the customer Messages and advices generated against the selected customer account are always sent to the primary or the default address of the corresponding customer You can maintain multiple addresses at a customer account level through this screen Module A message type is always associated with a module In some cases a message may be associated with more than one module An example could be a payment message that is Ga ORACLE generated by the trade treasury and remittances departments of the bank Once you select the module the Message Type gets defaulted alongside Note You can use the wildcard All indicating that all messages for the customer belonging to any module should be sent to the address being defined In order to generate MT292 on reversal of a contract you need to maintain the module as IS and the message type as REVSWIFT For example Ms Keturah Smith has five accounts with Kuber s bank Three of the accou
201. reto It is used to acknowledge receipt of any message relating to a guarantee and where applicable to indicate that action has been taken according to the instructions This message may also be used for Standby Letters of Credit The Sender s charges may also be accounted for in this message Maximum Length 2000 ieee ORACLE 13 8 19 1 Format Specifications it Field Name Format masini 20 Transaction Reference Number 16x M 21 Related Reference 16x M 25 Account Identification 35x O 30 Date of Message Being Acknowledged 6 n M 32a Amount of Charges B or D O 57a Account With Bank A B or O D 71B Details of Charges 6 35x O 72 Sender to Receiver Information 6 35x 13 9 Cash Management and Customer Status 13 9 1 MT 900 Confirmation of Debit This message type is sent by an account servicing institution to an account owner It is used to notify the account owner of an entry which has been debited to its account The entry will be further confirmed by statement Maximum Length 2000 13 9 1 1 Format Specifications e Field Name Format AO 20 Transaction Reference Number 16x M 21 Related Reference 16x M 25 Account Identification 35x M 32A Value Date Currency Code Amount 6 n3 a15 M d 52a Ordering Institution AorD O 72 Sender to Receiver Information 6 35x 13 9 2 MT 910 Confirmation of Credit This message is se
202. s Documentary Credit This message is sent by an advising bank which has received a documentary credit from the issuing bank or the non bank issuer to the bank advising the beneficiary or another advising bank It is used to advise the Receiver about the terms and conditions of a documentary credit Maximum Length 10000 ae ORACLE 13 8 5 1 Format Specifications Si Field Name Format lesen 27 Sequence of Total 1 n 1 n M 40B Form of Documentary Credit 24x M 24x 20 Sender s Reference 16x M 21 Documentary Credit Number 16x M 23 Reference to Pre Advice 16x O 31C Date of Issue 6 n M 40E Applicable Rules 30x 35x M 31D Date and Place of Expiry 6 n29x M 52a Issuing Bank AorD O 50B Non Bank Issuer 4 35x O 51a Applicant Bank AorD O 50 Applicant 4 35x M 59 Beneficiary 34x M 4 35x 32B Currency Code Amount 3 a15d M 39A Percentage Credit Amount Tolerance 2n 2n O 39B Maximum Credit Amount 13x O 39C Additional Amounts Covered 4 35x O 41a Available With By AorD M 42C Drafts at 3 35x O 42a Drawee AorD O 42M Mixed Payment Details 4 35x O 42P Deferred Payment Details 4 35x O 43P Partial Shipments 1 35x O 43T Transshipment 1 35x O 44A Place of Taking in Charge Dispatch from 1 65x O Place of Receipt 44E Port of Loading Airport of Departure 1 65x O 44F Port of Discharge Airport of Destination 1 65x O 13 112 ORA
203. s also Hash value based validation shall be done irrespective of this option being checked Indicating the activities that require authorization You can perform several activities on a message that is to be generated from your branch and on those that have come in for your branch For example from the outgoing or incoming browser you can change the address to which a message should be sent In the branch preferences screen you can indicate the activities which when performed on an incoming or outgoing message would require subsequent manual authorization for the message Several activities have been listed in this screen A message on which an activity which has been selected in this screen is performed would require subsequent manual authorization for the activity to take effect A message on which an activity not selected in this screen is performed would be automatically authorized with the activity taking effect The activities that you can choose from are e Cancel e Hold e Change Node e Testword e Auth Repair Incoming e Carry Forward e Change Media e Regenerate e Regenerate e Change Address e Reinstate e Release a ORACLE Carried Forward Branch Move Change Media Change Priority Testword Check Auth Repair Incoming A message on which you perform an activity that requires authorization will be available for further processing only after it is authorized SK Arrangement You can choose the action to
204. s will be directed to it If for instance an MCS located at the node in which your branch operates malfunctions you can indicate that the MCS is passive In this case Oracle FLEXCUBE will not write into or read from the directories on the node No message will be routed through a passive MCS In Directory and Out Directory If the Delivery Type is Folder and the SWIFT server is a Windows server then apart from indicating the node on which an MCS is located you should specify the full path of the directories from which Oracle FLEXCUBE should read and write incoming and outgoing messages respectively File Prefix For the MCS you are maintaining you should identify the outgoing message files generated in a different media with unique prefixes Enter the unique identifier in this field In Queue If the Delivery type is Queue then you should enter the full path of the queue in the node or server into which the MCS should store the incoming message hand off file Oracle FLEXCUBE by default will pickup and read all incoming messages transmitted through the specified media from this queue a ORACLE 5 3 1 5 3 2 5 3 3 Out Queue Enter the full path of the queue in the node or server into which the message hand off file from Oracle FLEXCUBE for the specified media should be stored The MCS which is also located on the same node will by default store the outgoing messages in this queue Unix Swift Server At your bank
205. sage advice e Receiver sender of the message e Type of the message e Type of the SWIFT message e Complete text of the message advice e Remarks if any e Reject reason if any e Message trailer 3 5 2 2 Printing Message Advices 3 5 3 From the Message Preview screen you can print a message advice using the Print button Select the message advice and click Print button to print the message Maintaining Message Type for Account Opening You can maintain a specific message type to be associated with account opening event class ou ORACLE The Events Class Maintenance screen is as shown below Events Class Maintenance E New amp Enter Query Class Code Class Description Module Module Description Event Class _ Event Code Event Description Accounting Entries Advice Fields Modification Number Wi Authorized Open Input By Date Time Authorized By Date Time Specify the following details Module Specify the module as DE Message Type Specify as ACC_OPADV For further details refer the section Maintaining Message Types in this User Manual You can specify a format for this message using the Advice Format Maintenance screen Then you can associate this message to the event class maintained for account opening Refer the chapter Maintaining Advice Formats in this User Manual for details about format maintenance
206. ss message to processed folder Check for Media Others Select destination for message If Destination queue If Destination FTP or Folder FTP or Copy Message to processed folder Send Message to destination queue If any exception Update Message Status as handed off Rollback transaction Commit Transaction 2 6 2 Incoming EMS Process The Incoming EMS Process is in two layers The EMS process as part of jobs in FCJ scheduler polls the pre configured folder for messages and sends the messages read to EMS internal queue The EMS process as part of an MDB listening on internal JMS queue identifies the message from queue and calls the incoming messages service package to process the message The EMS in job is available as factory shipped zo ORACLE The Incoming EMS Process as part of jobs scheduler is as follows e Once the job is triggered it polls for messages in a folder Configured for incoming messages e Each message is then sent to an internal JMS queue e The job is then rescheduled to fire next time The Incoming EMS Process in MDB is as follows e An MDB that listens on the internal EMS incoming queue receives the message e The media details are identified and incoming message processing package is called to process the message e Incase of any exception while processing message is sent to a deferred queue e Incase of messages
207. ssage is sent MT 204 through the RTGS Network COVER_RTGS Used when a cover payment is sent MT 202 through the RTGS Network Note If none of the criteria is selected then the system displays all the messages in the outgoing browser Funding Status will be updated during the processing of incoming MT102 and MT 109 8 2 1 Performing Operations on an Outgoing Message The operations that you can perform on an outgoing message are determined by the rights that you are assigned with at Security Management System SMS level If a function in the Outgoing Browser is disabled then the function is not allowed for the record Check the box against the message s for which you need to perform an operation and then click the corresponding operation The action performed will require authorization if maintained at the Messaging Branch Preferences level 54 ORACLE The following operations can be performed on the outgoing messages Generate Click to generate an outgoing message You can generate un generated and repaired messages When you click Generate the system checks the contract status for which the message is generated and will not generate a message in the following condition e Ifthe contract is reversed e If the message is on hold e If the message maintenance is not authorized and the message is moved to repair queue Hold Click if you need to temporarily stop generating an
208. ssages If the background message process is not running all the messages that are triggered for generation will be displayed in the Outgoing Message Browser from where you can generate the message You can generate messages from the Outgoing Browser at any time in the day You can invoke the Outgoing Message Browser Summary screen by typing MSSOUTBR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Outgoing Message Browser Summary I Search Advanced Search 9 Reset D Clear All Case Sensitive Branch as Document Number Gal Reference Number P Module Message Type ae Receiver FE Media i ial SWIFT Message Type ee oe Message Status X Hold Release Status v Acknowledgement Status X Authorization Status Delivered Status Records per page 15 v 10f1 is Branch Document Number Reference Number Module Message Type Receiver Currency Amount Media SWIFT Message Type Node m lt Mm Generate Hold Cancel TWinput Change Node Change Address Print Undo Change Priority Resend Release Reinstate TW Auth Change Media Change Branch View Authorize Handoff Details On Line Auth Copy CarryForward BIP Advice File Format Spool Viewing Outgoing Messages You can view features of the outgoing messages based on any of the following criteria e Branch e Document Number e Reference Number e Module e Message Type e Receiver iia ORACLE Media
209. sses are triggered Click Exit or Cancel button to return to the application 44 ORACLE 5 1 5 2 5 Maintaining Media Control Systems Introduction The messages that are sent from and delivered to your bank are transmitted and received over sources that are external to Oracle FLEXCUBE We shall call these external sources Media Control Systems MCS In a distributed environment the database of a branch is located in a node or server The MCS of the messages are also installed in a node Thus while defining an MCS you also need to indicate the node in which it is installed An MCS can handle only one media hence you need to set up several media control systems for the various media types maintained for your bank Apart from indicating the media type for an MCS you can indicate separate directories from which Oracle FLEXCUBE should read and write incoming and outgoing messages for a given media You can maintain MCS details in the Message Media Control Maintenance screen The details that you specify in this screen control the medium of delivery and reception of messages Maintaining Message Media Control You can invoke Message Media Control Maintenance screen by typing MSDMCS in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button If you are maintaining details of a new media control system click the New button on the Applicat
210. ssttntnssttnnnssatennnnstennae 14 2 14 3 1 Contents of Report 2 ccccccccccecceceeeeeeenncanenaeeeeeeeeeeesesseeeaaeaeeeesteseetersseens 14 3 14 4 Successful Messages Report sssssssseiisseeerrstttrrrssttrrnssttrtnntsttntunsttnnnstatennnnneen nnt 14 3 14 4 1 Contents or Rep OE a ei aaa ee 14 3 14 5 Daily Swift Message Status Report ce eeeccceeeeeeeneeeeeeeeneeeeeeeeeeeeeeeeetaeeeeeseeaaes 14 4 14 5 1 Contents of the Report 2 ccccccccceeeeeeenneaeceeeeseeeeteeteceaaeaeeeseeeeeeneettnen 14 5 14 6 Statement Message Status Report eeeeeee teeters ee ecieeeeeeeieeeeeeeaeeeerenea 14 5 14 6 1 Contents of the Report 0 ccccccccccceeeenesneaeeeeeececeesesteceaaeaeceseeeseesenseeens 14 6 15 Function ID Glossary s3 coset cee cece cee Oe ee ee ee 15 1 1 1 1 2 1 3 1 4 1 Preface Introduction This manual is designed to help acquaint you with the Messaging System module of Oracle FLEXCUBE The module supports various types of media Besides standard media modes like Mail Telex and SWIFT you can also use other media types supported by the Media Control System MCS installed at the node at which the database of your branch is installed Oracle FLEXCUBE gives native support for media like Mail Telex and SWIFT using EMS as the MCS In addition to this User Manual you can find answers to specific features and procedures in the Online Help It can be invoked by choosing Help Contents from the H
211. t are scheduled to be generated during End of Day operations e Assoon as the message is generated system will check whether the advice was scheduled to get generated during EOD If so the advice will be sent for spooling and printing If the advice is not scheduled to be generated during EOD system will move on to generate the next advice without printing the advice 16 ORACLE 8 1 8 Processing Outgoing Messages Introduction Here the procedure involved in generating an outgoing message is explained To recall you have already maintained e The type of messages that can be generated at your bank e Formats for the various messages e The media through which messages should be transmitted e A media control system to receive and transmit messages for a given media e The addresses for a customer for a given media In each module of Oracle FLEXCUBE you can define products While defining products you also indicate the messages that should be associated with an event in the life cycle of a contract involving the product A contract goes through several events during it s life cycle A message for an event is triggered for generation when the event is authorized For example you have defined a product to cater to short term loans You have indicated that the following messages should be generated when events take place Event Message INITIATION Initiation Advice LIQUIDATION Liquidation Advice
212. t undertaking to the issuing bank It may also be sent by the bank to which documents have been presented to a bank that has been nominated to pay accept It is used to advise the Receiver that documents were presented in accordance with the credit terms and are being forwarded as instructed The MT 754 may also be used e forthe settlement of the payment negotiation e as a pre notification of a reimbursement claim from the claiming bank to the issuing bank e asa pre debit notification from the claiming bank to the issuing bank Note Where a pre debit notification from the reimbursing bank to the issuing bank is required banks should use the MT 799 Free Format message specifying the future date of debit Maximum Length 2000 ize ORACLE 13 8 15 1 Format Specifications i Field Name Format Aed 20 Sender s Reference 16x M 21 Related Reference 16x M 32a Principal Amount Paid Accepted AorB M Negotiated 33B Additional Amounts 3la15d O 71B Charges Deducted 6 35x O 73 Charges Added 6 35x O 34a Total Amount Claimed AorB O 53a Reimbursing Bank A B or O D 57a Account With Bank A B or O D 58a Beneficiary Bank Aor D 72 Sender to Receiver Information 6 35x TTA Narrative 20 35x 13 8 16 MT 756 Advice of Reimbursement or Payment This message is sent by the issuing bank to the bank from which it has received documents or by the reimbursing bank
213. th appropriate rights can perform this function 10 6 ORACLE 10 2 6 Supress Suppressing the Incoming Message To suppress a message click Suppress button in the Incoming Browser and invoke the Suppress Message screen The following options are available to suppress a Payment Message e Suppress Message Generation e Suppress Full e No Suppress Specifying the Suppress Message Generation option If you select this option Oracle FLEXCUBE will stop the generation of the Payment Message However the system will post the necessary accounting entries for the messages being suppressed Indicating the Suppress Full option If you select the full suppress option for a message the system will not post the related accounting entries Advice generation will also be stopped In other words the system will not pick up the Payment Mes sage for any further processing Specifying the No Suppress option A message marked with the No Suppress option will be processed like any other normal Incoming SWIFT Payment Message Specifying the remarks for a suppressed message You can specify the reason for suppressing a Payment Message in the Remarks field Click Exit or Cancel to return to the Application Browser Viewing Details of Incoming Message You can view an incoming message in the Incoming Message Summary screen by selecting the message and clicking D
214. that are not in accordance with the terms and conditions of a documentary credit Maximum Length 10000 13 116 ORACLE 13 8 9 1 Format Specifications S Field Name Format ean eas 20 Sender s TRN 16x M 21 Presenting Bank s Reference 16x M 32A Date and Amount of Utilization 6 n3 la15 M d 73 Charges Claimed 6 35x O 33a Total Amount Claimed AorB O 57a Account With Bank A BorD O 72 Sender to Receiver Informa 6 35x O tion 77J Discrepancies 70 50x M 77B Disposal of Documents 3 35x M Note Field 77B will have the following format for line 1 3 Line 1 8c additional information Line 2 6 add l information The following codes are supported for field 77B HOLD RETURN 13 8 10 MT 740 Authorization to Reimburse This message is sent by the issuing bank to the reimbursing bank It is used to request the Receiver to honour claims for reimbursement of payment s or negotiation s under a documentary credit The MT 740 authorizes the reimbursing bank to debit the account of the Sender or one of the Sender s branches if so indicated for reimbursements effected in accordance with the instructions in the MT 740 Maximum Length 2000 Taie ORACLE 13 8 10 1 Format Specifications Field Name Format a 20 Documentary Credit Number 16x M 25 Account Identification 35x O 40F App
215. the Surrey Branch Copies You can indicate the number of copies of the message that should be sent to this location each time it is generated The number you specify here will be the default number of copies of the message that will be generated each time a message is sent to this location through the media you have specified If you indicate that more than one copy should be sent to a location the first message will be the original and the others will be marked as copy Note For payment messages Oracle FLEXCUBE will default one indicating that only one pay ment message will be generated You will not have an option to change it oN ORACLE 6 2 2 2 Format You can specify the format in which a message should be sent to a customer s address The default format for a message type needs to be defined through the Advice Format Maintenance screen You can choose to use the default format defined for the message type or you can indicate another format for the message If you leave this field blank the default format specified for a message type in the Advice Format screen will be used However if you want to personalize a message to make it specific to a customer you can indicate the code of the format that should be used for the advice customer combination For example you have maintained a standard format for the account statements that are sent from your bank in the Advice Format screen However
216. the adjoining arrow button The screen is as shown below BIP Advice File Format E New Enter Query Advice File Format Branch Code Module Advice Message Type Advice File Format PDF Maker Date Time Checker Date Time Mod No Record Status Authorization Status You can maintain the following parameters here Branch Code Specify branch code for which you need to maintain BIP advice file format from the adjoining option list Module Specify branch code for which you need to maintain BIP advice file format from the adjoining option list Advice Message Type Specify advice message type of the BIP advice file format from the adjoining option list Advice File Format Select a valid file format in which you would prefer to generate the BIP message from the adjoining drop down list This list displays the following e PDF e Excel e HTML e RTF ORACLE 8 2 3 Processing Outgoing Messages with PDE Trailer System identifies outgoing messages with a PDE Possible Duplicate Emission trailer and parks it in the PDE queue From the PDE queue you can opt to either release the message with without the PDE trailer or reject the message You can release or reject an outgoing message with a PDE Trailer using the PDE Detailed screen You can invoke the PDE Detailed screen by typing MSDETPDE in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow b
217. the location of the address The location of an address is the unique identifier between the other addresses of the customer for a given media Node Select the node at which the database of your branch is installed from the option list provided Name Specify the name of the customer to whom the message is to be addressed If the recipient of the message is a customer of your bank the customer s name will be automatically displayed when you specify the customer code Address 1 4 If the recipient of the message is a customer of your bank the address gets automatically displayed based on the Customer Media Location combination that you have specified You need to specify the address in case of a walk in customer Form Select a template from the option list if you wish to send the message in the form of a template 18 ORACLE SWIFT Message Type Specify the type of the SWIFT message to be sent to the customer from the adjoining option list Number of Copies Specify the number of copies of the message that should be sent to the customer at the time it is generated Response To Select the type of the previous SWIFT message in response to which the common group message is being sent The following options are provided in the drop down list e Incoming e Outgoing Reference Number for Query When a common group message is sent the reference number specified here will help to query and fetch the original message date and
218. tions 13 4 13 4 1 Fiag Field Name Format Mandatory Tag Optional 20 Transaction Reference Num 16x M ber 25 Account Identification 35x O 30 Value Date 6 n M 21 Related Reference 16x M 32B Currency Code Amount 3 a15d M 50a Ordering Customer No letter option O C orF 52a Ordering Institution AorD O 56a Intermediary AorD Treasury Markets Foreign Exchange Money Markets and Derivatives MT 300 Foreign Exchange Confirmation This message is exchanged by or on behalf of the institutions or corporate party A and party B which have agreed to a foreign exchange contract This message may also be sent by a money broker to the two parties party A and party B for which the broker arranged the deal This message is also used when one of the trading parties is a fund manager as the fund manager has to specify the fund for which he is dealing The MT 300 is used to e confirm the details of a new contract between the parties e confirm an exercised foreign currency option e confirm the details of an amendment to a previously sent confirmation e Cancela previously sent confirmation Maximum Length 10000 1914 ORACLE 13 4 1 1 Format Specifications Mandatory Sequence A General Information i Field Name Format Boa 15A New Sequence Empty field M 20 Se
219. to International Standby Practices additional type codes are allowed for field 40 C The URCG The guarantee is subject to the ICC Uniform Rules for Demand Guar antees type codes are disallowed for field 40 C 13 124 ORACLE 13 8 18 MT 767 Guarantee Standby Letter of Credit Amendment This message is sent by a bank which has issued a guarantee to the bank to which the guarantee was issued It may also be sent by a bank which has requested the issuance of a guarantee to the bank to which the request for a guarantee was sent It is used to amend or request the amendment of the guarantee Note This message may also be used for Standby Letters of Credit Maximum Length 10000 13 8 18 1 Format Specifications i Field Name Format eee 27 Sequence of Total 1 n 1 n M 20 Transaction Reference Number 16x M 21 Related Reference 16x M 23 Further Identification 16x M 30 Date 6 n O 26E Number of Amendment 2n O 31C Date of Issue or Request to Issue 6 n M 77C Amendment Details 150 65 M xX 72 Sender to Receiver Information 6 35x O 13 8 19 MT 768 Acknowledgement of a Guarantee Standby Message This message type is sent by a bank which has received a guarantee to the bank which issued the guarantee or an amendment thereto It may also be sent by a bank which has been requested to issue a guarantee to the bank which requested the guarantee or an amendment the
220. to send a copy of an outgoing message to another customer involved in a contract You will provide the following to options e Any Select to implement the following changes Select media from an adjoining option list Specify name of the recipient Specify the location of the recipient Specify the address of the recipient e Original Select to copy the message in the original form Carry Forward Click if you need to Carry Forward an outgoing message which is on Hold for subsequent days Note Messages which have been Carried Forward can be put back on Hold BIP Advice Click if you need to generate advice in PDF format Note Advice ACST_DETAILED as part of AC module Only ACST_DETAILED and Credit Instrument Liquidation Advices i e DD and BC as part of Branch Advice are supported in PDF format You can generate BIP advice messages for Branch advices by maintaining BRANCH_ADV_TYPE as BIP Generation of these BIP advices is similar to Host advices a ORACLE 8 2 2 Note If an advice is not generated then the system generates spools and moves it to the client work station Maintaining BIP Advice File Format You can maintain BIP advice file format using BIP Advice File Format screen You can invoke the BIP Advice File Format screen by typing MSDADFTP in the field at the top right corner of the Application tool bar and clicking on
221. to the bank from which it has received a reimbursement claim It may also be sent by the bank nominated to pay accept negotiate incur a deferred payment undertaking to the bank from which it has received documents It is used to advise the Receiver about reimbursement or payment to that bank for a drawing under a documentary credit for which no specific reimbursement instructions or payment provisions were provided The account relationship between the Sender and the Receiver is used unless otherwise expressly stated in the message Maximum Length 2000 13 123 ORACLE 13 8 16 1 Format Specifications Field Name Format aaa 20 Sender s Reference 16x M 21 Presenting Bank s Reference 16x M 32B Total Amount Claimed 3 a15d M 33A Amount Reimbursed or Paid 6 n3 a15d M 53a Sender s Correspondent A B or D O 54a Receiver s Correspondent A B or D O 72 Sender to Receiver Informa 6 35x O tion 13 8 17 MT 760 Guarantee Standby Letter Of Credit Issues or requests the issue of a guarantee or Standby LC Maximum Length 10000 13 8 17 1 Format Specifications T Field Name Format Sad 27 Sequence of Total 1n in M 20 Transaction Reference Num 16x M ber 23 Further Identification 16x M 30 Date 6 n O 40C Applicable Rules Ala 35x M 77C Details of Guarantee 150 65x M 72 Sender to Receiver Information 6 35x O Note The ISPR The guarantee is subject
222. ton Repeat step one with the criteria value as Message type select Guarantee under value clicking accept and add buttons in the sequence described for the first criterion Step 3 Click the And button Repeat step one with the criteria value as Branch select London under Value clicking accept and add buttons in the sequence described for the first criterion Step 4 The query that you have made will be displayed in the Query screen Check it for correctness and click Ok button The Outgoing Message Browser will display details of all the Guarantees generated for the LC module from your branch at London Selecting Same Criterion to Apply One or More Condi tions Now you may want to make a query to see the debit advices in the Letters of Credit module that were generated from the London branch involving three different customers Wendy Klien Silas Reed and Keturah Smith This involves specifying a customer code one by one all of which come under the same criterion module LC listed out under Fields and indicating a message type for which you want details This is where the Or button on the query screen comes into play You can choose to use the keyboard to key in the query or you can follow the following procedure to make a query Procedure Step 1 Select Module under Fields and then from the Operator drop down list choose Equal To and LC under Value Then click the Accept button 22 ORACLE
223. ts 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 Pre aG es cco aist te ates Rese cace ch oti etetu pital ecat cetacean ia beechete cet teadece 1 1 Wes AMMTOMUGHON psec les oticet tecdtveds a ahebviddat Matbdeecetgabicedts baa Miciatidadel adlanede cites 1 1 12 AUGION CO a e ATAA ANEETA CU AORA E ANE heeded dade 1 1 1 3 Documentation Accessibility ssaceessiieeeessieessnneeinnnnnesiennnnsnnnnadsinannnnenanaaasiannnnana 1 1 14 sOPGAMIZAUOM esra nt aT a Aaa e AE E EEA AARO AA RE 1 1 WD Glossary ol Icos r 5 54 sats E E E E A O 1 2 16 Rated Documents rreran a e et eg diets gh E RENO 1 2 Messaging System An Overview sssssssssssnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 2 1 21 IntroductiOm enseaninieneari iii ieee aaa eae A A O RA E a A 2 1 2 2 Features Provided for Processing Outgoing Messages eseeeeeeeeeeeesseerressree 2 1 2 3 Features Provided for Processing of Incoming Messages ccceesseeeeeeeeneees 2 2 2 4 Archival and Retrieval of Information seessseeeeeesesrrresseerrsssrtrrssstetrrssttrrsssrtnnsssnt 2 2 2 5 Set up Messaging Preferences s eessssessesrressssrrresttnrnestrnnnesstennnesinanneeetnnnaeeninnaane 2 2 2 6 Message Notification Process cessssseeesisnssesnneseriinnesiinnnneenudnasddiannnaetnananeniannanana 2 2 26T Outgoing EMS Frossen tapaea anaa EE aAA A iei ag
224. tton 6 1 ORACLE The Account Address Maintenance screen is shown below Account Address Maintenance E New i Enter Query Customer Details Branch Code Account No Location Country Answerback Media Language Test Keyword Delivery By C Send by Email Add Hold Mail Text Name Address Default Address Message Address 10f1 Module Message Type NoofCopies Format Primary Address Fields EL ig Date Time Checker Date Time Mod No Record Status Authorization Status If you are querying for a customer address record that has already been defined select the Summary option under Account Address In the View screen all the customer address records that have been maintained so far will be displayed in a tabular form Double click a record to open it If you are maintaining a new address for an account select New from the Actions Menu or click new icon on the toolbar The screen is displayed without any details If you are modifying some of the details of the existing record select the Unlock option from the Actions Menu and proceed Customer Account Number It is the relevant customer account number in the current branch against which you are maintaining an address based on a selected media and location The branch code gets defaulted alongside A single customer can have any number of accounts You can choose to link a
225. type payment message it would mean that the format is applicable when ever a payment message is generated from any of the branches of your bank Saving the record After you have made the mandatory entries save the record A user bearing a different Login ID should authorize an advice format maintenance record that you have created before the End of Day processes EOD are begun Click Exit or Cancel button to return to the Application Browser In the summary screen all the advice format records that have already been saved will be displayed in a tabular form double click a record of your choice to open it You can also invoke this screen by typing MSSADVFT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button is ORACLE 7 3 7 3 1 Automatic Printing of Advices Generated during EOD Processing In addition to generation of advices Oracle FLEXCUBE automatically prints the advices that are scheduled to be generated during End Of Day EOD processing Account Statements Loan statements are examples of advices that are scheduled to be generated during EOD processing Starting the Background Process In Oracle FLEXCUBE you need to run the background process to generate and print advices In addition to the generation of the advices system will also print the advices that are scheduled to be generated during EOD processing You can start or stop
226. ugh a correspondent s to the financial institution of the beneficiary customer It is used to convey a funds transfer instruction in which the ordering customer or the beneficiary customer or both are non financial institutions from the perspective of the Sender This message may only be used for clean payment instructions It must not be used to advise the remitting bank of a payment for a clean e g cheque collection nor to provide the cover for a transaction whose completion was advised separately e g via an MT 400 Tra ORACLE Maximum Length 10000 Format Specifications 7 Field Name Format eae 20 Sender s Reference 16x M 13C Time Indication 8c 4 n1 x4In O 23B Bank Operation Code Alc M 23E Instruction Code Alc 30x O 26T Transaction Type Code 3 c O 32A Value Date Currency Inter 6 n3 a15d M bank Settled Amount 33B Currency Instructed Amount 3 a15d O 36 Exchange Rate 12d O 50a Ordering Customer A F or K M 51A Sending Institution 1 a 34x O 4 a2 a2 c 3 c 52a Ordering Institution AorD O 53a Sender s Correspondent A B or D O 54a Receiver s Correspondent A B or D O 55a Third Reimbursement Institu A B or D O tion 56a Intermediary Institution A C orD O 57a Account With Institution A B C or D O 59a Beneficiary Customer No letter option or M A 70 Remittance Information 4 35x O 71A Details of Charges 3la M 71F Sender s Charges 3 a
227. umber DCN assigned to the incoming message the DCN is the delivery control number used to identify the message It is a 10 digit number prefixed with a letter of the English alphabet The DCN ID is made up as follows 1 2 Characters Last two digits of the current year 3 5 Characters Day of the year Julian Date 6 10 Characters Sequential number starting from 00001 each day e Reference No e Sender the name address and location of the sender of the message e Media the media through which the message was transmitted e SWIFT Message Type of the message e Customer Name the name of the sender of the message e Address 1 4 the location of the sender of the message e Location the location of the sender of the message e Testword in case of a Telex message e Entry By e Maker Date Stamp e Repair Reason e Running Number e Generated Reference e Queue in which the message is stored e Auth Status e Checker Date Stamp e Checker ID e Remarks e Status e Currency e Amount e Suppress Message e External Reference e Multi Credit Reference e RTGS Network e Process Status e Modification Number e PDE Flag e Required Execution Date You can set some of the above parameters to make a query Specify the details in the respective fields and click Search button to view the details Checking the testword for a telex message Telex messages that come into your bank need to be checked for
228. umber of days that you specified in the Messaging Branch Preferences screen You can choose to retrieve the outgoing messages that have been archived by invoking the Message History Retrieval Summary screen 9 2 Invoking Message History Retrieval Summary Screen You can invoke the Message History Retrieval Summary screen by typing MSSUNARC in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The Unarchive Outgoing message screen is displayed Message History Retrieval Summary E gt Search Advanced Search 9 Reset Case Sensitive Reference Number Media _ Ra a Date E PE ana fan ffan Module Message Type L Receiver Records per page 15 Document Number Reference Number Message Type Media View Message In the above screen you can base your queries on any or all of the following parameters and fetch records e Module e Reference Number e Message Type e Media e Receiver e Date Select any or all of the above parameters for a query and click Search button The records meeting the selected criteria are displayed a ORACLE System displays the following details pertaining to the fetched records e Module e Reference Number e Message Type e Media e Receiver e Date Click View Message to view the archived message in the standard Oracle FLEXCUBE message
229. us of original con tract will be updated as Partially Com pleted HD oe ORACLE 10 NEFT Incoming Workflow F25 This is a Negative acknowledge mes sage from SFMS If this message is received then sys tem will reverse the corresponding outgo ing payment contract and the message sta tus will be updated as Processing Reversed PR 11 NEFT Incoming Workflow F26 This is a Negative acknowledge mes sage from SFMS User If this message is received then sys tem will reverse the corresponding outgo ing payment contract and the message status will be updated as Pro cessing Reversed PR 12 NEFT Incoming Workflow F27 This is a acknowl edgement message from Bank API If this message is Negative Acknowledgement then the correspond ing contract will be reversed and the message status will be updated as Pro cessing Reversed PR If this message is Positive Acknowl edgement then the message status of original contract will be updated as Fully Completed PD 11 NEFT Outward N10 This is acknowledg Inward ment for N02 and Credit Con NO6 firmation Message at branch Performing PDE Validations on SWIFT Messages Oracle FLEXCUBE allows you to tag SWIFT messages both incoming and outgoing as duplicate if it identifies that the same message was sent received earlier Once the message a7 ORACLE is detected as a duplicate message
230. utton PDE Detailed enter Query ESN Reference Number Branch Code Document Number User Reference Status Message Remark Detail Input By Authorized By Date Time Date Time Wi Authorized The following details of the message are displayed in the above screen e Branch Code e Reference Number e ESN e DCN e Remark e Message You need to capture the following information in the above screen Status Select the status of the message from the drop down list The options available are e Release with PDE e Release without PDE e Reject S9 ORACLE In order to view the details of the record click Detail button The details of the record are displayed in the PDE Detail screen PDE Detailed E3 Enter Query ESN Branch Code User Reference Message Remark Reference Number Document Number Status Input By Authorized By Date Time Date Time WB Authorized The following details of the message are displayed e Module Id e Reference Number e User Ref No e Message 8 2 3 1 Viewing Outgoing Messages with PDE Trailer You can view all the PDE messages parked in the PDE queue using the PDE Summary screen You can invoke the PDE Summary screen by typing MSSETPDE in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button pa ORACLE The screen is as shown below PDE summary amp
231. vels e Incoming Message Level e Contract Level Resulted due to the Incoming message e Outgoing message As a result of the above contract RTGS Network The service identifier of the RTGS network will be picked up from field 113 of block 3 header of the incoming message and displayed here For TARGET 2 clearing network the service identifier specified for the network in the Clearing Networks screen will be defaulted and displayed here Status You can filter the records based on the status The drop down list displays the following statuses e Unprocessed e Processed e Repair e Suppressed e Funding Exception e Pending Cover Match e Failed Verification e Pending Authorization e Pending liquidation e Pending Auth Receipt If the Bill Liquidation is failed for the trade related MT202 message the status will be updated as L Pending liquidation You can list all the trade related MT202 which are failed during Bill Liquidation by filtering by Status as L On successful processing of Trade Related MT202 the Generated Ref No is displayed with the Bill Contract Ref No in the Incoming Message Browser screen 104 ORACLE 10 2 4 Linking Guarantee Issuance Contract to an Incoming Message You can link guarantee issuance contract to an incoming MT760 message in the Incoming Message Browser screen While linking the incoming MT760 message to a Guarantee contract the system validates
232. ver renewed contract between the parties e the maturity of a contract This message is exchanged by or on behalf of the institutions or corporate party A and party B who have agreed to a fixed term loan deposit contract A money broker may also send this message to the two parties party A and party B for which he arranged the deal Maximum Length 10000 Format Specifications Mandatory Sequence A General Information a Field Name Format a 15A New Sequence Empty field M 20 Sender s Reference 16x M 21 Related Reference 16x O 22A Type of Operation Alc M 94A Scope of Operation Alc O 22B Type of Event Alc M 22C Common Reference Ala2 c4 n4la2 M c 21N Contract Number Party A 16x O 82a Party A A D or J M 87a Party B A D or J M 83a Fund or Instructing Party A D or J O 77D Terms and Conditions 6 35x O 13 25 ORACLE Mandatory Sequence B Transaction Details ia Field Name Format ocr 15B New Sequence Empty field M 17R Party A s Role 1la M 30T Trade Date 8 n M 30V Value Date 8 n M 30P Maturity Date 8 n M 32B Currency and Principal Amount 3 a15d M 32H Amount to be Settled N 3 a15d O 30X Next Interest Due Date 8 n O 34E Currency and Interest Amount N 3 a15d M 37G Interest Rate N 12d M 14D Day Count Fraction 7X M 30F Last Day of the First Interest 8 n O Period 38J Number of Days 1 a3 n O Mandatory
233. viewer Receiver Sender Reference Number DCN SWIFT Message Type Version Number 4101 Message Remarks Reject Reason Message Trailers Click Exit or Cancel to return to the Application Browser v2 ORACLE 10 1 10 2 10 2 1 10 2 2 10 Processing Incoming Messages Introduction To recall in the MCS Maintenance screen you have indicated the Media Control Systems that are connected to the node in which the database of your branch is installed You have also specified the media that the MCS should handle Besides you have specified a hand off directory into which all incoming messages transmitted through a specific media should be stored The final destination of an incoming message is the end user queue These queues represent departments responsible for acting on the received messages Viewing Incoming Messages All incoming messages that are intended for your bank will be handled based on the MCS specifications that you have maintained for your branch You can choose to receive the incoming messages in the ASCII format from an MCS and manually direct them to the appropriate queues or indicate that the background process should automatically pickup incoming messages from an MCS and transfer them to the appropriate queues Background Processing of Incoming Messages If you indicate that incoming messages for your branch should be processed in the background mess
234. x Information no Field Name Format a 15G New Sequence Empty field M 37L Tax Rate 12d M 33B Transaction Currency and Net Inter 3 a15d M est Amount 36 Exchange Rate 12d 33E Reporting Currency and Tax Amount 3 a15d Optional Sequence H Additional Information a Field Name Format eae 15H New Sequence Empty field M 29A Contact Information 4 35x O 24D Dealing Method Alc 35x O 84a Dealing Branch Party A A B D orJ O 85a Dealing Branch Party B A B D or J O 88a Broker Identification A D or J O T1F Broker s Commission 3 a15d O 26H Counterparty s Reference 16x O 21G Broker s Reference 16x O 72 Sender to Receiver Information 6 35x O Optional Sequence I Additional Amounts e Field Name Format Sa 15l New Sequence Empty field M 18A Number of Repetitions 5n M 30F Payment Date 8 n M 32H Currency Payment Amount N 3 a15d M 53a Delivery Agent A D or J O 86a Intermediary 2 A D or J O 13 28 ORACLE 56a Intermediary A D or J 57a Receiving Agent A D or J 13 4 5 MT 330 Call Notice Loan Deposit Confirmation This message is exchanged to confirm a call notice loan deposit contract The message is used to confirm notify the details of e anew contract between the parties e an amendment to a previously agreed contract e the cancellation of a confirmation e ani
235. y of field resolvers is available in Oracle FLEXCUBE You can create template as and when required with the combination of hard coated text and the field resolvers You can define templates for Free Format Messages which contains Template id Language code and Free Format Text Only for MT499 and MT799 using the Swift FFT Template 14 10 ORACLE screen Maintenance screen You can invoke this screen by typing MSDFFTMP in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Swift FFT Template Maintenance E New E3 Enter query FFT Details Template Id Language Code Free Format Text SWIFT Message Type MT499 Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Template ID Specify the template id Language Code Specify a valid language code The adjoining option list displays all the valid language code maintained in the system You can choose the appropriate one Free Format Text Specify the Substitution Variables You can identify these variables by prefixing them with or by some other special character Swift Message Type Select the Swift Message type from the drop down list You have the following options e MT799 e MT499 e MT999 11 11 ORACLE Following are the substitute variables Message Substitution Variables Description MT799 LC_AMOUNT LC Amount

Messaging System User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents