At a glance
CHALLENGES
- Discrepancies between WMS and Oracle quantities impacting product shipments and financials.
- Manual inventory validation using Excel vlookups.
- High volume of sales orders during peak hours (around 20K) leading to synchronization challenges.
BENEFITS
- Reduced discrepancies in inventory quantities.
- Streamlined customer order processing during peak hours.
- Enhanced financial accuracy and reporting.
TIMELINES
The implementation took approximately 4 months, involving
collaboration with integration, WMS, and Oracle teams,
along with thorough validation of inbound and outbound
transactions
ARIA SANTIAGO
Nutrition and Wellness Company
“SPL’s partnership was pivotal in
transforming our inventory management.
The seamless integration of Oracle and
WMS systems has significantly improved
our operations, providing us with real-time
visibility and ensuring smooth customer
order processing.
SCENARIO
A leading health and wellness company, specializing in nutrition
and weight loss products, faced critical challenges in
synchronizing inventory between their multiple warehouse
management systems (WMS) and Oracle Cloud. This affected
customer orders and financials, prompting them to seek a
robust solution.
IMPLEMENTED MODULES
- Integration of Oracle Cloud and WMS systems
- Utilization of MuleSoft and SSIS for data integration
- Automatic inventory sync for Receipts, Returns, Adjustments, Movements, and Shipments
- Daily pre-operation automatic process for inventory comparison and adjustments in Oracle
- Email notifications for users post-adjustment processing
SOLUTIONS
- A comprehensive solution was proposed and implemented using MuleSoft and SSIS integration.
- The automated process ensures daily synchronization of product onhand quantities between Oracle and WMS systems, addressing the challenges and providing visibility into inventory management.
- Positive and negative adjustments are processed in Oracle through SSIS-generated files, with email notifications for user awareness.
