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

How to Delete Records from HIERARCHY MEMBER object (FND_TREE_NODE).

in Sales 5 comments

Summary:

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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