Using generic application for Banking System, as a leader Oracle developer, I was responsible for maintenance and adding new modules and functionalities. The generic application is very flexible, (made in Oracle Forms 6i) gives the possibility to create a new module without a single line of PLSQL code. Of course, it’s possible to use PLSQL and Oracle Reports for some specific solutions. (e.g. calculation which is not included in the generic model, reports which are not standard generic model reports, etc.)

Generic model supports:

  • Domains, (description of default parameters)
    • Inheritance, (for the situations where we need additional parameters description)
  • Contracts, (with a defined set of input parameters)
  • Procedures, (with defined input parameters, subprocedures, bookkeeping procedures as a part of subprocedures, etc.)
  • Parameter Tables; (possibility to define set of dynamic parameters and its values)

Application can produce HTML code (HTML web site automatically generated by database package, which produces more than 5000 HTML pages) as description of all entered values in generic application, so its very easy to find how contracts are defined, or how procedures are defined with all its description, or how booking procedures looks like, (bookkeeping schemes, with view on details on each accounting entry records related pairs) etc.

This is a generic application, developed in Oracle Forms/Reports, with the main purpose to help the company to easily manage inventory during the year. (annual or monthly) The form of application is generic so that the end user (with administrator privileges) can prepare lists, which are then filled by the employee responsible for inventory. After all, lists are filled, there is a possibility to compare them automatically with current inventory states.

The application is connected to the general ledger, with the possibility to check the current balance of accounts.