My Oracle Support Banner

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

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!

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