Load/Copy/Merge MDS Program Is Experiencing Poor Performance Due to Large Number of Records in MRP_RELIEF_INTERFACE table
Last updated on JUNE 28, 2017
Applies to:Oracle Materials Requirement Planning - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Master Demand Schedule
Load/Copy/Merge MDS program taking long time
We have a request set "AWA Detroit Load/Copy/Merge MDS" which has requests that run the standard program 'Load/Copy/Merge MDS' several times for each 'Destination Schedule'. This request set should take about 2 hours in average to complete. But sometimes this is taking longer, for example 7 or 9 hours. Due to this, the next set of MRP related programs are getting affected so that the MRP_RECOMMENDATIONS table is not populating as expected.
We have been running gather schema stats for MRP and MSC to clear stale data every day hoping to see above request will complete in lesser time but this did not improve performance of the program 'Load/Copy/Merge MDS'.
Expect the request set to take about 2 hours on average
The issue can be reproduced at will with the following steps:
1. Run the request set "AWA Detroit Load/Copy/Merge MDS"
2. Note the problem with Load/Copy/Merge MDS performance
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