Uploading Customers Using Spreadsheet Does Not Honor Special Characters While Address Comparsion

(Doc ID 2373342.1)

Last updated on MARCH 13, 2018

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms



Fusion Cloud - Uploading Customers using Spreadsheet Errors


We are trying to upload customers through Spreadsheet functionality and using Template for R10 though we are working in R12. The reason for this is due to bug in R11/12 which the Upload Customers From Spreadsheet does not support the Non-English characters. Refer Note -->Upload Customers From Spreadsheet For Non-English Characters (Doc ID 2084423.1)
Now As a workaround we are using R10 Template and have enabled Business Key Validation Enabled profile option to Y as we donot want any duplicate addresses.
Now in Template we are using Address line 1 as 1 Calsonic Way and 1 Calsonic Way, .But system is still throwing below error. We believe as these are two different addresses,system shouldnot throw any error.

ERROR
-----------------------
The specified Address either already exists in the upload batch or is associated to a different site in the registry.
You cannot upload duplicate Addresses if Business Key Validation is enabled.
Either change the Address for this record or set the Business Key Validation Enabled profile option to N in the Manage Administrator Profile Values setup to allow duplicate Addresses to be uploaded.

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