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.
Table to join Activity and resources
Summary
Link between activity(WLF_LI_ACTIVITIES_F) and resources(WLF_RESOURCES_B) tableContent
We have defined an activity and attached resources(Room no, location) under the activity. Now I am unable to link the 2 tables which holds the data from activity(WLF_LI_ACTIVITIES_F) and resources(WLF_RESOURCES_B).
I know the bookings table(WLF_LI_BOOKINGS) but this sometimes doesnt have the complete data and more importantly it is only populated in case any employee is assigned to the offering/activity. Since the activity is always tagged to the resources irrespective of any bookings done, I need a connection between the activity and resource even if there are no bookings done.
Tagged:
0