Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Holiday Calendar Extraction

Gunjan BobadeSep 14 2019 — edited Sep 16 2019

Hello Community,

Greetings!!

I have requirement to get Holiday Calendar for particular regions (location). I got the the Holiday Name and Holiday Type from PER_CALENDAR_EVENTS_VL View but I cannot find a link to join this to Location.

Please provide a SQL Query join and table name to connect PER_CALENDAR_EVENTS_VL. FYI, I just want to get Holiday Days. I am currently working on Oracle Fusion Cloud 19C Version.

Thanks in advance!!

Thanks & Regards,

Gunjan

Added on Sep 14 2019

#cloud-applications, #hcm-cloud-service

2 comments

6,065 views