Skip to content

Developing a GUI for online banking using Oracle Forms and Oracle EBS (E-Business Suite)

Notifications You must be signed in to change notification settings

Trisha11r/oracle_apps_case_study

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Case Study: Oracle Applications

Developing a GUI for online banking using Oracle Forms Builder 10g, Oracle Database 10g and Oracle EBS (E-Business Suite)

1. SQLScript.sql: SQL script for table creation 
2. Forms Folder: contains the Oracle Forms (.fmb files) with implementation of required GUI
3. plsql_trigger_func.pdf : PDF file with detailed listing of the pages and the trigger functionalities implemented

Requirements for Design & Development of the UI pages:

1. Customers should be able to open the account online.
2. They can also register for Online banking and avail the e-banking services.
3. Interest Calculator to be provided for Interest Calculations.
4. Generate a Statement for User Transactions.
5. Create separate login pages for Users and Managers.

Instructions:

  • Source form (. fmb) needs to be compiled into a platform-specific "executable" (. fmx), that is run (interpreted) by the forms runtime module.

  • WinSCP and PuTTY have been used for interaction with server:

      WINSCP: For adding the .fmb files to the server (file transfer)
      PuTTY: For creating .fmx files 
    
  • Finally, create Menu and define Responsibility in the Oracle Applications prior to running the forms to get the GUI

About

Developing a GUI for online banking using Oracle Forms and Oracle EBS (E-Business Suite)

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages