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

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