Oracle Cloud Fusion GL Integration

Automates  the integration and reconciliation process between the core banking system (Oracle Flexcube) and the general ledger (Oracle Fusion). The solution includes various validation rules, mapping rules, allocation rules and control checks.

Summary:

Our client, a bank operating in 5 sub-Sahara African countries, embarked on the implementation of Oracle Cloud Fusion General Ledger platform as their centralised group financial reporting system. This initiative aimed to streamline financial reporting and data integration across the organization. To achieve this, the Bank needed to integrate various sub-ledgers, particularly from their core banking platform, into the new Fusion GL environment.

The project required a robust and efficient mechanism to extract, transform data from the sub-ledgers and load the data into the target system, while ensuring the application of business rules and maintaining data integrity and traceability throughout the process.

This case study outlines the challenges faced, the solution developed, and the results achieved during this critical project.

The Challenge:

The Bank needed a solution that could:

• Handle data from multiple sub-ledgers: The integration had to account for data from various core banking instances, ensuring uniformity and consistency across different versions.

• Apply business rules consistently: The transformation process required the application of complex business mapping rules to ensure that data imported from the sub-ledgers met the standards and formats required by Oracle Fusion GL.

• Ensure data integrity and traceability: With data flowing from multiple sources to a single target, it was crucial to maintain the integrity and traceability of each transaction to avoid discrepancies in financial reporting.

• Develop a control framework: The project also needed a control framework that could manage daily activities, schedule processes, monitor checkpoints, and generate exception reports to identify and reconcile any discrepancies.

The solution:

To address these challenges, Digiata developed a comprehensive ETL and Business Rules Engine.

The key components of the solution included:

• ETL and business rules engine layer: This layer was designed to import data from the sub-ledgers, transform it according to predefined business mapping rules, and export the processed data for loading into the target GL. The ETL layer was also equipped to assign a unique reference to each transaction, enabling easy tracking from the source to the target system.

• Control framework: A robust control framework was developed to oversee the entire ETL process. This framework managed daily activities and scheduling, ensured process checkpoints were met, and generated exception reports. Additionally, it facilitated reconciliation processes to quickly identify and resolve any discrepancies between the sub-ledgers and the Fusion GL system.

The Results:

The development of the Oracle Fusion GL integration system resulted in significant improvements in financial data management and reporting.

The key outcomes included:

• Streamlined data integration: The consistent and efficient ETL process allowed for seamless integration into the Oracle Fusion GL system. This integration reduced the time and effort required for data processing and minimized the risk of errors.

• Enhanced data integrity and traceability: By assigning unique references to each transaction, the solution ensured that all financial data could be easily traced from the source to target. This traceability improved the accuracy and reliability of financial reports.

• Improved operational efficiency: The control framework minimised manual intervention, improved process efficiency, and allowed for quicker identification and resolution of discrepancies.

• Scalability and flexibility: The solution was designed to accommodate future expansions and upgrades, ensuring that the Bank could continue to integrate additional sub-ledgers as needed without significant development.

‍