RTGS SKN Messages Interface User Manual
Contents
1. 5 1 5 1 FUNCTIONS UD IIS T 26 225 ts cerent asa IEA AAI OSES 5 1 1 About this Manual 1 1 Introduction Oracle FLEXCUBE facilitates processing of SKN and RTGS messages for bank payments The system dispatches and processes Incoming credit payment Return of Incoming credit payment Outgoing Credit Payment Return of Outgoing Credit Payment in SKN and RTGS networks Besides this User Manual while maintaining the interface related details you can invoke the context sensitive help available for each field This help encapsulates the purpose of each field within a screen Placing the cursor on the relevant field and striking the F1 key on the keyboard can obtain information specific to a particular field 1 2 Audience This manual is intended for the following User User Roles Role Function Back office data entry Clerks Input functions for maintenance related to the interface Back office Managers Officers Authorization functions 1 3 Acronyms and Abbreviations Abbreviation Description System Unless and otherwise specified it shall always refer to Oracle FLEXCUBE Corporate FCC system Gl Generic Interface RTGS Real Time Gross Settlement SKN Sistem Kliring Nasional Indonesia National Clearing system 1 4 Organization This manual is organized into the following chapters Chapter 1 About This Manual Provides an2. SKN as the external system For more details refer Maintaining External System s Details section of Generic Interface User Manual 3 2 2 Maintaining SKN Interface Details Generic Interface GI provides a facility to define format details and properties associated to interface file You can maintain format details and properties associated with SKN interface file in the Interface Definition screen You can invoke this screen by typing GIDIFTDF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Interface Definition New Enter Query Branch Code Interface Type File Mask CRC Algorithm CRC File Mask CRC File Path Justification Date Number Text Frequency Type Week Day Month Dates Last Run Date Next Run Date CRC Required Component Details Incoming File Names Authorized By Date Time Input By Date Time External System FormatType F File Path Data Log Required Commit Fetch Frequency Date Format YYYYMMDD No Of Executions Day Duplication File Check Required For Current Date Padding Character Date Number Tex Pre Message Post Message Pre Message AUDF Post Message AUDF Modification Number Interface Code Delimiting Character Confirmation File Required When To Run Mandatory Trigger Type Confirmation File Mask Confirmation File Path Incoming Function Id Processed File Mask Default Action New On Override Reje Outg
3. form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated
4. introduction to the organisation of the Manual Chapter 2 RTGS Messages Provides an overview of the messages in RTGS network Chapter 3 SKN Messages Provides an overview of the messages in SKN network ORACLE 1 5 Conventions Used in this Manual STOP Important information is preceded with the 9 symbol 1 6 Glossary of Icons CRECEN Delete row Option List 1 7 Related Documents You may need to refer to any or all of the User Manuals while working on the IF RTGS SKN Messages module e Procedures User Manual e Gl e CS e FT e MS e PC e LC 1 2 ORACLE 2 1 Introduction 2 RTGS Messages Oracle FLEXCUBE supports processing of messages in RTGS network Incoming credit payment Return of Incoming Credit payment Outgoing Credit payment return of outgoing credit payment and Incoming debit are the messages dispatched and processed in RTGS networks 22 Maintaining Details for RTGS Interface You need to maintain the following details for this interface e Details of External System e Details of the Interface e Interface Parameterization e Interface Translation 2 2 1 Maintaining External System You need to specify the external system connected to the interface by using the External System Maintenance screen You can invoke the External System Maintenance screen by typing GWDEXSYS in the field at the top right corner of the Application tool bar and clicking the adjoining ar
5. RACLE DRLQ Incoming Network GL NOSTRO Debit Transaction Amount DRLQ Intermediary GL Credit Transaction Amount If the transaction is completely authorized from the incoming authorization queue that means the transaction not falls on any exception queue then system will process the CRLQ event Event Account Debit Credit Amount CRLQ Intermediary GL Debit Transaction Amount CRLQ Customer Account Credit Transaction Amount If the incoming payment is rejected from the incoming authorization queue then system will process CRLQ event Event Account Debit Credit Amount CRLQ Intermediary GL Debit Transaction Amount Unsettle GL will be picked CRLQ up from Product Category Credit Transaction Amount If the incoming payment or return of outgoing payment is suspended from the incoming authorization queue then system will process the CRLQ event with following accounting entries Event Account Debit Credit Amount CRLQ Intermediary GL Debit Transaction Amount Unsettle GL will be picked CRLQ up from Product Category Credit Transaction Amount If the incoming payment or return of outgoing payment is authorized from the repair queue then system will not post any accounting entries and the transaction will be moved into incoming authorization queue If the incoming payment is rejected from the re
6. RTGS SKN Messages Oracle FLEXCUBE Universal Banking Release 12 0 May 2012 Oracle Part Number E51527 01 ORACLE FINANCIAL SERVICES RTGS SKN Messages 1 bd Table of Contents ABOUT THIS MANUAL Pres S 1 1 1 1 INTRODUCTION 4 5t eedem tmt tSt S ame ttu te D 1 1 E2 SAUDIENGES5 eoe Un ardenter pA oT dits 1 1 1 3 ACRONYMS AND ABBREVIATIONS esee nennen nennen tein nenne tni n ER iini nn einsehen ts insta iini EE 1 1 L4 DORGANIZATION GS rore eher eren eet eda ee Ea E be ere gue i aU ENS 1 1 1 5 CONVENTIONS USED IN THIS MANUAL eeeeeeeeeenenenenen ese veereb nnne teint inniti nenne entere nosnu tt esaea Eo Ue E ense innere 1 2 1 6 RELATED DOCUMENTS 4 tret tere tere e e e tone ge e Ue ch eee e XE ER gr eR EE eter ko eee enis 1 2 jLrn0 2 1 2 1 INTRODUCTION ENEE EEE sets aiepaa so vebsishes dasussoacb sean as savsuosss RR ERR FU RN OPEP ERR ERR ORE EAD ERES 2 1 2 22 MAINTAINING DETAILS FOR RTGS INTERFACE cccscsssessssesssesecssesscsecesessecssssecseesscsessessessassesssessssessseseseesseeseneass 2 1 2 21 Maintaining External System ee deo de ottenere eene re Heg re ERE peter tdeo 2 1 2 2 2 Maintaining RTGS Interface Details eee esee eese tenete then ne nnne tenter nnne nennen etnia 2 2 2 2 3 Maintaining RTGS Messages eiie pire eh OR Gn ER EOD ge itr Eee ERR PEE HE pete tion 2 3 2 2 4 P
7. ames Input By Date Time Authorized By External System Format Type Fixed File Path Data Log Required Commit Fetch Frequency Date Format YYYYMMDD No Of Executions Day Duplication File Check Required For Current Date Padding Character Date Number Text Pre Message Post Message Pre Message AUDF Post Message AUDF Modification Number Interface Code Delimiting Character Confirmation File Required When To Run Mandatory Trigger Type Confirmation File Mask Confirmation File Path Incoming Function Id Processed File Mask Default Action On Override Reject Outgoing Interface Suppress Start Reference Incoming File Mask Log Output Parallel Process Parallel Process Required Parallel Process No Of Records No Of Parallel Process Wi Authorized Open The following details are maintained for PCRTGSIN interface here External System Specify BIS as external system Interface Code Specify interface code as PCRTGSIN Interface Type Select Incoming as interface type from the adjoining drop down list 2 2 ORACLE File Path Specify the directory path of the incoming files to be processed File Name Specify the file name as per network Frequency Type Select Multiple times in a day as the frequency type from the adjoining drop down list Incoming File Mask Select Start With File Name as the incoming file mask from the adjoining drop down list The inter
8. d in the path 2 5 ORACLE 3 SKN Messages 3 1 Introduction 3 2 3 2 1 Oracle FLEXCUBE facilitates the outgoing and incoming payments with SKN network SKN networks dispatches and processes Incoming Credit Payment Return of Incoming Credit Payment Outgoing Credit Payment and Return of Outgoing Credit Payment messages Maintaining Details for SKN Interface You need to maintain the following details for this interface e Details of External System e Details of the Interface e Interface Parameterization e interface Translation Maintaining External System You need to specify the external system connected to the interface by using the External System Maintenance screen You can invoke the External System Maintenance screen by typing GWDEXSYS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button External System Maintenance 9 Enter Query External System Correlation Pattern External System Request Message Id Description Queue Request Message Input On Default Response Queue Response Message Full Scree Dead Letter Queue XSD Validation Required Register Response Queue Message Id External System Queues EE In Queue Response Queue FTP Parameters Input By Authorized By Modification Date Time Date Time Number L Authorized Open In this screen you can specify the following details 3 1 ORACLE External System Specify
9. e table The PC OUTFILE PATH parameter is inserted in CSTB PARAM table The outgoing file is placed in the path based on the path specified in the parameter 3 4 ORACLE 4 1 Accounting Entries 4 Annexure The following are the various accounting entries for RTGS and SKN Messages 4 1 1 Accounting entries for RTGS Incoming Debit from Central Bank If the transaction does not fall in to any of the exception queues then both DRLQ CRLQ will be processed Event Account Debit Credit Amount DRLQ Network GL Credit Charge Amount DRLQ Intermediary GL Debit Charge Amount Event Account Debit Credit Amount CRLQ Charge Fees GL Debit Charge Amount CRLQ Intermediary GL Credit Charge Amount 4 1 2 Accounting Entries for SKN RTGS incoming payments If the transaction does not fall in to any of the exception queues then both DRLQ CRLQ will be processed Event Account Debit Credit Amount Incoming Network GL DRLQ NOSTRO Debit Transaction Amount DRLQ Intermediary GL Credit Transaction Amount Event Account Debit Credit Amount CRLQ Intermediary GL Debit Transaction Amount CRLQ Customer Account Credit Transaction Amount If the transaction falls on incoming auth orization queue then DRLQ event will be processed Event Account Debit Credit Amount O
10. edit S01 Payment This is an incoming SKN Payment message for the Customer The message type received in the message will be BMSKNO1 based on which the product type will be identified Mapping between the message type and the corresponding Payment product has to be provided based on which the transaction will be created 2 SKN Incoming Customer Return of S03 Outgoing Credit Payment The message is the return of Outgoing credit payment The first 16 characters of the Remarks field in the message contain the Reference number based on which the transaction will be 3 3 ORACLE identified SKN Outgoing Payment Outgoing Credit S05 This message will be generated for the Outgoing Payment transaction using the SKN product SKN Outgoing Payment Return of S07 This message will be Incoming Credit generated when the authorizer rejects the Incoming credit Payment 3 2 4 Processing Incoming SKN Messages The interface PCSKNSINC uploads the incoming payment files through SKN networks The incoming files uploaded in the ASCII format is placed in a specified folder and the path is mapped to GI maintenance Steps involved in File processing of Incoming SKN Message When the file is uploaded the network type is identified based on the file type The file is parsed as per the message format and is uploaded in the Gl interface table From the inte
11. face details and the external system details are maintained using the Interface Definition Details and External System Maintenance screens For more details refer Specifying Interface Definition Details section of Generic Interface User Manual 2 2 3 Maintaining RTGS Messages The following table specifies the various message types and the corresponding transaction code of RTGS Network Seria Network Message Transfer Product RTGS Message Description I No from Type Type Type from SKN Product Outgoin Product Messa g Category ge Name Incomin 9 1 RTGS Incoming Custome Incoming 607 This is an Incoming RTGS Payment to r Credit the Customer Payman The Message Type received in the RTGS message will be 607 based on which the product type will be identified Mapping between the message type and the corresponding Payment product has to be provided based on which the transaction will be created 2 RTGS Incoming Custome Return of 610 This message is for return of Outgoing r Outgoing Payment Credit Payment The first 16 characters of the Payment field in the message contain the Reference number based on which the transaction will be identified 3 RTGS Outgoing Payment Outgoing 600 This message will be generated for the Credit Outgoing Payment transaction using RTGS product 4 RTGS Outgoing Payment Return of 617 This message will be generated when the Incoming authori
12. nt Negative transaction REVR Customer Account Debit Amount Negative transaction REVR Intermediary GL Credit Amount If the contract is rejected from Authorization A1 A2 queues then system will not process any accounting entries For Reject of Incoming Payments IN contracts following accounting entries will be posted for DRLQ and CRLQ events Event Account Debit Credit Amount 4 3 ORACLE DRLQ Unsettle GL Debit Transaction Amount DRLQ Intermediary GL Credit Transaction Amount CRLQ Intermediary GL Debit Transaction Amount Outgoing Network GL CRLQ NOSTRO Credit Transaction Amount ORACLE 5 Screen Glossary 5 1 Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual Function ID Function Description GIDIFTDF Interface Definition GWDEXSYS External System Maintenance 5 1 ORACLE ORACLE RTGS SKN Messages May 2012 Version 12 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_services Copyright 2012 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any
13. oing Interface Suppress Start Reference Incoming File Mask Log Output Parallel Process Parallel Process Required Parallel Process No Of Records No Of Parallel Process Authorized open The following details are maintained for PCSKNSIN interface here External System Specify BIS as external system Interface code Specify interface code as PCSKNSIN Interface Type Select Incoming as interface type from the adjoining drop down list File Path Specify the directory path of the incoming files to be processed 3 2 ORACLE File Name Specify the file name as per network Frequency Type Select Multiple times in a day as the frequency type from the adjoining drop down list Incoming File Mask Select Start With File Name as the incoming file mask from the adjoining drop down list The interface details and the external system details are maintained using the Interface Definition Details and External System Maintenance screens For more details refer Specifying Interface Definition Details section of Generic Interface User Manual 3 2 3 Maintaining SKN Messages The following table specifies the various message types and the corresponding transaction code of SKN Network Seria Network Message Payment Product Message Message Description I No from Type Collectio Type from Name Outgoing n Product Product Incoming Category 1 SKN Incoming Customer Incoming Cr
14. pair queue then system will process CRLQ event Event Account Debit Credit Amount CRLQ Intermediary GL Debit Transaction Amount Unsettle GL will be picked CRLQ up from Product Category Credit Transaction Amount 4 2 ORACLE 4 1 3 Accounting Entries for SKN RTGS outgoing payments If the contract is moved to release queue then DRLQ event will be processed Event Account Debit Credit Amount DRLQ Customer Account Debit Transaction Amount DRLQ Intermediary GL Credit Transaction Amount If the contract is released from Release queue then CRLQ event will be processed Event Account Debit Credit Amount CRLQ Intermediary GL Debit Transaction Amount Outgoing Network GL CRLQ NOSTRO Credit Transaction Amount If the contract does not require any manual authorization or release action then both DRLQ and CRLQ event will be processed Accounting entries will be posted as below Event Account Debit Credit Amount DRLQ Customer Account Debit Transaction Amount DRLQ Intermediary GL Credit Transaction Amount CRLQ Intermediary GL Debit Transaction Amount Outgoing Network GL CRLQ NOSTRO Credit Transaction Amount If the contract is rejected from Release queue then contract will be reversed and the accounting entries will be as given below Event Account Debit Credit Amou
15. rface table new program unit is written to call the PC service using the data available in the GI interface table The SKN file is identified with SKN file extension The interface job is triggered manually to initiate manual processing After the file processing and data processing incoming job PC_PRCSINMSG is executed from the job browser screen CSSJOBBR After job execution system processes the data from the GI upload table and creates Incoming payment contracts During the data process stage the transaction will be rejected for the following cases gt Corrupted input file gt Invalid record e g account number missing gt Account number field will be checked for the presence of any special characters if found then the transaction will be rejected gt TRN code is incorrect or blank 3 2 5 Processing Outgoing SKN Messages The interface PCSKNOUT uploads the outgoing payment files through SKN networks The outgoing files uploaded in the ASCII format is placed in a specified folder and the path is mapped to GI maintenance Steps involved in File processing of Outgoing SKN Message The cut off time maintained is validated for the network in order to check if the current time is within the cut off time All the outgoing payment contracts generated today along with the contracts generated after the cut off time in the previous day is selected All the fields required for the file will be inserted into the GI upload interfac
16. rocessing Incoming RTGS Message seus rrt Etre Rl ettet eee tbe ree PESEE KERESI RE euin 2 4 2 2 5 Processing Outgoing RTGS Message eset eerte tei tege bl ettet iet taper Eb Ee epe voee eden 2 4 d rnr 3 1 3 1 INTRODUCTION 15 55er pert rr hM HER RR EN ORIRUE E RUNE ER vesuveveseusevedutevaeued TREE EEKEE EET E ER UE perra Res 3 1 3 2 MAINTAINING DETAILS FOR SKN INTERFACE eeeeeeeeeneeeeenen enn enne nein uae n seesi Nedya iueiai iieis 3 1 3 2 Maintdiring Exterfal System ute et be RH Se oao S Ea Ee eSa EESE ERE OSES DERI 3 1 3 2 2 Maintaining SKN Interface Details p sciroppi enne nennen trennen etre e enne trennen 3 2 3 2 3 Maintaining SK N Messages eei ee tn RE HERE REED RR HEURE D ERE RISE 3 3 3 2 4 Processing Incoming SKN Messages eese eene neret een rennen tene tenete kaise trente entren reete enne ipoe en 3 4 3 2 5 Processing Outgoing SKN Messages eese eene nennen een rennen tne tnee tene trennen trennen eren eren E 3 4 ANNEXURE RPSL dissesti siS 4 1 4 1 ACCOUNTING ENTRIES eoe o RR OI ERU TU REA SRI RS SERAEORE NOU RIEN E URSUN 4 1 4 1 1 Accounting entries for RTGS Incoming Debit from Central Bank essere 4 1 4 1 2 Accounting Entries for SKN RTGS incoming payments esee eene eene nennen eene ener nnne 4 1 4 1 3 Accounting Entries for SKN RTGS outgoing payments eese eene nennen eene nee nrnennee 4 3 SCREEN GLOSSARY
17. row button Extemal System Maintenance I Enter Query External System External System Description Request Message Response Message External System Queues In Queue FTP Parameters Input By Date Time Correlation Pattern Request Message Id Queue Default Response Queue Dead Letter Queue XSD Validation Required Register Response Queue Message Id HE Response Queue Authorized By Modification Number L Authorized Open Date Time 2 1 ORACLE In this screen you can specify the following details External System Specify RTGS as the external system For more details refer Maintaining External System s Details section of Generic Interface User Manual 2 2 2 Maintaining RTGS Interface Details Generic Interface GI provides a facility to define format details and properties associated to interface file You can maintain format details and properties associated with RTGS interface file in the Interface Definition screen You can invoke this screen by typing GIDIFTDF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Interface Definition New amp Enter Query Branch Code Interface Type File Mask CRC Algorithm CRC File Mask CRC File Path Justification Date Number Text CRC Required Frequency Type Da Week Day Month Dates Last Run Date Next Run Date Component Details Incoming File N
18. through RTGS networks The outgoing files uploaded in the ASCII format is placed in a specified folder and the path is mapped to Gl maintenance Steps involved in File processing of Outgoing RTGS Message All the outgoing payment contracts generated on the day along with the contracts generated after the cut off time in the previous day is selected All the fields required for the message is inserted into the GI upload interface table From the interface table file is generated and placed in the directory location A new parameter NO OF OUT TXN is introduced in CSTB PARAM This parameter denotes the number of transaction to be grouped in a single file If the number of transaction to be processed exceeds the count then multiple outgoing files are generated The outgoing job PC_PRCSOUTMSG is introduced for processing outgoing file generation After the execution of job from the job browser screen the system 2 4 ORACLE Selects the set of contracts to be dispatched Processes individual contracts to build the message body on per transaction basis Based on the parameter count the individual transactions are grouped in the file and the corresponding header and footer are built Multiple files are generated for both RTGS and SKN in case if the number of transactions exceeds the parameter count New parameter PC OUTFILE PATH will be introduced in the CSTB PARAM table Based on the path specified in the parameter the outgoing file is place
19. zer rejects the Incoming credit 2 3 ORACLE Credit payment RTGS Incoming Payment RTGS Debit 637 Notification 2 2 4 Processing Incoming RTGS Message The interface PCRTGSINC uploads the incoming payment files through RTGS networks The incoming files uploaded in the ASCII format is placed in a specified folder and the path is mapped to Gl maintenance Steps involved in File processing of Incoming RTGS Message When the file is uploaded the network type is identified based on the file type The file is parsed as per the message format and is uploaded in the Gl interface table From the interface table new program unit is written to call the PC service using the data available in the Gl interface table The RTGS file will be identified with RTGS file extension The interface job is triggered manually to initiate manual processing After the file processing and data processing incoming job PC_PRCSINMSG is executed from the job browser screen CSSJOBBR After job execution system processes the data from the GI upload table and creates Incoming payment contracts The following validation is done as part of file parsing and it will be rejected if validation fails ncorrect credit count debit count gt Incorrect total credit amount total debit amount gt TRN code is incorrect or blank 2 2 5 Processing Outgoing RTGS Message The interface PCRTGSOUT uploads the outgoing payment files
Download Pdf Manuals
Related Search