Handling having multiple addresses

Summary

How to report only one address (by type) in BI Reports?

Content

Hello!

 

We are facing an annoying issue in Oracle Fusion HCM.
An employee is allowed to enter multiple permanent/secondary addresses to the System through Self-Service.
As a result more than one permanent/secondary addresses can be effective at once.
If we want to avoid duplication then we need to end-date the older address.

Currently we are using the following view for getting the address information of the employees:
PER_PERSON_ADDRESSES_V

By using this view we cannot select only one address per type.
The only way I can imagine is using a analytic function that would rank each addresses using a custom condition (like ordering by effective date). If we choose this approach then we need to adjust all of our reports.