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?

in Reporting and Analytics for HCM 1 comment

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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