Net Change Collection Fails (Doc ID 1536716.1)

Last updated on DECEMBER 13, 2016

Applies to:

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

Symptoms

On : 12.1.3.8 version, Data Collections

When attempting to run data collections in net change mode, the following error occurs in Planning Data Pull Worker.

ERROR
-----------------------
Procedure MSC_CL_DEMAND_PULL.LOAD_SALES_ORDER(5:AHL) started.
Error pulling data from MRP_AD_AHL_MTL_REQS_V to MSC_ST_SALES_ORDERS.
ORA-00942: table or view does not exist
ORA-02063: preceding line from DCMPIC_TO_SNB2
ORA-00942: table or view does not exist
ORA-02063: preceding line from DCMPIC_TO_SNB2
Error_Stack...
ORA-00942: table or view does not exist
ORA-02063: preceding line from DCMPIC_TO_SNB2

Error_Backtrace...
ORA-06512: at "APPS.MSC_CL_PULL", line 6649
ORA-06512: at "APPS.MSC_CL_PULL", line 1696


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Advanced Supply Chain planner
2. Run Data Collections with collection method as Net Change.

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