JDE-VCP PIP Fails To Upload UOM Class Conversion Data In VCP (Doc ID 2192998.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version 11.6 and later
Information in this document applies to any platform.

Symptoms

12.2.5
MSCCLPPB.pls 120.67.12020000.29

PROBLEM
-------------
We have run VCP Collection Process.
Though data is present in base.xml still UOM Class Conversion data is not inserted in VCP MSC_ST_UOM_CLASS_CONVERSIONS table.

We have data in msc_st_uom_conversion table without any error_text. But no data in msc_uom_conversions base table.
-- data in process_status = 2 and never processed.

It appears that they pre-processor gets error trying to process MSC_ST_UOM_CLASS_CONVERSIONS - then does not progress to to uom_conversions processing.

Log shows

19-SEP 12:29:46 : MSC_CL_PRE_PROCESS.LOAD_UOM_CLASS_CONV(24)ORA-00928: missing SELECT keyword

STEPS
--------
Run extract to generate base.xml
and run collections process.

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