Legacy Collection - MSC Pre Process Worker Fails With MSC_PP_FAIL when RAC_ENABLED value 2 (Doc ID 2242639.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 with with VCP Cum Patch 12.2.4.1 - 19549533, running legacy collection got
stuck on the pre process workers and timed out. After rerunning, it again it errored as follows:
ERROR
-----------------------
MSCPPW: MSC Pre Process Worker
+---------------------------------------------------------------------------+

Current system time is 06-MAR-2017 10:31:50

+---------------------------------------------------------------------------+

**Starts**06-MAR-2017 10:31:50
**Ends**06-MAR-2017 10:31:50
MSC_PP_FAIL

Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
06-MAR 10:31:50 : The name in GET_MY_COMPANY :My Company
06-MAR 10:31:50 : v_legacy_parallel = 0
06-MAR 10:31:50 : Schema : APPS
06-MAR 10:31:50 : RAC_ENABLED value 2
06-MAR 10:31:50 : Initialize the Legacy load Pipes
06-MAR 10:31:50 : Oracle Demand Planning Installed
06-MAR 10:31:50 : Oracle ASCP Installed
06-MAR 10:31:50 : Get Pipe :MSC_CL_PRE_TQ21
06-MAR 10:31:50 : sucess_flag :0
06-MAR 10:31:50 : Message :-1
06-MAR 10:31:50 : Send Pipe :MSC_CL_PRE_ST21
06-MAR 10:31:50 : sucess_flag :0
06-MAR 10:31:50 : Message :1
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+



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