Asociation Of Account To The Same Address With Multiple Address Purposes from Siebel to Fusion (Doc ID 2046376.1)

Last updated on APRIL 25, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

In Siebel, there is a M:M relation between accounts and addresses and M:M relations can be loaded for accounts and addresses.

In the source application, the same address can be billing, shipping, primary address under an acccount. In siebel intersection table (account address) S_CON_ADDR, multiple records with unique row_id will be present with same account_id and addr_per_id, but with different address purpose.
But, in Sales cloud, there are different object for Address and Address purpose that cannot be used to replicate the siebel data in sales cloud.
When the account and address are associated with different address purpose in Sales cloud, one address record is created with multiple address purposes.
In Siebel, if only billing address is changed and shipping address is still the same, the date of that particular record cannot be updated in Sales Cloude since only one address is present there with all the address purposes.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms