How to Delete Records from HIERARCHY MEMBER object (FND_TREE_NODE).
We are planning to delete records from FND_TREE_NODE table where FND_TREE_NODE.TREE_VERSION_ID is not within effective date ranges in FND_TREE_VERSION TABLE (i.e. FND_TREE_NODE.TREE_VERSION_ID = FND_TREE_VERSION.TREE_VERSION_ID AND TRUNC(SYSDATE) NOT BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE).
Our objective is to delete one of the duplicate records w.r.t. (TREE_STRUCTURE_CODE, TREE_CODE, PK1_START_VALUE, PARENT_PK1_VALUE)
When we try to delete one of the rows, we could not find the primary key to delete exactly one record as the available columns in Import Management are