Oracle 11g-Parcel deleted but still appearing in Geoprocessing results

[Thumo]

@MarceloMarques and community,

I have deleted a parcel from geodatabase, but when i ran my custom geoprocessing tool this parcel is been picked up as if it there, even from history is not available it gone, i have reconciled and posted the job also. I am using oracle 11g with Arcmap 10.8.1 what could be problem. Am asking if there is any method besides compressing geodatabse to make sure that this cache is deleted.

[VaibhavS]

You could check if there are any orphan feature classes in the geodatabase.

GDB_Items
SDE_TABLE_REGISTRY
SDE_COLUMN_REGISTRY
SDE_LAYERS
SDE_GEOMETRY_COLUMNS
GDB_ITEMRELATIONSHIPS (if the feature class existed in a feature dataset)

[MarceloMarques · Accepted solution]

@Thumo, if you are working with geodatabase versioning then make sure you reconciled and posted the correct child version that you made the edits to the sde.default version. You can also use a connection file that points to a version where you made edits and use that connection file in geoprocessing tools.