There are 1296271345 records in FND_FLEX_VALUE_HIERARCHIES. when ever the request "Compile Value Set Hierarchies" run, it throw records in this table with negative sign.
Few weeks back requests got stuck and number of zombie sessions were available in v$session table and system was not allowing the users to login in application. so we cancelled the requests and wipe the zombie sessions and bounce the application services after increasing number of sessions. After that system started to generate records with negative value set ID. and now whenever user run this request or change the particular value set then "Compile Value Set Hierarchies" throw records regardless of the existence of the records.
Need your help in this regard.