Collect Planning Data In JDE-VCP Integration Fails With ORA-00942

(Doc ID 1302807.1)

Last updated on SEPTEMBER 24, 2015

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version: 12.1.2 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

Applied VCP 12.1.3.3  patch 10389190 and 11713909 (for 10g ODI support)

Collect Planning Data in JDE-VCP Integration fails with error in:

MSCE1PDP module: Collect Planning Data

Error:

04-MAR 11:30:44 : ODI Scenario PREPROCESSHOOKPKG FAILED. Session # : 11317785
04-MAR 11:30:44 : Error : ORA-00942: table or view does not exist
04-MAR 11:30:46 : Mail Execution SUCCESS

Steps:
Collect Planning Data in VCP-JDE Integration

Changes

Applied VCP 12.1.3.3 patch.

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