4. Dashboards

Oracle FLEXCUBE facilitates the availability of the following Dashboards based on the ‘User Role’ you are mapped to:

• My Transaction Event Status
• Parked Loan/Transactions
• EOD Exceptions
• Bulletin Board
• Watch List Accounts
• Wakala To Murabaha
• Pending New Loans/Contracts
• Pending Life Cycle Events
• TD’s Maturing details
• Loan’s Maturing Details
• Business Opportunities
• Watch List Accounts
• Pending Authorization transactions
• Loan/Trade User Event Wise Report
• Trade Re-assignment
• Business Done for the Month
  • Self
  • Team

• Customer Upgrade / Downgrade
• Loan & TD Account Maturing
• Origination Dashboards

Each ‘User Role’ would not require all of the above, hence the system enables grouping of these Dashboards based on the ‘User Role’.

The following sections explain, in detail, the features associated with each Dashboard, the groups, and the ‘User Role’ associated with each group.

This chapter contains the following sections

• Section 4.1, "Loan Officer (Maker) Dashboard"
• Section 4.2, "Loan Authorizer Dashboard"
• Section 4.3, "Loan Supervisor Dashboard"
• Section 4.4, "Trade Maker Dashboard"
• Section 4.5, "Trade Authorizer Dashboard"
• Section 4.6, "Trade Supervisor Dashboard"
• Section 4.7, "Branch Manager Dashboard"
• Section 4.8, "Relationship Manager Dashboard "
• Section 4.9, "Origination Dashboards"
• Section 4.10, "Organizing Dashboards"

4.1 Loan Officer (Maker) Dashboard

Loan Officer of a Bank generates loans for the bank and maintains complete details related to loan transactions. Also, monitors, analyzes, and assess the credit worthiness of the borrowers. The following Dashboards are made available to assist a Loan Officers in their assignments:

• My Transaction Event Status – To view the status of the authorized and unauthorized loan transactions event wise.
• Parked Loans – To view the status of the loan applications put on hold for pending information.
• EOD Exceptions – To view the list of EOD exceptions of the loan accounts encountered for previous and current working day.
• Bulletin Board – To view the list of Bulletin messages received.
• Watch List Accounts – To keep watch on their overdue loan transactions.
• Wakala to Murabaha conversion – To view the list of loan transactions which needs to be converted to Murabaha on the current date, based on Wakala mature days configured at ‘RM Report Parameterization’ level.

This section contains the following topics

• Section 4.1.1, "My Transaction Event Status"
• Section 4.1.2, "Parked Loans"
• Section 4.1.3, "EOD Exceptions"
• Section 4.1.4, "Bulletin Board"
• Section 4.1.5, "Watch List Accounts"
• Section 4.1.6, "Wakala to Murabaha Conversion"

4.1.1 My Transaction Event Status

‘My Transaction Event Status’ Dashboard displays the event status of authorized and authorized transactions of CL, LE, CI, and MO accounts; processed by the Maker for the current date and event wise. The Dashboard displays the following transaction details, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

• Customer ID
• Account Number
• Currency
• Amount – Amount Financed
• Auth Status
• Product Code
• Module Code
• Event Code

  

A hyperlink is provided to the ‘Account Number’ column. Click the link to invoke the corresponding contract detailed screen based on the module of the account and the event of the contract. However;

• If you click an unauthorized transaction, the system will display the corresponding current event screen processed.
• If you click an authorized transaction, the system will display the module contract screen.

4.1.2 Parked Loans

‘Parked Loans’ Dashboard displays the loan transactions of CL, LE, CI, and MO; which are put on hold for pending information. This Dashboard facilitates working on the pending information required in completing the transactions without any delay. The Dashboard displays the following details of the transactions on hold, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

• Customer ID
• Account Number
• Currency
• Amount – Amount Financed
• Last Updated Date
• Product Code
• Module code

  

A hyperlink is provided to the ‘Account Number’ column. Click the link to invoke the corresponding contract detail screen.

4.1.3 EOD Exceptions

‘EOD Exceptions’ Dashboard lists the EOD exceptions of the loan accounts encountered for previous and current working day. The Dashboard displays the following details, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

• Account Number – Loan Account No or Reference No
• Processing Date – Date on which the exception is logged
• Operation – Event for which the exception occurred
• Maker ID

  

A hyperlink is provided to the account number column. Click the link to invoke the ‘EOD Exception Query’ screen.

 

This screen displays the following, EOD message and event details, for the contract event screen:

• Contract Reference
• Branch
• Module
• Event Code
• Message

4.1.4 Bulletin Board

‘Bulletin Board’ Dashboard lists all or any of the following bulletin messages configured to you across all branches:

• Public news or messages
• Product information
• Policies and Notices of the bank
• System messages
• Adhoc or unplanned messages, if any.

The following details of the message are displayed in the Dashboard:

• Reference Number – Bulletin Reference No
• Message Description – Bulletin concise description

  

A hyperlink is provided to the Message ID column. Click the link to invoke the ‘Bulletin Detail’ screen.

 

