• UK: +44 (0)118 9653 904
    IRL: + 353 (0)61 512 840
  • support

Oracle E-Business Suite, Support to 2030 | Time to Think about Data Archiving

In June 2017, Oracle announced a product roadmap for Oracle E-Business Suite which showed a further release beyond 12.2 with support available to customers through to 2030!  For customers who are not already in the process of moving to a cloud-based ERP solution, the decision on the future can be postponed for the time being.


Extending the life of an existing, on-premise ERP solution is not without its challenges.  Many customers currently using Oracle E-Business Suite have done so for many years and the underlying database has grown continually since the original implementation. Over time, the historical data being held alongside current data has an impact on user experience and everyday operational needs such as backing up the database regularly. 


Continuing to run Oracle E-Business Suite to 2020 and beyond will imply further application upgrades will have to take place to maintain full support from Oracle. Each upgrade can potentially become longer and more difficult to achieve as the data volumes continue to grow.


There is another, and often more high profile, challenge faced in continuing to store all data within an operational ERP system. Companies are subject to legal minimums for the retention of certain information and internal policies may exist which define longer periods and/or cover additional types of data. However, almost no data is required to be held indefinitely and it is therefore likely that most organizations are storing data that is not required for any business purpose. Often this is seen as having little more impact than additional disk storage, however, in the event of a legal case, any information held needs to be disclosed. The additional time and effort expended can be costly.


In the event of a data breach, holding more data than required increases the size of the breach and the resulting exposure to sanctions including fines and damage to the company’s brand.

It is not surprising therefore that companies are looking for Archive & Purge solutions for Oracle E-Business Suite to manage their data more effectively. In most ERP applications, any routines provided as standard have limited functionality, are difficult to modify to cope with local customisations, are not performance optimised and risk creating data integrity issues.


As an alternative, Oracle E-Business Suite customers can buy additional Oracle Database Enterprise Edition options including Partitioning and Compression to reduce the impact of storing historical data, however, the additional license costs and the fact that the data continues to be stored in the production database schema makes this a potentially expensive solution.


An alternative approach which has been successfully deployed by hundreds of ERP customers is ARCTOOLS™.  Originally developed for use with JD Edwards ERP, ARCTOOLS™ is an Archive & Purge solution based on a rules & database engine independent of any individual application. Installed outside of the application’s code base it is not a customisation and does not require integration work and associated testing. 


So how does ARCTOOLS work?

ARCTOOLS focuses on ensuring data is archived with integrity maintained. To do this requires an understanding both of the application function and also the underlying data model. ARCTOOLS comes supplied with pre-built modules for core business functions such as Financials making implementation rapid and the benefits quick to achieve. Once the data to be archived has been identified, usually by age but can also include any other criteria such as company, document type etc, the modules are configured and ready to run.  Scheduling takes place within ARCTOOLS and each job that runs produces a comprehensive log of its actions, even down to the SQL that was issued to the underlying database.


ARCTOOLS was built to interact natively with the application database to deliver performance and throughput, most other Archive & Purge products go via interfaces which slow down these time-critical processes.


With a common rules engine, ARCTOOLS supports multiple ERP applications including Oracle E-Business Suite and JD Edwards out of the box. It has also been used to archive many other packaged applications including Demantra and bespoke applications running on Oracle or Microsoft SQL Server database.


If you’re looking for a solution to data growth in your Oracle E-Business Suite application you’ll find more detail here, or to discuss your requirement please Contact Us

< Back to blog

About the author

David Storey

David joined the Redfaire team after 20 years at Oracle where he covered all aspects of Oracle’s Technology Stack and was well known in the field of Oracle Databases and Data Management. At Redfaire, David is responsible for ARCTOOLS, the leading Data Management solution for ERP Applications. ARCTOOLS provides customers with a cost-effective, easy to manage solution for typical data management challenges including Archiving, Application Retirement and Test Data Management.

Next Steps
Oct 22nd - 25th | Event | Oracle OpenWorld
13.02.2018 - Oracle’s OpenWorld event is hitting San Francisco from October 22nd to October 25th 2018. Delegates will… Read More
Planning your JD Edwards Cloud Journey

March 20th, London

02.02.2018 - Interactive sessions and presentations to help you optimise and extend JD Edwards with Oracle Cloud -… Read More