Shared mailing addresses — Cloud Customer Connect
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

Shared mailing addresses

edited Jun 23, 2020 6:39PM in Reporting and Analytics for HCM 8 comments

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
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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