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.
2019 Leavers with salary
Summary
OTBI report needed showing 2019 leavers & salariesContent
Hi,
I have been looking through the shared reports centre and previous posts and haven't really found a suitable
solution to my requirement which is a standard report showing leavers from 2019 and their last salary.
I have so far used "Compensation - Salary History Details Real Time" (see attached XML) but that brings back multiple lines for employees even though I've filtered on 'Inactive' Assignment Type.
Can anyone help on this please?
Many thanks,
Andrew
Version
19DCode Snippet
<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Compensation - Salary History Details Real Time"">
<saw:columns>
<saw:column xsi:type="saw:regularColumn" columnID="c45149a67ffd53e19">
<saw:columnFormula>
<sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Person Number"</sawx:expr></saw:columnFormula></saw:column>
<saw:column xsi:type="saw:regularColumn" columnID="c5171db2cf12648bc">
<saw:columnFormula>
0