Demantra Solutions - EBS (MOSC)

MOSC Banner

How to remove Data from SALES_DATA tables before 24 months

edited Mar 27, 2014 11:25AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered

Hello Everyone,

We have old data in Sales_Data tables which is more than 24 months. We do not use historic data more than 24 months to forecast.

What is the easiest way to remove data earlier than 24 months?

1) Is there a std feature to clear historic data based upon a date?

2) Is there any custom script we can use to remove historic data ? I want to be aware of any known pitfalls after we remove data from Sales_data table.

Thanks for your time.

rgds

Aqil

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center