For further details about Bulletin Board, refer ‘Bulletin_Board’ User Manual.

4.1.5 Watch List Accounts

A loan officer of the Bank will have a watch on loan transactions;

• To advise borrowers on the management of their finances, if the loan becomes delinquent
• To take action to collect outstanding amounts

‘Watch List Accounts’ Dashboard displays this watch list of authorized loan accounts; assigned to the Maker for the current date and latest event. The Dashboard displays the following transaction details after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

• Customer ID – Customer Id of the loan borrower
• Name – Customer Name
• Account Number – Loan Account No or Reference No
• Currency – Currency in which the loan is availed
• Overdue Amount – Overdue Amount of all the components
• RM ID – Relationship Manager Id
• Product Code – Loan Product
• Module Code
• Event Code

 

A hyperlink is provided to the account number column. Click the link to invoke the corresponding contract detailed screen.

4.1.6 Wakala to Murabaha Conversion

‘Wakala to Murabaha Conversion’ Dashboard displays a list of Wakala transaction to be converted to Murabaha on the current day, based on Wakala mature days configured at ‘RM Report Parameterization’ level. The Dashboard displays the following transaction details after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

• Customer ID – Customer Id of the loan borrower
• Account No – Loan Account No
• CCY – Currency in which the loan is availed
• Amount – Loan Amount

  

A hyperlink is provided to the account number column. Click the link to invoke the corresponding ‘Wakala Contract Detailed’ screen

4.2 Loan Authorizer Dashboard

Loan Authorizer of a Bank approves loans for the bank and evaluates credit records and payment histories of the customer, to decide on approving the loans. The following Dashboards are made available to assist a Loan Authorizers in their assignments:

• Pending New Loans – To view the list of new loan transactions, which are pending for approval for the current date.
• Pending Life Cycle Events – To view a list of VAMI, Rollover, Payment, and Re-Negotiation loan contracts, which are pending for authorization.
• EOD Exceptions – To view the list of EOD exceptions of the loan accounts encountered for previous and current working day.
• Bulletin Board – To view the list of Bulletin messages received.

This section contains the following topics

• Section 4.2.1, "Pending New Loans"
• Section 4.2.2, "Pending Life Cycle Events"
• Section 4.2.3, "EOD Exceptions"
• Section 4.2.4, "Bulletin Board"

4.2.1 Pending New Loans

‘Pending New Loans’ Dashboard displays the list of new CL, CI, MO, and LE loan transactions, which are pending for approval; assigned to the role. The Dashboard displays the following transaction details, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

• Customer ID – Customer ID of the loan borrower
• Account Number – Loan Account No or Reference No
• Currency – Currency in which the loan is availed
• Amount – Loan Financed
• Branch Code
• Maker ID – Loan Officer who booked
• Product Code
• Module Code
• Event Code

  

A hyperlink is provided to the ‘Account Number’ column. Click the link to invoke the corresponding contract detailed screen, based on the module of the account and the event of the contract.

Note

Accounts with current event as Book/INIT are listed.

4.2.2 Pending Life Cycle Events

‘Pending Life Cycle Events’ Dashboard displays a list of VAMI, Rollover, Payment, and Re-Nego loan contracts of CL, CI, MO, and LE; which are pending for authorization. The Dashboard displays the following details of the transactions on hold, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

• Customer ID – Customer ID of the loan borrower
• Account Number – Loan Account No or Reference No
• Currency – Currency in which the loan is availed
• Amount – Loan Amount
• Branch Code
• Maker ID – Loan Officer who booked
• Product Code
• Module Code
• Event Code

  

A hyperlink is provided to the ‘Account Number’ column. Click the link to invoke the corresponding contract event screen or current event authorization screen.

Note

Accounts with current event other than Book/INIT are listed.

4.2.3 EOD Exceptions

‘EOD Exceptions’ Dashboard lists the EOD exceptions of the loan accounts encountered for previous and current working day. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

For further details on ‘EOD Exceptions’ Dashboard, refer ‘EOD Exceptions’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.2.4 Bulletin Board

‘Bulletin Board’ Dashboard lists all or any of the following bulletin messages configured to you across all branches:

• Public news or messages
• Product information
• Policies and Notices of the bank
• System messages
• Adhoc or unplanned messages, if any.

For further details on Bulletin Board Dashboard, refer ‘Bulletin Board’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.3 Loan Supervisor Dashboard

Loan Supervisor of a Bank manages the Loan Servicing Department of the bank. Also, directly supervisors the duties of department staff, coordinates with the staff for coverage in related areas of the department. The following Dashboards are made available to assist a Loan Supervisors in their assignments:

• Loan User Event Wise Report – To view the user event wise report for the loan transactions.
• EOD Exceptions – To view the list of EOD exceptions of the loan accounts encountered for previous and current working day.
• Bulletin Board – To view the list of Bulletin messages received.

This section contains the following topics

• Section 4.3.1, "Loan User Event Wise Report"
• Section 4.3.2, "EOD Exceptions"
• Section 4.3.3, "Bulletin Board"

4.3.1 Loan User Event Wise Report

