Targeted collection for catalogs is picking only end dated category codes

Summary:

for us category codes are different while category names are same. business tends to move items from one category code to another keeping category name same.

first netchange collection run for catalog picks the changed category code.

first targeted collection run for catalog will again pick the end dated category and category code.

again netchange collection run for catalog now cannot pick the active category code.

Business has weekly targeted run scheduled and the custom hierarchy for category is attached to plan scope. which due to this issue misses the items in the plan.

no forecast generation for them, we cannot publish them to suppliers.