Replace association of old Address with new to an Account without creating a new intersection record
Using an EAI Data Map and the EAI Siebel Adapter business service, I'm trying to:
- Create a new Address record (S_ADDR_PER)
- Associate this to an Account via an existing intersection record (S_CON_ADDR), replacing the ADD_PER_ID that's already there.
In essence, I want to simply update the S_CON_ADDR.ADDR_PER_ID of the existing intersection record, without creating a whole new S_CON_ADDR record. We store a lot of data on the intersection and the S_CON_ADDR.ROW_ID is referred to via many foreign keys. Our master data system dictates that we cannot simply update S_ADDR_PER to modify an address, forcing us to create a new one.