University Inventory Management System
American University of Sharjah
Challenge
The university needed to track physical assets across departments with integration into Banner's security model for role-based access — ensuring department heads can only manage their own inventory.
Solution
Built a 22-page APEX application with Banner security integration for department-level access control, barcode-based asset tracking, depreciation calculations, and audit-ready reporting.
Results
- ✓ 22 production APEX pages
- ✓ Banner security integration
- ✓ Department-level access control
- ✓ Asset depreciation tracking
This system replaced a fragmented spreadsheet-based inventory process with a centralized Oracle APEX application, leveraging Banner’s existing security model to enforce department-level data isolation without requiring separate authentication infrastructure.