Green Book Interface User Manual
Contents
1. directory Maintenance STDEXTBD screen 2 4 ORACLE External Bank Maintenance Bank Code 0000 Bank Description 0000 Bank Code Branch Code Branch Description Status Effective Date 0011 Bank Code1 011 Bank Closed 2011 12 27 Active 2011 12 27 Active gt 2011 12 30 2011 12 30 2011 12 30 Active 2012 02 06 1003 Branch 03 1010 bankcode 2 1020 Bank code 2 1023 Branch 023 View Bank Details Maker U1 Date Time Checker 2014 01 31 14 40 21 Date Time X Mod 10 Record Status Open Authorization Status Unauthorized You can view the additional Branch level details captured as part of Record Type 01 by clicking View Details button on External bank Maintenance screen External Branch Information Branch Name Branch Type T INE Code 280790001 Acquirer Entity 182 Acquisation Date 2011 07 16 BIC Code Postal Address JULIAN CAMARILLO 4 DigitContral 5 Mail Address Telephone Number 0 Fax Number 0 Postal Code 28037 Branch Discharge Date Date Change Type 7 Operative Code MoadificatinniCancellation _ 2 11 7 1 Click View Bank Details button to view the additional bank level details captured part of Record Type 10 2 5 ORACLE External Bank Information NIF Of The Entity Short Name Entity Entity Type 1 Entity Type 2 First Third Entity Name Second Third Entity Name Last Third Entity Name2. formats and components here Branch Code Specify the code of the branch to which the interface belongs 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 For more details refer section Specifying Interface Definition Details in Generic Interface User Manual Attribute Name Attribute Value Interface Type Incoming From System SNCE CENTER OF EXCHANGE or Associated austits To System FCUBS File Name Nomenclature Frequency Fortnightly Character Set ASCII EBCDIC File Header Yes 2 3 ORACLE 2 3 2 3 1 2 4 Attribute Name Attribute Value File Footer Yes Delimiter Record Length Fixed 264 bytes Format Line Sequential Fixed Length Record End of the Record Numeric padding Left padding with Zeros Text padding Right padding with spaces Directory Location To be confirmed Executing Green Book Upload Batch Green Book Upload IBGRNBOk is used to upload the green book data into Oracle FLEXCUBE The batch can be configured as an intraday batch in Oracle FLEXCUBE The uploaded green book details can be viewed from External Bank maintenance STDEXTBD function id This batch handles the following operations e Creation of
3. new record of any types When a record with the respective key doesn t exist a new record will be created e Modification of existing records of any types When a record with the respective key exists the values will be amended e Norecords will be allowed for deletion However the Status of the Branch will identified based on the Branch Status The values present under the detail record branches value E7 would be considered to mark the branch as Active or Inactive e If value of field E7 is B the corresponding branch has to be marked Closed e this field is blank the branch status has to be considered as Active Once the file is uploaded you will be allowed to modify only the Status and Effective Date in External Bank maintenance STDEXTBD screen Handling Exceptions If any exception occurs while uploading the data those exceptions can be viewed in upload monitor CVDUPLMT function id for the source code and upload id starting with If any error occurred while fetching the data from Green Book file to upload table then the file will be considered as rejected and the intraday process will be stopped with the error code and error reason Same can be monitored in the intraday monitor BASIDMTR screen You have to manually verify rectify the data file and reprocess the same file again as intraday batch Viewing Uploaded Details You can view the uploaded details in External Bank
4. Acronym Of Type Of Road Road Name Road Number Rest Of Address Postal Code Town Province Country Code Serv Tasa Code Telephone Prefix Telephone Number A37001815 FINANZIA BANCO DE CREDITO S A BP 30001 FINANZIA BANCO DE CREDITO S A CL JULIAN CAMARILLO 4 28037 MADRID ES 091 3743916 Cancellation Pending 2 6 ORACLE 3 1 3 Screen Glossary 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 BASIDMTR Intraday Monitor CVDUPLMT Upload Monitor GIDIFTDF Interface Definition IBGRNBOK Green Book Upload STDEXTBD External Bank maintenance 3 1 ORACLE Black Listed Customers Data October 2013 Version 11 3 81 02 0 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
5. Green Book Interface Oracle FLEXCUBE Universal Banking Europe Cluster Release 11 3 81 02 0 October 2013 Oracle Part Number E51523 01 ORACLE FINANCIAL SERVICES ORACLE Green Book Interface Table of Contents 2 ABOUTTHIS MANUA 1 1 2 1 OI eee ements 1 1 2 2 sec stirs 1 1 2 3 CONVENTIONS USED IN THIS 1 1 Be GREEN BOOK INTERFACE 2 2 3 1 INTRODUCTION 2 2 3 4 MAINTAINING INTERFACE DEFINITION DETAILS cccceccececcececcsceccececcececcecscccscesescecesceceececescecesesctsesees 2 2 3 3 EXECUTING GREEN BOOK UPLOAD BATCH Q cccecceceecececcecccsceccscuccececeecsceecscuscscusescscescsseececescscucescesesces 2 4 3 3 1 Hond nPE NCOP ON Ter ttt Terre weet 2 4 3 4 VIEWING UPLOADED DETAILS sesccccssnsocestaniwcgacmssacecbaedondenonseesataniwsgacmadaceabieioudenonseseabandusdarmsdadaabieiendenonsessatonss 2 4 SCREEN GLOSSARY orseevecececceseccc cen Seececescacccccdensevesbecasesveeusecsasecsecestaccausssectecceiceceecsbestaceseenteusssenansebcarseanseeceee 3 1 4 1 J LI 3 1 1 1 ORACLE 1 A
6. bout this Manual 1 1 Introduction This manual is designed to help you quickly get acquainted with interface between Oracle FLEXCUBE and an external system 1 2 Audience This manual is intended for the following User User Roles Back office 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 Managers Generation of reports 13 Conventions Used in this Manual Important information is preceded with the symbol ORACLE 2 1 2 2 2 Green Book Interface Introduction To correctly identify the banks savings banks rural banks and Credit Unions and their branches in Spain and the smooth operations of interbank clearing systems The list of Entities banks Green Book is published and maintained by Center of Exchange Sociedad Espanola de Sistemas de under the supervision of Bank of Spain This list contains information on the Banks Branches and Location of branches which are active SNCE sends this list every fortnight to its direct clearing participants to update their systems Indirect participants would receive the fortnight update information on bank list from their representing banks direct participants Oracle FLEXCUBE needs to maintain and update the local bank and branch information as and
7. the Application tool bar and clicking the adjoining arrow button 2 2 ORACLE Interface Definition Branch Code External System az FormatType Fixed v File Path Interface Code Delimiting Character C Confirmation File Required Interface Type Incoming File Mask CRC Required CRC Algorithm laz CRC File Mask C Data Log Required CommitFetch Frequency When Run C Mandatory CRC File Path Justification Date Number Text Frequency Type Week Day Month Date Date Format YYYYMMDD No Of Executions Day Padding Character Date Number Text Pre Message Post Message Pre Message AUDF Post Message AUDF C Duplication File Check Reqd For Current Date Trigger Type Confirmation File Mask Confirmation File Path Incoming Function Id Processed File Mask Default Action New On Override Outgoing Interface Incoming File Mask C Suppress Start Log Output Last Run Date Next Run Date Parallel process Parallel Process Required Parallel process i No Of Records No Of Parallel Process Component Details Incoming File Names Input By Date Time Authorized By Modification Authorized Date Time Number Open You can define the following interface file properties
8. 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 dangerous applications including applications that may create a risk of personal injury you use this software or hardware in dangerous applications then you shall be responsible 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 displa
9. when it receives the update file and while creating a clearing transaction always needs to consult with this latest updated list Fortnightly banks receive this file with all information This file is received trough EDltran from Center of exchange if is a direct participant If it is an indirect participant direct participant send the file trough Every fortnight bank receives this file with contents in the following way e Latest full list of Spanish banks details e Latest full list of Spanish bank location details e Only the details of changes happened to the list of bank branches in Spain Meaning list of new branches opened and list of existing branches closed Once the fortnightly interface file is received Oracle FLEXCUBE needs to update its local bank branch repository accordingly No outbound file exchange is applicable as part of this interface The file contains information related to e Branch details of local Spanish Banks e Spanish Bank Details e Details on Bank locations The following maintenances have to be done for the interface to work e Maintaining Interface Definition Details Maintaining Interface Definition Details You can define the format details and properties associated with interface file in the Interface Definition screen For both Incoming and Outgoing files the file structure is defined here You can invoke this screen by typing GIDIFTDF in the field at the top right corner of
10. y 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 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
Download Pdf Manuals
Related Search