My Oracle Support Banner

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

Last updated on DECEMBER 22, 2020

Applies to:

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


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.