My Oracle Support Banner

Planning Data Pull Worker Fails - Error pulling data from BISBV_PERFORMANCE_MEASURES to MSC_ST_BIS_PFMC_MEASURES - ORA-00942: table or view does not exist (Doc ID 1940051.1)

Last updated on NOVEMBER 13, 2018

Applies to:

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

Symptoms

When attempting to run the Data Collections, the following error occurs in the Planning Data Pull/Worker (MSCPDP/MSCPDPW)...

ERROR
-----------------------
28-OCT 10:44:00 : Error pulling data from BISBV_PERFORMANCE_MEASURES to MSC_ST_BIS_PFMC_MEASURES.
28-OCT 10:44:00 : ORA-00942: table or view does not exist
ORA-02063: preceding line from VCP_TO_SOURCE
28-OCT 10:44:00 : ORA-00942: table or view does not exist
ORA-02063: preceding line from VCP_TO_SOURCE
28-OCT 10:44:00 : Error_Stack...
28-OCT 10:44:00 : ORA-00942: table or view does not exist
ORA-02063: preceding line from VCP_TO_SOURCE

28-OCT 10:44:00 : Error_Backtrace...
28-OCT 10:44:00 : ORA-06512: at "APPS.MSC_CL_PULL", line 6943
ORA-06512: at "APPS.MSC_CL_PULL", line 1730

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


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.