My Oracle Support Banner

New Dnb Purchases Are overriding Orig_system_reference = Duns_number (Doc ID 359656.1)

Last updated on MAY 24, 2019

Applies to:

Oracle Trading Community - Version 11.5.10 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.
HZ_MAP_PARTY_PUB ARHMAPSB.pls 115.91.115104.2

Symptoms

After upgrading 11.5.10 DNB one off purchases of new DNB data ORIG_SYSTEM_REFERENCE  is populated with the Duns_Number.

Prior to the upgrade the ORIG_SYSTEM_REFERENCE  was unique.

Now the new purchases of DNB the  HZ_PARTY table  ORIG_SYSTEM_REFERENCE field now
contained the D&B DUNS number

Changes

Upgrade to 11.5.10


You should not have the same duns_number for multiple customer (parties)
Each Location should have their own duns_number

.

Cause

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
Symptoms
Changes
Cause
Solution

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