‘Loan User Event Wise Report’ Dashboard displays the user event wise report for; unauthorized and authorized loan transactions of the current date and all on-hold loan transactions of the Users. The Dashboard displays the following transaction details, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

• User ID – User list based on the supervisor mapped at ‘User Maintenance’ level
• Authorized – Provides count of event wise accounts authorized by the current ‘User’ for the current date.
• Submitted – Provides count of event wise accounts processed by the current ‘User’ for the current date
• Parked – This provides count of accounts on-hold by the current ‘User’

  

A hyperlink is provided to the ‘User ID’ column. Click the link to invoke the corresponding ‘Loan Transaction Query Status’ screen with the contract details processed by the user. The following details are displayed:

• Account Number
• Module
• CCY
• Amount
• Product
• Event Code
• ESN
• Status - (‘A’,’U’,’H’)

 

4.3.2 EOD Exceptions

‘EOD Exceptions’ Dashboard lists the EOD exceptions of the loan accounts encountered for previous and current working day. The system also validates if the current user has multi-branch/centralized access to display other branch accounts.

For further details on ‘EOD Exceptions’ Dashboard, refer ‘EOD Exceptions’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.3.3 Bulletin Board

Bulletin Board’ Dashboard lists all or any of the following bulletin messages configured to you across all branches:

• Public news or messages
• Product information
• Policies and Notices of the bank
• System messages
• Adhoc or unplanned messages, if any.

For further details on Bulletin Board Dashboard, refer ‘Bulletin Board’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.4 Trade Maker Dashboard

Trade Maker of a Bank generates Trade contracts for the bank and maintains complete details related to Trade transactions. Also, monitors, analyzes, and assess the credit worthiness of the transactions. The following Dashboards are made available to assist a Trade Makers in their assignments:

• My Transaction Event Status – To view the status of the authorized and unauthorized trade transactions.
• Parked Transactions – To view the status of the trade applications put on hold for pending information.
• EOD Exceptions – To view the list of EOD exceptions that Trade Maker has encountered for previous and current working day transactions.
• Bulletin Board – To view the list of Bulletin messages received.

This section contains the following topics

• Section 4.4.1, "My Transaction Event Status"
• Section 4.4.2, "Parked Transactions"
• Section 4.4.3, "EOD Exceptions"
• Section 4.4.4, "Bulletin Board"

4.4.1 My Transaction Event Status

‘My Transaction Event Status’ Dashboard displays the status of authorized and unauthorized Trade transactions; assigned to the role for the current date and event wise processed by the ‘User’. The Dashboard displays the following transaction details after verifying the ‘DFI mapped, validating if the ‘Show Dashboard’ check box is checked, and verifying the multi-branch accessibility:

• Customer ID
• Contract Reference – Trade reference No
• Currency
• Amount – Trade amount
• Auth Status
• Module
• Product Code
• Event code

Note

• If more than one event is initiated on a single stage, then the system displays all events initiated on that day.
• On-hold contracts are not listed.

A hyperlink is provided to the ‘Contract Reference Number’ column. Click the link to invoke the corresponding contract detailed screen based on the module of the account and the event of the contract. However;

• If you click an unauthorized transaction, the system will display the corresponding current event screen processed.
• If you click an authorized transaction, the system will display the module contract detail screen.

4.4.2 Parked Transactions

‘Parked Loans’ Dashboard displays the trade transactions, which are put on hold for pending information for the current date and latest event. This Dashboard facilitates working on the pending information required in completing the transactions without any delay. The Dashboard displays the following details of the transactions on hold, after verifying the DFI mapped, validating if the ‘Show Dashboard’ check box is checked, and verifying the multi-branch accessibility:

• Customer ID
• Contract Reference – Trade reference No
• Currency
• Amount – Trade amount
• Last Updated
• Status
• Module
• Product Code

  

A hyperlink is provided to the ‘Reference Number’ column. Click the link to invoke the corresponding contract detail screen.

4.4.3 EOD Exceptions

‘EOD Exceptions’ Dashboard lists the EOD exceptions that Trade Maker has encountered for previous and current working day for a particular branch or based on Multibranch role mapping for that User.

For further details on ‘EOD Exceptions’ Dashboard, refer ‘EOD Exceptions’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.4.4 Bulletin Board

‘Bulletin Board’ Dashboard lists all or any of the following bulletin messages configured to you across all branches:

• Public news or messages
• Product information
• Policies and Notices of the bank
• System messages
• Adhoc or unplanned messages, if any.

For further details on Bulletin Board Dashboard, refer ‘Bulletin Board’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.5 Trade Authorizer Dashboard

Trade Authorizer of a Bank approves trades for the bank and evaluates he contract details and checks the credit worthiness, to decide on approving the contracts. The following Dashboards are made available to assist a Loan Authorizers in their assignments:

• Pending New Contracts – To view the list of new contract transactions, which are pending for approval for the current date.
• Pending Life Cycle Events – To view a list of AMND, Rollover, AVAL, and Liquidation etc of trade contracts, which are pending for authorization.
• EOD Exceptions – To view the list of EOD exceptions that Trade Authorizer has encountered for previous and current working day.
• Bulletin Board – To view the list of Bulletin messages received.

