Table 35. Schema differences between SEA and SIA repositories
|
|
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. |