Data collection - Planning Data Pull Worker Request Error Out
Hi All,
We had applied VCP 12.1.3.9.2 aka R12.SCP_PF.B.Delta.4 - Patch 22706126. and our existing VCP version was 12.1.3 , When we applied the patch the data collection request got aborted due to below error.
Error Details:-
________________________________________________________________________________________
22-NOV 03:02:17 : Task Number is 10
22-NOV 03:02:17 : Global RN (msc_cl_pull.v_lrn): -1
22-NOV 03:02:17 : Procedure MSC_CL_DEMAND_PULL.LOAD_SALES_ORDER(1) started.
22-NOV 03:02:17 : lv_net_sales :
22-NOV 03:02:17 : Error pulling data from MRP_AP1_SALES_ORDERS_V to MSC_ST_SALES_ORDERS.
22-NOV 03:02:17 : ORA-00904: "X"."DEFECTIVE_FLAG": invalid identifier
22-NOV 03:02:17 : ORA-00904: "X"."DEFECTIVE_FLAG": invalid identifier
22-NOV 03:02:17 : Error_Stack...
22-NOV 03:02:17 : ORA-00904: "X"."DEFECTIVE_FLAG": invalid identifier