You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Update Reference Accounts Using Upload Customers from Spreadsheet Simplified Template

in Receivables & Collections 1 comment

Summary:

I'm trying to update customer reference accounts using the "Upload Customers from Spreadsheet" Simplified Template but keep running into ""The error message and token information couldn't be retrieved. Log a service request and reference error code HZ_IMP_INVALID_PARENT_ID and token values PARENT_TABLEID_COLUMNnullnullnull." error.

After going to Billing>Manage Data Import> Select your batch name> Click on report the issue seems to be related to Party and Party Site.

Does anyone have a sql query to help populate the template for this scenario correctly?

We also have noticed that hz_cust_site_uses_all.orig_system_reference is null, but we have updated hz_orig_sys_references.orig_system_reference via API's. It's unclear if this could be causing the failure and what the fix would be.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!