Shared Address

The shared address child object stores information on the addresses that can be shared between accounts, contacts, partners, and dealers.

This child object is applicable only for companies that have the Enable Shared Addresses check box selected on the company profile. In this case, addresses can be associated with multiple account, contact, dealer, or partner records.

When a child shared address is inserted, it can be flagged as a billing address or shipping address for accounts, dealers, and partners, or as a primary contact address for contacts. When this occurs, the billing, shipping, or primary contact fields in the parent object are populated from the shared address fields.

You cannot delete a shared address child object directly, it can only be dissociated through the parent-level shared address object. For more information, see Address. For more information about the shared address functionality, see Oracle CRM On Demand Online Help.

When Enable Shared Addresses is deselected, the shared address child object cannot be used, because addresses are not being shared. Instead, the address child object is used for address operations. For information about the address child object, see Address. See the following table for information about the usage of address child objects and fields depending on whether addresses are shared. For information about converting unshared addresses to shared addresses using UI export functionality and Web services calls, see Converting Unshared Addresses to Shared Addresses.

Table Usage of Address Child Objects and Fields Depending on Whether Enable Shared Addresses is Selected

Enable Shared Addresses check box on company profile	ListOfAddress (address as child object)	ListOfSharedAddress (shared address as child object)	Denormalised address fields in parent object (PrimaryBillToCity, PrimaryShipToCity and so on)	Address Id fields in parent object (PrimaryBillToAddressId, PrimaryShipToAddressId, AlternateAddressId)
Selected - addresses are shared.	Cannot be used to create, update, or delete the addresses as addresses are being shared, but can be used for query operations.	Can be used only to associate or dissociate an address from parent. Addresses cannot be created, deleted, or updated using this child object. The top-level Address Web service must be used, see Address.	Cannot be used because addresses are being shared. To create and update addresses, the top-level Address Web service must be used. see Address.	Can be used to associate a billing/shipping/primary address to the account, contact, dealer, partner objects.Billing/shipping/primary fields in ListOfSharedAddress can also be used for the same purpose.
Deselected - addresses are not being shared.	Can be used to create, update, delete, and read addresses.	Partial update allowed - can be used only to edit the intersection object fields other than AddressId, billing/shipping/primary flag fields. Changing address association or address flags is not allowed but any other fields (for example, custom fields on the account address object) can be updated. Create or delete and change in address association are not allowed, but query operations are not restricted.	Can be used.	Usage is as described in Adding and Updating Account Addresses.

Enable Shared Addresses check box on company profile

ListOfAddress (address as child object)

ListOfSharedAddress (shared address as child object)

Denormalised address fields in parent object (PrimaryBillToCity, PrimaryShipToCity and so on)

Address Id fields in parent object (PrimaryBillToAddressId, PrimaryShipToAddressId, AlternateAddressId)

Selected - addresses are shared.

Cannot be used to create, update, or delete the addresses as addresses are being shared, but can be used for query operations.

Can be used only to associate or dissociate an address from parent.

Addresses cannot be created, deleted, or updated using this child object. The top-level Address Web service must be used, see Address.

Cannot be used because addresses are being shared.

To create and update addresses, the top-level Address Web service must be used. see Address.

Can be used to associate a billing/shipping/primary address to the account, contact, dealer, partner objects.Billing/shipping/primary fields in ListOfSharedAddress can also be used for the same purpose.

Deselected - addresses are not being shared.

Can be used to create, update, delete, and read addresses.

Partial update allowed - can be used only to edit the intersection object fields other than AddressId, billing/shipping/primary flag fields. Changing address association or address flags is not allowed but any other fields (for example, custom fields on the account address object) can be updated.

Create or delete and change in address association are not allowed, but query operations are not restricted.

Can be used.

Usage is as described in Adding and Updating Account Addresses.

Parent Objects

Account, Contact, Dealer, Partner

Fields

The following table details the required and read-only fields for the shared address child object.

Table Required and Read-Only Fields for the Shared Address Child Object

Field Name	Type
AddressId	Read-only

The following table details the pick map fields for the shared address child object.

Table Pick Map Fields for the Shared Address Child Object

Pick Map Field	Maps To
AddressName	AddressId
AddressExternalSystemId	AddressId

The following table provides a list of the user key combinations for the shared address child object.

Table User Key Fields on the Shared Address Child Object

User Key Field Combinations
Id
AddressId
AddressName
AddressExternalSystemId

The following table details the picklists available for the shared address child object.

Table Picklists Available for the Shared Address Child Object

Field Name
AddressType
CurrencyCode