What's new in Customer Journeys?

Connect and learn more!
PL/SQL - Absences in UoM: Weeks to be Displayed in Days? — 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

PL/SQL - Absences in UoM: Weeks to be Displayed in Days?

Received Response

Hi all,

Hope you are well.

We have certain absence types such as Maternity, which have the UoM: Weeks.

We have a requirement for reporting purposes to display this as Days on a line by line basis.

Currently in our PL/SQL reports, we have absences displayed as per the below:

And I would ideally like this to display like the below:

Maternity 18-Feb-2022

Maternity 21-Feb-2022

Maternity 22-Feb-2022

All the way up to the End Date of 17-Jan-2023.

I notice the table: anc_per_abs_daily_dtls but I am unsure if this can handle absences where the UoM is not in Days?

Howdy, Stranger!

Log In

To view full details, sign in.


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