MSC Pre Process Worker Fails With Error " MSC_PP_FAIL" And Pre-process Monitor Hangs (Doc ID 2182806.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Data Collections

Using ODI-PIP to Collect from JDE Edwards

MSC Pre Process Worker fails with Error " MSC_PP_FAIL" and Pre-process Monitor never completes

We are seeing an error when the Pre-process Monitor creates an Index on MSC_ST_BOMS and MSC_ST_ROUTINGS.

ERROR
-----------------------
06-JUL 21:08:40 : Error creating Index MSC_ST_BOMS_N1_E1C. Error:ORA-00904: "ALTERNATE_BOM_DESIGNATOR": invalid identifier
06-JUL 21:08:41 : Error creating Index MSC_ST_ROUTINGS_N1_E1C. Error:ORA-00904: "ALTERNATE_ROUTING_DESIGNATOR": invalid identifier

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run 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