R12: How to do a mass de-activation of Supplier Contacts
We have a need to de-activate the old Supplier Contacts. In our Test instance, I updated the INACTIVE_DATE field of AP_SUPPLIER_CONTACTS table and the END_DATE column of HZ_RELATIONSHIPS table. I verified via SQL that both Inactive_DAte and End_Date have values of 21-NOV-13. But when I go to the Contact Directory form, the same Supplier Contacts continue to show "Current" in the Status field. I was expecting to see "Inactive".
What step could I be missing? Please advice. Thanks.