My Oracle Support Banner

Customer Import fails with an error after the update to Release 20A. (Doc ID 2641294.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version N/A and later
Oracle Fusion Receivables Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : 11.13.20.01.0 version, Customer Import

Customer Import fails with an error after the update to Release 20A.

ERROR
-----------------------
Inside invokeESS oracle/apps/ess/cdm/foundation/bulkImport SQLDataImportJob
Status: = ERROR
Batch 999999999999999 resulted in ERROR
Error = Batch 999999999999999 resulted in ERROR
Error : oracle.as.scheduler.ExecutionErrorException: Batch 999999999999999 resulted in ERROR

Changes

Navigate to Setup and Maintenance > Manage Administrator Profile Values
Profile Option Code: ORA_HZ_ENABLE_IMPORT_PLSQL_MODE
Profile Display Name: New Back End Code for Better Performance Enabled
Description: Enables new back end code for better performance to match, validate, and load data in the target tables when value is 'Y'. When the value is 'N', it will call older code.

Starting with Release 20A this profile option is set to Yes by default.

 

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.