My Oracle Support Banner

ASCP: Unable To Load MSC_UOM_CONVERSIONS (Doc ID 1639011.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9 and later
Information in this document applies to any platform.

Symptoms

When running Legacy Collections, the MSC Pre Process Worker is failing with below error. ,

ERROR
-----------------------
MSCPPW module: MSC Pre Process Worker
09-JAN 07:19:08 : The name in GET_MY_COMPANY :My Company
09-JAN 07:19:08 : v_legacy_parallel = 0
09-JAN 07:19:08 : Oracle ASCP Installed
09-JAN 07:19:10 : Procedure LOAD_UOM_CLASS_CONV started.
09-JAN 07:19:10 : MSC_CL_PRE_PROCESS.LOAD_UOM_CLASS_CONV(24)ORA-00928: missing SELECT keyword



The issue can be reproduced at will with the following steps:
1. Launch legacy collections

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.