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