Handling having multiple addresses
SummaryHow to report only one address (by type) in BI Reports?
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:
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.