VENDOR CORNER Fall 2018

MANAGING YOUR EBS DATA DURING ORGANIZATIONAL CHANGE

Once your Oracle E-Business Suite (EBS) implementation go-live is behind you, there follow a few months of ironing out business processes, workflows and attaining maturity in conducting day-to-day business smoothly without much IT intervention.

Even after steady state is achieved, there always are requirements and demands initiated by business and strategy changes that impact your data management.

For example, restructures and organic business growth can put a strain on how you deal with data and data entry. Issues can arise with timeliness and data quality.

In the case of a restructure, there are many varying factors that can have an impact on the success of the project: whether the project is company-wide or limited to one area, changing the human resource structure or changing the reporting requirements within the company. Changes like these will have an impact on the processes, reporting and data collection methods.

Understanding and scoping out any process change is key in determining the scale of the restructure, which then allows you to identify the metrics of how much data will be impacted.

How do you improve your processes during data restructures?
Identify the scale of your changes:

  • Are you dealing with a larger volume of data?
  • Are a multitude of functional areas affected?
  • Can you get away with a small bit of manual data entry?

Methods of processing data

  • Traditional methods of manual user entry: Cost effective and efficient when dealing with a small amount of data changes.
  • IT-built processes: Expensive but may be required when working with very large volumes of data.
  • Third-party solutions: Solutions that are out-of-the-box and already created to help assist users who know the data with their specific data processing needs.

Typically, larger volumes of data require an IT department that will create bespoke code for the project; traditional manual methods are inefficient, risky and result in high costs.

Within the EBS space, there are third-party solutions that are available within the market to empower and allow end users to own their data, resulting in improved data quality and user engagement. However, these involve building templates, maintaining them and keeping patches up to date.

At More4Apps, we have software products that help our customers with their data needs. These are pre-built, off-the-shelf, Excel-based templates that are ready to plug and play into EBS and load volumes of records without being stuck with a 1-record view of Oracle forms.

Let’s take James Avery, a family owned jewelry company. How did More4Apps work out for them?

Previously all Bill of Materials changes were performed manually. However, as the company grew, manual updates became inefficient and lagged behind manufacturing planning and production requirements.

The biggest drivers behind James Avery’s process changes were:

  • Company growth.
  • New manufacturing facilities.
  • Competing responsibilities for functional users.
  • More products.

Using the More4Apps products, James Avery was able to:

  • Increase the ability to introduce new items from 300 to over 700 annually, without additional headcount.
  • Update routings for over 20,000 finished products and 5,000 sub-assemblies in four organizations.
  • Update inventory categories for 18,000 items and introduce min/max planning for a range of supply items.
  • Update supply sub-inventories for components, on over 20,000 Bills of Material.

As well as giving staff their weekends back, the setup times for new products improved by over 600 percent.

Learn how you can improve your data processing methods at www.More4Apps.com.

More4Apps simplifies business processes by providing intelligent data capture and integration solutions. Since 2000, More4Apps has gained more than 20,000 EBS users in over 45 countries, establishing a loyal customer base.