Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Query/SQL for datamodel in BI Publisher of Other Addresses in Location Page
Summary:
Hi,
Do you know via datamodel/BI Publisher in what table other addresses for locations are stored?
We do not find them either in: HR_LOCATIONS_ALL_F_VL or per_location_details_f_tl or per_location_details_f or HR_LOCATIONS.
We did find we could do a join with PER_LOC_ADDRESS_USAGES_F & PER_ADDRESSES_F
But we were wondering if there was already a view that showed both main address & other type address linked to one locaiton.
Thank you for your help.
Kind regards,
Pilar
Version (include the version you are using, if applicable):
Tagged:
0