Siebel Innovation Pack 2015: Migrating Address Data After a Direct SEA to SIA Upgrade

See Table 36 for a list of schema differences between the SEA and SIA repository along with recommended data migration approaches.

Schema Differences Between SEA and SIA Repositories

Table 36 displays schema differences between the SEA repository and the SIA repository.

Table 36. Schema Differences Between SEA and SIA Repositories
SEA Repository	SIA Repository	SEA to SIA Migration Approach
Account Addresses are stored in the S_ADDR_ORG table. Other addresses are stored in the S_ADDR_PER table.	The S_ADDR_ORG table is obsolete. Address data is stored in the S_ADDR_PER table.	Data is converted automatically through upgrade scripts.
Organization Relationships are stored in the S_ORG_REL table. Other party relationships are stored in the S_PARTY_REL table.	All party relationships, including organizations, are stored in S_PARTY_REL. The S_ORG_REL table is obsolete.	Manual data migration required. For instructions see 476479.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 312.
Contact relationships are stored in the S_CONTACT_REL table. Other party relationships are stored in the S_PARTY_REL table.	All party relationships, including organizations, are stored in the S_PARTY_REL table. The S_CONTACT_REL table is obsolete.	Manual data migration required. For instructions see 476479.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 312.
Household relationships are stored in the S_PER_ORG_UNIT table.	Household relationships are stored in the S_PARTY_PER table.	Manual data migration required. For instructions see 476479.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 312.

Siebel Database Upgrade Guide		Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.