My Oracle Support Banner

Recently Disabled Mps Still Shows In Plan. Not Able To Delete Mps. (Doc ID 941989.1)

Last updated on SEPTEMBER 11, 2019

Applies to:

Oracle Materials Requirement Planning - Version 11.5.10 and later
Information in this document applies to any platform.
Information in this document applies to any platform.
FORM:MRPSCPWB.FMB - Supply Chain Planner Workbench
EXECUTABLE:MRRDPR - Planning Detail Report


Users have end dated (ie not purged, just inactivated) and MPS plan which contains manual MPS entries - However the entries are still showing in the planning detail report which, in turn, is affecting forecast demand. Currently they are unable to delete MPS entries since the MPS has been end dated.  They have attempted to delete all MPS entries in a Test instance, but records remain for the plan name in tables
mrp_gross_requirements and mrp_recommendations as well as other MRP tables.  What's the best way to remove the records from this specific plan from the MRP tables?


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

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