Profix Interface Oracle FLEXCUBE Universal Banking Release 11.3
Contents
1. FCUBS SYED CHO F ZueryRegionandST GueryRec ACUMEN FCUBS SYED CHO F QueryRegionandST GueryRec ACUMEN FCUBS SYED CHO F QueryRegionandST GueryRec ACUMEN FCUBS SYED CHO F ZueryRegionandST QueryRec 6031 740000000044 ACUMEN FCUBSCCAST Service QueryRegionandSTl 6091 740000000045 ACUMEN FOUBSCCAST Service QueryRegionands TI 6091 740000000046 ACUMEN FCUBSCCAST Service QueryRegionandSTl 6091 740000000047 ACUMEN FCUBSCCAST Service GQueryRegionandsT You can query the records by the following fields e Message Reference Number e Queue Name e Status The following fields are displayed in this screen e Message Reference Number e Branch e External System e Message ID e Service Name e Operation Code e User ID e Status e Message e Queue Name 2 4 Maintaining Secondary Details for ProFix Oracle FLEXCUBE allows you to maintain the list of secondary details along with their corresponding code which are transferred to ProFix along with payment information The following secondary details can be a part of incoming and outgoing files 2 4 ORACLE e Purpose of payment e Additional information 2 4 1 Maintaining Secondary Parameters Details The secondary fields are maintained as codes in Secondary Parameters Details Maintenance screen You can invoke this screen by typing PCDSECPR in the field at the top right corner of the A2. 2 8 Clarification Payment Details Oracle FLEXCUBE validates the incoming payment with Customer Account Number and Tax ID Counter Party Bank validates outgoing domestic payments with their Account Number and Tax ID The system sends or receives clarification details for those wrong details payments from counter party Bank 2 8 1 Outgoing Domestic PC Payment If validation fails during outgoing payment then counter party bank has to send the payment details to the system for clarification to get correct Account Number or Tax ID You need to copy the original contract and add Counter Party account number or Tax ID in Secondary details under dummy product where original reference number will be same as original contract 2 8 2 Incoming payments If validation fails during incoming payments then funds are moved to suspense account You need to enter the details in Secondary details to get clarification for payment from Counter party Bank When system receives details from Counter party Bank after the validation it will display the details with the Initial Payment Identifier Original Contract ref Number You can create the contract after verifying the new account number and Tax ID Debit Suspense Account and Credit to the correct new Beneficiary Account Number original payment reference number as user reference number are used Dro can view the list of clarification payment details in the PC Transaction Summary screen During the I
3. Profix Interface Oracle FLEXCUBE Universal Banking Release 11 3 1 0 0EU April 2012 Oracle Part Number E51534 01 ORACLE FINANCIAL SERVICES 1 1 ORACLE Profix Interface 1 Table of Contents ABOUT THIS MANUAL osado aaa 1 1 1 1 INTRODUCCION aio 1 1 E AUDENC ias 1 1 LS E CR LE 1 1 14 CONVENTIONS USED IN THIS MANUA ae 1 1 PROFIS INTERES Dios a ia ela 2 2 2 1 Ice ER e E 2 2 2 1 1 EEN 2 2 2 2 4AREGENERATING THE NOTIFICATION essen asian an 2 2 2 OUER DO TIE LOS TADLE tica 2 3 2 4 MAINTAINING SECONDARY DETAILS FOR DpObI 2 4 2 4 1 Maintaining Secondary Parameters Details 2 5 2 4 2 Maintaining Profix Status Code 2 6 2 4 3 Maintaining Profix Event Code oooooonnnnnnnnnnnsesennnnnssssseenonnsssseerensssssreressssssserrosssssserreossssseereesssssse 2 7 2 CAPTURING SECONDARY PAYMENT DETAILS res Eege EE eE 2 8 2 3 4 Processing Secondary Details in Outgoing Payment Messagen 2 8 232 Processing Secondary Details in incoming Payment Messagen 2 8 2 0 VIEWING PAYMENT HISTORY DETAILS ii linken ik 2 9 2 6 1 ee een 2 9 2 1 PROCESSING NOSTRO ACCOUNTS FOR PROFIX ideal 2 10 2 8 CLARIFICATION PAYMENT DETAILS ans nee 2 10 2 8 1 OU OTe DOMESTIC CT DEN een nee RE 2 10 2 8 2 Peon DA MES ai ina 2 10 SCREEN GEOSSARY scsi aiii iia dan 3 1 3 1 UN A ER E 3 1 a ORACLE 1 1 1 2 1 3 1 4 1 About this Manual Introduction This manual is designed to help you quickly get acquainted with interface bet
4. cial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated gt ORACLE
5. d received K file 2 7 ORACLE Event description e Document is confirmed created Z file 2 5 Capturing Secondary Payment Details You can capture the secondary payment details of a transaction in the Secondary Details screen You can invoke the Secondary Details screen from the PC Transaction Input screen by clicking Secondary Details button 3 Secondary Details Web Page Dialog Contract Reference Number 341212001 550024 Secondary Details d Secondary Parameters FPPF a MARS C MAlTHIRI TESTING az JUPITER TEST4 az INDIA C UPASANA az TESS o Cancel The Secondary detail screen and the processing are explained under the heading Specifying Secondary Payment Details in the Payments and Collections user manual 2 5 1 Processing Secondary Details in Outgoing Payment Messages For an outgoing payment message the secondary details are maintained in FLEXCUBE There is no other validation on the Secondary details of payments values apart from the codes of data type as Date against Date Mask if it is specified The payment values are not validated in Oracle FLEXCUBE The secondary details are captured in the form of simple text in multi line with each line having max of 217 chars with a maximum number of 99 lines 2 5 2 Processing Secondary Details in incoming Payment Messages The secondary details in the incoming payment details from Profix are t
6. ed You can maintain the following details here Status Code Specify the status code for a particular status here Description Specify a description for the code you are maintaining Example The following status codes and description can be maintained aa Document is accepted by ProFix o Document is sent to SEP Document is reflected on the correspondent account Document is closed Document is rejected in SEP 2 6 ORACLE CS Document is returned to FlexCube 2 4 3 Maintaining Profix Event Code You can maintain the list of ProFix SEP event code and description in system The event code details are maintained in Profix Event Code Definition screen You can invoke this screen by typing PCDPROEV in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button A Profix Event Code Definition Web Page Dialog Event Code Description Input Bry Date Time Modification Number i Open Authorized By Date Time KM suthorized You can maintain the following details here Event Code Specify the event code for a particular event here Description Specify a description for the code you are maintaining Example The following event codes and description can be maintained Event description Initial document is sent from FlexCube Initial document is received in ProFix Document is sent in ARM SEP Initial document is confirmed received T file Document is confirme
7. ncoming payment upload debit account currency is checked with Product Category lf the currency not allowed then payment will be rejected The debit account currency can be restricted or allowed as per the maintenance in Product Category maintenance screen a ORACLE 3 Screen Glossary 3 1 Function ID List The following table lists the function id and the function description of the screens covered as part of this User Manual IFSLOGQR Log Summary PCDSECPR Secondary Parameters Details Maintenance PCDPROST Profix Status Code Definition PCDPROEV Profix Event Code Definition PCSPYHST PC Payment History 3 1 ORACLE ORACLE Profix Interface April 2012 Version 11 3 1 0 0EU Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_ services Copyright 2012 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in any form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Finan
8. on of the contract the system passes the accounting entries and if it is successful then contract details are logged in messaging queue 4 Thesystem creates an XML with handoff details required by external system 2 1 1 2 Incoming Payment 1 The requests to Oracle FLEXCUBE Gateway from the external systems are kept in an incoming queue configured for the external systems The system picks up those requests from this queue and processes the requests 2 The system logs the requests in a log table The time logged and status of the transaction Is maintained in the log table Regenerating the Notification You can regenerate the outgoing payment notification using Payment Status screen You can invoke this screen by typing PCDLIQDT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 2 2 ORACLE 2 3 g Payment Staus Webpage Dialog ACTIVATION DATE 7 42000 El QUERY CONTRACT DETAILS e Contract Ref Number Source Code Source Reference Customer No Account No Auth Status y ACBBBBC00186001 22201 SAVINDEURf1 A y ACBBBBC00186001 22201 SAVINDEURFI Y ACBCPCO0018600 22201 SAVINDEURF TI ACBCPCO0018600 22201 SAVINDEURFI IT ACBCPCO0018600 22201 SAVINDEURF S See ae rn rn rn rn rn Activation Date Specify the activation date for querying the records You can choose this date from the option list as well The following fields are dis
9. played in this screen Contract Reference Number Source Code Source Reference Customer Number Account Number Authorization Status Name Upload Status You can select the record and click OK to regenerate the outgoing payment notification Querying the Log Table You can query the log table using Log Summary screen You can invoke this screen by typing IFSLOGQR in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button 2 3 ORACLE F A Log Summary Web Page Dialog Message Ret No Status El aueue Mame Search Advanced Search Reset Records per page 15 RT of 2 Fe Goto Page Message Ref Mo Branch Ext System Message ld Service Mame Operation Code Userld Status Messe ACUMEN FCUBS VICKY CHO F CreatePCContract FLEXCUEE 6091 750000000059 ACUMEN FCUBSPE Service CreatePCContract PCUTEST CNC1 CUS100CHA 300 300 SEFENK C3 26209001 USDA A ACUMEN FCUBS VICKY CHO F CreatePCContract FLEXCUIBE 6091 750000000090 ACUMEN FCUBSPE Service CreatePCContract PCUTEST CNC1 CUS100CHA 300 300 SEPBMKCS 26209001 USD A A ACUMEN FCUBS WICKY CHO F CreatePlContract FLEXCUBE 6091 750000000091 ACUMEN FCUBSPCService CreatePlContract PCUTEST CMC1 CUS1T00CHA C 300 300 SEPBNKES 26209001 USDA A ACUMEN FCUBS VICKY CHO F CreatePCContract FLEMCUBE 6091750000000092 ACUMEN FCUBSPCService CreatePCContract PCUTEST CNC1 CUS100CH4 300 300 SEPBNKCS 26209001 USDA A ACUMEN
10. pplication tool bar and clicking on the adjoining arrow button 23 Secondary Parameters Details Maintenance Web Page Dialog Code Data Type Multiple Lines Date Mask 4 yviailable For User Input By Date Time Modification Humber Open Authorized By Date Time Wy authorized The following details can be maintained here Code Specify the code you want to assign for a parameter here Name Specify a name for the parameter for which you are maintaining the code Data Type Select the data type from the list of options e D Date The date mask field gets enabled e T Text e N Number Multiple Lines Check this box to indicate if this code can be used multiple times Date Mask Specify the date mask if the data type you selected is date 2 5 ORACLE Available for User Check this box to indicate if this parameter is available for the user to edit 2 4 2 Maintaining Profix Status Code You can maintain the list of ProFix SEP status code in system to identify if the payment has been created or rejected The status code details are maintained in Profix Status Code Definition screen You can invoke this screen by typing PCDPROST in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button A Profix Status Code Definition Web Page Dialog Status Code Description Input By Date Time Modification Humber Open Authorized By Date Time Authoriz
11. ransferred in separate multiline field with indication of the secondary detail code and value You can view secondary details and the system will not perform any validation 2 8 ORACLE 2 6 Secondary detail screen and the interface processing are explained under the heading Specifying Secondary Payment Details in the Payments and Collections user manual Viewing Payment History Details After a PC contract is authorized successfully in FLEXCUBE and all the events being processed FLEXCUBE will send notification to Profix After validations ProFix generates acknowledgement as S or E FLEXCUBE will reverse the contract if status sent is E In case of acknowledgement S Payment Status in PC Transaction Input screen gets displayed as Success and for E as Rejected The details can be viewed using the PC Payment History summary screen You can invoke this screen by typing PCSPYHST in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button A PC Payment History Web Page Dialog Contract Ref Number Frofix Document Identifier Result of Document Acceptance Event Code Status Code Object name Line Search Advanced Search Reset Records per page 15 LIKE Of 1 we Contract Ref Number Profix Document Identifier Result of Document Acceptance Event Code Event Code Description Status Code State Status i The PC Pa
12. ween Oracle FLEXCUBE and the external system Profix 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 Abbreviations The following abbreviations are used in this User Manual SCFMU Specially Authorized Executive Body for Financial Monitoring Conventions Used in this Manual Important information is preceded with the symbol 1 ORACLE 2 1 2 1 1 2 2 2 Profix Interface Introduction The external system Profix provides communication between Oracle FLEXCUBE and Integrated Payment System of the bank or System of Electronic Payment of National Bank of Ukraine The following diagram illustrates the data exchange that happens between Profix and Oracle FLEXCUBE Flexcube BNIC Con PC nabo FT Process Flow 2 1 1 1 Outgoing Payment 1 You maintain the Payments and Collections contract details in Oracle FLEXCUBE During the save of the contract the system triggers BOOK and INIT events 2 If there are any data related issues you cannot save the contract Once BOOK and INIT events are successfully executed the contract is ready to be authorized 3 During authorizati
13. yment History details and processing are explained under the topic Viewing Payment History Details in the chapter Maintaining Information Specific to the Payments and Collections Module of this user manual 2 6 1 Viewing History Details You can view the payment status history details of a particular contract in the History screen You can invoke the History screen from the PC Transaction Input screen by clicking History button 2 9 ORACLE The PC Payment History details and processing are explained under the topic Viewing Payment History Details in the chapter Maintaining Information Specific to the Payments and Collections Module of this user manual 2 7 Processing Nostro Accounts for Profix During EOD BOD NOSTRO accounts are notified to Profix Profix can send query with account number to get account balance and debit amp credit turnovers 2 7 1 1 Payment Reconciliation During payment reconciliation after receiving the block request from Profix Oracle FLEXCUBE blocks the NOSTRO account for domestic payment until reconciliation completes Any payment comes during this time goes to Exception Queue and later you can upload the payment after receiving the unblock NOSTRO request from Profix after completing reconciliation During reconciliation all the PC contracts would go into exception queue and they have to be retried manually by the bank Error during reconciliation is handled by bank
Download Pdf Manuals
Related Search