Automating the Capital General Rate Case Filing Process Using SAP HANA: A Digital Transformation Approach for Regulatory Compliance
Abstract
A General Rate Case (GRC) is a formal regulatory process where a utility company requests approval from a regulatory body—such as the California Public Utilities Commission (CPUC)—to adjust customer rates based on projected costs and revenues. Utilities typically submit GRC filings every three years, presenting detailed financial, operational, and capital data. The goal is to justify rate changes needed to support infrastructure, operations, and returns for investors. The process includes public hearings, stakeholder input, and regulatory review before rates are approved, modified, or denied. GRC filings are complex and labour-intensive, often requiring manual data extraction, analysis, and documentation. Automation tools such as SAP HANA can significantly streamline this process by consolidating data from multiple sources, performing cost allocations, validating inputs, and generating regulatory reports. Automation reduces errors, saves time, and ensures better compliance. Key components of GRC preparation include capital data (financial, physical, human, and intellectual), budget codes for tracking expenditures, and workpaper groups that organize supporting documents. Witness areas define expert testimony topics, while special remaps update compliance programs. GRC tools facilitate risk assessment, policy management, and reporting, supporting both GRC-specific filings and broader utility compliance efforts. Automating GRC processes enhances transparency, accuracy, and regulatory responsiveness.
Keywords
Downloads
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