ATP Data Pull & Planning Data Pull Worker Ending With Error ORA-942 For MRP_AN_AHL_MTL_REQS_V (Doc ID 2131663.1)

Last updated on MARCH 08, 2017

Applies to:

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

Goal

After upgrade from 11.5.10 to 12.2.4, when we launch ATP Data Collections we see error in the Planning Data Pull worker log file

************************************************************
25-APR 11:02:44 : Task Number is 48
25-APR 11:02:44 : Global RN (msc_cl_pull.v_lrn): 43196906
25-APR 11:02:44 : Procedure MSC_CL_DEMAND_PULL.LOAD_SALES_ORDER(5:AHL) started.
25-APR 11:02:44 : insert into MSC_ST_SALES_ORDERS ( DEMAND_ID, ROW_TYPE, DELETED_FLAG, RESERVATION_TYPE, ORGANIZATION_ID, REFRESH_ID, SR_INSTANCE_ID) select x.DEMAND_ID, x.ROW_TYPE, 1, x.RESERVATION_TYPE, x.ORGANIZATION_ID, :v_refresh_id, :v_instance_id from MRP_AN_AHL_MTL_REQS_V x where x.ORGANIZATION_ID IN (101,102,103,122,125,145,166,186) AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )
25-APR 11:02:44 : Error pulling data from MRP_AN_AHL_MTL_REQS_V to MSC_ST_SALES_ORDERS.
25-APR 11:02:44 : ORA-00942: table or view does not exist
25-APR 11:02:44 : ORA-00942: table or view does not exist
25-APR 11:02:44 : Error_Stack...
25-APR 11:02:44 : ORA-00942: table or view does not exist

25-APR 11:02:44 : Error_Backtrace...
25-APR 11:02:44 : ORA-06512: at "APPS.MSC_CL_PULL", line 7022
ORA-06512: at "APPS.MSC_CL_PULL", line 1809
 

Solution

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