My Oracle Support Banner

Using SCP Cloud Extract From EBS - How To Manage EBS Tables - MRP_AD% Which Are Growing Very Large (Doc ID 2725660.1)

Last updated on NOVEMBER 03, 2020

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

In our EBS instance we have a table MRP_AD_FORECAST_DATES which is approaching 60 GB in size. The table has no indexes so evidently this data is never queried at all.

This is one of the larger tables in our EBS instance so I'd like to get it under control.

1. What is this data for? Can we tell if we need this data?
2. Can we delete older data at some point?
3. Can we truncate the table?
4. Is it possible to stop new data from being added here, if we're truly not using this data?
 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.