Leading Financial Institution: Replacing Oracle Stored Procedures in the Core General Ledger System
A domestic replacement for Oracle stored procedures in core business systems
The general ledger, SMIS reporting, and consumer-loan systems all depended on Oracle stored procedures. After solving out-of-memory issues on massive data reads and deeply supporting Oracle packages and collection types, IvorySQL powered a stable cutover of the customer's core business systems.
Background
Three core systems — the general ledger, SMIS reporting, and the consumer-loan application — all depended on Oracle stored procedures that needed to be replaced, marking a key step in this financial institution's core-system digital transformation.
Project Highlights
- By adopting the open-source IvorySQL technology stack together with an in-house domestic database roadmap, the team successfully replaced the Oracle database underlying the core business systems while keeping the business running smoothly. After rigorous testing, the new platform's performance and stability metrics both met expectations.
- During implementation, the team solved an out-of-memory issue encountered when reading massive volumes of data, and achieved deep compatibility with Oracle Package functionality.
- The platform achieved full compatibility with collection data types, and comprehensively supports a large number of Oracle system views, special schema elements, and partition indexes — allowing the new platform to better match Oracle's characteristics and improving system stability and reliability.
- The new platform delivers strong transaction-processing capability and syntax/lexical compatibility. This broke down the structural differences between Oracle and IvorySQL while improving system flexibility and extensibility — together enabling a successful upgrade of the core business systems and laying a solid foundation for the customer's digital transformation.
General Ledger System Modernization Scope
The replacement covered the full workflow of the general ledger system, SMIS reporting, and the consumer-loan application, paired with visual cluster management, development tooling, automated migration tools, and a set of jointly developed database-level compatibility capabilities:
- General ledger / SMIS reporting / consumer-loan application: file import, interface import, general-ledger voucher import, voucher posting, daily/monthly closing (58 sub-requirements), annual closing (25 sub-requirements), annual trial closing (47 sub-requirements), JOB testing, chart-of-accounts mapping and reconciliation testing, exchange-rate calculation, balance backup, and institution initialization
- Jointly developed tooling capabilities: a visual cluster management platform (backup management, event messaging, monitoring & alerting, sync/async switchover, node scaling, primary/standby switchover), development management tools (syntax hints, execution plans, database ER diagrams, backup & restore, Oracle package management, session management), and automated migration tools (parallel migration, sharded migration, multi-threaded migration, online/offline migration)
- Jointly developed database capabilities: collection types, system package/view compatibility, autonomous transaction support, partition syntax support, global variables, and nested structures
Outcome
By adopting the open-source IvorySQL technology stack and an in-house domestic database roadmap, the team successfully replaced the Oracle database underlying the customer's core business systems while keeping operations running smoothly. The new platform's performance and stability metrics both met expectations, laying a solid foundation for the customer's digital transformation.