Technology Stack - EBS (MOSC)

MOSC Banner

Duplicates in fnd_flex_value_hierarchies table on 12.1.3

edited May 22, 2015 5:45AM in Technology Stack - EBS (MOSC) Question

Customer cannot remove duplicates from fnd_flex_value_hierarchies table even after following Doc ID 748971.1.

There are two rows in fndl_flex_value_hierarchies table for the same parent_flex_value.

These rows have a creation_date and last_update_date of 19-APR-15 (when the sql script from the note was run).

Where as, there is only one row in FND_FLEX_VALUE_NORM_HIERARCHY table with different CREATION_DATE and LAST_UPDATE_DATE.

There are no new hierarchy changes for the parent on 19-APR-15 in this table.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center