Data Collections - Planning Data Pull Taking Long Time Pulling OPM Data in MSC_CL_GMP_UTILITY
Last updated on JULY 11, 2018
Applies to:Oracle Process Manufacturing Process Planning - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Data Collections
Planning Data Pull has increased performance time of over an hour.
Previous runs averages about 2.5 hours and now take about 3.5 hours.
The issue can be reproduced at will with the following steps:
1. ASCP>Collections?Oracle Systems>Standard Collections.
Log shows long time in pulling OPM data
MSC_CL_GMP_UTILITY - 18-APR-2018 03:31:24
MSC_CL_GMP_UTILITY - Sequence Dependent Changeover size is = 0
MSC_CL_GMP_UTILITY - g_gmp_uom_class TIME Routing Detail Cursor = SELECT
/*+ DRIVING_SITE(sou) DRIVING_SITE(sou2) DRIVING_SITE(crd) DRIVING_SITE(frd)
MSC_CL_GMP_UTILITY - 18-APR-2018 04:47:43 <<< See total time taken here is over 75 minutes
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms