My Oracle Support Banner

PDP Fails With Item Extraction Failed With Error ORA-00904: "SEQ_DPND_CLASS": Invalid Identifier (Doc ID 1985229.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Process Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.


AT the time of runing "Planning Data Collection" get this error.


ERROR
-----------------------

MSCPDP module: Planning Data Pull

ORA-00904: "SEQ_DPND_CLASS": invalid identifier when INSERT INTO gmp_item_aps@KEP_TO_NIC from ic_item_mst@KEP_TO_NIC

Item extraction failed with error ORA-00904: "SEQ_DPND_CLASS": invalid identifier

There is a subsequent and highly likely to be consequential error in:

MSCPDPW module: Planning Data Pull Worker

Error retrieving effectivities: ORA-00942: table or view does not exist
ORA-02063: preceding line from KEP_TO_NIC
MSC_CL_GMP_UTILITY - Effectivity extraction failed
25-FEB 22:45:57 : Error in Routine MSC_CL_GMP_UTILITY.EXTRACT_EFFECTIVITIES.
25-FEB 22:45:57 : User-Defined Exception
25-FEB 22:45:57 : User-Defined Exception
25-FEB 22:45:57 : Error_Stack...
25-FEB 22:45:57 : ORA-06510: PL/SQL: unhandled user-defined exception

25-FEB 22:45:57 : Error_Backtrace...
25-FEB 22:45:57 : ORA-06512: at "APPS.MSC_CL_PULL", line 7039
ORA-06512: at "APPS.MSC_CL_PULL", line 1805


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N) ASCP -> Oracle Systems -> Collections where the environment is decentralized and ASCP is R12 and the OPM Source instance is 11.5.10.2


BUSINESS IMPACT
-----------------------
cannot collect OPM data and therefore cannot plan

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.