JMJ CLOUD
  • Home
  • Projects
  • Blog
  • About Us
  • Contact Us

Our Blog

Retire Your E-Business Suite Data in Style with APEX

7/16/2017

3 Comments

 

The Situation

Picture
Oracle E-Business Suite is an old friend. I have been implementing and extending EBS since 1994 (think version 9.4 character mode). There comes a time, however, when we need to move onto the next big thing. If only it was as easy to move to the next ERP as it is to upgrade your iPhone. If you have made the decision to move to Oracle ERP Cloud but are wondering what to do with the years and years of accumulated EBS data, then this post is for you. With APEX and some EBS know how, there is an affordable way to sunset your EBS environment without having to either convert all of the data or maintain your old EBS environment for the next 5-10 years.

The Problem

Picture
The problem is that in many cases you are legally required to keep your ERP data for many years (100 years if you are into Nuclear Energy!). One option is to keep EBS up and running in view only mode. Maintaining the hardware to keep the full EBS stack up and running, however, is not cheap. When you add the cost of keeping it patched and secure you end up with pretty much the same headache you were trying to get rid of by going to the cloud in the first place. Just shifting all this software to AWS or Oracle IaaS really doesn't help much either.
​

Implementers will convert your data to ERP Cloud for you but this can get expensive quickly. The more years of data you have and the more complex the data you are migrating, the bigger the bill. If you are converting anything more than the legally required number of years of General Ledger, your master data and any high volume open transactions then the chances are you are paying more than you need to. If you can reduce the amount and types of data you have to move to ERP Cloud you can reduce the implementation bill significantly. No matter what data you are able to convert, however, the chances are you will still be required to retain much of your EBS data for at least 5-10 years.

The Solution (APEX to the Rescue)

Picture
We were recently given this challenge by a customer. They had a legacy EBS R11.5.10 environment they had inherited during an acquisition. The data had long since been converted to their corporate EBS R12 environment but they had to keep the old environment open for audit purposes. It was running on aging Sun Hardware and was becoming increasingly challenging to manage.
​

We proposed migrating just the database to a much smaller Linux Server and putting an APEX front end on it. Not only does this solve the problem of maintainability and cost, it also gives users a modern easy to use UI to work with.

Now that this is up and running and the old hardware retired, the next step is to move just the tables they need to a PaaS cloud service. We are thinking we can squeeze this into something like Exadata Express ($175/month for 20GB). That a big step down from maintaining a full EBS environment for something that is accessed a dozen or so times a year.

Why APEX?

I believe APEX is uniquely suited to solving this problem:
  1. It runs off an Oracle database (which you have anyway)
  2. All it needs to run (aside from the database) is ORDS which, when run in standalone mode offers a tiny footprint when compared to the full EBS stack.
  3. The data and APEX application can be easily moved to a cloud service (such as Exadata Express).
  4. APEX offers an easy to use and powerful reporting capability with build in advanced end user features such as Aggregation, Grouping, Charting, Filtering, Pivoting etc. All based on a simple SQL statement.
  5. APEX allows you to integrate various security models so users could login using their current Active Directory credentials.

Sneak Peek

I'll leave you with a sneak peak of what we built. The application was built using the latest version of APEX (as of time of writing 5.1.2). It handles the various EBS organization constructs, Operating Units, Legal Entities, Ledgers, Inventory Organizations etc.
3 Comments
Dinesh
8/6/2017 02:15:27 am

JMJ, you guys are brilliant as usual. The solution sounds extremely simple and elegant. Simpler the solution, better it is.

Reply
Sreenivasa Eedara
8/14/2017 07:08:24 pm

I like this idea and this could help big companies to move to Oracle ERP cloud.
Anyone has been implemented this?
Thanks

Reply
Jon Dixon link
8/15/2017 07:41:27 am

Yes, we recently did this for one of our customers who acquired a company which also had EBS. We created a solution to maintain historical data for the company they bought using APEX. All they had to maintain was a small Linux server with the Oracle DB (and it's EBS data), ORDS and APEX.

Reply

Your comment will be posted after it is approved.


Leave a Reply.

    RSS Feed

    Popular Posts

    - APEX Dog Food
    - Cloud ERP & APEX Mashup
    - Modernizing EBS with APEX
    - Easy APEX_WEB_SERVICE
    - Running APEX in RDS
    - ORDS What & Why?

    Categories

    All
    APEX
    AWS
    Fusion Cloud ERP
    INTEGRATION
    MS GRAPH
    OCI
    ORDS
    PaaS
    RAD
    REST
    SOAP

    Archives

    October 2021
    February 2021
    January 2021
    October 2020
    September 2020
    June 2020
    May 2020
    April 2020
    February 2020
    January 2020
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    September 2017
    August 2017
    July 2017
    June 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016

Company

About
Contact
Blog
  • Home
  • Projects
  • Blog
  • About Us
  • Contact Us