The Party Name In HZ_PARTIES Gets Updated With Party Name From DNB After Running Import (Doc ID 2258534.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Trading Community - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Updating a party information via Import DNB file. The party name which is there in the file is replacing the party name is HZ_PARTIES table

For example:

You see Orthoshop BVBA in HZ_PARTIES table instead of ORTHOSHOP NV in HZ_ORGANIZATION_PROFILES.

SQL> execute hz_common_pub.disable_cont_source_security;
PL/SQL procedure successfully completed.

SQL> select organization_profile_id, organization_name,actual_content_source, content_source_type,effective_start_date, effective_end_date from hz_organization_profiles where party_id = 437727;

ORGANIZATION_PROFILE_ID ORGANIZATION_NAME ACTUAL_CONTENT_SOURCE CONTENT_SOURCE_TYPE EFFECTIVE_START_DATE   EFFECTIVE_END_DATE
465839                              ORTHOSHOP NV         SST                                  USER_ENTERED              15-APR-16
686919                              Orthoshop BVBA         DNB                                  DNB                             22-NOV-16
439630                              ORTHOSHOP NV         SST                                  USER_ENTERED              11-APR-16                     14-APR-16

You expect hz_parties to have ORGHOSHOP NV (user entered) and NOT Orthoshop BVBA (DNB)

HZ_PARTIES.PARTY_NAME is showing Orthoshop BVBA



Cause

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