DELETE Customer Hierarchy Member Using File Import
(Doc ID 2043529.1)
Last updated on DECEMBER 22, 2020
Applies to:Oracle Fusion Sales Cloud Service - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
When trying to DELETE the customer hierarchy members using the file import feature. Getting errors:
"The value in the column TREE_CODE is invalid. You must enter a valid TREE_CODE from table FND_TREE_VERSION/HZ_IMP_HIERARCHIES_T. (HZ-120736) You cannot delete this record because it does not exist in the registry. Enter a reference to an existing record or a suitable ACTION_CODE. (HZ-120710) You cannot complete the import process because there is an import action mismatch between interface table columns and import process definition. (HZ-120252) Cause: The value in the INSERT_UPDATE_FLAG column of the interface table conflicts with the action determined by the import process. Action: Update the values and try again."
See the following error in logs.
HZ_IMP_INVAL_VALUE_COMPARE ATTRIBUTE1 TREE_CODE ATTRIBUTE2 TREE_CODE ATTRIBUTE 3 FND_TREE_VERSION/HZ_IMP_HIERARCHIES_T
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