Ngày đăng: 06/11/2024
Our team, in collaboration with Partner FPT, was tasked with integrating System HIS2 with Oracle EBS for a Hoan My Medical Corporation (8 sites). The primary goal was to achieve seamless data synchronization while minimizing disruption to existing user workflows and optimizing the speed of integration requests.
Project Goals
- Seamless Data Integration: Enable smooth data flow between System HIS2 and Oracle EBS without requiring significant changes to user processes.
- Optimized Processing Speed: Enhance the efficiency of data synchronization requests.
- Robust Error Reconciliation: Implement mechanisms for identifying and resolving synchronization errors.
Challenges (Pain Points) & Solutions
1st Challenge: Lack of Integrated Reconciliation Reporting
Users faced difficulties identifying and resolving synchronization errors due to the absence of a comprehensive reconciliation report.
Solution
We conducted a thorough analysis of business processes and common error scenarios. Based on these findings, we designed and developed an integrated reconciliation report within Oracle EBS. This report provided visibility into errors, data statuses, and key metrics, empowering users to troubleshoot issues effectively.
2nd Challenge: Slow Processing of Integration Requests
The existing data synchronization process was slow, leading to delays in data availability.
Solution
We analyzed the algorithms used in the current code and identified optimization opportunities. By refining the algorithms while preserving the existing solution and business logic, we were able to significantly improve the processing speed of integration requests.
3nd Challenge: Customization & Integration
Data Storage Structure
We modified the data storage structure from a single table to three separate tables: Interface (I), Success (S), and Error (E). This change served multiple purposes:
- Optimized Processing: By focusing on the Interface and Error tables, we reduced the amount of data scanned during each request, resulting in faster processing times.
- Clear Role Separation: Partner FPT was granted permissions to insert, delete, and update data in the Interface table and delete data from the Error table. However, they were restricted from modifying data in the Success table, ensuring data integrity.
Form Customization
We added new fields to a customized form (Ex: HOADON, BANGKETHUTIEN,…) to accommodate additional information required by users, further enhancing the system’s usability.
Implementation Process
Change Management
Training: Recognizing that users were unfamiliar with the new integrated reconciliation report, we conducted comprehensive training sessions to familiarize them with the new processes and report interpretation. We also provided detailed user guides and report specifications.
Support: We established a dedicated support channel to address user queries and resolve any issues promptly, minimizing disruptions to their workflows.
Risk Mitigation
We proactively identified potential risks, such as delays caused by pending errors from the third-party partner. By collaborating closely with the partner to find solutions, we were able to mitigate these risks and keep the project on schedule.
Results
The project achieved the following outcomes:
- Empowered Users: End-users gained the ability to independently identify and resolve errors (within their permissions) through the integrated reconciliation report.
- Improved Performance: Data processing speed was significantly enhanced compared to the previous system.
- Minimal User Disruption: We successfully minimized changes to existing user workflows, ensuring a smooth transition to the new system.
Conclusion
This case study demonstrates our commitment to delivering seamless integration solutions that prioritize user experience and operational efficiency. By addressing pain points, optimizing processes, and providing comprehensive support, we successfully integrated System HIS2 with Oracle EBS, enabling efficient data synchronization and empowering users to manage their workflows effectively.