For our latest NCOA update, I was asked to add the addresses to the appropriate customer records (with type = "NCOA update", make them primary, then inactivate the erstwhile primary addresses and change their type to "Inactivated by NCOA update". All of that seemed to go fine, but now in the General tab for each record, the former primary addresses (now inactivated) still show up, rather than the new primary addresses.
What did I do wrong? Is there some switch I should have flipped? I do know about the T_NEXT_ID thing when bulk inserting records into certain tables, so I don't that's what's happening.
Me am stymied.
BONUS TRIVIA: James Madison was the first president to wear long trousers.
Matt,
You need to update the primary_address_no field in t_customer with the address_no of the new primary address you added.
David
DOH! Of course.
Thanks, David.