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 create Data Model fetching Element Entries created for Individual Compensation Plans
Summary:
Need to create a SQL Data Model to fetch the Element Entries for those attached to a specific ICP.
Content (required):
Hi team,
I need to create a SQL based Data Model where i can join the ICP and the Element Entries created for the allocation made to employee.
ICP Plan IDs can be found in CMP_PLANS_VL and CMP_PLANS_B and Elements have theirs, but how do i connect so that i can have similar data to what we normally get in the ICP Subject Area.
May someone please share a sample query.
TIA
Version (include the version you are using, if applicable):
0