Customer Import Errors - Unable To Retrieve Error Message. Log A Service Request And Reference Eeror Code FND_CMN_RCRD_VAL
Last updated on OCTOBER 04, 2015
Applies to:Oracle Fusion Receivables Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On Oracle Fusion, 126.96.36.199.0 version, attempting to upload customers by spreadsheet, the upload batch ends with status: 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
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
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