My Oracle Support Banner

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

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
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.