Human Resources and ELM - PSFT (MOSC)

MOSC Banner

Group Build Job effective date

edited Mar 30, 2022 1:22PM in Human Resources and ELM - PSFT (MOSC) 1 commentAnswered ✓

We're trying to configure group build to find all employees in a particular union as of a certain effective date. For examples all employees in union 28 as of 04-25-2020 and we want the group to return the maximum effective dated row less than or equal to 4/25/2020 for the employee.  The issue we're running into is the the group build process is adding in it's own effective date criteria which says and job.effdt<=sysdate. So if the employee has a future dated row they're knocked out of the group. Any idea how to turn this "Bonus feature" off?

Here's the SQL group build is creating:

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