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.
Termed employee report with both Manager hierarchy AND final salary
Summary:
Has anyone written an OTBI report to pull termed employees and include both Manager hierarchy AND also final salary?
Content (required):
Has anyone written an OTBI report to pull termed employees and include both Manager hierarchy AND final salary?
I have seen many samples here for termed employee reports but they all talk about either Manager hierarchy OR final salary; but not both. I need to include both in the report along with many employee demographic info.
I tried to write a lSQL with Worker Assignment Event Real Time, Salary History and Worker Assignment Real Time SAs but the join and group by doesn't seem to be working.
Tagged:
3