Standard Data Collection: Planning Data Pull Worker ends in error: Profile "BOM: UOM for Hour" is Invalid.
(Doc ID 957329.1)
Last updated on DECEMBER 04, 2019
Applies to:
Oracle Process Manufacturing Process Planning - Version 11.5.0 and laterInformation in this document applies to any platform.
Symptoms
When running Standard Data Collection to pull the OPM data to Planning instance; the Planning Data Pull Worker requests is completed with error. The request generate in Completed Error in Collection trigger and Collection pull.
10/22/2009 16:54:41
GMP_BOM_ROUTING_PKG.get_profile_value called for profile BOM:HOUR_UOM_CODE with dblink Profile "BOM: UOM for Hour" is Invalid
Effectivity extraction failed
22-OCT 16:54:41 : Error in Routine GMP_BOM_ROUTING_PKG.EXTRACT_EFFECTIVITIES.
22-OCT 16:54:41 : User-Defined Exception
22-OCT 16:54:41 : User-Defined Exception
22-OCT 16:54:41 : Error_Stack...
22-OCT 16:54:41 : ORA-06510: PL/SQL: unhandled user-defined exception
22-OCT 16:54:41 : Error_Backtrace...
22-OCT 16:54:41 : ORA-06512: at "APPS.MSC_CL_PULL", line 6213
ORA-06512: at "APPS.MSC_CL_PULL", line 1583
Steps To Reproduce:
- Go to OPM supply chain planning.
- Run the Standard data collections and ends with error.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |