Automating the OM General Rate Case Filing Process Using SAP HANA: A Digital Transformation Approach for Regulatory Compliance
DOI:
https://doi.org/10.58425/ajt.v4i4.463Keywords:
General Rate Case (GRC), SAP HANA, regulatory compliance, automation, data integration, Extract, Transform, Load (ETL), SAP analytics cloud, regulatory filing, efficiencyAbstract
Aim: The aim of this study is to examine how automation can improve the efficiency, accuracy, and regulatory compliance of the General Rate Case (GRC) preparation process undertaken by utility companies.
Methods: The study adopts a process-oriented and descriptive approach to analyze the traditional GRC filing workflow and the integration of automation tools such as SAP HANA. It examines the consolidation of financial, operational, and operations and maintenance data from multiple sources, the use of automated cost allocation, data validation, and the generation of regulatory reports. Key GRC components analyzed include operations and maintenance data, cost centres, workpaper groups, witness areas, and special remaps used for compliance updates.
Results: The findings indicate that automating GRC preparation significantly reduces manual data extraction and documentation efforts, minimizes errors, and improves data consistency. Automation enhances the organization of workpapers, improves cost tracking across cost centres, supports structured expert testimony through defined witness areas, and strengthens risk assessment and policy management. These improvements contribute to greater transparency, faster preparation timelines, and improved regulatory responsiveness.
Conclusion: The study concludes that automation of GRC processes transforms a traditionally complex and labour-intensive regulatory activity into a more accurate, efficient, and transparent workflow. By leveraging automated data consolidation and reporting capabilities, utilities can better justify rate adjustments while meeting regulatory requirements.
Recommendations: The study recommends that utility companies adopt automated GRC tools as a core component of their regulatory compliance strategy. Regulators and utilities should encourage the integration of centralized data platforms, standardized workpaper management, and automated validation mechanisms to enhance long-term efficiency, compliance quality, and stakeholder confidence in the GRC process.
References
Rate Case Support: https://www.consultcelerity.com/case-studies/gas-electric-utilities/
Lessons Learned from the Rate Case Process: An analysis of utility rate case experiences, highlighting best practices and common challenges. https://www.mcr-group.com/wp-content/uploads/2024/01/Rate-Case-Paper-Part-2-Lessons-Learned.pdf
SAP HANA XSA Migration Strategy. https://help.sap.com/doc/4b2182c05561496d83e2a32b7d22a625/2.0.04/en-US/SAP_HANA_XS_Advanced_Migration_Guide_en.pdf
2025 General Rate Case Total Compensation Study: A study examining total compensation as part of Southern California Edison’s GRC filing. https://docs.cpuc.ca.gov/PublishedDocs/SupDoc/A2305010/6064/508571399.pdf
2025 GRC Study on Residential Disconnections: Assessment of how proposed rate increases may impact residential service disconnections. https://docs.cpuc.ca.gov/PublishedDocs/SupDoc/A2305010/6065/508572055.pdf
PacifiCorp’s GRC Operations Report: Details on PacifiCorp’s operational results and methodologies in their GRC filing. https://docs.cpuc.ca.gov/PublishedDocs/SupDoc/A2205006/5704/500158375.pdf
Pacific Gas and Electric (PG&E) General Rate Case (GRC) Proceedings Overview. https://www.cpuc.ca.gov/industries-and-topics/electrical-energy/electric-rates/general-rate-case/pacific-gas-and-electric-grc-proceedings
Technology Platforms Essential to Prove Need in Utility Rate Cases. https://www.tdworld.com/electric-utility-operations/tools-and-technologies/article/21164430/technology-platforms-essential-to-prove-need-in-utility-rate-cases?
Accelerating utility rate case filings with generative AI. https://www.utilitydive.com/news/accelerating-utility-rate-case-filings-generative-ai-artificial-intelligence-genai/730551/
Neudesic on GenAI Use Cases for GRC: Exploration of how Generative AI can assist in preparing and managing GRC filings. https://www.neudesic.com/blog/genai-use-cases-general-rate-case/
Towards Multi-way Join Aware Optimizer in SAP HANA. http://www.vldb.org/pvldb/vol13/p3019-wi.pdf
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 Naveen Nischal Vaduguru

This work is licensed under a Creative Commons Attribution 4.0 International License.
The authors retain the copyright and grant this journal right of first publication. This license allows other people to freely share and adapt the work but must give appropriate credit, provide a link to the license, and indicate if changes were made. They may do so in any reasonable manner, but not in any way that suggests the licensor endorses them or their use.






