Building GrievanceHub: A Student Grievance

Management System Using Oracle APEX

Introduction

As part of my journey in learning Oracle technologies and low-code application development, I wanted to build a practical solution that addresses a real-world challenge faced by educational institutions. This led me to develop GrievanceHub, a Student Grievance Management System built using Oracle APEX and Oracle Database.

Educational institutions receive various grievances related to academics, hostels, food services, transportation, library facilities, and campus infrastructure. Traditional grievance handling methods often rely on manual records, emails, or paper-based forms, making it difficult to track complaints efficiently.

GrievanceHub was designed to provide a centralized platform where students can submit grievances, upload supporting documents, track progress, and receive updates while administrators can efficiently manage and resolve issues.

Project Objectives

The primary objectives of GrievanceHub were:

Digitize the grievance submission process
Provide transparency in grievance handling
Enable status tracking for students
Improve communication between students and administrators
Create a structured workflow for grievance resolution
Visualize grievance data through dashboards and analytics

Technologies Used

Frontend & Application Development

Oracle APEX 26.1

Database

Oracle Database

Development Tools

SQL Workshop
Interactive Reports
Interactive Grids
Dashboard Charts
File Upload Components

Programming Language

System Architecture

The application follows a database-driven architecture where Oracle APEX serves as the presentation layer while Oracle Database manages data storage and processing.

Core Database Tables

STUDENTS

Stores student information including:

Student ID
Register Number
Student Name
Email
Department
Year of Study

GRIEVANCES

Stores grievance records including:

Grievance ID
Student ID
Category
Title
Description
Status
Submitted Date
Tracking ID
Priority
Admin Remark
Resolved Date

GRIEVANCE_CATEGORIES

Stores grievance categories such as:

Academics
Hostel
Food
Transportation
Library
Infrastructure

Home Page

The Home Page serves as the landing page of the application.

The page was designed to provide a modern user experience with:

Welcome Banner
Quick Navigation
KPI Cards
Grievance Statistics
Easy Access to Core Modules

The objective was to ensure that users could immediately understand the purpose of the application and access key functionalities with minimal effort.

Screenshot: Home Page

Submit Grievance Module

The Submit Grievance page allows students to create and submit grievances.

Features

Student Selection
Category Selection
Title Entry
Detailed Description
Supporting File Upload
Automatic Status Assignment

When a grievance is submitted:

Status is automatically set to Submitted
Submission date is recorded
Tracking ID is generated

This ensures consistency and traceability throughout the grievance lifecycle.

Screenshot: Submit Grievance Page

File Upload Functionality

One of the key enhancements added to the project was support for file uploads.

Students can attach:

Images
PDF Documents
Supporting Evidence

Examples include:

Hostel facility photographs
Food quality complaints
Academic issue documents
Infrastructure damage evidence

This feature improves grievance verification and resolution efficiency.

My Grievances Module

The My Grievances page allows students to view previously submitted grievances.

Information Displayed

Category
Title
Description
Status
Tracking ID
Submitted Date

Students can easily monitor the progress of their requests without needing to contact administrators directly.

This significantly improves transparency within the grievance management process.

Manage Grievances Module

The Manage Grievances page is designed for administrators.

Using Oracle APEX Interactive Grid functionality, administrators can:

View all grievances
Update grievance status
Set priority levels
Add administrative remarks
Record resolution dates

Status Workflow

The application implements a structured workflow:

Submitted → In Progress → Resolved → Closed

Priority Levels

Low
Medium
High
Critical

Administrative Remarks

Administrators can provide updates such as:

Issue assigned to concerned department
Investigation in progress
Resolution completed
Additional information requested

This enables effective communication between students and administrators.

Screenshot: Manage Grievances Page

Dashboard Analytics

To provide insights into grievance data, a dashboard was developed using Oracle APEX chart components.

Dashboard Features

Grievance Status Distribution
Resolution Tracking
Visual Reporting
Interactive Analytics

The dashboard helps administrators quickly understand:

Number of submitted grievances
Pending issues
Resolved cases
Overall grievance trends

Visualization simplifies decision-making and improves monitoring efficiency.

Screenshot: Dashboard Page

Challenges Faced During Development

Building GrievanceHub involved several technical challenges.

Interactive Grid Configuration

Initially, editing grievance statuses directly within the Interactive Grid was not functioning as expected.

This was resolved by:

Configuring editable columns
Setting primary key identification correctly
Enabling row processing

Database Synchronization

After adding new database columns such as:

Priority
Admin Remark
Resolved Date

the columns did not immediately appear within Oracle APEX.

The issue was resolved using the Synchronize Columns feature.

File Upload Integration

Implementing file upload functionality required understanding Oracle APEX file handling mechanisms and ensuring proper database integration.

Dashboard Configuration

Creating meaningful charts required designing suitable SQL queries and mapping data correctly to chart components.

Key Learnings

This project provided valuable hands-on experience in:

Oracle APEX Development

Form Creation
Interactive Reports
Interactive Grids
Dashboard Design
Navigation Management

Database Design

Table Creation
Relationships
Constraints
Data Management

SQL Development

DML Operations
Data Retrieval
Aggregation Queries

User Experience Design

Modern Interface Design
Workflow Optimization
Data Visualization

Future Enhancements

Although GrievanceHub is fully functional, several enhancements are planned for future versions.

Role-Based Access Control

Separate permissions for:

Students
Administrators
Department Heads

Email Notifications

Automatic notifications when:

Grievances are submitted
Status changes occur
Issues are resolved

Mobile Optimization

Enhanced responsiveness for smartphones and tablets.

Advanced Analytics

Additional reports and performance metrics.

AI-Assisted Categorization

Automatic grievance classification using Artificial Intelligence.

Project Outcomes

Through this project, I successfully developed a complete grievance management solution using Oracle APEX.

The application demonstrates:

Low-Code Development
Database-Driven Application Design
Workflow Management
Reporting and Analytics
Real-World Problem Solving

Most importantly, it strengthened my practical understanding of Oracle APEX and showcased how enterprise applications can be rapidly developed using Oracle's low-code platform.

Conclusion

Building GrievanceHub has been one of the most valuable learning experiences in my Oracle APEX journey. From database design and application development to workflow implementation and dashboard analytics, the project provided practical exposure to multiple aspects of enterprise application development.

Oracle APEX proved to be a powerful platform for rapidly developing scalable and user-friendly applications with minimal code. This project not only enhanced my technical skills but also demonstrated how technology can be used to solve real-world challenges within educational institutions.

I look forward to continuing my Oracle APEX journey and further enhancing GrievanceHub with advanced features and capabilities.

Thank you for reading!

Author: Mohamed Ibrahim A
Program: B.Tech Information Technology
Institution: Sri Ramakrishna Engineering College, Coimbatore

#OracleAPEX #OracleDatabase #OracleACE #LowCode #StudentDeveloper #DatabaseDesign #WebDevelopment #OracleCloud