Data Collections - Planning Data Pull Taking Long Time Pulling OPM Data in MSC_CL_GMP_UTILITY
(Doc ID 2421817.1)
Last updated on JULY 16, 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!