Customer Attachment Import - Attachments Are Not Loaded In For Few Customers

(Doc ID 1638271.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Common CRM - Version 11.1.5.0.0 to 11.1.7.0.0 [Release 1.0]
Oracle Fusion Common CRM Cloud Service - Version 11.1.5.0.0 to 11.1.7.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On  11.1.7.0.0 version, File Import

ACTUAL BEHAVIOR
---------------
Performed import with attachments for 22 records, import worked for 4 records and not the rest

EXPECTED BEHAVIOR
-----------------------
Expect import to work for all the records

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to File Import > Object Customer
2. Select the attached .CSV file and choose the zip file and click on Upload > Once the attachment is uploaded to UCM server
3. Click on Next and choose the mapping.
4. Observe the first 5 rows of the customer with attachments are loaded in but the rest of the customers, none of the attachments are loaded.
5. The import job is completed successfully and there are no errors.
6. Looking at the Import status, being completed without error, I assumed all the attahcments were loaded in.
7. But I manually queried for the 23 Customers in the attached .csv and observed only the first 5 records the attachments have been loaded in.
8. We have 2906 attachments and it would be impossible to look for 5000 customers if the attachments have been loaaded in successfully.




BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot tell which attachments that got imported or not.


Other Information
--------------------------
Attachments types used:
1. .doc
2. ppt
3. pdf
4. xls
5. tif
6.htm
7.rtf
8. msg

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