RTGS SKN Messages Interface User Manual
Contents
1. CRLQ will be processed Event Account Debit Credit Amount DRLQ Incoming Network GL Debit Transaction Amount NOSTRO DRLQ Intermediary GL Credit Transaction Amount Event Account Debit Credit Amount CRLO Intermediary GL Debit Transaction Amount CRLQ Customer Account Credit Transaction Amount If the transaction falls on incoming authorization queue then DRLO event will be processed Event Account Debit Credit Amount 4 ORACLE DRLO Incoming Network GL Debit Transaction Amount NOSTRO DRLO 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 CRLO 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 CRLO Intermediary GL Debit Transaction Amount CRLO Unsettle GL will be picked Credit Transaction Amount up from Product Category If the incoming payment or return of outgoing payment is suspended from the incoming authorization queue then system will pro2. Justification Date Number Text Freguency Type Week Day Month Dates Last Run Date Next Run Date Incoming v EI CRC Required L PA Component Details Incoming File Names Input By Date Time Authorized By Date Time External System FormatType Fixed v File Path Data Log Reguired CommitFetch Freguency W 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 Interface Code Delimiting Character When To Run Trigger Type Confirmation File Mask Confirmation File Path Incoming Function Id Processed File Mask Default Action On Override Outgoing Interface Incoming File Mask Log Output Parallel Process Parallel Process No OfRecords No Of Parallel Process 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 File Path Specify the directory path of the incoming files to be processed File Name Specify the file name as per network Frequency Type F Confirmation File Required Mandatory Manual v New v Rejet v Suppress Start
3. Maintaining External System ee ee kaa aa n ee ee Ge ke ee ee ee 3 1 3 2 2 Maintaining SKN Interface DetailsS ee GR Re ee GR Re ee ee Re ee ee 3 2 3 2 3 Maintaining SKN Messages ee ee ee ee kaa ee Re ee ee ee ke ee ee ee 3 3 3 2 4 Processing Incoming SKN Messages iii ee ee AR Re ee ee ke ee ee 3 4 3 2 5 Processing Outgoing SKN Messages errar 3 5 ANNEX TE EE EE eee Ao to STS ee ee te et 4 1 d 1 Accounting ENTES mets n Menen taksia eet de 4 1 4 1 1 Accounting entries for RTGS Incoming Debit from Central Bank 4 1 4 1 2 Accounting Entries for SKN RTGS incoming payMeNtS wwmmmmmmmmwa 4 1 4 1 3 Accounting Entries for SKN RTGS Outgoing Payments wwmwwwmmmwa 4 2 Function ID Glossary s o EE ee Ee t nin KAL N EA Ee Bee La ds sena 5 1 1 1 1 2 1 3 1 4 1 Preface 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 lt F1 gt key on the keyboard can obtain informa
4. Payment 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 Gl 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 interface table new program unit is written to call the PC service using the data available in the Gl 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 Gl upload table and creates Incoming payment contracts During the data process stage the transaction will be rejected for the following cases n ORACLE 3 2 5 Corrupted input file Invalid record e g account number missing Account number field will be checked for the presence of any special characters if found then the transaction will be rejected TRN code is incorrect or blank Processing Outgoing SKN Messages The interface PCSKNOUT uploads the outgoing payment files through SKN net
5. Reference E Parallel Process Required v Select Multiple times in a day as the freguency type from the adjoining drop down list 2 2 ORACLE 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 2 2 3 Maintaining RTGS Messages The following table specifies the various message types and the corresponding transaction code of RTGS Network i Produ essag ct S Network ype Type f a Ser Outgoin Transfer rom H ial from gl Type Produ Messa Message Description No Product Incomin ct a Name g Categ ory 1 RTGS Incoming Cus Incom 607 This is an Incoming tomer ing RTGS Payment to the Credit Customer A 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 Pay ment product has to be provided based on which the transaction will be created 2 RTGS Incoming Cus Return 610 This message is for tomer of Out return of Outgoing going Payment v The first 16 charac ment ters of the Payment field in the message contain t
6. 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 Systems Ci New External System Correlation Pattern External System Request Messageld v Description Queue Request Message InputOnly v Default Response Queue Response Message FullScreen v Dead Letter Queue 4 E Register Response Queue 5 XSD Validation Required Message Id External System Queues SCI a In Queue Response Queue FTP Parameters Input By Authorized By Date Time Date Time In this screen you can specify the following details e ORACLE 2 2 2 External System Specify RTGS as the external system For more details refer Maintaining External System s Details section of Generic Interface User Manual Maintaining RTGS Interface Details Generic Interface Gl provides a facility to define format details and properties associated to interface file OLE LINK1 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 Branch Code Interface Type File Mask CRC Algorithm CRC File Mask CRC File Path
7. ORACLE RTGS SKN Messages User Guide Oracle FLEXCUBE Universal Banking Release 12 0 3 0 0 Part No E53393 01 April 2014 RTGS SKN Messages User Guide April 2014 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently danger
8. ates 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 di Sn CR AAA EN EE OE EE EN 1 1 Tti UA OE RA OE EE EN NE EE 1 1 1 20 Gel EE OR NE OE eika Ki OE EE OE OE EE 1 1 1 3 Documentation Accessibility iii se ee ee Re ee Re ee Ge RR ee RA ee ennnen 1 1 TA UGANI N OR EE ME ER EG 1 1 1 5 Acronyms and AbbreviatiOnS iese ee ee ee ee ekana ee ee ee ee ee ee 1 2 1 6x Organization EE ener RE thei EN Jenttu ehtien 1 2 Tet 6lossary ot EONS EER EE ee EE GE GE Ge SE EE ee ee Gee Ee De EE Ee ee Ai 1 2 18 Related Documents Ee ee aiina eaaa araa aa ee annan iwa de ee aa ee Ge ee 1 2 RTGS Messages EE GE sanada Gina saias 2 1 2 40 Introduction SEE EE EE EG GE ED EED EE EG ces DE 2 1 2 2 Maintaining Details for RTGS Interface ooo eee ee ee ee AA ee naamini 2 1 2 2 1 Maintaining External System ee ee ek Ge Re ee aa aa Re ee ee ee 2 1 2 2 2 Maintaining RTGS Interface Details ie ee Re ee a ee Re ee ee 2 2 2 2 3 Maintaining RTGS Messages akka kaa aa ke ee ee ee 2 3 2 2 4 Processing Incoming RTGS Message errante 2 4 2 2 5 Processing Outgoing RTGS Message resinas 2 4 SKN Messages ln Ee Bee Ee ek tt oe RARR Pe oe Sid Bes SE gl ee cando 3 1 31 Introduction ER EE e nalan SA GE As Se A Ve AA Ge ER aa an en Va ga Aaa Vi 3 1 3 2 Maintaining Details for SKN Interface oe ee ee ee ee AR aa n ee Re ee ed ee ee ee 3 1 3 2 1
9. cess the CRLQ event with following accounting entries Event Account Debit Credit Amount CRLO Intermediary GL Debit Transaction Amount CRLO Unsettle GL will be picked Credit Transaction Amount up from Product Category If the incoming payment or return of outgoing payment is authorized from the repair gueue then system will not post any accounting entries and the transaction will be moved into incoming authorization gueue If the incoming payment is rejected from the repair queue then system will process CRLQ event Event Account Debit Credit Amount CRLO Intermediary GL Debit Transaction Amount CRLO Unsettle GL will be picked Credit Transaction Amount up from Product Category Accounting Entries for SKN RTGS Outgoing Payments If the contract is moved to release queue then DRLQ event will be processed 42 ORACLE Event Account Debit Credit Amount DRLQ Customer Account Debit Transaction Amount DRLO Intermediary GL Credit Transaction Amount If the contract is released from Release queue then CRLQ event will be processed Event Account Debit Credit Amount CRLO Intermediary GL Debit Transaction Amount CRLO Outgoing Network GL Credit Transaction Amount NOSTRO If the contract does not require any manual authorization or release action then both DRLQ and CRLO event
10. eal Time Gross Settlement SKN Sistem Kliring Nasional Indonesia National Clearing system Organization This manual is organized into the following chapters Chapter 1 About This Manual Provides an introduction to the organisation of the Manual Chapter 2 RTGS Messages Provides an overview of the messages in RTGS net work Chapter 3 SKN Messages Provides an overview of the messages in SKN network Glossary of Icons Icons Function KI Exit Add row Delete row EE Option List 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 GI e CS e FT e MS e PC e LC Ve ORACLE 2 RTGS Messages 2 1 Introduction 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 2 2 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
11. een v Dead Letter Queue e ed E Register Response Queue XSD Validation Required pi External System Queues Min Queue Response Oueue FTP Parameters Input By Date Time In this screen you can specify the following details External System Specify SKN as the external system Si ORACLE For more details refer Maintaining External System s Details section of Generic Interface User Manual 3 2 2 Maintaining SKN Interface Details Generic Interface Gl 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 Branch Code Interface Type Incoming v File Mask CRC Algorithm CRC File Mask CRC File Path Justification Date Number Text Freguency Type Week Day Month Dates Last Run Date Next Run Date 7 CRC Required lae Component Details Incoming File Names Input By Date Time Authorized By Date Time External System 23 Format Type Fixed v File Path 7 Data Log Required CommitFetch Freguency Date Format YYYYMMDD No Of Executions Day E Duplication File Check Required For Curr
12. ent Date Padding Character Date Number Text Pre Message PostMessage Pre Message AUDF Post Message AUDF Interface Code Delimiting Character E Confirmation File Required When To Run E Mandatory Trigger Type Manual v Confirmation File Mask Confirmation File Path Incoming Function Id nz Processed File Mask __ Default Action New v On Override Reject v Outgoing Interface Jal Suppress Start Reference Incoming File Mask Log Output Parallel Process E Parallel Process Required Parallel Process v No Of Records No Of Parallel Process 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 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 3 2 ORACLE 3 2 3 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 I
13. he Reference number based on which the transaction will be identified 3 RTGS Outgoing Payment Outgo 600 This message will be ing generated for the Out Credit going Payment trans action using RTGS product 2 3 ORACLE 2 2 4 2 2 5 4 RTGS Outgoing Payment Return 617 This message will be of generated when the Incom authorizer rejects the ing Incoming credit pay Credit ment 5 RTGS Incoming Payment RTGS 637 Debit Notifi cation 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 GI 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 GI interface table From the interface table new program unit is written to call the PC service using the data available in the GI 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 pay
14. ment contracts The following validation is done as part of file parsing and it will be rejected if validation fails Incorrect credit count debit count Incorrect total credit amount total debit amount TRN code is incorrect or blank Processing Outgoing RTGS Message The interface PCRTGSOUT uploads the outgoing payment files through RTGS 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 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 Gl 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 ORACLE The outgoing job PC PRCSOUTMSG is introduced for processing outgoing file generation After the execution of job from the job browser screen the system 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 t
15. nterface Definition Details section of Generic Interface User Manual Maintaining SKN Messages The following table specifies the various message types and the corresponding transaction code of SKN Network Seria I No Network from Product Message Type Outgoing Incoming Payme nt Collecti on Product Type fro m Product Category Mess age Name Message Description SKN Incoming Cus tomer Incoming Credit Payment S01 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 corre sponding Pay ment product has to be pro vided based on which the trans action will be created ORACLE 3 2 4 SKN Incoming Cus Return of S03 The message tomer Outgoing is the return of Credit Outgoing Payment credit payment The first 16 characters of the Remarks field in the message con tain the Refer ence number based on which the transaction will be identi fied SKN Outgoing Pay Outgoing S05 This message ment Credit will be gener ated for the Outgoing Pay ment transac tion using the SKN product SKN Outgoing Pay Return of S07 This message ment Incoming will be gener Credit ated when the authorizer rejects the Incoming credit
16. ous 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 its affili
17. ransactions 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 placed in the path 2 ORACLE 3 1 3 2 3 2 1 3 SKN Messages Introduction 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 Systems 1 New External System Correlation Pattern External System Request Messageld v Description L Queue Request Message InputOnly v Default Response Queue e Response Message FullScr
18. tion specific to a particular field 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 Officers Back office Managers Authorization functions Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http www oracle com pls topic lookup ctx acc amp id docacc Organization This manual is organized as follows About this Manual gives information on the intended audience It Chapter1 also lists the various chapters covered in this User Manual Chapter 2 RTGS Messages explains the process of maintaining the incoming p and outgoing credit payment messages through RTGS interface Chapter 3 SKN Messages explains the process of maintaining the incoming p and outgoing credit payment messages through SKN interface Annexure lists all the various accounting entries for RTGS and SKN Chapter 4 Messages Chapter 5 Function ID Glossary has alphabetical listing of Function Screen ID s used in the module with page references for guick navigation 14 ORACLE Acronyms and Abbreviations Abbreviation Description System Unless and otherwise specified it shall always refer to Oracle FLEX CUBE Corporate FCC system GI Generic Interface RTGS R
19. will be processed Accounting entries will be posted as below Event Account Debit Credit Amount DRLO Customer Account Debit Transaction Amount DRLO Intermediary GL Credit Transaction Amount CRLO Intermediary GL Debit Transaction Amount CRLO Outgoing Network GL Credit Transaction Amount NOSTRO 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 Amount REVR Customer Account Debit Negative transaction Amount REVR Intermediary GL Credit Negative transaction Amount If the contract is rejected from Authorization A1 A2 gueues 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 DRLO Unsettle GL Debit Transaction Amount DRLO Intermediary GL Credit Transaction Amount CRLO Intermediary GL Debit Transaction Amount ORACLE Event Account Debit Credit Amount CRLQ Outgoing Network GL NOSTRO Credit Transaction Amount ORACLE 5 Function ID Glossary G GIDIETDE ui 2 2 GWDEXSYS 2 1 SA ORACLE
20. works 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 reguired for the file will be inserted into the GI upload interface 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 De ORACLE 4 Annexure 4 1 Accounting Entries 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 DRLO Network GL Credit Charge Amount DRLO Intermediary GL Debit Charge Amount Event Account Debit Credit Amount CRLO Charge Fees GL Debit Charge Amount CRLO 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
Download Pdf Manuals
Related Search