ADF for Financial Services Software Development

Business Case for this Banking Software

My Banking Software : Available for free Business Reason ? Banks really dont pay you all the interest on your Fixed Deposits .. Sometimes they blame it on their Computer Systems for not having paid … Sometimes they dont pay you because you did not renew the Deposits on time .. Sometimes they would have paid more than they should have and next month they cut more than they should have .. when you have multiple bank accounts in multiple names of your family members managing would be really challenging .. So this challenge led me to develop a Banking Software that i am making it as Open Source and Free for Download . Features

1. Manage Multiple FDs under Multiple Names and in Multiple Bank Accounts.

2. Generate Reports when an FD needs to be Renewed.

3. Generate Reports on How much you are actually being paid in a Quarter when compared to How much you should have been paid.

4. Easily Identify any Technical Glitches in the Banks Software when they have not paid you.

5. Export to Multiple Formats like PDF, Excel and Show it to Bank if they have made mistakes

6. Create Unlimited number of Accounts , Deposit Sheets,

7. Keep Track of Banking ID changes .. Most Banks change the Account number of FD after renewal .. so keeping track is a challenge in itself ..

8. Generate Business Reports on How much of money you had deposited in which month and which year.

9. Keep Track of changing rate of interests and find out the Best Options to Invest

10. Keep Data on Mobile Devices and Share it with Bank when required Technology Oracle Database , Oracle Application Development Framework, Mobile App Development Software Author

Introduction to ADF

Oracle Application Development Framework (Oracle ADF) is an innovative, yet mature Java EE development framework available from Oracle and directly supported and enabled by the award winning development environment, Oracle JDeveloper 11g. Oracle ADF simplifies Java EE development by minimizing the need to write code that implements the application’s infrastructure allowing the developers to focus on the features of the actual application. Oracle ADF provides these infrastructure implementations as part of the framework. To recognize a set of runtime services is not enough, Oracle ADF is also focused on the development experience to provide a visual and declarative approach to Java EE development through the Oracle JDeveloper 11g development tool.

MVC Architecture

ADF can be used for Web based as well as Mobile Based Application Development..

Model layer : The way it works is you create Model layer with your Business components that can be Based on Database Tables or PLSQL Stored Procedures or Web Services or EJBs .. . We can also have simple Java Based Business Components. ADF Development ensures that you dont end up writing a Ton of code .. but instead use easy to use Drag and Drop features which generates standard based codes..

View layer: The View layer can be JSPX pages for Web or ADF Mobile based JSPX pages that are rendered with light weight trinidad components.. The JSPX pages can have their own validations and expression based page rendering .. supports multiple templates to control the look and feel .. flexibility to create your own templates along with Out of Box templates.

Controller layer: Taskflows allow a set of JSPX pages bound to each other.. and one task flow can call another taskflow and they can have their own set of variables based on managed bean or pageflow or session scope. These task flows can be portletized to be consumed in Webcenter Portal. Most of the Code is Auto Generated .. all you need to know is what to drag and where to drop.. the code generated fits into Best Practices and Java Design patterns .. so the developer need not worry about these implementations. This also saves development time there by increasing return on investment in this technology

ADF for Software Development and Financial Services

Since ADF Components support variety of integration technologies including Oracle BAM and Oracle BI .. and also its own out of box DVT Visualization Components variety of high quality graphs can be shown along with the regular software features.

Usecase : This Blog contains a fictitious scenario of a Bank.. that helps people to maintain their Fixed Doposits. Fixed Deposits [FD] is a money that one invests in a bank for a particular duration based on a fixed rate of interest. once the maturity date is over the customer needs to renewal the FD or withdraw the money.. One Home can have multiple investors and each of them can be individual bank customers .. each customer can have accounts in n number of banks .. and all maturing at different times .. management can become a little complex and tricky if done manually .. and even the process to cross check the rate of interests that BANKs have been paying for those FDs .. also its good to have your own PassBook Generator and Renewal Alerts so that you dont lose the money

View Fixed Deposits by Person

Screenshot from 2013-04-14 12:03:34 Screenshot from 2013-04-14 12:05:38

Download The Deposits into Excel File or Take a printout

Screenshot from 2013-04-14 12:06:01

View related Documents

The Actual Fixed Deposit sheets can be scanned to an image file and can be physically stored on the disk or on Oracle Content Server [Webcenter Content].. ADF allows out of box integration capabilities to the content repository

Screenshot from 2013-04-14 12:06:14


Search and Update FDs using ADF based lookups

You can build ADF lookup components by using Execute by Query feature that allows you to search for a Deposit and Update once renewal is done with respect to new interest rates and new dates.

Screenshot from 2013-04-14 12:06:25


CRUD Operations

You can create , read, update  delete , commit and rollback without writing any back end code .. you can also have your own little business logic written in a Managed Bean a Simple Java Class to say calculate the fixed deposit rate of interest .. and this can be made to immediately reflect on the page using partial page refresh feature.

Screenshot from 2013-04-14 12:08:24

Screenshot from 2013-04-14 12:15:37


Timeline feature

This is a new feature of ADF which shows the FDs based on the timeline date that you have invested. you just scroll through the dates and you can find the deposit sheets.

Screenshot from 2013-04-14 12:08:56

Your own Virtual Pass Book

Most often we eighter download our transaction if we have online account and if we dont have we the customers ask the banks to manually enter our transactions into a passbook that the banks provide . this can be automated as shown with the passbook feature

Screenshot from 2013-04-14 12:09:13

Screenshot from 2013-04-14 12:09:28

Screenshot from 2013-04-14 12:09:42


FD renewal Alerts

Graphical representation of the next renewal dates and bank names incase of having account in multiple banks will make it easy for most common users.

Screenshot from 2013-04-14 12:11:49

Screenshot from 2013-04-14 12:12:11


Multiple Report Views

You can view multiple reports on who has invested how much , what is the rate of interest they are supposed to get.

Screenshot from 2013-04-14 12:11:58

Screenshot from 2013-04-14 12:12:19

Screenshot from 2013-04-14 12:12:25

Screenshot from 2013-04-14 12:12:32


Checking your code in model

Sometimes before generating the user interface it makes perfect sense to test our model layer – ADF’s Swing based App Module Component helps you do exactly that you can check your View Objects which are Derived from Entity Objects to be tested using App Module

Entity Objects EO : First Derivative from a Database Table that can read and write into DB table.

View Object VO : Is formed using Entity Object or based on a SQL Query .. they form the next layer on top of EO.

Viewlink VL : Can have multiple master detail tables joined together .. in our case applicant name is master table , FDData is a detail table .. joined using View link

Screenshot from 2013-04-14 12:14:24

Source code- Deleted


About the Author