Lost Production Data For Orders In EBS OM By Accidentally Running The Order Purge Selection Job (Doc ID 2212239.1)

Last updated on DECEMBER 08, 2016

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Accidentally selected wrong date range. Purged 2 years worth of Sales Orders.

1. Order Management responsibility
2. Orders, Returns > Purge > Order Purge Selection
3. Enter the Purge criteria and create a Purge set
4. Entered a specific range of dates by selecting a value for the Creation Date Low, the Creation Date High
5. Click Submit

Have a clone of the production data in a test environment, however, need to selectively extract and load the data into production.

Do you have any scripts or process to restore the data back in production?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms