Sales History Question
DM Gurus
we are loading Sales history in our CRP Instrnace.
Total Number of Records in the Excel file : 148672
Total Number of records count in the T_SRC_SALES_TMPL = 148672,
After Running the Load history workflow,
Record count data for today's upload in the SALES_DATA=79498
select * from demantra.sales_data where trunc(last_update_date)='27-JAN-2014' order by ITEM_ID= Count= 78498
No records found in the T_SRC_SALES_TMPL_ERR = No records found
Can any one tell us, the data in the SRC_SALES_TMPL and sales_data record count not matching.. but there is no data in the error table. Is there is any way i can verify all my data is loaded in to the SALES_DATA table? is there is any way i can cross check?
we are loading Sales history in our CRP Instrnace.
Total Number of Records in the Excel file : 148672
Total Number of records count in the T_SRC_SALES_TMPL = 148672,
After Running the Load history workflow,
Record count data for today's upload in the SALES_DATA=79498
select * from demantra.sales_data where trunc(last_update_date)='27-JAN-2014' order by ITEM_ID= Count= 78498
No records found in the T_SRC_SALES_TMPL_ERR = No records found
Can any one tell us, the data in the SRC_SALES_TMPL and sales_data record count not matching.. but there is no data in the error table. Is there is any way i can verify all my data is loaded in to the SALES_DATA table? is there is any way i can cross check?
1