Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Absence Leave Amount & Payroll Element Name — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Absence Leave Amount & Payroll Element Name

edited Feb 10, 2017 12:25PM in General Transactional Reporting (OTBI) 3 comments


Good Day,

We have been tasked to create a report where anyone who has booked less than a full days leave is highlighted.   This in its self is very easy and achievable.
But there is a second requirement, the requesting team then want this/these people to only be highlighted if they have a Recurring Element in the "Payroll" - "Element Name" field.


We have tried various different computations and realignments, also going onto Advanced Tab and then to apply sql after the relevant marker has been ticked.   And still no joy.   There are a minimum of 6 subfolders that match the SA's together as well.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!