My Oracle Support Banner

D&B Adapter Does Not Import 8 Digit SIC Codes (Doc ID 2778300.1)

Last updated on MAY 21, 2021

Applies to:

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

Symptoms

On : 12.1.3 version, Third Party Data Integration

ACTUAL BEHAVIOR
---------------
Seeded request set "D&B Import Adapter", Request Set code "HZ_DNB_ADAPTER2" to import D&B data into Oracle Customer Data Hub.
The request set import 4 digit 1987 SIC codes, but it does not import 8 digit SIC codes.

EXPECTED BEHAVIOR
-----------------------
Seeded request set "D&B Import Adapter", Request Set code "HZ_DNB_ADAPTER2" should import 8 digit SIC codes.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

In DNB file Test.csv, column
AE                                  AF                                        AG
PRIMARY_SIC                 PRIMARY_SIC_TYPE               ADDITIONAL_SIC
99990001                       1987                                     12345678

Run
D&B Import Adapter (Request Set D&B Import Adapter)

After the program completes

SQL> select class_category, class_code from HZ_IMP_CLASSIFICS_INT;

CLASS_CATEGORY                  CLASS_CODE
------------------------------       ------------------------------
1987 SIC                               9999
1987 SIC                               1234

Only 4 digits imported into the interface table

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


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