Skip to content
HR Service Delivery Advanced Integration with Oracle HCM › Integration of HR Service Delivery with third-party systems › HR Service Delivery › Employee Service Management
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Configure holiday calendars in HR Service Delivery Advanced Integration with Oracle HCM

Pull holiday calendars from the Oracle HCM system into a ServiceNow application. Display applicable holiday calendars to employees in the configured Service Portal.

Before you begin

Role required: sn_hr_oracle_adv.admin

Procedure

  1. Create the Holiday Calendar BI report in the Oracle HCM system.

    For more details, refer to this KB article.

  2. To run the View Holiday Calendar widget successfully, configure BI report and Connection & Credential Aliases in Oracle Cloud HCM Spoke.

    For more information, see set up Oracle HCM Cloud spoke.

  3. Navigate to Oracle Advanced Use Cases > Holiday Calendar.

  4. Click Get Holiday Calendars.

    All the records starting from current year until the next available calendar years are pulled from Oracle HCM system and stored in the Holiday Calendar [sn_hr_oracle_adv_holiday_calendar] table.

What to do next

An employee can add the View Holiday Calendar widget to any ServiceNow page. An employee will not be able to view this widget if the Person ID (Correlation_ID) is missing in the HR profile [sn_hr_core_profile] table.