My Oracle Support Banner

Customer Import Ends With Errors HZ_DE_INVALID_DATERANGE. HZ_IMP_INVALID_PARENT_ID And PARENT_TABLEID_COLUMN (Doc ID 2052100.1)

Last updated on AUGUST 24, 2020

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 create customers by spreadsheet, the upload batch ends with status:



ERROR
-----------------------
1.Unable to retrieve error message and token information. Log a service request and reference error code HZ_IMP_INVALID_PARENT_ID and token values PARENT_TABLEID_COLUMNnullnullnull.
2.Unable to retrieve error message. Log a service request and reference error code HZ_DE_INVALID_DATERANGE.
3.Unable to retrieve error message. Log a service request and reference error code HZ_DE_INVALID_DATERANGE.



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

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


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