FCUBS-FD04-02-01-Generic Interface Configuration Guide
Contents
1. be executed after the component is processed if any Pre Record Specify the value that needs to be calculated before the record is processed if any Pre Record AUDF Specify the AUDF that has to be executed before the record is processed if any You can use this to add any additional functionality required at the record level Post Record FD04 02 01 Generic Interface Configuration Guide 23 Specify the value that needs to be calculated after the record is processed if any Post Record AUDF Specify the AUDF that has to be executed after the record is processed if any You can use this to add any additional functionality required at the record level Component Field Linkage You can specify the component field linkage details here i e the data to be fetched in the file Serial Number Specify the order of fields here Field Name Specify the field name here that will be created for the interface Field Type Select the type of field from the options available in the drop down list The options available are e Message e Intermediate e Start Identifier e End Identifier e Action Default Specify the default value for the field here Data type Specify the data type of the field here Length Specify the length of the field here Column Name Specify the column name in the database of the field here From the data source Object Name Specify the object name from which the field should be derived Name of the table fo2. process for error records For an outgoing file it is a single process of reading for database and writing in to file But for incoming file there are two steps 1 Reading the data from file and inserting into upload table File Process FP 2 Reading the data from upload table and uploading as part of base table Data Process DP Now the file is generated in the path as mentioned in the interface definition 4 4 2 Incoming interface Trigger Branch Code 000 Interface Code INCOME External System EXTGI Interface File Name in tet Status W Process Code Input By Authorized By Modification Authorized Exit Date Time Date Time Number Open FD04 02 01 Generic Interface Configuration Guide 27 Branch Code Specify the branch code from where the GI file process has to be initiated Interface Code Select the Interface Code that has to be processed External System Specify the external system from to where the details have to be picked up or delivered respectively Here the external system is EXTGI Interface Type Select the type of interface from the drop down list The options available are e Incoming e Outgoing Here its I i e Incoming File Name Specify the file name if the selected Interface Code is Incoming Process Code Select the process code from the drop down list if the selected Interface Code is Incoming The options available are FP Populating the Upload tables using the file d
3. ION JL Component Linkage You can specify the component linkage details here Serial Number Specify the component position here Component Name Specify a name for the component Here the name is BDY Component Type This field indicates the component type of the file following are the possible values of component type e Header e Body FD04 02 01 Generic Interface Configuration Guide 22 Footer Batch Header Batch Footer Batch Body Here the type is BODY Parent Specify the parent component to which component is linked Relation If parent component is specified then specify the relation here Batch by Field Specify the field in the component based on which you want to create a batch This is applicable only for Outgoing Interfaces Where Clause Specify the where Clause for the component Group By Specify the group by clause for the component Order By Specify the order by clause for the component Pre Component Specify the value to be calculated before the component is processed if any Pre Component AUDF Specify the AUDF that has to be executed before the component is processed if any You can use this to add any additional functionality required at the component level Post Component Specify the value to be calculated after the Component is processed if any Post Component AUDF You can use this to add any additional functionality required at the component level Specify the AUDF that has to
4. Oracle FLEXCUBE Universal Banking 12 0 Generic Interface Configuration Guide Release 1 0 May 2012 ORACLE FINANCIAL SERVICES Contents 1 O 3 Vel A o 3 SA E A O E E 3 SN A O sum saseounaaees 3 2 A O O 3 28 HOw tose this CI A yates weaned canasaezeansbned cuaaaaeceunaaees AE 3 3 Generic Interface Getting started isernia aa aE E T E E E EEN 4 4 Generic Interface Configuration OVerViCW ssccsescccesecesseecseecscecsseeeesaeecsseecsscecsseecesaeecsaeersaeessneeeesaeeesaeers 5 AA File Folders reation s2 2 20265 4 sees isaestcassaceadaysteseaxaeungsceceasagne luadsi tea Wesust canes eaten saved E 6 ALA SQUIBOLNG aiiin a e goss da E iaa 6 AAD ANCOMING sexi E E T 6 4 2 Creation of External system isrener e nen Tenen eav te E E E dite te bade el een 6 4 3 Creation of Interface definition cececcccceeesccceesneeeeeeeeceecesceeeceeaeeecesnaeeecesaeeeeeseaeeeeeseaeeesseaeeeeesneeeseenees 9 AED Outgoing Interface irsini e aa bed EE iO 9 BID EIA RO 17 AA Trig Ser Interfaces nissan abba 26 AAN O OURROING A Mehdi hel Melisa ees 26 BAD TE AA NO 27 Ad NeStresult ss saicveiesiscecdecee secu iv 28 451 OUPBOING a a Mackie aoh aii dealin a eine lie 28 A IE AO 29 FD04 02 01 Generic Interface Configuration Guide 2 1 Preface This document Generic Interface Configuration Guide explains the steps to create incoming or outgoing ASCII Generic Interface in FLEXCUBE UBS 1 1 Audience This Generi
5. ata DP Populating the Base tables from the Upload tables e AL This is will trigger FP and DP processes one after another e RT This is Retry operation the previous process that failed is triggered RE This will rerun the DP process for error records For an outgoing file it is a single process of reading for database and writing in to file But for incoming file there are two steps 1 Reading the data from file and inserting into upload table File Process FP 2 Reading the data from upload table and uploading as part of base table Data Process DP It s Process All so that it will first initiate the FP and then DP If successfully the process is triggered it will update the data in the file to the table as defined in the interface details i e data from in txt to JKTM_JUNK_TRNCODE 4 5 Test results 4 5 1 Outgoing In the specified path location check for the outgoing file generated with the name specified in the interface definition screen FD04 02 01 Generic Interface Configuration Guide 28 4 5 2 Incoming Ensure the upload table is populated with records from incoming file FD04 02 01 Generic Interface Configuration Guide 29 ORACLE Generic Interface Configuration Guide oe 2012 Oracle Corporation World Headquarters 500 Oracle Parkwa Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_services Copyri
6. c Interface Configuration Guide is intended for FLEXCUBE Application Developers Users who require to do the following tasks e Create Incoming ASCII upload interface using GI framework e Create Outgoing ASCII handoff interface using GI framework 1 2 Related documents For more information on Interfaces see these resources FCUBS FD01 01 01 Development Overview Guide FCUBS FD04 01 01 Interface Getting started FCUBS FD04 03 01 Upload Adapter Development Guide 1 3 Conventions The following text conventions are used in this document Convention Meaning boldface Boldface type indicates graphical user interface elements for example menus and menu items buttons tabs dialog controls including options that you select italic italic type indicates book titles emphasis or placeholder variables for which you supply particular values moonscape Monospace type indicates language and syntax elements directory and file names URLs text that appears on the screen or text that you enter 2 Introduction 2 1 How to use this Guide Chapter 2 Introduction This is an introduction section Chapter 3 Getting Started This section discusses GI Chapter 4 Generic Interface Configuration Overview This section describes the GI functioning FD04 02 01 Generic Interface Configuration Guide 3 3 Generic Interface Getting started Generic Interface framework is used to define Interface code that a
7. cts as an entry point to upload data into FLEXCUBE UBS or handoff data from FLEXCUBE There are two types of GI e Incoming ASCII file data that needs to be uploaded into FLEXCUBE UBS e Outgoing FLEXCUBE UBS data to be created in ASCII file FD04 02 01 Generic Interface Configuration Guide 4 4 Generic Interface Configuration overview This section describes the overview of the Generic Interface Configuration FD04 02 01 Generic Interface Configuration Guide 4 1 File Folders Creation Create following folder structure in the FLEXCUBE UBS Application server Eg gi EI incoming E confirmation 5 processed 5 ready EE cre 5 processed 5 ready EME data 5 error 5 processed 5 ready G wip H outgoing EE confirmation 5 ready wip ED cre 5 ready E wip EM data 5 ready G wip m 4 1 1 Outgoing Outgoing the file writing process takes place in the WIP folder and on successful completion of the writing process the file is moved to the Ready folder The name of the file will be based on the File mask maintained in the Interface Definition 4 1 2 Incoming Incoming file should be placed in the ready folder when it is ready for upload When the Interface is triggered after successful file validation the file the file is moved to the WIP folder and the Interface processing unit is triggered by the GI Processing framework If the file validation fails the file is moved to the Error fo
8. e Specify the field name here that will be created for the interface Field Type Select the type of field from the options available in the drop down list The options available are e Message Intermediate e Start Identifier e End Identifier e Action Default Specify the default value for the field here Data type Specify the data type of the field here Length Specify the length of the field here Column Name Specify the column name in the database of the field here From the data source Object Name Specify the object name from which the field should be derived Name of the table for which data is to be written in the flat file Here the table name is JKTM_JUNK_TRNCODE Start Position Specify the start index of the field in the fixed length format Precision If the field is of numeric type then specify precision here Translation If the field value needs to be translated then select the translation code that has to be used for the translation FD04 02 01 Generic Interface Configuration Guide 16 Un translated Specify the action to be taken if the translation value is not present Derivation Specify the derivation logic for the field Pre Field Specify the value that needs to be calculated before the field value is processed Pre Field AUDF Specify the AUDF that should be executed before the processing of the field here Post Field Specify the value that needs to be calculated after the
9. face should be triggered The options available are e Manual Select this option if the interface has to be triggered manually e System Select this option if the interface has to be triggered automatically During EOD if there are any mandatory unprocessed interfaces and if the triggering type is selected as System then the interface is triggered automatically In case of Incoming interface if triggering type is selected as System then system checks if the file is available in the ready folder for that interface If the file is present the system will process it In case of outgoing interface if triggering type is selected as System then system will automatically trigger the Outgoing interface Here its manual type It can be triggered manually whenever required Frequency Type Select the frequency type for interface file processing from the following drop down options Daily e Weekly e Fort Nightly e Monthly e Quarterly e Yearly e Adhoc Week Day If you select frequency type as Weekly select the day from the drop down list for processing the interface file The options available are e Sunday e Monday e Tuesday e Wednesday e Thursday e Friday e Saturday FD04 02 01 Generic Interface Configuration Guide 12 Month If you select frequency type as Fort Nightly Monthly Weekly Yearly select the month for the interface files execution from the drop down list The options a
10. field value is processed Post Field AUDF Specify the AUDF that should be executed after the processing of the field 4 3 2 Incoming Interface Definition Branch Code 000 File Mask CRC Required CRC Algorithm CRC File Mask CRC File Path Justification Date Number Text Frequency Type Week Day Month Date LastRun Date 2012 03 01 Next Run Date 2012 03 01 External System EXTGI Format Type File Path nome fcubs gilog ai inco ming data Data Log Required Commit etch 500 Frequency Date Format YYYYMMDD No Of Executions Day 1 Duplication File Check Reqd For Current Date Padding Character Date Number Text Pre Message Post Message Pre Message AUDF Post Message AUDF Interface Code INCOME Delimiting Character Confirmation File Required When To Run Mandatory Trigger Type Confirmation File Mask Confirmation File Path Incoming Function Iid JKDTRNCD Processed File Mask Default Action On Override Outgoing Interface Suppress Start Reference Incoming File Mask Exact File Log Output Parallel process Parallel Process Required Parallel process No Of Records No Of Parallel Process Component Details Incoming File Names Input ByPIYUSH1 Date Time 2012 03 01 18 15 11 Authorized ByPIYUSHB Modification Authorized Date Time 2012 03 01 18 16 04 Number Open Branch Code FD04 02 01 Generic Interface Configuration Guide 17 Specify the code of the branch to w
11. g process the file is moved to the Ready folder The name of the file will be based on the File mask maintained in the Interface Definition Here it will be OUT o Data Log Required Check this box to indicate if the confirmation details are required t in logged file Commit Fetch Frequency Specify the number of transaction committed or fetched at a given point of time Date Format Specify the date format for the interface file No of Executions Day If you select frequency type as Daily specify select the number of interface file processing executions per day from the drop down This field is applicable only for incoming interface file process Interface Code Specify a unique interface code to identify the interface as incoming or outgoing Here the code is OUTER1 FD04 02 01 Generic Interface Configuration Guide 11 Delimiting Character Specify the delimiting character if you select the format type of definition as Delimited When to Run Select the stage of application the interface has to be triggered Mandatory Check this box to indicate that the interface has to be mandatorily processed before moving on to the next stage of EOD If this box is checked system checks if the interface has been processed or not and if it is not processed system will not allow movement to the next EOD stage Triggering Select an appropriate option to indicate how the inter
12. ght O 2012 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document FD04 02 01 Generic Interface Configuration Guide 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 FD04 02 01 Generic Interface Configuration Guide 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 FD04 02 01 Generic Interface Configuration Guide 30
13. h Interface Trigger screen You can invoke this screen by typing GIDIFPRS 4 4 1 Outgoing interface Trigger Branch Code 000 Interface Code OUTER1 External System EXTGI Interface O File Name Status Process Code Information Message Input By Authorized By Modification Authorized Date Time Date Time Number Open You can provide the following details here to invoke the GI routing package Branch Code Specify the branch code from where the GI file process has to be initiated Interface Code Select the Interface Code that has to be processed External System Specify the external system from to where the details have to be picked up or delivered respectively Here the external system is EXTGI Interface Type Select the type of interface from the drop down list The options available are FD04 02 01 Generic Interface Configuration Guide 26 e Incoming e Outgoing Here it s O i e Outgoing File Name Specify the file name if the selected Interface Code is Incoming Process Code Select the process code from the drop down list if the selected Interface Code is Incoming The options available are e FP Populating the Upload tables using the file data DP Populating the Base tables from the Upload tables e AL This is will trigger FP and DP processes one after another e RT This is Retry operation the previous process that failed is triggered e RE This will rerun the DP
14. h interface file in the Interface Definition screen You can invoke this screen by typing GIDIFTDF FD04 02 01 Generic Interface Configuration Guide 9 interface Definition X A Branch Code 900 External System EXTGI Interface Code OUTER1 ra Interface Type going Format Type Delimiting Character File Mask O U T File Path home fcubs gilog ai outa Confirmation File CRC Required oing data fe Required i When To Run CRC Algorithm Data Log Required CRC File Mask CommitFetch 500 Mandatory jai Trigger Type CRC File Path Date Format YYYYMMDD 7 ile Mask No Of Executions Day 4 Confirmation File Mask aeii F Confirmation File Path Duplication File Check Reqd For Current Date Justification Padding Character Incoming Date Date Function Id Number Number Processed File Mask z Text Text Default Action ui On Override F ney Tyi re Message da ime Outgoing Interface Week Day Post Message E i Suppress Start Month Pre Message AUDF Reference Date Post Message AUDF Incoming File Mask LastRun Date 2012 03 01 Log Output Next Run Date 2012 03 01 Parallel process Parallel Process Required Parallel process No Of Rezords No Of Parallel Process E SS Component Details Incoming File Names Input ByPIYUSHB Authorized ByPIYUSH1 Modification 1 Authorized exit Date Time 2012 03 01 18 07 29 Date Time 2012 03 01 18 08 55 Number Open Branch Code Specify the code of the branch to which the interface belongs Here it is 000 Inte
15. hich the interface belongs Here it is 000 Interface Type Select the interface type from the following options e Incoming Select this option if the file data needs to be uploaded into Oracle FLEXCUBE e Outgoing Select this option if data from Oracle FLEXCUBE needs to be written into file Here the interface type is INCOMING File Mask Specify the file mask for the outgoing interface file External System Specify the external system with which Oracle FLEXCUBE is interfacing Here the system is EXTGI the one created earlier Format Type Select the type of data length in the interface from the following options e Fixed Select this option if the file data has to be in fixed width e Delimited Select this option if the file data has to be in delimited format Delimiting Character field gets enabled for you to specify the delimiting character if you select the format type of definition as Delimited File Path Specify the path of the file a gi incoming data as mentioned in below picture E gi E incoming a confirmation 5 processed 5 ready D cre 5 processed y ready 5 error 5 processed 5 ready wip E outgoing E confirmation 5 ready O wip cre 5 ready O wip data 5 ready O wip In case of GI Incoming the Incoming file should be placed in the ready folder when it is ready for upload When the Interface is triggered after successful file validation the file the FD04 02 01 Gener
16. ic Interface Configuration Guide 18 fl m Cal m file is moved to the WIP folder and the Interface processing unit it triggered by the GI Processing framework If the file validation fails the file is moved to the Error folder On successful processing of the file the file is renamed based on the processed file mask attribute maintained in the interface definition and moved to the processed folder Data Log Required Check this box to indicate if the confirmation details are required t in logged file Commit Fetch Frequency Specify the number of transaction committed or fetched at a given point of time Date Format Specify the date format for the interface file No of Executions Day If you select frequency type as Daily specify select the number of interface file processing executions per day from the drop down This field is applicable only for incoming interface file process Interface Code Specify a unique interface code to identify the interface as incoming or outgoing Here the code is INCOME Delimiting Character Specify the delimiting character if you select the format type of definition as Delimited When to Run Select the stage of application the interface has to be triggered Mandatory Check this box to indicate that the interface has to be mandatorily processed before moving on to the next stage of EOD If this box is checked system checks if the interface has been proces
17. ional functionality required at the message level Incoming File You can specify the interface details applicable for incoming file details here Function ID Specify the function id for which the incoming data need to be sent Here the function id is JKDTRNCD Processed File Mask Specify the file mask for renaming the incoming file after uploading the data Default Action Select the default action which needs to be invoked to process the uploaded data in the upload table from the drop down list below e New e Modify e Close Here the action is NEW On Override Select the action to be taken if an override occurs from the drop down list below e Reject e Continue e Skip Outgoing Interface Specify the corresponding outgoing interface file for the above incoming file FD04 02 01 Generic Interface Configuration Guide 21 e Specifying Component Details You can specify the component details here Click Component Details button in the Interface Definition screen 9 Component Details Component Linkage BW serial Number Component Name ComponentType Parent Relation Batch By Field Where Clause lt i Component Field Linkage BW serial Number FieldName Field Type Default Data Type Length Column Name TRANSAC j MODULE 2 MODULE JKTM_JUNK_TRN DESCRIPTIO 25 DESCRIPTION JKTM_JUNK_TRI ISWIFTCODE gt me 3 SWIFT_CODE JKTM_JUNK_TRN ACT
18. lder On successful processing of the file the file is renamed based on the processed file mask attribute maintained in the interface definition and moved to the processed folder 4 2 Creation of External system You need to maintain the details of the external system with which Oracle FLEXCUBE is interfacing using External Interface Maintenance screen Function id for invoking the screen is GWDEXSYS e External system maintenance FD04 02 01 Generic Interface Configuration Guide 6 Note Refer GI pdf FLEXCUBE UBS User manual for the meaning of each item in below screen PIYUSH1 000 000 Oracle FLEXCUBE UBS 11 3Dev ENG 2012 03 01 Transaction Input Windows Internet Explorer a amp a GWDEXSYS Menu External System Maintenance Accounting amp MIS Acdactrn_Main_Menu Asset Management Auto Billing Clients Bank Parameters LBL_MSG_EX_PAT Queue Batch Operations Billing Request Message Default Response Queue DB_QUEUE_RESPONSE a Bills and Collection Response Message Full Screen Y Dead Letter Queue MDB_QUEUE_DLQ 2 External System Correlation Pattern Request Messageld Branch Parameters o Register Response Queue i XSD Validation Required Carckret_Main_Menu Message Id Card Maintenance Cams LBL_BLK_GWTM_EXT_SYS_QUEUES Clegrosp_Main_Menu 7 Clearing Codhi_Main_Menu esponse Queue Collections MDB_QUEUE1 j MDB_QUEUE_RESPONS Common Entit
19. nt Group By Specify the group by clause for the component Order By Specify the order by clause for the component Pre Component Specify the value to be calculated before the component is processed if any Pre Component AUDF Specify the AUDF that has to be executed before the component is processed if any You can use this to add any additional functionality required at the component level Specify the value to be calculated after the Component is processed if any Post Component AUDF Specify the AUDF that has to be executed after the component is processed if any You can use this to add any additional functionality required at the component level Pre Record Specify the value that needs to be calculated before the record is processed if any Pre Record AUDF Specify the AUDF that has to be executed before the record is processed if any You can use this to add any additional functionality required at the record level Post Record Specify the value that needs to be calculated after the record is processed if any FD04 02 01 Generic Interface Configuration Guide 15 Post Record AUDF Specify the AUDF that has to be executed after the record is processed if any You can use this to add any additional functionality required at the record level Component Field Linkage You can specify the component field linkage details here i e the data to be fetched in the file Serial Number Specify the order of fields here Field Nam
20. ou select frequency type as Fort Nightly Monthly Weekly Yearly select the month for the interface file execution from the drop down list The options available are January December If you select frequency type as Fort Nightly Monthly Weekly Yearly select the date of the month for the interface file execution from the drop down list Last Run Date The last run date gets displayed here Next Run Date The day on which the interface can be triggered gets displayed here Padding Character You can specify the padding character of fixed length format type interface file here All the data types can have the same padding character Date Select the padding character for date field from the drop down Number Select the padding character for number field from the drop down FD04 02 01 Generic Interface Configuration Guide 20 Text Select the padding character for text field from the drop down Pre Message Specify the value that should be calculated before triggering the interface in the predefined format Specify the value that should be calculated after Interface processing is done in the predefined format Pre Message AUDF Specify the AUDF that needs to be invoked before triggering the interface You can use this to Post Message add additional functionality required at the message level Post Message AUDF Specify the AUDF that needs to be invoked after triggering the interface You can use this to add addit
21. r which data is to be written in the flat file Here the table name is JKTM_JUNK_TRNCODE Start Position Specify the start index of the field in the fixed length format Precision If the field is of numeric type then specify precision here Translation FD04 02 01 Generic Interface Configuration Guide 24 If the field value needs to be translated then select the translation code that has to be used for the translation Un translated Specify the action to be taken if the translation value is not present Derivation Specify the derivation logic for the field Pre Field Specify the value that needs to be calculated before the field value is processed Pre Field AUDF Specify the AUDF that should be executed before the processing of the field here Post Field Specify the value that needs to be calculated after the field value is processed Post Field AUDF Specify the AUDF that should be executed after the processing of the field e Specifying Incoming File Names Click on Incoming File Names button in the Interface Definition screen to specify the incoming interface file names File Names File Names ow File Name FD04 02 01 Generic Interface Configuration Guide 25 File Names The incoming file names are maintained here File Name Specify the incoming interface file name here 4 4Trigger Interface You can trigger the process of Generic Interface using Gateway Messages EOD run or throug
22. rface Type Select the interface type from the following options e Incoming Select this option if the file data needs to be uploaded into Oracle FLEXCUBE e Outgoing Select this option if data from Oracle FLEXCUBE needs to be written into file Here the interface type is Outgoing File Mask Specify the file mask for the outgoing interface file The name with which the file will be generated External System Specify the external system with which Oracle FLEXCUBE is interfacing Here the system is EXTGI the one created earlier Format Type Select the type of data length in the interface from the following options e Fixed Select this option if the file data has to be in fixed width e Delimited Select this option if the file data has to be in delimited format Delimiting Character field gets enabled for you to specify the delimiting character if you select the format type of definition as Delimited FD04 02 01 Generic Interface Configuration Guide 10 File Path Specify the path of the file Example gi outgoing data as mentioned in below picture 34 gi EI incoming confirmation 5 processed 5 ready cre 5 processed 5 ready data error 5 processed 5 ready O wip 5 outgoing confirmation 5 ready O wip cre 5 ready O wip aa Eat C ready O wip In case of GI Outgoing the file writing process takes place in the WIP folder and on successful completion of the writin
23. sed or not and if it is not processed system will not allow movement to the next EOD stage Triggering Select an appropriate option to indicate how the interface should be triggered The options available are e Manual Select this option if the interface has to be triggered manually e System Select this option if the interface has to be triggered automatically During EOD if there are any mandatory unprocessed interfaces and if the triggering type is selected as System then the interface is triggered automatically In case of Incoming interface if triggering type is selected as System then system checks if the file is available in the ready folder for that interface If the file is present the system will process it In case of outgoing interface if triggering type is selected as System then system will automatically trigger the Outgoing interface FD04 02 01 Generic Interface Configuration Guide 19 Here its manual type It can be triggered manually whenever required Frequency Type Select the frequency type for interface file processing from the following drop down options Daily e Weekly e Fort Nightly e Monthly e Quarterly e Yearly e Adhoc Week Day If you select frequency type as Weekly select the day from the drop down list for processing the interface file The options available are e Sunday e Monday e Tuesday e Wednesday e Thursday Friday e Saturday Month If y
24. tton in the Interface Definition screen Y Component Details Component Linkage Relation Where Clause BW Serial Number Component Name ComponentType Parent Batch By Field lt mM Component Field Linkage W serial Number Field Name Field Type Default Data Type Length Column Name o 1 TRANSAC Message Character 3 TRN_CODE ___ JKTM_JUNK_TR P ol 2 MODULE jcccage 2 MODULE JKTM_JUNK_TRN o 3 DESCRIPTIO z R 25 DESCRIPTION JKTM_JUNK_TRN o 4 SWIFTCODE 3 el 3 SWIFT_CODE JKTM_JUNK_TRN_ al 5 ACTION End Ide N acter 1l K i gt bosal atte Component Linkage You can specify the component linkage details here Serial Number Specify the component position here Component Name Specify a name for the component Here the name is BDY Component Type This field indicates the component type of the file following are the possible values of component type e Header e Body e Footer FD04 02 01 Generic Interface Configuration Guide 14 e Batch Header e Batch Footer e Batch Body Here the type is BODY Parent Specify the parent component to which component is linked Relation If parent component is specified then specify the relation here Batch by Field Specify the field in the component based on which you want to create a batch This is applicable only for Outgoing Interfaces Where Clause Specify the where Clause for the component Post Compone
25. vailable are January December If you select frequency type as Fort Nightly Monthly Weekly Yearly select the date of the month for the interface file execution from the drop down list Last Run Date The last run date gets displayed here Next Run Date The day on which the interface can be triggered gets displayed here Padding Character You can specify the padding character of fixed length format type interface file here All the data types can have the same padding character Date Select the padding character for date field from the drop down Number Select the padding character for number field from the drop down Text Select the padding character for text field from the drop down Pre Message Specify the value that should be calculated before triggering the interface in the predefined format Post Message Specify the value that should be calculated after Interface processing is done in the predefined format Pre Message AUDF Specify the AUDF that needs to be invoked before triggering the interface You can use this to add additional functionality required at the message level Post Message AUDF Specify the AUDF that needs to be invoked after triggering the interface You can use this to add additional functionality required at the message level e Specifying Component Details FD04 02 01 Generic Interface Configuration Guide 13 You can specify the component details here Click Component Details bu
26. y Compliance Checks Conversion Core Corporate Deposits Corporate Teller Customer Customer Accounts Customer Accounts Customers E Dedtillp_Main_Menu ES Derivatives Input ByPIYUSH1 Authorized By Modification ES EMP MAINMENU Date Time Date Time Number EOC Operations Exchange Traded Derivatives Expense Processing FRS a Workflow opoopo 88 S8S8S88888088088808S8088o08 E customer My Dash Board Done 9 Local intranet 100 FD04 02 01 Generic Interface Configuration Guide 7 e Specifying File Transfer Protocol FTP Parameters LBL_FTP_PARAMETER xternal System EXTGI LBL_IP_ADDRESS LBL_PORT User Name Password e Viewing External System Details You can view details of external Systems maintained in the system using External System Summary screen You can invoke this screen by typing GWSEXSYS FD04 02 01 Generic Interface Configuration Guide 8 External System Summary Authorization Status Authorized mw Record Status External System EXTGI az Default Response Queue Dead Letter Queue laz EXTGI MDB_QUEUE_RESPONSE MDB_QUEUE_DLQ Authorization Status A Authorized U Unauthorized Record Status C Closed O Open 4 3 Creation of Interface definition 4 3 1 Outgoing Interface You can define the format details and properties associated wit
Download Pdf Manuals
Related Search