Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Help Needed: Retrieving Current Address for a Legal Entity
Hi Everyone,
I'm trying to retrieve the current address for a Legal Entity, but I'm facing challenges in identifying the correct tables and joins.
Context:
I understand that the Manage Legal Entities page in Oracle HCM displays the first effective address by default, and the current address can only be viewed through View > All in the history. However, I'm not sure how to fetch the most recent (current) address directly from the backend.
Could anyone please help me with:
1. The right tables or views that store the current address for a Legal Entity.
2. The appropriate join conditions to ensure I fetch the most recent address instead of the first effective record.
0