Home

FLEXCUBE Information Server User Manual

1. 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 ORACLE 2 4 3 Expired Line Status This report shows details of lines in expired status ORACLE Business Intelligence Enterprise Limits and Collateral Management New Sanctioned Limit Unutilized Limit Expired Lines Status Expired Line Details Limit Sanctioned vs Utilized Quarter 2015 Q3 Sector Select Value y Business Segment Select Value y Industry Select Value x Limit Type Select Value x Analyze By None xl Line Expiry Status in million Time run 12 10 2014 10 19 35 PM Expired Line Status by Sector BANKING M Banking E COMMUNICATIONS HEALTHCARE M NDUSTRY INSURANCE ar MANUFACTURING MUnciassi ed Sector Amount Ovedue in million BANKING 0 00 Banking 0 00 EORNA om HEALTHCARE 0 03 INDUSTRY 0 03 INSURANCE 0 03 m 0 00 MANUFACTURING 0 05 Undassified 2 25 Analyze By Search All EA Limit Details x Country Select Value y Group Select Value x Segment Select Value x Customer Select Value x gt Advanced Administration Help Signout v Enews Bsopeny Signed in As Overdue Amount Recovery Exposure EFO CreditRating Overdrawn Lines Apply _Reset v Expired
2. ORACLE Business Intelligence Search Al El 9 Advanced Adminstration Help Sign Out C new Open Signed In As weblogic y Grtera Results Prompts Advanced 88 Subject Areas K G BSA GOP BR Base 4 7 Fexcube Information Server Compound Layout gt E Account Periods es gt Branch a 0 x gt reny gt 2 Customer gt Date a7 gt DELCM Limts Exposure gt ELCH Lab Year Q Limit Type Limit Sanctioned Ley Limt Utilzed L gt ELCH Track Exposure Num Ae sd gt DELCH Facity 21501 S 10 006 158 063 271 267 gt EBELCM Uti Exposure en Wi J ra zn 201502 S 30 019 386 128 2 373 126 u 56 823 332 996 10 647 462 201503 S 50 034 436 214 4 155 211 u 94 735 839 210 3 000 020 637 407 ax Limit Sanctioned Lcy Limit Utilized Ley 3 500 000 000 000 F 3 000 000 000 000 x Catalog ich 7 8 S Lint Lst Al 5 2 500 000 000 000 po gt 3 My Folders Ei S Limit 2 000 000 000 000 Mi gt Y Shared Folders E Ul zed Ley a U Limit Y 1 500 000 000 000 Im Sanctioned E Ley S 1 000 000 000 000 U Limit E i M Ul zed Loy E 500 000 000 000 2015 01 2015 02 2015 03 Year Q Nun vom 28 79 Nur 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 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 re
3. OK button You will see the New Filter window ORACLE Business Intelligence gt a o Men Fito om ilters Column Year Number TA gt amp cn Operator is equal to is in a Value 2015 ise E 2013 00 El Protea B 2014 00 SOS a u Conver Search Limted Values ox Cancel Select the operator and value Click OK button to add the filter You can add more filters in the same manner The Filters section of the screen displays all the selected filters ORACLE Business Intelligence Search Al gt Advanced Administration Help Sign Out pen y igi As weblogic y Criteria Results Prompts Advanced ao g x Subject Areas gt a Emi 7 Fiexcube Information Server y Selected Columns Qe gt Account Periods 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 properties formula gt Branch and fiters apply sorting or delete by clicking or hovering over the button next to its name gt EA Currency gt 3 Customer Y Date Date ELCM Facilty B calendar Date B Year Q Num E LmtType Lmt Sanctioned Ley 5 I Limt utiized Loy 53 E 1s Last Qtrday amp Is Last Monthday B Haf Year E BM x Filters Tune 3 Year tiumber Om Add fiters to the analysis criteria by clicking on Fiter option for the specific column in the Selected Columns pane or by clicking on
4. Field Description Line Exp Amount LCY Expired amount in local currency Line Expiry Date Date on which line is expired Matured Util Amount Utilized amount matured Mis Date Business Date Module Module New Liab Qtr Flag for the new liability in the quarter Overdrawn Amount Fcy Amount overdrawn in foreign currency Overdrawn Amount LCY Amount overdrawn in local currency Overdrawn Date Date on which amount is overdrawn Recovery Date Date on which amount is recovered Revolving Line Flag to indicate that the line is Revolv ing Util Date Date on which amount is utilized Status Line status Unutilized Limit LCY Amount not utilized in local currency Unutilized Percentage of unutilization Prev Recovery Amount LCY Amount recovered on previous date in local currency ELCM Util Exposure Available Amount FCY Available amount in foreign currency Available Amount LCY Available amount in local currency Exposure Amount FCY Exposure amount in foreign currency Exposure Amount LCY Exposure amount in foreign currency Exposure ID Exposure ID Utilization FCY Utilization in foreign currency Utilization LCY Utilization in local currency Exch Rate Exchange rate Exp Ccy Exposure currency 2 34 ORACLE Folder Field Description Liab ID Li
5. 31 to 90 days greater than 365 da PeriodY upto 30 days 3110 90 days has than 365 days Grand Total lt Analyze By You can analyse the report by the following parameters e Segment e Country e Business segment e Quarter e Sector e Limit type e Group e Liab Number e Industry Select the appropriate dimension from the drop down list and click Apply button The system displays the details of the expired lines analysed based on the selected dimension You can also filter the reports based on the following parameters e Quarter e Country e Group e Segment e Customer e Sector e Business segment 2 14 ORACLE e Industry e Limit type 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 formatYou can view the following details You can drill down to further levels by clicking the respective links as illustrated below Baca By Drill Down values Report Segment For more details Click here Expiry Line Details by Period Details Country For more details Click here Expiry Line Details by Period Details Business For more details Click here Expiry Line Details by Period Details Segment Quarter For more details Click here Expiry Line Detai
6. Business Seg ment 2 8 ORACLE Analyze by Drill bown Drill down Report Report values values Unutilized New Limit Sanc tioned by Limit Type UnSe cured Unuti lized Business Segment Group Group New Limit Sanc Codes and tioned by Group Unclassified Customer Liab No NA Industry Industries New Limit Sanc Secured New Limit Sanc and Unclas tioned by Indus tioned by Indus sified try Secured amp try Secured Unsecured Unsecured New Limit Sanc tioned by Indus try Unsecured 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 9 ORACLE 2 4 2 Unutilized Limit The unutilized limit report shows the details of limits that are not utilised ORACLE Business Intelligence Search All 2 Advanced Administration Help Sign Ou Dashboards new BsOpen SignedIn As Enterprise Limits and Collateral Management o New Sanctioned Limit Unutilized Limit Expired Lines Status Expired Line Details Limit Sanctioned vs Utilized Limit Details Credit Rating Overdrawn Lines Overdue Amount Recovery Exposure gt S Quarter 2015 Q3 z Country Select Value y Group Select Value y Segment Select Value x Customer Select Value y Sector Select Value y Bu
7. Facility E Faciity Id E LimtType Lmt Sanctioned Ley 5 Limit utiized Ley 5 E Fet Faciity Key E LimtType 8 Labilty Key 8 Main Lab ID y Filters E Te i Add fiters 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 Fiter pane header Add Eu a saved fiter by clicking on add button after selecting ts name in the catalog pane E Limit Sactioned Date h Limit Sanctioned Fey Out sanctioned Ley Limit utiized Fey Limit utilized Loy Add Fitters Here Line Amt Recovered Fey une Amt Recovered Ley Line Exp Amount Fey Line Exp Amount Ley E Line Expiry Date Matured util Amt E Ms Date EL Madula y Catalog PTA List Al 4 en ORACLE In order to add filters to the report click the Filter icon ORACLE Business Intelligence Search Al e Advanced Administration Help Sign out O As weblogic y Criteria Results Prompts Advanced 88 A 2a mus gt a gt CELOM Lab xl Selected Columns R k gt GBELCM Track Exposure 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 Y ELM Facility and fiters apply sorting or delete by clicking or hovering over the button next to its name amp Currency E Currency Key ELCM Facility E Customer Key E LmtType 5 Limt
8. Line Status by Business Segment 0 03 0 03 W 000000057 W 000002495 000002496 000002514 E 000002539 W 000002540 000002541 W Unclassified Bus Segment 000000057 000002496 000002514 000002539 000002540 000002541 Undassified Grand Total You can analyse the report by the following parameters e Segment e Country e Business segment e Quarter e Sector e Limit type e Group e Liab Number e Industry Select the appropriate dimension from the drop down list and click Apply button The system displays the details of the expired lines analysed based on the selected dimension You can also filter the reports based on the following parameters e Quarter e Country e Group e Segment e Customer e Sector e Business segment e Industry 2 12 ORACLE e Limit type You can drill down to further levels by clicking the respective links as illustrated below Analyze By Drill Down Drill Down Report values Repon Values Report Segment NA Country NA Business List of Busi Line Expiry Sta For more Line Expiry Sta Segment ness Segments tus by Busi details Click tus by Busi and Unclassi ness Segment here ness Segment fied Details Limit Details Quarter For more Line Expiry Sta details Click tus by Quarter here Details Sector NA Limit Type NA Group NA Liab No NA Industry NA The following acti
9. Segment e Country e Business segment e Quarter e Sector e Limit type e Group e Liab Number e Industry Business Segment 000000057 000002495 000002496 000002514 000002539 Select the appropriate dimension from the drop down list and click Apply button The system displays the recovery details of the overdue amount based on the selected dimension You can also filter the reports based on the following parameters e Quarter e Country e Group e Segment e Customer e Sector e Business segment 2 24 ORACLE e Industry e Limit type You can drill down to further levels by clicking the respective links as illustrated below Analyze Drill Down By Report Drill Down values Report Values Report Segment For more details Overdue Amount Click Here Recovery Details Country For more details Overdue Amount Click Here Recovery Details Business List of Business Overdue Amount For more Overdue Segment Segments and Recovery by Busi details Click Amount Unclassified ness Segment Here Recovery Details Details Quarter List of quarters Overdue Amount For more Overdue Recovery by Quar details Click Amount ter Details Here Recovery Details Sector List of Sectors and Overdue Amount For more Overdue Unclassified Recovery by Sector details Click Amount Details Here Recovery Details Limit Type For more details Overdue Amount Click Here Recovery Details Group For more d
10. below Analyze Drill Drill Down Drill By Down Report Report Down Report Values Report values Values Seg Bank Segment Group Segment ment Group Codes and Group Details Unclassi Customer fied Details Corpo Segment Group Segment rate Group Codes and Group Details Unclassi Customer fied Details Individ Segment Group Segment ual Group Codes and Group Details Unclassi Customer fied Details Country NA Busi Formore Business Liab No Business ness details Seg wise and Seg wise Seg Click Sanc Uti Unclassi Sanc Uti ment Here lized fied lized Details Details Report Quarter NA Sector Formore Sector List of Sec Sector List of Sector Sanc Sanc tors and Sanc Groups Sanc tioned tioned Limit Unclassi tioned Limit and Limit details Type fied Group Unclassi Top20 amp Click Details Details fied Others here Cust Details Formore Sector List of Sec Sector List of Sector Utiliza Utilized tors and Utilized Groups Util Limit tion Limit Type Unclassi Limit and Top20 amp details Details fied Group Unclassi Others Click Details fied Cust here Details Limit NA Type Group Group Group Codes Liability No and Details Unclassi fied Liab No NA 2 17 ORACLE Analyze Drill Drill Down Drill By Down Report Report Down Report Report values values Values Industry Formor
11. 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 bl je E Source Element Target Element Key Column Type x Transform Rule Y MIS_DATE 23 MIS_DATE 72 Natural Key w TRUNC ESTB_STG_l 7 BRANCH_KEY 22 BRANCH_KEY A ACCOUNT_NUMBER 23 ACCOUNT_NUMBER a CURRENCY_KEY 22 CURRENCY_KEY A Dimension Key ESTB_STG_LOANS B Natural Key ESTB_STG_LOANS A Dimension Key ESTB_STG_LOANS C Dimension Key ESTB_STG_LOANS P Dimension Key y ESTB_STG_LOANS C Measure T 1_FSTR STG LOANS Y mais PRODUCT_KEY 72 PRODUCT_KEY A CUSTOMER_KEY az CUSTOMER_KEY VALUE DATE azl VALUE DATE Sf E U 9 0 10 ID ID ID Mr Click Enrich button to populate the source elements 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 ke
12. 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 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 GEBEXTRC using Mandatory Batch Program Maintenance screen This batch extracts the data from Oracle FLEXCUBE during end of transaction input EOTI stage at head office You also need to maintain the extraction routine After EOD operations you need to run the batch GEBEXTRC as intraday During the intraday batch the
13. the analysis Once added drag and drop columns to reorder them Edit a column s properties formula and filters apply sorting or delete by dicking or hovering over the button next to its name x Filters Drop Columns Here P a gt Add fiters to the analysis criteria by diding on Filter option for the specific column in the Selected Columns pane or by dicking on the fiter button in the Filter pane header Add a saved filter by dicking 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 ELCM Limits Dimensional Data Displays limits exposure details maintained for Exposure the bank ELCM Liab Dimensional Data Displays all the liabilities maintained for the bank ELCM Track Fact Data Displays tracking details for exposure maintained Exposure for the bank ELCM Facil Fact Data Displays facili
14. 0 0 72 Note Values are shown in Currency GBP Refresh Print Export You can view this report for the following exposure types e Sector e Currency e Country 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 2520 ORACLE 2 4 11 Exposure Top 10 Liabilities This report shows the exposure details for the top ten liabilities in the system ORACLE Business Intelligence Search AI Advanced Administration Help Sign out Home Catalog Favorites Dashboards new Msopenv Signedin As weblogic Enterprise Limits and Collateral Management xpired Lines Status Expired Line Details Limit Sanctioned vs Utilized Limit Details CreditRating Overdrawn Lines Overdue Amount Recovery Exposure Details Exposure Top10 Liabilities Exposure Type CURRENCY Apply Reset v Exposure for Top 10 Liabilites in milion Time run 12 10 2014 10 26 05 PM IM Exposure Utilized N JuH1S IM Exposure Amount 5 00 5 00 1 15 wall A A 0 17 ML OJOS 00s 000000004 000000010 000000016 000002481 BIRLALIAB LIAPUS001 Exposure Amount in million Exposure Utilized in million Liab No Name 11 Jul 15 11 Jul 15 000000004 000000004 19 90 000000010 000000010 30 00 000000016 000000
15. 016 23 90 000002481 000002481 69 70 BIRLALIAB BIRLALIAB 158 19 LIAPUSOO1 LIABILITYO1 Grand Total Note Values are shown in Currency GBP Refresh Print Export You can view this report for the following exposure types e Country e Currency e Sector You can drill down to further levels by clicking the respective links as illustrated below Analyze By Report Drill Down values Report Country Liab Name Exposure Top 10 Liabilites Details Currency Liab Name Exposure Top 10 Liabilites Details Sector Liab Name Exposure Top 10 Liabilites 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 ar ORACLE 2 5 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 Search All Favorites w Advanced Hepr Signout Dashboards v bipuser v Create Ziff Analysis and Interactive Reporting Analysis Filter Gilt Published Reporting ES Report Job Actionable Intelligence Action Browse Manage D Al Content v 188 My Analyses ig My Reports Laa My Scorecards Marketing Jobs Get Start
16. 14 2 4 5 Limits Sanctioned VS Utilized oooonionocnnnnnnnnnnnnnnnnncconconccnncnnccnnnnnnnnnnrnnnnnos 2 16 2 4 6 Limit Details a arena rien Denen 2 18 24 0 Credit RIINI aci a 2 20 2 4 8 OVerdrawn Eines u as steile 2 22 2 4 9 Overdue Amount Recovery ussssessnsnnnnnnssnnnnnnnnnnnnnnnnnnnnnnnnnnnnrsnnnnnnnn nn 2 24 2 4 10 Exposure Details sisas iiaia eaa ia eE aA E ar Ea aaia ia Ea 2 26 2 4 11 Exposure Top 10 Liabilities oooonmoninnicnnnnnnccicnnnnnnncconcnnccnncnnccnnnnnnnnrnrrrnnnno 2 27 2 5 Creating Dynamic Reports reie eE TRA 2 28 3 Function ID Gloss SAY 2 4 3 1 1 Preface 1 1 Introduction FLEXCUBE Information Server facilitates reporting of analysable data that helps improved decision making The maintenances required for the proper functioning ofthe system and the processing related to it are covered in this manual 1 2 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 1 3 Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http www oracle com pls topic lookup ctx acc amp id docacc 1 4 Abbreviations Abbreviat
17. ANCE MANUFACTURING u of oo a aaa am 0 cn 3 en MANUFACTURING o oo o oo 0 oo ol ooj o oo Undassified o oo 2 oss 2 on ol ooj 1 oo Grand Total 1 000 9 1 000 000 63 5 020 ooo 4 00 Sanctioned in million Utilized in million Sector 11 Jul 2015 Growth 11 Jul 2015 Growth BANKING 0 02 100 00 0 02 100 00 Banking 0 01 100 00 0 00 0 00 COMMUNICATIONS 126 100 00 146 100 00 HEALTHCARE 0 06 100 00 0 00 100 00 INDUSTRY R 0 44 100 00 0 00 0 00 INSURANCE 10 09 100 00 1 000 000 00 _ 100 00 m o oo 1o oo 0 00 0 00 x m J Analyze By You can analyse the report by the following parameters e Segment e Country e Business segment e Quarter e Sector e Limit type e Group e Liab Number e Industry Select the appropriate dimension from the drop down list and click Apply button The system displays the details of the credit ratings based on the selected dimension You can also filter the reports based on the following parameters e Quarter e Country e Group e Segment e Customer e Sector 2 20 ORACLE e Business segment e Industry e Limit type You can drill down to further levels by clicking the respective links as illustrated below Analyze By Drill Down values Report Segment For more details Click here Credit Rating wise Utilization Report Country For more details Click here Credit Rating wise Utilization Report Business Segment For
18. ORACLE Oracle FLEXCUBE Information Server User Guide Oracle FLEXCUBE Enterprise Limits and Collateral Management Release 12 1 Part No E59502 01 December 2014 Oracle FLEXCUBE Information Server User Guide December 2014 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 2014 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 I
19. SHARCOLT2 SHARCOLT2 0 05 0 00 Unsecured Undassified Undassified Undassified 2015Q3 000000010 000000010 0 50 0 10 EXPIRED 0 01 0 53 000000025 000000027 0 00 0 00 000000079 000000079 _0 02 0 00 000000396 000000396 0 02 0 00 000000401 000000401 0 02 0 00 000000402 000000402 0 02 0 00 000000408 000000408 0 02 0 00 YE Rows 1 25 Note Values are shown in Currency GBP Analyze By You can analyse the report by the following parameters e Segment 208 ORACLE e Country e Business segment e Quarter e Sector e Limit type e Group e Liab Number e Industry Select the appropriate dimension from the drop down list and click Apply button The system displays the details of limits based on the selected dimension You can also filter the reports based on the following parameters e Quarter e Country e Group e Segment e Customer e Sector e Business segment e Industry e Limit type 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 4 7 Credit Rating Credit rating report shows the details of credits provided to various sectors classified based on the credit rating ORACLE Business Intelligence Search Al Adva
20. Sanctioned Ley Limit Utilzed Ley B Date Key E Facity 1d B Fet Facility Key E LimtType E Lebity Key E x Fiters ELCM Facity Limt Type El B man Liab 10 Add fitters to the analysis criteria by clicking on Filter option for the specific column in the Selected Columns pane ELCM Facilty Lim t Sanctioned Ley E header E Lab ty Number Add a saved filter by clicking on add button after selecting its name in the catalog pane E Une Code Lint Sactioned Date Add Fiters Here Lim Sanctioned Fey D Limt Sanctioned Ley Y Limit Utilized Fey Limit utilized Ley 4 Une Amt Recovered Fey Line Amt Recovered Ley D Line Exp Amount Fey D Lne Exp Amount Ley amp Line Expiry Date Gh Matured uti Amt y Catalog D bf Ci Est Al D T Folders gt Shared Folders Click Filter icon and select More Columns to select the filters that you need to apply ORACLE Untitled Criteria Subject Areas Eu gt EJ Account Periods amp Bench gt Currency Filters amp D Customer Add fiters t sis crit Y abate Add a saved fiter by clicking E Calendar Date E Is Last Qtrday E Is Last Monthday i E Half Year Year Number i E Quarter Name E Quarter Number E Month Name E Month Number EB Day Weekname amp Day Yyyymm ie E ELCM Limits Exposure i gt PELCM Liah OK cancel Catalog 236 ORACLE Select the required column and click
21. ability ID Main Liab ID Main Liability ID Util Amt Utilization Amount Util Ccy Utilization Currency Util ID Utilization ID Liab Name Liability Name Liab No Liability Number Exp Util Fey Liability Number Exp Util Ley Exposure utilized in local currency Mis Date Business Date Cparty Appetite FCY Counterparty appetite in foreign cur rency Cparty Appetite LCY Counterparty appetite in local currency 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 Double click a column name to add it to the report The selected columns are displayed on the screen Search AI Advanced Administration Help Sign Out ORACLE Business Intelligence Untitled jome vortesw Dashboardsy i Newv MeOpeny Signed In As weblogic v Criteria Results Prompts Advanced 88 o xl Subject Areas gt Huis reer meu gt CELM Track Exposure x Selected Columns B e 7a ELM Fadity 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 8 currency and fiters apply sorting or delete by clicking or hovering over the button next to its name E Currency Key amp Customer Key E Date Key ELCM
22. d Limit Details CreditRating Overdrawn Lines Country Select Value x Group Select Value x Segment Select Value x Customer Select Value x Select Value y Industry Select Value x Limit Type Select Value x Analyze By Overdrawn Lines by Sector in million For more details Click Here Overdrawn by Amount 397 Count above 50000 T jav count Amount in Upto 30 days Banking 2 COMMUNICATIONS 4 4 0 00 MANUFACTURING 3 Undassified al COMMUNICATIONS 5 HEALTHCARE 2 INDUSTRY al 31 to 60 days Overdrawn Amount in million Count labove 50000 397 Dashboards it New Bs Open Signed In As weblogic v Exposure C 0 Overdue Amount Recovery None gt Apply Reset y Overdrawn by 397 Count Mabove 50 doverdrawn EEn Grand Total Analyze By You can analyse the report by the following parameters e Segment e Country e Business segment e Quarter e Sector e Limit type e Group e Liab Number e Industry Select the appropriate dimension from the drop down list and click Apply button The system displays the details of the overdrawn lines based on the selected dimension You can also filter the reports based on the following parameters e Quarter e Country e Group e Segment e Customer e Sector e Business segment 2 22 ORACLE e Industr
23. d on the selected dimension You can also filter the reports based on the following parameters e Quarter e Country e Group e Segment e Customer e Sector 2 ORACLE e Business segment e Industry e Limit type You can drill down to further levels by clicking the respective links as illustrated below tioned by Type Analyze by Drill bown Drill down Report Report values values Segment Bank New Limit Sanc tioned by Seg ment Bank Corporate New Limit Sanc Group Code and New Limit Sanc tioned by Seg Unclassified tioned by Seg ment Corporate ment Corporate Customer Individual New Limit Sanc tioned by Seg ment Individual Country NA Business List of Busi New Limit Sanc Secured New Limit Sanc Segment ness Seg tioned by Busi tioned by Busi ments and ness Segment ness Segment Unclassified Secured amp Secured Unsecured Unsecured New Limit Sanc tioned by Busi ness Segment UnSecured Quarter NA Sector List of Sec New Limit Sanc tors and tioned by Sector Unclassified Secured amp Unsecured Limit Type Secured New Limit Sanc Utilized New Limit Sanc tioned by Type tioned by Type Secured Secured Uti lized Business Segment Unutilized New Limit Sanc tioned by Type Secured UnUti lized Business Segment Unsecured New Limit Sanc Utilized New Limit Sanc tioned by Limit UnSecured Type Unse cured Utilized
24. e Industry List of Industry List of Industry Sanc Sanc Industries Sanc Groups Sanc tioned tioned Limit and tioned Limit and Limit details Type Unclassi Group Unclassi Top20 amp Click Details fied Details fied Others here Cust Details Formore Industry List of Industry List of Industry Utiliza Utilized Industries Utilized Groups Util Limit tion Limit Type and Limit and Top20 amp details Details Unclassi Group Unclassi Others Click fied Details fied Cust here 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 2 4 6 Limit Details Limit details report shows the details of limits maintained in the system This report is displayed in table format ORACLE Business Intelligence Search Al x Advanced Administration Help Sign Out Enterprise Limits and Collateral Management Home Catalog Favorites Dashboards it New Ba Open SignedInAs weblogic v New Sanctioned Limit Unutiized Limit Expired Lines Status Expired Line Details Limit Sanctioned vsUtized Limit Details CredtRating Overdrawn Lines Overdue Amount Recovery Exposure C 530 Quarter 2015 Q3 z Country le alue y Group Select Value y Segment Selec x Customer Se
25. e 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 Program Name LD _DIM_ACC_PERIOD Source Target Element Mapping 10f1 5 Source Element Target Element Key Column Type a LH z el 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 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 ORACLE 2 2 2 1 2 2 3 Mapping Facts You
26. ed Introduction to Oracle BI Orade BI EE Documentation fi Download BI Desktop Tools v Help Contents v a De Orade Technology Network Recent Dashboards Enterprise Limits and Collateral SO open More v 58 Enterprise Limits and Collateral Open More y More Dashboards Others Expiry Line Details by Period Open Edit More LA Most Popular oo Es late Enterprise Limits and Collateral Open More y Enterprise Limits and Collateral Open More y New Limit Sanctioned by Segme Open Edit More E WB Report Job Actionable Intelligence E action Open More y DO ara DO tale No recommendations are currently available Most Popular items will be displayed here when results become available Click New on the toolbar and select Analysis You will be prompted to select the Subject Area ORACLE Business Intelligence Create AA Analysis and Interactive Reporting Analysis Filter 8 Published Reporting ES Report Job fod Actionable Intelligence Action Browse Manage 133 Al Content y ig My Analyses igh My Reports igp My Scorecards Marketing Jobs Get Started Introduction to Orade BI Orade BI EE Documentation Download BI Desktop Tools v Help Contents v Orade Technology Network Select FLEXCUBE Information Server Recent Dashboard
27. er than 10 003 074 41 146 67 46 67 75 00 17 165 10 greater 365 days m ER 50 to Grand Total 10 216 781 84 183 86 187 64 21042 18 7338 000 000 02 greater W fan 75 10 000 000 01 12 000 000 00 Upto 30 days 31 to 90 days greater than 365 days Analyze By You can analyse the report by the following parameters e Segment e Country e Business segment e Quarter e Sector e Limit type e Group e Liab Number e Industry Select the appropriate dimension from the drop down list and click Apply button The system displays the details of the unutilised limits analysed based on the selected dimension 200 ORACLE You can also filter the reports based on the following parameters e Quarter e Country e Group e Segment e Customer e Sector e Business segment e Industry e Limit type You can drill down to further levels by clicking the respective links as illustrated below Analyze By Drill Down Drill Down Report values Report Values Report Segment Bank Unutilized Limit by Segment Bank Corporate Unutilized Limit by Group Code and Unutilized Segment Corpo Unclassified Limit by Seg rate ment Corpo rate Liability No Individual Unutilized Limit by Segment Individ ual Country NA Business NA Segment Quarter NA Sector NA Limit Type For More Unutilized Limit by Details Click Limit Type Coun Here try Group NA Liab No NA Industry NA
28. etails Overdue Amount Click Here Recovery Details Liab No For more details Overdue Amount Click Here Recovery Details Industry For more details Overdue Amount Click Here Recovery 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 2 25 ORACLE 2 4 10 Exposure Details This report displays the details of exposure ORACLE Business Intelligence Search AI gt Advanced Administration Help Sign Out Enterprise Limits and Collateral Management Favorites new Be Open Signed in As weblogic y Unutlized Limit Expired Lines Status Expired Line Details Limit Sanctioned vs Utiized Limit Details CreditRating Overdrawn Lines Overdue Amount Recovery Exposure Details Exposurt gt 30 Exposure Type Sector zi Apply _Reset v Exposure Details by Sector in milion Time run 12 10 2014 10 25 12PM 1 399 93 1 199 94 1 200 00 999 95 11 Jul 2015 E IM Exposure Amount 11 Jul 2015 Exposure MM Ui Amount COMMUNICATIONS Exposure Amount in million Exposure Utilized Amount in million Exposure Amount Utilized Amount Sector Bank s Exposure Rating 11 Jul 2015 O ios m 11 Jul 2015 11 Jul 2015 COMMUNICATIONS A 0 20 0 72 0 20 0 72 STEEL 0 00 0 00 i Grand Total 0 2
29. ion Main Liab ID Main Liability ID 2 32 ORACLE Folder Field Description ELCM Track Expo sure Exposure Currency Exposure Currency Exposure ID Exposure ID Exposure Key Exposure Key MIS Date MIS Date Available Amount FCY Amount Available in Foreign Currency Available Amount LCY Amount Available in Local Currency Exposure Amount FCY Exposure Amount in Foreign Currency Exposure Amount LCY Exposure Amount in Local Currency Utilisation FCY Utilisation Amount in Foreign Currency Utilisation LCY Utilisation Amount in Local Currency ELCM Facility Currency Currency Code Facility ID ID of each facility Limit Type Type of limit Secured or unsecured Main Liab ID Main Liability ID Liability Number Liability Number Line Code Identifier for the line Limit Sanctioned Date Date on which limit is sanctioned Limit Sanctioned FCY Limit sanctioned in foreign currency Limit Sanctioned LCY Limit sanctioned in local currency Limit Utilized FCY Limit utilized in foreign currency Limit Utilized LCY Limit utilized in local currency Line Amount Recov ered FCY Amount recovered in foreign currency Line Amount Recov ered LCY Amount recovered in local currency Line Exp Amount FCY Expired amount in foreign currency 2 33 ORACLE Folder
30. ion Description System Unless specified it shall always refer to Oracle FLEXCUBE Enterprise Limits and Management Collaterals RPD Repository Definition File MIS Management Information System LCY Local Currency FCY Foreign Currency EOTI End of Transaction Input 1 5 Organization This manual is organized into the following chapters About this Manual gives information on the intended audience It Chapter 1 also lists the various chapters covered in this User Manual Oracle FLEXCUBE Information Server discusses about the features Chapter 2 which are to be maintained in Oracle FLEXCUBE for enterprise reporting and the pre shipped reports 14 ORACLE Function ID Glossary has alphabetical listing of Function Screen ID s Chapter 3 used in the module with page references for quick navigation 1 6 Related Documents You may refer the following manuals for more information 1 7 Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function ES Exit Add row Ea Delete row E Option List Refer the Procedures User Manual for further details about the icons Tg 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
31. ired Line Details Limit Sanctioned vs Utilized Limit Details CreditRating Overdrawnlines Overdue Amount Recovery Exposure 30 Quarter 2015 Q3 2 Country Select Value x Group Select Value x Segment Select Value y Customer Select Value y Sector Select Value y Business Segment Select Value y Industry Select Value y Limit Type Select Value y Analyze By None Apply Reset y New Limit Sanctioned by Segment in milion Time run 12 10 2014 10 16 28 PM IM individual IM Corporate W Bank 2015 03 2015 02 2015 01 2014 04 Currency details in million g Values in million p Currency 2015 Q3 2015 Q2 2015 Q1 2014 Q4 Segment 2015 Q3 2015 Q2 2015 Q1 2014 Q4 Growth GBP 10 90 4 26 2 56 18 894 33 Bank 0 20 0 14 0 17 100 00 o oo ooo 0 00 0 00 Corporate 0 032 1 64 18 912 89 100 00 0 00 T 0 00 0 02 Individual 10 67 66 0 78 26 76 100 00 0 00 00 0 00 0 10 Grand Total 10 90 2 56 18 939 82 100 00 0 00 0 00 29 04 Note Values are shown in Currency GBP Refresh Print Export Analyze By You can analyse the report by the following parameters e Segment e Country e Business segment e Quarter e Sector e Limit type e Group e Liab Number e Industry Select the appropriate dimension from the drop down list and click Apply button The system displays the details of the new sanctioned limits in graph and tables analysed base
32. ist Schedule Based on the selected scheduler parent program ID the system displays the name of the schedule Note The required scheduler maintenances are available in Oracle FLEXCUBE However if you need to modify the maintenances you can do it using this screen 25 ORACLE Once you have specified the above details save the maintenance 2 3 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 as tabs under the dashboard You can drill down to the account level by clicking the data Following reports are available under the dashboards New Sanctioned Limit Unutilized Limit Expired Lines Status Expired Line Details Limit Sanctioned vs Utilized Limit Details Credit Rating Overdrawn Lines Overdue Amount Recovery Exposure Details Exposure Top 10 Liabilities 2 4 Reports The reports that you can view from the dashboard are discussed below ORACLE 2 4 1 New Sanctioned Limit The New Sanctioned Limit report shows the details of new limit amounts sanctioned by the bank ORACLE Business Intelligence Search Al E Advanced Administration Help signout Enterprise Limits and Collateral Management s Catalog Favorites Dashboards y Bs Open Signed In As weblogic y New Sanctioned Limit Unutlized Limit Expired Lines Status Exp
33. lect Value y Sector Sele ue y Business Segment Sel ue y Industry t x Limit Type Select Value x Analyze By None xi Apply_ _ Reset y Detailed Limit Report in milion Time run 12 10 2014 10 22 16 PM Segment Country Business Segment Limit Type Group Industry Sector Quarter Liab No LiabName Limit Sanctioned in million Limit Utilized in million Status Bank GB 000002435 Unsecured Undassified ESSERSTEELS INDUSTRY _ 2015Q3 000002538 000002538 0 05 0 00 000002539 Unsecured Undassified ESSERSTEELS INDUSTRY 2015 Q3 000002539 000002539 0 05 0 00 000002540 Secured _jUndassified ESSERSTEELS INDUSTRY 2015Q3 000002540 000002540 0 03 0 00 Undassified Unsecured Undassified KB Banking 201503 LIABKVBO1 LIABKVBO1 0 01 0 00 Undassified Undassified 2015Q3 000002488 KISHORELIAB 0 08 0 00 000002640 RKLIAB 0 20 0 00 us 000002486 Secured _jUndassified ESSERSTEELS INDUSTRY 2015Q3 LIABEK203 Bank Liabilty 0 00 0 00 Corporate GB 000002435 Unsecured Undassified RELTANCE HEALTHCARE 2015 Q3 000002542 000002542 0 03 0 00 000002541 Unsecured Undassified RELIANCE HEALTHCARE 2015 Q3 000002541 000002541 0 03 0 00 Undassified Secured Undassified Unclassified Undassified 221503 000002492 000002492 3 50 0 00 EXPIRED enna legen 10 000 00 0 12 001000409 001000409 0 01 0 00 CORPLIAB CORPLIAB 0 00 0 00 LIABOS LIABOS 0 01 0 00 LIABOG LIABO6 0 02 0 00 SHARCOLT1 SHARCOLT1 0 00 0 00
34. ls by Period Details Sector For more details Click here Expiry Line Details by Period Details Limit Type For more details Click here Expiry Line Details by Period Details Group For more details Click here Expiry Line Details by Period Details Liab No For more details Click here Expiry Line Details by Period Details Industry For more details Click here Expiry Line Details by Period 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 ORACLE 2 4 5 Limits Sanctioned Vs Utilized This report shows the details of sanctioned limits and the utilized limits ORACLE Business Intelligence Search All Y Advanced Administration Help y Sign Out Enterprise Limits and Collateral Management ome Catalog Favorites D v Enews BsOpen SignedinAs weblogic v New Sanctioned Limit Unutiized Limit Expired Lines Status Expired Line Details Limit Sanctioned vs Utilized Limit Details CreditRating Overdrawn Lines Overdue Amount Recovery Exposur 0 Quarter 2015093 y Country Select Value x Group Select Value y Segment Select Value x Customer Select Value y Sector Select Value y Business Segment Select Value y Industry Select Value y Limit Type Select Value y Analyze By None zi App
35. ly Reset Limit Sanctioned vs Utilized by Segment in million Time run 12 10 2014 10 21 22 PM IM individual IM Corporate M Bank 11 Jul 15 Utilized 11 Jul 15 Sanctioned Limit Sanctioned in million Limit Utilized in million Limit Sanctioned in million Limit Utilized in million Segment 11 Jul 15 Growth 11 Jul 15 Growth Currency 11 Jul 15 Growth 11 Jul 15 Growth Bank 0 51 100 00 0 00 0 00 l 21285 100 00 1 000 005 70 100 00 Corporate 28 917 78 100 00 155 100 00 INR i 0 00 100 00 0 00 individual 40 05 100 00 1 000 004 24 100 00 Pr 0 02 100 00 0 00 Grand Total 28 958 34 100 00 11 000 005 79 100 00 wo 0 10 100 00 0 19 luso 23 04 100 00 0 00 Note Values are shown in Currency GBP Refresh Print Export Analyze By You can analyse the report by the following parameters e Segment e Country e Business segment e Quarter e Sector e Limit type e Group e Liab Number e Industry Select the appropriate dimension from the drop down list and click Apply button The system displays the details of the sanctioned and utilized limits based on the selected dimension You can also filter the reports based on the following parameters e Quarter e Country e Group e Segment e Customer e Sector e Business segment e Industry 246 ORACLE e Limit type You can drill down to further levels by clicking the respective links as illustrated
36. more details Click here Credit Rating wise Utilization Report Quarter For more details Click here Credit Rating wise Utilization Report Sector For more details Click here Credit Rating wise Utilization Report Limit Type For more details Click here Credit Rating wise Utilization Report Group For more details Click here Credit Rating wise Utilization Report Liab No For more details Click here Credit Rating wise Utilization Report Industry For more details Click here Credit Rating wise Utilization Report 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 21 ORACLE 2 4 8 Overdrawn Lines This report shows the details of overdrawn lines ORACLE Business Intelligence Enterprise Limits and Collateral Management New Sanctioned Limit Unutilized Limit Expired Lines Status Quarter 2015 Q3 Sector Select Value y Business Segment Time run 12 10 2014 10 23 47 PM Overdrawn Lines Report in days 85 5 15 1 26 155 157 1 999 9 Count Overdrawn Amount E Upto 30 days H greater than 90 days MM 31 to 60 days Expired Line Details Search All M gt Advanced Administration Help Sign Out Home Catalog Favorites v Limit Sanctioned vs Utilize
37. n 12 10 2014 10 24 31 PM For more Quarter details Click Here Overdue Amount Overdue Amount Recovered by Quarter Overdue MM Amount Overdue Amount Recovered Quarter Overdue Amount in million Overdue Amount Recovered in million 201593 2 43 0 00 Limit Sanctioned vs Utilized Value 2 Group Select Value Search All X Advanced Administration Help SignOut Home Catalog Favorites w Limit Details CreditRating Overdrawn Lines x Segment Select Value Dashboards fi New 5 Open v Overdue Amount Recovery g Signed In As_weblogic v 0 Exposure x Customer Select Value y Select Value x Industry Select Value y Limit Type Select Value x Analyze By None iz Overdue Amount Recovery in milion For more Sector details Click Here Overdue Amount Overdue Amount Recovered by Sector 225 IM BANKING IE COMMUNICATIONS I HEALTHCARE INDUSTRY INSURANCE ar MANUFACTURING Unclassified 09939 0 00 0 00 9 Overdue Amount Overdue Amount Recovered Overdue Amount in million Overdue Amount Recovered in million 0 00 0 0 Apply Reset y For more Business Segment details C Overdue Amount Overdue Amount Recove Segment El 2 0 49 oo 003 0 03 His 049 Overdue Amount Recovered Overdue Amoun Analyze By You can analyse the report by the following parameters e
38. nced Administration Help Sign Out Enterprise Limits and Collateral Management Home Catalog Favorites Dashboards new Bs Open Signed InAs weblogic v New Sanctioned Limit Unublized Limit Expired Lines Status Expired Line Details Limit Sanctioned vs Utiized LimitDetals Credit Rating Overdrammlines Overdue AmountRecovery ExposueD 5 Quarter 2015 Q3 Country Select Value x Group Select Value y Segment Select Value x Customer Select Value y Sector Select Value x Business Segment Select Value y Industry Select Value y Limit Type Select Value y Analyze By None fe Y Sector Credit Rating Report by Sector in milion Time run 12 10 2014 10 22 47 PM For more details Click Here 11 Jul 2015 11 Jul 2015 1 199 999 94 Z 1 000 000 00 mAs a artt B Je Bar Value in Value in Value in Value in Value ii Sector ica count Go 799 999 96 is Count maana Count million Une million COU million COUN million HSA BANKING o oo o oo oj oo ol ooo 1 00 moana CCRAA Banking o 00 1 oo oj oo ol om ol oo te 1 399 999 98 Hea COMMUNICATIONS 1 0 00 1 00 al om o om 1 oo CCRC HEALTHCARE o 00 ol oo ol oo o om 1 oo 199 999 99 MA Unclassified INDUSTRY o 00 4 00 1 00 oj o00 oj oo 0 00 0 02 0 10 1 36 0 00 0 00mDaHD 8 56 INSURANCE o o 00 1 1 000 000 00 1 ooo al ooo oj 00 BANKING COMMUNICATIONS INDUSTRY T Unclassified 30 Banking HEALTHCARE INSUR
39. ntent 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 Contents We Pref ce nn A 1 1 1 1 Introduction a a aa anaa eaa aa a aaan aa e in een Tai 1 1 1 2 A di CO res ra sis 2a A Daas dae ii 1 1 1 3 Documentation Accessibility 4444444snnnnnnennnnnnennennnnnennnnennnnnnnennnnnnne nenn 1 1 1 4 ADDFEVIStIONS ciar id O ia dededaeeedeses 1 1 1 9 QOVQANIZATION in O iii 1 1 1 06 Related Documents ceci tas lis e a 1 2 1 7 2Glossary OIC A A A A aar 1 2 2 Oracle FLEXCUBE Information Server uunuunnnnnsssnennnnnnnnnnnnnnnnnnnnnnn nn 2 1 2 1 IHtroduetion Detras linie 2 1 2 2 Maintenances in Oracle FLEXCUBE uunsssnnenesnnnnnnnnnnnnnannnnnnnnnnnenne nn 2 1 2 2 1 Maintaining Batch Programs 244ssssrsnnnnnnnnsnnnnnnnnnsnnnnnnnnnnnnnnnnnnn nn 2 1 2 2 2 Maintaining Details of Data Transformation Tool u 244 nn 2 1 2 2 3 Maintaining FLEXCUBE Information Server Scheduler 2 4 2 3 Generating Rep rS esner il Be nee 2 6 24 NO 2 6 2 4 1 New Sanctioned Limit 24 uu0nu44nnnrnnnnnnnnnnnnnnnnannnnnnnennnennnnn nennen 2 7 24 2 Unutilized LIN 325222 engen HE apa ee 2 10 2 4 3 Expired Ele Status iio tend ade nee hei 2 12 2 4 4 Expired Line DetallS ciococici rita 2
40. ons 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 13 ORACLE 2 4 4 Expired Line Details Expired line details report shows the details of expiry lines Search All ORACLE Business Intelligence Enterprise Limits and Collateral Management New Sanctioned Limit Unutilized Limit Expired Lines Status Expired Line Details Limit Sanctioned vs Utilized Limit Details Credit Rating Quarter 2015 Q3 Sector Country Select Value x Group Select Value y Segment Select Value Select Value y Business Segment Select Value y Industry Select Value x Limit Type Expiry Line Details by Limit Type in million Time run 12 10 2014 10 20 26 PM For more Details Click Here Overdue Amount by Period 0 15 MM Upto 30 days H 31 to 90 days H greater than 365 days Value in milion Period poca 31 to 90 days greater than 365 days Grand Total Value in million Note Values are shown in Currency GBP Upto 30 days X Advanced Administration Help Signout Signed In As_weblogic v z Customer Select Value y Overdrawn Lines Overdue Amount Recovery Exposurel Select Value y Analyze By None Apply Reset Overdue Count amp Value by LimitType ES 0 13 0 03
41. port to save es om Folders Ma sen amp J My Folders 2 Shared Folders Test BIA 7 Shared Folders Lime Sanctioned vs Utiized by Type gt Components gt Belem fis reports gt 3 FLEXCUBE gt O Sample Lite gt O Test Eu Hime Sanctioned Vs Ut zed by Type Description m _0K 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 2 ORACLE 3 Function ID Glossary R RPDSCH 824220 2 5 RPBDTT ua 2 2 s ORACLE
42. s Enterprise Limits and Collateral ag BI open More y fag Enterprise Limits and Collateral BA Open More v More Dashboards Others Expiry Line Details by Period Open Edit More Y Most Popular Enterprise Limits and Collateral Open More y Enterprise Limits and Collateral Open More New Limit Sanctioned by Segme Open Edit More y gt Advanced Help sionout Rs Open v Signed In As bipuser y E Create Direct Database Request E create Analysis from Simple Logical SQL by enter le logical SQL t D No recommendations are currently available Most Popular items will be displayed here when results become available 2 28 from the list ORACLE Navigate to Criteria tab ORACLE Business Intelligence Search All Y gt Advanced Help signout Untitled Criteria Results Prompts gt Subject Areas gt Account Periods gt Branch gt currency gt Customer gt date gt JELCM Limits Exposure gt BEM Liab gt CELOM Track Exposure gt GEM Facility gt BELOM Uti Exposure x Catalog 2 List All gt shared Folders Advanced a Mia V Flexcube Information Server x Selected Columns Home Catalog Favorites y Dashboard new B3Open SignedInAs bipuser amla Qe Double dick on column names in the Subject Areas pane to add them to
43. sed Whether the customer is deceased or not Frozen Whether the customer details are fro zen or not Language Language of the customer 2 31 ORACLE Folder Field Description 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 Business Segment Code Business Segment of the customer Industry Code Industry of the customer Sector Code Sector of the customer Group Code Group of the customer Exposure Country Country for which exposure belongs to ELCM Limits Expo sure End Date Exposure date Exposure ID Exposure ID Exposure Name Exposure Name Exposure Rating Exposure Rating Exposure Type Exposure Type Start Date Start date Utilization Type Type of Utilization Valid Flag Valid flag for validation Exposure Code Exposure Code ELCM Liab Liab Branch Liability Branch Code Liab Ccy Liability Currency Code Liab Name Liability Name Liab No Liability Number Valid Flag For validat
44. siness Segment Select Value y Industry Select Value y Limit Type Select Value y Analyze By None al Apply_ Reset y gt Limit Type Unutilized Limit by Limit Type in milion Time run 12 10 2014 10 17 36 PM P ___ For more details Click here 100 unut ized Limit n milion Period Secured Unsecured Upto 30 days 0 00 a air 31 to 90 days 9 999 88 0 55 greater than 365 days 4 48 991 343 82 Grand Total 10 004 36 991 337 75 60 Wm Unsecured W Secured 40 20 0 4 48 Upto 30 days 31 to 90 days greater than 365 days Secured Unutilized 2 999 94 2 499 95 W Upto 10 Unutilized mes 1 999 96 greater Er Upto greater than 10 greater than 25 greater than 50 greater than IM than 10 to 10 to 25 to 50 to 75 175 1 499 97 ae 31to 90 days 0 00 0 00 0 00 0 00 100 00 Wm than 25 to greater than 263 31 0 00 75 00 2 398 89 999 98 ial 365 days IM than 50 to Grand Total 263 31 0 00 0 00 75 00 2 498 89 499 99 75 a J greater M than 75 y 499 99 31 to 90 days greater than 365 days Unsecured Unutilized 1 999 999 93 0 06 o Unutilized E Upto 10 EEE T Y Y E Y 2 000 000 05 a Upto 10 greater than greaterthan greaterthan greaterthan a ea 10 to 25 25 to50 50 t075 75 Er Upto 30 days 176 249 00 0 00 0 00 0 00 385 95 000 000 04 greater 31to 90 days 37 458 44 37 20 140 98 135 42 922 33 amos He great
45. system populates the data onto FIS related tables 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 2 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 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 22 ORACLE Once you have specified the abov
46. t 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 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 co
47. the fiter button in the Fiter pane header B Quarter Name Add a saved fitter by clicking on add button after selecting its name in the catalog pane Quarter Number P Year Number is equal to isin 2015 Month Name E Month Number amp Day Weekname amp Day Yyyymm gt GBELCM Limits Exposure gt E gt BELCM Uti Exposure xj Catalog Y al ORACLE Once you have added the filters and done the required edits click Results tab Advanced Administration Help Sign out O Search All X ORACLE Business Intelligence Home Catalog Favorites Dashboardsy New r Criteria Prompts Advanced am o gt Subject Areas M a e BAZAR OP 89 1882 4 7 8 Flexcube Information Server Compound Layout a gt E Account Periods gt Branch x ttle gt A Currency as Customer gt Date a APR gt DELCM Limits Exposure i ee gt EELO Liab Year Q Limit Type Limit Sanctioned Loy Limit Utilzed Li gt BELOM Track Exposure a ai meet Num gt DELCM Facility s 10 006 158 063 271 267 2015 Q1 gt E ELOM Util Exposure 30 019 386 128 50 039 436 214 2 373 126 2015 Q2 ql 4 155 211 2015 Q3 u 18 937 781 589 3 435 801 2015 Qt 56 823 332 996 10 647 462 2015 Q2 94 735 839 210 3 000 020 637 407 2015 Q3 a m x Catalog List Al gt wy Folders gt Shared Folders From this tab yo
48. ty details maintained for the bank ity ELCM Util Fact Data Displays utilization and exposure details Exposure 2 29 ORACLE 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 Is Last Qtrday The last working day of the quarter Is Last Monthday The last
49. u can add graphical representation of the data by using the new view button lb Advanced Administration Help Sign out Search All r ORACLE Business Intelligence Dashboardsy AE Open Signed In As weblogic y Criteria Results Prompts Advanced a z Subject Areas M 8 8 BB Aa BSP Ha Base a Y Flexcube Information Server Compound Layout EX Best Visualzation ta gt 3 Account Periods gt Earanch lg Recommended Visualzation for gt currency E Title gt Customer gt Date 2 2 EN Table ELCM Limits Exposure u _ ___ EB Pivot Table gt DELOM Lab Type 1 El Performance Tile gt GBELCM Track Exposure pr La eee ionad tay JE a gt BELON Faciity Is _10 006 158 063 E Trelis gt JELOM Uti Exposure 30 019 386 128 BS Graph gt li Bar lll Recommended Subtype 50 034 436 214 F T t Gauge lu 18 997 781 589 Ma Eine ld Vertical 56 823 332 996 3 DD Funnel Klaren re Horn 94 735 839 210 3 000 Map rie lua Stacked Vertical Y fiters BE Lne Bar gt E Stacked Horizontal U Selection Steps Ex Time Series Line Wl 100 Stacked Vertical 4 Other Views Pareto EZ 100 Stacked Horizontal a EJ Scatter x Catalog ERAS E Bubble Est Al Radar gt My Folders Cu Waterfall gt E Shared Folders Select the type of graphical representation that you need to add 2 38 ORACLE OBIEE will display the graph in the result area
50. working day of the month Half Year Denotes whether it is the first half sec ond half of the financial year 2 30 ORACLE Folder Field Description Week Day Shows whether the day is a weekday weekend Year Number The year ofthe 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 i 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 Decea
51. y e Limit type You can drill down to further levels by clicking the respective links as illustrated below Analyze By Report Drill Down values Report Segment For more details Click Here Overdrawn Lines Report Details Country For more details Click Here Overdrawn Lines Report Details Business Segment For more details Click Here Overdrawn Lines Report Details Quarter For more details Click Here Overdrawn Lines Report Details Sector For more details Click Here Overdrawn Lines Report Details Limit Type For more details Click Here Overdrawn Lines Report Details Group For more details Click Here Overdrawn Lines Report Details Liab No For more details Click Here Overdrawn Lines Report Details Industry For more details Click Here Overdrawn Lines Report 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 2 23 ORACLE 2 4 9 Overdue Amount Recovery This report displays the details of overdue amounts and the recovery status ORACLE Business Intelligence Enterprise Limits and Collateral Management New Sanctioned Limit Unutilized Limit Expired Lines Status Expired Line Details Quarter 2015 Q3 Z Country Select Sector Select Value v Business Segment Time ru
52. y e Versioning Select the appropriate one Transform Rule Define the transform rule Maintaining FLEXCUBE Information Server Scheduler You can maintain the Oracle FLEXCUBE Information Server jobs and their dependencies using FLEXCUBE Information Server Scheduler Maintenance screen To invoke this screen ORACLE type RPDSCH in the field at the top right corner of the application toolbar and click the adjoining arrow button Flexcube Information Server Scheduler Maintenance H save Job Type Data Transformation v Scheduler Program Type PLSQL_BLOCK Scheduler Program ID laz Scheduler Program Action Scheduler Program Name Enabled Flag 101 W Scheduler Parent Program Schedule a El Maker Date Time Checker Date Time Mod No Record Status Authorization Status Specify the following details Job Type Specify the job type Data Transformation Scheduler Program Type Specify the program type By default the system displays PLSQL_BLOCK However you can modify this Scheduler Program ID Select the program ID from the option list Scheduler Program Name Based on the program ID the system displays the name of the program Scheduler Program Action Specify the program action Enable Flag Check this box to enable the program action Scheduler Parent Program Specify the scheduler parent program You can select the appropriate program from the option l

FLEXCUBE Information Server User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents