Dunning emailed for accounts after strategy/items has been cancelled.

12.2.11

We have dunning emails with old/outdated transactions that are already paid/closed being sent out on accounts which have already had strategy/work items closed or cancelled.

Both IEX: Strategy Management and IEX: Scoring Engine Harness have been put on Hold while we determine how these emails are being generated.

select status_code from IEX.IEX_STRATEGIES only returns CLOSED or CANCELLED

select * from IEX.IEX_STRATEGY_WORK_ITEMS where status_code NOT IN ('COMPLETE','CANCELLED','SKIP','INERROR','INERROR_CHECK_NOTIFY','TIMEOUT') doesn't return any records

select * from APPLSYS.WF_ITEMS where ITEM_TYPE like 'IEX%' and end_date is null doesn't return any records