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.
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
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms