Customer Import Errors - Unable To Retrieve Error Message. Log A Service Request And Reference Eeror Code FND_CMN_RCRD_VAL (Doc ID 2040257.1)

Last updated on OCTOBER 04, 2015

Applies to:

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

Symptoms

On Oracle Fusion, 11.1.9.2.0 version, attempting to upload customers by spreadsheet, the upload batch ends with status: Error

ERROR
-----------------------
Upload failed due to errors in the record
The error column in the correction spreadsheet says "1. Unable to retrieve error message. Log a service request and reference error code FND_CMN_RCRD_VAL."

The error  FND_CMN_RCRD_VAL is a generic error related to an incorrect value. As there is not detail about the error, the table hz_imp_errors provides the specific error.
In this case: Reviewing hz_imp_errors the error for the record is: S4 - payment method name provided is not valid

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On Navigator
2. Go to Billing > Customers
3. Click on Upload Customers from Spreadsheet
4. Reviewed the Import results and observed the error described appears


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