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 AUGUST 11, 2022

Applies to:

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

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