Implementación de un módulo de software para la exportación de reportes en Excel en el sistema Hermes componente de extensión, utilizando Oracle APEX

Abstract

This project addresses the implementation of a new report generation module in Excel format within the Hermes system—an extension component used by the National University of Colombia. This initiative arose in response to the problems identified in the current module, such as high latency, difficulties with the CSV format, and dependence on asynchronous processes that negatively impact operational efficiency and user experience. The solution is developed using Oracle APEX and the APEX_DATA_EXPORT package, allowing the immediate generation of Excel files downloadable from the browser. A new optimized database schema is implemented as a data source for the reports, along with an automated transfer mechanism from the transactional schema, all within a three-tier architecture. Development is guided by the adapted RSSD methodology, including analysis, design, implementation, and validation phases. Features are designed that include report and column selection, date validation, access control, and log recording. The module seeks to improve efficiency, reduce response times to less than three minutes, and offer an intuitive and functional interface for administrative users at the university's various locations. The implementation of this module represents a significant improvement in the Hermes system's ability to meet its users' information needs, strengthening institutional processes and data-driven decision-making.