How can I find the most recent hire date when using V3 seniority dates?

You can do so by configuring a non-cumulative rule at the person level for the enterprise attribute. For more information, see the document Seniority Dates V3 - Common Use Cases Configured Using V3 Seniority Dates (https://community.oracle.com/customerconnect/discussion/631036) on Customer Connect.