Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Handling having multiple 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

Handling having multiple addresses

Accepted answer
edited Oct 31, 2017 10:51AM in Applications Security 1 comment


How 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.


Howdy, Stranger!

Log In

To view full details, sign in.


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