5 mins
Share
About the Client
The client is a global leader in materials science and digital identification solutions with a workforce of approximately 35,000 employees worldwide. The company serves diverse industries including apparel, retail, e-commerce, logistics, food and grocery, pharmaceuticals, automotive, and home and personal care.
The Challenges
During the shift from SAP to Oracle Fusion, the client chose not to build direct real-time interfaces with its legacy Warehouse Management System (WMS) to reduce implementation costs.
This created a challenge:
Goods receipts against purchase orders had to be entered manually in Oracle Fusion.
The same supplier lot details then had to be entered separately in the legacy WMS.
Manual dual entry introduced delays, inefficiencies and possibility for errors.
The business needed a fast, reliable, and scalable solution that could:
Capture supplier lot numbers in Oracle Fusion during goods receipt.
Support multiple lot entries in a single step.
Automatically generate a new output file in a format directly loadable into the legacy WMS.
Ensure inventory consistency and traceability across both systems without requiring real-time integration.
The Solution
Working alongside the primary SI partner, our Oracle SCM consulting team designed and delivered a streamlined integration approach:
OIC-Based Integration
Enabled warehouse users to upload CSV files containing supplier lot details mapped to quantities for goods receipt in Oracle Fusion.
Custom ESS Job
Automated the processing of the uploaded file, performing the goods receipt and generating an output file in the required format for the legacy WMS.
Automated Lot Number Generation
Eliminated manual steps by correlating supplier lots with Oracle-generated lot numbers, ensuring accuracy.
Seamless File Exchange
Allowed the legacy WMS to consume output files directly, removing the need for manual file preparation.
This design struck a balance between cost savings (avoiding real-time interface build-outs) and operational efficiency (removing manual bottlenecks).
Business Impact
The implementation delivered measurable improvements:
Seamless Integration
No need for direct interfaces, yet smooth communication between Oracle Fusion and the legacy WMS.
Automated Data Handling
CSV-based uploads and ESS processing eliminated manual input errors.
Accurate Lot Traceability
Automated lot generation captured supplier-specific details without human intervention.
Efficient Goods Receipts
Faster inbound processing with no redundant manual steps.
Inventory Reliability
Ensured synchronized, accurate stock records across both Oracle Fusion and the legacy WMS.
What the Client said......
“ Dear Shabbir,
Truly appreciate your way of handling the customer & requirements.
Keep up the good work!!!
Thanks”Shabbir Malik Tahasildar
Head – Enterprise Cloud & Innovation
More Success Stories
Workspace Solutions Manufacturer Optimizes Wood Utilization by 40% and Streamlines Production with Oracle Cloud Manufacturing
Workspace Solutions Manufacturer Optimizes Wood Utilization by 40% and Streamlines Production with Oracle Cloud Manufacturing
Read More
A Global Manufacturer Enhances Statistical Forecast Accuracy by 15%+ Using Elfonze’s Innovative Forecasting Approach
A Global Manufacturer Enhances Statistical Forecast Accuracy by 15%+ Using Elfonze’s Innovative Forecasting Approach
Read More
A Diversified Agribusiness Leader Transforms Dry Goods Planning with Elfonze’s Tailored Supply Chain Solution
A Diversified Agribusiness Leader Transforms Dry Goods Planning with Elfonze’s Tailored Supply Chain Solution
Read More
How a Semiconductor Manufacturing Leader Automated Year-End Reporting with Oracle Cloud BI
How a Semiconductor Manufacturing Leader Automated Year-End Reporting with Oracle Cloud BI
Read More
Professional Services Leader Boosts Sales Efficiency with Automated Quoting & Ordering in Oracle CPQ
Professional Services Leader Boosts Sales Efficiency with Automated Quoting & Ordering in Oracle CPQ
Read More
Manufacturing Leader Automates Prepayment Invoice Creation with Oracle ERP, Eliminating Manual Effort and Improving Audit Readiness
Manufacturing Leader Automates Prepayment Invoice Creation with Oracle ERP, Eliminating Manual Effort and Improving Audit Readiness
Read More
Energy Distribution Leader Reduces 85% manual Effort by Automating Pre-Credit Calculations and Credit Memo Processing with Custom Oracle ERP Solution
Energy Distribution Leader Reduces 85% manual Effort by Automating Pre-Credit Calculations and Credit Memo Processing with Custom Oracle ERP Solution
Read More
A leading energy distribution company leverages a Custom Inter Unit Transfer engine to digitalize and streamline 40K+ Inter Unit Transfer transactions per year
A leading energy distribution company leverages a Custom Inter Unit Transfer engine to digitalize and streamline 40K+ Inter Unit Transfer transactions per year
Read More