Import Customer Hierarchy Members Get Error : FND-HZ_HIER_IMPORT_NON_CUSTOMER A customer hierarchy node cannot have a party usage other than sales account, sales prospect, customer, legal entity, or external legal entity. (HZ-120695) (Doc ID 1567930.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Trading Community Model Cloud Service - Version 11.1.5.0.0 and later
Oracle Fusion Trading Community Model - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Symptoms

Following steps os How to create a Customer Hierarchy in file import [Doc ID 1481496.1]
Customer Hierarchy import task failed

1. Customer
2. Customer Hierarchy
3. Customer Hierarchy Member Import

 

In last import :

a) On Manage Import activities page click on create Icon(Create Import Activity:Set Up page is displayed)
b) Enter Name
 Select "Customer hierarchy Member" from Object drop down
 select upload from desktop radio button
  upload
 select Header Row Selected checkbox
 click on next button
c) Map the fields according to the attached file <CustomerHierarchyMemberMapping.xls > and click on next
d). Click on next and submit the job
e) Wait for the job to complete

 

 get error :

File Record Number,Import Job Id,System TaskId,Error Message
1,300000035231649,300000035223160,FND-HZ_HIER_IMPORT_NON_CUSTOMER (FND--1) Details: FND-HZ_HIER_IMPORT_NON_CUSTOMER Cause: The message, FND-HZ_HIER_IMPORT_NON_CUSTOMER, can not be accessed. Action: Report this problem to an administrator.
2,300000035231649,300000035223160,FND-HZ_HIER_IMPORT_NON_CUSTOMER (FND--1) Details: FND-HZ_HIER_IMPORT_NON_CUSTOMER Cause: The message, FND-HZ_HIER_IMPORT_NON_CUSTOMER, can not be accessed. Action: Report this problem to an administrator.
3,300000035231649,300000035223160,FND-HZ_HIER_IMPORT_NON_CUSTOMER (FND--1) Details: FND-HZ_HIER_IMPORT_NON_CUSTOMER Cause: The message, FND-HZ_HIER_IMPORT_NON_CUSTOMER, can not be accessed. Action: Report this problem to an administrator.

Error generated for the same import in R6 is different
File Record Number,Import Job Id,System TaskId,Error Message
File Record Number,Import Job Id,System TaskId,Error Message
1,300000000726844,300000000728279,A customer hierarchy node cannot have a party usage other than sales account, sales prospect, customer, legal entity, or external legal entity. (HZ-120695)
2,300000000726844,300000000728279,A customer hierarchy node cannot have a party usage other than sales account, sales prospect, customer, legal entity, or external legal entity. (HZ-120695)
3,300000000726844,300000000728279,A customer hierarchy node cannot have a party usage other than sales account, sales prospect, customer, legal entity, or external legal entity. (HZ-120695)

 

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