My Oracle Support Banner

Upload Customers From Spreadsheet: Customer Accounts Imported Despite Error Appear To Be Corrupt (Doc ID 2099575.1)

Last updated on DECEMBER 10, 2019

Applies to:

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

Symptoms

On : NA version, Other Issues

Upload Customers from Spreadsheet: Customer accounts imported despite error appear to be corrupt

The customer used the Upload Customers from Spreadsheet function to import some new customers (party, account, site) into Fusion Receivables. The Manage Customer Upload page shows that all records were unsuccesful. The CorrectCustomerData spreadsheet tells us that the reason for the unsuccesful import was that no valid Customer Profile Class was defined in our upload spreadsheet. That was indeed the case.
However, all customer records that appeared to have failed, *were* imported and are now visible in the Manage Customers Function. But when the customer use that function to review the customer account or the Profile History tab on the customer account, the following error is thrown:
This is true for all imported customers from this batch. It seems that the imported data is corrupt.

ERROR
-----------------------
ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #7


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Import customers using Rapid spreadsheet methodology without specifying profiles
2.Import ends showing that all records were unsuccesful.
3.Still all customers are imported but when navigating to profile history tab the error presented below is thrown:

ADF_FACES-60097:For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #7

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
Cause
Solution
References


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