Home

Millionaire Certificate User Manual

1. 3 1 3 1 INTRODUCTION o 3 1 3 1 1 Maintaining Pay in Parameter Details eese esee esee seen non tentent enne nee 3 1 3 1 2 Viewing Pay in Parameter Details Summary eee eee esee eee enne enne neret nennen enne 3 2 3 1 3 Maintaining Monthly Provision Details eese eene eere enne 3 3 3 1 4 Viewing Monthly Provision Details Summary eese esee eene nono nono nennen entente enne nee 3 5 3 1 5 Maintaining Draw Parameter Details eese eene eene trennen entren 3 5 3 1 6 Viewing Draw Parameter Summary eese eene tenent nennen rennen ener tree trennen trennen 3 7 SLT Processing EOD Baths tn e tenu RERO p RUE Ee estate 3 8 DEFINING PRODUCT ATTRIBUTES eeeeeee essen eese entes etn tune tasse thats tasses suse tasse ta senten sesso sese suse siess 4 1 4 1 INTRODUCTION eei depen HU RU RI REOR REO MM III 4 1 4 1 1 Capturing Millionaire Certificate Product Details esee 4 1 4 1 2 Specifying Preferences for a Product eese ener nenne ene 4 3 4 1 3 Specifying Charges ICCF for a Product eese eene ener nenne entente 4 5 4 1 4 Viewing Product Definition Details Summary easet enne eee nen nennen 4 6 PROCESSING MB CONTRACT eese esee eese tn stes tn status ets tuse ta senten sesso sess tuse ta ro cone senten sesto sonsos ssis 5 1 5 1 INTRODUCTION A Prieto snp Pete EB U
2. Event Accounting Role ix Amount tag Amount tag Description n REVR MC CUST AC GL Dr CERT AMT Certificate value No of certificates Negative amount REVR MC LIAB GL Cr CERT AMT Certificate value No of certificates Negative amount 7 3 7 LMC Issuance Event Accounting Role Dr Cr Ind Amount tag Amount tag Description INIT LMC ASSET GL Dr CERT AMT Certificate value INIT LMC LIAB GL Cr CERT AMT No of certificates INIT MC CUST AC GL Dr INT AMT Issuance price INIT LMC ADV INT GL Cr INT AMT No of LMC issued 7 3 8 LMC Manual Roll over Event Accounting Role Dr Cr Ind Amount tag Amount tag Description ROLL MC CUST AC GL Dr INT AMT Issuance price No of LMC issued ROLL LMC ADV INT GL Cr INT AMT LMC Cancellation Event Accounting Role Dr Cr Amount tag Amount tag Ind Description LIQD LMC LIAB GL Dr CERT AMT Certificate value No of certificates LIQD LMC ASSET GL Cr CERT AMT LIQD LMC ADV INT GL Dr UNAMORTIZED INT AMT Unamortized interest amount LIQD LMC INT INCOME GL Cr UNAMORTIZED INT AMT 7 3 ORACLE 7 3 10 LMC Monthly Amortization Event Accounting Role Dr Cr Amount tag Amount tag Ind Description LMCA LMC ADV INT GL Dr AMORTIZE INT AMT Amortized interest amount LMCA LMC INT INCOME GL Cr AMORTIZE INT AMT 7 3 11 LMC Reversal Event Accounting Role Dr Cr Amou
3. 3 3 ORACLE amp Monthly Provision Maintenance New Monthly Provision Maintenance Product Code Product Description Provision Currency Provision Date Provision Amount Maker Date Time Checker Date Time Record Status Authorization Status You can maintain the following details here Product Code Select a valid MC LMC product code for provisioning from the list of values maintained You can specify ALL products also for provisioning The description for the specified product gets displayed in the adjacent field Provision date gets defaulted as the system date Provision Amount Specify the amount for provision The currency gets displayed in the adjacent field After the provision is authorized you cannot modify the record System compute the branch provision share for all the branches holding active MC LMC as on provision date and post provision accounting entries for all these branches Branch provision amount is computed by apportioning the Provision amount based on the number of MC LMC in books of branch under consideration with that of total number of MC LMC in books of all branches System would use contract originating branch as the basis to group MC LMC for a given branch Branch Provision Share Provision amount Total MC LMC in books of branch A Total MC LMC Deposits in all branches Upon computing branch provision amount system would trigger the PROV event to pass the inter br
4. Event For Association Event For Application Description Description Event For Liquidation Basis Amount Tag Description Description Rule Details Settlement Currency Default Waiver Rule Capitalize Description Collect LC Advising Charges in Bills Other Details Allow Rule Amendment Amend After Application Amend After Association Consider as Discount Allow Amount Amendment Discount Basis Accrual Required a D tu Issuance charge is a flat amount based charge associated to appropriate events It could also be a percentage of total amounts of certificates issued Pre encashment charge is a tenor basis charge with 2 596 charge for 0 90 days and 096 thereafter The tenor of the open ended MC contract with maturity date as null would be computed as Application date Value date Charge currency code should be the LCY code Any changes in product parameters would be applied for prospective contracts events only For further information on the generic attributes that you can define for a product please refer the following Oracle FLEXCUBE User Manuals under Modularity e Product Definition e User Defined Fields e Settlements Millionaire Certificate Product Definition screen allows all standard maintenance functions Add Modify Delete Authorize Close Re open and Inquiry It also log all maintenances in the Audit Trail m ORACLE 4 1 4 Viewing Product Definition Details Summary You can view the sum
5. e Status Number of MC held and Number of LMC held by the customer gets displayed 5 2 6 Mapping Customer Reference to CIF You can map a single or multiple customer reference number to a CIF with one of the customer reference number to be selected as default Customer reference mapping can be done through Customer Reference Mapping screen To invoke the Customer Balance Inquiry screen enter MBDCMAP in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button Customer Reference Mapping New Customer No Customer Reference Details 1017 O Customer Reference No x Default Maker Date Time Checker Date Time Record Status Authorization Status You can map customer reference number or multiple customer reference numbers to a CIF with one of the customer reference number to be selected as default here Customer No Select the customer number or CIF for mapping the customer reference number Customer Reference Details Customer Reference No Select the customer reference number to map the selected customer number CIF The customer reference numbers which are yet to be mapped to a customer number are listed in the LOV You cannot map a customer reference number already mapped to one CIF to other CIF 5 10 ORACLE Default Specify the default customer reference number for the selected customer One of the mapped customer reference numbers has t
6. screen 3 2 ORACLE To invoke the Pay in Parameter Summary screen enter MBSMBPAY in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button Summary Authorization Status v Record Status v Product Code Las Branch Code 7 Payin v MEX 000000 n U digi 0Search mi Advanced Search Records per pagez 15 v 1 8001 Authorization Status Record Status Product Code Branch Code Pay In Oe CDM oR UU O 54 0 50 0 Ue O O MR Dum UU mbg 2 uU 10 17 Sore Ax 10110 D You can query the contract records with the following details e Authorization Status e Record Status e Product Code e Branch Code e Payin Click search button to view the records with the specified values Maintaining Monthly Provision Details You can maintain monthly provision for MC LMC in the Monthly Provision Maintenance screen from the head office level For a product provision is allowed only once in a calendar month and if it is done for ALL products then provisioning for individual products is not allowed Similarly If provisioning is done for specific product then system would not allow provisioning for ALL products in the given calendar month To invoke the Monthly Provision Maintenance screen enter MBDMPROV in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button
7. to the winner without any cash payments Winner has an option to redeem the certificates 2 3 Lien Millionaire Certificates Lien Millionaire Certificates LMC is another product offered by the bank All features are like the Millionaire Certificates but for the below mentioned features While purchasing the MC you have an option to pay the interest Currently 696 per year per certificate and get add on notional MC Notional certificates are eligible to participate in the draw The number of MC you can buy on lien is dependent on the number of MC you hold The subscription transaction fee MC is waived off if the customer opts for the Lien Liened MC can be renewed every year by paying the same interest If the renewal is not done then the notional certificate will be active up to grace period end defined at product preference and after grace period end Notional certificate is dropped automatically The bank has an option to Reverse the MC LMC with an option to refund the interest when gt Reversal of MC contract is allowed only if it has not undergone liquidation re issuance and it should not be linked to any LMC contracts gt Reversal of LMC contract is allowed only if it has not undergone cancellation rollover reissuance monthly interest amortization 2 2 ORACLE 2 4 2 5 If a customer liquidates the MC then proportionate of LMC should be dropped accordingly as per eligibility matrix Interest rate charged is not refu
8. Date Time The following details are displayed here e Product Code e Product Description e Customer No e Customer Reference Number e Transaction Type as liquidate ORACLE Contract Reference No Specify the contract reference number User Reference Specify the user reference number Source Code Specify the source of the contract Source Reference Specify the source reference of the contract The following details are displayed e Value Date system defaults the application date to value date e Book Date book date of the contract e Maturity Date maturity date of the contract e Issuance Price MC certificate value or LMC issuance price No of Certificates Specify the number of certificates participating in the specified transaction type The computed contract value based on the number of certificates and issuance price gets displayed as amount Control Number Specify the control number of pre printed stationary instrument which should be a valid stock number as maintained through Adjust Inventory Balance MC Branch to User System would accept this control number value only for partial liquidation of MC contract The details of remaining active MC are printed on the instrument with the specified control number In case of complete liquidation of MC contract or cancellation of LMC contract control number value has to be left blank null For contracts initiated from FCDB source system woul
9. This chapter gives you an overview of the Millionaire Certificate MB module of Oracle FLEXCUBE There are two types of certificates issued by the bank e Millionaire Certificate MC e Lien Millionaire Certificates LMC Millionaire Certificate Millionaire Certificate MC is a savings and investment opportunity which offers a good returns on your investment and certificates are completely capital guaranteed and en cashable at any point of time The subscription to MC is in multiple of thousands only To subscribe to MC you should hold a Valid Visa Transit Visit Business Residential and a Passport MC can be bought from any of the branches of the bank or through any channels like their associated exchanges and gets processed from the bank The non residential clients would be able to redeem it through a Power of Attorney issued with proper documentation 2 2 ORACLE Customers of the bank can get certificates attached to their account if the MCs have been purchased under the CIF of the account as well Non customers of the bank can purchase the MC and later associates with the Customer or CIF if he becomes customer and declares the same to the bank Inventory module is used to track the movement of the instruments between central vault and branches and tracks the status of each instrument by serial number The MB module provides you with the following features MC is open ended and don t have any maturity date and can be withdrawn
10. to identify the product throughout the module The code should contain four characters You can follow your own convention for devising the code but at least one of the characters should be a letter of the English alphabet Since the code that you define is used to identify the product it should be unique across the modules of Oracle FLEXCUBE For instance if you have assigned the code MC01 to a particular product in this module you cannot use it as a code in any other module Description Specify a brief description of the product which will be associated with the product for information retrieval purposes Product Type Indicate the type of product from the options given below e Millionaire Certificate e Lien Millionaire Certificate Start End Date A product can be set up for use over a specific period by defining a start and an end date The Issue Date of an MC involving a product should be e The same as or later than the Start Date e The same as or earlier than the End Date The start and end dates of a product come in handy when you are defining a product for a scheme which is open for a specific period e ORACLE Remarks You can enter information about the product intended for the internal reference of your bank The remarks are displayed when the details of the MC are displayed or printed but not printed on any correspondence with the customer 4 1 2 Specifying Preferences for a Product Click Pre
11. value of the identifier details of the customer KYC Status Select the status of KYC checking of the customer from the following drop down options e Yet to Verify e Verified Charge Group Specify the charge group of the customer Passport Details You can provide the passport details of the customer here Passport Number Specify the passport number of the customer Issue Date Specify the issue date of the customer passport Expiry Date Specify the expiry date of the customer passport 5 6 ORACLE 5 2 3 Certificate Details L Certificate Details Certificate Details 10117 Control Number Certificate Start no Certificate End No No of Certificates Certificate Amount When you save the contract and system performs the following e Upon MC issuance to customers if the cumulative value of MC held by the customer including the current contract and by considering all the mapped customer reference number exceeds the KYC limit then system would validate the KYC compliance of the CIF If the CIF is not KYC compliant then system raises an error e Contracts initiated from FCDB source can only be viewed in the system Customer can do further lifecycle in FCDB only System would not allow any operations processing on FCDB contracts through Oracle FLEXCUBE source e You can operate contracts initiated through other branches For account transfer system would post accounting entry to the branch in which the accou
12. 8 1 8 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 MBDCMAP Customer Reference Mapping MBDCUBAL Customer Balance Inquiry MBDDRMNT Draw Parameter Definition MBDMBPAY Pay In Parameter Maintenance MBDMPROV Monthly Provision Maintenance MBDPRMNT Millionaire Certificate Product Definition MBDTRONL Millionaire Certificate Contract Input MBDTRPAY Millionaire Certificate Payment Input MBSDRMNT Draw Prameter Summary MBSMBPAY Pay In Parameter Summary MBSMPROV Monthly Provision Summary MBSPRMNT Millionaire Certificate Product Definition Summary MBSTRONL Millionaire Certificate Contract Summary 8 1 ORACLE ORACLE Millionaire Certificate May 2012 Version 12 0 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 writ
13. INIT MC LIAB GL Cr CERT AMT Certificate value No of certificates INIT ChargeClass INC Cr ChargeClass AMT Issuance charge 7 3 2 MC Re issuance Event Accounting Role Dr Cr Ind Amount tag Amount tag Description RIMC MC CUST AC GL Dr ChargeClass AMT Re Issuance charge RIMC ChargeClass GL Cr ChargeClass AMT 7 3 3 MC Issuance to winners Event Accounting Role Dr Cr Ind Amount tag Amount tag Description WIMC HO AC CPC Dr CERT AMT Certificate value No of certificates WIMC MC LIAB GL Cr CERT AMT 7 3 4 MC Liquidation Encashment Event Accounting Role Dr Cr Ind Amount tag Amount tag Description LIQD MC LIAB GL Dr CERT AMT Certificate value No of certificates LIQD MC CUST AC GL Cr CERT AMT LIQD MC CUST AC GL Dr ChargeClass AMT Pre encashment fee LIQD MC INCOME GL Cr ChargeClass AMT 7 3 5 MC Monthly Provisioning Event Accounting Dr Cr Role Ind Amount Amount tag Description tag PROV MC EXP GL Dr PROV AMT Monthly provision amount This would trigger an interbranch accounting entry Debit the local branch and credit the HO PROV MC PROV GL Cr PROV AMT 7 2 ORACLE 7 3 6 MC Reversal 7 3 9
14. Millionaire Certificate Oracle FLEXCUBE Universal Banking Release 12 0 May 2012 Oracle Part Number E51465 01 ORACLE FINANCIAL SERVICES ORACLE Millionaire Certificate 1 Ead q Table of Contents MILLIONAIRE CERTIFICATE MB eocccccconoonoononncononacnnncnncnncononnonncnnonnnonocononncnnooncn conc nc none sens enses enses sonata snae 1 1 1 1 INTRODUCTION de en ea 1 1 2 gt SSUDIENCE nicas 1 1 1 32 ORGANIZATION aia 1 1 1 4 GLOSSARY OR ICONS iS 1 2 L RELATED DOCUMENTS A ERR REG T IR Bee 1 2 OVERVIEW MILLIONAIRE CERTIFICATES eese esee ee seen en sente atta tuse ta tone ta sens enses tosta caceres 2 2 2 1 INTRODUCTION josse deret eere heel re dee eii eee e eor ds 2 2 2 2 MILEIONATRE CERTIFICATE i 1er p ete Ir Re ee i rr Her nre eee e ens 2 2 2 3 LIEN MILLIONAIRE CERTIFICATES tbt het Her n e eee etas 2 2 2 4 JDRAW PROCEDURE cere preter eere ra tee cott Her inr e eee s 2 3 2 59 SCOPE OFTHE MODULE opere ete tre eh i Her e teo eet s 2 3 2 0 MB MODULE FUNCTIONS amp FEATURES eee etette ttr tree o iden Here ier eerie ens 2 4 2 6 1 Flexible Parameters Definition eee ee seien ianea nn cana Er ettet entente nete nne 2 4 2 6 2 MC EMC Customers isis es eh PR UR EE E PER RARE KR RETE EE ERE UR TORTE REL 2 4 2 6 3 Instrument Numbering iii iui odis sri apopo EEEE SESEO sS eP STEES CERESE EEN Eae os 2 4 MAINTENANCES TYTT A
15. Office Trade Finance Contract Input functions except Authorization Department Clerks Back Office Trade Finance Contract Authorization maintenance of static data specific to Department Officers this module Front end Trade Finance Product definition functions excluding authorization Query Product Managers functions End of Day Operators End and beginning of day related processing functions Bank s Financial Branch level processing related setup for this module and Controller Trade Finance Authorization of the same Department Manager MIS Department Officers Query Report functions 1 3 Organization This Manual is organized into the following chapters Chapter 1 About this Manual Chapter 2 Overview of the MB module Chapter 3 Maintenances required for the MB Module Chapter 4 Attributes specific to setting up MB product Chapter 5 Contract details related to MB 1 4 1 5 Chapter 6 Payment details related to MB Chapter 7 Annexure containing additional details Glossary of Icons This User Manual may refer to all or some of the following icons 3 Add row row Option List Related Documents You may need to refer to any or all of the User Manuals while working on the MB module e CE e Inventory e ELCM e Procedures e Products e User Defined Fields 2 1 2 2 2 Overview Millionaire Certificates Introduction
16. aintenance Report accepts Draw reference number as the input parameter and displays sequence number certificate number and customer reference number for all certificates eligible for the draw Viewing Draw Parameter Summary You can view the summary of monthly provision details through the Draw Parameter Summary screen To invoke the Monthly Provision Summary screen enter MBSDRMNT in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button 3 7 ORACLE 3 1 7 Summary Authorization Status v Draw Reference Number Min No of MC Record Status v Cutoff Date 0 tig00Search o Advanced Search qododo mj Reset Records per paged 15 v 1 pOfo 1 Authorization Status Record Status Draw Reference Number Cutoff Date Min No of MC pe Qu UON E q eG 050 0 ww O ea OD UO O uw Oum Du O O 2047 10 0 THX G You can query the contract records with the following details e Authorization Status e Record Status e Draw Reference Number e Cutoff Date e Min No of MC Click search button to view the records with the specified values Processing EOD Batch During the End of Transaction Input to amortize the interest received in advance on LMC an EOD batch MBBEODFN is run on a monthly basis The lien amount is amortized over the period of one year based on the following formula Monthly amortization amount Total interest amoun
17. alance You can query the MC and LMC holding balance of a customer in the Customer Balance Inquiry screen To invoke the Customer Balance Inquiry screen enter MBDCUBAL in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button 5 8 ORACLE Customer Balance Inquiry New t 3 Enter Query Customer No Customer Reference No ALL Control No Certificate No Balance Details 10710 C Customer Reference No Product Code Contract Reference Control No Certificate Start No No of MC Held No of LMC Held System would display the MC LMC holding details of the given customer number and customer reference number Customer No Specify the customer number CIF to query the balance of that customer Customer Reference Number Specify a valid reference number mapped to the selected customer number You can select ALL to view the consolidated holdings of the customer across all customer reference number mapped to the CIF Control No Specify the control number to query the balance Certificate Number Specify the MC certificate number of the customer to query the balance Click Query button to view the balance details as per the selected criteria You can view the following details e Customer Reference No e Record Code e Contract Reference No e Control No e Certificate Start No e Certificate End No e Quantity e Total Certificate Value 5 9 ORACLE
18. anch accounting entries as mentioned below In Books of Branch A Debit Expense GL Branch Provision Share 3 4 ORACLE 3 1 4 Credit Head Office Account in books of branch A Branch Provision Share In Books of Head Office Debit Branch A Account in Head Office books Branch Provision Share Credit MM Provision GL Liability GL Branch Provision Share The date of provision gets defaulted Viewing Monthly Provision Details Summary You can view the summary of monthly provision details through the Monthly Provision Summary screen To invoke the Monthly Provision Summary screen enter MBSMPROV in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button Summary Authorization Status v Record Status v Product Code Provision Date Provision Currency alia Provision Amount _coRefresh jajajajajajaja Reset MEE ETE Records per pagec 15 1 zofz 1 Authorization Status Record Status Product Code Provision Date Provision Currency Prc 0003 0 q O 6 01 BRE er OS 17 aou o Gm DOW y e mE US EE TUAE Dy 20 0 Fa eee m You can query the contract records with the following details e Authorization Status e Record Status e Product Code e Provision Date e Provision Currency e Provision Amount Click search button to view the records with the specified value
19. at any point in time across the counter But any encashment within X number of days from the date of purchase shall be subject to a nominal pre encashment fee of 2 5 of total certificate value Certificates are Non Interest bearing non negotiable and non pledge able to any third party Customers can walk into any Bank branch and en cash their certificates Withdrawal of MC can be cash or transfer to customer account with the bank Minimum investment allowed as certificates is issued in respective LCY equivalents One time fee is charged per transaction irrespective of number of certificates issued Draw is conducted on a daily weekly bimonthly monthly quarterly basis with minimum savings condition Secured over draft facility is there to meet the immediate financial needs while remaining in the running for a million dirham draw You can avail the facility of a secured over draft against their Millionaire certificates up to 9096 of MM value at the rate of 8 596 MC can be purchased on line by account holders of your bank and non account holders All credit card holders are accepted to purchase MC customers amp non customers For other bank credit card customers there is an additional MC issuance charge of 1 596 on the transaction amount normal issuance fee In case of lost certificates the bank reprints the MC and may charge a new issuance fee After winning the draw MM certificates equivalent to the winning amount would be issued
20. d not allow to track control number LMC Control Number Specify the control number of pre printed stationary instrument which is a valid stock number as maintained through Adjust Inventory Balance MC Branch to User If the Liquidation of MC causes reduction in the eligibility of the LMC for that customer reference number then auto liquidation of LMCs held by the customer is done Hence this control number is used for the partially liquidated LMCs Pay in option Specify the pay option from the following drop down list e Cash e Account Transfer 6 2 ORACLE Account No GL code Upon selection of pay in option as cash you should select the GL code as maintained in pay in parameters from which the contract value would be debited If the GL code is not selected then upon save system would default the relevant GL code from pay in parameter maintenance For pay in option as account transfer you should specify the customer account number linked to the selected CIF System would allow only LCY accounts to be selected Remarks Specify any additional remarks for the Payment Charge Group System defaults the charge group associated with the CIF to be used for the contract You can modify the charge group of the contract Denomination Details For cash payment you can maintain denomination details You should operationally maintain appropriate denomination details for the amount settled across counter which is not vali
21. dated by the system 6 3 ORACLE 7 Accounting Entries and Advices 7 1 Introduction This Annexure contains details of the suggested accounting roles and events related to the MB module of Oracle FLEXCUBE The annexure lists details of the suggested accounting entries event wise Supporting Advices and Notifications are also listed in this chapter 7 2 MB Events The following is an exhaustive list of events that are part of millionaire certificate product maintenance In the subsequent paragraphs we shall examine the accounting entries for each of the events listed below Event Code Event Description BOOK MC LMC Book INIT MC LMC Issuance RIMC MC LMC Re issuance WIMC MC Issuance to winners LIQD MC LMC Liquidation ROLL LMC rollover LMCA LMC Monthly amortization PROV MC Monthly provision CLOS LMC Closure REVR Reversal 7 3 Accounting Entries No accounting entries are maintained for BOOK and CLOS events The accounting entries are maintained for other events as mentioned below 7 3 1 MC Issuance Cash Cheque Credit Card Account transfer Event Accounting Role Dr Cr Ind Amount tag Amount tag Description INIT MC_CUST_AC_GL Dr CERT_AMT Certificate value No of certificates INIT MC_CUST_AC_GL Dr lt ChargeClass gt _AMT Issuance charge 7 1 ORACLE Event Accounting Role Dr Cr Ind Amount tag Amount tag Description
22. ditional details of new walk in customers should be recorded in the customer details section Transaction Type Specify the type of transaction from the drop down options Transaction types are associated to a specific event for differential charging and accounting The options are e Normal Issue Event INIT For normal issuance of MC to customers e Replacement Issue Event RIMC In case of lost certificates an indemnity may be taken from customer and the bank reprints the MC certificates with new system generated certificate numbers Old control number would be marked as lost and system would force the user to enter new control number This option is available only on contract amendment e Issue to winners Event WIMC For issuance of MC to winners Pay in option has to be Other GL enabling user to specify the debit GL eg HO account in CPC books or MM provision GL or other expense GL e Lien Issue Event INIT For issue of notional lien MC e Lien Rollover Event ROLL For renewing the lien This option would be available only on contract amendment User Reference Specify the user reference number Source Code Specify the source of the contract Source Reference Specify the source reference of the contract Value Date Specify the value date of the contract Only MC issuance can be back dated Future dated contract is not supported The application date gets displayed as the booking date of
23. e eee e SERENO REL e e QA OR IRURE er dios 5 1 5 2 CAPTURING MILLIONAIRE CERTIFICATE CONTRACT DETAILS occcocononcononnnanonnnnononanononnonananancononanaronincanacinenos 5 1 5 2 1 D nomination Details iure yate e euet e pr tee eda tereti aces tenet npe s 5 3 2 2 2 Customer Detdilss ates eS Re o NA o E fe e 5 4 5 2 3 Certificate Details itp RI RE EUR BERE RO GR GR re to Den gera 5 7 5 2 4 Viewing Millionaire Certificate Contract Summary essent nen enne 5 7 3 2 2 Querying Customer Balance cea ter ete ete PREIS Kan eee E RE aa LEN e Fee RN Ee RERO ERR ere RR 5 8 5 2 6 Mapping Customer Reference to CIF eese eene enne nennen trennen ene 5 10 PAYMENT A ONO 6 11 6 1 INTRODUCTION c etat solace ccs odiada Ei RIAS lube Ed id 6 11 6 1 1 Millionaire Certificate Payment Details esee eene enne nennen rennen ene 6 11 ACCOUNTING ENTRIES AND ADVICES eee esee ee ense ee tenent n etna tn senses tosta tone ta conoce sesto sees suse tatnen 7 1 7 1 INTRODUCTION a dd a e di a dt e aed 7 1 7 2 MB EVENTS E 7 1 7 3 ACCOUNTING ENTRIES cccceessssscecececeessseaeseceesesssnsecececeeseseaesecececsensnaeaeeececsensuaesececsesesesseaeseceeseeeseaaeeeeees 7 1 7 3 1 MC Issuance Cash Cheque Credit Card Account transfer eee nennen 7 I 7 3 2 MC ReisSstanC E Ada 7 2 7 3 3 MC Issu nce 10 WIleFs ds 7 2 7 3 4 MC Liquidation Encashment eee eese eese enne n
24. ect one of the following options e Disallowed e Allowed Product You can specify the list of MC LMC products to be included in the restriction for the draw Product Code Specify the product to be included in the restriction for the draw The product description gets displayed Branch Restrictions Indicate the restriction for the branch during the draw You can select one of the following options e Disallowed 3 6 ORACLE e Allowed Branch You can specify the list of branch to be included in the restriction for the draw System would use contract originating branch as the basis to tag MC LMC to a given branch Branch Code Specify the branch to be included in the restriction for the draw The branch description gets displayed Certificate Restrictions Indicate the restriction for the certificate numbers during the draw You can select one of the following options e Disallowed e Allowed Exclude Certificate Number You can specify the list of certificate numbers to be included in the restriction for the draw Certificate No Specify the certificate number to be included in the restriction for the draw After the authorization system would extract the eligible certificate details based on the data provided Only active MC LMC will be considered for the draw All certificates that have been redeemed or cancelled will not be eligible for the draw An OBIEE report gets displayed with draw data based on this m
25. ennen teen eren ren een eene nne tne nren trennen 7 2 7 3 5 MC Monthly Provisioning ei Re aep Ee poen 7 2 7 3 6 ME Reversal f eds 7 3 7 3 7 EME TSSUGIC ia 7 3 7 3 8 EME Manua HIT PEE 7 3 7 3 9 EMG Cancellation cicciciictii ants asia 7 3 7 3 10 EMC Monthly Amortization i eiie vin taetaseeieiseadesiatvadestecuvtacesveviutaasasee ti stesdost baadessetsviecdavetins 7 4 LILLE EMC RA Dias 7 4 7 4 ADVICE PC liccUIaes 7 4 7 5 NOTIFICATION de 7 E 7 5 8 SCREEN GLOSSARY oeeccoceeeseeo eor a eoe exse uve eb Se Ue E Yea cob P Sn ENDS Ke UNE naaa aereas eV peu ERE 8 1 8 1 FUNCTION ID Titi dit 8 1 ORACLE 1 Millionaire Certificate MB 1 1 Introduction Millionaire Certificate MC is a savings and investment opportunity which offers a maximum returns of 1000 times the investment value and at the same time the customer s certificates are completely capital guaranteed and en cashable at any point in time Oracle FLEXCUBE Millionaire Certificate module MB module helps you to facilitate MC LMC transactions This module provide features to issue redeem partially redeem cancel and mark as lost or reissue certificates Certificates can be bought by cash or cheque or credit card Certificates can also be bought on lien by paying the interest amount 1 2 Audience This manual is intended for the following User User Roles Role Function Back
26. er reference number and would not create a CIF in the system The system generated customer reference number should then be mapped against the standard walk in CIF defined in the branch parameters 5 4 ORACLE Customer Details Customer Name Customer Short Name Party Type Individual Branch Code Address For Correspondence Geographic Address 1 Country Code Address 2 Nationality Address 3 Language Address 4 Unique Identifier Passport Details Name Passport Number Value Issue Date KYC Status M Expiry Date Charge Group You can maintain the following details of a walk in cutomer here Branch code gets dislayed Customer Name Specify the customer name Customer Short Name Specify a short name for the customer Party type Select the party type of the customer from the following drop down options e Individual e Corporate e Bank Address for Correspondence You can provide the customer address in the following fields e Address 1 e Address 2 e Address 3 e Address 4 Geographic You can provide the geographic information of the customer here Country Code Specify the country code of the customer 5 5 ORACLE Nationality Specify the nationality of the customer Language Specify the language of the customer for communication Unique Identifier You can provide the unique indentifier details of the customer here Name Specify the name of the unique identifier details of the customer Value Specify the
27. ference button from Millionaire Certificate Product Definition screen to invoke the preference screen Preferences Product Code Stock Code KYC Limit Renewal Grace Period LMC Eligibility Ratio 1010 C MC Start Number x MC End Number LMC Eligibility Ra You can specify the following values here Product Description Product Currency Certificate Value Certificate Number Mask LMC Price 10107 O LMC Start Number LMC End Number x Issuance Price Fi Product code and the description for the code get displayed here Stock Code Specify the stock code of pre printed MC stationary inventory It should be a valid code in inventory module Certificate Value displays the value of the associated MC product The denomination value associated with the selected stock code would be defaulted Renewal Grace Period Specify the grace period for LMC renewal manual rollover Grace period would be specified as number of calendar days You can renew the LMC only after the maturity date e Ifthe LMC contract is not renewed before the grace period then EOD batch would Close the LMC contract e If LMC contract is renewed Event ROLL before the grace period then system would increase the maturity value of the contract by a year Ts ORACLE e LMC contracts in grace period which are yet to be renewed are not eligible to participate in the draw Certificate Number Mask Specify the mask for cert
28. ificate numbers Typical Certificate Number Mask would be bbbnnnnnnn where bbb would represent the branch code and n would represent the numeric character Product currency Specify the currency associated with the product certificate value issuance price for LMC Currency code should be the LCY code KYC Verification Limit Specify the limit for KYC verification After the MC issuance to customers if the cumulative value of MC held by the customer including the current contract and by considering all the mapped customer reference number exceeds this limit then system validates the KYC compliance of the CIF LMC Eligibility Ratio Specify the following details to calculate LMC eligibility ratio for a given range of MC held by the customers Based on the number of MC held by the customers system computes the maximum number of LMC that can be held by the customer Any decimal fractional output will be truncated in deriving the maximum eligible LMC LMC Price Specify the following details to maintain the issuance price for a given range of LMC issued to the customers T4 ORACLE 4 1 3 Specifying Charges ICCF for a Product Charge Details Product Code Product Description Component Details 4 100ta1 gt Stop Association Propagation Required Default From Class Component Description Charge Type Debit Credit Third Party Type Add Subtract Net Consideration SWIFT Qualifier Advice Charge Event Details
29. ld involve the following two numbers e Certificate number a ten digit number with branch code followed by running sequence number e Control key serial number unique number printed on the stationary instrument and would be used to authenticate the issued certificates Inventory management module would be used to track the instrument identified by the control numbers 2 4 ORACLE 3 1 3 Maintenances Introduction As part of enabling and using the Millionaire Certificates MB module of Oracle FLEXCUBE there are several maintenances to be performed These maintenances have been elaborated upon in the sections given below Unless specified otherwise all maintenances specified below allow all standard maintenance functions Add Modify Delete Authorize Close Re open and Inquiry The maintenance functions also log all maintenances in the Audit Trail The common maintenance related to Millionaire Certificate transactions are maintained in the following screens e Function ID CSDDEMAN under the heading Maintaining Currency Denomination Details in CS module e Function ID IVDSTKCD under the heading Stock Catalog Definition in Instruments Inventory Tracking IV module e Function ID IVDTXNAS under the heading Adjust Inventory Balance in Instruments Inventory Tracking IV module 3 1 1 Maintaining Pay in Parameter Details You can maintain the general ledger code for each product b
30. llation including partial cancellation and re issuance are handled as different stages events of a contract Inventory module is used to track the flow of inventory from head office to various branches It also tracks the status of the instrument MC contracts can be used as collateral to a liability in the collateral maintenance screen in the ELCM module MC contract is then blocked to the extent of collateralized amount MC LMC Customers All customers of MC LMC including customers credit card holders of your bank and walk in customers credit card holders are CIF in Oracle FLEXCUBE Each type of MC customers are created with different charge groups to facilitate differential charging if any For new walk in customers during MC issuance you can record the basic details of the customer in Customer details section of MC contract issuance screen These details are stored against the customer reference number and would not create a CIF in the system The system generated customer reference number would then be mapped against the standard walk in CIF defined in the branch parameters Upon fresh first time purchase of MC by CIF system dynamically generates the customer reference number and associates it to the CIF This reference number would be a ten digit number branch code followed by running sequence number System would not validate the MC customers based on customer nationality visa details age Instrument Numbering MC LMC wou
31. mary of monthly provision details through the Product Definition Summary Screen To invoke the Product Definition Summary screen enter MBSPRMNT in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button Summary Authorization Status Record Status Product Code Las Product Type pc Advanced Search Records per pagez 15 w poto 1 Authorization Status Record Status Product Code Product Type KYC Limit You can query the contract records with the following details Authorization Status Record Status Product code Product Type Click search button to view the records with the specified values 4 6 Certificate Val ORACLE 5 1 5 2 5 Processing MB Contract Introduction An MC LMC contract is an instruction wherein a customer requests the bank to issue a Millionaire Certificate Certificate issuance encashment lost partial re issue cancellation and re issuance are handled as different stages or events of a contract Capturing Millionaire Certificate Contract Details You can input MC LMC contract in the Millionaire Certificate Contract Input screen For walk in customers during MC issuance you can record the basic details of the customer in Customer details section of MC contract issuance screen These details are stored against the customer reference number without creating a CIF in the sys
32. ndable and unearned interest is transferred to earned GL Draw Procedure A member from the Economic Panel would be part of the draw This is generally conducted in a Mall or a Beach or an open place where public gathering generally happens The Lottery happens through a throw of dice corresponding to the Units place hundreds place etc considering the total number of reference active deposits in consideration Currently the Bank is getting the sequence reference no through the lot and then contacting the customer support centre to ensure that the deposit is active Oracle FLEXCUBE provides the reference number and the corresponding certificate number immediately instead of using the manual process Scope of the Module The MB module comprises the following high level functions Product Definition Contract Input Pay in Parameter Maintenance Monthly Provision Maintenance Draw Parameter Maintenance Factory shipped report is only for a single report for draw data Advices is only to provide advice field tags 2 3 ORACLE 2 6 2 6 1 2 6 2 2 6 3 MB Module Functions amp Features The following sections give you a brief overview of the MB module s various functions and features Flexible Parameters Definition Parameters Definition for millionaire certificate product associated charges accounting entries and preferences are completely user defined and flexible Certificate issuance encashment cance
33. nt Amount tag Description Ind tag REVR LMC ASSET GL Dr CERT AMT Certificate value Negative Amount REVR LMC LIAB GL Cr CERT AMT No of certificates Negative Amount REVR MC CUST AC GL Dr INT AMT Issuance price Negative Amount REVR LMC ADV INT GL Cr INT AMT No of LMC issued Negative Amount 7 4 Advices System supports the below mentioned advices Event Advice Advice Name Description Supported Field Tags Field Tag Description INIT RIMC WIMC MB ISSUE Millionaire Certificate Issuance CUST NAME1 Customer Name BRANCH NAME Branch Name BOOK DATE Booking Date VALUE DATE Value Date ORIGINAL PURCHASE DATE Original Purchase Date CERT START NUM Certificate Start Number CERT END NUM Certificate End Number NUM CERT Number of Certificates CERT AMT Certificate Amount 74 ORACLE Event Advice Name Advice Description Supported Field Tags Field Tag Description CONTROL NUM Control Number CONTRACT REF NO Contract Reference Number 7 5 Notification System supports gateway notification for the below mentioned events Event Code Event Description INIT MC LMC Issuance RIMC MC LMC Re issuance WIMC MC Issuance to winners LIQD MC LMC Liquidation ROLL LMC rollover 7 5 ORACLE
34. nt is held e Reversal of MC contracts is allowed only if it has not undergone liquidation reissuance and it should not be linked to any LMC contracts e Reversal of LMC contracts is allowed only if it has not undergone cancellation rollover reissuance monthly interest amortization In such reversals the accounting entries are reversed to refund the interest collected e During the reversal of MC contract REVR entry gets fired and it reverses the INIT accounting entry 5 2 4 Viewing Millionaire Certificate Contract Summary You can view the summary of millionaire certificate contracts through the Millionaire Certificate Contract Summary screen To invoke the Millionaire Certificate Contract Summary screen enter MBSTRONL in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button 5 7 ORACLE Summary Product Code Contract Status Source Reference Contract Reference Currency Source Code FLEXCUBE Auth Status Sodmoosearch AM Advanced Search coco Records per page 15 w i4 1 gof 1 bl Contract Reference Product Code Currency Contract Status Source Code Source Refen You can query the contract records with the following details e Contract Reference e Product Code e Currency e Contract Status e Source Code e Source Reference e Authorization Status Click search button to view the records with the specified values 5 2 5 Querying Customer B
35. o be selected as the default reference number for the CIF 6 1 Introduction 6 Payment This chapter elaborates upon the operations which can be performed using the function present as part of the Millionaire Certificate MB module of Oracle FLEXCUBE These operations have been elaborated upon in the sections given below 6 1 1 Millionaire Certificate Payment Details You can liquidate or cancel the Millionaire Certificates or Lien Millionaire Certificates using the Millionaire Certificate Payment Input screen System allows you to perform partial liquidation for MC contracts also using the same screen To invoke the Millionaire Certificate Payment Input screen enter MBDTRPAY in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button Millionaire Certificate Payment Input Version T Number 10 A Contract Details Product Code Transaction Type Liquidate Active Certificates Contract Reference No of Certificate to Liquidate Other Details User Reference Currency Value Date Customer Reference Control Number Liquidated Certificate Amount Charge Group Product Description Customer No Pay In Option Cash Source Code FLEXCUBE Source Reference Issuance Price Book Date Maturity Date Account No GL Code LMC Control No Certificate Details Denomination Details Maker Checker Date Time Status Authorization Status
36. om pay in parameter maintenance e For pay in option as account transfer specify the customer account number linked to the selected CIF System would support only LCY accounts e For pay in option as Other GL specify the GL code from which the contract value should be debited This option is allowed only if the Transaction Type is selected as Issue to Winners The original purchase purchase issue date of the certificates gets displayed Remarks Specify any additional remarks or information for the contract Charge Group While selecting the CIF system defaults the associated charge group You can modify the charge group of the contract Denomination Details For cash payment you can maintain denomination details You should operationally maintain appropriate denomination details for the amount settled across counter which system does not validate 5 3 ORACLE Denomination Details Denomination Details 1010 C Denomination Code Denomination Value Units Total Amount Currency Total Amount Denomination Code Specify the denomination code for the currency Denomination Value Specify the value of the denomination Units Specify the units of the denomination Currency and the total amount get displayed here 5 2 2 Customer Details For new walk in customers during MC issuance you can record the basic details of the customer in this section These details are stored against the custom
37. ranch and pay in option viz by cash cheque and credit card in the Pay in parameter Maintenance screen from the head office level To invoke the Pay in parameter Maintenance screen enter MBDMBPAY in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button 3 1 ORACLE L Pay in Parameter Maintenance Product Code Product Description Branch Code General Ledger Code Pay In Cash Maker Date Time Checker Date Time Record Status Authorization Status You can maintain the following details here Product Code Specify the MC product code for which you are maintaining the details The description for the specified product gets displayed in the adjacent field Branch Code Specify the branch code where the product MC product is issued Pay in Option Select a valid paying option from the drop down list The values are e Cash e Cheque e Credit card General ledger code Specify the GL code for the selected pay in option MC issuance through cheque and credit card is a deposit in teller module to the specified GL codes MC issuance through cash would impact the till in teller module and update the specified cash GL During MC issuance based on the pay in option these GL codes would be used for further processing Viewing Pay in Parameter Details Summary You can view the summary of monthly provision details through the Pay in Parameter Summary
38. rtificate Product Definition Product Code Product Description Product Type Millionaire Certificate Lien Millionaire Certificate Start Date End Date Remarks Maker Date Time Checker Date Time Record Status Authorization Status You can specify all attributes related to MB product here The buttons on this screen are explained below Buttons Description Accounting Click this button to define the accounting role to accounting head Roles mapping 4 1 ORACLE Buttons Description Events Click this button to select the events for the product and then maintain event wise accounting entries and advices Branch Click this button to maintain the list of allowed disallowed branches for the product Customer Click this button to maintain the list of allowed disallowed customers customer categories Preferences Click this button to define preferences of the product Charges Click this button to define charge components rules events and other associated details Fields Click this button to provide values for the UDFs associated with the Screen For any product you create in Oracle FLEXCUBE you can define generic attributes such as branch currency and customer restrictions interest details tax details etc by clicking on the appropriate icon in the horizontal array of icons in this screen Product Code Specify the code you assign to a product which is used
39. s 3 1 5 Maintaining Draw Parameter Details You can maintain the data file extraction details in the Draw parameter Maintenance screen from the head office level 3 5 ORACLE To invoke the Draw parameter Maintenance screen enter MBDDRMNT in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button Draw Parameter Definition New Draw Reference Number Cutoff Date Min No of MC Product Restriction Allowed Branch Restriction Allowed Certificate Restriction Allowed Disallowed Disallowed Disallowed Product List Branch List Certificate List 10710 1010 1010 Certificate Number Product Code O O n O Product Code Product Description O Branch Code Branch Description Maker Date Time Mod No Checker Record Status Date Time Authorization Status You can maintain the following details here A unique draw reference number gets displayed here Cut off date Specify the cut off date for the draw All active certificates with value date lesser than the specified cut off date are eligible to participate in the draw Min No of MC Specify the Minimum number of MC If the number of MC held by the customer including all mapped to customer reference number is less than this specified quantity then the customer is not eligible to participate in the draw Product Restrictions Indicate the restriction for the product during the draw You can sel
40. t No of Days in Year No Of days passed by No of days in a month In the month when LMC is issued the no of days for the above calculations is from date of issuance till month end and in the last month i e 12th month the total unamortized amount would be amortized System triggers the LMCA event to post accounting entries for monthly amortization amount On the maturity date of LMC this EOD batch marks the LMC status as Pending renewal LMC with Pending Renewal status are not eligible to participate in the draw If the LMC contract is not renewed before the grace period then this EOD batch would Close the LMC contract 3 8 ORACLE 4 Defining Product Attributes 4 1 Introduction In this chapter we shall discuss the manner in which you can define attributes specific to a MB Product In the product definition you can specify basic information associated accounting roles events branches customers restrictions charges product preferences MIS 8 UDF Separate products are created for millionaire certificate and lien millionaire certificate 4 1 1 Capturing Millionaire Certificate Product Details You can maintain the MB product definition in the Millionaire Certificate Product Definition screen To invoke the Monthly Provision Maintenance screen enter MBDPRMNT in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button ES Millionaire Ce
41. tem The system generated customer reference number is then be mapped against the standard walk in CIF defined in the branch parameters To invoke the Millionaire Certificate Contract Input screen enter MBDTRONL in the field at the top right corner of the Application Toolbar and then click the adjoining arrow button Millionaire Certificate Contract Input Version Number 4 Contract Details Product Code Product Description Transaction Type Customer No No of Certificates Pay In Option Charge Group Other Details Contract Reference Source Code FLEXCUBE User Reference Source Reference Currency Issuance Price Value Date Book Date Certificate Amount Maturity Date Customer Reference Account No GL Code Control Number Original Purchase Date Remarks Certificate Details Denomination Details Customer Details Maker Date Time Status Authorization Status Checker Date Time The system generated contract reference number gets displayed in the screen You can specify the following details here Product Code Specify the millionaire certificate product to be used in the contract The product description gets displayed in the adjacent field Customer No Specify the CIF number of the customer Customer Reference Number mapped to the selected customer gets displayed 5 1 ORACLE For new walk in customers you have to select the standard walk in customer id as maintained in the branch parameters Ad
42. ten 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 Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this 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
43. the contract For LMC issuance maturity date is computed as value date one year Upon rollover of LMC maturity date gets incremented by a year For MC contract maturity date would be blank null No of Certificates Specify the number of certificates participating in the specified transaction type The MC certificate value or LMC issuance price gets displayed as Issuance Price 5 2 ORACLE 5 2 1 While saving the issuance price for MC LMC is defaulted by the system LMC issuance price is derived based on the number of liened certificates requested in the contract and LMC pricing maintained in product definition Control Number Specify the control number of pre printed stationary instrument which should be a valid stock number as maintained through Adjust Inventory Balance MC Branch to User For contracts initiated from FCDB source system would not allow to track control number The computed contract value based on the number of certificates and issuance price gets displayed in the Amount Pay in option Select the pay option from the drop down list The options are e Cash cash GL of the current branch gets impacted e Cheque e Account transfer system allows only LCY accounts to be selected e Credit card e Other GL Account No GL code Specify the GL code from which the contract value should be debited If the GL code is not selected then while saving system would default the relevant GL code fr