Table MRP.MRP_RELIEF_INTERFACE too large

metalink參考:

Max_Extents Reached For Table MRP.MRP_RELIEF_INTERFACE [ID 214726.1]
		Modified 31-OCT-2002     Type PROBLEM     Status PUBLISHED

fact: Materials Requirement Planning 11.5

symptom: Max_Extents reached for table MRP.MRP_RELIEF_INTERFACE

symptom: Not using MRP Planning in 11i

symptom: Not using Forecasts, MDS, MPS, or MRP

symptom: Planning Manager is not running

symptom: Rows are continually added to MRP_RELIEF_INTERFACE

cause: The functions that cleanse the table are not being run.



fix:

The table can be safely truncated to save space.
This will have to be a regular DBA responsibility since we cannot keep the 
table from being updated.
OR
 1. Upgrade your code to 11.5.7 or higher
 2. Profile MRP: Planning Manager First time should be present
 3. Profile MRP:Interface Table History Days = 0
 4. Run the Planning Manager regularly
THEN
 This table will automatically be cleansed when these conditions are met.

Related Products More Applications > Value Chain Planning > Supply Chain Planning > Oracle Materials Requirement Planning 另外可以參考: Article-ID:         Note 148706.1 Alias:              SOL:OSS3001 Circulation:        PUBLISHED (LIMITED) Folder:             EBS.Mfg.MRPPlanning Topic:              MPS_MPS: Master Production Schedule Title:              Table MRP_RELIEF_INTERFACE Is Growing Very Large Document-Type:      PROBLEM Impact:             MEDIUM Skill-Level:        NOVICE Updated-Date:       20-AUG-2003 19:27:10 References:         Authors:            LERIKSON.US Attachments:        NONE Content-Type:       TEXT/X-HTML Products:           574/MPS (10.7); Platforms:          0;    @ This article has been replicated from the Primus repository ·                fact: Materials Requirement Planning ·                  ·                fact: MRP_RELIEF_INTERFACE ·                  ·                symptom: Table is growing very large ·                  ·                symptom: MPS is not being used ·                  ·                cause: MPS relief entries are created every time a PO or discrete Job is ·                created.  ·                Since the MPS is not being used, and the profile option, MRP: Consume MPS is ·                set to NO, The MPS relief entries are never getting purged from the ·                MRP_RELIEF_INTERFACE table. ·                Bug 1487243. ·                  ·                      fix:   There are two ways to clean up the records in the MRP_RELIEF_INTERFACE.   1.  If using the MDS Relief [or MPS Relief] but it is turned off for some reason, then turn it on using the profile MRP: Consume MDS [or MRP: Consume MPS] .  This ensures that the Planning Manager, in its next run, would process all these records. The daily cleanup worker of the Planning Manager would then clear up these records, thereby cleaning up MRP_RELIEF_INTERFACE.   If profile options Consume MDS/MPS are changed,  then restart the Planning Manager to activate the new profile option setting.   2)  If not using the MDS Relief [or MPS Relief],  then manually delete these rows from the MRP_RELIEF_INTERFACE using the following SQL:   Delete from MRP_RELIEF_INTERFACE where relief_type = 1; Delete from MRP_RELIEF_INTERFACE where relief_type = 2;