Case study: WASA - Water and Sanitation Agency
How JBS transformed WASA’s project & financial operations with Oracle APEX
Solution overview
- Solution partner
- JBS (www.jbs.live)
- Solution implemented
- Oracle APEX–based PMES (end-to-end project management, contracts, variations, billing, inspections)
- Oracle EBS FMES Integration (financials + e-Business Tax, invoicing, tracking)
Overview
When JBS first connected with the Water and Sanitation Agency (WASA), much of their operations from financials and project evaluations to planning were being managed manually through spreadsheets, phone calls, and paper-based approvals. Hours were spent every day just keeping processes running.
Recognizing the need for digital transformation, JBS leveraged Oracle APEX to build a fully customized Project Management & Evaluation System (PMES) that centralized all project data, introduced real-time visibility, and enabled automated reporting. This transformation was further amplified by integrating Financial Management & Evaluation System (FMES), built earlier on Oracle EBS, to create a connected ecosystem that unified financial and project performance data.
Today, WASA’s management processes are fully paperless, efficient, and transparent — with insights and reports available in seconds instead of days.
Challenges
Manual operations and paper-based workflows
Most of WASA’s project and financial tracking relied on spreadsheets and physical documentation, causing duplication, delays, and data inaccuracies
Lack of integration between systems
Separate financial and project records prevented real-time visibility and made budget utilization tracking difficult.
Limited monitoring and evaluation capabilities
Project progress, inspection quality, and contract variations lacked centralized tracking and approval mechanisms.
Time-consuming bill and approval cycles
Bill submissions, approvals, and tax integration processes were slow, with limited automation or accountability.
Key benefits of the solution
- Complete transition to a paperless, automated system
- Real-time project and financial visibility across all directorates
- Accurate tracking of expenses and budget utilization
- Faster approval cycles and digital invoice generation
- Improved coordination between finance, quality, and project teams
- Integration with Oracle EBS for seamless financial processing
The solution provided by JBS
JBS developed a comprehensive, Oracle APEX-based PMES, seamlessly integrated with Oracle EBS financials, resulting in a connected and transparent management system. Key components included:
End-to-End Project Management Portal
Enabled users to create, monitor, and manage projects under specific directorates, including fund allocation, tendering, and progress tracking.
Contract and Variance Order Management
Allowed real-time tracking of contracts, dynamic workflows for cost or scope changes, and automated version control for BOQ revisions.
Bill Submission and Approval Automation
Supported multiple bill types (IPC, Secure Advance, Mobilization Advance, Escalation, and Withheld Amounts) with digital approvals up to Director-level authorization.
Integrated Financial and Tax Processing
Linked Oracle EBS with e-Business Tax for seamless invoice generation and tracking.
Administrative and Quality Modules
Introduced role-based access, master data configuration, inspection tracking, and centralized quality control.
How it solved the challenges
Digitized Workflows
Eliminated manual paperwork and calls, enabling a single-window system for all project and financial operations.
Integrated Financial Ecosystem
Unified PMES and FMES to synchronize project, budget, and expense data in real time.
Accelerated Approvals
Automated routing and approval hierarchies reduced turnaround time for invoices and project changes.
Data Accuracy and Transparency
Centralized records improved audit ability and ensured reliable, live data for management decisions.
Enhanced Efficiency
Reports that once took days are now generated instantly, empowering leadership with actionable insights.
Conclusion
Through Oracle APEX and Oracle EBS integration, JBS transformed WASA’s fragmented, manual operations into a connected digital ecosystem. The new Project Management & Evaluation System (PMES) and Financial Management & Evaluation System (FMES) enabled transparent workflows, accelerated billing, and data-driven decision-making — turning complexity into clarity.
WASA now operates with greater control, efficiency, and confidence. It is a proof that with JBS’s innovation and expertise, public sector transformation truly Works Better.
Why JBS
- A proven track record of successful project deliveries with measurable outcomes
- Expert-level certifications in cybersecurity, guaranteeing deep technical expertise and best-in-class implementation