Opens in a new tab
Customer CommunitySupportProduct Download|
Company

Managing Customer Maintenance with Ease

Oracle EBS customer data maintenance

Achieving 96% Time Savings and Increased Data Integrity

Case Study – Retail

 

A leading retailer moved from using three products to one Excel-based solution for maintaining customer data in Oracle EBS, cutting errors and saving hundreds of hours every year.

 

The Client

A leading home improvement and lifestyle products retailer in Australia and New Zealand. They are also a major supplier to project builders, commercial tradespeople, and the housing industry. A More4apps customer since 2008, using ten products across the EBS Toolbox.

 

The Challenge

The Credit Control team managed commercial customer data using DataLoad Classic, then DataLoad Professional, an HTML-based tool running on Internet Explorer 11. The process involved extracting data via Discoverer reports, editing in Excel, and re-uploading through screen macros that required constant monitoring, extra PCs, and caused network performance issues. With IE11 being retired, the retailer needed a replacement that required little to no development, fast implementation, minimal training, and no network slowdowns.

 

The Solution

More4apps demonstrated the EBS Customer Wizard and provided a trial license for the Credit Control team to test in their development environment. The Wizard let users query and download customer details, including DFF Attributes, directly into Excel, then edit, validate, and upload changes securely back to Oracle EBS. This also covers sites, classifications, profiles, contacts, banking details, cards, and attachments.

 

The Results

  • 96% less time spent on customer creation and profile class assignments
  • 94% reduction in time for monthly customer profile changes
  • 87% decrease in time for monthly customer stop credit updates
  • ~29 hours saved every month, nearly nine weeks of work per year

 

“The outcome was a very successful introduction of the Customer Wizard that eliminated multiple laptops used for DataLoad keystroke processes that required constant monitoring,” said one end user. “Customer query in the Customer Wizard enabled the team to download customers, make the necessary updates in the spreadsheet, and upload. We’re saving time and improving accuracy!”

 

Tasks that once took days and multiple desktops now take three hours or less on any PC, freeing staff for higher-value work and a better customer experience.

Share
Tags
Case Study
EBS Toolbox
Oracle E-Business Suite
Oracle EBS
Oracle ERP