Re: How to delete the entire application data (EBS 12.2.6)

As others have already stated, there is no easy way to delete data for a particular business unit in EBS. Oracle doesn't provide a mechanism for doing this out of the box. There might be 3rd party tools but I'm not familiar with any.

We've recently done something similar at our company with the divestiture of one of our business units. What we did was provide the company with data extracts of the data they needed (items, inventory, open orders, open POs, etc) and they loaded into their ERP system. For our acquiring company, they were already an Oracle EBS shop so it was a bit easier to load data that was extracted from EBS using standard interfaces with minimal data massaging.

The other thing I'm wondering, is the new company, if not an Oracle EBS shop already, ready to take on the purchase of Oracle licensing needed to run EBS? Or maybe it's a "not our problem" scenario. :)

Alfredo

On Tue, Feb 25, 2020 at 9:31 AM Vishalaksha Vyas <vishalaksha_at_gmail.com> wrote:

> All,
>
>
>
> This question is related to the Oracle Application 12.2.6. In this Oracle
> instance we have two separate business units running and recently we have
> decided to sell one of the business units to some other company. I think
> there is some kind of agreement between our company and the other company
> to provide them (buyer) a cloned copy of Oracle instance by removing all
> the related data for the business unit which we are *not* selling. I am
> looking for different ways in which we can delete the data for the business
> unit we are *not *selling so that the buyer company will not have access
> to our private data.
>
>
>
> Does anyone have experience or any suggestions, how to handle these kinds
> of scenarios when companies are splitting up and need to protect their
> data?
>
>
> Thanks & Regards
> Vishalaksha Vyas
>

--
http://www.freelists.org/webpage/oracle-l