My Oracle Support Banner

In Collections for ASCP with OPM, the Planning Data Pull Process Failed With Error, "Profile "GMP: UOM for Hour" is Invalid" (Doc ID 2546991.1)

Last updated on DECEMBER 04, 2019

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 process failed

Planning data pull process failed..
following error is showing up in one of worker

We have MO Security Profile defined at source instance as well as MSC:UOM for Hours have been setup.. we have done refresh snapshots complete in both source and destination instance, after that running planning data collection and its erroring out..

15-APR 19:28:42 : Task Number is 36
15-APR 19:28:42 : Global RN (msc_cl_pull.v_lrn): -1
15-APR 19:28:42 : Procedure MSC_CL_WIP_PULL.LOAD_WIP_SUPPLY started.
production_orders pinstance_id = 1 AND l_process_seq_id = 0
GMP:Collect WiP Batches when Output is Over OR Fully yielded = Yes
Profile "GMP: UOM for Hour" is Invalid
15-APR 19:29:28 : Error in Routine GMP_APS_DS_PULL.PRODUCTION_ORDERS.
15-APR 19:29:28 : User-Defined Exception
15-APR 19:29:28 : User-Defined Exception
15-APR 19:29:28 : Error_Stack...
15-APR 19:29:28 : ORA-06510: PL/SQL: unhandled user-defined exception

15-APR 19:29:28 : Error_Backtrace...
15-APR 19:29:28 : ORA-06512: at "APPS.MSC_CL_PULL", line 7060
ORA-06512: at "APPS.MSC_CL_PULL", line 1808

The issue can be reproduced at will with the following steps:
1. Run Collections

The issue has the following business impact:
Due to this issue, users cannot .




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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