Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to delete shipments history collected from OPS for last one month — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to delete shipments history collected from OPS for last one month

Received Response
24
Views
4
Comments
edited May 27, 2021 2:10PM in Supply Chain Planning and Collaboration 4 comments

Summary

How to delete shipments history collected from OPS for last one month. We used seeded collection to collect shipments history from fusion (OPS).

Content

We are trying to delete shipments history collected via seeded collection job for last one month only. That is we are trying to delete all shipments history for the month May 2021. We can't use FBDI because the data was collected using standard collection. We can't use Adjusted Shipments History to override manually, more than 100K records. 

I tried using seeded job 'Purge Data Repository'. In the 'Demand Planning Data', we have the options to limit the number of days to purge data. However, both the options don't facilitate a way to purge last one month data only. Either it allows to purge the oldest data or allows to retain the latest/recent data. Not sure how to leverage these options to purge only one month's data (recent month). 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!