2. Oracle FLEXCUBE Information Server

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 reporting are as follows:

This chapter contains the following sections:

2.1 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.

2.1.1 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.

2.1.2 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 ‘RPDDTT’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.

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.

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.

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:

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.

2.1.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.

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:

Select the appropriate one.

Transform Rule

Define the transform rule.

2.1.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 ‘RPDSCH’ in the field at the top right corner of the application toolbar and click the adjoining arrow button.

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.

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.

2.2 Report Generation

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 I and Bank Scorecard II.

Oracle Business Intelligence system displays the reports 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 I and Bank Scorecard II:

The reports are displayed across various parameters as shown below.

Reports Description
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
Interest Earned All (open/closed), existing/new assets that have contributed for interest earned
Interest Paid All (open/closed), existing/new liabilities that have contributed for Inter­est paid

Following reports are available under the dashboards:

2.3 Bank Scorecard I

This section contains the following topics:

2.3.1 Bank 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:

You can view the following details:

The following actions are supported from this screen:

2.3.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:

You can view the following details:

The following actions are supported from this screen:

2.3.3 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:

You can view the following details:

The following actions are supported from this screen:

2.3.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:

The report shows the following details:

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:

2.3.5 Liabilities Status

This report shows the value and count of active and dormant liabilities for the previous business day. The generated report is as follows:

The report shows the following details:

You can click the values in the report to see the details.

The following actions are supported from this screen:

 

2.3.6 New Account Balances and Deposits

This report shows 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:

The report shows the following details:

The following actions are supported from this screen:

2.3.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:

You can view the following details:

The following actions are supported from this screen:

2.3.8 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:

You can view the following details pertaining to TD(P), TD(I) and TD(P+I) accounts:

The following actions are supported from this screen:

2.4 Bank Scorecard II

This section contains the following topics:

2.4.1 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 as unclassified. The details are shown as of the previous business day. The generated report is as follows:

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:

2.4.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:

This report displays the data for the customer type ‘Individual’.

You can view the following details:

The following actions are supported from this screen:

2.4.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:

This report displays the data for the customer type ‘Individual’.

You can view the following details:

The following actions are supported from this screen:

2.4.4 Corporate New Disbursements

This report displays the total disbursements across different type of corporate loans.

The generated report is as follows:

This report displays the data for the Customer type ‘Corporate’.

You can view the following details:

The following actions are supported from this screen:

2.4.5 Interest Earned

This report shows the interest earned across loan types for each quarter. The generated report is as follows:

You can view the following details:

The following actions are supported from this screen:

2.4.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:

You can view the following details:

You can drill down to further levels by clicking the links.

The following actions are supported from this screen:

2.4.7 NPA Statistics

The generated report is as follows:

You can view the following details:

You can drill down to further levels by clicking the links.

The following actions are supported from this screen:

2.4.8 Total Loan Status

This report shows the status of loans for each quarter. The generated report is as follows:

You can view the following details:

The following actions are supported from this screen:

2.5 Enterprise Limits and Collateral Management

This section contains the following topics:

The reports that you can view from the dashboard are discussed below.

2.5.1 New Sanctioned Limit

The New Sanctioned limit report displays the details of new limit amounts sanctioned by the bank for all type of customers in a quarter and also it provides the pictorial representation of the newly sanctioned limit across various quarters

Analyze By

You can analyse the report by the following parameters.

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 based on the selected dimension.

You can also filter the reports based on the following parameters:

You can drill down to further levels by clicking the respective links, as illustrated below.

Analyze by Report Drill Down values Report Drill down values  
Segment Bank New Limit Sanc­tioned by Seg­ment - Bank    
  Corporate New Limit Sanc­tioned by Seg­ment - Corporate Group Code and Unclassified New Limit Sanc­tioned by Seg­ment Corporate - Customer
  Individual New Limit Sanc­tioned by Seg­ment - Individual    
Country Countries of the custom­ers where new limits has been sanctioned New limit Sanc­tioned by Vari­ous list of countries    
Business Segment List of Busi­ness Seg­ments and Unclassified New Limit Sanc­tioned by Busi­ness Segment Secured & Unsecured Secured New Limit Sanc­tioned by Busi­ness Segment - Secured
      Unsecured New Limit Sanc­tioned by Busi­ness Segment - UnSecured
Quarter NA      
Sector List of Sec­tors and Unclassified New Limit Sanc­tioned by Sector - Secured & Unsecured    
Limit Type Secured New Limit Sanc­tioned by Type- Secured Utilized New Limit Sanc­tioned by Type-Secured - Uti­lized - Business Segment
      Unutilized New Limit Sanc­tioned by Type-Secured - UnUti­lized - Business Segment
  Unsecured New Limit Sanc­tioned by Type- UnSecured Utilized New Limit Sanc­tioned by Limit Type - Unse­cured - Utilized - Business Seg­ment
      Unutilized New Limit Sanc­tioned by Limit Type - UnSe­cured - Unuti­lized - Business Segment
