Why did my OBIEE report include old and deleted territories?
Only active territories can be assigned to sales objects such as accounts, opportunities, and leads. Territories in tables can be active, draft (in a proposal), or soft deleted.
For OBIEE reports, add these criteria to include only active territories:
-
StatusCode = FINALIZED
-
EffectiveEndDate is greater than today's date