Management Information System User Manual
Contents
1. Input By Authorized By Modification Number Authorized Open Date Time Date Time If you are creating a new MIS Class select New from the Actions Menu in the Application toolbar or click new icon The MIS Class Maintenance screen is displayed without any details If you are calling an MIS Class that has already been defined double click on an MIS Class from the summary screen 2 2 MIS Type The most basic attribute of an MIS class is the type of its class An MIS class can belong to one of the following types e Transaction Class e Customer Class e Composite Class e Fund Class e Allocation Class oe ORACLE The MIS type helps you classify your reporting based on either a customer or a transaction An MIS Class belonging to the Customer class type helps you generate your profitability for a customer Similarly MIS Class belonging to the Transaction class type helps you generate your profitability report based on transactions A Composite class type as the name indicates would help you group a Customer and Transaction type classes Choose an MIS Type for an MIS Class using the option button beside it Transaction Class A Cost Center would be a typical transaction type of MIS class For a cost center you would want to generate reports for the kind of costs incurred for processing a transaction For example short term loans may be a cost center For this cost center you c2. TransactionCode All Module Code All Specific Specific From Date To Date Report Format PrinterAt Client v Report Output Printer You can specify the following parameters here Source Code Select source code for which you want to generate the report from the options The following options are available for selection e All Select if you want to generate the report for all the source codes 9 7 ORACLE e Specific Select if you want to generate the report for a specific code If you have selected specific specify a valid source code for which you want to generate the report from the adjoining option list Branch Code Select Branch code for which you want to generate the report from the options The following options are available for selection e All Select if you want to generate the report for all the branch codes e Specific Select if you want to generate the report for a specific code If you have selected specific specify a valid branch code for which you want to generate the report from the adjoining option list Transaction Code Select transaction code for which you want to generate the report from the options The following options are available for selection e All Select if you want to generate the report for all the transaction codes e Specific Select if you want to generate the report for a speci
3. Branch Code Select the branch code from the option list The system generates the report of maturity profile for next week for the selected branch Specify the report options and click OK button to generate the report 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 of the report contains the title of the report branch code branch name branch date User ID of the user who generated the report module code run date and time of the report and the page number of the report 9 12 ORACLE 9 5 Body of the Report The following details are displayed as body of the generated report Field Name Field Description Module The code that identifies the module Branch The branch code and the name of the branch Product Code Account The product code if the details are displayed for a Name Customer CIF Class contract or the account class if the details are displayed for an account Description The description of the product code if the details are Product Account displayed for a contract or the description of account class if the details are displayed for an account Customer The customer s name and customer number Booking Date Origination Date The booking date of the contract if the details are displayed for a contract or the origination date of th
4. Maturity Profile for Next Day GLDCLSMT MIS Class Maintenance MIDADJ MIS Adjustment Maintenance MIDCCODE MIS Cost Code Maintenance MIDGRPMT MIS Group Maintenance MIDHEAD MIS Head Maintenance MIDPOOLD MIS Pool Code Maintenance MIDREFRT MIS Refinance Rate Input MIRPRLO Management Information System Profit amp Loss Report MIRREFRT Pool Codes Report 10 1 ORACLE ORACLE Management Information System December 2012 Version 12 0 1 0 0 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashira 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2012 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 Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shal
5. defining the product MIS Details Product Code MIS Group Pool Code Default Frorn MIS Group MIS Classes Cost Code 10710 Fi MIS Class MIS Code 8 2 3 Specifying the MIS Details for an Account Class and a Product The MIS details you would define for an account class and a product are similar You should specify the following MIS Group The MIS Group to which the account class or product should be linked is specified in the MIS Group field if it is applicable if not you can define the individual entities under which the product or account class should be reviewed If a group is linked the entities defined for the group will be displayed and these entities can be changed Only the transaction type of MIS Class will be applicable for an account class or product The specific MIS entity in the form of an MIS Code will be picked up by default only if you have defined them for the group If not you have to indicate the appropriate MIS code for each applicable MIS classes Link to Group If an MIS Group is linked you can indicate whether the linkage with the group should always be maintained If yes any change done to the MIS Group will automatically be applied to the account class or product to which the MIS Group is linked If not the entities defaulted for the account class or product will be continued even if they are changed subsequently for the group oF ORACLE Default from MIS Group The det
6. Accounts Officer Similarly Short Term Loans Incoming Bills and Import Letters of Credit will have an MIS Code each under the MIS Class Cost Center The same concept applies to Industry Segments also An MIS Code is added on to an MIS Class either through the New operation on the MIS Class screen or through the Amend option on an existing MIS Class record Once an MIS Class has been stored you can add MIS Codes to it by unlocking the MIS Class record and adding the required MIS Code The MIS Code list contains the MIS Codes attached to the selected MIS Class To add a new record to the MIS Code list click add icon an ORACLE To delete an MIS Code s from the list choose the MIS code s using the checkbox next to it and then click delete icon 2 2 2 Operations on the MIS Class Record On an existing MIS Class record you can perform the following operations if any function under the Actions Menu is disabled it means that the function is not allowed for the record e Amend the details of an MIS Class e Authorize an MIS Class e Copy the details of an MIS Class on to a new one e Print the details of an MIS Class e Delete an MIS Class Please refer to the manual on common procedures for details of these operations ORACLE 3 Defining MIS Cost Codes 3 1 Introduction An MIS cost code represents the notional cost incurred for a transaction An MIS cost code can be attached either to an accoun
7. Code New MIS Code GL MIS Balance Transfers due to Reclassification When an MIS reclassification occurs in respect of a customer account or contract the balances in a GL associated with the old MIS code in each case are transferred to the GL for the new MIS code if the option of transferring MIS balances upon reclassification has been set in the Chart of Accounts for the GL A batch process executes a GL MIS balance transfer upon MIS reclassification for those GLs for which the balance transfer option has been set The transfer is performed taking into account the details stored in the change logs Customer MIS Change Log Account MIS Change Log or Contract MIS Change Log When the transfer is performed the transfer details are stored in the MIS Balance Transfer Log The following details relating to the transfer are stored e Branch e GL e Period Code e Financial Cycle e Currency e Reference Type e Reference Number Account Contract Customer Number e MIS Class e Old MIS Code e New MIS Code ii ORACLE e Transfer Indicator Dr or Cr into New MIS Code e Amount e Transaction Date You can view the MIS Balance Transfer Log for a customer customer account or contract by clicking on Transfer Log button in the Customer MIS Customer Account MIS or Transaction MIS Maintenance screens Balance Transfer Log Account Balance Transfer Log Details 1010 C Branch Code ProductCode Financial Year Tran
8. From This indicates holding from Closing Security Balance This indicates closing security balance Position Reference This indicates the position reference ORACLE 9 2 2 Invoking the Pool Codes Report Screen You can invoke the screen by typing the code MIRREFRT on the field at the top right corner of the Application tool bar and click on the adjoining arrow button Pool Codes Report Pool Code From Currency Year Pool Code To Currency Year ReportFormat PDF PrinterAt Client v Report Output Print v Printer From Pool Code Specify the pool code Select the appropriate one from the option list From Currency Specify the currency code Select the appropriate one from the option list Year Specify the year Select the appropriate one from the option list To Pool Code Specify the pool code Select the appropriate one from the option list To Currency Specify the currency code Select the appropriate one from the option list Year Specify the year Select the appropriate one from the option list 9 4 ORACLE 9 2 2 1 Contents of the Report The contents of this report have been discussed under the following heads Header The Header carries the title of the report branch code branch date user ID module from which the report has been generated date and time at which the report has been generated and
9. Officer that is picked up by default Allocation Class You may want to view details of the expenses incurred by your bank To do this you can maintain Allocation Classes by which you can allocate the various expenses to different entities within your bank For instance let us assume that your organization has over 2000 employees spread across four different locations Delhi Mumbai Chennai and Calcutta in India You would like to have a location wise break up of the salary amount disbursed to each of these locations Additionally you would also like to view a break up of balances for individual departments within each location an ORACLE 2 2 1 To meet these requirements in Oracle FLEXCUBE firstly define an MIS Class called Locations All the four location of your organization Delhi Mumbai Chennai Calcutta will be created as MIS Codes under this MIS Class Similarly create another MIS Class called Departments All the departments within your organization Administration Financial Control Products Division IT Solutions etc will be created as MIS Codes under this MIS Class Consequently details of salary expenses incurred across locations will be available under the MIS Class called Locations The department wise salary disbursement details will be available under the MIS Class called Departments Both these MIS classes will be of the Allocation Class type Fund Class Your bank may float a number of funds like Mutua
10. in which case the applicable MIS class should be specified Pool Code Report A pool code report can be generated for a specific pool code A pool code report can further be sorted on any of the following e Account class e Customer e Customer category e MlS class e Product Indicate the sort parameter by highlighting the applicable option This selection will enable to generate the profitability report based on one of the five parameters given below Thus the following reports for a pool code can be generated e Account class profitability report e Customer profitability report e Customer category profitability report e MIS Class profitability report 9 1 ORACLE e Product profitability report Error Report Error reports are generated for details of errors specific to each function and the corresponding unit reference number Specifying the period of reporting Any type of report has to be generated for a specific period You should indicate the period for which the report should be generated by specifying the year and the From and To months 9 2 Invoking the Report Options Screen The different report options are detailed below You can invoke the screen by typing the code MIRPRLO on the field at the top right corner of the Application tool bar and click on the adjoining arrow button Management Information System Profit amp Loss Report From Date Year To Date Year Report For Report For Othe
11. linked the entities defined for the group will be displayed and these entities can be changed Only the Customer and Composite type of MIS Classes will be applicable for customers The specific MIS entity in the form of an MIS Code will be picked up by default only if you have defined them for the group If not you have to indicate the appropriate MIS code for each applicable MIS class Bl ORACLE Link to Group If an MIS Group is linked you can indicate whether the linkage with the group should always be maintained If yes any change to the MIS Group will automatically apply to the customer to whom the MIS Group is linked If not the entities defaulted for the customer will continue even if they are changed subsequently for the group Customer MIS Code and Composite MIS Code The details defined for a customer will be defaulted whenever a contract a loan deposit funds transfer letter of credit bill etc is processed for the customer The details of the customer and composite class of entities will be picked up by default These entities are defaulted even when you are opening an account for the customer Change Log If MIS reclassification occurs through changing the MIS codes for the Customer Type of MIS classes the system stores the changes made in a Customer MIS Change Log screen Click Change Log button in the Customer MIS screen to view the Customer MIS Change log Customer Code Customer Change
12. spool the report to a specified folder so that you can print it later Printer At Select location where you wish to print the report from the adjoining drop down list This list displays the following values e Client Select if you need to print at the client location e Server Select if you need to print at the server location Printer Select printer using which you wish to print the report from the adjoining option list 9 2 5 Contents of the Report The parameters specified while generating the report are printed at the beginning of the report Other content displayed in the Transaction Force Debit Report is as follows Header The following details are displayed in the header section Field Name Field Description Report Name Indicates Report Name Bank Code Bank Name Indicates Bank code and Bank Name Branch Code Branch Name Indicates Current Branch code and Branch Name Report Run Date Indicates Current Branch Date Report Run Time Indicates Current Branch Time User ID Indicates User ID of the user generating the report From Date Indicates Start date 9 9 ORACLE Field Name Field Description To Date Indicates End date Branch Currency Indicates Branch Currency Body of the Report The following details are displayed as body of the generated report Field Name Field Description Source Indicates Transaction source FLEXCUBE F
13. E A S RONE OE a RE 9 14 10 SCREEN GLOSSARY 0 0 teccsscccsseescenssccnsecsesesesssssnsssseneesesscessesssnesssenessssnessosssessssssenessessossossessosees 10 1 HOG HWNCTION TD LIS Tersi eaer Ae a AE E ies dus esta sto aegscs ts ie EA A AS 10 1 ORACLE 1 About this Manual 1 1 Introduction This manual is designed to give you an understanding of the Management Information System module of Oracle FLEXCUBE Apart from assisting you in generating reports this manual guides you in the definition and maintenance of MIS classes and cost codes MIS groups MIS heads MIS pools and refinancing rates You are also taught how to define MIS details for a customer an account class a product and a contract 1 2 Audience This manual is intended for the Customer Service Representatives CSRs and the bank staff in charge of setting up new products in your bank 1 3 Organization This manual is organized as follows Chapter 1 About this Manual gives information on the intended audience It also lists the various chapters covered in this User Manual Chapter 2 Defining MIS Class Code describes how to define MIS classes and link them to several entities Chapter 3 Defining MIS Cost Codes explains the procedure for defining and maintaining MIS cost codes Chapter 4 Defining an MIS Group describes in detail how the definition of an MIS group simplifies the process of associating an account product or a transaction to severa
14. LEXBRANCH FRCH or External system code Branch Code Indicates the branch code Transaction Type Indicates Module Code and Event Transaction Reference Number Indicates e Contract reference number for transactions in FT LC BC LD MM FT FX DL PC DE CG RT e Account Number for CL Transaction Code Indicates Transaction Code Transaction Description Indicates Transaction Description Module Indicates Module code Account Number Indicates Account which is debited beyond the available balance of the account Transaction Date Indicates Transaction Date will be in the date range Value Date Value date Transaction Currency Transaction currency Dr Cr Debit Credit Indicator Transaction Dr Amount Transaction Amount in transaction currency Transaction Cr Amount Transaction Amount in transaction currency Footer of the Report The following details are displayed as footer of the generated report Field Name Field Description 9 10 ORACLE 9 3 9 3 1 Field Name Field Description Total Debit Amount Indicates Total Debit Amount Total Credit Amount Indicates Total Credit Amount Inter Branch Reconciliation Report You can generate this report using Inter Branch Recon Report screen To invoke the screen type CORINTBR in the field at the top right corner of the application toolbar a
15. Log 1010 MIS Class Transaction Date Old MIS Code New MIS Code m li The following details are stored in the Customer MIS Change Log for the customer in respect of which the MIS reclassification occurred e Customer Number e MIS Class that was changed e Date on which the change was made e The old code for the changed MIS Class this information is stored only for the first amendment during a day e The new MIS code for the changed MIS class oe ORACLE 8 2 MIS Details for an Account Class and a Product The MIS details for an account class and a product are defined in a similar manner The procedures involved in defining the MIS details for an account class and a product are described below 8 2 1 Invoking the MIS Details Screen for an Account Class The MIS details screen for an account class can be invoked by clicking on the MIS button while defining the account class MIS Details Account Class MIS Group Pool Code 8 Link To Group Transaction MIS MIS Class 1 MIS Code 1 Cost Code 1 MIS Class 2 MIS Code 2 Cost Code 2 MIS Class 3 MIS Code 3 Cost Code 3 MIS Class 4 MIS Code 4 Cost Code 4 MIS Class 5 MIS Code 5 Cost Code 5 MIS Class 6 MIS Code 6 MIS Class 7 MIS Code 7 MIS Class 8 MIS Code 8 MIS Class 9 MIS Code 9 MIS Class 10 MIS Code 10 s4 ORACLE 8 2 2 Invoking the MIS Details Screen for a Product The MIS Details screen for a product can be invoked by clicking on the MIS button while
16. MIS Head screen is displayed without any details If you are calling an MIS Head that has already been defined double click an MIS Head from the summary screen Category The MIS Head Category classification indicates the method in which the accounting entry will be reported in the profitability report It could be one of the following ORACLE 5 1 4 Balance Indicates that the accounting entry should be considered for calculating the Cumulative Average Balance Typically an asset entry would be classified under the balance type MIS Head The GL entry leg of a loan disbursement transaction would typically be classified under a Balance type of MIS Head Income Indicates that the accounting entry should be considered as an income for the purpose of profitability reporting Clearly any interest or charge income would be classified under an Income type of MIS Head Expense Indicates that the accounting entry should be considered as an expense for the purpose of profitability reporting Any interest postage or tax expense would be classified under an expense type of MIS Head Contingent Indicates that the accounting entry should be considered as a contingent entry for the purpose of profitability reporting A forward FX deal the issue of an import Letter of Credit etc are examples of contingent type of entries You can generate a report that gives the balances due to such contingent type of entries Under each type
17. Management Information System Oracle FLEXCUBE Universal Banking Release 12 0 1 0 0 December 2012 Oracle Part Number E51465 01 ORACLE FINANCIAL SERVICES ORACLE Management Information System Table of Contents 1 ABOUT THIS MANUAL ju cccccescscssccssencsscsssscsesssnsesssnessssnessessesssssssnsssssnessssnessesssssessosenesssssessessessosenese 1 1 1 1 INTRODUCTION N E ctie les A E A sans 2idovestts E A E 1 1 L2 AUDIENCE eetas Eene eE E Ees REEE E EEEE eS e EAEE Ee E e DOES Ero a AEAEE SEE 1 1 L ORGANIZATION eTA ENEE ER TOR 1 1 Le GLOSSARY O CON e Sees a AI AE EER 1 2 1 4 1 R lated Documents ooieoe niai E E E E EA 1 2 2 DEFINING MIS CLASS CODES escsssssssscsssccnsssescscsnesssensssssnesesssssssssssnsssssscesesssssessssssessesnessossessosees 2 1 2 1 INTRODUCTION 6005503 sssssecscsecsscsscsnsececssesacsscsueedecunesd osiguncsvecstesectavedgs ceutes saesteness wosedu dectesbdsace E 2 1 2 1 1 Invoking th MIS Class Seret c ssicicssussices rase EE E E A ES 2 2 X2 MIS TYPE oneer ieg eeen aiaia E AE E EE E E E R E OE EA EO RE ERNES 2 2 2 2 1 MIS Colerain a a E E anes vous sasa deep ingavadp EE oagateas Guat sapcastegui EE sayees 2 4 2 2 2 Operations on the MIS Class ReCOrd csccesccesccsseesseesseeseseseeeeeeecesecesecaecaecsaecaaecaaeeseesseesaeeeeeeeeeeaees 2 5 3 DEFINING MIS COST CODES cssscsssssssesssscssecessscssscsssnssscsnesessssssssssensssseseesosssssssssssessesneesosssesosees 3 1 3 1 INT
18. RODUCTION sec3 25505555 sd sso E a E E E AEE AE EE E E E RE EENE 3 1 3 1 1 Invoking the MIS Cost Codes SCreen ccsccccccsccssscesscesecesecssecuseeseeeseesseesseeseeseesseceaecsecaecaaeenaeeaaeeaeees 3 1 3 132 TVD E E E tucbevedvadena bee E E tue estugdasespiecbaseddedd E E 3 2 3 1 3 COST aS segs R a E wah E ER E E E D E E A A 3 3 3 1 4 PeriOdichty csiacioncenceesvins Gniansie ceeins costiansnenveivadassvocsepantivent asians ENAERE NENEK NERE EEEE EE 3 3 3 1 5 Operations on the MIS Cost Code ReCOrd cccccsccseccesscesscesecesecusecueeeseeeaeeeseeeseeeaseeeeeeeeeaeenasensesaeaas 3 3 4 DEFINING AN MIS GROUP sscssssscsssessscssscccesssescssssesessnesscsnessessssenesessnessesnessessssnssesssesssssossesssssoeees 4 1 4 1 INTRODUCTION csssssvesehsdensvesestebecsnsenseusesebbeststnrsentvatebettednstnatison sviscnebensuepetestenne sesiganst spss aaa E e ESTE ESR 4 1 4 1 1 Invoking the MIS Group SCLC 15 2 dcssieesnessesdeescisidacvessectoosiendeguedgudeensissseensepedaserionsvannasndbassdptabeadages 4 2 4 1 2 Operations on the MIS Group Record ccecceecceeseeesceescesecusecusecasecaeecaeeeaeeeseeeaeeeeeeeeeeeeeaeenaeenseeaeeaas 4 3 4 1 3 MIS COSCON Ba os ssscegareauctosesicessestiecsonsionsvathasuseeyscsiescssnseshetbandnessanaceavedstesvosapecteptduntenbiasndesnesybesacndess 4 3 4 1 4 Feature ID MGIntenance k rrine one O E S EER EN EEE E EEEO EEn ETa 4 3 5 DEFINING MIS HEADS 00 ss essssscccecscescscsnesessnessccesssscss
19. TMENTS FOR A POOL eeeesesessesesereeeerosoesesecesoeroroeseeesceooroeoeseseeoesororseseeesoesosoeseeeeeee 7 1 7 1 INTRODUCTION E E E E 7 1 7 1 1 Invoking the MIS Adjustments Screen sccccccsccssccescesecesecesecuseeseessesseeeseesseeeeeesecesecnsecaecaaeenaeeaeeeasees 7 2 7 1 2 Operations on the MIS Adjustments SCreen sccscccsccesseesseesseesseeeceeecesecusecsecaaecaeecseeeseeeseeeaeeseeeneenaees 7 3 ORACLE 8 DEFINING MIS DETAILS FOR A CUSTOMER ACCOUNT CLASS ACCOUNT PRODUCT AND CONTRACT WEEE E E T E A A E N E E E E O 8 1 8 1 DEFINING MIS DETAILS FOR A CUSTOMER scscsscsssssesssessssssscesecesesessavssssesensusesesessssevasasasesssescassesssossanes 8 1 8 2 MIS DETAILS FOR AN ACCOUNT CLASS AND A PRODUCT ccccscsessseeesesseescesecesesecseesscnesesessesesesessueseeneeene 8 3 6 2 1 Invoking the MIS Details Screen for an Account Class 1 ceccescesseeseeseeseeeeeceeecnsecusecnsecaaeeseeseeeneees 8 3 6 2 2 Invoking the MIS Details Screen for a Product cccsccesccessceseenseesseeseeeseeseeeeccesecesecusecnaecaeesaeeaaeeneees 8 4 8 2 3 Specifying the MIS Details for an Account Class and a Product eseseseeeeeeeeeeeeseesrsreseeen 8 4 8 3 DEFINING MIS DETAILS FOR AN ACCOUNT OR CONTRACT ccccsesssssescsseescssecesesecseesecesesessesesesesseseesneeenes 8 5 6 3 1 Invoking the MIS Details Screen for a CONtHACE cesccesceseeeseeneesseeseesseeseeeseceecesecusecuaecaaeeaaesaeeeaeens 8 5 8 3 2 Invoking the MIS Deta
20. act MIS Change Log Branch Code Account Change Log Details 10710 C misclass Transaction Date OldMISCode New MIS Code ee ORACLE 8 3 2 Invoking the MIS Details Screen for an Account To invoke the Management Information System screen for an account click on the MIS button while opening or modifying the account e Management information System MIS Group Branch Code Calc Method Account Rate Type Spread Default MIS Group Pool Code Link to Group Account Level Rate Code Pool Code Reference Rate Transaction MIS Codes Cost Code Composite MIS Codes Change Log Transfer Log Change Log If MIS reclassification occurs through changing the MIS codes for the transaction or composite type of MIS classes for the customer account the system stores the changes made in an Account MIS Change Log The following details are stored in the Account MIS Change Log for the customer account in respect of which the MIS reclassification occurred Account Number Account Branch MIS Class that was changed Date on which the change was made The old code for the changed MIS Class this information is stored only for the first amendment during a day The new MIS code for the changed MIS class oe ORACLE 8 4 Click Change Log button in the Account MIS screen to view the Account MIS Change log Branch Code Account Change Log Details 10f10 C MIS Class Transaction Date Old MIS
21. adjustments screen Thus MIS adjustments can be done between two MIS Codes which belong to the same pool and MIS Class ORACLE 7 1 1 Invoking the MIS Adjustments Screen You can invoke the MIS Adjustment Maintenance screen by typing MIDADJ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button MIS Adjustment Maintenanc Reference Number Pool Code MIS Class MIS Head Currency Adjustment Details Debit MIS Code Credit MIS Code Adjustment Amount Time Details Year Month e January Ba Select New from the Actions Menu in the Application toolbar or click new icon to input the details of an adjustment The MIS Adjustments screen is displayed without any details You can input the following details of the adjustment e Reference Number e Pool Code e MIS Class e MIS Head e Currency Adjustment Details and Time Details You have to specify the following details while doing an adjustment e The pool code MIS Class and MIS Head under which you want to make the adjustment e The currency in which the adjustment amount is represented e The MIS Code from which the amount should be moved the debit MIS Code e The MIS Code to which the amount should be moved the credit MIS Code e The amount that has to be moved or adjusted i ORACLE
22. ails defined for an account class will default to account opened under the class The details defined for the product will be picked up for the contracts processed under it Pool Code The Pool Code to which the account class or product belongs should be defined 8 3 Defining MIS Details for an Account or Contract The MIS details you would define for an account class and a product are similar The entities defined for the customer will be picked up by default and these entities can be changed 8 3 1 Invoking the MIS Details Screen for a Contract To invoke the MIS details screen for a contract click on the MIS button while processing the contract Contract Reference Input Link To Group Rate At Rate Type Transaction MIS MIS Group Transaction MIS 1 Transaction MIS 2 Transaction MIS 3 Transaction MIS 4 Transaction MIS 5 Transaction MIS 6 Transaction MIS 7 Transaction MIS 8 Transaction MIS 9 Transaction MIS 10 MIS Group Related Reference Related Account Related Account Related Reference MIS Head Interest Method Pool Code Refinance Rate Contract Level Pool Code Composite MIS MIS Group Composite MIS 1 Composite MIS 2 Composite MIS 3 Composite MIS 4 Composite MIS 5 Composite MIS 6 Composite MIS 7 Composite MIS 8 Composite MIS 9 Composite MIS 10 Rate Code Spread Cost Code 1 Cost Code 2 Cost Code 3 Cost Code 4 Cost Code 5 Fund MIS Fund MIs 1 Fund MIS 2 Fund MIS 3 Fund MIS 4 F
23. an generate a report that gives the details of the cost of processing each transaction All the cost centers of your bank would ideally be the different departments of your bank like short term loans long term loans teller bills etc Each of these can be defined as MIS Codes and linked to it Customer Class You may want a profitability report based on the type of industry manufacturing agriculture mining financial institutions etc to which a customer belongs For achieving this you would define Industries as an MIS class and have various MIS codes linked to the class for each type of industry manufacturing agriculture mining financial institution etc This MIS class would be of Customer class type Composite Class A composite class is simply a combination of a customer and a transaction type of MIS class Typically an Accounts Officer would be handling several customers and you would want a report of the profitability of each customer Occasionally a customer may begin with one Accounts Officer and use a product or service that folds under some other Accounts Officer In such a requirement you work backwards and create an MIS Class called Accounts Officer All the accounts officers of your bank will be created as MIS Codes under this MIS Class When you are generating your profitability reports you can choose to get the figures for all the accounts officers or for a selected few Also you can change the Accounts
24. ance Rate Input screen by typing MIDREFRT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button MIS Refinance Rate input Branch Pool Code Description Currency Description i Year Debit Credit January July February August March September April October May November June December If you are creating MIS Pool Refinancing rates for a new pool select New from the Actions Menu in the Application toolbar or click new icon The MIS Pool Refinancing Rates screen is displayed without any details oe ORACLE If you are calling an existing MIS Pool Code double click on an MIS Pool Code from the summary screen Once the refinancing rates have been defined for a month for a Pool Code currency combination you should use the Amend option for maintenance screens to input the rates applicable for the subsequent months The rates for a month in the past can also be defined If the rates have not been defined for a specific month the latest rates available in the screen will be picked up For example you have defined rates for the months of January and February of the year 1998 You are in April now and there is no rate for March 1998 The rate defined for February 1998 being the latest available in the screen will be picked up f
25. anch code and the name of the branch Product Code Account The product code if the details are displayed for a Class contract or the account class if the details are displayed for an account Description The description of the product code if the details are Product Account displayed for a contract or the description of account class if the details are displayed for an account Customer The customer s name and customer number Name Customer CIF Booking The booking date of the contract if the details are 9 14 ORACLE Field Name Field Description Date Origination Date displayed for a contract or the origination date of the account if the details are displayed for an account Contract Reference Number Customer Account number The reference number of the contract if the details are displayed for a contract or the customer account number if the details are displayed for an account Tenor The tenor Original balance The original balance Outstanding balance The outstanding balance 9 15 ORACLE 10 Screen Glossary 10 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 Function ID Function Description ACRFCDR Transaction Force Debit Report CORINTBR Inter Branch Recon Report CORMNPRF Maturity Profile for Next Week CORMTPREF
26. any function under the Actions Menu is disabled it means that the function is not allowed for the record e Amend the details of an MIS Cost Code e Authorize an MIS Cost Code e Copy the details an MIS Cost Code on to a new one e Print the details of an MIS Cost Code e Delete an MIS Cost Code Please refer to the manual on Common Procedures for details of these operations ae ORACLE 4 1 4 Defining an MIS Group Introduction The definition of an MIS group simplifies the process of linking an account product or a transaction to several MIS entities Consider the following example Example Savings accounts in the local currency are a type of account class This class may come under the purview of the following MIS entities Business Segment Individuals Cost center Savings accounts in local currency Accounts officers Elizabeth Towers and Sam Brown Cost Code Transaction charges for savings accounts The following are the definitions in the various MIS screens MIS Class MIS Code Business Segment Individuals Cost Center Savings Accounts Accounts Officer Elizabeth Towers and Sam Brown In the MIS Cost Codes screen a Cost Code has been defined for the transaction charges for savings accounts The pool for this class of accounts is called SAVINGS When you create this account class you do not have to individually link each applicable MIS entity to the account c
27. documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services
28. e MIS Code Desc MIS Class 10 MIS Code ELCs Date Time Checker Date Time Mod No Record Status Authorization Status If you are creating a new MIS Group select New from the Actions Menu in the Application toolbar or click new icon The MIS Group Definition screen is displayed without any details i ORACLE If you are calling an MIS Group that has already been defined double click an MIS Group from the summary screen Operations on the MIS Group Record On an existing MIS Group record you can perform any of the following operations if any function under the Actions Menu is disabled it means that the function is not allowed for the record e Amend the details of an MIS Group e Authorize an MIS Group e Copy the details an MIS Group on to a new one e Print the details of an MIS Group e Delete an MIS Group Please refer to the manual on common procedures for details of these operations MIS Cascading You can have a particular MIS group defaulted in the MIS Subsystem of the following screens at the time of creation of records e Customer Maintenance Screen e Account Class Maintenance Screen e Customer Account Maintenance Screen e All the Products Screens e All the Contract Screens Once these records are authorized you can change the MIS Group values i e MIS Codes li
29. e account if the details are displayed for an account Contract Reference Number Customer Account number The reference number of the contract if the details are displayed for a contract or the customer account number if the details are displayed for an account Tenor The tenor Original balance The original balance Outstanding balance The outstanding balance Maturity Profile for Next Day Report You can generate this report using Maturity Profile for Next Day Including Contingents screen To invoke the screen type CORMTPRF in the field at the top right corner of the application toolbar and click the adjoining arrow button 9 13 ORACLE 9 5 1 Maturity Profile for Next Day Including Contingents ReportFormat PDF wv Report Output Print wv Printer At Client v Printer Specify the report options and click OK button to generate the report Contents of the Report The following content is displayed in the report Header The header of the report contains the title of the report branch code branch name branch date User ID of the user who generated the report module code run date and time of the report and the page number of the report Body of the Report The following details are displayed as body of the generated report Field Name Field Description Module The code that identifies the module Branch The br
30. e The period for which the adjustment should be considered represented through the month and the year under the Time Details Depending on the type of MIS Head balance income expense or contingent the adjusted amount will be reported accordingly for the appropriate period 7 1 2 Operations on the MIS Adjustments Screen Once you input the details of an adjustment it should be authorized by a user bearing a different Login ID from yours Please refer to the manual on common procedures for details of these operations as ORACLE 8 1 8 Defining MIS Details for a Customer Account Class Account Product and Contract Defining MIS Details for a Customer The MIS details for a customer can be defined through the MIS screen This screen can be invoked by clicking on the MIS button while defining the customer code The MIS details screen for a customer is shown below MIS Group laz v Link to Group Customer Code Ts Customer MIS Code Composite MIS Code ia a fe E m e fe x m x ana jan y l Change Log Transfer Log Exit While defining a customer you can define the following MIS details MIS Group The MIS Group to which the customer should be linked is defined in the MIS Group field if it is applicable if not you can define the individual entities under which the customer should be reviewed If a group is
31. ed double click on an MIS Cost Code from the summary screen Type The MIS Cost Code can belong to one of the following types Number of Transactions This typically applies for calculating the cost of processing a transaction involving an account You can indicate the amount to be considered as the notional cost for each transaction Example You may incur a certain amount for every transaction you process of a savings account a particular category This cost could be different for processing transactions in a different type of savings account or for current accounts You should define different MIS Cost Codes and link them to the appropriate account classes Event based Charges The notional cost applicable for processing an event can be defined as a cost code Typically this applies for a contract Example For processing an event in the lifecycle of a loan you may want to attach a certain cost You can define a cost code for it and link it to the product Similarly you can define a different notional cost for different events in the lifecycle of a contract Thus you can have a cost code for initiating a loan one for liquidating interest and so on and link them to the product with the appropriate event codes The notional cost that you define will be taken as the cost per event Duration based Charges These changes are applied typically for a contract The notional cost in this case is calculated on the basis of a s
32. een by typing MIDPOOLD in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button MIS Pool Code Maintenance Pool Code Description Interest Method Input By Authorized By Modification Date Time Date Time Number Authorized Open If you are creating a new MIS Pool Code select New from the Actions Menu in the Application toolbar or click new icon The MIS Pool Code Definition screen is displayed without any details If you are calling an MIS Pool Code that has already been defined double click on an MIS Pool Code from the summary screen 6 1 ORACLE 6 2 6 2 1 Defining Refinancing Rates for a Pool For each pool you can define refinancing rates for every month of the year for different currencies The refinancing rate will be used to arrive at the refinance income and expense for a given MIS entity Two types of refinancing rates can be defined debit rate and credit rate The debit rate is applied when the cumulative average balance calculated for the MIS entity is positive This indicates that the MIS entity has borrowed funds The credit rate is applied when the cumulative average balance calculated for the MIS entity is negative This indicates that the MIS entity has lent funds The refinancing rates are defined for each branch of your bank individually Invoking the MIS Pool Refinancing Rates Screen You can invoke the MIS Refin
33. eld Name Field Description Function This is the function which is being reported Unit Ref No This is the corresponding unit ref no as against the relevant function being reported Error Msg This is the error message being reported 9 2 4 Transaction Force Debited Report Oracle FLEXCUBE facilitates generation of a report at branch level which lists details of all forced debit transactions processed from the following modules e Bills and Collections BC e Data Entry DE 9 6 ORACLE e Deposit Locker DL e Foreign Exchange FX e Funds Transfer FT e Letters Of Credit LC e Loans and Deposits LD e Local Payments PC e Retail Lending CL e Retail Teller RT e Clearing CG This Transaction Force Debit Report would be generated for the transactions with Available Balance Check Option check box checked at Account Class Preferences and Transaction Code Maintenance levels Accounts and transactions uploaded from an external system will have respective external system code as source code The transaction details are grouped based on the Branch Source Transaction Code and Transaction Type You can invoke the Transaction Force Debit Report screen by typing the code ACRFCDR on the field at the top right corner of the Application tool bar and click on the adjoining arrow button Transaction Force Debited Report Source Code All Branch All Specific Specific
34. enssessnesessnessesessssessnesscsecssesssssessnssnessssnossessessosees 5 1 5 1 INTRODUCTION ccir siena ENE ENESENN ENEE ARTEETAN ITTE OEE OON 5 1 5 1 1 Invoking the MIS Heads Screen sssssesscesseesscssecesecssesssecsnecnnsonssonsesnsenseessesseesseesseeneesseecoesenesenssensons 5 1 5 1 2 COLE BOTY setie ewes tess EE ory syed ve E E E E E OE EE O E E E E 5 1 5 1 3 FROPINON CE ck aroe E EEE E T EE E T thee 5 2 5 1 4 Linking an MIS Head to an Accounting Entry sesessssesesseseesesesrsreesssresresreresesressesresresereresesrensrsreeesse 5 2 5 1 5 Operations on the MIS Head Record scccscecceesceescessceseceecusecsecasecsaeeaeeeseeeseeeeeeeeseseseaesnaeenaesaenae 5 3 6 DEFINING POOL CODES AND REFINANCING RATES sseeseseseceseesoeseseeescesoroeoeseseeossoroeseseeesoesoroeseeeeeee 6 1 6 1 INTRODUCTION niise niara bes suc saccaevs Sees ucesassates EA E EEE coves daiutesevsecetenteugoessassests 6 1 6 1 1 Invoking the MIS Pool Code Screen csscssccescceseceeecnsecnsecasenseensesscesseeseesecssecsaeesaesnaesnasenasenseensees 6 1 6 2 DEFINING REFINANCING RATES FOR A POOL ccccceceeeseescesesesesecseesecseeescseeesesessuessceessseseeeesssecsuesssneeenenes 6 2 6 2 1 Invoking the MIS Pool Refinancing Rates SCre N sccesccescceseesseesseeseeeseeseeeeeceecusecusecuaecaeeaaeeaeeeseees 6 2 6 2 2 Operations on the MIS Pool Refinancing Rates Record ccccsccesccescese cess cue cuseeeeesseeseesseeeseeenenaees 6 3 7 MAKING MIS ADJUS
35. fic code If you have selected specific specify a valid transaction code for which you want to generate the report from the adjoining option list Module Code Select module code for which you want to generate the report from the options The following options are available for selection e All Select if you want to generate the report for all the module codes e Specific Select if you want to generate the report for a specific code If you have selected specific specify a valid module code for which you want to generate the report from the adjoining option list From Date Specify a valid date from when you wish to generate the interest accrual report from the adjoining calendar To Date Specify a valid date till when you wish to generate the interest accrual report from the adjoining calendar Report Format Select the format in which you need to generate the report from the adjoining drop down list This list displays the following values e HTML Select to generate report in HTML format 9 8 ORACLE e RTF Select to generate report in RTF format e PDF Select to generate report in PDF format e EXCEL Select to generate report in EXCEL format Report Output Select the output in which you need to generate the report from the adjoining drop down list This list displays the following values e Print Select to print the report e View Select to print the report e Spool Select to
36. hile defining the product Accounting Entries Event Code Event Description Accounting Entries Details 10110 o Accounting Role Amount Tag Dr Cr Transaction Code Netting MIS Head Profit GL You should link the appropriate leg of the accounting entry to the MIS Head to which it belongs Ensure that you link only one leg of the entry to an MIS Head To add a record to the list of Accounting Entries click add icon Choose values for each field of a record using the adjoining option list Operations on the MIS Head Record On an existing MIS Head record you can perform the following operations if any function under the Actions Menu is disabled it means that the function is not allowed for the record e Amend the details of an MIS Head e Authorize an MIS Head e Copy the details an MIS Head on to a new one e Print the details of an MIS Head e Delete an MIS Head Please refer to the manual on common procedures for details of these operations ze ORACLE 6 1 6 Defining Pool Codes and Refinancing Rates Introduction Each logical pool that will lend or borrow funds should be allocated a pool code The interest method to be used while applying refinancing rates for the pool should be defined for the pool code also The refinancing rates for the pool should be defined in the MIS Pool Refinancing Rates screen Invoking the MIS Pool Code Screen You can invoke the MIS Pool Code Maintenance scr
37. ils Screen for an Account ssseseseseeseeeeseeererrrrerrsrrererrerrnrerrreresrreresressse 8 7 8 4 GL MIS BALANCE TRANSFERS DUE TO RECLASSIFICATION 0 ccscsssesceseesseseseeseceseeeseesesssesssesesseseeeseesese 8 8 D2 SRERORTS E E E EE E E E E E 9 1 9 1 INTRODUCTION cansonn i E E E a EE ENEN a E E aE 9 1 9 2 INVOKING THE REPORT OPTIONS SCREEN csccscsscssesessessceseceeesecseesecseseesssessuesecsessecsesesseeseussesseeseeneseesegs 9 2 9 2 2 Invoking the Pool Codes Report Screen cccccccsccesscessceseceecuseesseeseeeseeeeeeseeeseceseceaecaecnaecaeeeeeaeeeaeees 9 4 9 2 3 Invoking the Error Report Screens nn EE S 9 5 9 2 4 Transaction Force Debited Report scccsccesccssecsseesseeseeeseeeseeeneeeceesecaecaeceaecsaecsaecseeeaeeeeeeeeeeeeeeeeeeaees 9 6 9 2 5 Contents 0f the Report sicsccctevcscvsiaestavsodesnavsasnverdots E NE EE E ie vuveeeybeuwens 9 9 9 3 INTER BRANCH RECONCILIATION REPORT ccccscsssesesseesceseceseseceeesecsesescssessseseseessessesssesseseasessuensenenenes 9 11 9 3 1 Contents Of the REDO ts oireena anarie EE E N R OE 9 11 9 4 MATURITY PROFILE FOR NEXT WEEK REPORT eesesssseseieresesrsesrerietstnsssrstretsrnrnnrsrntenretsnnstnrernesense netere 9 12 9 4 1 Contents ofthe Report riesana annin ER E aE RAEE EREET E aR E 9 12 9 5 MATURITY PROFILE FOR NEXT DAY REPORT ccccscsssssssssssscssesecssessesssssssesessesesssesessavesaasessseeceseseseesaees 9 13 9 5 1 CONTENTS Of The ROD OTE orosenie iaa a a
38. l Funds Growth Funds and Income Funds etc You may want to view details on each of the funds You can achieve this by defining Funds as an MIS Class and have the various funds reporting to it Each of these funds would be defined as an MIS Code and then linked to the MIS Class Funds This is a Fund type of MIS Class MIS Code An MIS Code can be called an entity for which you want profitability reports Each MIS Code will report to an MIS Class Consider the following examples e Accounts Officer is an MIS Class To this MIS Class will report all the Accounts Officers of your bank With this structure you can generate profitability reports for each Accounts Officer Elizabeth Towers Sam Brown and Connie Beckwith are some of your accounts officers e Cost Center is an MIS Class The various cost centers in your bank will be classified under this MIS Class Thus the various departments in your bank will report to this Cost Center so that you can generate profitability reports for each cost center Short Term Loans Incoming Bills and Import Letters of Credit can be some of your cost centers e Industry Segments is an MIS Class The various industries to which your customers belong will report to this MIS Class Manufacturing agriculture cash crops and financial institutions can be some of your industry segments In these examples Elizabeth Towers Sam Brown and Connie Beckwith will each have an MIS Code all under the MIS Class
39. l be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury 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
40. l other entities Chapter 5 Defining MIS Heads describes the procedure for defining MIS heads This includes the linking of an MIS head to an accounting entry indicating whether the MIS head should be considered for refinancing and the operations that can be performed on an existing MIS head record Chapter 6 Defining Pool Codes and Refinancing Rates explains how to assign unique codes to MIS pools and how for each pool you can maintain refinancing rates in different currencies Chapter 7 Making MIS Adjustments for a Pool specifies the manner in which you can allocate the amounts to be reported from one MIS code to another Chapter 8 Defining MIS details for a Customer Account Class Product and Contract enumerates the steps that you should follow while defining MIS details for a customer an account class a product or a contract FI ORACLE Chapter 9 Reports provides a list of reports that can be generated in this module and also explains their contents Conventions Used in this Manual Important information is preceded with the symbol 1 4 Glossary of Icons This User Manual may refer to all or some of the following icons 1 4 1 Related Documents For a detailed description of all the procedures in the manual please refer to the Oracle FLEXCUBE manual on Common Procedures Te ORACLE 2 1 2 Defining MIS Class Codes Introduction In simple terms an MIS Class represent
41. lass Instead you can create an MIS Group with the MIS Class and MIS Code linked as follows MIS Group SAVE1 Pool SAVINGS Customer class Business segment MIS Code Individuals Transaction class Accounts Officer no MIS Codes Transaction class Cost Center savings accounts in local currency Cost code Code defined for transaction charges on savings accounts While defining the account class you can link the MIS Group SAVE1 to it and indicate the appropriate accounts officer code that for Elizabeth Towers or Sam Brown Fi ORACLE In a similar fashion MIS Groups can be defined in various ways and used for linking MIS entities to an account class account product or transaction 4 1 1 Invoking the MIS Group Screen You can invoke the MIS Group Maintenance screen by typing MIDGRPMT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button MIS Group Maintenance MIS Group Description Pool Code Pool Description Customer Class Composite Class Transaction Class Cost Code MIS Class 1 MIS Code MIS Code Desc MIS Class 2 MIS Code MIS Code Desc MIS Class 3 MIS Code MIS Code Desc MIS Class 4 MIS Code MIS Code Desc MIS Class 5 MIS Code MIS Code Desc MIS Class 6 MIS Code MIS Code Desc MIS Class 7 MIS Code MIS Code Desc MIS Class 8 MIS Code MIS Code Desc MIS Class 9 MIS Cod
42. nd click the adjoining arrow button inter Branch Recon Report ReportFormat PDF v PrinterAt Client v Report Output View wv Printer Specify the report options and click OK button to generate the report Contents of the Report The following content is displayed in the report Header The header of the report contains the title of the report branch code branch name branch date User ID of the user who generated the report module code run date and time of the report and the page number of the report Body of the Report The following details are displayed as body of the generated report Field Name Field Description Branch The branch code and the name of the branch i ORACLE 9 4 9 4 1 Field Name Field Description Account Number The account number whose balance is displayed in the report Currency The currency in which the balance amount is displayed Balance The balance amount available in the account Maturity Profile for Next Week Report You can generate this report using Maturity Profile for Next Week Including Contingents screen To invoke the screen type CORMNPRF in the field at the top right corner of the application toolbar and click the adjoining arrow button Maturity Profile for Next Week Including Contingents Branch Code 000 ReportFormat PDF PrinterAt Client v Report Output Print v Printer
43. nked to the MIS Class in the MIS Group Maintenance screen During EOD the batch program MIGCASCD maintained at the Post EOTI level will cascade the modified MIS Codes in the above screens As a result the system replaces the MIS Codes that are provided at the time of creation of the above records by the MIS Codes maintained in MIS Group Feature ID Maintenance If you maintain feature ID for all branches the system displays the MIS class values and MIS codes in the MIS subsystem of the following screens e Customer Maintenance Screen e Account Class Maintenance Screen e Customer Account Maintenance Screen e All the Products Screens i ORACLE e All the Contract Screens T ORACLE 5 1 5 Defining MIS Heads Introduction Each accounting entry that is generated can be linked to an MIS Head An MIS Head indicates the manner in which the type of entry should be considered for profitability reporting purposes Invoking the MIS Heads Screen You can invoke the MIS Head Maintenance screen by typing MIDHEAD in the field at the top right corner of the Application toolbar and clicking the adjoining arrow button MIS Head Maintenance Head Description Category v Refinance Input By Authorized By Modification Number Authorized Open Date Time Date Time If you are creating a new MIS Head select New from the Actions Menu in the Application toolbar or click new icon The
44. of MIS Head you may define additional MIS Heads as per your reporting requirement For example you can have an MIS Head for each loan product so that you can have the cumulative average balance due to all the loans disbursed under the product Refinance The Refinance option is provided for marking MIS Heads for refinancing For MIS Heads that are marked for refinancing the refinancing income or expense would be calculated on the cumulative average balance for the reporting period You would typically mark a balance type of MIS Head for refinancing This option is provided because not all the balance type of entries would come under the umbrella of refinancing To enable this option select the check box beside Refinance Linking an MIS Head to an Accounting Entry Each accounting entry generated in Oracle FLEXCUBE will have a transaction code that describes the nature of the entry These transaction codes are defined by you depending on your requirements An MIS Head can be attached to a transaction code A transaction code is attached to an accounting entry when an event is defined for a product through the Product Event Accounting Entries Maintenance screen Thus whenever a transaction with an MIS Head attached is entered for an entry the MIS Head will automatically be linked to it You can change this while defining the product ve ORACLE Alternatively you can link an MIS Head to an accounting entry directly w
45. or March also 6 2 2 Operations on the MIS Pool Refinancing Rates Record On an existing MIS Pool Refinancing Rates record you can perform any of the following operations if any function under the Actions Menu is disabled it means that the function is not allowed for the record e Amend the rates e Authorize the addition or amendment of the rates e Copy the details from one pool code to another e Print the details of the refinancing rates e Delete the refinancing rates for a pool Please refer to the manual on common procedures for details of these operations os ORACLE 7 1 7 Making MIS adjustments for a Pool Introduction Within a pool you may sometimes want to allocate the amounts to be reported from one MIS Code to another This concept is explained through the following example Example The Financial Control FINCON department in your bank is the one that disburses the salaries for your staff This department is defined as an MIS Code under the MIS Class Cost Center Now there are other cost centers such as loans department time deposits department trade financing department and retail banking department When the salary is disbursed by the FINCON department every month a debit entry shown for the MIS Code FINCON The burden of this debit entry should be shared appropriately by the various departments to which the staff of your bank belong This distribution of the salary amount is done through the MIS
46. pecific duration This notional cost is defined for a cost code The following example illustrates how this cost is applied on a contract Example If a loan is live for a month the notional cost you incur is a specific amount You would define a duration based cost code define the periodicity as monthly For every month a loan linked to the cost code is live the notional cost will be applied 2 ORACLE 3 1 3 Cost The notional cost along with the currency in which it is expressed should be indicated for the cost code The cost will be applied based on the Cost Code type as follows Number of The amount is taken as the cost per transaction Transactions Event The amount is taken as the cost per event Duration The amount is taken as the cost for the period defined as the periodicity for the cost code If a currency conversion is involved during reporting the prevailing conversion rate will be used 3 1 4 Periodicity This is the periodicity at which the costs defined have to be applied In the profitability report the notional cost reported would depend on the periodicity defined for the cost code For a quarterly half yearly or yearly periodicity you should also indicate the first month of application The subsequent application months would be computed based on this 3 1 5 Operations on the MIS Cost Code Record On an existing MIS Cost Code record you can perform any of the following operations if
47. r Parameters MIS Class MIS Description Report Format Report Output January v January v Branch Customer Pool Code Account Class Customer Category MIS Class Product 9 2 1 1 Contents of the Report Branch Code Branch Name Customer Customer Name Pool Code Pool Description PrinterAt Client v Printer The contents of the report will be sorted and break up figures provided depending on your selection The order in which the report will be sorted for each type of report is as follows Field Name Field Description ORACLE Branch report Branch code and currency Customer report On customer pool code and currency Pool code report Pool code and currency Header The Header carries the title of the report branch code pool code branch date user ID module from which the report has been generated date and time at which the report has been generated and the page numbe Body r of the report You can find the following details in the body of the report Field Name Field Description Branch This is the branch for which the profitability is being reported Event Date This is the date of the event Fund Reference This indicates the fund reference Security ID This indicates the security ID Portfolio This indicates the security portfolio Holding
48. ran Reference Dr Cr GL MIS MIS Transa Ccy Amount ch Number Indicat Class Code ction or Date 8 10 ORACLE Bran Reference Dr Cr GL MIS MIS Transa Ccy Amount ch Number Indicat Class Code ction or Date 000 OOOLDBL993 Dr 190648 TRAN BBB 31 03 2 US 10 000 00 350005 342 _OUC 003 D 000 OOOLDBL993 Cr 190648 TRAN AAA 31 03 2 US 10 000 00 350005 342 _OUC 003 D 000 OOOLDBL774 Dr 834244 CUST CCC 31 03 2 US 545 00 480006 064 _OUC 003 D 000 OOOLDBL774 Cr 834244 CUST YYY 31 03 2 US 545 00 480006 064 _OUC 003 D 8 11 ORACLE 9 1 9 Reports Introduction During the course of the day or at the end of the day you may want to retrieve information on any of the several operations that were performed in your bank You can generate this information in the form of reports in Oracle FLEXCUBE The MIS Profit and Loss report Pool Codes report and Error report are explained in this section The different report options for each of them are as mentioned below Profit and Loss Report The first parameter based on which you can generate the MIS report can be e The branch e Customer e Pool code A branch report will always be for the branch to which you are logged on A customer report can be generated for a specific customer You should indicate the CIF ID of the customer The customer report can also be generated for a specific MIS class
49. s a type of entity based on which you want your reporting to be done An MIS Class will be the most general definition for MIS reporting under which you can have several entities For example if you want reports on the profitability of accounts officers you would define Accounts Officer as an MIS Class Accounts Officers in your bank would report to this MIS Class Similarly you define Cost Center as an MIS Class if you want reports based on the cost centers in your bank You can have the various cost centers in your bank linked to the MIS Class of Cost Center Business Segment Industry Segments are other examples of an MIS Class The definition of MIS Class renders the entire MIS reporting absolutely flexible By defining a class of your choice and linking several entities to it you can generate management information as per your requirement In acentralized database architecture an MIS Class is defined in the Head Office branch of your bank and is used by all the branches on the database ORACLE 2 1 1 Invoking the MIS Class Screen You can invoke the MIS Class Maintenance screen by typing GLDCLSMT in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button MIS Class Maintenance MIS Class pae Description Mandatory vl MIS Type Transaction Class Customer Class Composite Class Fund Class MIS Code E mis Code Code Description Inactive
50. saction Date GL Code MIS Class Old MIS Code NewM The GL MIS Balance Transfer Process The following example explains how the batch process executes the transfer of GL MIS balances Your customer CITINY holds the accounts OOOCITINY111 and OOOCITINY444 in branch 000 A loan reference number OOOLDBL993350005 has been disbursed to the customer CITINY The MIS details for the customer and loan contract are as follows e Customer MIS Class CUST_OUC gt MIS Code associated with Customer MIS Class CUST_OUC CCC e Transaction MIS Class TRAN _OUC gt MIS Code associated with Transaction MIS Class TRAN_OUC AAA The following accounting entries have been posted till date for the loan reference number 000LDBL993350005 issued to customer CITINY Debit Credit Indicator Role Account Currency Amount Debit ASSET 190648342 USD 10 000 00 Credit Customer USD 10 000 00 8 9 ORACLE For GLs 190648342 and 834244064 the transfer of balances on MIS reclassification option has been set in the Chart of Accounts An entry is posted on 30 March 2003 with related account as OOOCITINY111 for a loan reference number 000LDBL774480006 for a credit of 545 USD into the GL 834244064 On 31 March 2003 the MIS code for customer MIS class CUST_OUC for the customer CITINY is changed to YYY The system stores the following details in the Customer MIS Change Log Customer No MIS cla
51. ss Transaction Date Old Value New Value CITINY CUST_OUC 31 March 2003 CCC YYY Again on 31 March 2003 the MIS code for transaction MIS class TRAN_OUC for the contract 000LDBL993350005 is changed to BBB The following details are stored in the Contract MIS Change Log Unit Type Reference No MIS class Transaction Date Old Value New Value Contract 000LDBL993350005 TRAN_OUC 31 March 2003 AAA BBB During the batch process the system takes into account the Customer MIS Change Log and then updates the Contract MIS Change Log for the contracts and accounts of the customer The Contract MIS Change Log is updated as follows Unit Type Reference No MIS class Transaction Date Old Value New Value Contract 000LDBL993350005 TRAN_OUC 31 March 2003 AAA BBB Contract 0O0OLDBL993350005 CUST_OUC 31 March 2003 CCC YYY Account OOOCITINY111 CUST_OUC 31 March 2003 CCC YYY Account OOOCITINY444 CUST_OUC 31 March 2003 CCC YYY The following entries are then taken into account Reference Number Debit Credit Account Related Currency Amo Indicator Account unt O0O0OLDBL993350005 Debit 190648342 USD 10 00 0 00 OOOLDBL774480006 Credit 834244064 OOOCITINY111 USD 545 0 0 The MIS Balance Transfer Log is thus constructed to display the following details B
52. t or to a contract in the following manner 1 You can link a Cost Code to an account class This will default to the accounts maintained under the account class You can change this default Alternatively you can link an MIS Cost Code to an account when maintaining it 2 When creating a product you can identify the Cost Codes against which contracts involving the product should be reported 3 When processing a contract the Cost Codes identified for the product the contract involves will automatically default These defaults can be changed If cost codes have not been identified for the product you can identify one for the contract The notional cost will be reported in the profitability report 3 1 1 Invoking the MIS Cost Codes Screen You can invoke this screen by typing MIDCCODE in the field at the top right corner of the Application toolbar and clicking the adjoining arrow button MIS Cost Code Maintenance Cost Code Description E Type No of Transactions v Currency z Cot o i Periodicity Monthly v Applied Month Input By Authorized By Modification Number Authorized Open Date Time Date Time 3 1 ORACLE 3 1 2 If you are creating a new MIS Cost Code select New from the Actions Menu in the Application toolbar or click new icon The MIS Cost Code Maintenance screen is displayed without any details If you are calling an MIS Cost Code that has already been defin
53. the page number of the report Body You can find the following details in the body of the report Field Name Field Description Pool code This is the Pool Code which is being reported Currency This is the MIS currency being reported Debit Rate This is the credit rate applied when the cumulative average balance calculated for the MIS entity is positive indicating funds have been borrowed Credit Rate This is the credit rate applied when the cumulative average balance calculated for the MIS entity is negative indicating funds have been lent Year This the calendar year being reported Month This is specific month of the calendar year being reported 9 2 3 Invoking the Error Report Screen You can invoke the screen by typing the code MIRERRPT on the field at the top right corner of the Application tool bar and click on the adjoining arrow button 9 5 ORACLE Eror Report Output Output O Print O View Spool Print At Client Server Printer Printer 9 2 3 1 Contents of the Report The contents of this report have been discussed under the following heads Header The Header carries the title of the report branch code branch date user ID module from which the report has been generated date and time at which the report has been generated and the page number of the report Body You can find the following details in the body of the report Fi
54. und MIS 5 Fund MIS 6 Fund MIS 7 Fund MIS 8 Fund MIS 9 Fund MIS 10 Link To Group For a contract the transaction type of MIS class the cost code and pool code will be picked up from the product under which the contract is processed The composite MIS code will be picked up from the definition made for the customer on behalf of whom the contract is being processed 8 5 ORACLE The interest calculation method for the refinancing rates of the pool will also be picked up by default from Pool Codes maintenance and these can be changed For an account the transaction type of MIS class will be picked up from the account class along with the cost codes and pool codes The composite type of MIS class will be defaulted from those defined for the customer These too can be changed Change Log If MIS reclassification occurs through changing the MIS codes for transaction or composite classes the System stores the changes made in a Contract MIS Change Log The following details are stored in the Contract MIS Change Log for the contract in respect of which the MIS reclassification occurred e Contract Reference Number e MIS Class that was changed e Date on which the change was made e The old code for the changed MIS Class this information is stored only for the first amendment during a day e The new MIS code for the changed MIS class Click Change Log button in the Transaction MIS Maintenance screen to view the Contr
Download Pdf Manuals
Related Search