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

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • 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.