Finding Most Recent Row FDI Detail Report

Question

Apologies in advance, new Oracle/FDI user…

Using workforce core, I'm building a supplemental Active with Salary detail report. The issue I'm running into is once I bring in the salary field the dataset returns all of the compensation history which then causes multiple rows per employee.

My question is whether or not there is a way to filter on the person's most recent row?

Raghavendra Raghunath-Oracle · Answer

Hi @User_LW96B Please use an expression filter criteria like below

"HCM - Workforce Rewards - Salary Basis"."Worker Salary Basis Details"."Salary Change Start Date" = (MAX("HCM - Workforce Rewards - Salary Basis"."Worker Salary Basis Details"."Salary Change Start Date" by "HCM - Workforce Rewards - Salary Basis"."Basic Information"."Person Number"))

Orange · Answer

Hi, perhaps the RANK function can be leveraged,

https://www.oracletutorial.com/oracle-analytic-functions/oracle-rank/

Jamie Anderson-Oracle · Answer

Mike, It looks like you're trying to just show the latest salary for an employee using Workforce Core. 
@Raghavendra Raghunath-Oracle , @Nupur Joshi-Oracle , @Gunvansh Khanna-Oracle - do we have this capability? I imagine a time filter would not satisfy the requirement if Mike is trying to pull the latest salary, and that timeframe can vary depending on when a salary is updated.