Customer Import - Load Interface File For Import Fails

(Doc ID 2308301.1)

Last updated on SEPTEMBER 17, 2017

Applies to:

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

Symptoms

When attempting to Upload Customers From Spreadsheet,
the following error occurs.

ERROR
-----------------------
........
value used for ROWS parameter changed from 64 to 11
Record 1191: Rejected - Error on table AR_UPD_CUSTOMERS, column ADDRESS_LINE_3.
second enclosure string not present
Record 1192: Rejected - Error on table AR_UPD_CUSTOMERS, column ORIG_SOURCE_SYSTEM_NAME.
second enclosure string not present
Record 1194: Rejected - Error on table AR_UPD_CUSTOMERS, column ADDRESS_LINE_2.
second enclosure string not present
Record 1195: Rejected - Error on table AR_UPD_CUSTOMERS, column ORIG_SOURCE_SYSTEM_NAME.
second enclosure string not present

Table AR_UPD_CUSTOMERS:
  1393 Rows successfully loaded.
  4 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
...........


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigator: Receivables -> Billing -> Upload Customers From Spreadsheet
1. Click on Download Customers Spreadsheet
2. Populate the data in to the desired sheets
3. Generate the .zip files by clicking on 'Generate CSV' button in Instructions sheet
4. In the application, click on Upload Customers From Spreadsheet button
5. Provide a Batch Name and select the .zip file
6. System will upload and process the data.
7. Verify the status of the Import
8. If the import fails, click on the count of Unprocessed records against the import batch
9. This will open the data showing the error which can be corrected and resubmitted for import.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the customer import.

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