Standard Collection Fails After Upgrading Planning Instance To 12.2 (Doc ID 2758585.1)

Last updated on APRIL 18, 2022

Applies to:

Goal

We have completed an upgrade of our planning instance to 12.2. Our source instance remains 12.1.

When running the standard collection, the Planning Data Pull Worker request fails. Logs are attached.

We have patched the source instance to ASCP version 12.1.3.9.2.

Log shows


MSCPDPW: Planning Data Pull Worker
+---------------------------------------------------------------------------+

Current system time is 25-FEB-2021 10:57:17

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

[25-FEB-2021 10:57:17]: **Starts**
[25-FEB-2021 11:05:06]: **Ends**
Planning Data Pull process failed.
...................

25-FEB 11:03:23 : Procedure MSC_CL_WIP_PULL.LOAD_WIP_SUPPLY started.
production_orders pinstance_id = 22 AND l_process_seq_id = 0
GMP:Collect WiP Batches when Output is Over OR Fully yielded = Yes
Failure occured during Production Orders extractORA-00942: table or view does not exist
ORA-02063: preceding line from EBSRED
ORA-00942: table or view does not exist
ORA-02063: preceding line from EBSRED
25-FEB 11:03:33 : Error in Routine GMP_APS_DS_PULL.PRODUCTION_ORDERS.
25-FEB 11:03:33 : User-Defined Exception
25-FEB 11:03:33 : User-Defined Exception
25-FEB 11:03:33 : Error_Stack...
25-FEB 11:03:33 : ORA-06510: PL/SQL: unhandled user-defined exception

25-FEB 11:03:33 : Error_Backtrace...
25-FEB 11:03:33 : ORA-06512: at "APPS.MSC_CL_PULL", line 7048
ORA-06512: at "APPS.MSC_CL_PULL", line 1825

Trace shows that key table is missing on the system - GME_BATCH_ONHOLD_DTLS

How can we get this table?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.