High Vol Import Doesnt Work For REST API (Doc ID 2780455.1)

Last updated on MAY 13, 2022

Applies to:

Symptoms

On : 11.13.21.01.0 version, Accounts, Contacts

High Vol Import Doesnt Work for REST API

Calling https://xxx.oraclecloud.com/crmRestApi/resources/latest/importActivities

to submit Contact import high volume fails with error below

ERROR, "Some system error occurred. Please contact administrator helpdesk. ",FileImportAMImpl.java.generateSQLLDRCtlDataFile(3718), FileImportJobGenCtlDataProcess
ERROR, "Exception details - generateSQLLDRCtlDataFile: java.lang.Exception: Corresponding Attributes are not mapped for High volume:WORK_STATE,TELEWORK_ZIP,WORK_ZIP,BUSINESS_UNIT_DESCRIPTION,WORK_STREET_ADDR_2,WORK_CITY,PREF_STREET_ADDR_1,WORK_STREET_ADDR_1,MGT_LEVEL_INDICATOR,SUPERVISOR_ATTUID,PREF_STREET_ADDR_2,BUSINESS_UNIT_ID,PREF_ZIP,TELEWORK_CITY,EMP_CLASSIFICATION,PREF_COUNTRY,PREF_STATE,TELEWORK_STATE,PREF_CITY,TELEWORK_COUNTRY,TELEWORK_STREET_ADDR_1,EMP_STATUS_CODE,TELEWORK_STREET_ADDR_2,OCCUPANCY_STATUS,WORK_COUNTRY,CONSULTANT,
at FileImportCommonUtil.java:initializeMetadataForRestImport:6194
FileImportAMImpl.java:generateSQLLDRCtlDataFile:3673
NativeMethodAccessorImpl.java:invoke0:-2
",FileImportAMImpl.java.generateSQLLDRCtlDataFile(3720), FileImportJobGenCtlDataProcess
INFO, "Exiting generateSQLLDRCtlDataFile method. ",FileImportJobGenCtlDataProcess, FileImportJobGenCtlDataProcess
INFO, "Deleting Shared Files from File System",FileImportJobGenCtlDataProcess, FileImportJobGenCtlDataProcess
ERROR, "Batch : 300000002429457:Error in SQLLDR Data/Ctl Generation with Exception : java.lang.Exception: Corresponding Attributes are not mapped for High volume:WORK_STATE,TELEWORK_ZIP,WORK_ZIP,BUSINESS_UNIT_DESCRIPTION,WORK_STREET_ADDR_2,WORK_CITY,PREF_STREET_ADDR_1,WORK_STREET_ADDR_1,MGT_LEVEL_INDICATOR,SUPERVISOR_ATTUID,PREF_STREET_ADDR_2,BUSINESS_UNIT_ID,PREF_ZIP,TELEWORK_CITY,EMP_CLASSIFICATION,PREF_COUNTRY,PREF_STATE,TELEWORK_STATE,PREF_CITY,TELEWORK_COUNTRY,TELEWORK_STREET_ADDR_1,EMP_STATUS_CODE,TELEWORK_STREET_ADDR_2,OCCUPANCY_STATUS,WORK_COUNTRY,CONSULTANT,",FileImportAMImpl.java.generateSQLLDRCtlDataFile(3763),
ERROR, "30000000242945

ERROR
-----------------------

ERROR, "Some system error occurred. Please contact administrator helpdesk. ",FileImportAMImpl.java.generateSQLLDRCtlDataFile(3718), FileImportJobGenCtlDataProcess
ERROR, "Exception details - generateSQLLDRCtlDataFile: java.lang.Exception: Corresponding Attributes are not mapped for High volume:WORK_STATE,TELEWORK_ZIP,WORK_ZIP,BUSINESS_UNIT_DESCRIPTION,WORK_STREET_ADDR_2,WORK_CITY,PREF_STREET_ADDR_1,WORK_STREET_ADDR_1,MGT_LEVEL_INDICATOR,SUPERVISOR_ATTUID,PREF_STREET_ADDR_2,BUSINESS_UNIT_ID,PREF_ZIP,TELEWORK_CITY,EMP_CLASSIFICATION,PREF_COUNTRY,PREF_STATE,TELEWORK_STATE,PREF_CITY,TELEWORK_COUNTRY,TELEWORK_STREET_ADDR_1,EMP_STATUS_CODE,TELEWORK_STREET_ADDR_2,OCCUPANCY_STATUS,WORK_COUNTRY,CONSULTANT,
at FileImportCommonUtil.java:initializeMetadataForRestImport:6194
FileImportAMImpl.java:generateSQLLDRCtlDataFile:3673
NativeMethodAccessorImpl.java:invoke0:-2
",FileImportAMImpl.java.generateSQLLDRCtlDataFile(3720), FileImportJobGenCtlDataProcess
INFO, "Exiting generateSQLLDRCtlDataFile method. ",FileImportJobGenCtlDataProcess, FileImportJobGenCtlDataProcess
INFO, "Deleting Shared Files from File System",FileImportJobGenCtlDataProcess, FileImportJobGenCtlDataProcess
ERROR, "Batch : 300000002429457:Error in SQLLDR Data/Ctl Generation with Exception : java.lang.Exception: Corresponding Attributes are not mapped for High volume:WORK_STATE,TELEWORK_ZIP,WORK_ZIP,BUSINESS_UNIT_DESCRIPTION,WORK_STREET_ADDR_2,WORK_CITY,PREF_STREET_ADDR_1,WORK_STREET_ADDR_1,MGT_LEVEL_INDICATOR,SUPERVISOR_ATTUID,PREF_STREET_ADDR_2,BUSINESS_UNIT_ID,PREF_ZIP,TELEWORK_CITY,EMP_CLASSIFICATION,PREF_COUNTRY,PREF_STATE,TELEWORK_STATE,PREF_CITY,TELEWORK_COUNTRY,TELEWORK_STREET_ADDR_1,EMP_STATUS_CODE,TELEWORK_STREET_ADDR_2,OCCUPANCY_STATUS,WORK_COUNTRY,CONSULTANT,",FileImportAMImpl.java.generateSQLLDRCtlDataFile(3763),
ERROR, "30000000242945




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Call import with REST API
2. IMport process is submitted
3. process failed with error

BUSINESS IMPACT
-----------------------
Import should work as expected

Cause

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