Group Group Codes and Unclassified New Limit Sanc­tioned by Group- Customer    
Liability No List of liabil­ity number      
Industry Industries and Unclas­sified New Limit Sanc­tioned by Indus­try Secured & Unsecured Secured New Limit Sanc­tioned by Indus­try-Secured
      Unsecured New Limit Sanc­tioned by Indus­try-Unsecured

The following actions are supported from this screen:

2.5.2 Unutilized Limit

Unutilized limit report shows the details of limits which are not utilized in current quarter:

Analyze By

You can analyse the report by the following parameters.

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.

You can also filter the reports based on the following parameters:

2.5.3 Expired Line Status

This report displays the list of lines which are in expired status, By default it displays the report by sector and Business segment. User can also generate the report as per below mentioned parameters

Analyze By

You can analyse the report by the following parameters.

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:

You can drill down to further levels by clicking the respective links, as illustrated below.

Analyze By Report Drill Down values Report Drill Down Values Report
Segment Bank Line Expired Status by Seg­ment - Bank    
  Corporate Line Expired Status by Seg­ment - Corpo­rate Group Code and Unclassi­fied Line Expired Status by Seg­ment - Corpo­rate - Liability No
  Individual Line Expired Status by Seg­ment - Individ­ual    
Country Countries of the customers that are in expired status      
Business Segment List of Busi­ness Segments and Unclassi­fied Line Expiry Sta­tus by Busi­ness Segment - Details List of Busi­ness Segments and Unclassi­fied Line Expiry Sta­tus by Busi­ness Segment - Limit - Details
Quarter NA Line Expiry Sta­tus by Quarter Details    
Sector List of Sectors and Unclassi­fied      
Limit Type NA      
Group Group Codes and Unclassi­fied      
Liab No List of liability number      
Industry Industries and Unclassified      

The following actions are supported from this screen:

2.5.4 Expired Line Details

Expired line details report shows the list of expired lines, by default system shows the list of Overdue amount by period and Overdue count & value by limit type

Analyze By

You can analyse the report by the following parameters.

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:

The following actions are supported from this screen:

You can view the following details:

You can drill down to further levels by clicking the respective links, as illustrated below

Analyze By Report Drill Down values Report
Segment Bank Expiry Line Details by Period - Details
  Corporate  
  Individual  
Country Countries of the customers that are in expired Line status Expiry Line Details by Period - Details
Business Segment List of Business Segments and Unclassified Expiry Line Details by Period - Details
Quarter NA Expiry Line Details by Period - Details
Sector List of Sectors and Unclassi­fied Expiry Line Details by Period - Details
Limit Type NA Expiry Line Details by Period - Details
Group Group Codes and Unclassi­fied Expiry Line Details by Period - Details
Liab No List of liability number Expiry Line Details by Period - Details
Industry Industries and Unclassified Expiry Line Details by Period - Details

The following actions are supported from this screen:

2.5.5 Limits Sanctioned Vs Utilized

This report shows the details by comparing the limit sanctioned with utilized limits:

This report shows the details of sanctioned limits and the utilized limits:

Analyze By

You can analyse the report by the following parameters.

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:

You can drill down to further levels by clicking the respective links, as illustrated below.

Analyze By Report Drill Down values Report Drill Down Values Report Drill Down Values Report
Seg­ment Bank Segment - Group - Details Group Codes and Unclassi­fied Segment - Group - Customer Details    
  Corpo­rate Segment - Group - Details Group Codes and Unclassi­fied Segment - Group - Customer Details    
  Individ­ual Segment - Group - Details Group Codes and Unclassi­fied Segment - Group - Customer Details    
Country Display the coun­try of the cus­tomer where Limit is sanc­tioned and uti­lized          
Busi­ness Seg­ment List of Busi­ness Seg­ments and Unclassi­fied Business Segment wise Sanc - Utilized Details Liab No and Unclassi­fied Business Seg wise Sanc - Uti­lized Details Report    
Quarter NA          
Sector List of Sectors and Unclassi­fied Sector - Sanc­tioned iuti­lized Limit - Type Details List of Sec­tors and Unclassi­fied Sector - Sanc­tioned Limit - Group - Details List of Groups and Unclassi­fied Sector - Sanc Limit - Top20 & Others Cust Details
Limit Type Secured Sanc­tioned - utlized Limit- Secured        
             
  Unse­cured Sanc­tioned -Uti­lized Limit- Un Secured        
Group Group Codes and Unclassi­fied Group - Liability No Details        
Liab No List of liability number          
Industry List of Indus­tries and Unclassi­fied Industry - Sanc­tioned Limit - Type - Details List of Industries and Unclassi­fied Industry - Sanc­tioned Limit - Group - Details List of Groups and Unclassi­fied Industry - Sanc Limit - Top20 & Others Cust Details

The following actions are supported from this screen:

2.5.6 Limit Details

Limit details report shows the details of limits maintained in the system. This report is displayed in table format.

Analyze By

You can analyse the report by the following parameters.

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:

The following actions are supported from this screen:

2.5.7 Credit Rating

Credit rating report shows the details of credits provided to various sectors classified based on the credit rating.

Analyze By

You can analyse the report by the following parameters.

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:

You can drill down to further levels by clicking the respective links, as illustrated below..The following actions are supported from this screen:

Analyze By Report Drill Down values Report
Segment Bank Credit Rating wise Utilization Report
  Corporate  
  Individual  
Country Display the country of the customer where credit rating was performed.  
Business Segment List of Business Segments and Unclassified Credit Rating wise Utilization Report
Quarter NA Credit Rating wise Utilization Report
Sector List of Sectors and Unclassi­fied Credit Rating wise Utilization Report
Limit Type NA Credit Rating wise Utilization Report
Group Group Codes and Unclassi­fied Credit Rating wise Utilization Report
Liab No List of liability number Credit Rating wise Utilization Report
Industry Industries and Unclassified  

2.5.8 Overdrawn Lines

This report shows the details of overdrawn lines.

Analyze By

You can analyse the report by the following parameters.

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:

You can drill down to further levels by clicking the respective links, as illustrated below.

The following actions are supported from this screen:

2.5.9 Overdue Amount Recovery

This report displays the details of overdue amounts and the recovery status

Analyze By

You can analyse the report by the following parameters.

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:

You can drill down to further levels by clicking the respective links, as illustrated below.

Analyze By Report Drill Down values Report
Segment Bank Overdue Amount Recovery Details
  Corporate  
  Individual  
Country Display the country of the customer overdue details are maintained. Overdue Amount Recovery Details
Business Segment List of Business Segments and Unclassified Overdue Amount Recovery by Busi­ness Segment Details
Quarter List of quarters Overdue Amount Recovery by Quar­ter Details
Sector List of Sectors and Unclassified Overdue Amount Recovery by Sector Details
Limit Type NA Overdue Amount Recovery Details
Group Group Codes and Unclassified Overdue Amount Recovery Details
Liab No List of liability num­ber Overdue Amount Recovery Details
Industry Industries and Unclassified Overdue Amount Recovery Details

The following actions are supported from this screen:

2.5.10 Exposure Details

This report displays the details of exposure.

You can view this report for the following exposure types:

The following actions are supported from this screen:

2.5.11 Exposure Top 10 Liabilities

This report shows the exposure details for the top ten liabilities in the system

The following actions are supported from this screen:

2.6 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.

Click ‘New’ on the toolbar and select ‘Analysis’. You will be prompted to select the Subject Area.

Select ‘FLEXCUBE Information Server’ from the list.

Navigate to ‘Criteria’ tab.

On the left pane, expand the ‘FLEXCUBE Information Server’ subject area. You can find the following folders.

Folder Data Type Description
Account Periods Dimensional data Displays the accounting periods maintained for 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 Exposure Dimensional Data Displays limits exposure details maintained for the bank
ELCM Liab Dimensional Data Displays all the liabilities maintained for the bank
ELCM Track Exposure Fact Data Displays tracking details for exposure maintained for the bank
ELCM Facil­ity Fact Data Displays facility details maintained for the bank
ELCM Util Exposure Fact Data Displays utilization and exposure details
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 CASA Fact data Displays the liabilities of the bank, i.e. the current and saving accounts.Overdraft accounts with positive balance are displayed here
Asset Loans Fact data Displays all the assets of the bank, i.e. loans and 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 Code Regional office code
  Regional Office Name Name of the regional office
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 working day of the month
  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, 3 or 4
  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
  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 Unknown Whether the whereabouts of the cus­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
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 validation

 

 Main Liab ID Main Liability ID

ELCM Track Exposure

 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

 

 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 local 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
  Liab ID Liability 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 Fcy Exposure utilized in foreign currency
  Exp Util Lcy 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
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
  Currency Currency code
  Fin Year 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 Over Credit Today’s credit turnover in account cur­rency
  ACY Today Turn Over Debit Today’s debit turnover in account cur­rency
  LCY Today Turn Over Credit Today’s credit turnover in local currency
  LCY Today Turn Over Debit Today’s debit turnover in local currency
  Asset/Liability Bal­ance Balance in asset or liability
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 it is 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
  Credit interest Credit interest
  Dormant Account Dormant account
  Interest Pay Freq Frequency of interest payment
  Interest Rate Rate of interest
  Maturity Date Maturity 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 LCY Maturity amount in local currency
  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
  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 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
  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 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.

Double-click a column name to add it to the report. The selected columns are displayed on the screen.

In order to add filters to the report, click the ‘Filter’ icon.

Click ‘Filter’ icon and select ‘More Columns’ to select the filters that you need to apply.

Select the required column and click ‘OK’ button. You will see the ‘New Filter’ window.

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.

Once you have added the filters and done the required edits, click ‘Results’ tab.

From this tab, you can add graphical representation of the data by using the new view button.

Select the type of graphical representation that you need to add.

OBIEE will display the graph in the result area.

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 report to save

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.