ASCP: Unable To Load MSC_UOM_CONVERSIONS (Doc ID 1639011.1)

Last updated on JUNE 28, 2017

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

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 hundreds of Community platforms