When Importing Party Addresses As Primary Addresses, The Existing Primary Remains A Primary As Well. (Doc ID 2866996.1)

Last updated on OCTOBER 14, 2023

Applies to:

Symptoms

 When importing a Primary Party Address the primary flag for the existing address for the party is not reset and leading to both address as Primary

 Steps to Reproduce:

1.Via import management -> Account -> enable high volume unchecked -  import account with just minimal set of attributes

SourceSystem,SourceSystemReferenceValue,OrganizationName

DNB,DNB-ACCT-1000-STD,Std Imp Inc

DNB,DNB-ACCT-2000-STD,Std Imp Inc

2.Via import management -> Address -> enable high volume unchecked – import 1 primary address for each account

PartySourceSystem,PartySourceSystemReferenceValue,SourceSystem,SourceSystemReferenceValue,Country,PrimaryFlag,Address1

DNB,DNB-ACCT-1000-STD,DNB,DNB-ADDR-1000-STD,US,Y,Std first prmry address

DNB,DNB-ACCT-2000-STD,DNB,DNB-ADDR-2000-STD,US,Y,Std first prmry address

3. Via import management -> Address -> enable high volume unchecked – import 1 primary address for each account. Customer wants this latest address (which is actually the second address) to be primary

PartySourceSystem,PartySourceSystemReferenceValue,SourceSystem,SourceSystemReferenceValue,Country,PrimaryFlag,Address1

DNB,DNB-ACCT-1000-STD,DNB,DNB-ADDR-1001-STD,US,Y,Std Second primary address

DNB,DNB-ACCT-2000-STD,DNB,DNB-ADDR-2001-STD,US,Y,Std Second primary address

Expectation : the second address to be marked as primary and the first address (imported via step 2) to be reset as not primary.

Actual : both the addresses are left behind as primary

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.