Vehicle-Management-System (Fleet)

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 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.