Human Capital Management - EBS (MOSC)

MOSC Banner

How to get the latest employee record from per_people_f?

We get the latest employee validity information using this table and join the employee_number from this table to other tables to get the required data. However, for few records, we have person_id, as well as the object_version_number same. How to find the active and valid record from this data that can be used in any sql?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center