My Oracle Support Banner

Handling MLOG's and MRP_AD% Tables When Value Chain Planning Applications Are Not Used By The Business (Doc ID 580205.1)

Last updated on JUNE 28, 2017

Applies to:

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


ORA-01653 ORA-01555

Goal

Reviewed and revised for 25-MAR-2010

When a customer has decided not to use Data Collections and Value Chain Planning (aka APS - Advanced Planning and Scheduling) applications, but have run the initial installation processes, then the MLOG and MRP_AD% tables that were created will grow in an uncontrolled manner.
OR
The Data Collection objects do not exist, but this note is being used since some MLOG's that are shared with Data Collections are very large - e.g. MLOG$_BOM% tables.

If the business is no longer going to use these applications, then the objects can be managed using this note.

AND IF the business later changes direction and decides to implement applications that requires Data Collections to be run, then the entities can be easily restored to the system by:

Symptom that can lead to using this note

 

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
 What is happening on the system:
 Confirm with the Business Users:
 Limitations on the Advice in this Note
 What These Steps Accomplish
 Final Questions and Answers before Running the SQL
 SQL Commands
 Appendix A - Data Collections Snapshots and their Base Tables - 12.1
References

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