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

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