Oracle FLEXCUBE Universal Banking
Contents
1. pous oof 11 28 16 51 16 27 19 64 20 68 Loss oo ooj 345 324 331 202 NORM 1 3 17 00 13 79 344 319 720 SUES 212 158 184 0 00 419 000 Undassfed 1249 8 36 10 75 10 94 11 36 350 WACH 313 1af 023 013 106 73785 Grand Total 29 07 3985 4658 34 01 4275 25 68 ____fTotaltoanstatus NoofAccunts OO OO Status Y 2014Q1 201402 2014Q3 2014 Q4 2015 Q1 Growth E O P O S O A E Loss of of 2 a a 0 NORM 6 al ol 6 6 0 SUBS a a at op 1 0 Undassfed 31 3 9 9 vw a S WACH 1l 1 1 1 1 n P _ _ ___ _ __ _ _ _ You can view the following details e Value of total loans in millions across loan statuses for the selected quarter and four previous quarters e Value of total loan status by segment e Number of loan accounts across loan statuses for the selected quarter and four previous quarters e Number of loan accounts by segment The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format eee ORACLE 2 6 Creating Dynamic Reports You can create dynamic reports using the Oracle FLEXCUBE Information Server RPD In order to start with creation of a dynamic report login to OBIEE system ORACLE Business Intelligence Sea2. 5 NPA Statistics No of Borrowers Status Y 2014Q1 2014 Q2 2014Q3 2014 94 2015 Q1 Growth pows o 6 LOSS 0 0 Sus 2 WACH 1 Grand Total 9 You can view the following details e Value of total NPA status in millions for the selected quarter and four previous quarters e Number of borrowers based on NPA status for the selected quarter and four previous quarters You can drill down to further levels by clicking the links The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format 22 ORACLE 2 5 8 Total Loan Status This report shows the status of loans for each quarter The generated report is as follows Bank Scorecard II Home Catalog Favorites y Dashboards y ff New Ba Open Signed In As readuser v Corporate Lending Statistics Retail AssetBook Retail New Disbursements Corporate New Disbursements InterestEarned NPA Status NPA Statistics Total Loan Status 5 3 a YearQu 01501 z Apply Reset v a Total Loan Status in milion Time run 9 3 2013 5 32 04 PM 23 94 19 95 1596 f Woo LOSS ENORM 11 97 SES Unclassified I WacH 7 98 3 99 0 00 2014 01 2014 02 2014 03 201404 201501 Value of Total Loan Status in milions Status Y 2014 912014 92 2014 03 2014 04 2015 Q1 eGrowth
3. Field Description Deceased Whether the customer is deceased or not Frozen Whether the customer details are fro zen or not Language Language of the customer Country Country to which the customer belongs Nationality Nationality of the customer Whereabouts Whether the whereabouts of the cus Unknown tomer is known or not Address Line 1 First line of the customer s address Address Line 2 Second line of the customer s address Address Line 3 Third line of the customer s address Address Line 4 Fourth line of the customer s address Credit Rating Credit rating of the customer GL Master GL Code The general ledger code GL Description The description of the general ledger Category The category of the GL Leaf GL that reports to a node GL and is not reported by any other GL Parent GL The parent GL Product Product Code Product code Product Type Product type Product Description Description of the product Asset Liability Whether the product is an asset or lia bility Module The module Product End Date End date of the product Product Start Date Start date of the product GL MIS Date The Oracle FLEXCUBE system date on which GL balance information was extracted GL Code General ledger code Branch Code Branch code 2 27 ORACLE Folder Field Description Currency Currency code Fin Year
4. No of Accounts constituting Assets amp Liabilities x 2012 Q4 2013 Q1 2013 Q2 2013 Q3 2013 Q4 Growth 20 23 24 7 16 129 Liabilities Grand Total 69 49 60 e e 7 13 83 s 70 87 24 Refresh Print Export You can view the following details e Asset Liability Book Balance This is a generic report and considers all modules in Oracle FLEXCUBE Sum of GL balances in asset category and the growth percentage compared to the previous period Sum of GL balances in liability category and the growth percentage compared to the previous period e Asset Liability Book Number of accounts constituting assets and liabilities All open and active assets and the growth percentage compared to the previous period 2 7 ORACLE All open and active liabilities and the growth percentage compared to the previous period The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format 2 4 2 New Assets and Liabilities The new assets and liabilities report shows the value and total number of the new and active assets and liabilities of the bank for each quarter Select the year quarter and click Apply button The generated report is as follows ORACLE Business Intelligence Search all E Advanced Administration Help
5. TD amount in local currency MTD Interest Paid MTD interest paid MTD Interest Paid LCY MTD interest paid terms of local cur rency MTD Total Interest Paid MTD total interest paid Interest Earned LCY Interest earned in terms of local cur rency Total No of Liabilities Total number of liabilities Assets Loans MIS Date The Oracle FLEXCUBE system date on which loans information was extracted Account Number Loan account number Account Status Account status Acc Type Account type Date Key Date key Loan Type Type of loan Maturity Date Maturity Date of the loan Product Key Product key User Defined Status User defined status Value Date Value date of the loan Module Module Product Product code Branch Code Branch code Currency Currency code New Account Qtr If the account is created during the cur rent quarter this is set to Y Otherwise it is set to N Loan Book Date Loan book date Amount Disbursed Amount disbursed 2 30 ORACLE Folder Field Description Industry Industry Amount Disbursed LCY Amount disbursed in local currency Amount Financed Amount financed Amount Financed LCY Amount financed in terms of local cur rency Monthly Amount Dis bursed Monthly amount disbursed Monthly Amount Dis bursed LCY
6. Monthly amount disbursed in terms of local currency Monthly Interest Earned Monthly interest earned Monthly Interest Earned LCY Monthly interest earned in terms of local currency Outstanding Balance Outstanding balance Outstanding Bal ance LCY Outstanding balance in terms of local currency Total No of Assets Total number of assets For further details on Branch and Currency see Core Services user manual For further details on Customer see Core Entities user manual For further details on GL Master see General Ledger user manual For further details on Liability CASA see Current Account and Savings Account user manual For further details on Asset Loans see Retail lending user manual The subject areas that you select for a particular report decide the data that needs to be taken for generating the report You can expand the folders mentioned above and select the columns that are required in the report 2 31 ORACLE Double click a column name to add it to the report The selected columns are displayed on the screen ORACLE Business Intelligence Search Al Y gt Advanced Administration Help Sign Out Home Catalog Favorites Dashboardsy EE Open Signed In As weblogic v Criteria Results Prompts Advanced aao x Subject Areas gt i a V Flexcube Information Server x Selected
7. Note Values are shown in Currency GBP Refresh Print Export You can view the following details e Value of Interest Earned in Millions Interest paid in millions for the selected quarter and four previous quarters and growth percentage for account types Interest paid for the selected quarter and four previous quarters and growth percentage for account types Interest paid for the selected quarter and four previous quarters and growth percentage for account types The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format ats ORACLE 2 4 8 2 5 2 5 1 TD Maturing Status This report shows the balance and interest details of term deposit accounts that are expiring within certain periods of time The details are displayed as of the previous business day The generated report is as follows ORACLE Business Intelligence Search All 2 gt Advanced Administration Help Sign Out Bank Scorecard I Bank Scorecard New Assets and Liabilities Interest Earned and Interest Paid Liabilities Book Liabilities Status New Account Balances and Deposits Interest Paid TD Maturing Status TD Maturing Status Time run 8 14 2013 4 09 18 PM Days No Of accounts Value of TD P in LCY in millions Value of TD 1 in LCY in milions Total
8. SignedInAs readuser v Corporate Lending Statistics Retail Asset Book Retail New Disbursements Corporate New Disbursements InterestEarned NPA Status NPA Statistics Total Loan Status ETO Time run 9 3 2013 5 31 20 PM Industry wise Lending in 14 5 51 12 16 54 36 05 10 E Hotel Im Hotel mr aT 331 I Manufacturing 8 IM Manufacturing E Pharma IM Pharma 551 W Real Estate Mi Real Estate E Telecom 6 IM Telecom IB Transport E Transport E Unclassified IM Unclassified 11 03 ll 11 03 11 03 2 Total Amount Financed o o A A_ AM Unclassified Industry Amount Financed Value Value Value Value Value Value Value Value Hotel 2 00 2 00 100 0 T 6 00 3 00 50 0 3 00 50 0 Manufacturing 120 20 100 0 Pharma 2 00 2 00 100 0 _ Real Estate 400 3 00 75 0 25 0 Telecom 4 00 3 00 75 0 25 0 Transport 400 4 00 100 0 Undassifed 13 08 100 76 0 03 0 2 12 05 92 1 Grand Total 10 00 27 6 11 00 30 3 3 23 8 9 12 05 33 2 Note Values are shown in Currency GBP Refresh Print Export You can view the total amount financed in millions to each industry You can click the links to drill down to the next levels for further details on each record This report displays the data for the Customer type Corporate The following actions are supported from this screen e Refresh Click this link to
9. Report Jobs Report Job History 3 list Format Get Started 7 Introduction to Oracle BI Orade BI EE Documentation fer Download BI Desktop Tools tes contents v Orade Technology Network y Click New on the toolbar and select Analysis You will be prompted to select the Subject Area ORACLE Business Intelligence Search Al Y Advanced Administration Help Sign Out Home Catalog Favorites Dashboar new Select Subject Area Create e Recent Analysis and Interactive Reporting Dashboards Analysis Dashboard More y Published Reporting Report Report Job More ge Actionable Intelligence Agent Action EZR Performance Management fet Scorecard KPI KPI Watchlist Marketing Segment Segment Tree List Format Lending Statistics Browse Manage Open Edit More Open Edit More All Content v a My Analyses ig My Reports 188 My Scorecards 188 My Agent Subscriptions Y Most Popular iam My Agents no recommendations are currently available Most Popular items will be displayed here when results become available Marketing Jobs Report Jobs Report Job History Get Started w Introduction to Orade BI Orade BI EE Documentation fer Download BI Desktop Tools v O Help Contents v a Oracle Technology Network Bank Scorecard II NPA
10. 56 110 21 111 53 23 32 3 90 0 13 0 00 112 93 1 25 9 61 8 65 7 74 766 7 73 091 10 68 64 63 96 75 97 47 075 Type ca occ No of Liabilities 2012 Q4 2013 Q1 2013Q2 2013Q3 14 19 2 21 o o 2013 Q4 Growth 19 0 2 Grand Total 27 16 65 4 7 13 Value of Liabilities by Segment in millions s 2012 Q4 2013 Q1 2013 Q2 2013 Q3 The report shows the following details 2013 04 Growth e Value of total liabilities in millions for all account types e Number of liabilities for all account types e Value of total liabilities by segments in millions for all segments e Number of liabilities for the account types for all segments Note In this report all the all positive and negative balances of all current accounts are netted for the quarter The graph is shown in the positive or negative axis depending on the net In case of OD CC the accounts that have positive balance alone is included If the customer segment is not mapped the report is displayed without classification under the customer segment Unclassified The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format 2 10 ORACLE 2 4 5 Liabilities Status This report shows the value and count of active and do
11. Columns Za z ore Ponca Double click on column names in the Subject Areas pane to add them to the analysis Once added drag and drop columns to reorder them Edit a column s properties formula and fiters apply sorting or delete by 1g or hovering over the button next to its name Matar d fiters apply delete by cicking or h the b gt Currency gt ES Customer gt nte Date Liability CASA gt EGL Master E Year Q Num E Report Account Type I MTD Interest Paid LCY gt Product gt Ga gt 3 Lability CASA gt D Assets Loans y Filters PA Add filters to the analysis criteria by clicking on Fitter option for the specific column in the Selected Columns pane or by clicking on the fitter button in the Filter pane header Add a saved filter by clicking on add button after selecting its name in the catalog pane Add Filters Here 4 x Catalog YA a El gt My Folders gt Y Shared Folders In order to add filters to the report click the Filter icon ORACLE Business Intelligence Search All Advanced Administration Help sign out Home Catalog Favorites Dashboards f New Open Signed In As weblogic Criteria Results Prompts Advanced Be o y Subject Areas JIM E 7 Flexcube Information Server x Selected Columns Qe 3 aeni pS Double cick on column names in the Subject Areas pane to add them to the analysis Once added drag and drop columns to reorder them Edit a column s prop
12. Financial year Date Key Date key Period Code Period code Credit balance Credit balance Credit Balance LCY Credit balance in local currency Debit Balance Debit balance Debit Balance LCY Debit balance in local currency ACY Today Turn Today s credit turnover in account cur Over Credit rency ACY Today Turn Today s debit turnover in account cur Over Debit rency LCY Today Turn Today s credit turnover in local currency Over Credit LCY Today Turn Today s debit turnover in local currency Over Debit Asset Liability Bal Balance in asset or liability ance Liability CASA MIS Date The Oracle FLEXCUBE system date on which CASA information was extracted Branch Code Branch code Customer ID Customer ID Date Key Date key Module Module Product Product code Currency Currency code Account Open Date Date on which the account was opened New Account Qtr If the account is created during the cur rent quarter this is set to Y Otherwise itis set to N Account Status Status of the account Account Type Type of the account Account Number Account number Credit Accr Interest Credit accrual interest 2 28 ORACLE Folder Field Description Credit interest Credit interest Dormant Account Dormant account Interest Pay Freq Frequency of interest payment Interest Rate Rate of interest Maturity Date Matur
13. No of Borrowers by Segment NPA Status Corporate Retail SME Undassified Dous of o Loss 0 suss o WACH WOFF Grand Total Note Values are shown in Currency GBP Refresh Print Export You can view the following details e Value of total NPA status in millions for each segment e Number of borrowers based on NPA status for each segment You can drill down to further levels by clicking the links The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format i ORACLE 2 5 7 NPA Statistics The generated report is as follows Bank Scorecard II Home Catalog Favorites y Dashboards y New Be Openy SignedInAs readuser v Corporate Lending Statistics Retail AssetBook Retail New Disbursements Corporate New Disbursements Interest Earned NPA Status NPA Statistics Total Loan Status Y YearQtr 20151 a Apply _ _ Reset NPA Statistics Time run 9 3 2013 5 32 00 PM M201401 2014 02 2014 03 Wi 2014 04 manso in million Value of NPA Statistics in milions di Status 2014Q1 201402 201403 201404 2015 Q1 Growth DOUB 0 00 11 28 16 51 19 24 23 01 19 59 LOSS 0 00 0 00 345 3 2 02 SUBS 212 1 98 1 84 4 19 1 044 41 WACH 3 13 124 0 23 423 29 34 Grand Total 5 25 14 49 2204 26 13 34 75 33 00
14. Select the required column and click OK button You will see the New Filter window Business Intelligence Search All X Advanced Ad elp tO Untitled Home Catalog Favorites Dashboards New Be Open Signed In As weblogic v Criteria Es Prompts Ad d if Subject Areas t Hue on Se v Selected Columns 3 ccount Type MTD Intere New Filter On Column Account Status 44 Operator is equal to is in e anal pa pane or by clicking on the fitter button in the Filter pane header Add Value Search Limited Values _ok Cancel Catalog i Select the operator and value Click OK button to add the filter You can add more filters in the same manner aaa ORACLE The Filters section of the screen displays all the selected filters ORACLE Business Intelligence Search Al Y Advanced Administration Help Sign Out Home Catalog Favorites Dashboards I New O Signed In As weblogic v Criteria Results Prompts Advanced amo x Subject Areas 20 Mug 77 Fexcube Information Server y Selected Columns Qe gt E Account Periods gt Branch gt EZ Currency Customer gt ate Date Liability CASA gt GL Master B Year Q Num E Report Account Type 5 1 MTD Interest Paid LCY gt Product gt Ge amp BLabilty CASA b gt D Assets Loans Y Filters P
15. Statisti G Create Direct Database Request Open Edit More Bank Scorecard II Total Loan Open Edit More DO DO Bank Scorecard II Corporate Bank Scorecard II Retail New Open Edit More E Open Edit More Interest Paid Open Edit More Interest Paid Details Open Edit More y Open Edit More Asset Book Total NPA Status Details Quarter Open Edit More Total NPA Status Details Open Edit More Total NPA Status Open Edit More Select FLEXCUBE Information Server from the list 20 ORACLE Navigate to Criteria tab ORACLE Business Intelligence Untitled Criteria Results Prompts Advanced Subject Areas a eis_mis El EJ Account Periods El Branch E BACurrency BACustomer El Date m GL Master E Product m Gc El Libiity CASA El Assets Loans Catalog List All My Folders m LI Shared Folders TALE E Selected Columns All 7 gua q Double click on column names in the Subject Areas pane to add them to the analysis Once added drag and drop columns to reorder them Edit a column s properties formula and filters apply sorting or delete by clicking or hovering over the button next to its name Drop Columns Here E Filters Pe Add fiters to the analysis cr
16. Status Specify the following details Source Entity Select the source entity that you need to map to the target entity The option list displays the existing staging tables available for selection Select the appropriate one Target Entity Select the target entity that you need to map to the selected source entity The option list displays the existing fact and dimension tables available for selection Select the appropriate one Program Name Based on the target entity the system displays the program name Program Description Enter a brief description of the above program Surrogate Key Name Based on the target entity the system displays the surrogate name Surrogate Key Type The surrogate key type is ASCII 2 2 ORACLE Once you have specified the above details click Mapping Details button to map the source and target elements The system displays the Dimension Mapping Details screen Dimension Mapping Details Source Entity ESTB_STG_ACC_PERIOD Target Entity DIM_ACC_PERIOD ProgramName LD _DIM_ACC_PERIOD Source Target Element Mapping 10f1 5 Source Element Target Element Key Column Type a LH z Click Enrich button to populate the source elements The system will populate the source elements in the screen You may also manually enter the source elements In that case
17. User Manual Oracle FLEXCUBE Information Server discusses about the features Chapter 2 which are to be maintained in Oracle FLEXCUBE for enterprise reporting Function ID Glossary has alphabetical listing of Function Screen ID s Chapters used in the module with page references for quick navigation 1 6 Related Documents You may refer the following manuals for more information Ve ORACLE 1 7 Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function ES Exit Add row E Delete row Fasl Option List Refer the Procedures User Manual for further details about the icons ORACLE 2 1 2 2 2 2 1 2 2 2 2 Oracle FLEXCUBE Information Server Introduction Oracle FLEXCUBE Information system provides for flexible enterprise reporting that helps improved decision making The Oracle FLEXCUBE Information Server collects the data stored in Oracle FLEXCUBE and generates reports You can use the Oracle FLEXCUBE Information Server for monitoring your business performance closely With the reports generated using Oracle FLEXCUBE Information Server you can have a vivid view of the problems in the business environment and identify the areas that require attention You can also analyse the new business opportunities and trends that help you enhance your businesses The key features of Oracle FLEXCUBE Information Server
18. Value of TD P in LCY in milions in 30 days 1 0 35 0 00 0 35 in 60 days 7 2 64 0 07 271 in 90 days 2 0 76 0 01 0 77 in 150 days 1 0 85 0 02 0 87 in 180 days 2 181 0 05 1 86 Others 2 0 68 0 04 0 72 Grand Total 15 7 08 0 19 7 27 Note Values are shown in Currency GBP p En g You can view the following details pertaining to TD P TD I and TD P I accounts e Number and value of term deposit accounts expiring in 30 days e Number and value of term deposit accounts expiring in 60 days e Number and value of term deposit accounts expiring in 120 days e Number and value of term deposit accounts expiring in 180 days e Others The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format Bank Scorecard Il The reports under the dashboard Bank Scorecard II are discussed below Corporate Lending Statistics This report displays corporate wise lending across industries Each industry is associated with a credit rating The percentage distribution of the amount financed across different credit ratings is displayed in this report Any industry that is not associated to credit rating is shown aN ORACLE as unclassified The details are shown as of the previous business day The generated report is as follows Home Catalog Favorites TA To v
19. asof 125 1 26 061 HOME 2 001 0 00 0 00 0 001 0 00 0 00 HOME 193 138 085 0 34 0 00 100 00 ACA A AOL PL IDOLO APA Y 3 3 f 6 looke 665 m2 1539 1566 1665 635 opjcc sas sl sasl sas ssf ea PERSONAL ooo 1 50 ooo ooo 400 0 00 PERSONAL 0001 5 90 3151 0 13 4 191 3 226 15 Undassifed 0 00 0 00 o oo 0 00 0 00 0 00 Undassifed 0 00 0 00 ooo 0 00 0 00 VEHICLE oo 300o 30o ooo ooo 0 00 yae 525 77 004 SU 52 Grand Total 8 90 1498 1939 1566 20 65 31 89 Grand Total 11 85 19 88 21 39 1242 16 611 Total No of Accounts Loan Type_ 2014Q1 2014Q2 2014Q3 2014 Q4 2015 Q1 Growth Total No of Advances Loan Type 201401 201402 2014Q3 201404 2015 Q1 Growth fenes cin E i 5 3 business ol o ol ol o 0 EDUCATION 0 ZEE n 1 M e ss 4 of al e A A A This report displays the data for the customer type Individual You can view the following details e Total advances in millions for all loan types for the selected quarter and four previous quarters including the growth percentage e Total number of advances for the selected quarter and four previous quarters including the growth percentage e Total advances in million for various customer segments for the selected quarter and four previous quarters including the growth percentage e Total number of advances for various customer segments for the selected quarter and four previous quarters
20. including the growth percentage The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format 246 ORACLE 2 5 3 Retail New Disbursements This report shows the value and the number of new disbursements made across different types of retail loans for each quarter This also shows the same details for each segment The generated report is as follows Bank Scorecard II Home Catalog Favorites Dashboards ft New y le Openy SignedinAs readuser v Corporate Lending Statistics Retail AssetBook Retail New Disbursements Corporate New Disbursements InterestEarned NPA Status NPA Statistics Total Loan Status 5 Y YearQu 201404 y Apply Reset Retail New Disbursements in million Time run 9 3 2013 6 23 02 PM 5 94 495 396 2013 04 201401 297 2014 02 2014 03 182014 04 1 98 0 39 0 00 EDUCATION GOLD HOME PERSONAL Unclassified VEHICLE ValueofRetal New Disbursements in milions Loan Type 201304 2014Q1 2014Q2 2014Q3 2014 Q4 Growth EDUCATION 0 00 1 00 0 00 0 00 0 00 0 00 GOLD 0 00 0 25 0 25 1 00 0 00 100 00 HONE 0 00 2 00 0 00 0 00 0 00 PERSONAL 0 00 0 00 0 00 0 00 0 00 lUndassifed 0 00 0 00 0 00 0 00 0 00 VEHICLE 0 00 5 00 3 00 3 00 0 00 100 00 Grand Total 0 00 8 25 475 400 0 0
21. refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format 215 ORACLE 2 5 2 Retail Asset Book This report displays the total advances and outstanding balances across different type of loans Any Loan without a loan type is displayed under Unclassified category The generated report is as follows Bank Scorecard II Home Catalog Favorites y Dashboards ft Newv Be Open Signed In As readuser y Corporate Lending Statistics Retail Asset Book Retail New Disbursements Corporate New Disbursements Interest Earned NPA Status NPA Statistics Total Loan Status y YearQtr 2015 Q1 x Apply Reset y Total Advances Total Outstanding Balance in milion in million Time run 9 3 2013 5 31 38 PM 17 94 14 95 11 96 897 5 98 at PU I mmh 0 BUSINESS GOLD oDC Unclassified 0 d BUSINESS GOLD ODICC Unclassified EDUCATION HOME PERSONAL EDUCATION HOME PERSONAL VEHICLE 2 201402 M2 a 20150 W201401 201402 201403 201404 201501 M201401 M2014 G2 M20403 2014 4 9201501 Total Advances in milion Total Outstanding Balance nmin Loan Type 2014Q1 2014 Q2 201493 2014Q4 2015 Q1 Growth Lowa Type DNQ 2014 G2 201503 EF QA 2015 Qt Neowin fusness ool oof 000 ool ool om Busmess ooo ooo oof ooo oof 00 EDUCATION 0 00 0 00 0 00 ooo ooo 0 00 EDUCATION 106 087 060 034 035 240 GOLD 0 25 0 251 100 0 00 000 0 00 GOLD 0 26 0 53
22. 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 Contents Te PrOtace 2csccct ote Santee E E E Ro te teeta 1 1 Tet Introduction titi iii 1 1 12 AUdIENCO csi A ai tia 1 1 1 3 Documentation AccesSibility ooonmnccnnnnnnncccnn nnccccnnnncocnncnnnnornncr naar ran r cnn rr rr 1 1 1 4 Abbreviations oer n ld en dea ates at A 1 2 ko ama MON O ia 1 2 1 06 Related Documents c ts Leen tac sich eae ted eae 1 2 Wf sGlosSary o ICNS A iis eee es Bases A 1 3 2 Oracle FLEXCUBE Information Server cccccccecseeeeeeeeeeeeeeeeeeeeeeeeeeees 2 1 ZN INTO UCUON iD ina ieee 2 1 2 2 Maintenances in Oracle FLEXCUBE ooooccccccccnncononcnnnconcnnncnnnnnannnnnnnnnnncnnnnnnnnnnnannnnnns 2 1 2 2 1 Maintaining Batch Programs somrer irsini ira a cnn naar rca rn 2 1 2 2 2 Maintaining Details of Data Transformation Tool oooooinccccnninncccnnnnconnccccnannss 2 1 2 2 3 Maintaining EIS MIS Scheduler oooooconnninicinnnnnoccccccncconncncconannnc nn na nannnnn cnn 2 5 2 3 Generating Reports idiota dd 2 6 2 4 Reports in Bank Scorecard l c cc ccccceecceeeeeeeeeeeeceecaaeaecceeeeeeeeseesecsccnaecaeeeeeeeeess 2 7 24 T Bank SCOrecard utiv se wtetiss ti atest ae eit ee ala as 2 7 2 4 2 New Assets and LiabllitiS 2ccccccceceeecsecceceeeeeeeteeteseenneaaeeeeeseeeeteeteeteess 2 8 2 4 3 I
23. 0 100 00 ____ No of Retail New Disbursements Loan Type 20134 2014Q1 2014Q2 2014Q3 2014 Q4 Groth EDUCATION 0 ol of o0 0 GOLD o 1 i al of w Howe o y o of of o PERSONAL o o of of o J lUndassi ed ol o ol o o 0 VEHICLE 0 1 1 1 o 100 Grand Total o 4 3 2 ol 10 This report displays the data for the customer type Individual You can view the following details e Value of new retail disbursements in millions for various loan types for the selected quarter and four previous quarters including the growth percentage e Total number of new retain disbursements for loan types the selected quarter and four previous quarters including the growth percentage The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format 2 5 4 Corporate New Disbursements This report displays the total disbursements across different type of corporate loans alt ORACLE The generated report is as follows Home Catalog Favorites Dashboards I New Be Open SignedInAs readuser v Corporate Lending Statistics Retail Asset Book Retail New Disbursements Corporate New Disbursements Interest Earned NPA Status NPA Statistics Total Loan Status YearQtr 2015 Q1 zl Apply _Reset y Corporate New Disbursements in mi
24. 2012Q1 S 18 516 gt Assets Loans u 134 645 Y 0 2012 Q2 28 639 u 32 456 Y 46 078 2012 Q3 S 261 434 u 66 489 E Y 75 165 4 201204 s 503 563 2 M 230 841 F Y 94 051 y Catalog leb ZB oga iN o List Al Y Ss L _ 864 923 My Folders U 1 475 125 gt Y Shared Folders Y ad 201302 N o s 1 289 162 u 196 668 Y 117 887 A Laminas Las n a Y views 9 7 YX di 4 gt Selection Stens ae ORACLE From this tab you can add graphical representation of the data by using the new view button ORACLE Business Intelligence Search All Y Advanced Administration Help Sign Out O Untitled Home Catalo Favorites Dashboards I New Open v Signed In As weblogic Criteria Results Prompts Advanced x Subject Areas M 2 d BAAM TO SP BH RBBB 4 7 Flexcube Information Server Compound Layout ES Best Visualization gt Account Periods ca gt Branch WB Recommended Visualization for gt EJ Currency i E Tiie E Lee Table EX Table gt EGL Master E Pivot Table gt Product gt Ea gt EX Labilty CASA als gt E Assets Loans _ lg Graph ld Bar ld Recommended Subtype Eb Gauge Ez Line dt Vertical Funnel I Area E Horizontal Q Map Pie lili Stacked Vertical Report Account Type m El Performance Tie 2nl 2012 Q2 2012 Q3 Wp Fiters BE Line Bar E Stacked Horizonta
25. ACCOUNT_NUMBER 3 Natural Key ESTB_STG_LOANSA D F CURRENCY_KEY 2 CURRENCY_KEY 2 Dimension Kew ESTB_STG_LOANS C 2 E PRODUCT_KEY 72 PRODUCT_KEY 23 Dimension Keyw ESTB_STG_LOANS P P F CUSTOMER_KEY 23 CUSTOMER_KEY 2 Dimension Key ESTB_STG_LOANS C D L VALUE DATE az VALUE DATE azl Measure wl _FSTR STG LOANS VIZ 7 Click Enrich button to populate the source elements Specify the following details Select the source element that you need to map to the target element Target Element Select the target element to be mapped to the selected source element Key Column Type Select the key column type The drop down list displays the following options e No versioning e Natural key e Versioning Select the appropriate one Transform Rule Define the transform rule 2 4 ORACLE 2 2 3 Maintaining EIS MIS Scheduler You can maintain the Oracle FLEXCUBE Information Server jobs and their dependencies using EIS MIS Scheduler Maintenance screen To invoke this screen type RPDSCP in the field at the top right corner of the application toolbar and click the adjoining arrow button EIS MIS Scheduler Maintenance Job Type Data Transformation y Program Type PLSQL_BLOCK Program ID az Program Action P Program Name Mlenable Flag 1 Of 1 Y Dependency ProgramID Dependency Pr
26. Half Year Denotes whether it is the first half sec ond half of the financial year Week Day Shows whether the day is a weekday weekend Year Number The year of the selected calendar date Year Q Num The quarter of the year of the selected calendar date Quarter Name The name of the quarter i e Q1 Q2 Q3 or Q4 Quarter Number The quarter number of the calendar date i e 1 2 30r4 Month Name The name of the month Month Number The number that represents the month based on the financial year Q1 will have 1 2 3 or 4 Q2 will have 4 5 6 or 7 and so on Day Weekname The name of the day of the calendar date e Monday Tuesday etc Day Yyyymm The calendar date in Yyyymm format Customer Customer No Customer number Customer Name Name of the customer Short Name Short name of the customer Creation Date Date of customer creation Local Branch Local branch of the customer Customer type Type of customer Customer Status Status of the customer O indicates Open and C indicates Closed Customer Category Category to which the customer belong Customer Classifica tion Classification of the customer Customer Segment Segment of the customer Sex Gender of the customer Date of Birth Date of birth of the customer 2 26 ORACLE Folder
27. ORACLE Oracle FLEXCUBE Information Server User Guide Oracle FLEXCUBE Universal Banking Release 12 0 2 0 0 Part No E49740 01 September 2013 Oracle FLEXCUBE Information Server User Guide September 2013 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2013 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed o
28. Sign Out Bank Sourecard E Home Catalog Favorites Dashboards ATA AE CERA Bank Scorecard New Assets and Liabilities Interest Earned and InterestPaid Liabilities Book Liabilities Status New Account Balances and Deposits Interest Paid TD Maturing Status YearQtr 2013 94 zj Apply Reset New Assets and Liabilities in million aal Time run 8 14 2013 4 07 53 PM 2012 04 201301 201302 W Assets W Liabiities Value of New Assets amp Liabilities in milions Type 2012 94 2013 Q1 2013 Q2 2013 Q3 2013 94 Growth Assets 21 76 28 46 113 33 107 54 16 71 84 46 Liablities 40 82 44 00 260 0 00 0 27 0 00 ___ Nowof New Assets amp Liabilities meee Type 2012 04 2013 01 2013 Q2 2013 Q3 2013 94 Growth Assets 4 8 3 g 350 Liabilities 14 15 8 8 _o Grand Total 18 23 11 17 750 Note Values are shown in Currency GBP Refresh Print Export You can view the following details e Value of New Assets and Liabilities in Millions Values of new assets of the selected quarter and four previous quarters and growth percentage Value of new liabilities of the selected quarter and four previous quarters and growth percentage e Number of New Assets and Liabilities Number of new assets of the selected quarter and four previous quarters and growth percentage Number of liabilities of the selected quarter and four previous quarters and growth percentage The foll
29. You can drag and drop the items in the result and rearrange the display If you wish to edit the properties of the graph click Edit icon on the graph item toolbar 205 ORACLE Once the changes are made click Save icon to save the report that you have created OBIEE prompts you to specify the name of the report to save Save As Folders Ma Save In amp My Folders a Shared Folders Test V Shared Folders EJ InterestPaid gt 9 Components gt SJ Flexcube Information gt D Sample Lite gt Test OK cancel Give an appropriate name to the report and click OK button to save it You may also add this dynamic report to a dashboard in OBIEE For details on creating dashboards and adding reports to dashboard refer to the documentation of Oracle Business Intelligence Enterprise Edition 236 ORACLE 3 Function ID Glossary R RPDSCH 5 RPDDTT 2 l ORACLE
30. amp gt Add fitters to the analysis criteria by clicking on Filter option for the specific column in the Selected Columns pane or by clicking on the filter button in the Fitter pane header Add a saved fiter by clicking on add button after selecting its name in the catalog pane Double click on column names in the Subject Areas pane to add them to the analysis Once added drag and drop columns to reorder them Edit a column s properties formula and fitters apply sorting or delete by clicking or hovering over the button next to its name F Account Status is equal to isin O ANDY Is Last Monthday is equal to is in Y y Catalog IATA Ust All gt OD My Folders gt Y Shared Folders javascript void 0 P gt Once you have added the filters and done the required edits click Results tab ORACLE Business Intelligence search All z 9 Advanced Administration Help sign Out Untitk Home Catalog Favorites Dashboards w ewy E Criteria its Prompts Advanced Subject Areas M 8 BSA 82 OPES RAGE UY 7 Flexcube Information Server Compound Layout a gt EJ Account Periods fa gt Branch Title gt ES Currency e ax gt 3 Customer gt Date pia ES gt GL Master gt Produt Year Q y gt Ea Num Report Account Type MTD Interest Paid LCY b E Libiity CASA
31. ank Scorecard The bank scorecard shows the details of assets and liability books of your bank Select the year quarter for which you need to generate the report and click Apply button The Oracle FLEXCUBE Information Server generates the report with the details of the value and total number of assets and liabilities books as of the last day of the quarter The generated report is as follows ORACLE Business Intelligence Bank Scorecard I Bank Scorecard New Assets and Liabilities Interest Earned and Interest Paid Asset Liability Book in million Time run 8 14 2013 3 32 27 PM 100 00 po 4 2 47 1 48 0 48 3 80 00 60 00 40 00 20 00 0 00 L J 2012 Q4 2013 Q1 2013 02 2013 03 __ Value oF Total Assets amp Liabilities in milions i Type 2012Q4 2013Q1 2013 Q2 2013Q3 2013 Q4 Growth Assets 368 37 582 84 1 104 99 1 322 77 2 270 50 za Liabilities 316 44 519 51 1 019 86 1 234 95 2 832 74 129 38 Note Values are shown in Currency GBP Refresh Print Export Liabilities Book Liabilities Status YearQtr 201304 Search All 2 Home New Account Balances and Deposi al Apply Reset y Im Liabiities M Assets Assets Advanced Administration Help Sign Out O Catalog Fi ee eee A 2 ee Interest Paid TD Maturing Status Asset Liability Book No of Accounts constituting Assets amp Liabilities 733 90 0 81 5 Im Liabiities W Assets 2013 Q1 2013 02
32. erties formula ea and fiters apply sorting or delete by clicking or hovering over the button next to its name gt currency gt Gp Customer gt Date Date Liability CASA gt Bel Master B Year Q Num E Report Account Type 5 MTD Interest Paid LCY gt EDProduct gt Ba gt JLabilty CASA A x Filters Date Year Q Num Add fitters to the analysis criteria by clicking on Filter option for the specific column in the Selected Columns pane Liability CASA Report Account Type a saved filter by clicking on add button after selecting its name in the catalog pane Liability CASA MTD Interest Paid LCY gt my Folders gt Y Shared Folders javascriptvoid null anne ORACLE Click Filter icon and select More Columns to select the filters that you need to apply Business Intelligence Search Al z lt aian Untitled Catalog Favortesy Dashboards New v Ba Open v Signed In As weblogic v Criteria Subject Areas V Fexcube Information Server a gt EJ Account Periods gt Branch gt EJ Currency gt 3 Customer gt abate B Columns pane or by clicking on the filter button in the Fiter pane he gt EGL Master gt Product gt Egel Y DLabity CASA E mis Date E Branch Code 4 E customer 1d E Date Key B Module E Product B currency E Account Open Date El New Account Qtr Catalog a 2 aaa renunt Tuna analysis clicking o
33. f the system and the processing related to it are covered in this manual Audience This manual is intended for the following User User Roles Role Function Back office data entry Clerks Input functions for maintenance related to the interface Back office Managers Officers Authorization functions Higher Level Management Analyse business performances Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http Awww oracle com pls topic lookup ctx acc amp id docacc t1 ORACLE 1 4 Abbreviations Abbreviation Description System Unless specified it shall always refer to Oracle FLEXCUBE NPA Non Performing Assets EOFI End of Financial Input RPD Repository Definition File CA Current Accounts SB Savings Bank Account TD Term Deposits OD CC Over Draft Cash Credit SME Small and Medium Enterprises TD P Term Deposit Principal TD l Term Deposit Interest TD P I Term Deposit Principal Interest MIS Management Information System ACY Account Currency LCY Local Currency MTD Month to Date RPD Repository Definition File 1 5 Organization This manual is organized into the following chapters About this Manual gives information on the intended audience It Chapter also lists the various chapters covered in this
34. iteria by clicking on Fiter option for the specific column in the Selected Columns pane or by clicking on the fiter button in the Fitter pane header Add a saved fiter by clicking on add button after selecting its name in the catalog pane Add Filters Here On the left pane expand the FLEXCUBE Information Server subject area You can find the following folders Folder Data Type Description Account Dimensional data Displays the accounting periods maintained for Periods the bank Branch Dimensional data Displays all the branches maintained for the bank Currency Dimensional data Displays all the currencies maintained for the bank Customer Dimensional data Displays all the customers maintained for the bank Date Dimensional data Displays all the dates from the start of accounting period to the end of accounting period GL Master Dimensional data Displays all the general ledgers that are main tained in the system Product Dimensional data Displays all the products that are maintained in the system GL Fact data This displays the general ledger balances availa ble in the system Liability Fact data Displays the liabilities of the bank i e the current CASA and saving accounts Overdraft accounts with positive balance are dis played here 2 24 ORACLE Folder Data Type Description Asset Loans Fact data Displays all the assets of the bank i e loans and
35. ity date Tenor Days Tenor days TD Maturity Days Number of days left for the TD to mature Maturity Date MIS Date Account Creation Date Date of creation of account Account Balance Account balance Monthly Debit Inter est Monthly debit interest Account Balance LCY Account balance in local currency Credit interest LCY Credit interest in local currency Debit Accr Interest Debit accrual interest Debit Interest Debit interest Debit Interest LCY Debit interest in local currency Maturity Amount Maturity amount Maturity Amount Maturity amount in local currency LCY Monthly Credit Inter est Monthly credit interest Monthly Credit Inter est LCY Monthly credit interest in local currency Monthly Total Credit Interest Monthly total credit interest Monthly Total Credit Interest LCY Monthly total credit interest in local cur rency Monthly Total Debit Interest LCY Monthly total debit interest in LCY Monthly Total Debit Interest Monthly total debit interest Monthly Debit Inter est LCY Monthly debit interest in local currency 2 29 ORACLE Folder Field Description Projected Interest Till Maturity Projected interest till maturity Projected Interest Till Maturity LCY Projected interest in local currency till maturity TD Amount TD amount TD Amount LCY
36. l 9 Selection Steps Ee Time Series Line ll 100 Stacked Vertical 2012 Q4 Other Views EZ 100 Stacked Horizontal E Scat x Catalog 2 eb ZB 201301 ol Bubble te al E C 864 933 Radar gt Dm Folders i ls Waterfall gt Y Shared Folders 2013 Q2 1 289 162 196 668 117 887 _ Select the type of graphical representation that you need to add OBIEE will display the graph in the result area ORACLE Business Intelligence Search Al x Advanced Administration Help Sign Out Untitled Home Catalog Favorites Dashboards Mit New B Open Signed In As weblogic y Criteria Results Prompts Advanced x Subject Areas 2 A BaL BBP BHA BARE 4 V Flexcube Information Server Compound Layout gt 3 Account Periods gt Branch beled gt EA Currency pa gt E Customer 2012 Q4 503 563 gt Date 230 841 gt act Master 94 051 gt Product 2013 Q1 o gt Egel 864 933 gt EX Libilty CASA 1 475 125 gt E Assets Loans 95 473 2013 Q2 0 1 289 162 196 668 117 887 MTD Interest Paid LCY 1 800 000 1 500 000 List All gt My Folders gt Y Shared Folders 1 200 000 900 000 600 000 MTD Interest Paid LCY 300 000 JEN E 201201 201202 201203 201204 201301 201302 201303 201304 Year Q Num
37. link to print the report e Export Click this link to export the report in a different format 208 ORACLE 2 5 5 Interest Earned This report shows the interest earned across loan types for each quarter The generated report is as follows Bank Scorecard II Home Catalog Favorites Dashboards New Be Open SignedinAs readuser v Corporate Lending Statistics Retall Asset Book Retal New Disbursements Corporate New Disbursements Interest Earned NPA Status NPA Statistics Total Loan Status YearQtr 2015 Qi Apply Reset y Interest Earned in million Time run 9 3 2013 6 26 28 PM m 201401 Im 2014 02 M 2014 03 2014 04 I 7 o oo ails 7 i HOME ODICC BUSINESS EDUCATION GOLD PERSONAL Unclassified VEHICLE Value of Interest Earned in milions Loan Type 2014Q1 2014Q2 2014Q3 2014Q4 2015 Q1 Growt BUSINESS 003 0 0 0 07 0 EDUCATION 0 01 0 0 14 GOLD o o1 003 0 04 HOME oo 0 10 0 06 OD CC 0 18 021 0 2 PERSONAL o 00 0 081 0 14 Undassified 0 00 0 01 o 01 o 00 0 00 7 VEHICLE oo8 0 18 o 22 0 11 0 05 56 63 Grand Total 0 37 0 72 0 93 0 63 0 69 Value of Interest Earned by Segment in milions Segment 2014Q1 2014Q2 2014Q3 2014Q4 2015 Qi Grow Corporate 017 0 0 36 0 35 0 40 Retail 0 16 _0 45 SME 0 04 0 12 Unclassified 0 00 0 00 0 00 0 00 Grand Total 0 37 0 93 0 63 0 69 You can view the following details e Va
38. lion M2014 01 1201402 201403 M2014 04 201501 Time run 9 3 2013 5 31 48 PM BUSINESS EDUCATION HOME PERSONAL Unclassified Value of Corporate New Disbursements in milions Loan Type 201401 2014 02 2014 03 2014 04 2015 Q1 6rowth Business 2 00 3 00 0 00 4 00 0 00 EDUCATION 0 00 4 00 ooo 0 00 HOME 3 00 0 00 0 00 0 00 PERSONAL 0 00 0 00 0 00 0 00 0 00 Unclassified 0 00 4 00 0 00 0 00 0 00 0 00 Grand Total 5 00 11 00 4 00 0 00 4 00 0 00 No of Corporate New Disbursements Loan Type 2014Q1 2014Q2 2014Q3 2014Q4 2015 Q1 Growth BUSINESS 2 2 EDUCATION HOME z PERSONAL Undassified Grand Total Value of Corporate New Disbursements by Segment in milions Seamant nio mian nana miana 015 01 hrath This report displays the data for the Customer type Corporate You can view the following details e Value of new corporate disbursements in millions for loan types for the selected quarter and four previous quarters including the growth percentage e Total number of new corporate disbursements for loan types the selected quarter and four previous quarters including the growth percentage e Value of corporate disbursements by segment in Millions e Number of corporate disbursements by segment The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this
39. lue of Interest Earned in Millions Interest earned for the selected quarter and four previous quarters and growth percentage for loan types e Value of Interest Earned by Segment in Millions Interest earned for the selected quarter and four previous quarters and growth percentage for segments The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format any ORACLE 2 5 6 NPA Status This report shows the details of non performing assets for each segment This report shows the details of the previous business day The generated report is as follows ORACLE Business Intelligence Search All y gt Advanced Administration Help Signout rites Dashboards Bt New AE Corporate Lending Statistics Retail Asset Book Retail New Disbursements Corporate New Disbursements Interest Earned NPA Status NPA Statistics Total Loan Status NPA Status by Segment Time run 8 14 2013 4 11 00 PM Corporate W Retail SME W Unclassified Value of Total NPA Status by Segment in millions NPA Status amp Corporate Retal SME Undassified DOUB 5 33 5 76 0 00 0 00 11 Loss 2 58 0 00 5 37 0 00 7 95 SUBS 424 o 00 0 00 0 00 4 WACH 2 12 0 00 0 00 0 00 WOFF 0 00 0 00 7 91 0 00 Grand Total 14 27 5 76 13 28 0 00 33 _ Total NPA Status
40. nterest Earned and Interest Pald oooonnininiicinininnnncninnnnnconconnonccnnnnnnnnnnnnnnannos 2 9 2 4 4 Liabilities BOOK os nutes eee ee hadi ead wee 2 10 2 4 5 Liabililios SAUS civic eii eee 2 11 2 4 6 New Account Balances and DeposTtS ooooonicicninconccnncnnccccccnnnannanrnnnnnnnnos 2 12 BALA ter st Pad it zas 2 13 2 4 8 TD Maturing SAUS e o a a EE n EE EEEE nc 2 14 2 5 gt Bank Sc recard Ileen dedicados eaaa aaan 2 14 2 5 1 Corporate Lending Statistics 0 cccccccceeeeceeteeee eee encneeeeeeeneeeeeeenaeeeeeeeee 2 14 2 9 2 Retail Asset BOOK coccion en ees ee 2 16 2 5 3 Retail New Disbursement 2 ccccccccceeeeeeeecenenneceeeeeteeeeeeteetenenensnateees 2 17 2 5 4 Corporate New Disbursements 22 ccceccccceceeeeeeeeeeeeenenneneeeeeeeeeeetteeteens 2 17 299 Niere STE AIN O ocacion A rE E ES 2 19 295 6 NPA SAUS iii eae a eens eee 2 20 29 7 NPA Statisties inet it iaee e ds Bat ated te essai 2 21 2 5 8 Total Loan Status 200000 habs 2 22 2 6 Creating Dynamic Reports seriis cceeee eE EEn eE EEREN ee eaeeeeeetideeeeeeniaeeeenenea 2 23 3 Function ID GIOSSANY uci ctecct oats estet se atria ete eat ee eatin beeen ooa lies 3 1 1 1 1 2 1 3 Introduction 1 Preface This user guide deals with the Oracle FLEXCUBE Information Server The Oracle FLEXCUBE Information Server facilitates reporting of analysable data that helps improved decision making The maintenances required for the proper functioning o
41. ogram Name AZ Date Time Date Time Record Status Authorization Status Maker Checker Mod No Specify the following details Job Type Specify the job type Data Transformation Program Type Specify the program type By default the system displays PLSQL_BLOCK However you can modify this Program ID Select the program ID from the option list Program Name Based on the program ID the system displays the name of the program Program Action Specify the program action Enable Flag Check this box to enable the program action Dependency Program ID Specify the dependency program ID You can select the appropriate dependency program ID from the option list Dependency Program Name Based on the dependency program ID the system displays the name of the dependency program 25 ORACLE 2 3 Note The required EIS MIS scheduler maintenances are available in Oracle FLEXCUBE How ever if you need to modify the maintenances you can do it using this screen Once you have specified the above details save the maintenance Generating Reports You can generate the various preset reports from Oracle FLEXCUBE Information Server Login to Oracle Business Intelligence Enterprise Edition Go to Dashboards The reports are organized under two dashboards viz Bank Scorecard and Bank Scorecard II Oracle Business Intelligence system displays the rep
42. orts for the selected year quarter It also shows the data pertaining the previous four year quarters You can drill down to the account level by clicking the data You can view the following reports under the dashboards Bank Scorecard and Bank Scorecard II e Bank Scorecard Bank Scorecard New Assets and Liabilities Interest Earned and Interest Paid Liabilities Book Liabilities Status New Account Balances and Deposits Interest Paid TD Maturing Status e Bank Scorecard II Corporate Lending Statistics Retail Asset Book Retail New Disbursements Corporate New Disbursements Interest Earned NPA Status NPA Statistics Total Loan Status The reports are displayed across various parameters as shown below Assets All CL accounts and OD CC with negative balance Liabilities All CASA Accounts CA SB TD Nostro Vostro and OD CC with posi tive balance New Assets All open closed existing new assets that have contributed for asset balance New Liabilities All open closed existing new liabilities that have contributed for liabil ity balance 26 ORACLE 2 4 2 4 1 Interest Earned earned All open closed existing new assets that have contributed for interest Interest Paid est paid All open closed existing new liabilities that have contributed for Inter Reports in Bank Scorecard The reports in dashboard Bank Scorecard are discussed below B
43. overdrafts with negative balance The subject areas and their descriptions are available in the following table Folder Field Description Account Periods Period Code Code that identifies the period Branch Code Branch code Start Date Start date of the account period End Date End date of the account period Financial Cycle Financial cycle Year Year of the account period Half Half year of the account period Quarter Quarter of the year of account period Month Month of the period code Branch Branch Code Branch code Branch Name Name of the branch Branch Address 1 First line of the branch address Branch Address 2 Second line of the branch address Branch Address 3 Third line of the branch address Branch LCY Local currency of the branch Closure Date Date of closure of the branch Country Code Country code Parent Code Parent branch code Parent Name Parent branch name Regional Office Regional office code Code Regional Office Name of the regional office Name Currency Currency Code Currency code Currency Description Currency description Date Calendar Date Calendar date all dates from the start and end of accounting periods are available 2 25 ORACLE Folder Field Description Is Last Qtrday The last working day of the quarter Is Last Monthday The last working day of the month
44. owing actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report 26 ORACLE 2 4 3 e Export Click this link to export the report in a different format Interest Earned and Interest Paid This report shows the interest earned and the interest paid for all loan accounts active or liquidated and accounts open or closed across quarters Accruals are considered for this interest calculation However Nostro and Vostro accounts are not included Select the year quarter and click Apply button The generated report is as follows ORACLE Business Intelligence Search All E Advanced Administration Help Signout Bank Scorecard I Home Catalog Favorites Dashboards y Bank Scorecard New Assets and Liabilities Interest Earned and Interest Paid Liabiities Book Liabilities Status New Account Balances and Deposits Interest Paid TD Maturing Status YearQtr 2013 Q4 i Apply Reset y Interest Earned v s Interest Paid in million 2012 04 2013 01 2013 02 2013 03 2013 04 Time run 8 14 2013 4 08 04PM Value of Interest Earned v s Interest Paid in Millions Type 2012 04 2013 01 2013 Q2 2013 Q3 2013 04 Growth lEarned 0 13 0 20 0 10 0 02 0 31 1 711 67 Paid 0 00 0 00 ooo 0 93 101 9 05 Note Values are shown in Currency GBP Refresh Print Export You can view the following details e Interest Earned and In
45. ows the number of new accounts including those which are open and closed in a given quarter and the balance in each account The details in this report are as of the last day of the selected quarter The generated report is as follows ORACLE Business Intelligence Search Al gt Advanced Help Sign Out O Bank Scorecard I lome Catalog avorites Dashboards v EE new gt Bs Open v Signed In As_readuser v Bank Scorecard New Assets and Liabilities Interest Earned and Interest Paid Liabilities Book Liabilities Status New Account Balances and Deposits Interest Paid TD Maturing Status a YearQtr 2013 Q4 zj A Apply Reset New Account Balances Deposits in milion Time run 8 14 2013 6 26 57 PM m2 2013 03 m2013 04 Value of New Account Balance Deposits in milions Account Type 2012 04 2013 01 2013 02 2013 032013 Q ca m 724 014 o 00 0 00 0 00 0 00 0 00 24 60 49 37 235 0 00 zsa 187 0 10 0 00 TD Grand Total 40 82 44 00 2 60 0 00 No of New Account Balance Deposits Account Type 2012 Q4 2013 Q1 2013 Q2 201303 CA 3 o oD cc SB o o o o mo 4 Grand Total Note Values are shown in Currency GBP Refresh Print Export The report shows the following details e Value of new account balance and deposits in millions for the account types and the growth percentage e Number of new account balance and deposits in millions for the accoun
46. r 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 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
47. rch All Sil Advanced Administration Help SignOut weblogic v Analysis and Interactive Reporting l Analysis Create Pz Recent E Dashboard A Analysis and Interactive Reporting Dashboards Yrer Analysis Dashboard More Bank Scorecard II Total Loan Bank Scorecard II NPA Statist E Dashboard Prompt a Published Reporting Open Edit More Open Edit More Y Condition ES Report Report Job More pee l Bank Scorecard II Corporate Bank Scorecard II Retail New Palisa ptos Actionable Intelligence El Report Open Edit More Open Edit More Agent Action Report Job EZ Performance Management Ej Data Model Steet Scorecard KPI KPI Watchlist E Style Template Interest Paid Details Interest Paid Sub Template Marketing Open Edit More Open Edit More x E Segment Segment Tree List Format Actionable Inteligence Asset Book Lending Statistics amp Agent Browse Manage Open Edit More Open Edit More Action Performance Management aa poras x Total NPA Status Details Total NPA Status Qs E My Ani corecar fia ete Open Edit More y Open Edit More y My Reports eer My Scorecards EBgKPI Watchlist My Agent Subscriptions Most Popular 188 My Agents D no recommendations are currently available Most Popular items will be displayed here when results become available segment Marketing Jobs PA Segment Tree
48. reporting are as follows e Extraction of information in a consumable format at all operational levels and management hierarchies e Cross functional data in summary form e Provisions for totals averages changes variances or ratios e Information based on customer types and product types e Historical data for comparisons Maintenances in Oracle FLEXCUBE In order to use the Oracle FLEXCUBE Information Server you need to maintain certain information in Oracle FLEXCUBE These maintenances are discussed under the following headings Maintaining Batch Programs You need to maintain the batch program EMXTRACT using Mandatory Batch Program Maintenance screen This batch extracts the data from Oracle FLEXCUBE during end of financial input EOFI stage You also need to maintain the extraction routine Maintaining Details of Data Transformation Tool You need to map the source entities staging tables to the respective target entities fact and dimension tables using Data Transformation Tool screen To invoke this screen type a ORACLE RPDDTT in the field at the top right corner of the application toolbar and click the adjoining arrow button Data Transformation Tool Ej New E Enter Query Source Entity Target Entity Program Name Surrogate Key Name Program Description Surrogate Key Type ASCII gt Mapping Details Maker Date Time Mod No Checker Date Time Record Status Authorization
49. rmant liabilities for the previous business day The generated report is as follows ORACLE Business Intelligence Search Al E Advanced Administration Help Signout O Bank Scorecard I ome Bs Open Signed In As weblogic y Bank Scorecard New Assets and Liabilities Interest Earned and Interest Paid Liabilities Book Liabilities Status New Account Balances and Deposits Interest Paid TD Maturing Status Liabilities Status in milion Time run 8 14 2013 3 38 29 PM Dormant Type Value of Active Liabilities in Milions Value of Dormant Liabiities in Milions Total No Of Active Liat 7 Total No Of Dormant Liabilities a Y IE 7 K oni 2 se 4 99 107 94 3 a aa af ai Grand Total 1233 85 15 24 46 1 25 Note Values are shown in Currency GBP Refresh Print Export The report shows the following details e Value of active liabilities in millions for the account types e Value of dormant liabilities in millions for the account types e Number of active liabilities for the account types e Number of dormant liabilities for the account types You can click the values in the report to see the details The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format 211 ORACLE 2 4 6 New Account Balances and Deposits This report sh
50. t types and the growth percentage The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format ale ORACLE 2 4 7 Interest Paid This report shows the interest amount paid by the bank across account types for each quarter Accruals are considered for these interest calculations The generated report is as follows Oracle Bl Interactive Dashboards Bank e 3 Googie 2 f D ot 220331 in oracle com 7001 analytics saw dll Dashboard Advanced Administration Help Sign Out O Search All ORACLE Business Intelligence Bank Scorecard I Bank Scorecard New Assets and Liabilities Interest Earned and InterestPaid Liabilities Book Liabilities Status Home Catalog Favorites AAA Open Signed InAs weblogic v New Account Balances and Deposits Interest Paid TD Maturing Status YearQtr 2013Q4 Y Apply Reset Interest Paid in milion Time run 8 14 2013 3 32 33 PM 201204 201301 im 2013 02 2013 03 2013 04 p CA Interest Paid in milions Type 2012 04 2013 91 2013 Q2 2013 03 2013 94 Growth Ica 0 00 0 00 o oo 0 40 0 36 10 47 oDcc ooo ooo o 00 0 00 c 0 00 s oo ooo ooo 12 131 135 mo ooo 0 00 0 00 0 04 60 67 Grand Total 0 00 0 00 0 00 0 93 s05
51. terest Paid in Millions Interest earned for the selected quarter and four previous quarters and growth percentage Interest paid for the selected quarter and four previous quarters and growth percentage The following actions are supported from this screen e Refresh Click this link to refresh the data in the report e Print Click this link to print the report e Export Click this link to export the report in a different format ae ORACLE 2 4 4 Liabilities Book The liabilities book shows the liability account balance and count based on the account type Only open and active accounts are considered for this report Select the year quarter and click Apply button to view the report The generated report is as follows ORACLE Business Intelligence Bank Scorecard 1 Bank Scorecard New Assets and Liabilities Interest Earned and Interest Paid Liabilities Book Liabilities Status YearQtr 2013 Q4 Y Apply Reset Total Liabilities in milion Value of Total Liabilities in millions New Account Balances and Deposits Search All E gt Advanced Help Sign Out O Home Catalog Favorites ATA Be Open Signed InAs readuser Interest Paid TD Maturing Status Time run 8 14 2013 6 27 54 PM 9 568 69 74 667 73 m am 2012 94 2013 01 2013 Q2 2013 Q3 2013 Q4 6rowth Type CA lopjec E Grand Total 90 51 22 86 104 53 182 59 22 44 0 00 0 00 o 00 0 00 58 05 106
52. you need not click Enrich button You can directly specify the following details Source Element Select the source element that you need to map to the target element Target Element Select the target element to be mapped to the selected source element Key Column Type Select the key column type The drop down list displays the following options e No versioning e Natural key e Versioning Select the appropriate one You can add more rows to the list using add button To delete a row check the adjoining check box and click delete button Note The required dimension mapping details are available within Oracle FLEXCUBE Howev er if you need to modify the mapping you can do it using these screens aa ORACLE 2 2 2 1 Mapping Facts You can map the source and target elements and define the key column type and transform rules using Fact Mapping Details screen Fact Mapping Details x Source Entity ESTB_STG_LOANS Target Entity FCT_LOAN Program Name LD _FCT_LOAN Source Target Element Mapping 10f2 gt bl E Source Element Target Element Key Column Type Transform Rule Y MIS_DATE 73 MIS_DATE 73 NaturalKey e TRUNC ESTB_STG _I D l E BRANCH_KEY 23 BRANCH_KEY 23 Dimension Keyi ESTB_STG_LOANS B P 1 F ACCOUNT_NUMBER 3
Download Pdf Manuals
Related Search