Generic Interface User Manual
Contents
1. Records per page 15 v First Previous 4 or 4 LNext Last Record Status Customer Name Description Authoriza Record St You can click Search button to view all the object definition records of your bank However you can to filter your search based on any of the following criteria Authorization Status Select the authorization status of the object defined from the dropdown list The options are e Authorized e Unauthorized Name Select the name of the object maintained from the option list Order by Clause Select the order by clause maintained for the object from the option list Having Clause Select the having clause maintained for the object from the option list Record Status Select the record status of the object from the drop down list The options are e C Closed record e O Open record 5 ORACLE 2 3 1 1 Description Select the description maintained for the object from the option list Group by Clause Select the group by clause maintained for the object from the option list Where Clause Select the where clause maintained for the object from the option list When you click Search button the records matching the specified search criteria are displayed For each record fetched by the system based on your query criteria the following details are displayed e Authorization Status e Record Status e Name e Description Search Functionalities The search functions availab2. Component Details button in the Interface Definition screen Component Details Component Linkage Serial Number Component Name ComponentType Parent Relation Batch By Field Where Claus il Header vi S 4 m Component Field Linkage Serial Number Field Name Field Type Default Data Type Length Column Name Object Name fia Message v 1 Character e D T The following details are captured here 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 Component Type Select the type of component from the options available in the drop down list The options available are e Header e Body e Footer e Batch Header e Batch Footer e Batch Body If header and footer are defined in component details section and opted for suppressing start reference then system consider the first line as header and bottom most line as the footer and continues the execution 216 ORACLE 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 Interf
3. Open You can maintain the following parameters for generic interface here Holiday Treatment You can specify the parameters for interface processing if the schedule date falls on a holiday Holiday Treatment Check this box to indicate your preference for interface processing on a holiday Next Run Date Specify how the system should process if the schedule date falls on a holiday You can select the options as either move the interface processing to previous working date or next working date if the interface processing day falls on a holiday Note The default holiday treatment is movement to next working date a ORACLE Purging Days Specify the purging days if you want to maintain any days to be purged while processing interface Incoming You can specify the parameters for interface processing for the incoming files Uploaded Record Status Select the input status of the transaction record after upload as e Authorized e Unauthorized Note By default Authorized option is selected Bad File Path Specify the path where the external tables should write the bad records while reading from the Incoming file Log file Path Specify the path where the external tables should write the Log file while reading from the Incoming file Outgoing You can specify the parameters for interface processing for the outgoing files Archival Reguired Check this box to specify if the upload table data and
4. Select Record Based option if the incoming file for upload consists of fields of only body type During file processing stage system would check whether parallel process is required or not If required based on the parallel process parameter system would internally update the process number field of master upload table The parallel process parameter is restricted to 3 as per GI MAX PARALLEL THREADS parameter in the table cstb_ param This restriction is needed and the parameter can be configured based on the system load as analysed by the DBA During data processing stage system checks maximum number of processes and submits the job for each process number System waits till all the processes are completed The D process happens as the job runs and the file log is updated This data processing is done based on the process number updated during file processing The files under process are subsequently moved to the Processed folder irrespective of whether the jobs are done or not The system does not wait until all the processes are completed If any process is resulted in error then the interface would be considered as error Maintaining CRC Algorithm Details Generic Interface supports CRC 32 and Adler 32 Checksum algorithms for generating CRC value of the file Other CRC components which are developed in Java and PL SQL are also supported by GI using the CRC Maintenance screen ORACLE You can invoke th
5. Advanced to specify queries with logical operators such as AND OR and NOT Reset Click Reset to empty the values in the criteria fields so that you may begin a new search Query After specifying your search criteria click Query to view the list of results which match your search criteria Refresh Click Refresh to refresh the list of results You can use Run Chart Summary to list the interfaces that should be processed in the branch on current branch date You can invoke this screen by typing GISRNCHT in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Records per page 15 v First Previous 1 Of 1 Next Last o Advanced Search f Reset Branch Code Interface Code az External System laz Interface Type External System Interface Code Interface Type Mandatory Processed You can click Search button to view the list the interfaces that should be processed on the current date However you can to filter your search based on any of the following criteria Branch Code Select the branch code of the branch for which you want to view the run chart from the option list External System Select the name of the external system to which the interface code is linked from the option list 233 ORACLE Interface Code Select the name of interface code which has to be processed
6. Refresh Click Refresh to refresh the list of results 2 5 Generating Dynamic Interface Component While saving the Interface Definition details a dynamic package is created in the database along with external tables for each component in case of incoming file 2 5 1 Processing Outgoing Interface The steps involved in Outgoing interface file processing is explained below e When a Outgoing Interface Definition is saved a dynamic package is created in the Database The outgoing package consists of fn_handoff fn_process_components functions and function per component as defined in the Outgoing Interface definition e Function fn_handoff is the triggering point for the Outgoing process which internally call the function fn process components after the completion of initiation and message level processing e Except the child component functions independent component functions are invoked by the fn_process_components function in the order on the Component Definition e Child component functions are internally invoked by the corresponding parent component function with required parameters based on the relationship between them e Each function call gets appended with its result in the Clob which is at package level This Clob is the result of the Outgoing process which is written into a flat file for Outgoing in the relevant folder e Update the last and next run date of the interface If data logging is required then the syste
7. displayed here Next Run Date The day on which the interface can be triggered gets displayed here ale ORACLE 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 Specify the padding character for date field Number Specify the padding character for number field Text Specify the padding character for text field Note All the data types can have the same padding character 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 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 Incoming File Mask Specify the file mask for selecting the incoming files from the file directory System supports four types of file masking e Date and Time mask YYYYM
8. file log data should be archived at the time of EOD or before deleting the same File writing process Select the tool to write the data into output file from the following options e Oracle This component uses ORACLE UTIL packages to write the data into output file e Java This component uses java libraries ages to write the data into output file Note By default Oracle option is selected You need to note the following details while selecting the tool for file writing e This feature is applicable only for the outgoing process e Low volume sites are recommended to use Oracle tool only in case of high volume Java tool is recommended e If Java tool is selected then the necessary Java software component should be installed in the database server and jvm is enabled in database ee ORACLE 2 3 Defining Gl Object You can prepare complex queries to use them in the outgoing interface definition for data extraction Object Definition screen can be used to create queries which can be invoked from the Application Browser You can invoke this screen by typing GIDOBDEF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Object Definition Fi New 65 Enter Query A Customer Name Description Static Static Query S Object Mapping Object Name Alias Name laz 4 Object Field Map
9. file permissions This cor responds to an entry in ALL DIRECTORIES table with directory name as IN WIP and directory path as filepath wip where the file path is the path maintained in Interface Defi nition screen GIDIFTDF 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 2 6 2 Viewing Scheduled Upload Logs For scheduling uploads you need to set the parameter IS UPLOAD SCHEDULED to Y in CSTB_PARAM table You can schedule the uploads by creating a job in Job Maintenance with the class name com ofss scheduler guartz FCGiUploadOrtz The block of code for input into the scheduler polling table should be present in the relevant source code To invoke Scheduled Upload Logs screen type GISSULOG in the field at the top right corner of the application toolbar and click the adjoining arrow button Scheduled Uploads Log E gt search C Advanced Search Reset Y Clear All Case Sensitive User ID az Branch Code az Function laz Status az Records per page 15 v 10f1 Scheduled Reference User ID Branch Code Module Code Upload Code Function Status You can search for the fields based on one or more of the follo
10. from the option list Interface Type Select the type of interface from the option list as incoming or outgoing When you click Search button the records matching the specified search criteria are displayed For each record fetched by the system based on your query criteria the following details are displayed Branch Code External System Interface Code Interface Type Stage Mandatory Processed 2 5 14 1 Search Functionalities The search functions available are Advanced Click Advanced to specify queries with logical operators such as AND OR and NOT Reset Click Reset to empty the values in the criteria fields so that you may begin a new search Query After specifying your search criteria click Query to view the list of results which match your search criteria Refresh Click Refresh to refresh the list of results i ORACLE 2 6 Invoking Gl Process You can trigger the process of Generic Interface using Gateway Messages EOD run or through Interface Trigger screen You can invoke this screen by typing GIDIFPRS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 4 Interface Trigger X e Execute Query Branch Code 000 File Pick Up Interface Code IFDCCBUPL 3 Pickup allfiles in the interface folder External System EXTSYS Specific File to be picked up Interface Type FileName IFDCCBUPLb t azi Physical F
11. log files of the files that are transferred using the FTP File Log screen You can invoke this screen by typing GISFTPLG in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Ct Advanced Search Reset Transfer Name laz File Name User ld wl Transferred On Status laz Records per page 15 v First Previous 4 0f 1 Next Last 50 File Name Transferred On You can click Search button to view all the FTP file log records of your bank However you can to filter your search based on any of the following criteria Transfer Name Select the transfer maintenance name used to transfer the file from the option list User Id Select the user id used for transferring the file from the option list Status Select the status of file transfer process from the option list File Name Select the name of the file which is transferred from the option list Transferred On Select the timestamp at which the file is transferred from the adjoining calendar When you click Search button the records matching the specified search criteria are displayed For each record fetched by the system based on your guery criteria the following details are displayed 232 ORACLE 2 5 13 1 Search Functionalities Transfer Name File Name User Id Transferred on Status The search functions available are 2 5 14 Viewing Interface Run chart Advanced Click
12. to the server for incoming interface processing Click File Upload button on the Interface Trigger screen The system displays the following screen File Upload x Browse Click Browse button to select the file from your local machine Once the file is selected click Upload button to start the file upload The system allows you to upload the file only if the extension of the file is txt and the content is plain text If these conditions are not met the system will display an error message On successful upload the system will display a confirmation message The file is uploaded to the DB server with the branch user ID prefixed to its name If the upload is successful the system will display the file name in the filed Physical File Name of Interface Trigger screen Click Process button to process the file Note You can move the incoming file to the DB server Read folder manually or through file up load feature Before starting the file upload ensure that you have sufficient access permissions grants to move and copy the files in the following folders inside file path specified while defining the interface ready wip file processed processed 236 ORACLE error Ensure that you have sufficient access permissions to the location mentioned for CRC and confirmation Ensure that the Oracle directory IN WIP is created with java io
13. typing GISAUDFM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Ct Advanced Search 4 Reset Authorization Status Record Status AUDF Name az Description Records per page 15 y First Previous 4 or 4 Next Last Authorization Status Record Status AUDF Name Description Authoriza Record St You can click Search button to view all the AUDF records of your bank However you can to filter your search based on any of the following criteria Authorization Status Select the authorization status of the AUDF you want to view the details from the drop down list The options are e Authorized e Unauthorized Record Status Select the record status of the AUDF from the drop down list The options are e C Closed e O Open AUDF Name Select the name of the AUDF from the option list Description Select the description of the AUDF from the option list When you click Search button the records matching the specified search criteria are displayed For each record fetched by the system based on your query criteria the following details are displayed e Authorization Status e Record Status e AUDF Name e Description S ORACLE 2 4 Specifying Interface Definition Details You can define the format details and properties associated with interface file in the Interface Definition screen You can invoke this scree
14. File Name Indicates File Name Status Indicates Status Field 1 Indicates Field 1 Field 2 Indicates Field 2 Field 3 Indicates Field 3 Field 4 Indicates Field 4 Field 5 Indicates Field 5 Error Indicates Error Error Parameter Indicates Error Parameter ORACLE 3 3 3 3 1 Customer Tax Payment Information The Customer Tax Payment Information report provides the details of tax paid by the customers To invoke the screen type IFRTXPM in the field at the top right corner of the application toolbar and click the adjoining arrow button Customer Tax Payment Information Branch Code Account No Assessment Year Period From Date To Date Report Format Printer At Client Report Output Printer Specify the following details Branch Code You can generate this report for customers in a specific branch of the bank Select the branch code from the option list Account Number Specify the account number if you wish to get the details of tax payment made from a specific account Assessment Year Specify the assessment year The system will generate the tax payment details for the assessment year specified Contents of the Report The parameters specified while generating the report are printed at the beginning of the report Other content displayed in the report is as follows Header The header displays the title of the report branch branch date and the user ID of the user who ge
15. Generic Interface User Guide Oracle FLEXCUBE Universal Banking Release 12 0 87 1 0 November 2015 ORACLE Generic Interface User Guide November 2015 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 O 2007 2015 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 Acguisition 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 applicatio
16. Log Success folder and update the primary key elements e If the value of Log Output is Both then system creates both error file and data file in log folder During the interface configuration log failure and log success folders are created in the interface configured folder Parallel Processes You can specify the parallel process details here Parallel Process Reguired Check this box to indicate if parallel processing is required if multiple interface files has to be processed at a given time When you select parallel process required parallel process type field gets enabled Parallel Process Select the type of parallel process you want to keep for the interface processing e Record Based Select this option if you want parallel processing to be based on the number of records you maintained e Process Based Select this option if you want parallel processing to be based on the number of parallel processes that you maintained No of Records Specify the number of records of parallel process can be performed at a given time This field gets enabled only if you select the parallel process type as Record based No of Parallel Process Specify the number of parallel process can be performed at a given time This field gets enabled only if you select the parallel process type as Process based 25 ORACLE 2 4 1 Specifying Component Details You can specify the component details here Click
17. MDDHHMISS year month date hours minutes and second e Sequence number based mask NNN 3 digit numeric numbers e Start With File Name File names starting with a specific signature Upload all files which are starting with incoming File name e Exact File Name File Names which are exact match with the file name in interface definition e ALL Allfiles that are present in the directory will be picked up without validating the file names anig ORACLE System searches all the files which are matching the mask criteria and process the files one by one _ as the split separator for the file name and the mask criteria Note System will continue or break the uploading of records based on the error handling defined in the On Override field If it is Continue then the system will ignore the current record and continue with the next record If it is Reject then the system will stop the execution of the file and start executing the next available incoming file Note By default system append the Incoming File Mask type to the file name while searching the physical file name If an interface supports for multiple type incoming files then same file mask is applicable for all type of incoming files 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 uplo
18. You can define the following interface file properties 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 File Mask Specify the file mask for the outgoing interface file CRC Required Check this box if you want to check the CRC while transferring the data In case of incoming interface system checks for the CRC value in the file name maintained in CRC file mask For outgoing interface system generates the CRC value in a CRC file CRC File Algorithm Specify the CRC algorithm which has to be used to calculate the CRC Value CRC File Mask The path of CRC File mask gets displayed here 2 ORACLE CRC File Path The path of CRC File gets displayed here External System Specify the external system with which Oracle FLEXCUBE is interfacing 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 Deli
19. aces 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 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 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 reguired at the record level Component Field Linkage You can specify the component field linkage details here Serial Number Specify the order of fields here ST ORACLE F
20. ad table from the drop down list below o New e Modify e Close 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 Suppress Start Reference Check this box to indicate that the start reference number should be suppressed If the checkbox is selected and start reference element is defined in the component definition system raises an error message while saving the interface System validates the start reference check for Header Body and Footer For a given interface mask and suppress start reference are applicable to all the file names configured for that interface Log Output Select the type of details to be updated in the log file from the adjoining drop down list This list displays the following values e Error e Success e Both While processing the interface file system verifies the log output value and the below details as ORACLE e Ifthe value of Log Output is Error then system creates an error file lt INTERFACE_NAME gt _ FILENAME gt _ERR_ lt ProcessRefNo gt dat in Log_Failure folder and update the primary key elements and the corresponding error details error code and message e Ifthe value of Log Output is Success then system creates a data file lt INTERFACE NAME gt FILENAME gt SUC lt ProcessRefNo gt dat in
21. ally e System Select this option if the interface has to be triggered automatically 210 ORACLE 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 Note If the interface is mandatory the triggering type must be system However even if the trig gering type is mentioned as System you can manually trigger the interface whenever re quired through Interface triggering screen Conformation File Required Check this box to indicate if confirmation is required for an incoming file If this box is checked then when incoming file is processed system checks whether confirmation file is available in the folder specified If the file is not available then incoming file processes will raise an error indicating the confirmation file is not available Conformation File Path The path of confirmation file gets displayed here Conformation File Mask The path of confirmation file mask gets displayed here Justification You can specify the justification details of fixed format type
22. anch code Interface Code Process Reference Number File Name Started Time Ended Time Status 2 40 ORACLE 2 8 2 8 1 2 8 2 2 9 2 9 1 Following field mapping details are also displayed e Key1 e Key2 o Key3 e Key4 e Key5 e Error Code e Error Description Integrating Gl with EOD During the EOD batch run GI EOD process also gets invoked at every stage GI EOD process would in turn check whether all the required interfaces are processed at that stage or not System executes the following Gl processes as part of EOD operation e Processing unprocessed interface e Gl Batch Processing Unprocessed Interface GI EOD process checks if all the required interfaces are process at that stage If any interface is not processed system process these interface and if it s a mandatory interface system would wait till it processed Note If any mandatory interface is not processed before the respective stage then system would raise an error Processing Gl Batch Based on the interface frequency information and Gl Batch would publish the Run Chart for the present day run Also it archives the interface data Gl Batch runs after Mark TI Global Variables and mask Attributes The global variables and mask attributes used in the generic interface are explained here Global variables The global variables used in the generic interface are explained below e OBRANCH defaults the value to Curr
23. be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Contents Preface id aa 1 1 A AN 1 1 12 PAUGION CO iio itiaa 1 1 1 3 Documentation AccesSibilitY oooonmncicinnnnicccnnnnoncccnnnnonncnncnnnannnnr cnn rn rrnnnn rr 1 1 VAS Organization aair at al 1 1 4 5 Abbreviations USA occiso ARA ias 1 2 1 65 Glossary Of ICONS iea E eerie ae oa mn latin 1 2 1 7 Related DOCUMENT a a 1 2 Generic Interface sor oe eee ee ees 2 1 ZN IOTOAUCTION im ti iaa 2 1 2 2 Maintaining Gl Parameter rare ea EEEE AR 2 1 2 3 Defining OLOBO escrita damn its 2 3 2 3 1 Viewing Summary Details of Object ooooooocincininiciciniccoccnnccccnannncnnnnnannnnnnnnnn 2 5 2 3 2 Maintaining AUDF ASCII User Defined Function DetalilS 2 7 2 3 3 Viewing AUDF Summary DetailS uuuuusssssss ooe aka eee aaeeeen 2 8 2 4 Specifying Interface Definition Details uuuuussssssss nn n nananana naene 2 9 2 4 1 Specifying Component Details cvuuuuuussssaa aak n a aa nannaa 2 16 2 4 2 Specifying Incoming File Names ccccuuossssaaaa aak kaa akekee annet 2 19 2 4 3 Viewing Interface Definition SUMMAaTy cccosoosssssaa kaakkia aaeeeen 2 20 2 5 Generating Dynamic Interface Component usousussssssee enn enaa aan annan aa aaneeen 2 21 2 5 1 Processing Outgoing Interface cccccocoosssuusss akkaa aa enaa aeeeeen 2 21 2 5 2 Pro
24. can filter the report based on below details Interface Code Select the interface code of the upload file from the options maintained Branch Code Select the branch code for file upload from the options maintained File Name Select the file name from the options maintained Upload File Name Select the name of the file for upload from the options maintained Process Reference Number Select the process reference number of the upload file from the options maintained Status Select the status from the options maintained i ORACLE 3 2 1 Start Date Specify the start date of the report date range End Date Specify the end date of the report date range Contents of the Report The parameters specified while generating the report are printed at the beginning of the report Other content displayed in the report is as follows Header The header displays the title of the report branch branch date and the user ID of the user who generated the report Body of the report Field Name Field Description Primary Key 1 Indicates Primary Key 1 Primary Key 2 Indicates Primary Key 2 Primary Key 3 Indicates Primary Key 3 Primary Key 4 Indicates Primary Key 4 Primary Key 5 Indicates Primary Key 5 Physical File Name Indicates Physical File Name Interface Code Indicates Interface Code Process Ref No Indicates Process Ref No
25. cessing INCOMING Interface cccscsuusssssuuas aka n nc cr nana 2 21 2 5 3 Processing File Transfer to Upload Tables ccccosusssssssuusa saitit 2 22 2 5 4 Processing Data Process from Upload Table to Base Table 2 22 2 5 5 Parallel Processing of Generic Interface ccccssssmmmsssuuan naene 2 23 2 5 6 Maintaining CRC Algorithm Details csuusssssssaa aikaa nana 2 23 2 5 7 Viewing CRC Summary DetallS ccuuuuussssusn saa kaka a e aak ease 2 25 2 5 8 Maintaining File Transferring Details ccuuuussssuuuas ainakaan 2 26 2 5 9 Viewing File Transfer SUMMary ccccoooesssssuaa ean n kaa aa rc 2 27 2 5 10 Triggering File Transfer serieren aa k aa aa kaa Oa a 2 29 2 5 11 Maintaining Translation Details cccuuussussss saa akat aaeen 2 29 2 5 12 Viewing Translation Summary DetailS cuuuuusssusss aan 2 31 2 5 13 Viewing FTP Log Files ccoo 2 32 2 5 14 Viewing Interface Run cha ooooonicccccnnonacccinnnnannccncn nan ccc nn narran rn 2 33 2 07 Invokina GIProcesss ssmetinasa N AAE Benenden canes eh AERA 2 35 2 6 1 Uploading a File for Incoming Interface Processing uuuosssusnnnieeee 2 36 2 6 2 Viewing Scheduled Upload LOY9S cooooooccccconnocicccnnoconncccccanannnccccnnannccncnannn 2 37 2 6 3 Archiving POCOSS ccccccccecceeeetnneeee eee ASE anna 2 38 NN ES AAA a asa a ana Aei TK SIS L KN TK ARANEA REE ASAA 2 38 2 7 Tracking the Status of Interface Proce
26. cord is read from the external table a Record Identifier is generated for that record and it is assigned to the children when inserted into the upload table which helps in identifying the corresponding children for that parent record in D Process If a relation is mentioned in the component definition and the relation fields are provide in the file then the corresponding fields are used for identifying the child records Which one to use will be determined by the dynamic package generator based on the Interface Maintenance parameters The files taken for processing at the time of processing is decided by the incoming file mask selected for the particular interface For example in Interface Definition BIS if the incoming file name is defined as CCYUPLOAD TXT and incoming file mask is defined as YY Y YMMDDHHMISS then system will search and process the file names like CCYUPLOAD_20100110201000 TXT CCYUPLOAD_20100110202001 TXT If the incoming file mask is defined as nnn then system will search and process the file names like CCYUPLOAD 001 CCYUPLOAD_002 If the incoming file mask is defined as Starting with File Name system will search and process all the files which are starting with Incoming File name like CCYUPLOAD 20100110200010 TXT CCYUPLOAD 201001102020 TXT CCYUPLOAD 001 CCYUPLOAD 002 Processing Data Process from Upload Table to Base Table You can trigger data process by invoking the fn upload func
27. criteria Authorization Status Select the authorization status of the Interface definition you want to view the details from the drop down list The options are e Authorized e Unauthorized Branch code Select the branch code belonged to the interface details from the option list Interface code Select the interface code belonged to the interface details from the option list Record Status Select the record status of the interface details from the drop down list The options are e C Closed e O Open External System Select the name of the external system belonged to the interface details from the option list Interface Type Select the type of interface from the option list as incoming or outgoing 220 ORACLE When you click Search button the records matching the specified search criteria are displayed For each record fetched by the system based on your query criteria the following details are displayed e Authorization Status e Record Status e Branch Code e External System e Interface Code e Interface Type 2 4 3 1 Search Functionalities The search functions available are e Advanced Click Advanced to specify queries with logical operators such as AND OR and NOT e Reset Click Reset to empty the values in the criteria fields so that you may begin a new search o Query After specifying your search criteria click Query to view the list of results which match your search criteria e
28. down list The options are e Authorized e Unauthorized CRC Name Select the name of the CRC algorithm from the option list Record Status Select the record status of the CRC algorithm from the drop down list The options are e C Closed e O Open Description Select the description of the CRC algorithm from the option list When you click Search button the records matching the specified search criteria are displayed For each record fetched by the system based on your query criteria the following details are displayed e Authorization Status e Record Status e CRC Name e Description eee ORACLE 2 5 7 1 Search Functionalities The search functions available are e Advanced Click Advanced to specify queries with logical operators such as AND OR and NOT e Reset Click Reset to empty the values in the criteria fields so that you may begin a new search e Query After specifying your search criteria click Query to view the list of results which match your search criteria e Refresh Click Refresh to refresh the list of results 2 5 8 Maintaining File Transferring Details Though Generic Interface doesn t support file transfer file transfer components available as independent component can be used for transferring files You can maintain the file transfer details in External System Maintenance screen and other details in File Transfer Definition You can invoke this screen by typ
29. e 15 First Previous 4 of 4 LNext Last Authorization Status Record Status Table Name Authoriza Record St You can click Search button to view all the translation records of your bank However you can to filter your search based on any of the following criteria Authorization Status Select the authorization status of the translation you want to view the details from the drop down list The options are e Authorized e Unauthorized Record Status Select the record status of the translation from the drop down list The options are e C Closed e O Open Translation Name Select the name of the translation from the option list When you click Search button the records matching the specified search criteria are displayed For each record fetched by the system based on your query criteria the following details are displayed e Authorization Status e Record Status e Translation Name Search Functionalities The search functions available are Aal ORACLE e Advanced Click Advanced to specify queries with logical operators such as AND OR and NOT e Reset Click Reset to empty the values in the criteria fields so that you may begin a new search e Query After specifying your search criteria click Query to view the list of results which match your search criteria e Refresh Click Refresh to refresh the list of results 2 5 13 Viewing FTP Log Files You can view the
30. ent Branch of the User e OBRANCHDATE defaults the value to branch date e OLCY defaults the value local currency of the branch e OAPPDATE defaults the value application date e LENGTH defaults the value length of the value of this field e LENGTH COMPONENT_NAME FIELD NAMEJ defaults the length of the mentioned field and assigns to this field e SUM COMPONENT_NAME FIELD_NAME defaults the sum of the field mentioned ORACLE 2 9 2 Mask Attributes RECNUM defaults the number of rows of the mentioned component The mask attributes used in the generic interface are explained below D M Y H I S Date Month Year Hour Minute Second will indicate the following character is a Constant 242 ORACLE 3 1 3 2 3 Reports Introduction This chapter provides the details of various reports that you can generate from Generic Interface module of Oracle FLEXCUBE File Process Report You can view a standard online report for the upload exception details of the interface in the File Process Report screen You can invoke this screen by typing GIRFILOG in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button File Process Report Interface Code Status Branch Code Start Date File Name End Date Upload File Name Process Reference Number Report Format f v Printer At Client Report Output Printer You
31. essed D ready data 5 error 5 file processed log failure 5 log success 2 processed D ready wip 4 outgoing SB confirmation D ready O wip EE cre D ready O wip 2 1 data D ready OB wip 2338 ORACLE 2 7 Tracking the Status of Interface Processing You can track the status of interface processing using the File Log screen You can invoke this screen by typing GISFILOG in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button CE Advanced Search 4 Reset Branch Code Interface Code File Name Process Reference Number External System Status Process Code Upload File Name Records per page 45 v 10f1 A Branch Code External System Interface Code Status File Name UserID Process Code Process Reference You can click Search button to view all the interface transaction records of your bank However you can to filter your search based on any of the following criteria Branch code Select the branch code of the interface file you want to track from the option list Interface Code Select the interface code of the interface file you want to track from the option list Date of Processing Select the date of the interface file transaction you want to track from the option list External System Select the external system name with which the interface files transaction you want to track from the opt
32. h button the records matching the specified search criteria are displayed For each record fetched by the system based on your query criteria the following details are displayed e Authorization Status e Record Status e File Transfer Name e External System o File Name Search Functionalities The search functions available are e Advanced Click Advanced to specify queries with logical operators such as AND OR and NOT e Reset Click Reset to empty the values in the criteria fields so that you may begin a new search e Query After specifying your search criteria click Query to view the list of results which match your search criteria e Refresh Click Refresh to refresh the list of results 25 ORACLE 2 5 10 Triggering File Transfer You can use File Transfer to trigger the file transfer You can invoke this screen by typing GIDFTPTF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button File Transfer Ey New E3 Enter Query Transfer Name Transfer Type Location You can specify the file details to transfer the same Transfer Name Select the name of the file which has to be transferred By default Transfer Type and Location gets displayed Click Transfer button to transfer the selected file 2 5 11 Maintaining Translation Details You can maintain translation details required between the external sys
33. ield Name Specify the field name here Field Type Select the type of field from the options available in the drop down list The options available are e Message o 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 Object Name Specify the object name from which the field should be derived 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 Un translated Specify the action to be taken if the translation value is not present 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 Primary Key Check this box to indicate the primary key to identify the individual record in the incoming file 248 ORACLE Note System allows a maximum of 5 element
34. ile Name IFDCCBUPL bd File Mask YMD Status U Process Code File Processing v Process 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 Based on the selected interface code system defaults external system and interface type 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 e 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 process for error records Physical File Name A physical file name is applicable if you are processing a file that is uploaded through the Interface Trigger screen When the file upload is successful the system will display the name of the file in this field ORACLE 2 6 1 File Mask The system displays the incoming file mask specified during interface definition Uploading a File for Incoming Interface Processing From the Interface Trigger screen you can upload a file from your machine
35. in case of Mainframes Viewing File Transfer Summary You can view the details of file transferred in the system using File Transfer Summary screen You can invoke this screen by typing GISFTPDF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Ct Advanced Search 4 Reset Authorization Status 7 Record Status FTP Name 23 External System File Name az Records per page 15 v First Previous l4 Of 4 Next Last Authorization Status Record Status FTP Name External System File Name Authorizai Record St You can click Search button to view all the file transaction records of your bank However you can to filter your search based on any of the following criteria Authorization Status Select the authorization status of the file transaction you want to view the details from the drop down list The options are e Authorized e Unauthorized ET ORACLE 2 5 9 1 File Transfer Name Select the name of file transfer used for file transaction from the option list File Name Select the name of the file used for file transaction from the option list Record Status Select the record status of the file transaction from the drop down list The options are e C Closed e O Open External System Select the name of the external system belonged to the file transaction from the option list When you click Searc
36. ing GIDF TPDF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button File Transfer Definition E New Enter Query FTP Name Protocol HTTP Description Mode Type External System File Name Local Path Remote Path Input By Authorized By Modification Date Time Date Time Number W Authorized Open You can maintain file following transfer details here File Transfer Name Specify a name for the File Transfer here Description Specify a description for the FTP name given here Mode Select the mode of transaction of the file from the drop down list The options are e Push Selectthis option if you are transferring the file from your system to another one e Pull Select this option if you are transferring the file from another system to yours 226 ORACLE 2 5 9 External System Select the external system name whose credentials are used to do the FTP transfer File Name Specify the file which has to be transferred Local Path Specify the path from where the file has to be taken for transferring Remote Path Specify the path in the external system to where the file has to be transferred Protocol Select the protocol to be used for file transfer from the drop down list They are e FTP File Transfer Protocol e HTTP Hypertext Transfer Protocol MIME From Client to Application Server e Connect Direct Only
37. ing You can map the fields of the database object selected here Field Name Select the column which can be used from the database object Alias The alias of the column name in the select query that is generated which by default the column name itself However you can edit it Data Type The data type of the field gets displayed here Data Length The data length of the field gets displayed here Where Clause Specify the where clause for the resultant dynamic query here You can define the join conditions of multiple tables along with the filter condition of the query Group By Specify the group by clause for the resultant dynamic query here Order By Specify the order by clause for the resultant dynamic query here E ORACLE 2 3 1 Having Clause Specify the having clause for the resultant dynamic query here Query Specify the indexes which can be used for the query This index gets used for the query Viewing Summary Details of Object You can view the details of objectives maintained in the system through Object Summary screen You can invoke this screen by typing GISOBDEPF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button CE Advanced Search 4 Reset Authorization Status Record Status Customer Name laz Description Order By laz Group By Having Fal Where N N vau jano aan
38. interface file here Date Select the justification type for date field from the drop down list The options are e Right o Left Number Select the justification type for number field from the drop down list The options are e Right o Left Text Select the justification type for text field from the drop down list The options are e Right o Left Note Default justification type for text and date field type is Left and number field type is right Freguency Type Select the freguency type for interface file processing from the following drop down options e Daily e Weekly EM ORACLE Fort Nightly Monthly Quarterly Yearly Adhoc Note If Adhoc is specified it will override any existing restrictions 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 Sunday Monday Tuesday Wednesday Thursday Friday Saturday Month If you select frequency type as Quarterly Half Yearly and Yearly select the month for the interface file execution from the drop down list The options available are Date January February March April May June July August September October November December If you select frequency type as Monthly Quarterly Half Yearly and 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
39. ion list Status Select the status of the interface file transaction you want to track from the option list Process code Select the process code of the interface file you want to track from the option list When you click Search button the records matching the specified search criteria are displayed For each record fetched by the system based on your query criteria the following details are displayed e Branch Code e External System e Interface code o Status e Date of Processing aoe ORACLE 2 7 1 File Name User ID Process Code Last Maker Date Stamp Records Processed Records Errored Error Code Error Param Upload file name Viewing Error Details of Individual Record You can view the individual record error details of the uploaded file in the View Error Details GIDFILOG screen From the summary screen GISFILOG double click the selected record to view the error details screen You can invoke View Error Details screen by typing GIDFILOG in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button File log Detailed Ej New E3 Enter Query Upload File Name Branch Code Interface Code Process Reference Number File Name Start Date Stamp End Date Stamp Status Field Mapping Details Based on the upload file name and process reference number system displays the error details here Upload File Name Br
40. is screen by typing GIDCRCFN in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button CRC Maintenance FX New E3 Enter Query CRC Name Description Invocation Stub Input By Authorized By Modification Date Time Date Time Number W Authorized Open You can write the invocation stub along with the CRC componenet details here CRC Name Specify the CRC Algorithm used to calculate the CRC value for the file Description Specify the description of the CRC Algorithm here Invocation Stub Specify the stub to invoke the CRC generation component 2 24 ORACLE 2 5 7 Viewing CRC Summary Details You can view the CRC details maintained in the system using CRC Summary screen You can invoke this screen by typing GISCRCFN in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button amp Advanced Search 5 Reset Authorization Status Record Status CRC Name az Description Records per page 15 y First _Previous 4 of 4 Next Last Authorization Status Record Status CRC Name Description Authorizai Record St You can click Search button to view all the CRC records of your bank However you can to filter your search based on any of the following criteria Authorization Status Select the authorization status of the CRC algorithm from the drop
41. le are Advanced Click Advanced to specify queries with logical operators such as AND OR and NOT Reset Click Reset to empty the values in the criteria fields so that you may begin a new search Query After specifying your search criteria click Query to view the list of results which match your search criteria Refresh Click Refresh to refresh the list of results 26 ORACLE 2 3 2 Maintaining AUDF ASCII User Defined Function Details You can maintain the AUDF ASCII User Define Function details in the AUDF Maintenance screen You can invoke this screen by typing GIDAUDFW in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button amp AUDF Maintenance Ej New E3 Enter Query AUDF Name Description Unit Name AUDF Type Message v Input By Authorized By Modification Date Time Date Time Number MI Authorized W Open Specify the following AUDF details in this screen AUDF Name Specify the name of the AUDF here Description Specify a description for the AUDF here Unit Name Specify the invoked function name here AUDF Type Select the AUDF types from the drop down list The following options are available e Message e Component e Record e Field 2T ORACLE 2 3 3 Viewing AUDF Summary Details You can view AUDF details maintained in the system using AUDF Summary screen You can invoke this screen by
42. m would insert the file data into log table 2 5 2 Processing Incoming Interface There are two upload tables for handling the process of incoming interface The master Upload table is for handling the master data and detail Upload table for the child data which can have 200 VARCHAR2 4000 fields to store data for each field in the file Intermediate 221 ORACLE 2 5 3 2 5 4 fields cannot be considered for transaction processing but could be used only for derivation transaction of transaction data e When an Incoming Interface Definition is saved a dynamic package and external tables for each component is created in the Database The generated dynamic package consists of fn process file and fn_upload for maintenance functions e External tables per component will be created on the file name mentioned in the Interface Maintenance which is used for reading the corresponding component s data from the file e The processing of the Incoming interface would takes place in two steps File process FP This process transfers data from file to upload tables Data process DP This process transfers data from upload table to the base tables using the function ID specific FCJ package invocation Processing File Transfer to Upload Tables You can trigger file transfer process by invoking the fn process file function in the dynamic package This function consists of cursors based on the external tables created When a parent re
43. mited File Path Specify the path of the file 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 the total number of interface file processing executions in a day This field is applicable only for incoming interface file process Duplication File Check Regd for Current Date Check this box to indicate that the duplicate files should not be added for the current date Interface Code Specify a unique interface code to identify the interface as incoming or outgoing 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 interface should be triggered The options available are e Manual Select this option if the interface has to be triggered manu
44. n by typing GIDIFTDF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button interface Definition El New E3 Enter Query EI Branch Code Interface Type Incoming v File Mask 5 CRC Required CRC Algorithm EH Justification Date Number Text Frequency Type Week Day Month Date Last Run Date Next Run Date CRC File Mask CRC File Path External System Format Type File Path CommitFetch Freguency Date Format No Of Executions Day Padding Character Date Number Text Pre Message AUDF Post Message AUDF laz Fixed hd AS H Data Log Required YY YYMMDD E Duplication File Check Required For Current Date 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 Of Records Confirmation File Required Mandatory Manual v AAA l New v Reject X E Suppress Start Reference Parallel Process Required v No Of Parallel Process Component Details Input By Date Time Incoming File Names Authorized By Date Time Modification Number M Authorized M Open
45. nerated the report ORACLE Body of the Report Source This is the source of tax payment Customer No This is the customer number of the customer who made the tax payment Customer Name This is the name of the customer who made the tax pay ment Account No This is the account number through which the tax was paid Taxable Amount This is the tax amount payable Paid Amount This is the tax amount paid Payment Date This is the date of payment of the tax Tax Reference No This is the reference number of the tax ORACLE 4 Function ID Glossary G GISCRCFN cccuiiuunietsnnnn 2 25 GIDAUDFM s 2 7 GISFILOG wakes 2 39 GIDCRCFN N 2 24 GISFTPDF coocccccnnccccncncncnncno 2 27 GIDFILOG useissa 2 40 GISFTPLG coccococorioorooinoononoss 2 32 GIDETPDF a 2 26 GISIFTDF uu eeeeees 2 20 GIDFTPTF csseesessssteseceee 2 30 GISOBDEP cedocooriciooonoonciononoss 2 5 GIDIFPRS cceecseeeeeteeeees 2 35 GISRNCHT uuiiittttnttetten 2 35 GIDIFTDF s csssseccsseeeesseeses 2 9 GISTRANS ou tees 2 31 GIDOBDEF meouuninnnnnnnn 2 3 i GIDPARAM ciiiiiniiinnnnnnn 2 1 eat min E IFRTXPM vonnissen 3 3 j ORACLE
46. ns 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 affiliates will not
47. ping Field Name Alias Name Data Type Data Length Where Order By Group By Input By Authorized By Modification Date Time Date Time Number MI Authorized M Open You can maintain the objective definition for generic interface here Name Specify the unique interface object name which is created here Description Specify a description for the object name Type Select the required object definition type from the following options e Static definition Select this option if you have a predefined query or you would write query of the object ORACLE Note Static field gets enabled for you to specify the query when you select the type of definition as static e Dynamic definition Select this option if you want to prepare or create the desired query using the dynamic maintenance Static Specify the predefined query for the static definition here Note This field gets enabled only if you select the type of definition as static Object Mapping You can map the database object details here Object Name Select the database object name that is used for the dynamic query Note Database object would be either table or Synonym or view Alias Name The alias name for the database object gets displayed which is same as the object name by default However you can edit it Field Mapp
48. rs officers Authorization functions End of day operators Processing during end of day beginning of day Financial Controller Product Managers Generation of reports 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 into the following chapters About this Manual gives information on the intended audience It also lists Chapter 1 the various chapters covered in this User Manual Generic Interface describe how to define and maintain the features sup Chapter 2 ported by Oracle FLEXCUBE to streamline the exchange of data between external systems Reports provides a list of reports that can be generated in this module and Chapter3 1155 explains their contents Function ID Glossary has alphabetical listing of Function Screen ID s used Chapter 4 in the module with page references for guick navigation 14 ORACLE 1 5 1 6 1 7 Abbreviations Used UI User Interface GW Gateway DB Database SMS Security Services ID Identification Number SDE System Defined Element IB Inter Branch Gl Generic Interfaces AUDF ASCII User Defined Function EOD End Of Day Mark EOTI Mark End of transaction Input Mark TI Mark transaction Input CRC Cyclic Redundanc
49. s as Primary Key element for a component and it is applicable to component body alone If the interface has multiple components then sys tem allows defining primary key in any one of the component 2 4 2 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 File Name You can specify the Incoming file names here File Names The incoming file names are maintained here File Name Specify the incoming interface file name here 2 ORACLE 2 4 3 Viewing Interface Definition Summary You can view the interface details maintained in the system using Interface Definition Summary screen You can invoke this screen by typing GISIFTDF in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Ct Advanced Search 4 Reset Authorization Status Record Status Branch Code a External System Interface Code Interface Type Incoming v Records per page 15 y First Previous 4 or 4 Next Last Authorization Status Record Status Branch Code External System Code Interface Type Interface Authoriza Record St You can click Search button to view all the interface records of your bank However you can to filter your search based on any of the following
50. ssing uouuuuumsmmem naa nannaa aeneeen 2 39 2 7 1 Viewing Error Details of Individual Record ccusuussssssssu aukasee 2 40 2 8 Integrating Gl with EOD aeea a sais nananana nana a naan ana O A 2 41 2 8 1 Processing Unprocessed Interface cccccuosssusssss aan a ana aa aa annet 2 41 2 8 2 Processing GI Batch x vuuvssisssssasts aan mas iaea ie 2 41 2 9 Global Variables and mask Attributes ooonoonnninnncconconncnncnccccccocnnnnnnanonncnncnnnnnnnns 2 41 29 1 Global Variables a A A ee enka STIINA 2 41 21922 EE ER O 2 42 RODOTES sarna E E ore 3 1 SA RON 3 1 3 2 File Process RepPOrtamm ssuaasnn dad ta daa tia 3 1 3 2 1 Contents of the Report a aa a a a a a a ra a ada siaii 3 2 3 3 Customer Tax Payment Information oooocinnnnnncnnnnnncccocnnonncccnnnnnonnno nano anna nana aa ennen 3 3 3 3 1 Contents of the Report a a e r a eaa naan naan naan n anna annan Aaaa aaa 3 3 Function ID Glossary corr saasta ia 4 1 1 1 1 2 1 3 1 4 1 Preface Introduction This User Manual is prepared to familiarize you with the interface between Oracle FLEXCUBE and external systems The manual gives you an overview of the usage of the system and the maintenances and process of Generic Interfaces required for its smooth functioning Audience This manual is intended for the following User User Roles Role Function Back office clerk Input functions for contracts Back office manage
51. tem values to Oracle FLEXCUBE Values and vice Versa in the Translation Definition screen You can invoke this 220 ORACLE screen by typing GIDTRANS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button Translation Definition Ej New E3 Enter Query Table Name Translate Parameter In Parameter Out Parameter Input By Authorized By Modification Date Time Date Time Number M Authorized Open You can capture the following details here Translation Name Specify the translation name you want to keep for the set The translation name gets linked to the interface field whose value needs to be translated during Interface Processing Translation Parameters The following details are specified here In Param Specify the system value for the corresponding external systems value Out Param Specify the external system s value for the corresponding Oracle FLEXCUBE value 200 ORACLE 2 5 12 2 5 12 1 Viewing Translation Summary Details You can view the translation details maintained in the system using Translation Summary screen You can invoke this screen by typing GISTRANS in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button CE Advanced Search 9 Reset Authorization Status Record Status Table Name az Records perpag
52. tion in the dynamic package This function can be divided into two parts e Populating the appropriate FCJ type with values from the upload tables e Invoking the FCJ function ID package for processing the data Populating the appropriate FCJ type with values from the upload tables is taken care by invoking the fn upload table to type function which populates the data from upload table to type using the cursors on upload table based on the base table columns Invoking the FCJ function ID package for processing the data is taken care by the function itself by invoking the appropriate function ID package s fn main function with the populated type and action The validation and business process which are already incorporated as part of the function ID development eres ORACLE 2 5 5 2 5 6 After data processing the log is written for the records if the primary key has been selected at the interface definition level Else the log is not written for that record Parallel Processing of Generic Interface Parallel processing feature is available only for Incoming file process and under incoming process it would be supported for data process i e D process You need to select parallel option and the number of parallel processes or each process for processing specified number of records in the Interface Definition screen Note Select Process Based option if the incoming file for upload consists of batch headers
53. wing parameters e User ID e Function e Branch code e Status The following details for each record are available in the results e Scheduled reference e UserID e Branch code 2 ORACLE 2 6 3 2 6 4 e Module code e Upload code e Function e Status Archiving Process When you select the interface data for archiving while maintaining the parameters the data gets archived The upload table data and file log data is moved to archive tables If parameter is set to delete then data is deleted from the upload log tables without archiving Folder Structure During generic interface for an incoming file the file is placed in the ready folder when it s ready for upload When Interface is triggered and after the successful file validation it is moved to file processed folder and the interface processing unit gets triggered If the file validation fails the file is moved to the Error folder After the successful processing of the file it is renamed with actual file name and current date time stamp YYYYMMDDHHMISS format which is separated by underscore _ and moved to the processed folder During generic interface for an outgoing file the file writing process takes place in the WIP folder and after the successful completion of the writing process the file is moved to the Ready folder The file is renamed based on the file mask maintained 246 al 4 incoming B confirmation 5 processed D ready D cre 5 proc
54. y Check OS Operating System Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function ES Exit Add row Delete row EE Option List Related Documents e Generic Interface e Core Entities e The Procedures User Manual e The Products User Manual ORACLE 2 1 2 2 2 Generic Interface Introduction Oracle FLEXCUBE interfaces with other systems installed at your bank to handle Incoming Outgoing data using batch mechanism Flat files This chapter discusses the features that are supported by Oracle FLEXCUBE to streamline the exchange of data between the system and external systems Maintaining Gl Parameter You can set the parameters for the framework of Generic Interface processing in the following screen Parameters screen invoked from the Application Browser You can invoke this screen by typing GIDPARAWM in the field at the top right corner of the Application tool bar and clicking the adjoining arrow button 4 Parameters E New E5 Enter Query Holiday Treatment Holiday Treatment Next Run Date Previous Working Day Next Working Day Purging Days Incoming Outgoing Uploaded Record Status Authorized v Archival Reguired Bad File Path File Writing Process Oracle Log File path Input By Authorized By Modification Date Time Date Time Number W Authorized
Download Pdf Manuals
Related Search