I was wondering if anyone knew of a way to see who would be scheduling each merge. We have a fair number of duplicates that have piled up and we're doing some heavy cleanup, and I would love to be able to see who scheduled what.
Thanks,
Stephen
You should be able to see the login id of who scheduled a particular merge by reviewing the data in the T_POTENTIAL_DUPS.
Any pair of rows with matching values in the "criterion" column, with values of "K" (for Keep) and "D" (for Delete) are scheduled; the last_updated_by column should show the user that scheduled those rows (ie, moved their status from "P", for Potential, to "K" or "D").
Hope this helps!