Skip to content

Latest commit

 

History

History
33 lines (26 loc) · 2.18 KB

README.md

File metadata and controls

33 lines (26 loc) · 2.18 KB

Vehicle-Management-System (Fleet)

Oracle APEX App APEX PL/SQL APEX Built with Love APEX Community

A system used to manage Fleet of vehicles migrated from Oracle Forms 6 to Oracle Application Express 18.1 - 22.1

Link : https://g163858f7227eb0-pbj5dxgdsbwntfay.adb.ap-seoul-1.oraclecloudapps.com/ords/f?p=101:LOGIN_DESKTOP:12161845380396:::::

This repository contains two sql scripts

  • vehicle_mamagement_database.sql contains the schema for the system. It has some dummy data. This can be truncated by users at will.(Did not want to disable constraints -reason i left the data in the tables)
  • Vehicle_management_apex_UI.sql contains the import of the Oracle Apex which is the UI of the application. This script contains supporting plugins APEX Plugin that have to be installed during the import process.

Usage -Create schema and import the vehicle_mamagement_database.sql script into it. -Import apex script into your oracle apex 22.1
installation build and run.

Troubleshooting: There is a possiblity you wont be able to access the app after a successful import. If that happens:

  • Goto the application in Apex and click on Shared Components
  • Under the Security Section click on Application Access Control
  • Click on Add User Role Assignment
  • A dialog box will open.Enter the user you want to add and checkbox their Role
  • Click on Create Assignment
  • Go back to the pages section select the Login Page (ususally 9999) and run it.
  • You should be able to login now.

Capture