This section contains the following topics

• Section 4.5.1, "Pending New Contracts"
• Section 4.5.2, "Pending Life Cycle Events"
• Section 4.5.3, "EOD Exceptions"
• Section 4.5.4, "Bulletin Board"

4.5.1 Pending New Contracts

‘Pending New Contracts’ Dashboard displays the list of new Trade transactions, which are pending for approval; assigned to the role. The Dashboard displays the following transaction details, after verifying the DFI mapped, validating if the ‘Show Dashboard’ check box is checked, and verifying the multi-branch accessibility:

• Customer ID – Customer ID of the loan borrower
• Contract Reference – Trade Reference No
• Currency – Currency in which the loan is availed
• Amount – Trade amount
• Maker ID – Trade Officer who booked
• Module
• Product Code
• Event Code

  

A hyperlink is provided to the ‘Reference Number’ column. Click the link to invoke the corresponding contract detailed screen.

4.5.2 Pending Life Cycle Events

‘Pending Life Cycle Events’ Dashboard displays a list of AMND, Rollover, AVAL, Liquidation etc, of trade contracts; which are pending for authorization. The Dashboard displays the following details of the transactions on hold, after verifying the DFI mapped, validating if the ‘Show Dashboard’ check box is checked, and verifying the multi-branch accessibility:

• Customer ID – Customer ID of the loan borrower
• Contract Reference – Trade Reference No
• Currency – Currency in which the trade contract is availed
• Amount – Trade Amount
• Maker ID – Trade Maker who booked
• Module
• Product Code
• Event Code

  

A hyperlink is provided to the ‘Reference Number’ column. Click the link to invoke the corresponding contract event screen or current event authorization screen.

4.5.3 EOD Exceptions

‘EOD Exceptions’ Dashboard lists the EOD exceptions that Trade Authorizer has encountered for previous and current working day for a particular branch or based on Multibranch role mapping for that User.

For further details on ‘EOD Exceptions’ Dashboard, refer ‘EOD Exceptions’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.5.4 Bulletin Board

‘Bulletin Board’ Dashboard lists all or any of the following bulletin messages configured to you across all branches:

• Public news or messages
• Product information
• Policies and Notices of the bank
• System messages
• Adhoc or unplanned messages, if any.

For further details on Bulletin Board Dashboard, refer ‘Bulletin Board’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.6 Trade Supervisor Dashboard

Trade Supervisor of a Bank manages the Trade Servicing Department of the bank. Also, directly supervisors the duties of department staff, coordinates with the staff for coverage in related areas of the department. The following Dashboards are made available to assist a Trade Officers in their assignments:

• Trade User Event Wise Report – To view the user event wise report for the trade transactions.
• Re-assignment – To view the list of contracts which are on-hold.
• EOD Exceptions – To view the list of EOD exceptions that Trade Supervisor has encountered for previous and current working day.
• Bulletin Board – To view the list of Bulletin messages received.

This section contains the following topics

• Section 4.6.1, "Trade User Event Wise Report"
• Section 4.6.2, "Trade Re-assignment"
• Section 4.6.3, "EOD Exceptions"
• Section 4.6.4, "Bulletin Board"

4.6.1 Trade User Event Wise Report

‘Trade User Event Wise Report’ Dashboard displays the user event wise report for the trade transactions which are unauthorized, authorized, or on-hold, for the current date. The Dashboard displays the following transaction details, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked:

• User ID – User list based on the supervisor mapped at ‘User Maintenance’ level
• Authorized – Provides count of authorized contracts initiated and modified for the current date.
• Submitted – Provides count of contracts processed by the current ‘User’ for the current date
• Parked – Provides count of contracts on-hold initiated and modified

  

A hyperlink is provided to the ‘User ID’ column. Click the link to invoke the corresponding ‘New Trade Transaction Query Status’ screen with the contract details processed by the user. The following details are displayed:

• Contract Reference No
• Account Number
• Module
• CCY
• Amount
• Product
• Event Code
• ESN
• Status - (‘A’,’U’,’H’)

4.6.2 Trade Re-assignment

‘Trade Re-assignment’ Dashboard displays the list of trade contracts, which are on-hold. The Trade Supervisor of the bank can checks the number of contracts available with each User and can reassign the contracts to a different User, if needed. The Dashboard displays the following transaction details, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked:

• User Id
• Contract Reference
• Account
• Module
• Currency
• Amount
• Product

  

A hyperlink is provided to the ‘Contract Reference’ column. Click the link to invoke the corresponding ‘Trade Re-assignment’ screen with the contract details processed by the user.

4.6.3 EOD Exceptions

‘EOD Exceptions’ Dashboard lists the EOD exceptions that Trade Supervisor has encountered for previous and current working day for a particular branch or based on Multibranch role mapping for that User.

For further details on ‘EOD Exceptions’ Dashboard, refer ‘EOD Exceptions’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.6.4 Bulletin Board

‘Bulletin Board’ Dashboard lists all or any of the following bulletin messages configured to you across all branches:

• Public news or messages
• Product information
• Policies and Notices of the bank
• System messages
• Adhoc or unplanned messages, if any.

For further details on Bulletin Board Dashboard, refer ‘Bulletin Board’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.7 Branch Manager Dashboard

Branch Manager supervises the daily operations of the Bank. Also, directs the bank branches and department, resolves the customer issues and ensures maintenance of service standards. The following Dashboards are made available to assist Branch Managers in their assignments:

• TDs maturing details – To view list of TDs which are maturing in next ‘X’ days, based on the mature days
• Loans maturing details – To view list of loans which are maturing in next ‘X’ days, based on the mature days
• Business Opportunities – To view list of customers who are eligible for the schemes in the current branch
• Watch list accounts – To keep watch on the accounts with available amount less than the threshold amount
• Pending Authorization contracts – To monitor the transactions which are pending for authorization
• Bulletin board – To view the list of Bulletin messages received

This section contains the following topics

• Section 4.7.1, "TDs Maturing Details"
• Section 4.7.2, "Loans Maturing Details"
• Section 4.7.3, "Business Opportunities"
• Section 4.7.4, "Watch List Accounts"
• Section 4.7.5, "Pending Authorization Contracts"
• Section 4.7.6, "Bulletin Board"

4.7.1 TDs Maturing Details

‘TDs Maturing Details’ Dashboard displays a list of TDs which are maturing in next ‘X’ days, based on the mature days maintained at ‘RM Report Parameter’ level, for the ‘Branch manager’ role. Both multi branch access and centralized role are supported for this Dashboard. The Dashboard displays the following transaction details, after verifying the DFI mapped, validating if the ‘Show Dashboard’ check box is checked, and verifying the multi-branch accessibility:

• Customer ID
• Account No
• Account Class
• Maturity Date
• Currency
• Amount – Maturity Amount
• Telephone

  

A hyperlink is provided to the ‘Account Number’ column. Click the link to invoke the corresponding ‘TD Account’ screen. The ‘RM Report Parameters’ facilitates configuration of the TD mature days.

4.7.2 Loans Maturing Details

‘Loans Maturing Details’ Dashboard displays a list of loans which are maturing in next ‘X’ days, based on the mature days maintained at ‘RM Report Parameter’ level, for the ‘Branch manager’ role. Both multi branch access and centralized role are supported for this Dashboard. The Dashboard displays the following CL, LE, CI, COM and MO contract details, after verifying the DFI mapped, validating if the ‘Show Dashboard’ check box is checked, and verifying the multi-branch accessibility:

• Customer ID
• Account Number
• Maturity Date
• Currency
• Amount
• Maturity Date
• Module Code
• Description
• Telephone

  

A hyperlink is provided to the ‘Account Number’ column. Click the link to invoke the corresponding ‘Loan Account’ screen. The ‘RM Report Parameters’ facilitates configuration of the Loan mature days.

4.7.3 Business Opportunities

‘Business Opportunities’ Dashboard displays list of customers who are eligible for the schemes in the current branch for the current date. Both multi branch access and centralized role are supported for this Dashboard. The Dashboard displays the following details, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked:

• Customer ID
• Customer Name
• Scheme
• Scheme Description
• Scheme End Date
• Telephone

  

A hyperlink is provided to the ‘Customer ID’ and ‘Scheme’ column. Click ‘Customer ID’ link to invoke the corresponding ‘Customer Scheme Linkages’ screen. Click ‘Scheme’ link to invoke the corresponding ‘Scheme Details’ screen. Click ‘More’ to invoke the ‘Scheme Summary’ screen.

4.7.4 Watch List Accounts

Bank Manager of the bank monitors the accounts with available amount less than the threshold amount and then informs the customer to maintain the minimum threshold amount in the account. Both multi branch access and centralized role are supported for this Dashboard. The Dashboard displays the following details based on the negative balance threshold parameter maintained at ‘RM Report parameterization’ level, after verifying the DFI mapped, validating if the ‘Show Dashboard’ check box is checked, and verifying the multi-branch accessibility:

• Customer ID
• Account Number – CASA Account No
• Account Description
• Currency – Account Currency
• Amount – Available balance

 

A hyperlink is provided to the ‘Account Number’ column. Click ‘Account Number’ link to invoke the corresponding ‘Account Maintenance’ screen.

4.7.5 Pending Authorization Contracts

Bank Manager of the bank monitors the accounts which are pending for authorization. The Dashboard displays the following details of loan, CASA, and TD accounts for the current branch, which are pending for approval, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked:

• Customer ID
• Account Number – Loan/CASA/TD
• Currency
• Amount
• Module Code
• Event

  

A hyperlink is provided to the ‘Account Number’ column. Click ‘Account Number’ link to invoke the corresponding ‘Account Maintenance’ screen.

4.7.6 Bulletin Board

‘Bulletin Board’ Dashboard lists all or any of the following bulletin messages configured to you across all branches:

