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 remove duplicates in geography hierarchy ?

KS is created twice not sure why Oracle allowed it in the first place. There is not much of difference in the backend also.

This geography has already been created and now it is associated with many employees' home address as well.

So we are also not sure which one to delete, as it may cause a data issue.

select * from hz_geographies where code ='KS'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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