Data Discrepency in CN_COMMISSION_HEADERS
Hi,
I have few Payment records for invoice numbers for which i find multiple rows for comm_lines_api_id in cn_commission_headers_all table. Due to this the commission amount has increased by folds.
for example if the commission amount is 500$ and there are 3 rows for same api_id then the amount has increased to 1500$
I ran the collect and load program again thinking that it will obsolete the previous lines but it did not happen.It did not obsolete these duplicate transactions rather it obsoleted the latest processed transactions.
I then executed following steps-
1) Updated the commission amount to 0 in cn_commission_lines_all table for those commission_header_id which has duplicate comm_lines_api_id.
I have few Payment records for invoice numbers for which i find multiple rows for comm_lines_api_id in cn_commission_headers_all table. Due to this the commission amount has increased by folds.
for example if the commission amount is 500$ and there are 3 rows for same api_id then the amount has increased to 1500$
I ran the collect and load program again thinking that it will obsolete the previous lines but it did not happen.It did not obsolete these duplicate transactions rather it obsoleted the latest processed transactions.
I then executed following steps-
1) Updated the commission amount to 0 in cn_commission_lines_all table for those commission_header_id which has duplicate comm_lines_api_id.
0