• Public news or messages
• Product information
• Policies and Notices of the bank
• System messages
• Adhoc or unplanned messages, if any.

For further details on Bulletin Board Dashboard, refer ‘Bulletin Board’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.8 Relationship Manager Dashboard

Relationship Manager is the contact point for a customer within the bank. They communicate among different groups of people for complaints and to resolve problems. They also help the bank in improving trade by promoting the products, services, and solutions to the customers. The following Dashboards are made available to assist Relationship Managers in their assignments:

• Business Opportunities – To view list of RM customers who are eligible for the schemes
• Business done for the month–Self – To view the details of the business done by the Relationship Manager for the month
• Business done for the month–Team – To view the details of the business done by the their sub-ordinates for the month
• Customer Upgrade/Downgrade – To view the list of customers who had a change in the credit rating on the current date
• Loans & TD’s maturing – To view the list of Loans and TD accounts which will mature within the specified days
• Bulletin Board – To view the list of Bulletin messages received

This section contains the following topics

• Section 4.8.1, "Business Opportunities"
• Section 4.8.2, "Business Done for the Month – Self"
• Section 4.8.3, "Business Done for the Month – Team"
• Section 4.8.4, "Customer Upgrade/Downgrade"
• Section 4.8.5, "Loans & TDs Maturing"
• Section 4.8.6, "Bulletin Board"

4.8.1 Business Opportunities

‘Business Opportunities’ Dashboard displays list of RM customers who are eligible for the schemas in the current branch for the current date. The Dashboard displays the following details, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked:

• Customer ID
• Customer Name
• Scheme ID
• Scheme Description
• Scheme End Date
• Telephone

  

A hyperlink is provided to the ‘Customer ID’ and ‘Scheme’ column. Click ‘Customer ID’ link to invoke the corresponding ‘Customer Scheme Linkages’ screen. Click ‘Scheme’ link to invoke the corresponding ‘Scheme Details’ screen. Click ‘More’ to invoke the ‘Scheme Summary’ screen.

4.8.2 Business Done for the Month – Self

‘Business Done for the Month – Self’ Dashboard displays the details of the business done by the relationship manager for the month. It also lists the current local branch customers mapped to RM, the active accounts, and the sum of amount grouped based on the module, customer, product and currency. The Dashboard displays the following details for the loan, CASA, and TD accounts, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked:

• Module Code
• Customer ID
• Product Code – Transaction product code
• Currency
• Amount – Transaction Amount (Loan - Amount Financed/TD amount deposited/ CASA Available balance)

  

4.8.3 Business Done for the Month – Team

‘Business Done for the Month – Team’ Dashboard displays the details of the business done by the RM and their sub-ordinates for the month. It also lists the current local branch customers mapped to RM’s sub-ordinates, the active accounts, and the sum of amount grouped based on the module, customer, product, currency, and maker ID. The Dashboard displays the following details for the loan, CASA, and TD accounts, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked:

• Module Code
• Customer ID
• Product Code – Transaction product code
• Currency
• Amount – Transaction Amount (Loan - Amount Financed/TD amount deposited/ CASA Available balance)
• Maker Id – RM’s sub-ordinate’s ID

  

4.8.4 Customer Upgrade/Downgrade

‘Customer Upgrade/Downgrade’ Dashboard displays list of customers who had a change in the credit rating, on the current date. It lists the current local branch customers mapped to RM. This Dashboard lists customers mapped to logged RM, whose credit rating changed as on the current date. The Dashboard displays the following, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked:

• Customer Id
• Previous Credit Rating
• Latest Credit Rating

  

4.8.5 Loans & TDs Maturing

‘Loans & TD’s Maturing’ Dashboard displays list of Loans and TD accounts which will mature within the specified days, based on the parameters maintained at ‘RM Report Parameterization’ level. It lists Loan and TD accounts in current branch, for customers mapped to logged RM. The Dashboard displays the following details for the CL, MO, CI, LE loan accounts, and TD accounts for the current branch, after verifying the DFI mapped and validating if the ‘Show Dashboard’ check box is checked:

• Customer ID
• Account No – Loan/TD account No
• Module code
• Maturity Date – TD maturity date/Loan Maturity date
• Currency
• Amount – Loan Amount Financed/TD amount
• Maker ID

  

A hyperlink is provided to the ‘Account Number’ column. Click the link to invoke the corresponding ‘Loan/TD Account Details’ screen.

4.8.6 Bulletin Board

‘Bulletin Board’ Dashboard lists all or any of the following bulletin messages configured to you across all branches:

• Public news or messages
• Product information
• Policies and Notices of the bank
• System messages
• Adhoc or unplanned messages, if any.

For further details on Bulletin Board Dashboard, refer ‘Bulletin Board’ section under ‘Loan Officer (Maker) Dashboard’ section of this chapter.

4.9 Origination Dashboards

Oracle FLEXCUBE allows you to configure dashboards with multiple queues, count various queues and map dashboards to specific user roles or users.

Following are the features of Origination Dashboards:

• Blow Up - On clicking the ‘Blow Up’ button, system gives a detailed view of the particular frame in the dashboard.
• Refresh - On clicking the ‘Refresh’ button, system refreshes the particular frame in the dashboard.
• Filter Search - On checking the ‘Filter’ box, system displays the filter criteria. Using the filter option, you can search a particular task in a particular queue dashboard as well as in all queue dashboards.
• Actions - You can select task-specific actions such as Acquire, Copy, Release, Status, Resume, etc, on the dashboard queues.
• Tool Tip - You can view the details of the task when you place the cursor on the Workflow Reference Number of a particular task in the queue frames of the dashboard.

Note

Each dashboard has minimum one to maximum six frames.

Following are the pre-configured dashboards available in the system:

• Default Dashboard - This dashboard lists the Assigned, Acquired, Pending, Completed, High Priority tasks along with the Action List which lists the Escalated, Expired, Aging, High Priority and Today queue count.
• Cancelled Applications - This dashboard lists the cancelled Applications in Retail Lending, Corporate Lending, CASA and Trade.
• High Priority - This dashboard lists the high priority Applications in Retail Lending, Corporate Lending, CASA and Trade.
• High Value - This dashboard lists the high value Applications in Retail Lending, Corporate Lending, CASA and Trade.
• Quick View - This dashboard can be mapped to the Quick View frame. It displays details such as task count in each category (Escalated, Expired, Aging, High Priority and Today queue count) and Assigned, Acquired and High Priority Queue Dashboard.

You can click on workflow reference number to launch the application. The system launches the queue on click of the queue name in the count dashboards.

In addition to the pre-configured dashboards, you can create additional dashboards using the ‘Origination Dashboard Maintenance’ screen.

For more details on Origination Dashboard Maintenance’, refer section titled, ‘Maintaining Origination Dashboard Details’ in chapter, ‘Maintenances’ in this User Manual.

4.10 Organizing Dashboards

As mentioned earlier, you can position and sequence individual dashboards based on DFI mapping. The system facilitates filtering of Dashboards. The function ID assigned to each dashboard and the criteria based on which each Dashboard is filtered is detailed in the following table:

