Skip to Main Content

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

Comments
Post Details
Added on Sep 14 2019
2 comments
4,389 views