Shared mailing addresses

Summary

Require a report to show employees that have the same mailing address

Content

Is it possible to generate a report that shows 2 employees residing at the same address?

I have generated a report that displays the mailing addresses for all of our employees but now the users would like one that just shows those addresses that have more than one employee at it

I am currently joining per_all_people_f, per_addresses_f and per_person_addr_usages

Are there any other tables that I could use that would give me the "duplicate" records

Thanks

Pam

 

Version

OBI 11.1.1.9