Function ID	Dashboard name	Filter Criteria	Order Criteria
Loan Maker
CLSLNTXS	My Transac­tion Event sta­tus	CL, LE, MO, CI, Commit­ment Authorised/Unauthor­ised Event wise Accounts for the Maker. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by Account Number in ascending order, Event Sequence Number in descending order
CLSLNPKD	Parked Loans	CL, LE, MO, CI, Commit­ment On-Hold Accounts for the Maker. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by Last updated date aged one first
CSSEODEX	EOD Excep­tions	CL, LE, MO, CI, Commit­ment Accounts gone into EOD exception from last working day to current branch date. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by Account Number in ascending order
CSSBULBD	Bulletin Board	Bulletin messages mapped to the required role and are active.	Order by Message Ref­erence Number
CLSLNWAT	Watch list transactions	CL, LE, MO, CI, Commit­ment Authorised Accounts of latest event for the Maker ,which has overdue of any components equal to or greater than one day. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by Account Number in ascending order
CLSLNWTM	Wakala to Murabaha	CI Authorised Accounts of latest event for the Maker based on the Wakala expiry days set at RM Parameterisation Mainte­nance (includes from and to date). Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by Account Number in ascending order
Loan Authorizer
CLSLNPEN	Pending New Loans	CL, LE, MO, CI, Commit­ment Accounts of latest event wise to the assigned user as per the operational hierarchy. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by Account Number in ascending order
CLSPNLCE	Pending Life cycle events	CL, LE, MO, CI, Commit­ment Accounts of latest event wise to the assigned user as per the operational hierarchy. Based on branch access permissions Current branch/Multi Branch/Cen­tralized. All events other than BOOK and INIT.	Order by Account Number in ascending order
CSSEODEX	EOD Excep­tions	CL, LE, MO, CI, Commit­ment Accounts gone into EOD exception from last working day to current branch date. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by Account Number in ascending order
CSSBULBD	Bulletin Board	Bulletin messages mapped to the required role and are active.	Order by Message Ref­erence Number
Loan Supervisor
CLSLNURP	Loan User Event Wise Dashboard	Event wise Count of the Submitted/Authorised/Parked CL, LE, MO, CI, and Commitment Accounts of the Maker, Authoriser and Supervisor User Id. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by User ID
CSSEODEX	EOD Excep­tions	CL, LE, MO, CI, Commit­ment Accounts gone into EOD exception from last working day to current branch date. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by Account Number in ascending order
CSSBULBD	Bulletin Board	Bulletin messages mapped to the required role and are active	Order by Message Ref­erence Number
Trade Maker
LCSTMSTS	My Transac­tion Event sta­tus	LC, BC, LI and IB Author­ised/Unauthorised Event wise contracts for the Maker. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by contract ref­erence Number in ascending order, Event Sequence Number in descending order
LCSTMPAT	Parked Trans­actions	LC, BC, LI and IB contracts Put on hold for the maker. Based on branch access permissions Current branch/Multi Branch/Cen­tralized	Order by Last updated date aged first
LCSEODTX	EOD Excep­tions	LC, BC, LI and IB contracts gone into EOD exception from last working day to current branch date. Based on branch access permis­sions Current branch/Multi Branch/Centralized	Order by contract refer­ence Number in ascending order
CSSBULBD	Bulletin Board	Bulletin messages mapped to the Trade maker role, Active	Order by Message Ref­erence Number
Trade Authorizer
LCSTAPEN	Pending new contracts	LC, BC, LI, IB contracts with BISS, INIT, BOOK, BCFM, BADV and BPRE triggered pending for authorization. Based on branch access permissions Current branch/Multi Branch/Cen­tralized and to the assigned user as per the operational hierarchy	Order by contract refer­ence Number in descending order.
LCSTAPLC	Pending Life cycle events	LC, BC, LI, IB with Latest Event other than new con­tracts pending for authori­zation. Based on branch access permissions Cur­rent branch/Multi Branch/Centralized and to the assigned user as per the operational hierarchy	Order by contract refer­ence Number in descending order.
LCSEODTX	EOD Excep­tions	LC, BC, LI and IB contracts gone into EOD exception from last working day to current branch date. Based on branch access permis­sions Current branch/Multi Branch/Centralized	Order by contract refer­ence Number in ascending order
CSSBULBD	Bulletin Board	Bulletin messages mapped to the Trade Authoriser role, Active	Order by Message Ref­erence Number
Trade Supervisor
CSSTRURP	Trade User Event wise Report	Event wise Count for the Submitted/Authorised/Parked LC, BC, LI, IB con­tracts of the Maker, Author­iser and Supervisor User Id. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order By User ID
CSSTRRAS	Trade Reas­signment	LC, BC, LI and IB contracts Put on hold in the system. Based on branch access permissions Current branch/Multi Branch/Cen­tralized and as per the operational hierarchy maintained.	Order by contract refer­ence Number in ascending order
LCSEODTX	EOD Excep­tions	LC, BC, LI and IB contracts gone into EOD exception from last working day to current branch date. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by contract refer­ence Number in ascending order
CSSBULBD	Bulletin Board	Bulletin messages mapped to the Trade Supervisor role, Active	Order by Message Ref­erence Number
Branch Manager
CLSBTDMD	TD’s Maturing Details	All TDs (Normal, Recurrent Deposit, Auto Deposit) that are getting matured in next X days (RM Param) includ­ing from and to date. Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Nearest Maturity first
CLSBLNMD	Loan’s Matur­ing Details	All Loans (CL, LE, MO, CI, COM) Active accounts, that are getting matured in next X days (RM Param) including from and to date Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Nearest Maturity first
CLSBBOPP	Business Opportunities	Relation ship pricing Open & Active scheme with active linkage to RP Cus­tomer for logged in branch	Order by Cust ID
CLSBWLST	Watch List Accounts	Accounts having account currency available bal­ance below negative threshold balance set at RM Param Based on branch access permissions Current branch/Multi Branch/Cen­tralized.	Order by account num­ber
CLSBPNAU	Pending Authorization transactions	Pending auth transactions of CASA, TD (Normal, Recurrent Deposit, Auto Deposit), Loans(CL, LE, MO, CI) accounts for the Current branch.	Group by module code, order by customer ID
CSSBULBD	Bulletin Board	Bulletin messages mapped to the required role and are active.	Order by Message Ref­erence Number
Relationship Manager
CSSRM­BOP	Business Opportunities	Relation ship pricing Open & Active scheme with active linkage to RP Cus­tomer of the RM	Order by Cust ID
CSSRMBS	Business done for the month - self	Arithmetic sum of contract amount (TD-Deposit, Loan-Amount Financed, CASA- Account CCY avail­able balance) grouped by Module, Customer, Prod­uct and Currency. CL, LE, MO, CI/TDs (Normal, Recurrent Deposit, Auto Deposit)/CASA booked for customer attached with logged in RM for the cur­rent branch and month	Grouped by Module, Customer, Product and Currency and Order by Cust ID
CSSRMBT	Business done for the month - Team	Arithmetic sum of contract amount (TD-Deposit, Loan-Amount Financed, CASA- Account CCY avail­able balance) grouped by Module, Customer, Prod­uct and Currency. CL, LE, MO, CI/TDs (Normal, Recurrent Deposit, Auto Deposit)/CASA booked for customer attached with logged in RM and subordi­nate RM for the current branch and month	Grouped by Module, Customer, Product and Currency and Order by Cust ID
CSDRMCU	Customer Upgrade / Downgrade	CREDIT_RATING modi­fied on current date, cur­rent branch for the customer attached to logged in RM	Order by Cust ID
CSSRMTD	Loan & TD account matur­ing	CL, LE, MO, CI or TDs (Normal, Recurrent Deposit, Auto Deposit) get­ting matured within next X days (RM report parame­ter) including from and to date for the customer attached to logged in RM	Order by Cust ID
CSSBULBD	Bulletin Board	Bulletin messages mapped to the required role and are active.	Order by Message Ref­erence Number