Need to attach same Address multiple times against same Account (Doc ID 799313.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.0.0.5 [20420] and later
Information in this document applies to any platform.
""Checked for Relevance on 12-AUG-2015""

Goal


Customer has a requirement of associating an Account with the same address multiple times, each against different Address Types;

e,g. an address 101 Fairway Street,LA,California can be associated twice with an Account once with Address Type as "Physical" and one more time with Address type as "Mailing".


Thus customer intends to have only a single record in the S_ADDR_PER table but two records in the S_CON_ADDR table with the same ACCNT_ID and ADDR_PER_ID combination but different ADDR_TYPE_CD/RELATION_TYPE_CD.

In standard customer cannot associate the same address multiple times against the same account.

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